Service:_MySQL

Fetch MySQL service query statistics

Changed on
post/project/{project}/service/{service_name}/mysql/query/stats

Request

  • Base URL
    https://api.aiven.io/v1
  • URL
    https://api.aiven.io/v1/project/{project}/service/{service_name}/mysql/query/stats
  • Auth
    HTTP bearer and OAuth 2
    Authorization code: https://console.aiven.io/oauth/authorize
    Token URL: https://api.aiven.io/v1/oauth2/token scopes: services:read

Path parameters

projectstring required

Project name

service_namestring required

Service name

Request body

limitinteger

Limit for number of results

offsetinteger

Offset for retrieved results based on sort order

order_bystring

Sort order can be either asc or desc and multiple comma separated columns with their own order can be specified: :asc,:desc. Accepted sort columns are: avg_timer_wait, count_star, digest, digest_text, first_seen, last_seen, max_timer_wait, min_timer_wait, query_sample_seen, query_sample_text, query_sample_timer_wait, quantile_95, quantile_99, quantile_999, schema_name, sum_created_tmp_disk_tables, sum_created_tmp_tables, sum_errors, sum_lock_time, sum_no_good_index_used, sum_no_index_used, sum_rows_affected, sum_rows_examined, sum_rows_sent, sum_select_full_join, sum_select_full_range_join, sum_select_range, sum_select_range_check, sum_select_scan, sum_sort_merge_passes, sum_sort_range, sum_sort_rows, sum_sort_scan, sum_timer_wait, sum_warnings

Response

Response

messagestring

Printable result of the request

Changes

  • 402066a999a1Revision changes
    • info

      the request property default value 100 was added

    • info

      the request property default value 0 was added

    • info

      the request property default value count_star:desc was added