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

Posted June 2, 2018
Nginx Ubuntu 16.04

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

Thank you.

Submit an answer

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

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.

Miroslav Kuhajda • 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.

NGINX Config GeneratorTool

after installing iRedMail my nginx 404 error

Question

SSL Security (HTTPS) in Django one-click-install configuration

Question

NGINX Config GeneratorTool

Related

Question

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

Related