Tair:Slow queries

Procedure

1. Log on to the Tair console and go to the Instances page. In the top navigation bar, select the region in which the instance that you want to manage resides. Then, find the instance and click the instance ID.

2. In the left-side navigation pane, choose CloudDBA > Slow Queries.

3. On the slow queries page, view Slow Log Trend and Slow Log Details.

   • Slow Log Trend

     In the Slow Log Trend section, you can view the number of slow query logs and CPU utilization for the instance within a specified period. You can click a specific point in time to view the slog query log details.

     Note

     If your instance uses the cluster or read/write splitting architecture, the following information is displayed: the slow query log details for data nodes and proxy nodes and the number of slow queries of each node.

   • Slow Log Details

     By default, the details of all slow queries are displayed in the following columns: Query Started At, Database Name, Slow Query Statement, Elapsed, and Host Address. You can click Set to filter the columns.

     Note

     • You can click Export Slow Log in the upper-right corner to export slow query logs to local storage for analysis.

     • By default, the Host Address parameter for cluster instances and read/write splitting instances displays the IP addresses of proxy nodes. To obtain the IP address of a specific client, set ptod_enabled to 1 in System Parameters. For more information, see Configure instance parameters.