How to enable slow query log for MYSQl in Ubuntu 16.04 ,Nginx
How do I enable slow query log for MYSQL? currently it seem to be disabled.
Thank you.
Log In to Comment
1 Answer
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.
Have another answer? Share your knowledge.