Related

NGINX Config Generator

Easily configure a performant, secure, and stable NGINX server.

Learn More

ERR_TOO_MANY_REDIRECTS

How to prevent bad caching on Users Browsers with Virtual Hosts on NGINX

Question

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

Posted June 2, 2018 5.6k

Nginx Ubuntu 16.04

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

Thank you.

By:

NewCustomer

Related

NGINX Config Generator

Easily configure a performant, secure, and stable NGINX server.

Learn More

ERR_TOO_MANY_REDIRECTS

How to prevent bad caching on Users Browsers with Virtual Hosts on NGINX

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.

×

Submit an Answer

1 answer

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

Reply Report

Looking for something else?

Ask a new question Search for more help