Slow Queries log with MySql and cPanel
I have included the following lines:
log-slow-queries = /var/lib/mysql/mysqld.slow.log
long_query_time=5
The log file (with header row) was created when I restarted mysql. However, I can see in TOP that some mysqld processes are running for more then 5 seconds (sometimes minutes) and no information is written to the log file. Am I doing something wrong? Is there a better way to log slow queries?
Thank you.
