How to enable slow query log in a cPanel/WHM Linux server

To enable slow query log in cpanel server, you can use following steps. 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 […]

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 […]