<- Back to Templates
MySql
By KloudMate
The MySQL dashboard provides real-time visibility into database performance and resource utilization by leveraging OpenTelemetry (Otel) for metric collection.
Template JSON
{
"name": "MySQL",
"description": "",
"data": {
"tz": "local",
"links": [],
"panels": [
{
"id": "kd84l4rgf0twe",
"tz": "local",
"title": "Server Uptime",
"overrides": [],
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"format": "duration",
"rename": [],
"statView": "grid",
"baseColor": "#4CBB17",
"multiplyBy": "1000",
"calculation": "last",
"value_mappings": []
},
"description": "The number of seconds that the server has been up",
"node_configs": [
{
"exp": "mysql_uptime{host_name=\"$DBHOST\"}",
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "promql",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "s",
"field": "",
"value": "mysql_uptime",
"metric": "mysql_uptime",
"spatial": "SUM",
"temporal": "RATE",
"metricType": "sum",
"temporality": "cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series",
"promql_query_type": "instant"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "lortygjug7c1h",
"tz": "local",
"title": "MySQL Locks Rate",
"overrides": [],
"panelType": "STATS",
"timeRange": "3h",
"statConfig": {
"rename": [],
"suffix": "/s",
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last",
"value_mappings": []
},
"description": "rate of waited type locks",
"node_configs": [
{
"exp": "rate(mysql_locks{kind=\"waited\", host_name=\"$DBHOST\"}[5m])",
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "promql",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "1",
"field": "",
"value": "mysql_locks",
"metric": "mysql_locks",
"spatial": "SUM",
"temporal": "INCREASE",
"metricType": "sum",
"temporality": "cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series",
"promql_query_type": "instant"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "y7gd8kergqb8a",
"tz": "local",
"title": "MySQL Page Size",
"overrides": [],
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"format": "bytes",
"rename": [],
"decimals": "1",
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last",
"value_mappings": []
},
"description": "InnoDB page size",
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
}
],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "By",
"field": "",
"value": "mysql_page_size",
"metric": "mysql_page_size",
"ranking": {
"func": "None"
},
"spatial": "LAST",
"temporal": "AVG",
"metricType": "gauge",
"temporality": "unspecified"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "0db2hwslyhy4l",
"tz": "local",
"title": "Buffer Pool Limit",
"overrides": [],
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"format": "bytes",
"rename": [],
"decimals": "1",
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last",
"value_mappings": []
},
"description": "configured size of the InnoDB buffer pool",
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
}
],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "By",
"field": "",
"value": "mysql_buffer_pool_limit",
"metric": "mysql_buffer_pool_limit",
"spatial": "LAST",
"temporal": "AVG",
"metricType": "gauge",
"temporality": "unspecified"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "0xu822dv6c3fe",
"tz": "local",
"title": "Running Threads",
"overrides": [],
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"format": "number",
"rename": [],
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last",
"value_mappings": []
},
"description": "no. of running threads",
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
},
{
"type": "string",
"field": "kind",
"value": "running",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "kind"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "1",
"field": "",
"value": "mysql_threads",
"metric": "mysql_threads",
"ranking": {
"func": "None"
},
"spatial": "LAST",
"temporal": "AVG",
"metricType": "gauge",
"temporality": "unspecified"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "o5mc2be12vbmf",
"tz": "local",
"axis": {
"x": {
"max": "",
"min": "",
"date_style": "auto",
"bucketCount": "30",
"bucketOffset": "0"
},
"y": {
"format": "number",
"prefix": "",
"suffix": " ops/s",
"decimals": "1",
"multiplyBy": 1
}
},
"title": "MySQL Operations",
"tooltip": {
"mode": "single"
},
"overrides": [],
"panelType": "TimeSeries",
"timeRange": "3h",
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "The number of InnoDB operations",
"node_configs": [
{
"exp": "rate(mysql_operations{operation=~\"fsyncs|reads|writes\", host_name=\"$DBHOST\"}[5m])",
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [],
"groupBy": [
{
"type": "string",
"field": "operation"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "promql",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "1",
"field": "",
"value": "mysql_operations",
"metric": "mysql_operations",
"ranking": {
"func": "None"
},
"spatial": "SUM",
"temporal": "INCREASE",
"metricType": "sum",
"temporality": "cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{operation}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "1qtsv1pk40thh",
"tz": "local",
"axis": {
"x": {
"max": "",
"min": "",
"date_style": "auto",
"bucketCount": "30",
"bucketOffset": "0"
},
"y": {
"format": "number",
"suffix": " req/s",
"decimals": ""
}
},
"title": "MySQL Handlers",
"tooltip": {
"mode": "all"
},
"overrides": [],
"panelType": "TimeSeries",
"timeRange": "30m",
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "no. of requests per sec to various MySQL handlers",
"node_configs": [
{
"exp": "mysql_handlers",
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
},
{
"type": "string",
"field": "kind",
"value": "commit",
"operator": "="
},
{
"type": "string",
"field": "kind",
"value": "rollback",
"operator": "="
},
{
"type": "string",
"field": "kind",
"value": "write",
"operator": "="
},
{
"type": "string",
"field": "kind",
"value": "update",
"operator": "="
},
{
"type": "string",
"field": "kind",
"value": "delete",
"operator": "="
},
{
"type": "string",
"field": "kind",
"value": "read_key",
"operator": "="
},
{
"type": "string",
"field": "kind",
"value": "read_rnd_next",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "kind"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "1",
"field": "",
"value": "mysql_handlers",
"metric": "mysql_handlers",
"ranking": {
"func": "None"
},
"spatial": "SUM",
"temporal": "RATE",
"metricType": "sum",
"temporality": "cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{kind}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "63kj1bnf1pi6u",
"tz": "local",
"axis": {
"x": {
"max": "",
"min": "",
"date_style": "auto",
"bucketCount": "30",
"bucketOffset": "0"
},
"y": {
"format": "number",
"suffix": " ops/s",
"decimals": "1"
}
},
"title": "Row Operations",
"tooltip": {
"mode": "all"
},
"overrides": [],
"panelType": "TimeSeries",
"timeRange": "10m",
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "no. of InnoDB row operations per sec",
"node_configs": [
{
"exp": "rate(mysql_row_operations[5m])",
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "operation"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "1",
"field": "",
"value": "mysql_row_operations",
"metric": "mysql_row_operations",
"ranking": {
"func": "None"
},
"spatial": "SUM",
"temporal": "RATE",
"metricType": "sum",
"temporality": "cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{operation}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "yfomjhvk2pmg3",
"tz": "local",
"table": {
"columns": [
{
"key": "table",
"rename": ""
},
{
"key": "A:LAST()",
"rename": "no. of rows"
}
]
},
"title": "Table Rows by Schema",
"panelType": "table",
"timeRange": "1h",
"description": "no. of rows for a given table",
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
},
{
"type": "string",
"field": "schema",
"value": "$Schema",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "table"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "LAST",
"type": "",
"unit": "1",
"field": "",
"value": "mysql_table_rows",
"metric": "mysql_table_rows",
"ranking": {
"func": "TopK",
"value": 10
},
"spatial": "LAST",
"temporal": "AVG",
"metricType": "gauge",
"temporality": "unspecified"
},
"datasourceId": "kloudmate",
"responseType": "number"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "gkwx1zkls4mmo",
"tz": "local",
"table": {
"columns": [
{
"key": "table",
"rename": ""
},
{
"key": "A",
"format": {
"format": "bytes",
"decimals": "1"
},
"rename": "Index size"
},
{
"key": "B",
"format": {
"format": "bytes",
"decimals": "1"
},
"rename": "Data size"
}
]
},
"title": "Table Size by schema",
"panelType": "table",
"timeRange": "2h",
"description": "table size in bytes for a given table",
"node_configs": [
{
"exp": "sum(mysql_table_size{schema=\"$Schema\", kind=\"index\", host_name=\"$DBHOST\"}) by (table)",
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "promql",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"field": "",
"spatial": "AVG",
"temporal": "AVG"
},
"datasourceId": "kloudmate",
"responseType": "number"
},
{
"exp": "sum(mysql_table_size{schema=\"$Schema\", kind=\"data\", host_name=\"$DBHOST\"}) by (table)",
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "B",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "promql",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"field": ""
},
"datasourceId": "kloudmate",
"responseType": "number"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "00lk1jm2po711",
"tz": "local",
"title": "Cache Hits",
"overrides": [],
"panelType": "STATS",
"timeRange": "15m",
"statConfig": {
"rename": [],
"suffix": "%",
"decimals": "0",
"statView": "grid",
"baseColor": "#4CBB17",
"multiplyBy": "100",
"calculation": "last",
"value_mappings": []
},
"description": "hit % for open tables cache lookups",
"node_configs": [
{
"exp": "mysql_table_open_cache{status=\"hit\", host_name=\"$DBHOST\"}",
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": true,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "promql",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"field": "",
"spatial": "AVG",
"temporal": "AVG"
},
"datasourceId": "kloudmate",
"responseType": "series",
"promql_query_type": "instant"
},
{
"exp": "mysql_table_open_cache{host_name=\"$DBHOST\"}\n",
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": true,
"metric": "",
"nodeId": "B",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "promql",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"field": "",
"spatial": "AVG",
"temporal": "AVG"
},
"datasourceId": "kloudmate",
"responseType": "series",
"promql_query_type": "instant"
},
{
"type": "expression",
"hidden": false,
"nodeId": "C",
"reducer": "last",
"expression": "$A/$B",
"expressionType": "math"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "d1x792guulhk3",
"tz": "local",
"title": "Page Size",
"overrides": [],
"panelType": "STATS",
"timeRange": "2h",
"statConfig": {
"format": "bytes",
"rename": [],
"decimals": "1",
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last",
"value_mappings": []
},
"description": "InnoDB page size",
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
}
],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "By",
"field": "",
"value": "mysql_page_size",
"metric": "mysql_page_size",
"spatial": "LAST",
"temporal": "AVG",
"metricType": "gauge",
"temporality": "unspecified"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "dhtwp150mqzuu",
"tz": "local",
"axis": {
"x": {
"max": "",
"min": "",
"date_style": "auto",
"bucketCount": "30",
"bucketOffset": "0"
},
"y": {
"format": "number",
"suffix": " ops/s",
"decimals": "1"
}
},
"title": "MySQL Sorts",
"tooltip": {
"mode": "all"
},
"overrides": [],
"panelType": "TimeSeries",
"timeRange": "1h",
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "no. of MySQL sorts",
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "kind"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "1",
"field": "",
"value": "mysql_sorts",
"metric": "mysql_sorts",
"ranking": {
"func": "None"
},
"spatial": "SUM",
"temporal": "RATE",
"metricType": "sum",
"temporality": "cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{kind}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "uejh6de6jww7u",
"tz": "local",
"axis": {
"x": {
"max": "",
"min": "",
"date_style": "auto",
"bucketCount": "30",
"bucketOffset": "0"
},
"y": {
"format": "bytes",
"suffix": "/s",
"decimals": "1"
}
},
"title": "Network IO",
"tooltip": {
"mode": "all"
},
"overrides": [],
"panelType": "TimeSeries",
"timeRange": "1h",
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "no. of transmitted bytes between server and clients",
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "kind"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "By",
"field": "",
"value": "mysql_client_network_io",
"metric": "mysql_client_network_io",
"ranking": {
"func": "None"
},
"spatial": "SUM",
"temporal": "RATE",
"metricType": "sum",
"temporality": "cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{kind}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "6x86n8kdntbrn",
"tz": "local",
"axis": {
"x": {
"max": "",
"min": "",
"date_style": "auto",
"bucketCount": "30",
"bucketOffset": "0"
},
"y": {
"format": "number",
"suffix": " err/s",
"decimals": "0"
}
},
"title": "Connection Error",
"tooltip": {
"mode": "all"
},
"overrides": [],
"panelType": "TimeSeries",
"timeRange": "1h",
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "errors that occur during the client connection process",
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"limit": null,
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"columns": [],
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "host_name",
"value": "$DBHOST",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "error"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"distinctBy": null,
"metricType": "",
"query_type": "qb",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "1",
"field": "",
"value": "mysql_connection_errors",
"metric": "mysql_connection_errors",
"ranking": {
"func": "None"
},
"spatial": "SUM",
"temporal": "RATE",
"metricType": "sum",
"temporality": "cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{error}}",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
}
],
"timeRange": "15m",
"variables": [
{
"name": "DBHOST",
"type": "query",
"label": "DB_HOST",
"config": {
"otel": {
"key": "host_name",
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "mysql_instance_endpoint",
"value": "",
"operator": "EXISTS"
}
]
},
"source": "cloudwatch",
"queryType": "otel.values"
},
"is_multi": false,
"description": "",
"usesVariables": [],
"show_all_option": false
},
{
"name": "Schema",
"type": "query",
"label": "Schema",
"config": {
"otel": {
"key": {
"type": "string",
"field": "schema"
},
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "schema",
"value": "performance_schema",
"operator": "!="
},
{
"type": "string",
"field": "schema",
"value": "mysql",
"operator": "!="
}
]
},
"source": "cloudwatch",
"queryType": "otel.values"
},
"is_multi": false,
"description": "",
"show_all_option": false
}
],
"panel_layouts": [
{
"h": 6,
"i": "kd84l4rgf0twe",
"w": 5,
"x": 0,
"y": 0,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 6,
"i": "lortygjug7c1h",
"w": 5,
"x": 5,
"y": 0,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 6,
"i": "y7gd8kergqb8a",
"w": 5,
"x": 10,
"y": 0,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 6,
"i": "0db2hwslyhy4l",
"w": 5,
"x": 15,
"y": 0,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 6,
"i": "0xu822dv6c3fe",
"w": 4,
"x": 20,
"y": 0,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 10,
"i": "o5mc2be12vbmf",
"w": 8,
"x": 0,
"y": 6,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 10,
"i": "1qtsv1pk40thh",
"w": 8,
"x": 8,
"y": 6,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 10,
"i": "63kj1bnf1pi6u",
"w": 8,
"x": 16,
"y": 6,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 10,
"i": "yfomjhvk2pmg3",
"w": 8,
"x": 0,
"y": 16,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 10,
"i": "gkwx1zkls4mmo",
"w": 10,
"x": 8,
"y": 16,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 5,
"i": "00lk1jm2po711",
"w": 6,
"x": 18,
"y": 16,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 5,
"i": "d1x792guulhk3",
"w": 6,
"x": 18,
"y": 21,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 10,
"i": "dhtwp150mqzuu",
"w": 8,
"x": 0,
"y": 26,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 10,
"i": "uejh6de6jww7u",
"w": 8,
"x": 8,
"y": 26,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
},
{
"h": 10,
"i": "6x86n8kdntbrn",
"w": 8,
"x": 16,
"y": 26,
"minH": 1,
"minW": 1,
"moved": false,
"static": false
}
],
"default_region": "us-east-1",
"refresh_interval": null
},
"tags": []
}