Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
ERR_TOO_MANY_REDIRECTS Question Question
How to prevent bad caching on Users Browsers with Virtual Hosts on NGINX Question Question

Question

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

Posted June 2, 2018 6.2k views
NginxUbuntu 16.04

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

Thank you.

Add a comment
NewCustomer
By:
NewCustomer

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
ERR_TOO_MANY_REDIRECTS Question Question
How to prevent bad caching on Users Browsers with Virtual Hosts on NGINX Question Question

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

Related

Looking for something else?

Ask a new question Search for more help