The performance trends feature of DBbrain not only supports the selection of multiple performance metrics such as key metrics, all metrics, and custom metrics, but also supports multiple ways to view performance trends, such as fine-grained view of one single performance metric trend, link comparison view of multiple performance metric trends, and time comparison view of multiple performance metric trends.

Note：

Currently, the performance trends feature is supported for TencentDB for MySQL (excluding the Basic Edition) and TencentDB for CynosDB (compatible with MySQL).

Viewing Performance Trend Metrics

The performance trends feature supports selection of multiple performance metrics, including 4 categories (Resource Monitoring, MySQL Server, InnoDB Engine, and MySQL Replication) and 15 subcategories. You can select different metrics based on different OPS needs to view the performance trends of the selected instance against the selected metrics.

1. Log in to the DBbrain Console and select Performance Optimizationon the left sidebar. On the displayed page, select a database at the top and select the Performance Trends tab.
2. On the performance trends page, click the "Select performance metrics" drop-down list.
3. On the performance metrics selection page, check performance metrics or select Key Metrics, Select all or Deselect all in the top-right corner, and click OK.

   Note：

   Click Apply to all instances to apply the selected metrics to all database instances.

   

The performance trends feature currently supports the following performance metrics:

Enabling Chart Interaction

1. Log in to the DBbrain Console and select Performance Optimizationon the left sidebar. On the displayed page, select a database at the top and select the Performance Trends tab.
2. On the performance trends page, toggle on the "Chart Interaction" switch in the top-right corner to view the link comparison of multiple performance metric trends.
   
   Drag on the view for fine-grained display of one single performance metric trend.
   

Switching Between Real-Time/Historical Views

1. Log in to the DBbrain Console and select Performance Optimizationon the left sidebar. On the displayed page, select a database at the top and select the Performance Trends tab.
2. Click Real-Time or Historical to view the corresponding real-time or historical performance trends.
   • The real-time performance trends view allows you to view the performance trends of the instance over the last 3 minutes and is automatically refreshed by default. Click Disable refresh to stop refreshing the trends in real time.
     
   • In the historical performance trends view, you can select a time period to display the view of performance trends over the selected time period, and you can switch among the last hour, last 3 hours, last 24 hours, last 7 days, and custom time period.
     
     Click Add Time Comparison and select the desired time period for comparison to view the time comparison of multiple performance metric trends.