All Products
Search

This Product

    Performance trends

    Document Center

    Performance trends

    Last Updated: Jun 02, 2020

    This topic describes performance metrics supported in the performance trend feature of DAS and how to view these performance metrics.
    The performance trend feature supports metrics such as TPS, QPS, and IOPS. You can View performance trends, and Customize performance trends.

    Prerequisites

    DAS has accessed the database instance and the access status is Accessed. The exception detection feature is only available to MySQL databases.

    For more information about how to access a database instance, see

    Performance metrics

    The Performance Trends tab of DAS displays the following metrics (MySQL databases are used as an example).

    You can view the description of each metric by clicking Definition? on the tab.

    Metric Unit Description
    mysql.tps Per second The number of transactions per second
    mysql.qps Per second The number of requests per second
    mysql.total_session Count All sessions
    mysql.active_session Count Active sessions
    mysql.bytes_received KByte The average number of bytes received from all clients per second
    mysql.bytes_sent KByte The average number of bytes sent to all clients per second
    mysql.tb.tmp.disk Count The number of temporary tables created automatically on the hard disk when statements are executed on the MySQL instance
    mysql.insert_ps Per second The average number of INSERT statements executed per second
    mysql.select_ps Per second The average number of SELECT statements executed per second
    mysql.update_ps Per second The average number of UPDATE statements executed per second
    mysql.delete_ps Per second The average number of DELETE statements executed per second
    mysql.replace_ps Per second The average number of REPLACE statements executed per second
    mysql.innodb_data_written KByte The average number of bytes written by InnoDB per second
    mysql.innodb_data_read KByte The average number of bytes read by InnoDB per second
    mysql.innodb_buffer_pool_reads_requests Count The average number of page reads by InnoDB buffer pool (logical reads) per second.
    mysql.innodb_bp_dirty_pct % The dirty page ratio of InnoDB buffer pool.
    Formula: Innodb_buffer_pool_pages_dirty/Innodb_buffer_pool_pages_data × 100%
    mysql.innodb_bp_hit % The read hit rate of InnoDB buffer pool.
    Formula: (Innodb_buffer_pool_read_requests - Innodb_buffer_pool_reads)/Innodb_buffer_pool_read_requests × 100%
    mysql.innodb_bp_usage_pct % The usage of InnoDB buffer pool.
    Formula: Innodb_buffer_pool_pages_data/(Innodb_buffer_pool_pages_data + innodb_buffer_pool_pages_free) × 100%
    mysql.innodb_log_writes Per second The average number of redo log file physical writes to InnoDB per second
    mysql.innodb_os_log_fsyncs Per second Average number of fsync() writes to the log file per second
    mysql.innodb_rows_deleted Per second The average number of rows deleted by InnoDB per second
    mysql.innodb_rows_read Per second The average number of rows read by InnoDB per second
    mysql.innodb_rows_inserted Per second The average number of rows inserted by InnoDB per second
    mysql.innodb_log_writes Per second The average number of redo log file physical writes to InnoDB per second
    mysql.innodb_rows_updated Per second The average number of rows updated by InnoDB per second
    mysql.mem_usage % The CPU utilization of the MySQL instance within the entire operating system.
    mysql.cpu_usage % The CPU utilization of MySQL processes (up to 100% of Alibaba Cloud databases)
    mysql.data.size MByte The data space
    mysql.tmp.size MByte The temporary space
    mysql.other.size MByte The system space
    mysql.instance.size MByte The total space usage of the MySQL instance
    mysql.log.size MByte The log space
    mysql.iops Count The IOPS of the MySQL instance

    View performance trends

    You can view performance trends within a specified time range.

    Procedure

    1. Log on to the DAS console.

    2. In the left-side navigation pane, click Instance Monitoring.

    3. Find the target instance. Choose Performance > Performance Trend in the Actions column.Console 1

    4. Specify a time range and select target metrics from the More Metrics drop-down list. Click Search.1

    View performance trend comparison

    You can compare performance trends withing two specified time ranges.

    Procedure

    1. Log on to the DAS console.
    2. In the left-side navigation pane, click Instance Monitoring.
    3. Find the target instance. Choose Performance > Performance Trend in the Actions column.
    4. Click the Performance Trend Comparison tab.
    5. Specify two time ranges and then click Search.

    Customize performance trends

    You can customize multiple performance monitoring dashboards and display multiple performance metrics in the same chart for troubleshooting and analysis.

    Procedure

    1. Log on to the DAS console.
    2. In the left-side navigation pane, click Instance Monitoring.
    3. Find the target instance. Choose Performance > Performance Trend in the Actions column.
    4. Click Custom Chart tab.

    If you are using the feature for the first time, you must create a Monitoring Dashboard first. For more information, see Monitoring dashboards.
    Specify a time range and then click Search.

    Free Trial Free Trial