How to enable the MariaDB slow query log on Windows Server with Plesk?

Question

How to enable the MariaDB slow query log on Windows Server with Plesk and analyze it?

Answer

1. Connect to a Plesk server via RDP.

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

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

   CONFIG_TEXT: 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 MariaDB 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 MariaDB slow query log, visit MariaDB Reference Manual: The Slow Query Log.

Note: How to enable the MySQL/MariaDB slow query log and analyze it on Linux