# Some grafics show "No datapoints"

**URL:** <https://forums.percona.com/t/some-grafics-show-no-datapoints/5372>\
**Category:** PMM 1.x\
**Created:** [January 26, 2017, 4:52am UTC](https://forums.percona.com/t/some-grafics-show-no-datapoints/5372 "2017-01-26T04:52:25Z")\
**Posts on this page:** 8\
**Page:** 1

<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:** [January 26, 2017, 4:52am UTC](https://forums.percona.com/t/some-grafics-show-no-datapoints/5372/1 "2017-01-26T04:52:25Z")

</div>

Hi.  
Like any other on this forum, i have a problem. I will be gratefull for any help about.  
So…  
After setting up pmm server, some grafics in Grafana show me “No datapoints”:

– mysql-innodb-metrics-advanced  
---- InnoDB Log Buffer Performance  
---- InnoDB Purge Performance  
---- InnoDB Locking  
---- InnoDB Main Thread Utilization  
---- InnoDB Undo Space Usage  
---- InnoDB Group Commit Batch Size  
---- InnoDB AHI Maintenance  
– mysql-overview  
---- Process State  
---- Top Process State Hourly  
– mysql-query-response-time  
---- Average Query Response Time  
---- Read Query Responce Time Distribution  
---- Write Query Responce Time Distribution

All other graphics related to mysql and linux work fine.

Is there some additional settings for mysql&pmm to make it work, or something else?

Some usefull info:

pmm-admin list:

pmm-admin 1.0.7

PMM Server | 111.111.111.111:81  
Client Name | mysql.db  
Client Address | 111.111.111.90  
Service Manager | linux-systemd

* * *

SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS

* * *

mysql:queries mysql.db - YES root:_**@unix(/var/lib/mysql/mysql.sock) query\_source=perfschema  
linux:metrics mysql.db 42000 YES -  
mysql:metrics mysql.db 42002 YES root:**_@unix(/var/lib/mysql/mysql.sock)

---

<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:** [January 26, 2017, 5:05am UTC](https://forums.percona.com/t/some-grafics-show-no-datapoints/5372/2 "2017-01-26T05:05:03Z")

</div>

Hi Aleksey,

can you please run command on mysql server?

---

<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:** [January 26, 2017, 5:49am UTC](https://forums.percona.com/t/some-grafics-show-no-datapoints/5372/3 "2017-01-26T05:49:11Z")

</div>

PMM Network Status

Server Address | 111.111.111.111:81  
Client Address | 111.111.111.90

- System Time  
Server | 2017-01-26 13:17:33 +0200 EET  
Client | 2017-01-26 13:17:33 +0200 EET  
Time Drift | OK

- Connection: Client → Server

* * *

SERVER SERVICE STATUS

* * *

Consul API OK  
Prometheus API OK  
Query Analytics API OK

Connection duration | 577.096µs  
Request duration | 987.613µs  
Full round trip | 1.564709ms

- Connection: Client ← Server

* * *

SERVICE TYPE NAME REMOTE ENDPOINT STATUS HTTPS/TLS PASSWORD

* * *

linux:metrics mysql.db 111.111.111.90:42000 OK YES -  
mysql:metrics mysql.db 111.111.111.90:42002 OK YES -

---

<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:** [January 26, 2017, 6:13am UTC](https://forums.percona.com/t/some-grafics-show-no-datapoints/5372/4 "2017-01-26T06:13:52Z")

</div>

Did you get my answer? I cant see it…

---

<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:** [January 26, 2017, 6:26am UTC](https://forums.percona.com/t/some-grafics-show-no-datapoints/5372/5 "2017-01-26T06:26:28Z")

</div>

Hi Aleksey,  
I see your post, can you try to remove instance and add it again?

```auto

pmm-admin remove mysql
pmm-admin add mysql

```

---

<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:** [January 26, 2017, 6:59am UTC](https://forums.percona.com/t/some-grafics-show-no-datapoints/5372/6 "2017-01-26T06:59:49Z")

</div>

Done. Nothing changed.

---

<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:** [January 26, 2017, 9:43am UTC](https://forums.percona.com/t/some-grafics-show-no-datapoints/5372/7 "2017-01-26T09:43:52Z")

</div>

Looks like some options are not configured, please find all needed information in the following document:  
[url][Percona Monitoring and Management](https://www.percona.com/doc/percona-monitoring-and-management/conf-mysql.html%5B/url%5D)

---

<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:** [January 30, 2017, 4:35am UTC](https://forums.percona.com/t/some-grafics-show-no-datapoints/5372/8 "2017-01-30T04:35:27Z")

</div>

Thank you! Now it works 🙂 You were right, RTFM!!!