Enable Logging of Slow Queries

vim /etc/my.cnf

log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 1

Leave a Reply

Your email address will not be published. Required fields are marked *