user3312792 user3312792 - 1 year ago 117
SQL Question

How do I turn on query_cache on a Windows XAMPP Server?

In xampp/mysql/bin/my.ini

Do I add?

query_cache_size = 16777216
query_cache_type = 1
query_cache_limit = 1048576

I have tried the above and restarted mysql server but when I run this query:

SHOW VARIABLES LIKE '%query_cache%'

It says

query_cache_type is OFF

Answer Source

First try in mysql command prompt by setting it globbally and check whether its working or not, If its working it means you are updating in wrong my.ini

mysql> SET GLOBAL query_cache_size = 41984;
mysql> SET GLOBAL query_cache_type = 1;
mysql> SET GLOBAL query_cache_limit = 1048576;

mysql> SHOW VARIABLES LIKE 'query_cache_size';

check with below command

mysql> SHOW VARIABLES LIKE 'have_query_cache';
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download