This topic describes the fields of ApsaraDB RDS logs. ApsaraDB RDS logs include SQL audit logs, slow query logs, and performance logs.

SQL audit logs

Log field Description
__topic__ The topic of a log entry. Valid value: rds_audit_log.
owner_id The ID of an Alibaba Cloud account.
region The region where an RDS instance resides.
instance_name The name of an RDS instance.
instance_id The ID of an RDS instance.
db_type The type of an RDS instance.
db_version The version of an RDS instance.
check_rows The number of scanned rows.
db The name of a database.
fail Indicates the result that is returned after an SQL statement is executed. Valid values:
  • 0: successful
  • 1: failed
client_ip The IP address of a client that accesses an RDS instance.
latency The latency of a result that is returned after an SQL statement is executed. Unit: microseconds.
origin_time The point in time when an SQL statement is executed.
return_rows The number of returned rows.
sql The SQL statement.
thread_id The ID of a thread.
user The name of a user who executes an SQL statement.
update_rows The number of updated rows.

Slow query logs

Log field Description
__topic__ The topic of a log entry. Valid value: rds_slow_log.
owner_id The ID of an Alibaba Cloud account.
region The region where an RDS instance resides.
instance_name The name of an RDS instance.
instance_id The ID of an RDS instance.
db_type The type of an RDS instance.
db_version The version of an RDS instance.
db_name The name of a database.
rows_examined The number of scanned rows.
rows_sent The number of returned rows.
start_time The time when an SQL statement is executed.
query_time The time that is consumed to execute an SQL statement. Unit: seconds.
lock_time The time that is consumed by a lock wait. Unit: seconds.
user_host The information of a client.
query_sql The SQL statement of a slow query.

Performance logs

Metric Description
mysql_perf_active_session The number of active connections.
mysql_perf_com_delete The average number of times that the DELETE statements are executed per second.
mysql_perf_com_insert The average number of times that the INSERT statements are executed per second.
mysql_perf_com_insert_select The average number of times that the INSERT SELECT statements are executed per second.
mysql_perf_com_replace The average number of times that the REPLACE statements are executed per second.
mysql_perf_com_replace_select The average number of times of the REPLACE SELECT statements are executed per second.
mysql_perf_com_select The average number of times of the SELECT statements are executed per second.
mysql_perf_com_update The average number of times of the UPDATE statements are executed per second.
mysql_perf_conn_usage The connection utilization of an RDS instance. Unit: percent.
mysql_perf_cpu_usage The CPU utilization of an RDS instance. Unit: percent.
mysql_perf_data_size The data usage of an RDS instance. Unit: MB.
mysql_perf_disk_usage The disk utilization of an RDS instance. Unit: percent.
mysql_perf_ibuf_dirty_ratio The dirty ratio of a buffer pool. Unit: percent.
mysql_perf_ibuf_read_hit The read hit ratio of a buffer pool. Unit: percent.
mysql_perf_ibuf_request_r The average number of read operations that are performed on an InnoDB buffer pool per second.
mysql_perf_ibuf_request_w The average number of write operations that are performed on an InnoDB buffer pool per second.
mysql_perf_ibuf_use_ratio The utilization of a buffer pool. Unit: percent.
mysql_perf_inno_data_read The amount of data that InnoDB reads per second. Unit: KB.
mysql_perf_inno_data_written The amount of data that InnoDB writes per second. Unit: KB.
mysql_perf_inno_row_delete The average number of rows that are deleted from an InnoDB table per second.
mysql_perf_inno_row_insert The average number of rows that are inserted from an InnoDB table per second.
mysql_perf_inno_row_readed The average number of rows that are read from an InnoDB table per second.
mysql_perf_inno_row_update The average number of rows that are updated from an InnoDB table per second.
mysql_perf_innodb_log_write_requests The average number of log write requests per second.
mysql_perf_innodb_log_writes The average number of physical writes to a log file per second.
mysql_perf_innodb_os_log_fsyncs The average number of write operations to a log file by calling the fsync() function.
mysql_perf_ins_size The disk usage of an RDS instance. Unit: MB.
mysql_perf_iops The IOPS. Unit: operations per second.
mysql_perf_iops_usage The IOPS utilization of an RDS instance. Unit: percent.
mysql_perf_kbytes_received The average inbound traffic per second. Unit: KB.
mysql_perf_kbytes_sent The average outbound traffic per second. Unit: KB.
mysql_perf_log_size The binary log usage of an RDS instance. Unit: MB.
mysql_perf_mem_usage The memory utilization of an RDS instance. Unit: percent.
mysql_perf_open_tables The number of opened tables.
mysql_perf_other_size The other space usage of an RDS instance. Unit: MB.
mysql_perf_qps The average number of times that SQL statements are executed per second.
mysql_perf_slow_queries The average number of slow queries per second.
mysql_perf_tb_tmp_disk The number of temporary tables that are automatically created per second in the hard disk when MySQL statements are executed.
mysql_perf_threads_connected The connection number of MySQL threads.
mysql_perf_threads_running The MySQL active threads.
mysql_perf_tmp_size The temporary space usage of an RDS instance. Unit: MB.
mysql_perf_total_session The total number of active connections.
mysql_perf_tps The average number of transactions per second.