database_mysql_index_vs_sequential_reads

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

Overview

Name	database_mysql_index_vs_sequential_reads
Type	Resource
Id	digitalocean.monitoring.database_mysql_index_vs_sequential_reads

Fields

The following fields are returned by SELECT queries:

monitoring_get_database_mysql_index_vs_sequential_reads

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_index_vs_sequential_reads	select	db_id, start, end		Retrieve index vs sequential reads ratio (percent) for a MySQL service — i.e. percentage of reads using an index.

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)
start	string	UNIX timestamp to start metric window. (example: 1620683817)

SELECT examples

monitoring_get_database_mysql_index_vs_sequential_reads

Retrieve index vs sequential reads ratio (percent) for a MySQL service — i.e. percentage of reads using an index.

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