my.ini setting not working
Posted: 23. September 2011 00:09
Hi
My website's MySQL setting under xampp/mysql/bin/my.ini file in the section of [mysqld] don't take effect. I am using XAMPP 1.7.1 Window version with mysql 5.1.33 installed as a service.
I added these variables:
slow_query_log = 1
slow_query_log_file = "C:/xampp/mysql/data/mysql-slow.log"
query_cache_size=64M
I stop and restarted MySQL (installed as a service).
And, I query MySQL using these comments:
show variables like 'query_cache%';
But, the results still shows:
Variable_name Value
query_cache_size 0
Also, there is no mysql-slow.log file created in C:xampp/mysql/data/
Anyone konws why my setting not working?
Thanks for your help.
My website's MySQL setting under xampp/mysql/bin/my.ini file in the section of [mysqld] don't take effect. I am using XAMPP 1.7.1 Window version with mysql 5.1.33 installed as a service.
I added these variables:
slow_query_log = 1
slow_query_log_file = "C:/xampp/mysql/data/mysql-slow.log"
query_cache_size=64M
I stop and restarted MySQL (installed as a service).
And, I query MySQL using these comments:
show variables like 'query_cache%';
But, the results still shows:
Variable_name Value
query_cache_size 0
Also, there is no mysql-slow.log file created in C:xampp/mysql/data/
Anyone konws why my setting not working?
Thanks for your help.