This topic describes the fields of PolarDB-X 1.0 SQL audit log entries.
Log field | Description |
---|---|
__topic__ | The topic of a log entry. The value must be in the format of drds_audit_log_instance ID_database name, for example, drds_audit_log_drdsxyzabcd_demo_drds_db. |
affect_rows | The number of rows that are returned after an SQL statement is executed.
This field is available for instance version 5.3.4-15378085 and later. |
client_ip | The IP address of a client that accesses a PolarDB-X 1.0 instance. |
client_port | The port number of a client that accesses a PolarDB-X 1.0 instance. |
db_name | The name of a PolarDB-X 1.0 database. |
fail | The result of an SQL statement. Valid values:
This field is available for instance version 5.3.4-15378085 and later. |
hint | The hint that is used to execute an SQL statement. |
instance_id | The ID of a PolarDB-X 1.0 instance. |
response_time | The response time. Unit: milliseconds.
This field is available for instance version 5.3.4-15378085 and later. |
sql | The SQL statement. |
sql_code | The hash value of a template SQL statement. |
sql_time | The time when an SQL statement is executed. The value is in the format of yyyy-MM-dd HH:mm:ss.SSS. |
sql_type | The type of an SQL statement. Valid values: Select, Insert, Update, Delete, Set, Alter, Create, Drop, Truncate, Replace, and Other. |
sql_type_detail | The name of an SQL parser. |
table_name | The name of a database table. Multiple tables are separated by commas (,). |
trace_id | The trace ID of an SQL statement when the statement is executed. If a transaction is executed, it is tracked by using an ID. The ID consists of a trace ID, a hyphen (-), and a number, for example, drdsabcdxyz-1 and drdsabcdxyz-2. |
user | The name of the user who executes an SQL statement. |