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.