MySQL slow query log

The MySQL slow query log enables you to log all queries that take longer than a specified number of seconds to execute. ┬áThis should help identify any queries that are not performing sufficiently. All that is required is two additional lines in the MySQL configuration file “my.cnf” in the [mysqld] section. 123[mysqld] log-slow-queries = /var/log/mysql-slow.log …

Continue Reading