How To enable Mysql Query Cache

How To enable Mysql Query Cache

Query caching is a way to increase the mysql performance by caching database queries.

How To enable Mysql Query Cache


To enable it edit its configuration file. The configuration file of mysql is /etc/my.cnf

Add the following lines in the mysqld section

query_cache_limit = 16M
query_cache_size = 256M
query_cache_type = 1

restart the mysql daemon

# /etc/init.d/mysql restart

To verify the cache is enabled or now follow the below procedure

# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 36074287
Server version: 5.0.92-community-log MySQL Community Edition (GPL)

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

mysql> SHOW VARIABLES LIKE ‘%query_cache%';

Variable_name Value
have_query_cache YES
query_cache_limit 16777216
query_cache_min_res_unit 4096
query_cache_size 268435456
query_cache_type ON
query_cache_wlock_invalidate OFF

6 rows in set (0.00 sec)


Leave a Reply

Your email address will not be published. Required fields are marked *