Request analysis
Database Autonomy Service (DAS) supports request analysis, which allows you to view global slow query logs and perform full request analysis.
Prerequisites
Your database instance must meet the following requirements:
-
The global slow query log feature supports only the following database instances:
-
ApsaraDB RDS for MySQL
-
ApsaraDB MyBase for MySQL
-
PolarDB for MySQL
ImportantThe global slow query log feature is available only in the Chinese mainland.
-
-
The full request feature has the following requirements:
-
This feature is available only for database instances in the China (Shanghai) region.
-
The database instance must have DAS Enterprise Edition enabled. For more information, see Manage DAS audit logs and O&M services (formerly Economy Edition).
-
Slow query log
Log on to the DAS console.
-
In the left-side navigation pane, choose .
-
On the Slow log page, select a target database engine to view its global slow query log.
-
Select a time range to view the Global Slow Log Trend chart and Top Instance Statistics table. You can select a time range in one of the following ways:
-
Click Last 1 Day, Previous 3 Days, or Last 7 Days to view data for the corresponding period.
-
Set a start and end date, and then click View.
NoteThe end time must be later than the start time. You can view the global slow query log trend for up to two weeks.
-
-
In the Global Slow Log Trend line chart, click a data point to view the corresponding database instances in the Top Instance Statistics area.
-
Full request
Log on to the DAS console.
-
In the left-side navigation pane, choose .
Note-
You can set a time range and click View to view the Full Request Trend chart and the Full Request Statistics table.
-
You can Export data from the Full Request Statistics table. A single Export can contain up to 10 million rows.
-