edit-icon download-icon

View performance monitoring list

Last Updated: Jul 13, 2016

For the convenience of developers, MySQL offers a variety of monitoring items on the console. As shown in the table below:


Monitored Item

Meaning

Disk Space

Trend of Space Usage History of Instance (Unit: GB)

IOPS

IOPS of ApsaraDB for RDS Instance

Connections

Total Number of Current Connections

CPU Utilization

CPU Utilization (Percentage in the OS) of ApsaraDB for RDS Instance

Network Traffic

The average input/output traffic flow of MySQL instances (Unit: KB)

QPS/TPS

Executions of SQL queries per second and transactions processed

InnoDB buffer pool

Read hit ratio, utilization % and dirty block percentage of InnoDB buffer pool

InnoDB reads and writes

InnoDB reads and writes per second

InnoDB logs

Writes into InnoDB logs

Temporary Table

Number of temporary tables created automatically on the hard disk when the MySQL query is in process

MyISAM Key Buffer

Average MyISAM Key Buffer usage per second

MyISAM reads and writes

Average MyISAM reads and writes per second

COMDML

Executions of MySQL queries per second. The involved query includes Insert, Delete, Insert_Select, Replace, Replace_Select, and Select.

ROWDML

Lines of InnoDB operations per second. Five types of operations are involved, namely, average physical writes to log files per second, and the average line "Delete/Update/Read/Insert" operations in InnoDB tables per second.


For the convenience of developers, SQLServer offers a variety of monitoring items on the console.As shown in the table below:


Monitored Item

Meaning

Connections

Total Number of Current Connections

Buffer Hit Ratio

Buffer Hit Ratio

Average full table scans per second

Average full table scans per second

SQL compilation per second

SQL statements complied per second in the instance

Written pages at the check point per second

Written pages at the check point per second

Logins per second

Logins per second

Lock timeouts per second

Lock timeouts per second

Deadlocks per second

Deadlocks per second

Lock waits per second

Lock waits per second

Network traffic

Average input/output traffic flow of SQL Server instance per secondUnit: KB.

QPS/TPS

Average executions of SQL queries per second and transaction counts.

CPU Utilization

CPU Utilization (Percentage in the OS) of ApsaraDB for RDS Instance

IOPS

IOPS of ApsaraDB for RDS Instance

Disk Space

Space Usage of ApsaraDB for RDS Instance

Thank you! We've received your feedback.