Is their any way to filter mysql slow queries database specifically from
/var/log/mysql/mysql-slow.log file. I have a mysql server with 5 live databases. I am trying to optimize this server.
Also I want to know what are the best practices for optimizing mysql server.
My settings are:
log_slow_queries = /var/log/mysql/mysql-slow.log long_query_time = 5 log-queries-not-using-indexes