Enable MySQL Slow Query Log


Query
Enable MySQL Slow Query Log

Edit Configure File /etc/my.cnf & Add Following Lines
#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 Permissions
chown mysql.mysql

Re-Start MySQL Service
service mysql restart
(or)
service mysqld restart

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s