How to enable Slow Query Log
Append into /etc/my.cnf the following:
slow_query_log = 1 slow-query_log_file = /var/log/mysql-slow.log long_query_time = 2
Create /var/log/mysql-slow.log log file and set it as mysql user:
touch /var/log/mysql-slow.log chown mysql:mysql /var/log/mysql-slow.log
Restart MySQL server:
/scripts/restartsrv_mysql
Monitor the logs using tail command:
tail -f /var/log/mysql-slow.log… Read the rest