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. The value 0 indicates success. All values other than 0 indicate failure. |
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. |
hash | Hash value. |
Slow query logs
Field | Description |
__topic__ | The topic of the 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. |
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.
|
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. |
db_name | The name of the database. |
file | Error information. |
port | The port number of the database. |
user | The user name. |
user_ip | The IP address of the user. |
user_port | The port number of the user. |