# MySQL not writing the Slow Queries in Slow Query Log file

**URL:** <https://forums.percona.com/t/mysql-not-writing-the-slow-queries-in-slow-query-log-file/5800>\
**Category:** Percona Server for MySQL 5.7\
**Created:** [August 9, 2017, 2:30am UTC](https://forums.percona.com/t/mysql-not-writing-the-slow-queries-in-slow-query-log-file/5800 "2017-08-09T02:30:48Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![akhilr1](https://avatars.discourse-cdn.com/v4/letter/a/9de0a6/32.png) [@akhilr1](https://forums.percona.com/u/akhilr1)\
**Post date:** [August 9, 2017, 2:30am UTC](https://forums.percona.com/t/mysql-not-writing-the-slow-queries-in-slow-query-log-file/5800/1 "2017-08-09T02:30:48Z")

</div>

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.