How to enable mysql query cache
Please note that i am enabling the mysql query caching limit to 20MB. I have converted the 20MB to 20971520KB
Login to the server via SSH.
Type “mysql” command
It will show the below output.
root@server [~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 99955 Server version: 5.1.62-cll MySQL Community Server (GPL)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
Then fire the below command in mysql
mysql> SHOW VARIABLES LIKE ‘query_cache_size’;
Then fire the below command to set the mysql query cache.
mysql> SET GLOBAL query_cache_size =20971520;
Then check the cache value again.
mysql> SHOW VARIABLES LIKE ‘query_cache_size’;
Then exit the mysql be pressing Ctrl+D
Open my.cnf file and insert the below line vi /etc/my.cnf
query_cache_size = 268435456
query_cache_type=1
query_cache_limit=1048576
save the file and restart mysql