This topic describes the fields of audit logs, slow query logs, error logs, and performance logs in PolarDB for MySQL.
Audit logs
Field | Description |
__topic__ | The topic of the log. The value is fixed as polardb_audit_log. |
owner_id | The ID of the Alibaba Cloud account to which the PolarDB for MySQL cluster belongs. |
region | The ID of the region where the PolarDB for MySQL cluster resides. |
cluster_id | The ID of the PolarDB for MySQL cluster. |
node_id | The ID of the node in the PolarDB for MySQL cluster. |
check_rows | The number of scanned rows. |
db | The name of the database. |
fail | Indicates whether the SQL statement fails to be executed. The value 0 indicates that the SQL statement is executed. A value that is not 0 indicates that SQL statement fails to be executed. |
client_ip | The IP address of the client that accesses the PolarDB for MySQL cluster. |
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 who executes the SQL statement. |
update_rows | The number of updated rows. |
db_version | The version ID of the PolarDB database. |
Slow query logs
Field | Description |
__topic__ | The topic of the log. The value is fixed as polardb_slow_log. |
owner_id | The ID of the Alibaba Cloud account to which the PolarDB for MySQL cluster belongs. |
region | The ID of the region where the PolarDB for MySQL cluster resides. |
cluster_id | The ID of the PolarDB for MySQL cluster. |
node_id | The ID of the node in the PolarDB for MySQL cluster. |
db_type | The type of the databases that are created in the PolarDB for MySQL cluster. |
db_name | The name of the PolarDB for MySQL database. |
version | The version of the database engine. |
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. |
Error logs
Field | Description |
__topic__ | The topic of the log. The value is fixed as polardb_error_log. |
collect_time | The time at which the log is collected. |
content | The content of the log. |
type_role | The type of the PolarDB for MySQL cluster. |
event_type | The type of the event. |
instance_id | The ID of the PolarDB for MySQL cluster. |
region | The ID of the region where the PolarDB for MySQL cluster resides. |
db_version | The version of the database engine. |
Performance logs
Metric | Description |
mysql_perf_active_session | The number of active connections per second. |
mysql_perf_binlog_size | The amount of binary logs that are generated on your computer. Unit: MB. |
mysql_perf_com_delete | The average number of times that DELETE statements are executed per second. |
mysql_perf_com_delete_multi | The average number of times that MULTI-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_com_update_multi | The average number of times that MULTI-UPDATE statements are executed per second. |
mysql_perf_cpu_ratio | The CPU utilization. Unit: percent. |
mysql_perf_created_tmp_disk_tables | The number of temporary tables that are automatically created per second. |
mysql_perf_data_size | The amount of storage space that is occupied by data. Unit: MB. |
mysql_perf_innodb_buffer_dirty_ratio | The ratio of dirty pages to the total number of pages in the buffer pool. Unit: percent. |
mysql_perf_innodb_buffer_read_hit | The read hit ratio of the buffer pool. Unit: percent. |
mysql_perf_innodb_buffer_use_ratio | The utilization of the buffer pool. Unit: percent. |
mysql_perf_innodb_data_read | The amount of data that is read from the storage engine per second. Unit: bytes. |
mysql_perf_innodb_data_reads | The average number of read operations that are performed on the buffer pool per second. |
mysql_perf_innodb_data_writes | The average number of write operations that are performed on the buffer pool per second. |
mysql_perf_innodb_data_written | The amount of data that is written to the storage engine per second. Unit: bytes. |
mysql_perf_innodb_log_write_requests | The average number of log write requests per second. |
mysql_perf_innodb_os_log_fsyncs | The average number of write operations to the log file by calling the fsync() function. |
mysql_perf_innodb_rows_deleted | The number of deleted rows per second. |
mysql_perf_innodb_rows_inserted | The number of inserted rows per second. |
mysql_perf_innodb_rows_read | The number of read rows per second. |
mysql_perf_iops | The input/output operations per second (IOPS). |
mysql_perf_iops_r | The read IOPS. |
mysql_perf_iops_throughput | The I/O throughput per second. Unit: MB. |
mysql_perf_iops_throughput_r | The read I/O throughput per second. Unit: MB. |
mysql_perf_iops_throughput_w | The write I/O throughput per second. Unit: MB. |
mysql_perf_iops_w | The write IOPS. |
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_mem_ratio | The memory usage. Unit: percent. |
mysql_perf_mps | The number of operations that are performed on data per second. |
mysql_perf_other_log_size | The amount of other logs that are generated. Unit: MB. |
mysql_perf_qps | The queries per second (QPS). |
mysql_perf_redolog_size | The amount of redo logs that are generated on your computer. Unit: MB. |
mysql_perf_slow_queries | The number of slow queries per second. |
mysql_perf_sys_dir_size | The amount of storage space that is occupied by system files. Unit: MB. |
mysql_perf_tmp_dir_size | The amount of storage space that is occupied by temporary files. Unit: MB. |
mysql_perf_total_session | The average number of total connections. |
mysql_perf_tps | The average number of transactions per second. |