All Products
Search
Document Center

Procedure

Last Updated: Jun 11, 2020

This topic describes how to enable, use, and disable the full request analysis feature of Database Autonomy Service (DAS). DAS is previously known as Hybrid Cloud Database Management (HDM).

Prerequisites

  • You remain logged on to the DAS console.

  • The target database instance is connected to DAS. For more information about how to connect database instances to DAS, see Connect database instances.

Limits

Currently, the full request analysis feature is available only for MySQL databases.

Procedure

Enable full request analysis

By default, the full request analysis feature is disabled. To enable the feature, follow these steps:

  • In the left-side navigation pane, click Instance Monitoring. On the page that appears, find the target database instance and click the ID of the target database instance. Note that the target database instance must be in the Accessed state.

  • In the left-side navigation pane of the page that appears, click Full Request.

  • On the page that appears, click Enable. In the message that appears, click OK.

After about 10 minutes, you can view the general trends and the statistics of all the SQL requests.

Key features

Execution duration distribution

In the Execution Duration Distribution section, the blue color indicates a high health score for the execution of SQL statements. The orange or the red color indicates a low health score for the execution of SQL statements. FullRequest1

In the Execution Duration Distribution section, you can specify a time range to view the execution duration distribution of SQL statements. The statistical data of execution durations is collected every minute, and the execution durations of SQL statements are divided into the following ranges:

[0,1] ms: indicates that the execution duration ranges from 0 ms to 1 ms. From the chart of execution duration distribution, you can view the percentage of the SQL statements whose execution durations fall within this range.

(1,2] ms: indicates that the execution duration is greater than 1 ms and less than or equal to 2 ms. From the chart of execution duration distribution, you can view the percentage of the SQL statements whose execution durations fall within this range.

(2,3] ms: indicates that the execution duration is greater than 2 ms and less than or equal to 3 ms. From the chart of execution duration distribution, you can view the percentage of the SQL statements whose execution durations fall within this range.

(3,10] ms: indicates that the execution duration is greater than 3 ms and less than or equal to 10 ms. From the chart of execution duration distribution, you can view the percentage of the SQL statements whose execution durations fall within this range.

(10,100] ms: indicates that the execution duration is greater than 10 ms and less than or equal to 100 ms. From the chart of execution duration distribution, you can view the percentage of the SQL statements whose execution durations fall within this range.

(0.1,1] seconds: indicates that the execution duration is greater than 100 ms and less than or equal to 1,000 ms. From the chart of execution duration distribution, you can view the percentage of the SQL statements whose execution durations fall within this range.

> 1 seconds: indicates that the execution duration is greater than 1,000 ms. From the chart of execution duration distribution, you can view the percentage of the SQL statements whose execution durations fall within this range.

Example:

2018-10-08 10:40:00

At this time, the percentage of the SQL statements whose execution durations fall within the [[0,1] ms] range is 34.30%.

At this time, the percentage of the SQL statements whose execution durations fall within the (10,100] ms range is 23.13%.

At this time, the percentage of the SQL statements whose execution durations fall within the (0.1,1] seconds range is 25.98%.

Execution duration

You can specify a time range to view the execution durations of SQL statements.
FullRequest2

SQL request statistics

After you specify a time range, you can view the SQL statement details in the Full Request Statistics section. The details include the SQL text, execution duration distribution, average execution duration, and execution trends for each SQL statement.

You can calculate the execution duration percentage for each SQL statement based on the specified formula. The formula is described as follows: Execution duration percentage = (Execution duration of an SQL statement × Number of all the executed SQL statements)/(Total execution duration of all the SQL statements × Number of all the executed SQL statements) × 100%.

Higher execution duration percentages indicate that the execution of SQL statements occupies a larger number of MySQL resources. You can optimize these SQL statements to achieve high cost-effectiveness. The following figure shows an example.
FullRequest3

You can click the ID of an SQL statement to view the performance trend and the sample data of the SQL statement.

SQL sample

On the SQL Sample tab, you can view the client IP address from which each SQL request is sent.
FullRequest4