Slow Queries

Scenarios

DDM provides a Slow Queries function that sorts out the same type of slow SQL statements within a specified period of time by SQL template. You can specify a time range, search for all types of slow SQL statements within the time range, and then optimize them.

Procedure

1. Log in to the DDM console.
2. On the Instances page, locate the required instance and click its name.
3. In the navigation pane, choose Slow Queries.
   Figure 1 Slow Queries page
   
   • On the Slow Queries page, specify a time range and view SQL statements executed within this time range.
   • In the upper right corner of the page, you can click to export slow query logs.
     

     The size of the exported slow query log file cannot exceed 8 MB. You can select different periods to export slow query log files in batches.