PMM clients running queries that are not valid for some Distributions.
The following queries running against DB. Because these queries are failed in a day like 34560 times usual error monitoring raising alarms.
List of known queries (Failed against Mysql/PS in different versions ):
- SHOW ALL SLAVES STATUS
- SHOW ALL SLAVES STATUS NONBLOCKING
- SHOW ALL SLAVES STATUS NOLOCK
- SELECT @@query_response_time_stats
*Example of AuditLog: *
PMM executes queries without generating errors in the Audit log.
Note: based on an initial discussion: we can consider a solution with a significant decrease in the number of errors if another implementation will be much harder
*Additional Technical details: *
The following logic is used for scraping status of slaves:
For Percona Server/MySQL it's generating errors, which are later recorder by any audit plugin. This, as a result, can cause monitoring systems to trigger errors (industry standard).