The Slow Query Log Mysql. Putting it all together. In the same folder create the file slow-querylog.
Here are the same commonly used examples from above. Save the changes and close the file. 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.
MySQL slow query log can be to used to determine queries that take a longer time to execute in order to optimize them.
Slow_query_log 1 log-slow-queries varlogmysql-slowlog long_query_time 2. Locate the configuration section mysqld. Start the mysql service. By identifying queries that are particularly slow in their execution you can address them by restructuring the application that triggers your queries.