Files
templates-default/GCP_Cloud_SQL_MySQL_by_HTTP.yaml

1200 lines
45 KiB
YAML

zabbix_export:
version: '7.0'
template_groups:
- uuid: c2c162144c2d4c5491c8801193af4945
name: Templates/Cloud
templates:
- uuid: 38456af4aedd4b168ec3fa4ad2acb256
template: 'GCP Cloud SQL MySQL by HTTP'
name: 'GCP Cloud SQL MySQL by HTTP'
description: |
Get GCP Cloud SQL MySQL instances monitoring with script item usage to perform HTTP requests to Google Cloud Platform Monitoring API.
This template will be automatically connected to discovered entities with all their required parameters pre-defined.
You can discuss this template or leave feedback on our forum https://www.zabbix.com/forum/zabbix-suggestions-and-feedback.
Generated by official Zabbix template tool "Templator"
vendor:
name: Zabbix
version: 7.0-3
groups:
- name: Templates/Cloud
items:
- uuid: 83e36c61e8ce4d06a395ea7b06c5877b
name: 'Reserved CPU cores'
type: DEPENDENT
key: gcp.cloudsql.mysql.cpu.reserved_cores
delay: '0'
value_type: FLOAT
description: 'Number of cores reserved for the database.'
preprocessing:
- type: JSONPATH
parameters:
- $.base_reserved_cores
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: cpu
- uuid: a39ba253dbf24110af48fd49572976fd
name: 'CPU usage time'
type: DEPENDENT
key: gcp.cloudsql.mysql.cpu.usage_time
delay: '0'
value_type: FLOAT
units: s
description: 'Cumulative CPU usage time in seconds.'
preprocessing:
- type: JSONPATH
parameters:
- $.base_usage_time
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: cpu
- uuid: df7469e3c76c4286846c27003c9785cc
name: 'CPU utilization'
type: DEPENDENT
key: gcp.cloudsql.mysql.cpu.utilization
delay: '0'
value_type: FLOAT
units: '%'
description: 'Current CPU utilization represented as a percentage of the reserved CPU that is currently in use.'
preprocessing:
- type: JSONPATH
parameters:
- $.base_utilization
- type: MULTIPLIER
parameters:
- '100'
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: cpu
triggers:
- uuid: 5bf54c01665549c8a05f49db34c86191
expression: 'min(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.cpu.utilization,5m) >= {$CLOUD_SQL.MYSQL.CPU.UTIL.MAX}'
name: 'GCP MySQL: High CPU utilization'
opdata: 'Current utilization: {ITEM.LASTVALUE}'
priority: AVERAGE
description: 'The CPU utilization is too high. The system might be slow to respond.'
tags:
- tag: scope
value: performance
- uuid: 948dac37023c4efcaf5f830ba5d4fafe
name: 'DB engine state'
type: HTTP_AGENT
key: gcp.cloudsql.mysql.db.state
description: 'GCP Cloud SQL MySQL DB Engine State.'
valuemap:
name: 'Database availability'
preprocessing:
- type: CHECK_NOT_SUPPORTED
parameters:
- '-1'
- type: JSONPATH
parameters:
- '$.timeSeriesData[0].pointData[0].values[0].int64Value'
error_handler: DISCARD_VALUE
- type: DISCARD_UNCHANGED_HEARTBEAT
parameters:
- 10m
timeout: '{$GCP.DATA.TIMEOUT}'
url: 'https://monitoring.googleapis.com/v3/projects/{$GCP.PROJECT.ID}/timeSeries:query'
status_codes: ''
posts: '{"query":"cloudsql.googleapis.com/database/up | within 5m | filter database_id = ''{$GCP.PROJECT.ID}:{HOST.NAME}''"}'
headers:
- name: Content-Type
value: application/json
- name: Authorization
value: 'Bearer {$GCP.AUTH.TOKEN}'
request_method: POST
tags:
- tag: component
value: status
triggers:
- uuid: a3eff8c422f5427e9b1c6abb9854f73c
expression: 'last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.db.state)=0'
name: 'GCP MySQL: Database engine is down'
priority: AVERAGE
description: |
Database engine is down.
If an instance experiences unplanned (non-maintenance) downtime, the instance state will still be RUNNING, but the database engine state metric will report 0.
dependencies:
- name: 'GCP MySQL: Failed to get the instance state'
expression: 'last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 10'
- name: 'GCP MySQL: Instance is in failed state'
expression: 'last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 5'
- name: 'GCP MySQL: Instance is in maintenance'
expression: 'last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 4'
- name: 'GCP MySQL: Instance is in suspended state'
expression: 'last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 1'
- name: 'GCP MySQL: Instance is in unknown state'
expression: 'last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 6'
- name: 'GCP MySQL: Instance is stopped by the owner'
expression: 'last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 2'
tags:
- tag: scope
value: availability
- uuid: 76c37760145d43f3927f1a9548dea8a5
name: 'Disk bytes used'
type: DEPENDENT
key: gcp.cloudsql.mysql.disk.bytes_used
delay: '0'
units: B
description: 'Data utilization in bytes.'
preprocessing:
- type: JSONPATH
parameters:
- $.mysql_bytes_used
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: storage
- uuid: 464fecbbedd64e988739c93736d2b824
name: 'Disk size'
type: DEPENDENT
key: gcp.cloudsql.mysql.disk.quota
delay: '0'
units: B
description: 'Maximum data disk size in bytes.'
preprocessing:
- type: JSONPATH
parameters:
- $.mysql_quota
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: storage
- uuid: d426d282d2ee43fe9c9b64dcb6d0c4c9
name: 'Disk read I/O'
type: DEPENDENT
key: gcp.cloudsql.mysql.disk.read_ops_count
delay: '0'
description: 'Delta count of data disk read I/O operations.'
preprocessing:
- type: JSONPATH
parameters:
- $.base_read_ops_count
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: storage
- uuid: b2274d47be5041b493b00fd55172c0e9
name: 'Disk utilization'
type: DEPENDENT
key: gcp.cloudsql.mysql.disk.utilization
delay: '0'
value_type: FLOAT
units: '%'
description: |
The fraction of the disk quota that is currently in use.
Shown as percentage.
preprocessing:
- type: JSONPATH
parameters:
- $.mysql_utilization
- type: MULTIPLIER
parameters:
- '100'
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: storage
triggers:
- uuid: d5ade16fb0494ca6af61100a2e643702
expression: 'last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.disk.utilization) >= {$CLOUD_SQL.MYSQL.DISK.UTIL.CRIT}'
name: 'GCP MySQL: Disk space is critically low'
opdata: 'Current utilization: {ITEM.LASTVALUE}'
priority: AVERAGE
description: 'Critical utilization of the disk space.'
tags:
- tag: scope
value: capacity
- uuid: 3b5c84fee47f4376b19d0738b261c01b
expression: 'last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.disk.utilization) >= {$CLOUD_SQL.MYSQL.DISK.UTIL.WARN}'
name: 'GCP MySQL: Disk space is low'
opdata: 'Current utilization: {ITEM.LASTVALUE}'
priority: WARNING
description: 'High utilization of the storage space.'
dependencies:
- name: 'GCP MySQL: Disk space is critically low'
expression: 'last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.disk.utilization) >= {$CLOUD_SQL.MYSQL.DISK.UTIL.CRIT}'
tags:
- tag: scope
value: capacity
- uuid: 7a44187c6a404defb0dc83fa22f89d96
name: 'Disk write I/O'
type: DEPENDENT
key: gcp.cloudsql.mysql.disk.write_ops_count
delay: '0'
description: 'Delta count of data disk write I/O operations.'
preprocessing:
- type: JSONPATH
parameters:
- $.base_write_ops_count
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: storage
- uuid: 5e5b9cdfa7f2455b881cceface136e65
name: 'InnoDB dirty pages'
type: DEPENDENT
key: gcp.cloudsql.mysql.innodb_buffer_pool_pages_dirty
delay: '0'
description: 'Number of unflushed pages in the InnoDB buffer pool.'
preprocessing:
- type: JSONPATH
parameters:
- $.mysql_innodb_buffer_pool_pages_dirty
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: innodb
- tag: component
value: memory
- uuid: 75835c8326e6461d8f25fb7d55271f16
name: 'InnoDB free pages'
type: DEPENDENT
key: gcp.cloudsql.mysql.innodb_buffer_pool_pages_free
delay: '0'
description: 'Number of unused pages in the InnoDB buffer pool.'
preprocessing:
- type: JSONPATH
parameters:
- $.mysql_innodb_buffer_pool_pages_free
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: innodb
- tag: component
value: memory
- uuid: 080d5304c0e346808bd70b125a27be4b
name: 'InnoDB total pages'
type: DEPENDENT
key: gcp.cloudsql.mysql.innodb_buffer_pool_pages_total
delay: '0'
description: 'Total number of pages in the InnoDB buffer pool.'
preprocessing:
- type: JSONPATH
parameters:
- $.mysql_innodb_buffer_pool_pages_total
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: innodb
- tag: component
value: memory
- uuid: 19e259f61fc24e29a189c35121878eb3
name: 'InnoDB fsync calls'
type: DEPENDENT
key: gcp.cloudsql.mysql.innodb_data_fsyncs
delay: '0'
description: 'Delta count of InnoDB fsync() calls.'
preprocessing:
- type: JSONPATH
parameters:
- $.mysql_innodb_data_fsyncs
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: innodb
- tag: component
value: storage
- uuid: c4a4ffa274974041bccbd25643ff9f70
name: 'InnoDB log fsync calls'
type: DEPENDENT
key: gcp.cloudsql.mysql.innodb_os_log_fsyncs
delay: '0'
description: 'Delta count of InnoDB fsync() calls to the log file.'
preprocessing:
- type: JSONPATH
parameters:
- $.mysql_innodb_os_log_fsyncs
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: innodb
- tag: component
value: storage
- uuid: 4a9154e235e84c0d9dbf0abf44479f49
name: 'InnoDB pages read'
type: DEPENDENT
key: gcp.cloudsql.mysql.innodb_pages_read
delay: '0'
description: 'Delta count of InnoDB pages read.'
preprocessing:
- type: JSONPATH
parameters:
- $.mysql_innodb_pages_read
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: innodb
- tag: component
value: memory
- uuid: 584714b219034bbebbc24edad36704c9
name: 'InnoDB pages written'
type: DEPENDENT
key: gcp.cloudsql.mysql.innodb_pages_written
delay: '0'
description: 'Delta count of InnoDB pages written.'
preprocessing:
- type: JSONPATH
parameters:
- $.mysql_innodb_pages_written
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: innodb
- tag: component
value: memory
- uuid: 71559008ad444772b0b1212f715980ed
name: 'Instance state'
type: HTTP_AGENT
key: gcp.cloudsql.mysql.inst.state
description: 'GCP Cloud SQL MySQL Current instance state.'
valuemap:
name: 'Instance state'
preprocessing:
- type: JSONPATH
parameters:
- '$.timeSeriesData[0].pointData[0].values[0].stringValue'
error_handler: CUSTOM_VALUE
error_handler_params: '10'
- type: JAVASCRIPT
parameters:
- |
const idx = [
'RUNNING',
'SUSPENDED',
'RUNNABLE',
'PENDING_CREATE',
'MAINTENANCE',
'FAILED',
'UNKNOWN_STATE'
].indexOf(value);
return idx !== -1 ? idx : 10;
- type: DISCARD_UNCHANGED_HEARTBEAT
parameters:
- 10m
timeout: '{$GCP.DATA.TIMEOUT}'
url: 'https://monitoring.googleapis.com/v3/projects/{$GCP.PROJECT.ID}/timeSeries:query'
status_codes: ''
posts: '{"query":"cloudsql.googleapis.com/database/state | within 5m | filter database_id = ''{$GCP.PROJECT.ID}:{HOST.NAME}''"}'
headers:
- name: Content-Type
value: application/json
- name: Authorization
value: 'Bearer {$GCP.AUTH.TOKEN}'
request_method: POST
tags:
- tag: component
value: status
triggers:
- uuid: 3b3adc89e0bb45a79a824121f49d2d02
expression: 'last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 10'
name: 'GCP MySQL: Failed to get the instance state'
priority: AVERAGE
description: |
Failed to get the instance state.
Check access permissions to GCP API or service account.
tags:
- tag: scope
value: availability
- uuid: 65831fed3d19425c86933db4034ed565
expression: 'last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 5'
name: 'GCP MySQL: Instance is in failed state'
priority: AVERAGE
description: 'The instance creation failed, or an operation left the instance in an own bad state.'
tags:
- tag: scope
value: availability
- uuid: fae15d1ab46c418ebfdfdd73fb698b51
expression: 'last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 4'
name: 'GCP MySQL: Instance is in maintenance'
priority: INFO
description: 'The instance is down for maintenance.'
tags:
- tag: scope
value: availability
- uuid: 347215d307c8465cad41198f12b5ff68
expression: 'last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 1'
name: 'GCP MySQL: Instance is in suspended state'
priority: WARNING
description: |
The instance is in suspended state.
It is not available, for example, due to problems with billing.
tags:
- tag: scope
value: availability
- uuid: 1387f9a2ef194d5bb5d1e548fc4eb8d3
expression: 'last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 6'
name: 'GCP MySQL: Instance is in unknown state'
priority: AVERAGE
description: 'The state of the instance is unknown.'
tags:
- tag: scope
value: availability
- uuid: 9c66317433a24be985559fdb11907c70
expression: 'last(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.inst.state) = 2'
name: 'GCP MySQL: Instance is stopped by the owner'
priority: INFO
description: |
The instance has been stopped by the owner.
It is not currently running, but it's ready to be restarted.
tags:
- tag: scope
value: availability
- uuid: cc09f5591b0242b3b99199b267a1c527
name: 'Memory size'
type: DEPENDENT
key: gcp.cloudsql.mysql.memory.quota
delay: '0'
units: B
description: 'Maximum RAM size in bytes.'
preprocessing:
- type: JSONPATH
parameters:
- $.base_quota
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: memory
- uuid: 13868b9408c9489296531bf1fd927084
name: 'Memory used by DB engine'
type: DEPENDENT
key: gcp.cloudsql.mysql.memory.total_usage
delay: '0'
units: B
description: |
Total RAM usage in bytes.
This metric reports the RAM usage of the database process, including the buffer/cache.
preprocessing:
- type: JSONPATH
parameters:
- $.base_total_usage
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: memory
- uuid: 995d07fc814f4d12a9c9bdc6bb52481d
name: 'Memory usage'
type: DEPENDENT
key: gcp.cloudsql.mysql.memory.usage
delay: '0'
units: B
description: |
The RAM usage in bytes.
This metric reports the RAM usage of the server, excluding the buffer/cache.
preprocessing:
- type: JSONPATH
parameters:
- $.base_usage
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: memory
- uuid: efe4357a63ec43f799b2303a952c1378
name: 'Memory utilization'
type: DEPENDENT
key: gcp.cloudsql.mysql.memory.utilization
delay: '0'
value_type: FLOAT
units: '%'
description: |
The fraction of the memory quota that is currently in use.
Shown as percentage.
preprocessing:
- type: JSONPATH
parameters:
- $.base_ram_pused
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: memory
triggers:
- uuid: 82e3af43d3104b4ba641e0be56d11662
expression: 'min(/GCP Cloud SQL MySQL by HTTP/gcp.cloudsql.mysql.memory.utilization,5m) >= {$CLOUD_SQL.MYSQL.RAM.UTIL.MAX}'
name: 'GCP MySQL: High memory utilization'
opdata: 'Current utilization: {ITEM.LASTVALUE}'
priority: HIGH
description: 'RAM utilization is too high. The system might be slow to respond.'
tags:
- tag: scope
value: performance
- uuid: 682484eaf1db4a239c69566a5cd492e2
name: 'Metrics get'
type: SCRIPT
key: gcp.cloudsql.mysql.metrics.get
delay: '{$GCP.TIME.WINDOW}'
history: '0'
value_type: TEXT
trends: '0'
params: |
const CTlsConfig = function (raw_value) {
raw_value = String(raw_value).trim().toLowerCase();
if (['none', 'peer', 'full'].indexOf(raw_value) === -1) {
raw_value = 'full';
}
this.options = {
SSLVerifyPeer: (raw_value === 'peer' || raw_value === 'full'),
SSLVerifyHost: (raw_value === 'full')
};
this.enabled = (raw_value !== 'none');
this.checkURL = function (url) {
if (this.enabled && !/^https:\/\//i.test(url)) {
throw 'TLS certificate verification is enabled by {$' + 'HTTP.TLS.VERIFY}, but the URL uses plain HTTP: ' + url +
'. Use an "https://" URL, or set {$' + 'HTTP.TLS.VERIFY} to `none` to disable verification.';
}
return url;
};
}
var base_path = 'cloudsql.googleapis.com/database/',
mysql_path = 'cloudsql.googleapis.com/database/mysql/',
obj = {},
base_paths = [
'cpu/reserved_cores',
'cpu/usage_time',
'cpu/utilization',
'disk/read_ops_count',
'disk/write_ops_count',
'memory/quota',
'memory/total_usage',
'memory/usage',
'network/connections',
'network/received_bytes_count',
'network/sent_bytes_count | map ignore [destination]'
].map(function (path) { return base_path + path; }),
mysql_paths = [
'innodb_buffer_pool_pages_dirty',
'innodb_buffer_pool_pages_free',
'innodb_buffer_pool_pages_total',
'innodb_data_fsyncs',
'innodb_os_log_fsyncs',
'innodb_pages_read',
'innodb_pages_written',
'queries',
'questions',
'received_bytes_count',
'sent_bytes_count',
'open_tables',
'open_table_definitions'
].map(function (path) { return mysql_path + path; }).concat(
['disk/bytes_used', 'disk/utilization', 'disk/quota'].map(function (path) { return base_path + path; }));
function getField(data, path) {
var steps = path.split('.');
for (var i = 0; i < steps.length; i++) {
var step = steps[i];
if (typeof data !== 'object' || typeof data[step] === 'undefined') {
throw 'Required field "' + path + '" is not present in data received.';
}
data = data[step];
}
return data;
}
function checkParams(params) {
['project_id', 'time_window', 'database_id', 'token'].forEach(function (field) {
if (typeof params !== 'object' || typeof params[field] === 'undefined' || params[field] === '') {
throw 'Required param is not set: ' + field + '.';
}
});
if (!params.time_window.match(/^[0-9]+(m|h)$/)) {
throw 'Incorrect update interval for parameter time_window. Valid ranges 1m-23h.';
}
return params;
}
function getHttpData(url, token, body) {
var tls = new CTlsConfig(params.tls_verify),
request = new HttpRequest(tls.options);
if (typeof params.proxy !== 'undefined' && params.proxy !== '') {
request.setProxy(params.proxy);
};
request.addHeader('Authorization: Bearer ' + token);
request.addHeader('Content-Type: application/json');
var response = request.post(url, JSON.stringify(body));
Zabbix.log(4, '[ GCP API ] [ ' + url + ' ] Received response with status code ' + request.getStatus() + ': ' + response);
if (response !== null) {
try {
response = JSON.parse(response);
}
catch (error) {
throw 'Failed to parse response received from GCP API. Check debug log for more information.';
}
}
if (typeof response !== 'object' || response === null) {
throw 'Cannot process response data: received data is not an object. Check debug log for more information.';
}
if (request.getStatus() !== 200) {
if (typeof (response.error && response.error.message) !== 'undefined') {
throw response.error.message;
}
else {
throw 'Failed to receive data: invalid response status code. Check debug log for more information.';
}
}
return response;
};
function rawMap(raw, prefix) {
var keys = getField(raw, 'timeSeriesDescriptor.pointDescriptors'),
values = getField(raw, 'timeSeriesData.0.pointData.0.values'),
re = /(^t_\d+\.value\.)/g;
for (i in keys) {
var key = getField(keys[i], 'key').replace(re, ''),
value_types = ['int64Value', 'doubleValue', 'stringValue', 'boolValue'];
for (v in value_types) {
if (typeof values[i][value_types[v]] !== 'undefined') {
if (prefix) {
obj[prefix + key] = values[i][value_types[v]];
}
else {
obj[key] = values[i][value_types[v]];
}
}
}
}
return obj;
}
var params = checkParams(JSON.parse(value)),
j_filter = ' | within ' + params.time_window + " | filter database_id = '" + params.database_id + "'" + ' | join',
url = 'https://monitoring.googleapis.com/v3/projects/' + params.project_id + '/timeSeries:query',
queries = [
{ name: 'base_', data: { query: '{' + base_paths.join(';') + '}' + j_filter } },
{ name: 'mysql_', data: { query: '{' + mysql_paths.join(';') + '}' + j_filter } }
];
for (q in queries) {
raw = getHttpData(url, params.token, queries[q].data);
obj = Object.assign(obj, rawMap(raw, queries[q].name));
}
obj.base_ram_pused = Math.floor(getField(obj, 'base_usage') / getField(obj, 'base_quota') * 100);
return JSON.stringify(obj);
description: 'MySQL metrics in raw format.'
preprocessing:
- type: CHECK_NOT_SUPPORTED
parameters:
- '-1'
timeout: '{$GCP.DATA.TIMEOUT}'
parameters:
- name: database_id
value: '{$GCP.PROJECT.ID}:{HOST.NAME}'
- name: project_id
value: '{$GCP.PROJECT.ID}'
- name: proxy
value: '{$GCP.PROXY}'
- name: time_window
value: '{$GCP.TIME.WINDOW}'
- name: tls_verify
value: '{$HTTP.TLS.VERIFY:"GCP Cloud SQL MySQL"}'
- name: token
value: '{$GCP.AUTH.TOKEN}'
tags:
- tag: component
value: raw
- uuid: 9ddae405a9b343759d03b5b29c469d18
name: Connections
type: DEPENDENT
key: gcp.cloudsql.mysql.network.connections
delay: '0'
description: 'Number of connections to the databases on the Cloud SQL instance.'
preprocessing:
- type: JSONPATH
parameters:
- $.base_connections
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: connections
- tag: component
value: network
- uuid: d970d8e209df4b2a810c2e59f39fa429
name: 'Network: Received bytes'
type: DEPENDENT
key: gcp.cloudsql.mysql.network.received_bytes_count
delay: '0'
units: B
description: 'Delta count of bytes received through the network.'
preprocessing:
- type: JSONPATH
parameters:
- $.base_received_bytes_count
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: network
- tag: component
value: traffic
- uuid: 977e4e22ebfc4a19a228a8935d9a342c
name: 'Network: Sent bytes'
type: DEPENDENT
key: gcp.cloudsql.mysql.network.sent_bytes_count
delay: '0'
units: B
description: 'Delta count of bytes sent through the network.'
preprocessing:
- type: JSONPATH
parameters:
- $.base_sent_bytes_count
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: network
- tag: component
value: traffic
- uuid: 1d651976f70944acb31cd0430e70d422
name: 'Open tables'
type: DEPENDENT
key: gcp.cloudsql.mysql.open_tables
delay: '0'
description: 'The number of tables that are currently open.'
preprocessing:
- type: JSONPATH
parameters:
- $.mysql_open_tables
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: tables
- uuid: 1606766c63bf4aa1ade24a34650eef05
name: 'Open table definitions'
type: DEPENDENT
key: gcp.cloudsql.mysql.open_table_definitions
delay: '0'
description: 'The number of table definitions that are currently cached.'
preprocessing:
- type: JSONPATH
parameters:
- $.mysql_open_table_definitions
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: tables
- uuid: 3d3ec2e37bf94fb68c40967b56dfd95c
name: 'Network: Bytes received by MySQL'
type: DEPENDENT
key: gcp.cloudsql.mysql_received_bytes_count
delay: '0'
units: B
description: 'Delta count of bytes received by MySQL process.'
preprocessing:
- type: JSONPATH
parameters:
- $.mysql_received_bytes_count
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: network
- tag: component
value: traffic
- uuid: f926beb31be44dc0bfb30c571fac280a
name: 'Network: Bytes sent by MySQL'
type: DEPENDENT
key: gcp.cloudsql.mysql_sent_bytes_count
delay: '0'
units: B
description: 'Delta count of bytes sent by MySQL process.'
preprocessing:
- type: JSONPATH
parameters:
- $.mysql_sent_bytes_count
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: network
- tag: component
value: traffic
- uuid: bbdeb595ab1b44d7a332fbf0c2637403
name: Queries
type: DEPENDENT
key: gcp.cloudsql.queries
delay: '0'
description: 'Delta of statements executed by the server.'
preprocessing:
- type: JSONPATH
parameters:
- $.mysql_queries
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: queries
- uuid: 114fb26dcdc1441c84c150c7809b3400
name: Questions
type: DEPENDENT
key: gcp.cloudsql.questions
delay: '0'
description: 'Delta of statements executed by the server sent by the client.'
preprocessing:
- type: JSONPATH
parameters:
- $.mysql_questions
master_item:
key: gcp.cloudsql.mysql.metrics.get
tags:
- tag: component
value: queries
tags:
- tag: class
value: cloud
- tag: target
value: cloudsql
- tag: target
value: gcp
- tag: target
value: google-cloud-platform
- tag: target
value: mysql
macros:
- macro: '{$CLOUD_SQL.MYSQL.CPU.UTIL.MAX}'
value: '95'
description: 'GCP Cloud SQL MySQL instance CPU usage threshold.'
- macro: '{$CLOUD_SQL.MYSQL.DISK.UTIL.CRIT}'
value: '90'
description: 'GCP Cloud SQL MySQL instance critical disk usage threshold.'
- macro: '{$CLOUD_SQL.MYSQL.DISK.UTIL.WARN}'
value: '80'
description: 'GCP Cloud SQL MySQL instance warning disk usage threshold.'
- macro: '{$CLOUD_SQL.MYSQL.RAM.UTIL.MAX}'
value: '90'
description: 'GCP Cloud SQL MySQL instance RAM usage threshold.'
- macro: '{$GCP.DATA.TIMEOUT}'
value: 15s
description: 'A response timeout for an API.'
- macro: '{$GCP.PROXY}'
description: 'Sets HTTP proxy value. If this macro is empty then no proxy is used.'
- macro: '{$GCP.TIME.WINDOW}'
value: 5m
description: |
Time interval for the data requests.
Supported usage type:
1. The default update interval for most of the items.
2. The minimal time window for the data requested in the Monitoring Query Language REST API request.
- macro: '{$HTTP.TLS.VERIFY}'
value: full
description: 'TLS certificate verification for script items: "none" - disabled, "peer" - verify the certificate chain and expiration, "full" - full verification. Any other value enables full verification. To override the setting for this template only, define the macro with the context "GCP Cloud SQL MySQL", e.g. {$HTTP.TLS.VERIFY:"GCP Cloud SQL MySQL"}.'
dashboards:
- uuid: 5932cc56f6f146db8fac121b3817a407
name: 'MySQL instance'
pages:
- name: 'MySQL instance'
widgets:
- type: graph
width: '36'
height: '5'
fields:
- type: ITEM
name: itemid.0
value:
host: 'GCP Cloud SQL MySQL by HTTP'
key: gcp.cloudsql.mysql.cpu.usage_time
- type: STRING
name: reference
value: AAAAA
- type: INTEGER
name: source_type
value: '1'
- type: graph
'y': '5'
width: '36'
height: '5'
fields:
- type: GRAPH
name: graphid.0
value:
host: 'GCP Cloud SQL MySQL by HTTP'
name: 'GCP Cloud SQL MySQL: Memory usage'
- type: STRING
name: reference
value: AAAAC
- type: graph
'y': '10'
width: '36'
height: '5'
fields:
- type: ITEM
name: itemid.0
value:
host: 'GCP Cloud SQL MySQL by HTTP'
key: gcp.cloudsql.mysql.disk.utilization
- type: STRING
name: reference
value: AAAAE
- type: INTEGER
name: source_type
value: '1'
- type: graph
'y': '15'
width: '36'
height: '5'
fields:
- type: GRAPH
name: graphid.0
value:
host: 'GCP Cloud SQL MySQL by HTTP'
name: 'GCP Cloud SQL MySQL: Network traffic'
- type: STRING
name: reference
value: AAAAG
- type: graph
'y': '20'
width: '36'
height: '5'
fields:
- type: GRAPH
name: graphid.0
value:
host: 'GCP Cloud SQL MySQL by HTTP'
name: 'GCP Cloud SQL MySQL: pages'
- type: STRING
name: reference
value: AAAAI
- type: graph
x: '36'
width: '36'
height: '5'
fields:
- type: ITEM
name: itemid.0
value:
host: 'GCP Cloud SQL MySQL by HTTP'
key: gcp.cloudsql.mysql.cpu.utilization
- type: STRING
name: reference
value: AAAAB
- type: INTEGER
name: source_type
value: '1'
- type: graph
x: '36'
'y': '5'
width: '36'
height: '5'
fields:
- type: ITEM
name: itemid.0
value:
host: 'GCP Cloud SQL MySQL by HTTP'
key: gcp.cloudsql.mysql.memory.utilization
- type: STRING
name: reference
value: AAAAD
- type: INTEGER
name: source_type
value: '1'
- type: graph
x: '36'
'y': '10'
width: '36'
height: '5'
fields:
- type: GRAPH
name: graphid.0
value:
host: 'GCP Cloud SQL MySQL by HTTP'
name: 'GCP Cloud SQL MySQL: Disk read/write operations'
- type: STRING
name: reference
value: AAAAF
- type: graph
x: '36'
'y': '15'
width: '36'
height: '5'
fields:
- type: ITEM
name: itemid.0
value:
host: 'GCP Cloud SQL MySQL by HTTP'
key: gcp.cloudsql.mysql.network.connections
- type: STRING
name: reference
value: AAAAH
- type: INTEGER
name: source_type
value: '1'
- type: graph
x: '36'
'y': '20'
width: '36'
height: '5'
fields:
- type: GRAPH
name: graphid.0
value:
host: 'GCP Cloud SQL MySQL by HTTP'
name: 'GCP Cloud SQL MySQL: Queries'
- type: STRING
name: reference
value: AAAAJ
valuemaps:
- uuid: 8aa36f0f6a0b42a3b5e0eabfb700e8db
name: 'Database availability'
mappings:
- value: '0'
newvalue: Down
- value: '1'
newvalue: Up
- uuid: 9adad9dad34646d79bcc6c414ddf8afe
name: 'Instance state'
mappings:
- value: '0'
newvalue: Running
- value: '1'
newvalue: Suspended
- value: '2'
newvalue: Runnable
- value: '3'
newvalue: 'Pending create'
- value: '4'
newvalue: Maintenance
- value: '5'
newvalue: Failed
- value: '6'
newvalue: 'Unknown state'
- value: '10'
newvalue: 'Data retrievement error'
graphs:
- uuid: 935c2f388185469f82100541d9efb2c7
name: 'GCP Cloud SQL MySQL: Disk read/write operations'
graph_items:
- color: 199C0D
item:
host: 'GCP Cloud SQL MySQL by HTTP'
key: gcp.cloudsql.mysql.disk.read_ops_count
- sortorder: '1'
color: F63100
item:
host: 'GCP Cloud SQL MySQL by HTTP'
key: gcp.cloudsql.mysql.disk.write_ops_count
- uuid: 1b0ea2b38fe740b197ecbcfdd7464b02
name: 'GCP Cloud SQL MySQL: Disk usage'
graph_items:
- drawtype: BOLD_LINE
color: 199C0D
calc_fnc: MIN
item:
host: 'GCP Cloud SQL MySQL by HTTP'
key: gcp.cloudsql.mysql.disk.quota
- sortorder: '1'
drawtype: GRADIENT_LINE
color: F63100
item:
host: 'GCP Cloud SQL MySQL by HTTP'
key: gcp.cloudsql.mysql.disk.bytes_used
- uuid: 4378be58ccff4592a1b54838b90e9ea8
name: 'GCP Cloud SQL MySQL: Memory usage'
graph_items:
- drawtype: BOLD_LINE
color: 199C0D
calc_fnc: MIN
item:
host: 'GCP Cloud SQL MySQL by HTTP'
key: gcp.cloudsql.mysql.memory.quota
- sortorder: '1'
drawtype: GRADIENT_LINE
color: F63100
item:
host: 'GCP Cloud SQL MySQL by HTTP'
key: gcp.cloudsql.mysql.memory.usage
- uuid: c23964e5e54541ccb3c8b7b5f5a4b24d
name: 'GCP Cloud SQL MySQL: Network traffic'
type: STACKED
graph_items:
- color: 199C0D
item:
host: 'GCP Cloud SQL MySQL by HTTP'
key: gcp.cloudsql.mysql.network.received_bytes_count
- sortorder: '1'
color: F63100
item:
host: 'GCP Cloud SQL MySQL by HTTP'
key: gcp.cloudsql.mysql.network.sent_bytes_count
- uuid: e680755183ec4927893e03f8d83bc0f2
name: 'GCP Cloud SQL MySQL: pages'
graph_items:
- color: 199C0D
item:
host: 'GCP Cloud SQL MySQL by HTTP'
key: gcp.cloudsql.mysql.innodb_buffer_pool_pages_free
- sortorder: '1'
color: F63100
item:
host: 'GCP Cloud SQL MySQL by HTTP'
key: gcp.cloudsql.mysql.innodb_buffer_pool_pages_dirty
- sortorder: '2'
color: 00611C
item:
host: 'GCP Cloud SQL MySQL by HTTP'
key: gcp.cloudsql.mysql.innodb_buffer_pool_pages_total
- sortorder: '3'
color: F7941D
item:
host: 'GCP Cloud SQL MySQL by HTTP'
key: gcp.cloudsql.mysql.innodb_pages_read
- sortorder: '4'
color: FC6EA3
item:
host: 'GCP Cloud SQL MySQL by HTTP'
key: gcp.cloudsql.mysql.innodb_pages_written
- uuid: e447dd13336446b1a965e92d7ddeaf96
name: 'GCP Cloud SQL MySQL: Queries'
graph_items:
- color: 199C0D
item:
host: 'GCP Cloud SQL MySQL by HTTP'
key: gcp.cloudsql.queries
- sortorder: '1'
color: F63100
item:
host: 'GCP Cloud SQL MySQL by HTTP'
key: gcp.cloudsql.questions