MariaDB error and slow query log became empty

Question

So I enabled error log and slow query log on MariaDB and I could see the data in log files. But after a couple of hours when I checked back again then they were empty. It is showing both log files size as 0 and now it is not creating new logs. Machine has not been restarted during this time. Why all of sudden both error and slow query logs are now empty?
OS is Debian.

Rick James · Accepted Answer · 2021-09-02 05:04:43Z

2

The error log rarely has anything.

The slowlog needs several settings to really get it "ON":

log_output = FILE
slow_query_log = ON
slow_query_log_file = (fullpath to some file)
long_query_time = 1
log_slow_admin_statements = ON        -- (optional)
log_queries_not_using_indexes = OFF   -- (optional)

Explanation and more discussion, plus recommendation on digesting the results: http://mysql.rjweb.org/doc.php/mysql_analysis#slow_queries_and_slowlog

edited Sep 2, 2021 at 5:04

answered Aug 27, 2021 at 19:40

Rick James

144k15 gold badges144 silver badges254 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

sarlacii Over a year ago

Also do "FLUSH SLOW LOGS;", as you (Rick) suggested in another post. That populated the file with data regarding recent slow logs.

Collectives™ on Stack Overflow

MariaDB error and slow query log became empty

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related