• Relational Database Service

rds
  1. Help Center
  2. Relational Database Service
  3. User Guide
  4. Working with RDS for MySQL
  5. Viewing Monitoring Metrics

Viewing Monitoring Metrics

  • Table 1 lists details about ECS monitoring metrics.
  • For details on database monitoring metrics, see Table 1.
    Table 1 Database performance monitoring metrics list

    Metric

    Description

    Value Range

    Total Connections

    Measures the total number of connection attempts to the MySQL server.

    ≥ 0 counts

    Current Active Connections

    Measures the number of current active connections.

    ≥ 0 counts

    QPS

    Measures the rate at which SQL statement queries (including the stored procedure) are executed.

    ≥0 executions/s

    TPS

    Measures the rate at which transactions (including those submitted and rolled back) are executed.

    ≥ 0 transactions/s

    Buffer Pool Usage

    Measures the ratio of dirty data to all data in the InnoDB buffer.

    0 to 1

    Buffer Pool Hit Rate

    Measures the ratio of read hits to read requests in the InnoDB buffer.

    0 to 1

    Buffer Pool Dirty Block Rate

    Measures the ratio of used pages to total data in the InnoDB buffer.

    0 to 1

    InnoDB Read Throughput

    Measures the average rate at which data is read by the InnoDB buffer.

    ≥ 0 bytes/s

    InnoDB Write Throughput

    Measures the average rate at which data is written by the InnoDB buffer.

    ≥ 0 bytes/s

    InnoDB File Read Frequency

    Measures the average rate at which the InnoDB reads files.

    ≥ 0 counts/s

    InnoDB File Write Frequency

    Measures the average rate at which InnoDB writes data.

    ≥ 0 counts/s

    InnoDB Log Write Request Frequency

    Measures the average rate at which log write requests are received.

    ≥ 0 counts/s

    InnoDB Log Physical Write Frequency

    Measures the average rate at which physical writes occur for log files.

    ≥ 0 counts/s

    InnoDB Log fsync() Write Frequency

    Measures the average rate at which fsync() write requests on log files are received.

    ≥ 0 counts/s

    Temporary Tables Qty

    Measures the number of temporary tables automatically created on hard disks when MySQL statements are executed.

    ≥ 0 tables

    Key Buffer Usage

    Measures the MyISAM key buffer usage ratio.

    0 to 1

    Key Buffer Write Hit Rate

    Measures MyISAM Key buffer write hit ratio of the monitored object.

    0 to 1

    Key Buffer Read Hit Rate

    Measures MyISAM Key buffer read hit ratio of the monitored object.

    0 to 1

    MyISAM Disk Write Frequency

    Measures the rate at which indexes are written into disks.

    ≥ 0 counts/s

    MyISAM Disk Read Frequency

    Measures the rate at which indexes are read from disks.

    ≥ 0 counts/s

    MyISAM Buffer Pool Write Frequency

    Measures the rate at which requests on writing indexes into the MyISAM buffer pool are received.

    ≥ 0 counts/s

    MyISAM Buffer Pool Read Frequency

    Measures the rate at which requests on reading indexes from the MyISAM buffer pool are received.

    ≥ 0 counts/s

    Delete Operations per Second

    Measures the average rate at which Delete statements are executed.

    ≥0 executions/s

    Insert Operations per Second

    Measures the average rate at which Insert statements are executed.

    ≥0 executions/s

    Insert_Select Operations per Second

    Measures the average rate at which Insert_Select statements are executed.

    ≥0 executions/s

    Replace Operations per Second

    Measures the average rate at which Replace statements are executed.

    ≥0 executions/s

    Replace_Selection Operations per Second

    Measures the average rate at which Replace_Selection statements are executed.

    ≥0 executions/s

    Select Operations per Second

    Measures the average rate at which Select statements are executed.

    ≥0 executions/s

    Update Operations per Second

    Measures the average rate at which Update statements are executed.

    ≥0 executions/s

    Row Delete Speed

    Measures the average rate at which rows are deleted from the InnoDB table.

    ≥ 0 rows/s

    Row Insert Speed

    Measures the average rate at which rows are inserted into the InnoDB table.

    ≥ 0 rows/s

    Row Read Speed

    Measures the average rate at which rows are read from the InnoDB table.

    ≥ 0 rows/s

    Row Update Speed

    Measures the average rate at which rows are updated in the InnoDB table.

    ≥ 0 rows/s

    Connection Usage

    Measures the percentage of used MySQL connections in the total number of connections.

    0% to 100%

    Replication Lag

    Measures the data replication delay of the slave node in the MySQL primary/standby relationship.

    ≥ 0s

    Number of Slow Query Logs

    Measures the number of slow query logs generated per minute by MySQL.

    ≥ 0 counts/min