Correct Syntax (slow_query_log)

fdnven

• September 03, 2013 13:27

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

  • September 03, 2013 19:01

  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.

  0

Please sign in to leave a comment.