Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-4437

MySQL Slow Log rotation by pmm-agent using FLUSH SLOW LOGS

    Details

    • Epic Name:
      Slow Log rotation by pmm-agent

      Description

      As a PMM User, I need pmm to rotate my SlowLog files so that I can not set up the rotation by an external program.

       

      We need to provide an additional parameter for --size-slow-logs (=0 = no rotation) (1Gb by default )

      No need to specify the number of files (keep only 1 file )

       

      Error and warnings: TBD

       

      Implementation:

      based on https://dev.mysql.com/doc/refman/5.5/en/flush.html#flush-slow-logs we should move the log file and FLUSH SLOW LOGS (note we might need additional permission )

      https://confluence.percona.com/display/PMM/MySQL+Slow+Log+rotation
      https://confluence.percona.com/display/PMM/Configurable+MySQL+Slow+Log+File+Rotation

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  roma.novikov Roma Novikov
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: