# Slow query log keeping in check

**URL:** <https://forums.percona.com/t/slow-query-log-keeping-in-check/5139>\
**Category:** PMM 1.x\
**Created:** [October 10, 2016, 6:00am UTC](https://forums.percona.com/t/slow-query-log-keeping-in-check/5139 "2016-10-10T06:00:25Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![leeus](https://avatars.discourse-cdn.com/v4/letter/l/a183cd/32.png) [@leeus](https://forums.percona.com/u/leeus)\
**Post date:** [October 10, 2016, 6:00am UTC](https://forums.percona.com/t/slow-query-log-keeping-in-check/5139/1 "2016-10-10T06:00:25Z")

</div>

Will PMM keep the Slow Query log from growing to a crazy value?

I have tried using the Persona options for keeping the slow query log rotated by using “max\_slowlog\_size” available in PS 5.5 and it can’t then read the log using this.

---

<div class="post-metadata">

**Author:** ![weber](https://avatars.discourse-cdn.com/v4/letter/w/da6949/32.png) [@weber](https://forums.percona.com/u/weber)\
**Post date:** [October 10, 2016, 6:11am UTC](https://forums.percona.com/t/slow-query-log-keeping-in-check/5139/2 "2016-10-10T06:11:52Z")

</div>

There is a problem in 1.0.4 version with slow log rotation.

On Wednesday we will have 1.0.5 release which fixes that: correctly detect when the slow log is rotated and also perform its own rotation.

---

<div class="post-metadata">

**Author:** ![leeus](https://avatars.discourse-cdn.com/v4/letter/l/a183cd/32.png) [@leeus](https://forums.percona.com/u/leeus)\
**Post date:** [October 11, 2016, 1:30am UTC](https://forums.percona.com/t/slow-query-log-keeping-in-check/5139/3 "2016-10-11T01:30:56Z")

</div>

Ok thanks,

So we’ll still have to rotate ourselves or will PMM do it for us?

Lee

---

<div class="post-metadata">

**Author:** ![weber](https://avatars.discourse-cdn.com/v4/letter/w/da6949/32.png) [@weber](https://forums.percona.com/u/weber)\
**Post date:** [October 11, 2016, 9:33am UTC](https://forums.percona.com/t/slow-query-log-keeping-in-check/5139/4 "2016-10-11T09:33:43Z")

</div>

PMM will rotate automatically. The release 1.0.5 will be this Friday.

---

<div class="post-metadata">

**Author:** ![leeus](https://avatars.discourse-cdn.com/v4/letter/l/a183cd/32.png) [@leeus](https://forums.percona.com/u/leeus)\
**Post date:** [October 12, 2016, 12:36am UTC](https://forums.percona.com/t/slow-query-log-keeping-in-check/5139/5 "2016-10-12T00:36:05Z")

</div>

Ok thanks, will stop rolling out to new servers until then.

---

<div class="post-metadata">

**Author:** ![leeus](https://avatars.discourse-cdn.com/v4/letter/l/a183cd/32.png) [@leeus](https://forums.percona.com/u/leeus)\
**Post date:** [October 17, 2016, 12:54am UTC](https://forums.percona.com/t/slow-query-log-keeping-in-check/5139/6 "2016-10-17T00:54:07Z")

</div>

I see that the log rollover is working well in 1.0.5.

Where are the config options set for the size and how many old files to keep?

Thanks!

---

<div class="post-metadata">

**Author:** ![weber](https://avatars.discourse-cdn.com/v4/letter/w/da6949/32.png) [@weber](https://forums.percona.com/u/weber)\
**Post date:** [October 17, 2016, 8:42am UTC](https://forums.percona.com/t/slow-query-log-keeping-in-check/5139/7 "2016-10-17T08:42:18Z")

</div>

They are hard-coded for now: 1G max file size, purge old log and keep only previous one.  
We will be improving the QAN settings page with the next releases to make it more flexible.

---

<div class="post-metadata">

**Author:** ![leeus](https://avatars.discourse-cdn.com/v4/letter/l/a183cd/32.png) [@leeus](https://forums.percona.com/u/leeus)\
**Post date:** [October 18, 2016, 1:54am UTC](https://forums.percona.com/t/slow-query-log-keeping-in-check/5139/8 "2016-10-18T01:54:43Z")

</div>

Great thank you for clarification.