Get ManagedMySqlDatabases SQL Data
GET {{baseUrl}}/managedMySqlDatabases/:managedMySqlDatabaseId/sqlData?filterColumn=<string>&limit=10&page=<string>&startTime=<string>&endTime=<string>&sortBy=TIMECREATED&sortOrder=ASC
Retrieves the SQL performance data for a specific MySQL database.
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
filterColumn | string | The parameter to filter results by key criteria which include : |
- AVG_TIMER_WAIT
- SUM_TIMER_WAIT
- COUNT_STAR
- SUM_ERRORS
- SUM_ROWS_AFFECTED
- SUM_ROWS_SENT
- SUM_ROWS_EXAMINED
- SUM_CREATED_TMP_TABLES
- SUM_NO_INDEX_USED
- SUM_NO_GOOD_INDEX_USED
- FIRST_SEEN
- LAST_SEEN
- HEATWAVE_OFFLOADED
- HEATWAVE_OUT_OF_MEMORY
|
|
limit| number | | The maximum number of records returned in the paginated response. | |page| string | | The page token representing the page from where the next set of paginated results are retrieved. This is usually retrieved from a previous list call. | |startTime| string | | (Required) The start time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'". | |endTime| string | | (Required) The end time of the time range to retrieve the health metrics of a Managed Database in UTC in ISO-8601 format, which is "yyyy-MM-dd'T'hh:mm:ss.sss'Z'". | |sortBy| string | | The field to sort information by. Only one sortOrder can be used. The default sort order for ‘TIMECREATED’ is descending and the default sort order for ‘NAME’ is ascending. The ‘NAME’ sort order is case-sensitive. | |sortOrder| string | | The option to sort information in ascending (‘ASC’) or descending (‘DESC’) order. Ascending order is the default order. |
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
opc-request-id | string | The client request ID for tracing. | |
Accept | string |
RESPONSES
status: OK
{"items":[{"schemaName":"\u003cstring\u003e","digest":"\u003cstring\u003e","digestText":"\u003cstring\u003e","countStar":"\u003cnumber\u003e","sumTimerWait":"\u003cnumber\u003e","minTimerWait":"\u003cnumber\u003e","avgTimerWait":"\u003cnumber\u003e","maxTimerWait":"\u003cnumber\u003e","sumLockTime":"\u003cnumber\u003e","sumErrors":"\u003cnumber\u003e","sumWarnings":"\u003cnumber\u003e","sumRowsAffected":"\u003cnumber\u003e","sumRowsExamined":"\u003cnumber\u003e","sumRowsSent":"\u003cnumber\u003e","sumCreatedTempDiskTables":"\u003cnumber\u003e","sumCreatedTempTables":"\u003cnumber\u003e","sumSelectFullJoin":"\u003cnumber\u003e","sumSelectFullRangeJoin":"\u003cnumber\u003e","sumSelectRange":"\u003cnumber\u003e","sumSortMergePasses":"\u003cnumber\u003e","sumSelectRangeCheck":"\u003cnumber\u003e","sumSelectScan":"\u003cnumber\u003e","sumSortRange":"\u003cnumber\u003e","sumSortRows":"\u003cnumber\u003e","sumSortScan":"\u003cnumber\u003e","sumNoIndexUsed":"\u003cnumber\u003e","sumNoGoodIndexUsed":"\u003cnumber\u003e","firstSeen":"\u003cdateTime\u003e","lastSeen":"\u003cdateTime\u003e","quantile95":"\u003cnumber\u003e","quantile99":"\u003cnumber\u003e","quantile999":"\u003cnumber\u003e","heatWaveOffloaded":"\u003cnumber\u003e","heatWaveOutOfMemory":"\u003cnumber\u003e"},{"schemaName":"\u003cstring\u003e","digest":"\u003cstring\u003e","digestText":"\u003cstring\u003e","countStar":"\u003cnumber\u003e","sumTimerWait":"\u003cnumber\u003e","minTimerWait":"\u003cnumber\u003e","avgTimerWait":"\u003cnumber\u003e","maxTimerWait":"\u003cnumber\u003e","sumLockTime":"\u003cnumber\u003e","sumErrors":"\u003cnumber\u003e","sumWarnings":"\u003cnumber\u003e","sumRowsAffected":"\u003cnumber\u003e","sumRowsExamined":"\u003cnumber\u003e","sumRowsSent":"\u003cnumber\u003e","sumCreatedTempDiskTables":"\u003cnumber\u003e","sumCreatedTempTables":"\u003cnumber\u003e","sumSelectFullJoin":"\u003cnumber\u003e","sumSelectFullRangeJoin":"\u003cnumber\u003e","sumSelectRange":"\u003cnumber\u003e","sumSortMergePasses":"\u003cnumber\u003e","sumSelectRangeCheck":"\u003cnumber\u003e","sumSelectScan":"\u003cnumber\u003e","sumSortRange":"\u003cnumber\u003e","sumSortRows":"\u003cnumber\u003e","sumSortScan":"\u003cnumber\u003e","sumNoIndexUsed":"\u003cnumber\u003e","sumNoGoodIndexUsed":"\u003cnumber\u003e","firstSeen":"\u003cdateTime\u003e","lastSeen":"\u003cdateTime\u003e","quantile95":"\u003cnumber\u003e","quantile99":"\u003cnumber\u003e","quantile999":"\u003cnumber\u003e","heatWaveOffloaded":"\u003cnumber\u003e","heatWaveOutOfMemory":"\u003cnumber\u003e"}]}