How to enable the MySQL slow query log on Windows Server

Question

How to enable the MySQL slow query log and analyze it?

Answer

1. Connect to a Plesk server via RDP.

2. Open the MySQL installation folder. In Plesk for Windows, it is %plesk_dir%DatabasesMySQL.

3. Open the my.ini file located in this folder and add the following lines under the [mysqld] section:

   slow_query_log = 1
   slow_query_log_file = slow-query.log
    long_query_time = 2

   • where long_query_time – time taken by an SQL query to be executed in seconds. If a query takes longer than the value specified, this query will be recorded in the slow query log file.

4. In the same folder create the file slow-query.log.

5. Restart MySQL via Task Manager > Services or using Plesk Services Monitor:

   

6. Once restarted, start monitoring the slow query logfile slow-query.log created on step 4.

To learn more about the MySQL slow query log, visit MySQL 5.7 Reference Manual: The Slow Query Log.

Related Articles

• How to enable the MySQL slow query log and analyze it on Linux