Differences

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

--- mysql_caching [2015/04/08 09:28] – luke7858
+++ mysql_caching [2024/05/23 07:26] (current) – external edit 127.0.0.1
@@ Line 4: / Line 4: @@
 When logged into mysql you can use the following command to view query cache size (note: 0 means that no caching has been enabled)
 <sxh bash>
-SHOW VARIABLES LIKE 'query_cache_size';
+show VARIABLES LIKE 'query_cache_size';
 </sxh>
 \\
@@ Line 49: / Line 49: @@
 </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 61: / Line 55: @@
 The command below is an example of setting the global caching of mysql to 16MB.
 <sxh bash>
-SET GLOBAL query_cache_size = 16777216;
+set GLOBAL query_cache_size = 16777216;
 </sxh>
 <sxh bash>
+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>