TopRegion analysis

Background information

In database operations, a high number of files can increase request latency. At the same time, uneven traffic distribution can overload specific nodes and create hotspots, which can lead to system-wide performance degradation and disrupt normal operations. The cluster management system provides a traffic diagnosis feature to help you identify hotspots and locate hot regions.

TopRegion real-time analysis

You can perform a real-time analysis to query for hot regions.

1. In the left-side navigation pane of the cluster management system, choose Diagnose > TopRegion Analysis.

2. Set the filter conditions, including IDC, Group, Node, sort dimension, and Table Name.

   The following table describes the sort dimensions.

   Dimension	Unit	Description
   Total requests	Requests/second	The number of requests per second for each region.
   Read requests	Requests/second	The number of read requests per second for each region.
   Write requests	Requests/second	The number of write requests per second for each region.
   region size	MB	The size of the region.
   number of files	Count	The total number of files in each region.
   read response time	ms	The average response time for read operations on each region.
   write response time	ms	The average response time for write operations on each region.
   Memstore Size	MB	The size of data in the Memstore.
   Total request data volume	KB/s	The total data volume of requests per second for each region.
   Read data volume	KB/s	The data volume of read requests per second for each region.
   Write data volume	KB/s	The data volume of write requests per second for each region.

   Note

   • In the Top text box, enter the number of records to display in the query results.

   • Enable table aggregation to display aggregated data.

   • Enable Ascending order to sort the results in ascending order.

3. Click Query.

   For example, consider a query where the sort dimension is set to Read requests, Top is set to 5, and both the Ascending order and table aggregation switches are enabled. This query first identifies the five regions with the highest number of read requests per second. Then, it groups the regions that belong to the same table. Finally, it sorts the aggregated results in ascending order by the number of read requests.

TopRegion historical snapshot

You can use historical snapshots to query for hot regions at a specific point in the past.

1. Select a IDC, Group, and Historical Snapshots.

   Note

   A Historical Snapshots represents a specific point in time. Snapshots are captured at 30-second intervals.

2. Click Query.

   The query results are divided into the following two sections:

   • Top Requests: The tables with the highest total request count in the specified time period and their corresponding regions. By default, the top 10 tables are displayed.

   • Top Data Volume: The tables with the largest total data volume in the specified time period and their corresponding regions. By default, the top 10 tables are displayed.

3. (Optional) Click the icon next to a table name to view the details of the table's regions.