DocsICP FilingConsole
官方文档
首页

Performance parameters

更新时间：
复制 MD 格式
产品详情
我的收藏

ApsaraDB RDS exposes performance parameters that you can query through the DescribeDBInstancePerformance API operation and view in the ApsaraDB RDS console. Use these parameters to monitor resource consumption, detect bottlenecks, and troubleshoot performance issues across your RDS instances.

ApsaraDB RDS for MySQL and ApsaraDB RDS for MariaDB

Note

ApsaraDB RDS for MySQL and ApsaraDB RDS for MariaDB use the same parameters.

Value of Key

Returned metrics and descriptions

MySQL_NetworkTrafficAverage inbound and outbound network traffic per second. Unit: KB/s.
MySQL_QPSTPSAverage number of SQL statements executed per second (QPS) and average number of transactions executed per second (TPS).
MySQL_SessionsNumber of active connections and total connections. Unit: counts.
MySQL_InnoDBBufferRatioRead hit ratio, usage, and dirty ratio of the InnoDB buffer pool. Unit: %.
MySQL_InnoDBDataReadWritenAverage data read and written by InnoDB per second. Unit: KB.
MySQL_InnoDBLogRequestsAverage reads from and writes to the InnoDB buffer pool per second. Unit: counts/s.
MySQL_InnoDBLogWritesAverage log write requests per second, average physical writes to log files per second, and average writes to log files via fsync() per second. Unit: counts/s.
MySQL_TempDiskTableCreatesNumber of temporary tables automatically created on disk during statement execution. Unit: tables.
MySQL_MyISAMKeyBufferRatioAverage usage, read hit ratio, and write hit ratio of the MyISAM key buffer per second. Unit: %.
MySQL_MyISAMKeyReadWritesAverage reads from and writes to the MyISAM buffer pool per second, and average reads from and writes to disk by MyISAM per second. Unit: counts/s.
MySQL_COMDMLAverage number of DELETE, INSERT, INSERT_SELECT, REPLACE, REPLACE_SELECT, SELECT, and UPDATE statements executed per second. Unit: counts/s.
MySQL_RowDMLAverage rows read, updated, deleted, and inserted in InnoDB tables per second, and average physical writes to log files per second. Unit: row/s or count/s.
MySQL_MemCpuUsageCPU utilization and memory usage of a non-serverless ApsaraDB RDS for MySQL instance at the operating system level. Unit: %.
MySQL_RCU_MemCpuUsageCPU utilization and memory usage of a serverless ApsaraDB RDS for MySQL instance at the operating system level. Unit: %.
MySQL_IOPSInput/output operations per second (IOPS) of the ApsaraDB RDS instance. Unit: counts/s.
MySQL_DetailedSpaceUsageDisk space breakdown for the ApsaraDB RDS instance: total disk space, data files, log files, temporary files, and system files. Unit: MB.
slavestatReplication delay to the read-only instance. Unit: seconds.
MySQL_ThreadStatusNumber of active threads and connected threads. Unit: counts.
MySQL_ReplicationDelayReplication delay to the secondary instance. Unit: seconds.
MySQL_ReplicationThreadStatus of the I/O thread and SQL thread. 1 indicates the thread is running normally; 0 indicates the thread is lost.
MySQL_ROW_LOCKMaximum wait time for a row-level lock (ms), average wait time for row-level locks (ms), and total number of row-level lock waits.
MySQL_SelectScanNumber of full table scans performed on the ApsaraDB RDS instance. Unit: scans.
MySQL_MBPSRead and write throughput per second. Unit: bytes/s.

ApsaraDB RDS for SQL Server

Value of Key

Returned metric

Description

SQLServer_TransactionsAverage number of transactions per second. Unit: counts/s.
SQLServer_SessionsTotal number of connections. Unit: counts.
SQLServer_BufferHitCache hit ratio. Unit: %.
SQLServer_FullScansAverage number of full table scans per second. Unit: counts/s.
SQLServer_SQLCompilationsNumber of SQL statement compilations per second. Unit: counts/s.
SQLServer_CheckPointNumber of checkpoint writes to pages per second. Unit: counts/s.
SQLServer_LoginsNumber of logons per second. Unit: counts/s.
SQLServer_LockTimeoutNumber of lock timeouts per second. Unit: counts/s.
SQLServer_DeadlockNumber of deadlocks per second. Unit: counts/s.
SQLServer_LockWaitsNumber of lock waits per second. Unit: counts/s.
SQLServer_NetworkTrafficAverage inbound and outbound network traffic per second. Unit: KB/s.
SQLServer_QPSAverage number of SQL statements executed per second. Unit: counts/s.
SQLServer_InstanceCPUUsageCPU utilization of the ApsaraDB RDS instance at the operating system level. Unit: %.
SQLServer_IOPSIOPS of the ApsaraDB RDS instance. Unit: counts/s.
SQLServer_DetailedSpaceUsageDisk usage of the ApsaraDB RDS instance. Unit: MB.

ApsaraDB RDS for PostgreSQL

Note

ApsaraDB RDS for PostgreSQL supports more fine-grained enhanced monitoring metrics in the ApsaraDB RDS console. For details, see View enhanced monitoring. The table below maps DescribeDBInstancePerformance parameter values to their corresponding enhanced monitoring metrics.

Value of Key

Returned metrics and descriptions

Corresponding enhanced monitoring metric

MemoryUsageMemory usage. Unit: %.os.mem_usage.total.avg
CpuUsageCPU utilization. Unit: %.os.cpu_usage.total.avg
PgSQL_SpaceUsageDisk usage of the ApsaraDB RDS instance. Unit: bytes.os.fs_size.wal_dir.avg + os.fs_size.base_dir.avg (Unit: MB)
PgSQL_IOPSIOPS of the ApsaraDB RDS instance. Unit: counts/s.(os.iops.data.avg + os.iops.wal.avg) / os.iops.total.avg × 100
PgSQL_SessionTotal number of connections. Unit: counts.db.connections.total.avg
PolarDBConnectionsReturns the following sub-metrics:
  • mean_active_session: number of active connections.
  • mean_idle_connection: number of idle connections.
  • mean_total_session: total number of connections.
  • mean_waiting_connection: number of connections in the waiting state.
  • db.connections.active.avg
  • db.connections.idle.avg
  • db.connections.total.avg
  • db.connections.waiting.avg
PolarDBRowDMLReturns the following sub-metrics:
  • mean_tup_returned_delta: rows returned per second by full table scans.
  • mean_tup_fetched_delta: rows returned per second by index scans.
  • mean_tup_inserted_delta: rows inserted per second.
  • mean_tup_updated_delta: rows updated per second.
  • mean_tup_deleted_delta: rows deleted per second.
  • db.sql.tup_returned.avg
  • db.sql.tup_fetched.avg
  • db.sql.tup_inserted.avg
  • db.sql.tup_updated.avg
  • db.sql.tup_deleted.avg
PolarDBQPSTPSReturns the following sub-metrics:
  • mean_commits_delta: transactions committed per second.
  • mean_rollbacks_delta: transactions rolled back per second.
  • mean_deadlocks_delta: deadlocks per second.
  • mean_tps: transactions run per second.
  • db.transactions.xact_commit.avg
  • db.transactions.xact_rollback.avg
  • Not collected by enhanced monitoring.
  • db.transactions.xact_commit.avg + db.transactions.xact_rollback.avg
PolarDBSwellTimePoint in time before which dead tuples can be recycled. Unit: seconds.db.swell.swell_time.avg
PolarDBCPUCPU utilization.
  • os.cpu_usage.sys.avg
  • os.cpu_usage.user.avg
  • os.cpu_usage.total.avg
PolarDBMemoryMemory usage.os.mem_usage.total.avg
PolarDBReplicationReturns the following sub-metrics:
  • mean_replay_latency_in_mb: replication delay to the secondary instance. Unit: bytes.
  • mean_send_latency_in_mb: replication delay from the instance to its secondary instance. Unit: bytes.
  • mean_logical_rep_latency_in_mb: logical replication delay. Unit: bytes.
/
PolarDBLongSQLReturns the following sub-metrics:
  • mean_one_second_executing_sqls: SQL statements running for more than 1 second.
  • mean_three_seconds_executing_sqls: SQL statements running for more than 3 seconds.
  • mean_five_seconds_executing_sqls: SQL statements running for more than 5 seconds.
  • db.slow_sql.one_second.avg
  • db.slow_sql.three_seconds.avg
  • db.slow_sql.five_seconds.avg
PolarDBLongIdleTransactionReturns the following sub-metrics:
  • mean_one_second_idle_transactions: transactions idle for more than 1 second.
  • mean_three_seconds_idle_transactions: transactions idle for more than 3 seconds.
  • mean_five_seconds_idle_transactions: transactions idle for more than 5 seconds.
  • db.long_transactions.idle_one_second.avg
  • db.long_transactions.idle_three_seconds
  • db.long_transactions.idle_five_seconds.avg
PolarDBLongTransactionReturns the following sub-metrics:
  • mean_one_second_transactions: transactions running for more than 1 second.
  • mean_three_seconds_transactions: transactions running for more than 3 seconds.
  • db.long_transactions.active_one_second.avg
  • db.long_transactions.active_three_seconds.avg
PolarDBLongTwoPCTransactionReturns the following sub-metrics:
  • mean_one_second_two_pc_transactions: two-phase commit transactions running for more than 1 second.
  • mean_three_seconds_two_pc_transactions: two-phase commit transactions running for more than 3 seconds.
  • mean_five_seconds_two_pc_transactions: two-phase commit transactions running for more than 5 seconds.
  • db.long_transactions.two_pc_one_second.avg
  • db.long_transactions.two_pc_three_seconds.avg
  • db.long_transactions.two_pc_five_seconds.avg
PolarDBLocalIOSTATReturns the following sub-metrics:
  • mean_local_iops_read: reads from the data disk per second.
  • mean_local_iops_write: writes to the data disk per second.
  • os.iops.read.avg
  • os.iops.write.avg
PolarDBLocalDiskUsageReturns the following sub-metrics:
  • mean_local_pg_wal_dir_size: disk space used by write-ahead log (WAL) files. Unit: MB.
  • mean_local_pg_log_dir_size: disk space used by log files. Unit: MB.
  • mean_local_base_dir_size: disk space used by data files. Unit: MB.
  • os.fs_size.wal_dir.avg
  • os.fs_size.log_dir.avg
  • os.fs_size.base_dir.avg

What's next

Previous：Instance state tableNext：Forbidden keywords