Created
November 11, 2014 02:29
-
-
Save wolfdancer/37ab6c56023380470469 to your computer and use it in GitHub Desktop.
mysql dashboard cloud metrics
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "title": "Grafana", | |
| "tags": [], | |
| "style": "dark", | |
| "timezone": "browser", | |
| "editable": true, | |
| "rows": [ | |
| { | |
| "title": "Welcome to Grafana", | |
| "height": "210px", | |
| "editable": true, | |
| "collapse": false, | |
| "collapsable": true, | |
| "panels": [ | |
| { | |
| "error": false, | |
| "span": 6, | |
| "editable": true, | |
| "type": "text", | |
| "loadingEditor": false, | |
| "mode": "html", | |
| "content": "<br/>\n\n<div class=\"row-fluid\">\n <div class=\"span6\">\n <ul>\n <li>\n <a href=\"http://grafana.org/docs#configuration\" target=\"_blank\">Configuration</a>\n </li>\n <li>\n <a href=\"http://grafana.org/docs/troubleshooting\" target=\"_blank\">Troubleshooting</a>\n </li>\n <li>\n <a href=\"http://grafana.org/docs/support\" target=\"_blank\">Support</a>\n </li>\n <li>\n <a href=\"http://grafana.org/docs/features/intro\" target=\"_blank\">Getting started</a> (Must read!)\n </li>\n </ul>\n </div>\n <div class=\"span6\">\n <ul>\n <li>\n <a href=\"http://grafana.org/docs/features/graphing\" target=\"_blank\">Graphing</a>\n </li>\n <li>\n <a href=\"http://grafana.org/docs/features/annotations\" target=\"_blank\">Annotations</a>\n </li>\n <li>\n <a href=\"http://grafana.org/docs/features/graphite\" target=\"_blank\">Graphite</a>\n </li>\n <li>\n <a href=\"http://grafana.org/docs/features/influxdb\" target=\"_blank\">InfluxDB</a>\n </li>\n <li>\n <a href=\"http://grafana.org/docs/features/opentsdb\" target=\"_blank\">OpenTSDB</a>\n </li>\n </ul>\n </div>\n</div>", | |
| "style": {}, | |
| "title": "Documentation Links" | |
| }, | |
| { | |
| "error": false, | |
| "span": 6, | |
| "editable": true, | |
| "type": "text", | |
| "mode": "html", | |
| "content": "<br/>\n\n<div class=\"row-fluid\">\n <div class=\"span12\">\n <ul>\n <li>Ctrl+S saves the current dashboard</li>\n <li>Ctrl+F Opens the dashboard finder</li>\n <li>Ctrl+H Hide/show row controls</li>\n <li>Click and drag graph title to move panel</li>\n <li>Hit Escape to exit graph when in fullscreen or edit mode</li>\n <li>Click the colored icon in the legend to change series color</li>\n <li>Ctrl or Shift + Click legend name to hide other series</li>\n </ul>\n </div>\n</div>\n", | |
| "style": {}, | |
| "title": "Tips & Shortcuts" | |
| } | |
| ], | |
| "notice": false | |
| }, | |
| { | |
| "title": "Connections", | |
| "height": "250px", | |
| "editable": true, | |
| "collapse": false, | |
| "panels": [ | |
| { | |
| "span": 6, | |
| "editable": true, | |
| "type": "graph", | |
| "loadingEditor": false, | |
| "datasource": null, | |
| "renderer": "flot", | |
| "x-axis": true, | |
| "y-axis": true, | |
| "scale": 1, | |
| "y_formats": [ | |
| "short", | |
| "short" | |
| ], | |
| "grid": { | |
| "leftMax": null, | |
| "rightMax": null, | |
| "leftMin": null, | |
| "rightMin": null, | |
| "threshold1": null, | |
| "threshold2": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "annotate": { | |
| "enable": false | |
| }, | |
| "resolution": 100, | |
| "lines": true, | |
| "fill": 0, | |
| "linewidth": 1, | |
| "points": false, | |
| "pointradius": 5, | |
| "bars": false, | |
| "stack": false, | |
| "legend": { | |
| "show": true, | |
| "values": false, | |
| "min": false, | |
| "max": false, | |
| "current": false, | |
| "total": false, | |
| "avg": false | |
| }, | |
| "percentage": false, | |
| "zerofill": true, | |
| "nullPointMode": "connected", | |
| "steppedLine": false, | |
| "tooltip": { | |
| "value_type": "cumulative", | |
| "query_as_alias": true | |
| }, | |
| "targets": [ | |
| { | |
| "target": "alias(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.max.connections,'max.connections')" | |
| }, | |
| { | |
| "target": "alias(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.core.aborted_clients),'aborted_clients')" | |
| }, | |
| { | |
| "target": "alias(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.core.connections),'core.connections')" | |
| }, | |
| { | |
| "target": "alias(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.threads.connected,'threads.connected')" | |
| } | |
| ], | |
| "aliasColors": {}, | |
| "aliasYAxis": {}, | |
| "title": "Connections" | |
| }, | |
| { | |
| "span": 6, | |
| "editable": true, | |
| "type": "graph", | |
| "datasource": null, | |
| "renderer": "flot", | |
| "x-axis": true, | |
| "y-axis": true, | |
| "scale": 1, | |
| "y_formats": [ | |
| "short", | |
| "short" | |
| ], | |
| "grid": { | |
| "leftMax": null, | |
| "rightMax": null, | |
| "leftMin": null, | |
| "rightMin": null, | |
| "threshold1": null, | |
| "threshold2": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "annotate": { | |
| "enable": false | |
| }, | |
| "resolution": 100, | |
| "lines": true, | |
| "fill": 0, | |
| "linewidth": 1, | |
| "points": false, | |
| "pointradius": 5, | |
| "bars": false, | |
| "stack": false, | |
| "legend": { | |
| "show": true, | |
| "values": false, | |
| "min": false, | |
| "max": false, | |
| "current": false, | |
| "total": false, | |
| "avg": false | |
| }, | |
| "percentage": false, | |
| "zerofill": true, | |
| "nullPointMode": "connected", | |
| "steppedLine": false, | |
| "tooltip": { | |
| "value_type": "cumulative", | |
| "query_as_alias": true | |
| }, | |
| "targets": [ | |
| { | |
| "target": "rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.qcache.free_blocks" | |
| } | |
| ], | |
| "aliasColors": {}, | |
| "aliasYAxis": {}, | |
| "title": "MySQL Threads" | |
| } | |
| ] | |
| }, | |
| { | |
| "title": "Query Cache Perf", | |
| "height": "250px", | |
| "editable": true, | |
| "collapse": false, | |
| "panels": [ | |
| { | |
| "span": 6, | |
| "editable": true, | |
| "type": "graph", | |
| "loadingEditor": false, | |
| "datasource": null, | |
| "renderer": "flot", | |
| "x-axis": true, | |
| "y-axis": true, | |
| "scale": 1, | |
| "y_formats": [ | |
| "short", | |
| "short" | |
| ], | |
| "grid": { | |
| "leftMax": null, | |
| "rightMax": null, | |
| "leftMin": null, | |
| "rightMin": null, | |
| "threshold1": null, | |
| "threshold2": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "annotate": { | |
| "enable": false | |
| }, | |
| "resolution": 100, | |
| "lines": true, | |
| "fill": 0, | |
| "linewidth": 1, | |
| "points": false, | |
| "pointradius": 5, | |
| "bars": false, | |
| "stack": false, | |
| "legend": { | |
| "show": true, | |
| "values": false, | |
| "min": false, | |
| "max": false, | |
| "current": false, | |
| "total": false, | |
| "avg": false | |
| }, | |
| "percentage": false, | |
| "zerofill": true, | |
| "nullPointMode": "connected", | |
| "steppedLine": false, | |
| "tooltip": { | |
| "value_type": "cumulative", | |
| "query_as_alias": true | |
| }, | |
| "targets": [ | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.qcache.inserts),9)", | |
| "hide": false | |
| }, | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.qcache.hits),9)" | |
| }, | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.qcache.queries_in_cache),9)" | |
| }, | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.qcache.total_blocks),9)" | |
| } | |
| ], | |
| "aliasColors": {}, | |
| "aliasYAxis": {}, | |
| "title": "Query Cache Perf" | |
| }, | |
| { | |
| "span": 6, | |
| "editable": true, | |
| "type": "graph", | |
| "loadingEditor": false, | |
| "datasource": null, | |
| "renderer": "flot", | |
| "x-axis": true, | |
| "y-axis": true, | |
| "scale": 1, | |
| "y_formats": [ | |
| "short", | |
| "short" | |
| ], | |
| "grid": { | |
| "leftMax": null, | |
| "rightMax": null, | |
| "leftMin": null, | |
| "rightMin": null, | |
| "threshold1": null, | |
| "threshold2": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "annotate": { | |
| "enable": false | |
| }, | |
| "resolution": 100, | |
| "lines": true, | |
| "fill": 0, | |
| "linewidth": 1, | |
| "points": false, | |
| "pointradius": 5, | |
| "bars": false, | |
| "stack": false, | |
| "legend": { | |
| "show": true, | |
| "values": false, | |
| "min": false, | |
| "max": false, | |
| "current": false, | |
| "total": false, | |
| "avg": false | |
| }, | |
| "percentage": false, | |
| "zerofill": true, | |
| "nullPointMode": "connected", | |
| "steppedLine": false, | |
| "tooltip": { | |
| "value_type": "cumulative", | |
| "query_as_alias": true | |
| }, | |
| "targets": [ | |
| { | |
| "target": "aliasByMetric(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.qcache.not_cached)" | |
| }, | |
| { | |
| "target": "aliasByMetric(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.qcache.size)" | |
| }, | |
| { | |
| "target": "aliasByMetric(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.qcache.lowmem_prunes)" | |
| }, | |
| { | |
| "target": "aliasByMetric(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.qcache.free_memory)" | |
| } | |
| ], | |
| "aliasColors": {}, | |
| "aliasYAxis": {}, | |
| "title": "Query Cache Memory" | |
| } | |
| ] | |
| }, | |
| { | |
| "title": "", | |
| "height": "250px", | |
| "editable": true, | |
| "collapse": false, | |
| "panels": [ | |
| { | |
| "span": 6, | |
| "editable": true, | |
| "type": "graph", | |
| "loadingEditor": false, | |
| "datasource": null, | |
| "renderer": "flot", | |
| "x-axis": true, | |
| "y-axis": true, | |
| "scale": 1, | |
| "y_formats": [ | |
| "short", | |
| "short" | |
| ], | |
| "grid": { | |
| "leftMax": null, | |
| "rightMax": null, | |
| "leftMin": null, | |
| "rightMin": null, | |
| "threshold1": null, | |
| "threshold2": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "annotate": { | |
| "enable": false | |
| }, | |
| "resolution": 100, | |
| "lines": true, | |
| "fill": 0, | |
| "linewidth": 1, | |
| "points": false, | |
| "pointradius": 5, | |
| "bars": false, | |
| "stack": false, | |
| "legend": { | |
| "show": true, | |
| "values": false, | |
| "min": false, | |
| "max": false, | |
| "current": false, | |
| "total": false, | |
| "avg": false | |
| }, | |
| "percentage": false, | |
| "zerofill": true, | |
| "nullPointMode": "connected", | |
| "steppedLine": false, | |
| "tooltip": { | |
| "value_type": "cumulative", | |
| "query_as_alias": true | |
| }, | |
| "targets": [ | |
| { | |
| "target": "derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.core.queries)" | |
| } | |
| ], | |
| "aliasColors": {}, | |
| "aliasYAxis": {}, | |
| "title": "Queries" | |
| }, | |
| { | |
| "span": 6, | |
| "editable": true, | |
| "type": "graph", | |
| "datasource": null, | |
| "renderer": "flot", | |
| "x-axis": true, | |
| "y-axis": true, | |
| "scale": 1, | |
| "y_formats": [ | |
| "s", | |
| "short" | |
| ], | |
| "grid": { | |
| "leftMax": null, | |
| "rightMax": null, | |
| "leftMin": 0, | |
| "rightMin": null, | |
| "threshold1": null, | |
| "threshold2": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "annotate": { | |
| "enable": false | |
| }, | |
| "resolution": 100, | |
| "lines": true, | |
| "fill": 0, | |
| "linewidth": 1, | |
| "points": false, | |
| "pointradius": 5, | |
| "bars": false, | |
| "stack": false, | |
| "legend": { | |
| "show": true, | |
| "values": false, | |
| "min": false, | |
| "max": false, | |
| "current": false, | |
| "total": false, | |
| "avg": false | |
| }, | |
| "percentage": false, | |
| "zerofill": true, | |
| "nullPointMode": "connected", | |
| "steppedLine": false, | |
| "tooltip": { | |
| "value_type": "cumulative", | |
| "query_as_alias": true | |
| }, | |
| "targets": [ | |
| { | |
| "target": "rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.core.uptime" | |
| } | |
| ], | |
| "aliasColors": {}, | |
| "aliasYAxis": {}, | |
| "title": "Uptime" | |
| } | |
| ] | |
| }, | |
| { | |
| "title": "New row", | |
| "height": "250px", | |
| "editable": true, | |
| "collapse": false, | |
| "panels": [ | |
| { | |
| "span": 6, | |
| "editable": true, | |
| "type": "graph", | |
| "loadingEditor": false, | |
| "datasource": null, | |
| "renderer": "flot", | |
| "x-axis": true, | |
| "y-axis": true, | |
| "scale": 1, | |
| "y_formats": [ | |
| "short", | |
| "short" | |
| ], | |
| "grid": { | |
| "leftMax": null, | |
| "rightMax": null, | |
| "leftMin": null, | |
| "rightMin": null, | |
| "threshold1": null, | |
| "threshold2": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "annotate": { | |
| "enable": false | |
| }, | |
| "resolution": 100, | |
| "lines": true, | |
| "fill": 0, | |
| "linewidth": 1, | |
| "points": false, | |
| "pointradius": 5, | |
| "bars": false, | |
| "stack": false, | |
| "legend": { | |
| "show": true, | |
| "values": false, | |
| "min": false, | |
| "max": false, | |
| "current": false, | |
| "total": false, | |
| "avg": false | |
| }, | |
| "percentage": false, | |
| "zerofill": true, | |
| "nullPointMode": "connected", | |
| "steppedLine": false, | |
| "tooltip": { | |
| "value_type": "cumulative", | |
| "query_as_alias": true | |
| }, | |
| "targets": [ | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.handler.write),9)" | |
| }, | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.handler.read_prev),9)" | |
| }, | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.handler.read_next),9)" | |
| }, | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.handler.delete),9)" | |
| }, | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.handler.read_rnd),9)" | |
| }, | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.handler.read_first),9)" | |
| }, | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.handler.read_key),9)" | |
| }, | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.handler.update),9)" | |
| }, | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.handler.read_rnd_next),9)" | |
| } | |
| ], | |
| "aliasColors": {}, | |
| "aliasYAxis": {}, | |
| "title": "MySQL Handlers" | |
| }, | |
| { | |
| "span": 6, | |
| "editable": true, | |
| "type": "graph", | |
| "datasource": null, | |
| "renderer": "flot", | |
| "x-axis": true, | |
| "y-axis": true, | |
| "scale": 1, | |
| "y_formats": [ | |
| "short", | |
| "short" | |
| ], | |
| "grid": { | |
| "leftMax": null, | |
| "rightMax": null, | |
| "leftMin": null, | |
| "rightMin": null, | |
| "threshold1": null, | |
| "threshold2": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "annotate": { | |
| "enable": false | |
| }, | |
| "resolution": 100, | |
| "lines": true, | |
| "fill": 0, | |
| "linewidth": 1, | |
| "points": false, | |
| "pointradius": 5, | |
| "bars": false, | |
| "stack": false, | |
| "legend": { | |
| "show": true, | |
| "values": false, | |
| "min": false, | |
| "max": false, | |
| "current": false, | |
| "total": false, | |
| "avg": false | |
| }, | |
| "percentage": false, | |
| "zerofill": true, | |
| "nullPointMode": "connected", | |
| "steppedLine": false, | |
| "tooltip": { | |
| "value_type": "cumulative", | |
| "query_as_alias": true | |
| }, | |
| "targets": [ | |
| { | |
| "target": "aliasByNode(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.handler.savepoint_rollback,9)" | |
| }, | |
| { | |
| "target": "aliasByNode(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.handler.rollback,9)" | |
| }, | |
| { | |
| "target": "aliasByNode(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.handler.savepoint,9)" | |
| }, | |
| { | |
| "target": "aliasByNode(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.handler.commit,9)" | |
| } | |
| ], | |
| "aliasColors": {}, | |
| "aliasYAxis": {}, | |
| "title": "MySQL Transaction Handler" | |
| } | |
| ] | |
| }, | |
| { | |
| "title": "New row", | |
| "height": "250px", | |
| "editable": true, | |
| "collapse": false, | |
| "panels": [ | |
| { | |
| "span": 6, | |
| "editable": true, | |
| "type": "graph", | |
| "datasource": null, | |
| "renderer": "flot", | |
| "x-axis": true, | |
| "y-axis": true, | |
| "scale": 1, | |
| "y_formats": [ | |
| "short", | |
| "short" | |
| ], | |
| "grid": { | |
| "leftMax": null, | |
| "rightMax": null, | |
| "leftMin": null, | |
| "rightMin": null, | |
| "threshold1": null, | |
| "threshold2": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "annotate": { | |
| "enable": false | |
| }, | |
| "resolution": 100, | |
| "lines": true, | |
| "fill": 0, | |
| "linewidth": 1, | |
| "points": false, | |
| "pointradius": 5, | |
| "bars": false, | |
| "stack": false, | |
| "legend": { | |
| "show": true, | |
| "values": false, | |
| "min": false, | |
| "max": false, | |
| "current": false, | |
| "total": false, | |
| "avg": false | |
| }, | |
| "percentage": false, | |
| "zerofill": true, | |
| "nullPointMode": "connected", | |
| "steppedLine": false, | |
| "tooltip": { | |
| "value_type": "cumulative", | |
| "query_as_alias": true | |
| }, | |
| "targets": [ | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.handler.read_rnd),9)" | |
| }, | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.handler.read_rnd_next),9)" | |
| } | |
| ], | |
| "aliasColors": {}, | |
| "aliasYAxis": {}, | |
| "title": "MySQL Table Scans" | |
| }, | |
| { | |
| "span": 6, | |
| "editable": true, | |
| "type": "graph", | |
| "datasource": null, | |
| "renderer": "flot", | |
| "x-axis": true, | |
| "y-axis": true, | |
| "scale": 1, | |
| "y_formats": [ | |
| "short", | |
| "short" | |
| ], | |
| "grid": { | |
| "leftMax": null, | |
| "rightMax": null, | |
| "leftMin": null, | |
| "rightMin": null, | |
| "threshold1": null, | |
| "threshold2": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "annotate": { | |
| "enable": false | |
| }, | |
| "resolution": 100, | |
| "lines": true, | |
| "fill": 0, | |
| "linewidth": 1, | |
| "points": false, | |
| "pointradius": 5, | |
| "bars": false, | |
| "stack": false, | |
| "legend": { | |
| "show": true, | |
| "values": false, | |
| "min": false, | |
| "max": false, | |
| "current": false, | |
| "total": false, | |
| "avg": false | |
| }, | |
| "percentage": false, | |
| "zerofill": true, | |
| "nullPointMode": "connected", | |
| "steppedLine": false, | |
| "tooltip": { | |
| "value_type": "cumulative", | |
| "query_as_alias": true | |
| }, | |
| "targets": [ | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.threads.created),9)" | |
| }, | |
| { | |
| "target": "aliasByNode(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.threads.running,9)" | |
| }, | |
| { | |
| "target": "aliasByNode(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.thread.cache_size,9)" | |
| } | |
| ], | |
| "aliasColors": {}, | |
| "aliasYAxis": {}, | |
| "title": "MySQL Threads" | |
| } | |
| ] | |
| }, | |
| { | |
| "title": "New row", | |
| "height": "250px", | |
| "editable": true, | |
| "collapse": false, | |
| "panels": [ | |
| { | |
| "span": 6, | |
| "editable": true, | |
| "type": "graph", | |
| "datasource": null, | |
| "renderer": "flot", | |
| "x-axis": true, | |
| "y-axis": true, | |
| "scale": 1, | |
| "y_formats": [ | |
| "short", | |
| "short" | |
| ], | |
| "grid": { | |
| "leftMax": null, | |
| "rightMax": null, | |
| "leftMin": null, | |
| "rightMin": null, | |
| "threshold1": null, | |
| "threshold2": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "annotate": { | |
| "enable": false | |
| }, | |
| "resolution": 100, | |
| "lines": true, | |
| "fill": 0, | |
| "linewidth": 1, | |
| "points": false, | |
| "pointradius": 5, | |
| "bars": false, | |
| "stack": false, | |
| "legend": { | |
| "show": true, | |
| "values": false, | |
| "min": false, | |
| "max": false, | |
| "current": false, | |
| "total": false, | |
| "avg": false | |
| }, | |
| "percentage": false, | |
| "zerofill": true, | |
| "nullPointMode": "connected", | |
| "steppedLine": false, | |
| "tooltip": { | |
| "value_type": "cumulative", | |
| "query_as_alias": true | |
| }, | |
| "targets": [ | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.bytes.received),9)" | |
| }, | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.bytes.sent),9)" | |
| } | |
| ], | |
| "aliasColors": {}, | |
| "aliasYAxis": {}, | |
| "title": "MySQL Network Traffic" | |
| }, | |
| { | |
| "span": 6, | |
| "editable": true, | |
| "type": "graph", | |
| "datasource": null, | |
| "renderer": "flot", | |
| "x-axis": true, | |
| "y-axis": true, | |
| "scale": 1, | |
| "y_formats": [ | |
| "short", | |
| "short" | |
| ], | |
| "grid": { | |
| "leftMax": null, | |
| "rightMax": null, | |
| "leftMin": null, | |
| "rightMin": null, | |
| "threshold1": null, | |
| "threshold2": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "annotate": { | |
| "enable": false | |
| }, | |
| "resolution": 100, | |
| "lines": true, | |
| "fill": 0, | |
| "linewidth": 1, | |
| "points": false, | |
| "pointradius": 5, | |
| "bars": false, | |
| "stack": false, | |
| "legend": { | |
| "show": true, | |
| "values": false, | |
| "min": false, | |
| "max": false, | |
| "current": false, | |
| "total": false, | |
| "avg": false | |
| }, | |
| "percentage": false, | |
| "zerofill": true, | |
| "nullPointMode": "connected", | |
| "steppedLine": false, | |
| "tooltip": { | |
| "value_type": "cumulative", | |
| "query_as_alias": true | |
| }, | |
| "targets": [ | |
| { | |
| "target": "rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.innodb.buffer_pool_pages_flushed" | |
| } | |
| ], | |
| "aliasColors": {}, | |
| "aliasYAxis": {}, | |
| "title": "InnoDB Buffer Pool Page Statistics" | |
| } | |
| ] | |
| }, | |
| { | |
| "title": "New row", | |
| "height": "250px", | |
| "editable": true, | |
| "collapse": false, | |
| "panels": [ | |
| { | |
| "span": 6, | |
| "editable": true, | |
| "type": "graph", | |
| "datasource": null, | |
| "renderer": "flot", | |
| "x-axis": true, | |
| "y-axis": true, | |
| "scale": 1, | |
| "y_formats": [ | |
| "short", | |
| "short" | |
| ], | |
| "grid": { | |
| "leftMax": null, | |
| "rightMax": null, | |
| "leftMin": null, | |
| "rightMin": null, | |
| "threshold1": null, | |
| "threshold2": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "annotate": { | |
| "enable": false | |
| }, | |
| "resolution": 100, | |
| "lines": true, | |
| "fill": 0, | |
| "linewidth": 1, | |
| "points": false, | |
| "pointradius": 5, | |
| "bars": false, | |
| "stack": false, | |
| "legend": { | |
| "show": true, | |
| "values": false, | |
| "min": false, | |
| "max": false, | |
| "current": false, | |
| "total": false, | |
| "avg": false | |
| }, | |
| "percentage": false, | |
| "zerofill": true, | |
| "nullPointMode": "connected", | |
| "steppedLine": false, | |
| "tooltip": { | |
| "value_type": "cumulative", | |
| "query_as_alias": true | |
| }, | |
| "targets": [ | |
| { | |
| "target": "aliasByNode(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.innodb.data_pending_fsyncs,9)" | |
| }, | |
| { | |
| "target": "aliasByNode(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.innodb.buffer_pool_reads,9)" | |
| }, | |
| { | |
| "target": "aliasByNode(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.innodb.os_log_pending_fsyncs,9)" | |
| }, | |
| { | |
| "target": "aliasByNode(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.innodb.data_pending_writes,9)" | |
| }, | |
| { | |
| "target": "aliasByNode(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.innodb.os_log_pending_writes,9)" | |
| } | |
| ], | |
| "aliasColors": {}, | |
| "aliasYAxis": {}, | |
| "title": "Innodb I/O Pending" | |
| }, | |
| { | |
| "span": 6, | |
| "editable": true, | |
| "type": "graph", | |
| "datasource": null, | |
| "renderer": "flot", | |
| "x-axis": true, | |
| "y-axis": true, | |
| "scale": 1, | |
| "y_formats": [ | |
| "short", | |
| "short" | |
| ], | |
| "grid": { | |
| "leftMax": null, | |
| "rightMax": null, | |
| "leftMin": null, | |
| "rightMin": null, | |
| "threshold1": null, | |
| "threshold2": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "annotate": { | |
| "enable": false | |
| }, | |
| "resolution": 100, | |
| "lines": true, | |
| "fill": 0, | |
| "linewidth": 1, | |
| "points": false, | |
| "pointradius": 5, | |
| "bars": false, | |
| "stack": false, | |
| "legend": { | |
| "show": true, | |
| "values": false, | |
| "min": false, | |
| "max": false, | |
| "current": false, | |
| "total": false, | |
| "avg": false | |
| }, | |
| "percentage": false, | |
| "zerofill": true, | |
| "nullPointMode": "connected", | |
| "steppedLine": false, | |
| "tooltip": { | |
| "value_type": "cumulative", | |
| "query_as_alias": true | |
| }, | |
| "targets": [ | |
| { | |
| "target": "aliasByNode(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.innodb.buffer_pool_size,9)" | |
| }, | |
| { | |
| "target": "aliasByNode(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.innodb.buffer_pool_pages_data,9)" | |
| }, | |
| { | |
| "target": "aliasByNode(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.innodb.buffer_pool_pages_total,9)" | |
| }, | |
| { | |
| "target": "aliasByNode(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.innodb.buffer_pool_pages_dirty,9)" | |
| }, | |
| { | |
| "target": "aliasByNode(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.innodb.buffer_pool_pages_free,9)" | |
| } | |
| ], | |
| "aliasColors": {}, | |
| "aliasYAxis": {}, | |
| "title": "InnoDB Buffer Pool Pages" | |
| } | |
| ] | |
| }, | |
| { | |
| "title": "New row", | |
| "height": "250px", | |
| "editable": true, | |
| "collapse": false, | |
| "panels": [ | |
| { | |
| "span": 6, | |
| "editable": true, | |
| "type": "graph", | |
| "datasource": null, | |
| "renderer": "flot", | |
| "x-axis": true, | |
| "y-axis": true, | |
| "scale": 1, | |
| "y_formats": [ | |
| "short", | |
| "short" | |
| ], | |
| "grid": { | |
| "leftMax": null, | |
| "rightMax": null, | |
| "leftMin": 0, | |
| "rightMin": null, | |
| "threshold1": null, | |
| "threshold2": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "annotate": { | |
| "enable": false | |
| }, | |
| "resolution": 100, | |
| "lines": true, | |
| "fill": 0, | |
| "linewidth": 1, | |
| "points": false, | |
| "pointradius": 5, | |
| "bars": false, | |
| "stack": false, | |
| "legend": { | |
| "show": true, | |
| "values": false, | |
| "min": false, | |
| "max": false, | |
| "current": false, | |
| "total": false, | |
| "avg": false | |
| }, | |
| "percentage": false, | |
| "zerofill": true, | |
| "nullPointMode": "connected", | |
| "steppedLine": false, | |
| "tooltip": { | |
| "value_type": "cumulative", | |
| "query_as_alias": true | |
| }, | |
| "targets": [ | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.innodb.pages_created),9)" | |
| }, | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.innodb.pages_read),9)" | |
| }, | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.innodb.pages_written),9)" | |
| } | |
| ], | |
| "aliasColors": {}, | |
| "aliasYAxis": {}, | |
| "title": "InnoDB Buffer Pool Activity" | |
| }, | |
| { | |
| "span": 6, | |
| "editable": true, | |
| "type": "graph", | |
| "datasource": null, | |
| "renderer": "flot", | |
| "x-axis": true, | |
| "y-axis": true, | |
| "scale": 1, | |
| "y_formats": [ | |
| "short", | |
| "short" | |
| ], | |
| "grid": { | |
| "leftMax": null, | |
| "rightMax": null, | |
| "leftMin": 0, | |
| "rightMin": null, | |
| "threshold1": null, | |
| "threshold2": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "annotate": { | |
| "enable": false | |
| }, | |
| "resolution": 100, | |
| "lines": true, | |
| "fill": 0, | |
| "linewidth": 1, | |
| "points": false, | |
| "pointradius": 5, | |
| "bars": false, | |
| "stack": false, | |
| "legend": { | |
| "show": true, | |
| "values": false, | |
| "min": false, | |
| "max": false, | |
| "current": false, | |
| "total": false, | |
| "avg": false | |
| }, | |
| "percentage": false, | |
| "zerofill": true, | |
| "nullPointMode": "connected", | |
| "steppedLine": false, | |
| "tooltip": { | |
| "value_type": "cumulative", | |
| "query_as_alias": true | |
| }, | |
| "targets": [ | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.innodb.rows_read),9)" | |
| }, | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.innodb.rows_inserted),9)" | |
| }, | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.innodb.rows_updated),9)" | |
| } | |
| ], | |
| "aliasColors": {}, | |
| "aliasYAxis": {}, | |
| "title": "InnoDB Row Details" | |
| } | |
| ] | |
| }, | |
| { | |
| "title": "New row", | |
| "height": "250px", | |
| "editable": true, | |
| "collapse": false, | |
| "panels": [ | |
| { | |
| "span": 6, | |
| "editable": true, | |
| "type": "graph", | |
| "datasource": null, | |
| "renderer": "flot", | |
| "x-axis": true, | |
| "y-axis": true, | |
| "scale": 1, | |
| "y_formats": [ | |
| "short", | |
| "short" | |
| ], | |
| "grid": { | |
| "leftMax": null, | |
| "rightMax": null, | |
| "leftMin": 0, | |
| "rightMin": null, | |
| "threshold1": null, | |
| "threshold2": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "annotate": { | |
| "enable": false | |
| }, | |
| "resolution": 100, | |
| "lines": true, | |
| "fill": 0, | |
| "linewidth": 1, | |
| "points": false, | |
| "pointradius": 5, | |
| "bars": false, | |
| "stack": false, | |
| "legend": { | |
| "show": true, | |
| "values": false, | |
| "min": false, | |
| "max": false, | |
| "current": false, | |
| "total": false, | |
| "avg": false | |
| }, | |
| "percentage": false, | |
| "zerofill": true, | |
| "nullPointMode": "connected", | |
| "steppedLine": false, | |
| "tooltip": { | |
| "value_type": "cumulative", | |
| "query_as_alias": true | |
| }, | |
| "targets": [ | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.innodb.row_lock_waits),9)" | |
| } | |
| ], | |
| "aliasColors": {}, | |
| "aliasYAxis": {}, | |
| "title": "Innodb Row Lock Waits" | |
| }, | |
| { | |
| "span": 6, | |
| "editable": true, | |
| "type": "graph", | |
| "datasource": null, | |
| "renderer": "flot", | |
| "x-axis": true, | |
| "y-axis": true, | |
| "scale": 1, | |
| "y_formats": [ | |
| "short", | |
| "short" | |
| ], | |
| "grid": { | |
| "leftMax": null, | |
| "rightMax": null, | |
| "leftMin": 0, | |
| "rightMin": null, | |
| "threshold1": null, | |
| "threshold2": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "annotate": { | |
| "enable": false | |
| }, | |
| "resolution": 100, | |
| "lines": true, | |
| "fill": 0, | |
| "linewidth": 1, | |
| "points": false, | |
| "pointradius": 5, | |
| "bars": false, | |
| "stack": false, | |
| "legend": { | |
| "show": true, | |
| "values": false, | |
| "min": false, | |
| "max": false, | |
| "current": false, | |
| "total": false, | |
| "avg": false | |
| }, | |
| "percentage": false, | |
| "zerofill": true, | |
| "nullPointMode": "connected", | |
| "steppedLine": false, | |
| "tooltip": { | |
| "value_type": "cumulative", | |
| "query_as_alias": true | |
| }, | |
| "targets": [ | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.innodb.buffer_pool_read_requests),9)" | |
| }, | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.innodb.buffer_pool_reads),9)" | |
| } | |
| ], | |
| "aliasColors": {}, | |
| "aliasYAxis": {}, | |
| "title": "InnoDB Buffer Pool Efficiency" | |
| } | |
| ] | |
| }, | |
| { | |
| "title": "New row", | |
| "height": "250px", | |
| "editable": true, | |
| "collapse": false, | |
| "panels": [ | |
| { | |
| "span": 6, | |
| "editable": true, | |
| "type": "graph", | |
| "datasource": null, | |
| "renderer": "flot", | |
| "x-axis": true, | |
| "y-axis": true, | |
| "scale": 1, | |
| "y_formats": [ | |
| "short", | |
| "short" | |
| ], | |
| "grid": { | |
| "leftMax": null, | |
| "rightMax": null, | |
| "leftMin": 0, | |
| "rightMin": null, | |
| "threshold1": null, | |
| "threshold2": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "annotate": { | |
| "enable": false | |
| }, | |
| "resolution": 100, | |
| "lines": true, | |
| "fill": 0, | |
| "linewidth": 1, | |
| "points": false, | |
| "pointradius": 5, | |
| "bars": false, | |
| "stack": false, | |
| "legend": { | |
| "show": true, | |
| "values": false, | |
| "min": false, | |
| "max": false, | |
| "current": false, | |
| "total": false, | |
| "avg": false | |
| }, | |
| "percentage": false, | |
| "zerofill": true, | |
| "nullPointMode": "connected", | |
| "steppedLine": false, | |
| "tooltip": { | |
| "value_type": "cumulative", | |
| "query_as_alias": true | |
| }, | |
| "targets": [ | |
| { | |
| "target": "aliasByNode(derivative(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.innodb.row_lock_time),9)" | |
| } | |
| ], | |
| "aliasColors": {}, | |
| "aliasYAxis": {}, | |
| "title": "InnoDB Row Lock Time" | |
| }, | |
| { | |
| "span": 6, | |
| "editable": true, | |
| "type": "graph", | |
| "datasource": null, | |
| "renderer": "flot", | |
| "x-axis": true, | |
| "y-axis": true, | |
| "scale": 1, | |
| "y_formats": [ | |
| "short", | |
| "short" | |
| ], | |
| "grid": { | |
| "leftMax": null, | |
| "rightMax": null, | |
| "leftMin": 0, | |
| "rightMin": null, | |
| "threshold1": null, | |
| "threshold2": null, | |
| "threshold1Color": "rgba(216, 200, 27, 0.27)", | |
| "threshold2Color": "rgba(234, 112, 112, 0.22)" | |
| }, | |
| "annotate": { | |
| "enable": false | |
| }, | |
| "resolution": 100, | |
| "lines": true, | |
| "fill": 0, | |
| "linewidth": 1, | |
| "points": false, | |
| "pointradius": 5, | |
| "bars": false, | |
| "stack": false, | |
| "legend": { | |
| "show": true, | |
| "values": false, | |
| "min": false, | |
| "max": false, | |
| "current": false, | |
| "total": false, | |
| "avg": false | |
| }, | |
| "percentage": false, | |
| "zerofill": true, | |
| "nullPointMode": "connected", | |
| "steppedLine": false, | |
| "tooltip": { | |
| "value_type": "cumulative", | |
| "query_as_alias": true | |
| }, | |
| "targets": [ | |
| { | |
| "target": "aliasByNode(rackspace.monitoring.entities.entityid.checks.agent.mysql.checkid.replication.*,9)" | |
| } | |
| ], | |
| "aliasColors": {}, | |
| "aliasYAxis": {}, | |
| "title": "MySQL Replication" | |
| } | |
| ] | |
| } | |
| ], | |
| "pulldowns": [ | |
| { | |
| "type": "filtering", | |
| "collapse": false, | |
| "notice": false, | |
| "enable": false | |
| }, | |
| { | |
| "type": "annotations", | |
| "enable": false | |
| } | |
| ], | |
| "nav": [ | |
| { | |
| "type": "timepicker", | |
| "collapse": false, | |
| "notice": false, | |
| "enable": true, | |
| "status": "Stable", | |
| "time_options": [ | |
| "5m", | |
| "15m", | |
| "1h", | |
| "6h", | |
| "12h", | |
| "24h", | |
| "2d", | |
| "7d", | |
| "30d" | |
| ], | |
| "refresh_intervals": [ | |
| "5s", | |
| "10s", | |
| "30s", | |
| "1m", | |
| "5m", | |
| "15m", | |
| "30m", | |
| "1h", | |
| "2h", | |
| "1d" | |
| ], | |
| "now": true | |
| } | |
| ], | |
| "time": { | |
| "from": "now-1h", | |
| "to": "now" | |
| }, | |
| "templating": { | |
| "list": [] | |
| }, | |
| "refresh": false, | |
| "version": 2 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment