Performance Trends

Last updated: 2020-10-22 16:48:05

    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 only for TencentDB for MySQL (excluding the Basic Edition).

    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, select Performance Optimization on the left sidebar, and select Performance Trends at the top.
    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:

    Resource Monitoring CPU CPU
    Memory Memory
    Memory usage
    Storage space Disk utilization
    Occupied disk space
    Traffic Outbound traffic
    Inbound traffic
    MySQL Server TPS/QPS TPS/QPS
    Connection Max connections
    Connected threads
    Running threads
    Created threads
    Requests Select
    Update
    Delete
    Insert
    Replace
    Total requests
    Slow query Slow queries
    Full-table scans
    InnoDB Engine InnoDB buffer pool pages InnoDB empty pages
    Total InnoDB pages
    InnoDB logical reads
    InnoDB physical reads
    Read/Written InnoDB data InnoDB reads
    InnoDB writes
    InnoDB data reads/writes Total InnoDB reads
    Total InnoDB writes
    InnoDB row operations InnoDB rows deleted
    InnoDB rows inserted
    InnoDB rows updated
    InnoDB rows read
    InnoDB row lock InnoDB row lock waits
    Average InnoDB row lock acquiring time
    MySQL Replication Replication status Source-replica delay distance
    Source-replica delay time
    Replication delay IO thread status
    SQL thread status

    Enabling Chart Interaction

    1. Log in to the DBbrain Console, select Performance Optimization on the left sidebar, and select Performance Trends at the top.
    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, select Performance Optimization on the left sidebar, and select Performance Trends at the top.
    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.

    Was this page helpful?

    Was this page helpful?

    • Not at all
    • Not very helpful
    • Somewhat helpful
    • Very helpful
    • Extremely helpful
    Send Feedback
    Help