EverSQL Performance Sensor can automatically track your Azure Databases (MySQL & PostgreSQL) instances performance, to generate actionable AI-powered optimization insights for you.
To integrate EverSQL Sensor with Azure Databases, please follow these steps.
Step #1: Enable the slow query log
If you already have slow query logs enabled for your Azure Database instance, you can skip to the next section.
To enable slow query logs:
- Navigate to your database instance configuration page.
- On the left side, choose Server Parameters.
- For MySQL, configure the following flags:
- slow_query_log - On
- long_query_time - Threshold in seconds that is considered as 'slow'. For example, configuring 1 means to log any query that executes for longer than 1 second.
- For PostgreSQL, configure the following flag:
- log_min_duration_statement - The threshold in milliseconds that is considered as 'slow'. For example, configuring 500 means to log any query that executes for longer than 500 millisecond (0.5 a second).
- log_min_duration_statement - The threshold in milliseconds that is considered as 'slow'. For example, configuring 500 means to log any query that executes for longer than 500 millisecond (0.5 a second).
Step #2: Configure slow logs to be saved in a storage container
- In the Storage section of Azure, please create a new storage container that will hold the slow query logs of this database instance. Remember the resource group name you choose for this storage container, as you'll use the name of this storage container during the sensor installation steps (after enabling the slow query logs as described below).
- Then, in the DB instance configuration page, on the left side, choose Diagnostic Settings.
- Choose Add Diagnostic Setting
- Choose MySQLSlowLogs (for MySQL instances), orPostgreSQLLogs (for PostgreSQL instances) in the Categories section.
- Choose Archive to a storage account, in the Destination Details section.
- Click Save.
Step #3: Install the Performance Sensor
Now that we have the slow query logs redirected to a storage container, you can start the sensor installation, as described in the sensors installation page.