How to enable the slow query log and identify slow queries with PerconaDB
Edit your /etc/mysql/my.cnf file – the default file comes with a bug for setting up this slow query log, but find the line which starts log_slow_queries (it’ll be commented out probably). Don’t uncomment it, instead use something like these values: slow-query-log = 1slow-query-log-file = /var/log/mysql/slow.loglong_query_time = 1log-queries-not-using-indexes long_query_time can be a decimal if you wish – […]