Question

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

Posted June 2, 2018 3.8k views
NginxUbuntu 16.04

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

Thank you.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
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.

Submit an Answer