The Slow Query Log. To enable this log use the slow-query-log option either from the command-line when starting the MySQL server or enter the option in the configuration file for MySQL mycnf or myini depending on your system. If your server is above 516 you can set the slow query log in the runtime itself.
MySQL slow query log makes it easy to track SQL queries that take more than a specific time for execution. To see if slow query logging is enabled enter the following SQL statement. To enable this log use the slow-query-log option either from the command-line when starting the MySQL server or enter the option in the configuration file for MySQL mycnf or myini depending on your system.
By default the slow query log is disabled.
To enable the slow query log for MySQLMariaDB navigate to the configuration file mycnf default path. The results here show that the log is not enabled. Slow Query Log Overview A record of SQL queries that took a long time to perform. To see if slow query logging is enabled enter the following SQL statement.