Performance parameter table

Last Updated: Dec 06, 2017

ApsaraDB for MySQL

API parameter Meaning
MySQL_NetworkTraffic Average inbound traffic to a MySQL instance per second and average outbound traffic from a MySQL instance per second. Unit: KB.
MySQL_QPSTPS Average times of executing an SQL statement per second and average number of transactions per second
MySQL_Sessions Number of currently active connections and total number of current connections
MySQL_InnoDBBufferRatio Read hit rate of the InnoDB buffer pool, utilization rate of the InnoDB buffer pool, and percentage of dirty data blocks in the InnoDB buffer pool
MySQL_InnoDBDataReadWriten InnoDB average volume of data reads per second and InnoDB average volume of data writes per second. Unit: KB
MySQL_InnoDBLogRequests Average times of reading data from the InnoDB buffer pool per second and average times of writing data to the InnoDB buffer pool per second
MySQL_InnoDBLogWrites Average number of log write requests per second, Average number of physical writes performed on log files per second, and average number of fsync() writes completed on log files per second
MySQL_TempDiskTableCreates Number of temporary tables automatically created in the hard drive during MySQL statement execution
MySQL_MyISAMKeyBufferRatio Average Key Buffer utilization rate of MyISAM per second, average Key Buffer read hit rate of MyISAM per second, and average Key Buffer write hit rate of MyISAM per second
MySQL_MyISAMKeyReadWrites Average times of reading data from the buffer pool by MyISAM per second, average times of writing data to the buffer pool by MyISAM per second, average times of reading data from the hard disk by MyISAM per second, and average times of writing data to the hard disk by MyISAM per second
MySQL_COMDML Average times of DELETE statement execution per second, average times of INSERT statement execution per second, average times of INSERT_SELECT statement execution per second, average times of REPLACE statement execution per second, average times of REPLACE_SELECT statement execution per second, average times of SELECT statement execution per second, and average times of UPDATE statement execution per second
MySQL_RowDML Average number of rows read from the InnoDB table per second, average number of rows updated in the InnoDB table per second, average number of rows deleted from the InnoDB table per second, average number of rows inserted into the InnoDB table per second, and average number of physical writes performed on log files per second
MySQL_MemCpuUsage CPU usage by a MySQL instance (expressed as a percentage of the operating system’s CPU) and memory usage by a MySQL instance (expressed as a percentage of the operating system’s memory)
MySQL_IOPS IOPS (I/O requests per second) of a MySQL instance
MySQL_DetailedSpaceUsage Space usage by a MySQL instance: total space usage by the ins_size instance + data_size data space + log_size log space + tmp_size temporary space + other_size system space
slavestat Read-only instance delay

ApsaraDB for SQL Server

API Parameter Meaning
SQLServer_Transactions Average number of transactions per second
SQLServer_Sessions Total number of current connections
SQLServer_BufferHit Buffer hit rate
SQLServer_FullScans Average times of full table scan per second
SQLServer_SQLCompilations Number of SQL compilations per second
SQLServer_CheckPoint Number of times checkpoints are written to pages per second
SQLServer_Logins Login times per second
SQLServer_LockTimeout Lock timeout times per second
SQLServer_Deadlock Deadlock times per second
SQLServer_LockWaits Number of lock waits per second
SQLServer_NetworkTraffic Average inbound/outbound traffic to/from a MySQL instance per second.Unit: KB
SQLServer_QPS Average times of SQL statement execution per second
SQLServer_InstanceCPUUsage CPU usage by a MS SQL instance (expressed as a percentage of the operating system’s CPU)
SQLServer_IOPS IOPS (I/O request per second) of a MS SQL instance
SQLServer_SpaceUsage Space usage by a MS SQL instance
Thank you! We've received your feedback.