# PMM graphs look strange

**URL:** <https://forums.percona.com/t/pmm-graphs-look-strange/5610>\
**Category:** PMM 1.x\
**Created:** [May 17, 2017, 3:20am UTC](https://forums.percona.com/t/pmm-graphs-look-strange/5610 "2017-05-17T03:20:13Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Catoman](https://avatars.discourse-cdn.com/v4/letter/c/cab0a1/32.png) [@Catoman](https://forums.percona.com/u/Catoman)\
**Post date:** [May 17, 2017, 3:20am UTC](https://forums.percona.com/t/pmm-graphs-look-strange/5610/1 "2017-05-17T03:20:13Z")

</div>

We have a PMM installation and the graphs look like this…I don’t think there are any network issues because that would probably affect our production and we would get notified about it very quickly.  
The server that runs the PMM docker container is an old database server, it’s an PowerEdge R720 with SSD’s in RAID10 and 127 Gb memory so it should be able to handle the monitoring tool. The server is also located at the same network segment as the servers it monitor

Any tuning that needs to be done or what can i look for. The tool is useful but the graphs are not when they look like this

 ![pmm.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/f/fe5b42eceae17352528dea974b2f8427697f52fe.png)

---

<div class="post-metadata">

**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\
**Post date:** [May 19, 2017, 11:10am UTC](https://forums.percona.com/t/pmm-graphs-look-strange/5610/2 "2017-05-19T11:10:53Z")

</div>

Hi [Catoman](https://percona.vanillacommunities.com/profile/x/x/38039) , I would suggest you send us a screen capture of the Prometheus dashboard. Usually we see gaps in the graphs for the following reasons:  
[LIST]  
[_]db server overloaded, and times out on metrics retrieval from mysqld\_exporter  
[_]network TTL taking longer than scrape interval (1s by default) - common  
[\*]PMM server overloaded. Given the specs you mention you’re well provisioned  
[/LIST] Also send us a screen capture of /prometheus/targets

---

<div class="post-metadata">

**Author:** ![Catoman](https://avatars.discourse-cdn.com/v4/letter/c/cab0a1/32.png) [@Catoman](https://forums.percona.com/u/Catoman)\
**Post date:** [May 23, 2017, 2:09am UTC](https://forums.percona.com/t/pmm-graphs-look-strange/5610/3 "2017-05-23T02:09:14Z")

</div>

Hi Michael,

I have attached files for config and targets. Not sure what you mean by “Prometheus dashboard”.

[prometheus\_metrics.txt](https://forums.percona.com/uploads/short-url/2Ftohs7LTMHFFspQO8kgKqLkei1.txt) (47.9 KB)

 ![config3.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/0/0956f80b2a19ff0feec0ffe046c904cb4fb2e841.png)

 ![config2.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/7/7c1356e3bc4980c62726e51eca6b2afb031ff30d.png)

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

 ![target4.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/a/a51c7182993c88620f812c9711e8945b4c266fd1.png)

---

<div class="post-metadata">

**Author:** ![Catoman](https://avatars.discourse-cdn.com/v4/letter/c/cab0a1/32.png) [@Catoman](https://forums.percona.com/u/Catoman)\
**Post date:** [May 23, 2017, 2:10am UTC](https://forums.percona.com/t/pmm-graphs-look-strange/5610/4 "2017-05-23T02:10:17Z")

</div>

More files

[prometheus\_metrics.txt](https://forums.percona.com/uploads/short-url/2Ftohs7LTMHFFspQO8kgKqLkei1.txt) (47.9 KB)

 ![target1.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/d/dd6a1099cdab47cfa311264b152dfc5e92fa448a.png)

 ![target3.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/c/c8608423c17b64d6d0cff56bc357f2407c9118b4.jpeg)

 ![target2.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/2/2cc41f96f50584db7499b6abff5641050dbf7350.jpeg)

---

<div class="post-metadata">

**Author:** ![Catoman](https://avatars.discourse-cdn.com/v4/letter/c/cab0a1/32.png) [@Catoman](https://forums.percona.com/u/Catoman)\
**Post date:** [May 24, 2017, 4:22am UTC](https://forums.percona.com/t/pmm-graphs-look-strange/5610/5 "2017-05-24T04:22:39Z")

</div>

Running a test now so we can let this rest until next week.

---

<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 26, 2017, 12:46am UTC](https://forums.percona.com/t/pmm-graphs-look-strange/5610/6 "2017-05-26T00:46:05Z")

</div>

Hi Catoman,

as I can see you have errors, it is the most popular reason for gaps in graphs.  
expected (cannot finish work in 1 second).  
so mysqld\_exporter creates long additional load on the database server.  
mysqld\_exporter runs many queries to the database, so we can disable some checks to speed up it.  
usually, the longest query is ‘tablestat’, it is possible to disable this query by the following commands.

```auto
pmm-admin remove mysql:metrics
pmm-admin add mysql:metrics --disable-tablestats

```

also options available.

---

<div class="post-metadata">

**Author:** ![Catoman](https://avatars.discourse-cdn.com/v4/letter/c/cab0a1/32.png) [@Catoman](https://forums.percona.com/u/Catoman)\
**Post date:** [June 1, 2017, 12:58am UTC](https://forums.percona.com/t/pmm-graphs-look-strange/5610/7 "2017-06-01T00:58:31Z")

</div>

We can close this…I migrated (well, re-installed) the PPM server on an HP DL385 instead and now the graphs are solid. No gaps or anything.  
The problem was the Dell server
