I have run some tests on my mysql 8 server with two monitoring 1.PMM 2.DPM on one of the request pmm displays 28m count and on DPM displays 148K (expected value).
pmm displays me a bad value
2 Likes
Hi @venomania, could you please add more details?
- What version of PMM is used?
- What version of MySQL is used?
- What data source was used: slowlog or performance schema?
- Did you use the same time range for both apps?
- Did you add a MySQL service only once?
Thank you
1 Like
hi @nurlan
What version of PMM is used?
version: 2.27.0 (April 13, 2022)
What version of MySQL is used?
Mysql 8.0.29 (innodb)
What data source was used: slowlog or performance schema?
i use performance schema
Did you use the same time range for both apps?
yes.I use the same time range
Did you add a MySQL service only once?
I have two mysql services but they are not on the same server
1 Like
Did you filter by service name in UI? Is it possible that you see summary for 2 services?
1 Like
Do you have an access to performance schema?
could you run
select * from performance_schema.events_statements_summary_by_digest WHERE DIGEST IS NOT NULL AND QUERY_SAMPLE_TEXT IS NOT NULL ?
1 Like