fdnven

Well-Known Member
Feb 14, 2006
120
1
168
Hi,

what is the correct syntax to enable mysql slow query log. MYSQL is set to most current version for WHM 11.38.
Is the below correct?
Code:
slow_query_log
Thanks
Frank
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
Hello :)

You can utilize the following entries in your /etc/my.cnf file:

Code:
slow-query-log=1
slow-query-log-file="/var/log/mysql-slow-queries.log"
Ensure you create the "/var/log/mysql-slow-queries.log" file and it's owned by the "mysql" user.

Thank you.