database_mysql_op_rates

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

Overview

Name	database_mysql_op_rates
Type	Resource
Id	digitalocean.monitoring.database_mysql_op_rates

Fields

The following fields are returned by SELECT queries:

monitoring_get_database_mysql_op_rates

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_op_rates	select	db_id, metric, start, end		Retrieve operations rate (per second) for a MySQL service. Use metric to choose select, insert, update, or 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	Operation type (select, insert, update, or delete). (example: select)
start	string	UNIX timestamp to start metric window. (example: 1620683817)

SELECT examples

monitoring_get_database_mysql_op_rates

Retrieve operations rate (per second) for a MySQL service. Use metric to choose select, insert, update, or delete.

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