Service:_MySQL

Get optimization recommendations for a query

Changed on

This endpoint may be changed or removed at any time. Don't use it in production environments.

post/account/{account_id}/mysql/query/optimize

Request

  • Base URL
    https://api.aiven.io/v1
  • URL
    https://api.aiven.io/v1/account/{account_id}/mysql/query/optimize
  • Auth
    HTTP bearer and OAuth 2
    Authorization code: https://console.aiven.io/oauth/authorize
    Token URL: https://api.aiven.io/v1/oauth2/token scopes: accounts:read

Path parameters

account_idstring required

Account ID

Request body

do_not_storeboolean

Do not store details

flagsstring[] required

Optimization flags

mysql_version'5.0' | '5.1' | '5.5' | '5.6' | '5.7' | '8.0' | '8.1' | '8.2' | '8.3' | '8.4' required

An enumeration.

querystring required

Query

schema_metadatastring

Schema metadata

Response

Response

Changes