Saturday 20 May 2017

Enable slow-query-log in MySQL ?

You can enable slow-log by un-commenting following lines in /etc/mysql/my.cnf
slow-query-log = 1
slow-query-log-file = /var/log/mysql/mysql-slow.log
long_query_time = 1
log-queries-not-using-indexes

No comments:

Post a Comment

Advertisement

Advertisement