The Slow Query Log Mysql. If a query takes longer than the value specified this query will be recorded in the slow query log file. To enable the slow query log for MySQLMariaDB navigate to the configuration file mycnf default path.
Make sure you have rights to moveremove the log file. Start the mysql service. Another valuable tool in MySQL is the included slow query logging feature.
Create a new log file with the same name.
Time the query began. Log-slow-queries varlogmysql-slowlog Make sure you create the log file varlogmysql-slowlog you can change this to your own naming and also change ownership of the file to mysql. MySQL has the capability to filter and log slow queries. Slow_query_log_file slow-querylog long_query_time 2.