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