This site is hosted and sponsored by hyve.com specialists in Cloud Hosting UK and VMware Hosting. If you are interested in our services please call us for chat on 0800 612 2524

Enable MYSQL Slow Query Log#

• Edit /etc/my.cnf

• Add the following:

#Slow Query Log
#Log file
log-slow-queries = /var/log/slow-queries-log          

#Logs queries longer than 2 sec 
long_query_time = 2                                           

#Logs queries not using indexes
log-queries-not-using-indexes TRUE

• Change owner on log file /var/log/slow-queries-log to

chown mysql.mysql

• restart mysql

/etc/init.d/mysql restart

Back to mySQL