The Slow Query Log

The Slow Query Log. The slow query log is a record of SQL queries that took a long time to perform. Locate the configuration section mysqld.

MySQL and MariaDB optionally log slow queries into the Slow Query Log or just Slow Log as friends call it. To see if slow query logging is enabled enter the following SQL statement. However there are good reasons to log all the queries not just some of them.

Note that if your queries contain users passwords the slow query log may contain passwords too.

If your server is above 516 you can set the slow query log in the runtime itself. The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be examined. The full list of mysqldumpslow options is available here. If your server is above 516 you can set the slow query log in the runtime itself.