Not the answer you need?
Register and ask your own question!

MySQL not writing the Slow Queries in Slow Query Log file

akhilr@ebutor[email protected] ContributorCurrent User Role Beginner
Hi There,

I've setup a master -slave replication topology. My master accepts all writes and slave accepts only Read. I've enabled the Slow Query log on the slave. If worked fine for 2 Days, after then no queries are logging into slow query logs.

mysql> show global variables like '%slow%';
show global variables like '%slow%'

+
+
+
| Variable_name | Value |
+
+
+
| log_slow_admin_statements | OFF |
| log_slow_filter | |
| log_slow_rate_limit | 1 |
| log_slow_rate_type | session |
| log_slow_slave_statements | OFF |
| log_slow_sp_statements | ON |
| log_slow_verbosity | |
| max_slowlog_files | 0 |
| max_slowlog_size | 0 |
| slow_launch_time | 2 |
| slow_query_log | ON |
| slow_query_log_always_write_time | 10.000000 |
| slow_query_log_file | /var/lib/mysql/mysql-slow.log |
| slow_query_log_use_global_control | |
+
+
+


From above I can see that Slow Query Log is on and none of the statements are logging into Slow Log.

Please provide a solution for this.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.