Configure and access slow query logs from the Azure portal

APPLIES TO: Azure Database for MySQL - Single Server

Important

Azure Database for MySQL - Single Server is on the retirement path. We strongly recommend for you to upgrade to Azure Database for MySQL - Flexible Server. For more information about migrating to Azure Database for MySQL - Flexible Server, see What's happening to Azure Database for MySQL Single Server?

You can configure, list, and download the Azure Database for MySQL slow query logs from the Azure portal.

Prerequisites

The steps in this article require that you have Azure Database for MySQL server.

Configure logging

Configure access to the MySQL slow query log.

  1. Sign in to the Azure portal.

  2. Select your Azure Database for MySQL server.

  3. Under the Monitoring section in the sidebar, select Server logs. Screenshot of Server logs options

  4. To see the server parameters, select Click here to enable logs and configure log parameters.

  5. Turn slow_query_log to ON.

  6. Select where to output the logs to using log_output. To send logs to both local storage and Azure Monitor Diagnostic Logs, select File.

  7. Consider setting "long_query_time" which represents query time threshold for the queries that will be collected in the slow query log file, The minimum and default values of long_query_time are 0 and 10, respectively.

  8. Adjust other parameters, such as log_slow_admin_statements to log administrative statements. By default, administrative statements are not logged, nor are queries that do not use indexes for lookups.

  9. Select Save.

    Screenshot of slow query log parameters and save.

From the Server Parameters page, you can return to the list of logs by closing the page.

View list and download logs

After logging begins, you can view a list of available slow query logs, and download individual log files.

  1. Open the Azure portal.

  2. Select your Azure Database for MySQL server.

  3. Under the Monitoring section in the sidebar, select Server logs. The page shows a list of your log files.

    Screenshot of Server logs page, with list of logs highlighted

    Tip

    The naming convention of the log is mysql-slow-< your server name>-yyyymmddhh.log. The date and time used in the file name is the time when the log was issued. Log files are rotated every 24 hours or 7.5 GB, whichever comes first.

  4. If needed, use the search box to quickly narrow down to a specific log, based on date and time. The search is on the name of the log.

  5. To download individual log files, select the down-arrow icon next to each log file in the table row.

    Screenshot of Server logs page, with down-arrow icon highlighted

Set up diagnostic logs

  1. Under the Monitoring section in the sidebar, select Diagnostic settings > Add diagnostic settings.

    Screenshot of Diagnostic settings options

  2. Provide a diagnostic setting name.

  3. Specify which data sinks to send the slow query logs (storage account, event hub, or Log Analytics workspace).

  4. Select MySqlSlowLogs as the log type. Screenshot of Diagnostic settings configuration options

  5. After you've configured the data sinks to pipe the slow query logs to, select Save. Screenshot of Diagnostic settings configuration options, with Save highlighted

  6. Access the slow query logs by exploring them in the data sinks you configured. It can take up to 10 minutes for the logs to appear.

Next steps

  • See Access slow query Logs in CLI to learn how to download slow query logs programmatically.
  • Learn more about slow query logs in Azure Database for MySQL.
  • For more information about the parameter definitions and MySQL logging, see the MySQL documentation on logs.