Correct Syntax (slow_query_log)

[fdnven]

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?

slow_query_log

Thanks
Frank

 

[cPanelMichael]

Hello

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

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.