Wednesday, February 13, 2013

Enable slow query log in Mysql


set global slow_query_log = 'ON';
 show variables like '%slow%';
set global log_queries_not_using_indexes = 'ON'
set global slow_query_log_file ='/var/log/mysql/slow-query.log';
set global long_query_time = '20';  

No comments :

Post a Comment