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

Slow query log keeping in check

leeusleeus ContributorInactive User Role Beginner
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.

Comments

  • weberweber Advisor Inactive User Role Beginner
    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.
  • leeusleeus Contributor Inactive User Role Beginner
    Ok thanks,

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

    Lee
  • weberweber Advisor Inactive User Role Beginner
    PMM will rotate automatically. The release 1.0.5 will be this Friday.
  • leeusleeus Contributor Inactive User Role Beginner
    Ok thanks, will stop rolling out to new servers until then.
  • leeusleeus Contributor Inactive User Role Beginner
    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!
  • weberweber Advisor Inactive User Role Beginner
    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.
  • leeusleeus Contributor Inactive User Role Beginner
    Great thank you for clarification.
This discussion has been closed.

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