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

June 2, 2018 3.1k 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

And restart MySQL.

Have another answer? Share your knowledge.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!