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

Audit logs

Field Description
__topic__ The topic of the log. The value is fixed as rds_audit_log.
owner_id The ID of the Alibaba Cloud account to which the ApsaraDB RDS instance belongs.
region The region where the ApsaraDB RDS instance resides.
instance_name The name of the ApsaraDB RDS instance.
instance_id The ID of the ApsaraDB RDS instance.
db_type The database type of the ApsaraDB RDS instance.
db_version The database engine version of the ApsaraDB RDS instance.
check_rows The number of scanned rows.
db The name of the database.
fail Indicates whether the SQL statement is successfully executed. Valid values:
  • 0: successful
  • 1: failed
    Note The valid values vary based on the database type of the ApsaraDB RDS instance.
client_ip The IP address of the client that accesses the ApsaraDB RDS instance.
latency The time that is consumed to return the result of the SQL statement. Unit: microseconds.
origin_time The point in time at which the SQL statement is executed.
return_rows The number of returned rows.
sql The SQL statement that is executed.
thread_id The ID of the thread.
user The name of the user that executes the SQL statement.
update_rows The number of updated rows.

Slow query logs

Field Description
__topic__ The topic of the log.
  • The topic of a slow query log in ApsaraDB RDS for MySQL is rds_slow_log.
  • The topic of a slow query log in ApsaraDB RDS for PostgreSQL is rds_slow_log_pg.
owner_id The ID of the Alibaba Cloud account to which the ApsaraDB RDS instance belongs.
region The region where the ApsaraDB RDS instance resides.
instance_name The name of the ApsaraDB RDS instance.
instance_id The ID of the ApsaraDB RDS instance.
db_type The database type of the ApsaraDB RDS instance.
db_version The database engine version of the ApsaraDB RDS instance.
db_name The name of the database.
rows_examined The number of scanned rows.
rows_sent The number of returned rows.
start_time The point in time at which the SQL statement is executed.
query_time The time that is consumed to execute the SQL statement. Unit: seconds.
lock_time The duration of the lock wait. Unit: seconds.
user_host The information about the client.
query_sql The SQL statement of the 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 DELETE statements are executed per second.
mysql_perf_com_insert The average number of times that INSERT statements are executed per second.
mysql_perf_com_insert_select The average number of times that INSERT SELECT statements are executed per second.
mysql_perf_com_replace The average number of times that REPLACE statements are executed per second.
mysql_perf_com_replace_select The average number of times that REPLACE SELECT statements are executed per second.
mysql_perf_com_select The average number of times that SELECT statements are executed per second.
mysql_perf_com_update The average number of times that UPDATE statements are executed per second.
mysql_perf_conn_usage The connection utilization of the ApsaraDB RDS instance. Unit: percent.
mysql_perf_cpu_usage The CPU utilization of the ApsaraDB RDS instance. Unit: percent.
mysql_perf_data_size The amount of data space that is occupied by the ApsaraDB RDS instance. Unit: MB.
mysql_perf_disk_usage The disk utilization of the ApsaraDB RDS instance. Unit: percent.
mysql_perf_ibuf_dirty_ratio The ratio of dirty pages to total pages in the buffer pool. Unit: percent.
mysql_perf_ibuf_read_hit The read hit ratio of the buffer pool. Unit: percent.
mysql_perf_ibuf_request_r The average number of read operations that are performed on the InnoDB buffer pool per second.
mysql_perf_ibuf_request_w The average number of write operations that are performed on the InnoDB buffer pool per second.
mysql_perf_ibuf_use_ratio The utilization of the 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 the InnoDB table per second.
mysql_perf_inno_row_insert The average number of rows that are inserted from the InnoDB table per second.
mysql_perf_inno_row_readed The average number of rows that are read from the InnoDB table per second.
mysql_perf_inno_row_update The average number of rows that are updated from the 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 the log file per second.
mysql_perf_innodb_os_log_fsyncs The average number of write operations that are performed by calling the fsync() function on the log file.
mysql_perf_ins_size The amount of disk space that is occupied by the ApsaraDB RDS instance. Unit: MB.
mysql_perf_iops The input/output operations per second (IOPS).
mysql_perf_iops_usage The IOPS utilization of the ApsaraDB 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 amount of data space that is occupied by the binary logs of the ApsaraDB RDS instance. Unit: MB.
mysql_perf_mem_usage The memory usage of the ApsaraDB RDS instance. Unit: percent.
mysql_perf_open_tables The number of open tables.
mysql_perf_other_size The amount of other space that is occupied by the ApsaraDB 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 query operations per second.
mysql_perf_tb_tmp_disk The number of temporary tables that are automatically created per second in the disk when SQL statements are executed in the MySQL process.
mysql_perf_threads_connected The number of open MySQL connections.
mysql_perf_threads_running The number of MySQL threads that are not sleeping.
mysql_perf_tmp_size The amount of data space that is occupied by the temporary files of the ApsaraDB RDS instance. Unit: MB.
mysql_perf_total_session The total number of connections.
mysql_perf_tps The average number of transactions per second.

Error logs

Field Description
__topic__ The topic of the log.
  • The topic of an error log in ApsaraDB RDS for MySQL is rds_error_log.
  • The topic of an error log in ApsaraDB RDS for PostgreSQL is rds_error_log_pg.
collect_time The time at which the log is collected.
content The content of the log.
db_type The database type of the ApsaraDB RDS instance.
db_version The database engine version of the ApsaraDB RDS instance.
event_type The type of the event.
instance_id The ID of the ApsaraDB RDS instance.
instance_name The name of the ApsaraDB RDS instance.
region The region where the ApsaraDB RDS instance resides.