User Tools

Site Tools


mysql_caching

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
mysql_caching [2015/04/08 10:36] luke7858mysql_caching [2024/05/23 07:26] (current) – external edit 127.0.0.1
Line 49: Line 49:
 </sxh> </sxh>
  
-An example of editing the **/etc/my.cnf** file is: 
-<sxh bash> 
-query_cache_size = 268435456 
-query_cache_type=1 
-query_cache_limit=1048576 
-</sxh> 
 \\ \\
 ---------------------------------------------------------- ----------------------------------------------------------
Line 66: Line 60:
 <sxh bash> <sxh bash>
 set global query_cache_limit = 1010101; set global query_cache_limit = 1010101;
 +</sxh>
 +\\
 +=== Setting the variables to be permanent: ===
 +
 +An example of editing the **/etc/my.cnf** file is:
 +<sxh bash>
 +query_cache_size = 268435456
 +query_cache_type=1
 +query_cache_limit=1048576
 </sxh> </sxh>
  
mysql_caching.1428489418.txt.gz · Last modified: 2024/05/23 07:26 (external edit)

Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
Public Domain Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki