# "MySQL Query Responce Time" show "No datapoints"

**URL:** <https://forums.percona.com/t/mysql-query-responce-time-show-no-datapoints/5498>\
**Category:** PMM 1.x\
**Created:** [March 19, 2017, 6:46am UTC](https://forums.percona.com/t/mysql-query-responce-time-show-no-datapoints/5498 "2017-03-19T06:46:36Z")\
**Posts on this page:** 4\
**Page:** 2

<div class="post-metadata">

**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\
**Post date:** [April 18, 2017, 1:52am UTC](https://forums.percona.com/t/mysql-query-responce-time-show-no-datapoints/5498/21 "2017-04-18T01:52:29Z")

</div>

Aleksey,

“Performance Schema File IO (Events)”, “Performance Schema File IO (Load)”, “Performance Schema File IO (Bytes)” graphs use data from collector.  
“Performance Schema Waits (Events)” and “Performance Schema Waits (Load)” use  
“Index Access Operations (Load)” use  
“Table Access Operations (Load)” use

we disabled  
so it is expected that “Performance Schema File” and “Performance Schema Waits” graphs are empty for bad server.  
but “Index Access Operations” and “Table Access Operations” should work fine if

sorry for long response

---

<div class="post-metadata">

**Author:** ![aleksey.filippov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@aleksey.filippov](https://forums.percona.com/u/aleksey.filippov)\
**Post date:** [May 3, 2017, 12:29am UTC](https://forums.percona.com/t/mysql-query-responce-time-show-no-datapoints/5498/22 "2017-05-03T00:29:21Z")

</div>

Looks like all problems solved by starting docker pmm-server like this:

docker run -d   
-p 80:80   
–volumes-from pmm-data   
–name pmm-server   
–restart always   
–env TZ=“Europe/Kiev”   
[B]–env METRICS\_RESOLUTION=5s [/B]  
percona/pmm-server:1.1.3

And client setup like this:

pmm-admin uninstall  
pmm-admin repair  
pmm-admin config --server pmm-server --client-name mysql.db  
pmm-admin add linux:metrics  
pmm-admin add mysql:queries --query-source slowlog  
pmm-admin add mysql:metrics --disable-tablestats-limit 3000

After that i have all graphics, including performance\_schema, exception is table statistics for DBs with table count \> 3000. I don’t have to edit

---

<div class="post-metadata">

**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\
**Post date:** [May 3, 2017, 12:36am UTC](https://forums.percona.com/t/mysql-query-responce-time-show-no-datapoints/5498/23 "2017-05-03T00:36:10Z")

</div>

it is not recommended way, because in this case, you lose details, with 5s resolution it is harder to debug database performance

---

<div class="post-metadata">

**Author:** ![aleksey.filippov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@aleksey.filippov](https://forums.percona.com/u/aleksey.filippov)\
**Post date:** [May 3, 2017, 2:28am UTC](https://forums.percona.com/t/mysql-query-responce-time-show-no-datapoints/5498/24 "2017-05-03T02:28:11Z")

</div>

Ok, i do not think about. Thanks

[Previous page](https://forums.percona.com/t/mysql-query-responce-time-show-no-datapoints/5498.md?page=1)
