Affects Version/s: 1.13.0
Fix Version/s: None
Component/s: PMM Client
I noticed the qan-agent pulling perfschema data too often (ie. every second) by default.
- EC2 m4.10xlarge
- pmm server version 1.14.1
- EC2 m3.2xlarge
- pmm client version 1.13.0
Number of clients running from PMM-CLIENTs EC2 host:
The "Interval" in each QAN agent located in /usr/local/percona/qan-agent/config/*.conf is set to 60:
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.