vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/das/umn/das_02_0005.html
Wang , Deng Ke 0f41701050 DAS UMN Initial version 
Reviewed-by: gtema <artem.goncharov@gmail.com>
Co-authored-by: Wang , Deng Ke <wangdengke2@huawei.com>
Co-committed-by: Wang , Deng Ke <wangdengke2@huawei.com>
2022-10-18 12:51:00 +00:00

4.8 KiB
Raw Permalink Blame History

Step 2: Switch to Intelligent O&M

Procedure

  1. In the navigation pane, choose Intelligent O&M, on the Instance Overview page, click Synchronize Instances and then click Refresh.

    Instance synchronization is an asynchronous process, which takes several minutes.

  2. Locate the instance you want to view and click Details.

    This section uses SQL Explorer as an example. For details about how to use each metric, see "Intelligent O&M for RDS for MySQL".

  3. On the displayed page, choose SQL > SQL Explorer.

    • Enable DAS SQL Explorer must be enabled so that the system can collect and analyze full SQL statements.
    • With Enable DAS SQL Explorer enabled, the instance performance loss is within 5%.

  4. Click the SQL Statements tab.

    • A maximum of 10,000 data records can be displayed on the SQL Statements tab page. To view more records, export the records for view. Columns such as execution duration, elapsed time, scanned rows, and lock wait are also provided. Additionally, SQL statements can be searched by multiple dimensions, including keyword, time range, and number of updated rows.
    • To view more records, click Export to create an export task. Click Export History to check whether the export task succeeded.
    • After the export succeeded, download the file and view the records on the local PC.

  5. Click the SQL Templates tab.

    • By default, the SQL statement executions in the last 1 hour are displayed. You can also specify a time range as needed. Columns such as average duration, total duration, total executions, and average scanned rows are provided.

  6. Click Details in the Operation column to view the SQL template details.
  7. Click the SQL Statement Types tab.
  8. Click Details in the Operation column to view SQL details.
Parent topic: Intelligent O&M