Share

Question

How do I enable slow query log for MYSQL? currently it seem to be disabled.

Thank you.

Answer 1

miroslavmimokuhajda June 6, 2018

There is wrong definition in my.cnf config. Try to add:

slow_query_log = 1
slow_query_log_file = /var/log/mysql/mysql-slow.log
long_query_time = 1
log_queries_not_using_indexes

And restart MySQL.

Reply Report

How to enable slow query log for MYSQl in Ubuntu 16.04 ,Nginx