How to enable the slow query log, Hostripples Web Hosting

How to enable the slow query log

To enable slow query log in cpanel server, you can use following steps. Its pretty simple.

Add following to following to /etc/my.cnf file on server.

# vi /etc/my.cnf

log-slow-queries=/var/lib/mysql/slow.log

After that,  do the following commands to create the file with the right ownership and file permissions:

# touch /var/lib/mysql/slow.log
# chmod 660 /var/lib/mysql/slow.log
# chown mysql:mysql /var/lib/mysql/slow.log

Restart the mysql server and check the logs in /var/lib/mysql/slow.log.