Microsoft Azure

Azure Database for MySQL: Query Performance Insights

The Microsoft Azure management API provides create, read, update, and delete functionality for Azure MySQL resources including servers, databases, firewall…

Data & analytics#openapi#cloud

Fork copies the collection into your workspace, without the publisher's secrets, so you can add your own key and send requests. Star saves it to your starred APIs (Account › Marketplace) and helps others find it.

Overview

The Microsoft Azure management API provides create, read, update, and delete functionality for Azure MySQL resources including servers, databases, firewall rules, VNET rules, security alert policies, log files and configurations with new business model.

Endpoints 7

QueryTexts

  • GETQueryTexts_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/queryTexts/:queryIdRetrieve the Query-Store query texts for the queryId.
  • GETQueryTexts_ListByServer/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/queryTexts?queryIds=stringRetrieve the Query-Store query texts for specified queryIds.

TopQueryStatistics

  • GETTopQueryStatistics_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/topQueryStatistics/:queryStatisticIdRetrieve the query statistic for specified identifier.
  • GETTopQueryStatistics_ListByServer/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/topQueryStatisticsRetrieve the Query-Store top queries for specified metric and aggregation.

WaitStatistics

  • GETWaitStatistics_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/waitStatistics/:waitStatisticsIdRetrieve wait statistics for specified identifier.
  • GETWaitStatistics_ListByServer/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/waitStatisticsRetrieve wait statistics for specified aggregation window.

ResetQueryPerformanceInsightData

  • POSTResetQueryPerformanceInsightData/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/resetQueryPerformanceInsightDataReset data for Query Performance Insight.

API details

Base URL
https://management.azure.com
Authentication
OAuth 2.0 (implicit flow) with 1 scope
Operations
7 operations on 7 pathsGET 6POST 1
Main resources
QueryTexts 2TopQueryStatistics 2WaitStatistics 2ResetQueryPerformanceInsightData 1
Response formats
application/json
Description format
Swagger 2.0, API version 2018-06-01

How to test the Azure Database for MySQL: Query Performance Insights in Swastik Codes

  1. Open the APISelect “Fork & run in Swastik Codes” on this page. Sign in or create a free account if asked.
  2. Fork it into your workspaceChoose a workspace. You get your own copy of the Azure Database for MySQL: Query Performance Insights collection, without the publisher's secrets.
  3. Add your credentialsThis API uses OAuth 2.0 (implicit flow) with 1 scope. Add yours in the collection's variables or an environment; the requests already reference it.
  4. Send a requestPick an endpoint, for example “QueryTexts_Get” (GET /subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforMySQL/servers/:serverName/queryTexts/:queryId), and press Send. Check the response, add tests and run the whole collection with the runner.

Frequently asked questions

What is the Azure Database for MySQL: Query Performance Insights?

The Microsoft Azure management API provides create, read, update, and delete functionality for Azure MySQL resources including servers, databases, firewall… It is listed under Data & analytics and has 7 endpoints.

Who publishes the Azure Database for MySQL: Query Performance Insights?

It is listed from Microsoft Azure's public API description (an OpenAPI document), not published by Microsoft Azure on Swastik Codes. Anyone who controls azure.com can claim the profile by adding a DNS TXT record.

What is the base URL of the Azure Database for MySQL: Query Performance Insights?

Requests go to https://management.azure.com. Endpoint paths are added to this base URL.

How do I authenticate with the Azure Database for MySQL: Query Performance Insights?

With OAuth 2.0 (implicit flow) with 1 scope.

How many endpoints does the Azure Database for MySQL: Query Performance Insights have?

7 operations on 7 paths (6 GET, 1 POST). The largest groups are QueryTexts, TopQueryStatistics, WaitStatistics, ResetQueryPerformanceInsightData.

Is forking the Azure Database for MySQL: Query Performance Insights free?

Yes. Forking copies the collection into your workspace for free. It has been starred 0 times and forked 0 times.

Suggest an API

Tell us which public API is missing. We check it, then add it here with its endpoints when it has an OpenAPI (Swagger) description.