Enable slow query log for cpanel whm mysql 5.5 2
*** Note the comments below, this is for MySQL 5.5. MySQL 5.6 uses slow_query_log ***
To enable the slow query log for your whm / cpanel server, do the following:
open /etc/my.cnf with your favorite editor and add the following lines under the [mysqld] section:
log-slow-queries=/var/lib/mysql/slow_queries.log
long_query_time = 3
log_queries_not_using_indexes
The log_queries_not_using_indexes option will also write any queries to the file that are not using indexes. They may take less than your long_query_time threshold, but is good for finding easy targets for indexes and performance gains.
Then create the log file and set the proper permissions:
touch /var/lib/mysql/slow_queries.log
chmod 660 /var/lib/mysql/slow_queries.log
chown mysql:mysql /var/lib/mysql/slow_queries.log
Then restart mysql:
service mysql restart
If you want to view the contents of the file in real time, go to the mysql directory – /var/lib/mysql/ and then run:
tail -f slow_queries.log
Monitor the queries being written to the file and make adjustments as necessary.