mariadb slow query not logged

Question

As the title suggests, no log is recorded in the log file even though the related settings have been completed.

slow_query_log_file    = /var/log/mysql/mariadb-slow.log
slow_query_log         = 1
long_query_time        = 1
log_slow_rate_limit    = 1000
log_slow_verbosity     = query_plan
log-queries-not-using-indexes

This is mariadb's conf content. When you open the log file, only the basics exist.

Tcp port: 3306  Unix socket: /run/mysqld/mysqld.sock
Time            Id Command  Argument

logrotate seems to work fine. After connecting to mysql, I used select sleep(); but it did not work properly. The result after using the command is 0, which seems to be normal, but the log is not recorded.

Why wouldn't it work?

suppose the query will appear in the log. After you changed the slow query log settings, have you restarted the MariaDB server? — Raptor, Mar 02 '22 at 09:33
yes restarted. I solved the problem! If log_slow_rate_limit was set to 1, a log was created. Thank you for your help :) — pat-bung, Mar 03 '22 at 01:26
I find that `log-queries-not-using-indexes` clutters the output. It tends to be a false alarm when using very small tables. — Rick James, Mar 05 '22 at 16:30

score 1 · Accepted Answer · answered Mar 03 '22 at 05:56

1

The new settings will apply only if the MariaDB server instance is restarted. Therefore, the solution, as mentioned in the comment, is to restart the MariaDB server instance in order to apply the new settings.

answered Mar 03 '22 at 05:56

Raptor

53,206
45
230
366

mariadb slow query not logged

1 Answers1