This topic describes the performance parameters of ApsaraDB for RDS.

ApsaraDB RDS for MySQL and ApsaraDB RDS for MariaDB TX

Note ApsaraDB RDS for MySQL and ApsaraDB RDS for MariaDB TX use the same parameters.
API parameter Description
MySQL_NetworkTraffic The average volume of inbound traffic to the RDS instance per second and the average volume of outbound traffic from the RDS instance per second. Unit: KB.
MySQL_QPSTPS The average number of SQL statements executed per second and the average number of transactions run per second.
MySQL_Sessions The number of active connections and the total number of connections.
MySQL_InnoDBBufferRatio The read hit ratio, usage, and dirty ratio of the InnoDB buffer pool.
MySQL_InnoDBDataReadWriten The average volume of data read from InnoDB per second and the average volume of data written to InnoDB per second. Unit: KB.
MySQL_InnoDBLogRequests The average number of reads from the InnoDB buffer pool per second and the average number of writes to the InnoDB buffer pool per second.
MySQL_InnoDBLogWrites The average number of log write requests per second, the average number of physical writes to log files per second, and the average number of writes performed by calling the fsync() function to log files per second.
MySQL_TempDiskTableCreates The number of temporary tables that are automatically created on the hard disk during statement execution.
MySQL_MyISAMKeyBufferRatio The average usage, read hit ratio, and write hit ratio of the MyISAM key buffer per second.
MySQL_MyISAMKeyReadWrites The average number of reads from the buffer pool by MyISAM per second, the average number of writes to the buffer pool by MyISAM per second, the average number of reads from the hard disk by MyISAM per second, and the average number of writes to the hard disk by MyISAM per second.
MySQL_COMDML The average number of DELETE statements executed per second, the average number of INSERT statements executed per second, the average number of INSERT_SELECT statements executed per second, the average number of REPLACE statements executed per second, the average number of REPLACE_SELECT statements executed per second, the average number of SELECT statements executed per second, and the average number of UPDATE statements executed per second.
MySQL_RowDML The average number of rows read from InnoDB tables per second, the average number of rows updated in InnoDB tables per second, the average number of rows deleted from InnoDB tables per second, the average number of rows inserted into InnoDB tables per second, and the average number of physical writes to log files per second.
MySQL_MemCpuUsage The CPU utilization and memory usage of the RDS instance within the entire operating system.
MySQL_IOPS The input/output operations per second (IOPS) of the RDS instance.
MySQL_DetailedSpaceUsage Details about the disk usage of the RDS instance. These details include the total amount of disk space occupied by the RDS instance (ins_size), the amount of disk space occupied by data files (data_size), the amount of disk space occupied by log files (log_size), the amount of disk space occupied by temporary files (tmp_size), and the amount of disk space occupied by system files (other_size).
MySQL_CPS The number of connections to the RDS instance per second.
slavestat The latency of data replication to the read-only RDS instance of the RDS instance.
MySQL_ThreadStatus The number of active threads and the number of threads connected.
MySQL_ReplicationDelay The latency of data replication to the secondary RDS instance of the RDS instance. Unit: seconds.
MySQL_ReplicationThread The status of the I/O thread and the status of the SQL thread. The value 1 indicates that the thread is normal, and the value 0 indicates that the thread is lost.

ApsaraDB RDS for SQL Server

API parameter Description
SQLServer_Transactions The average number of transactions run per second.
SQLServer_Sessions The total number of connections to the RDS instance.
SQLServer_BufferHit The cache hit ratio of the RDS instance.
SQLServer_FullScans The average number of full table scans per second.
SQLServer_SQLCompilations The number of SQL statement compilations per second.
SQLServer_CheckPoint The number of checkpoints written to pages per second.
SQLServer_Logins The number of logons per second.
SQLServer_LockTimeout The number of lock timeouts per second.
SQLServer_Deadlock The number of deadlocks per second.
SQLServer_LockWaits The number of lock waits per second.
SQLServer_NetworkTraffic The average volume of inbound traffic to the RDS instance per second and the average volume of outbound traffic from the RDS instance per second. Unit: KB.
SQLServer_QPS The average number of SQL statement executions per second.
SQLServer_InstanceCPUUsage The CPU utilization of the RDS instance within the entire operating system.
SQLServer_IOPS The IOPS of the RDS instance.
SQLServer_DetailedSpaceUsage The disk usage of the RDS instance.

ApsaraDB RDS for PostgreSQL

Storage type API parameter Description
Local SSD MemoryUsage The memory usage of the RDS instance.
CpuUsage The CPU utilization of the RDS instance.
PgSQL_SpaceUsage The disk usage of the RDS instance.
PgSQL_IOPS The IOPS of the RDS instance.
PgSQL_Session The total number of connections to the RDS instance.
Standard or enhanced SSD PolarDBConnections The following parameters are returned:
  • mean_active_session: the number of connections in the active state.
  • mean_idle_connection: the number of connections in the idle state.
  • mean_total_session: the total number of connections.
  • mean_waiting_connection: the number of connections in the waiting state.
PolarDBRowDML The following parameters are returned:
  • mean_tup_returned_delta: the number of rows returned per second by full table scans.
  • mean_tup_fetched_delta: the number of tables returned per second by index scans.
  • mean_tup_inserted_delta: the number of rows inserted per second.
  • mean_tup_updated_delta: the number of rows updated per second.
  • mean_tup_deleted_delta: the number of rows deleted per second.
PolarDBQPSTPS The following parameters are returned:
  • mean_commits_delta: the number of transactions committed per second.
  • mean_rollbacks_delta: the number of transactions rolled back per second.
  • mean_deadlocks_delta: the number of deadlocks triggered per second.
  • mean_tps: the number of transactions run per second.
PolarDBSwellTime The point in time before which the generated dead tuples can be recycled by the RDS instance. Unit: seconds.
PolarDBCPU The CPU utilization of the RDS instance.
PolarDBMemory The memory usage of the RDS instance.
PolarDBReplication The following parameters are returned:
  • mean_replay_latency_in_mb: the latency of data replication to the secondary RDS instance of the RDS instance. Unit: bytes.
  • mean_send_latency_in_mb: the latency of data replication from the RDS instance to its secondary RDS instance. Unit: bytes.
  • mean_logical_rep_latency_in_mb: the latency of logical replication. Unit: bytes.
PolarDBLongSQL The following parameters are returned:
  • mean_one_second_executing_sqls: the number of SQL statements that take more than 1 second to execute.
  • mean_three_seconds_executing_sqls: the number of SQL statements that take more than 3 seconds to execute.
  • mean_five_seconds_executing_sqls: the number of SQL statements that take more than 5 seconds to execute.
PolarDBLongIdleTransaction The following parameters are returned:
  • mean_one_second_idle_transactions: the number of transactions that sit idle for more than 1 second.
  • mean_three_seconds_idle_transactions: the number of transactions that sit idle for more than 3 seconds.
  • mean_five_seconds_idle_transactions: the number of transactions that sit idle for more than 5 seconds.
PolarDBLongTransaction The following parameters are returned:
  • mean_one_second_transactions: the number of transactions that take more than 1 second to run.
  • mean_three_seconds_transactions: the number of transactions that take more than 3 seconds to run.
PolarDBLongTwoPCTransaction The following parameters are returned:
  • mean_one_second_two_pc_transactions: the number of transactions that are committed in two phases and take more than 1 second to run.
  • mean_three_seconds_two_pc_transactions: the number of transactions that are committed in two phases and take more than 3 seconds to run.
  • mean_five_seconds_two_pc_transactions: the number of transactions that are committed in two phases and take more than 5 seconds to run.
PolarDBLocalIOSTAT The following parameters are returned:
  • mean_local_iops_read: the number of reads from the data disk per second.
  • mean_local_iops_write: the number of writes to the data disk per second.
PolarDBLocalDiskUsage The following parameters are returned:
  • mean_local_pg_wal_dir_size: the amount of disk space occupied by write-ahead log (WAL) files. Unit: MB.
  • mean_local_pg_log_dir_size: the amount of disk space occupied by log files. Unit: MB.
  • mean_local_base_dir_size: the amount of disk space occupied by data files. Unit: MB.

References