database_mysql_schema_latency

Creates, updates, deletes, gets or lists a database_mysql_schema_latency resource.

Overview

Name	database_mysql_schema_latency
Type	Resource
Id	digitalocean.monitoring.database_mysql_schema_latency

Fields

The following fields are returned by SELECT queries:

monitoring_get_database_mysql_schema_latency

The response will be a JSON object with a key called data and status.

Name	Datatype	Description
data	object
status	string	(success, error) (example: success)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
monitoring_get_database_mysql_schema_latency	select	db_id, schema, metric, start, end		Retrieve table I/O latency (seconds) for a schema. Requires schema and metric (insert, fetch, update, delete).

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
db_id	string (uuid)	The DBaaS cluster UUID (database ID). (example: 9cc10173-e9ea-4176-9dbc-a4cee4c4ff30)
end	string	UNIX timestamp to end metric window. (example: 1620705417)
metric	string	Table I/O operation (insert, fetch, update, or delete). (example: insert)
schema	string	The schema (database) name. (example: defaultdb)
start	string	UNIX timestamp to start metric window. (example: 1620683817)

SELECT examples

monitoring_get_database_mysql_schema_latency

Retrieve table I/O latency (seconds) for a schema. Requires schema and metric (insert, fetch, update, delete).

SELECT
data,
status
FROM digitalocean.monitoring.database_mysql_schema_latency
WHERE db_id = '{{ db_id }}' -- required
AND schema = '{{ schema }}' -- required
AND metric = '{{ metric }}' -- required
AND start = '{{ start }}' -- required
AND end = '{{ end }}' -- required
;