Not the answer you need?
Register and ask your own question!

pmm is not drowing graph of cpu usage

next1009next1009 ContributorCurrent User Role Contributor
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.

Comments

  • next1009next1009 Contributor Current User Role Contributor
    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?
  • MykolaMykola Percona Percona Staff Role
    Hi next1009,

    can you clarify dashboard? (because we have several cpu graphs)
  • next1009next1009 Contributor Current User Role Contributor
    Mykola

    it's "system overview" and pmm version 1.1.2

    thank you for your reply.
  • MykolaMykola Percona Percona Staff Role
    can you try to use the following Query in graph?
    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]
  • next1009next1009 Contributor Current User Role Contributor
    i did change query in graph.

    but it's not loaded.





    Response

    504 Gateway Time-out

    504 Gateway Time-out
    nginx
  • MykolaMykola Percona Percona Staff Role
    can you change Resolution value from "1/1" to "1/10" ?
  • next1009next1009 Contributor Current User Role Contributor
    Mykola 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.
  • MykolaMykola Percona Percona Staff Role
    is "CPU Usage" graph working fine on "Summary Dashboard" and on "Mysql Overview" (under "System Charts") ?
    is only "System Overview" dashboard affected?
  • next1009next1009 Contributor Current User Role Contributor
    "cpu usage" Graph is not loaded in all dashboard.
  • MykolaMykola Percona Percona Staff Role
    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?
  • next1009next1009 Contributor Current User Role Contributor
    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.
  • MykolaMykola Percona Percona Staff Role
    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.
  • next1009next1009 Contributor Current User Role Contributor
    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.
  • MykolaMykola Percona Percona Staff Role
    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
    you can compare loading time
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.