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

qan-agent pulling perfschema every 1 second

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Invalid
    • Affects Version/s: 1.13.0
    • Fix Version/s: None
    • Component/s: PMM Client
    • Labels:
      None

      Description

      I noticed the qan-agent pulling perfschema data too often (ie. every second) by default. 

      Current set up:

      PMM-SERVER:

      • EC2 m4.10xlarge
      • pmm server version 1.14.1 

      PMM-CLIENTs:

      • EC2 m3.2xlarge
      • pmm client version 1.13.0

      Number of clients running from PMM-CLIENTs EC2 host: 

            1 linux:metrics
            1 mongodb:metrics
          100 mysql:metrics
          100 mysql:queries 

      The "Interval" in each QAN agent located in /usr/local/percona/qan-agent/config/*.conf is set to 60:

       [pmm-client-runner /usr/local/percona/qan-agent/config]$ grep Interval *.conf
      qan-03abc5e30f7442b67a4aea26f07fe73c.conf:    "Interval": 60,
      qan-042c8a3ea4c743b14bf92750511d7fd5.conf:    "Interval": 60,
      qan-069198ec86a4450f4ce09c0d1c8a9b02.conf:    "Interval": 60,
      qan-080e30e6fab34d636b7fd97c6071c688.conf:    "Interval": 60,
      qan-0866cdb1e3704cc553cf540750267394.conf:    "Interval": 60,
      qan-0911b618c8674829428702b73538041b.conf:    "Interval": 60,
      qan-0abb28abaf8a46187fee4a50d7c663d6.conf:    "Interval": 60,
      qan-13dbb0327b7f47cd50a2ea51bd67ca2e.conf:    "Interval": 60,
      qan-1790789deca7430c7a465f20a3b1813f.conf:    "Interval": 60,
      qan-1e10270ad13c44ae4257b2954e7ca5e3.conf:    "Interval": 60,
      qan-21e60d013500468549f001220c5041a3.conf:    "Interval": 60,
      qan-23a32fc99537476441d3ae9fa5b893fc.conf:    "Interval": 60,
      qan-2474b5926b7f4f3e4616d595583696c3.conf:    "Interval": 60,
      qan-2599b38a84a6413442bc2b0c4ac5703c.conf:    "Interval": 60,
      qan-284469b8ae934478581567fc40ad296c.conf:    "Interval": 60,
      qan-2a0f94ecfcc84e186e28f857c1490528.conf:    "Interval": 60,
      qan-2e547d043ab4411552ab69477b2a5be6.conf:    "Interval": 60,
      ...

       PROBLEM: 

      The qan-agent in the UI is set to collect at a 1 minute interval, for example:

       

      It seems like this particular query to performance_schema.events_statements_history is running far too often given the collection interval of 1 minute:

      Can you help me understand why this is happening and how to tone the collection frequency down in the qan-agent?

      Please let me know if you have any questions or need more information.  And thanks in advance for your help.

       

        Smart Checklist

          Attachments

          1. PMM-QAN-Client-Pull_frequency.2.png
            225 kB
            Chris Schneider
          2. PMM-QAN-Client-Pull_frequency.3.png
            122 kB
            Chris Schneider
          3. PMM-QAN-Client-Pull_frequency.png
            48 kB
            Chris Schneider

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                schneiderdba@gmail.com Chris Schneider
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: