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

June 2, 2018 95 views
Nginx Ubuntu 16.04

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

Thank you.

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.