All Products
Search
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.