# Bug report on the count

**URL:** <https://forums.percona.com/t/bug-report-on-the-count/16770>\
**Category:** PMM 1.x\
**Tags:** pmm, mysql\
**Created:** [July 27, 2022, 6:59am UTC](https://forums.percona.com/t/bug-report-on-the-count/16770 "2022-07-27T06:59:15Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![venomania](https://avatars.discourse-cdn.com/v4/letter/v/b4bc9f/32.png) [@venomania](https://forums.percona.com/u/venomania)\
**Post date:** [July 27, 2022, 6:59am UTC](https://forums.percona.com/t/bug-report-on-the-count/16770/1 "2022-07-27T06:59:16Z")

</div>

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).

![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/5/5ed10710db43c9667beb8be650f08576c05c5bab.png)  
 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/4/4810b7c1a13a72b8268a76259ad0cc3056a93fcf.png)

pmm displays me a bad value

---

<div class="post-metadata">

**Author:** ![nurlan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/nurlan/32/1523_2.png) [@nurlan](https://forums.percona.com/u/nurlan)\
**Post date:** [July 27, 2022, 1:08pm UTC](https://forums.percona.com/t/bug-report-on-the-count/16770/2 "2022-07-27T13:08:40Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![venomania](https://avatars.discourse-cdn.com/v4/letter/v/b4bc9f/32.png) [@venomania](https://forums.percona.com/u/venomania)\
**Post date:** [July 27, 2022, 1:41pm UTC](https://forums.percona.com/t/bug-report-on-the-count/16770/3 "2022-07-27T13:41:07Z")

</div>

> [@venomania](#):
>
> DPM

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

 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/1/1d66c35416c5016f46ec3566316d1db2a7e232a0.png)

---

<div class="post-metadata">

**Author:** ![nurlan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/nurlan/32/1523_2.png) [@nurlan](https://forums.percona.com/u/nurlan)\
**Post date:** [July 27, 2022, 1:58pm UTC](https://forums.percona.com/t/bug-report-on-the-count/16770/4 "2022-07-27T13:58:49Z")

</div>

Did you filter by service name in UI? Is it possible that you see summary for 2 services?

---

<div class="post-metadata">

**Author:** ![venomania](https://avatars.discourse-cdn.com/v4/letter/v/b4bc9f/32.png) [@venomania](https://forums.percona.com/u/venomania)\
**Post date:** [July 27, 2022, 2:06pm UTC](https://forums.percona.com/t/bug-report-on-the-count/16770/5 "2022-07-27T14:06:48Z")

</div>

here but filter  
test is the right service

 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/4/4bf79fbf9885681e1c9f7d73b361b3f43173c9ae.png)

---

<div class="post-metadata">

**Author:** ![nurlan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/nurlan/32/1523_2.png) [@nurlan](https://forums.percona.com/u/nurlan)\
**Post date:** [July 28, 2022, 2:33pm UTC](https://forums.percona.com/t/bug-report-on-the-count/16770/6 "2022-07-28T14:33:35Z")

</div>

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` ?