ApsaraDB RDS

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.

threat_client_ip

Access RDSinstance clientIPIP address threat intelligence。For more information，, seeThreat intelligence fields。

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.

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.

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.

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.

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.