Field details for PolarDB for MySQL audit logs, slow query logs, error logs, and performance logs collected by Simple Log Service.
Audit log
|
Log field |
Description |
|
__topic__ |
Log topic. Fixed value: polardb_audit_log. |
|
owner_id |
Alibaba Cloud account ID. |
|
region |
Region of the PolarDB for MySQL cluster. |
|
cluster_id |
PolarDB for MySQL cluster ID. |
|
node_id |
PolarDB for MySQL node ID. |
|
check_rows |
Number of scanned rows. |
|
db |
Database name. |
|
fail |
Whether the SQL statement failed to execute. 0 indicates success. Any other value indicates failure. |
|
client_ip |
IP address of the client accessing the PolarDB for MySQL cluster. |
|
latency |
Time elapsed from SQL execution to result return. Unit: microseconds. |
|
origin_time |
Time when the operation was executed. |
|
return_rows |
Number of returned rows. |
|
sql |
Executed SQL statement. |
|
thread_id |
Thread ID. |
|
user |
Username that executed the SQL statement. |
|
update_rows |
Number of updated rows. |
|
db_version |
PolarDB database version. |
Slow query log
|
Log field |
Description |
|
__topic__ |
Log topic. Fixed value: polardb_slow_log. |
|
owner_id |
Alibaba Cloud account ID. |
|
region |
Region of the PolarDB for MySQL cluster. |
|
cluster_id |
PolarDB for MySQL cluster ID. |
|
node_id |
PolarDB for MySQL node ID. |
|
db_type |
PolarDB database type. |
|
db_name |
PolarDB database name. |
|
version |
PolarDB database version. |
|
rows_examined |
Number of scanned rows. |
|
rows_sent |
Number of returned rows. |
|
start_time |
Execution start time. |
|
query_time |
Query execution duration. Unit: seconds. |
|
lock_time |
Lock wait duration. Unit: seconds. |
|
user_host |
Client information. |
|
query_sql |
Slow query SQL statement. |
Error log
|
Log field |
Description |
|
__topic__ |
Log topic. Fixed value: polardb_error_log. |
|
collect_time |
Collection time. |
|
content |
Log content. |
|
type_role |
PolarDB instance type. |
|
event_type |
Event type. |
|
instance_id |
PolarDB instance ID. |
|
region |
Region of the PolarDB instance. |
|
db_version |
PolarDB instance version. |
Performance log
|
Metric name |
Description |
|
mysql_perf_active_session |
Active connections per second. |
|
mysql_perf_binlog_size |
Local binlog usage. Unit: MB. |
|
mysql_perf_com_delete |
DELETE executions per second. |
|
mysql_perf_com_delete_multi |
Multi-table DELETE executions per second. |
|
mysql_perf_com_insert |
INSERT executions per second. |
|
mysql_perf_com_insert_select |
INSERT...SELECT executions per second. |
|
mysql_perf_com_replace |
REPLACE executions per second. |
|
mysql_perf_com_replace_select |
REPLACE...SELECT executions per second. |
|
mysql_perf_com_select |
SELECT executions per second. |
|
mysql_perf_com_update |
UPDATE executions per second. |
|
mysql_perf_com_update_multi |
Multi-table UPDATE executions per second. |
|
mysql_perf_cpu_ratio |
CPU utilization. Unit: percent. |
|
mysql_perf_created_tmp_disk_tables |
Temporary tables created on disk per second. |
|
mysql_perf_data_size |
Data space usage. Unit: MB. |
|
mysql_perf_innodb_buffer_dirty_ratio |
Buffer pool dirty ratio. Unit: percent. |
|
mysql_perf_innodb_buffer_read_hit |
Buffer pool read hit ratio. Unit: percent. |
|
mysql_perf_innodb_buffer_use_ratio |
Buffer pool utilization. Unit: percent. |
|
mysql_perf_innodb_data_read |
Data read from storage per second. Unit: bytes. |
|
mysql_perf_innodb_data_reads |
Buffer pool reads per second. |
|
mysql_perf_innodb_data_writes |
Buffer pool writes per second. |
|
mysql_perf_innodb_data_written |
Data written to storage per second. Unit: bytes. |
|
mysql_perf_innodb_log_write_requests |
Log write requests per second. |
|
mysql_perf_innodb_os_log_fsyncs |
Log file fsync() operations per second. |
|
mysql_perf_innodb_rows_deleted |
Rows deleted per second. |
|
mysql_perf_innodb_rows_inserted |
Rows inserted per second. |
|
mysql_perf_innodb_rows_read |
Rows read per second. |
|
mysql_perf_iops |
Input/output operations per second (IOPS). |
|
mysql_perf_iops_r |
Read IOPS. |
|
mysql_perf_iops_throughput |
Total I/O throughput per second. Unit: MB. |
|
mysql_perf_iops_throughput_r |
Read I/O throughput per second. Unit: MB. |
|
mysql_perf_iops_throughput_w |
Write I/O throughput per second. Unit: MB. |
|
mysql_perf_iops_w |
Write IOPS. |
|
mysql_perf_kbytes_received |
Inbound network traffic per second. Unit: KB. |
|
mysql_perf_kbytes_sent |
Outbound network traffic per second. Unit: KB. |
|
mysql_perf_mem_ratio |
Memory utilization. Unit: percent. |
|
mysql_perf_mps |
Data operations per second. |
|
mysql_perf_other_log_size |
Other log usage. Unit: MB. |
|
mysql_perf_qps |
Queries per second (QPS). |
|
mysql_perf_redolog_size |
Local redo log usage. Unit: MB. |
|
mysql_perf_slow_queries |
Average slow queries per second. |
|
mysql_perf_sys_dir_size |
System space usage. Unit: MB. |
|
mysql_perf_tmp_dir_size |
Temporary space usage. Unit: MB. |
|
mysql_perf_total_session |
Average total connections. |
|
mysql_perf_tps |
Transactions per second (TPS). |