# pmm is not drowing graph of cpu usage

**URL:** <https://forums.percona.com/t/pmm-is-not-drowing-graph-of-cpu-usage/5635>\
**Category:** PMM 1.x\
**Created:** [May 24, 2017, 12:38am UTC](https://forums.percona.com/t/pmm-is-not-drowing-graph-of-cpu-usage/5635 "2017-05-24T00:38:35Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![next1009](https://avatars.discourse-cdn.com/v4/letter/n/8e7dd6/32.png) [@next1009](https://forums.percona.com/u/next1009)\
**Post date:** [May 24, 2017, 12:38am UTC](https://forums.percona.com/t/pmm-is-not-drowing-graph-of-cpu-usage/5635/1 "2017-05-24T00:38:35Z")

</div>

pmm is not drowing graph of cpu usage.

i’m setting time range is last 3 hours.

another graph is ok. but cpu usage is not showing.

help me. thanks.

---

<div class="post-metadata">

**Author:** ![next1009](https://avatars.discourse-cdn.com/v4/letter/n/8e7dd6/32.png) [@next1009](https://forums.percona.com/u/next1009)\
**Post date:** [May 24, 2017, 7:46pm UTC](https://forums.percona.com/t/pmm-is-not-drowing-graph-of-cpu-usage/5635/2 "2017-05-24T19:46:50Z")

</div>

I did not explain it correctly.

time range over 3hours it’s not loaded.

range set last 1 hour. it’s loaded but very slowly.

what’s the problem?

---

<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, 1:00am UTC](https://forums.percona.com/t/pmm-is-not-drowing-graph-of-cpu-usage/5635/3 "2017-05-26T01:00:54Z")

</div>

Hi [next1009](https://percona.vanillacommunities.com/profile/x/x/38295),

can you clarify dashboard? (because we have several cpu graphs)

---

<div class="post-metadata">

**Author:** ![next1009](https://avatars.discourse-cdn.com/v4/letter/n/8e7dd6/32.png) [@next1009](https://forums.percona.com/u/next1009)\
**Post date:** [May 28, 2017, 9:16pm UTC](https://forums.percona.com/t/pmm-is-not-drowing-graph-of-cpu-usage/5635/4 "2017-05-28T21:16:29Z")

</div>

[Mykola](https://percona.vanillacommunities.com/profile/x/x/30783)

it’s “system overview” and pmm version 1.1.2

thank you for your reply.

---

<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 29, 2017, 4:49am UTC](https://forums.percona.com/t/pmm-is-not-drowing-graph-of-cpu-usage/5635/5 "2017-05-29T04:49:43Z")

</div>

can you try to use the following Query in graph?

```auto
sum( rate(node_cpu{instance="$host", mode!="idle"}[$interval])) by (mode) * 100 / scalar(sum(rate(node_cpu{instance="$host"}[$interval]))) or sum(irate(node_cpu{instance="$host", mode!="idle"}[5m])) by (mode) * 100 / scalar(sum(irate(node_cpu{instance="$host"}[5m])))

```

it is needed to click on graph name, open for edit, open “metrics” tab and replace Query.  
please find the screenshot [IMG2=JSON]{“data-align”:“none”,“data-size”:“full”,“width”:“800”,“src”:“https://www.percona.com/forums/filedata/fetch?id=48137&d=1492075788”}[/IMG2]

---

<div class="post-metadata">

**Author:** ![next1009](https://avatars.discourse-cdn.com/v4/letter/n/8e7dd6/32.png) [@next1009](https://forums.percona.com/u/next1009)\
**Post date:** [May 30, 2017, 7:48pm UTC](https://forums.percona.com/t/pmm-is-not-drowing-graph-of-cpu-usage/5635/6 "2017-05-30T19:48:14Z")

</div>

i did change query in graph.

but it’s not loaded.

Response

504 Gateway Time-out

504 Gateway Time-out  
nginx

 ![photoid=48586](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/b/bb7d476b6b36a82a7c608968c3047201facd4566.jpeg)

---

<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 31, 2017, 7:11am UTC](https://forums.percona.com/t/pmm-is-not-drowing-graph-of-cpu-usage/5635/7 "2017-05-31T07:11:39Z")

</div>

can you change Resolution value from “1/1” to “1/10” ?

---

<div class="post-metadata">

**Author:** ![next1009](https://avatars.discourse-cdn.com/v4/letter/n/8e7dd6/32.png) [@next1009](https://forums.percona.com/u/next1009)\
**Post date:** [June 11, 2017, 10:03pm UTC](https://forums.percona.com/t/pmm-is-not-drowing-graph-of-cpu-usage/5635/8 "2017-06-11T22:03:05Z")

</div>

[Mykola](https://percona.vanillacommunities.com/profile/x/x/30783) I’m sorry. I’m late.

I changed Resolution value.

Last 12 hours is working but Last 24 Hours is not loaded yet.

I’m Sorry My English is very poor.

---

<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:** [June 13, 2017, 3:27am UTC](https://forums.percona.com/t/pmm-is-not-drowing-graph-of-cpu-usage/5635/9 "2017-06-13T03:27:05Z")

</div>

is “CPU Usage” graph working fine on “Summary Dashboard” and on “Mysql Overview” (under “System Charts”) ?  
is only “System Overview” dashboard affected?

---

<div class="post-metadata">

**Author:** ![next1009](https://avatars.discourse-cdn.com/v4/letter/n/8e7dd6/32.png) [@next1009](https://forums.percona.com/u/next1009)\
**Post date:** [June 13, 2017, 9:08pm UTC](https://forums.percona.com/t/pmm-is-not-drowing-graph-of-cpu-usage/5635/10 "2017-06-13T21:08:24Z")

</div>

“cpu usage” Graph is not loaded in all dashboard.

---

<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:** [June 14, 2017, 1:42am UTC](https://forums.percona.com/t/pmm-is-not-drowing-graph-of-cpu-usage/5635/11 "2017-06-14T01:42:28Z")

</div>

can you open only CPU usage graph and open “Developer Tools” in your browser?  
Do you see any errors in javascript “Console” tab or any issues in “Network” tab?

---

<div class="post-metadata">

**Author:** ![next1009](https://avatars.discourse-cdn.com/v4/letter/n/8e7dd6/32.png) [@next1009](https://forums.percona.com/u/next1009)\
**Post date:** [June 14, 2017, 9:31pm UTC](https://forums.percona.com/t/pmm-is-not-drowing-graph-of-cpu-usage/5635/12 "2017-06-14T21:31:27Z")

</div>

I was selected time range Last 24 Hours.

“cpu usage” graph is timeout error.

selected under 12 hours then it’s loaded but very slow.

 ![photoid=48758](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/f/f005988570eaebd725a65a016250cc205606d6ce.jpeg)

![photoid=48759](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/2/26e411088dedde4678b1f2328339b3e4c66282c9.jpeg)

---

<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:** [June 15, 2017, 4:06am UTC](https://forums.percona.com/t/pmm-is-not-drowing-graph-of-cpu-usage/5635/13 "2017-06-15T04:06:58Z")

</div>

Can you change “Resolution” value from “1/1” to “1/10” and “Min step” to “5m”?  
don’t forget to click “Save dashboard” button on the top.  
these changes radically decrease the amount of transferred data from grafana backend.

---

<div class="post-metadata">

**Author:** ![next1009](https://avatars.discourse-cdn.com/v4/letter/n/8e7dd6/32.png) [@next1009](https://forums.percona.com/u/next1009)\
**Post date:** [June 15, 2017, 9:53pm UTC](https://forums.percona.com/t/pmm-is-not-drowing-graph-of-cpu-usage/5635/14 "2017-06-15T21:53:48Z")

</div>

i was change “Resolution” value from “1/1” to “1/10” and “Min step” to “5m”

then it’s loaded. Thank you.

but i wonder why “cpu usage” graph is very slow.

---

<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:** [June 16, 2017, 1:24am UTC](https://forums.percona.com/t/pmm-is-not-drowing-graph-of-cpu-usage/5635/15 "2017-06-16T01:24:50Z")

</div>

> [@](#):
>
> i wonder why “cpu usage” graph is very slow

it is slower that other graphs because it filters (idle metric) and aggregates (sum and count functions) values.  
but anyway it should work fine and load values in few seconds.  
7 days graph - [https://pmmdemo.percona.com/graph/da…=now-7d&to=now](https://pmmdemo.percona.com/graph/dashboard/db/system-overview?orgId=1&from=now-7d&to=now)  
you can compare loading time
