Help Center/ Data Replication Service/ Workload Replay/ Audit Log Format
Updated on 2024-09-25 GMT+08:00
View PDF
Share

Audit Log Format

When creating a DRS workload replay task, you can select different sources for the source DB engine. The audit log format varies depending on the source database.

Table 1 Parameters of audit logs

Parameter

Description

quo

Enclosing character. Generally, SQL statements in audit logs are enclosed by this character.

column

Total number of columns in each row.

separator

Separator of audit logs.

format

Meaning of a key column. The value starts from 0.

timeFormat

Date format. If this parameter is left empty, it indicates the timestamp.

Huawei Cloud RDS for MySQL

quo ="
column = 12
separator = ,
format = threadId:1,protocolType:3,time:4,queryType:5,sql:6,client:10
timeFormat = yyyy-MM-dd'T'HH:mm:ss 'UTC'

Huawei Cloud GaussDB(for MySQL)

quo =^^
column = 19
separator = ,
format = threadId:4,latency:12,protocolType:0,time:2,queryType:3,sql:6,client:10,schemaName:11,client2:8
timeFormat =

Alibaba Cloud ApsaraDB RDS for MySQL

quo ="
column = 16
separator = ,
format = threadId:2,latency:8,time:10,queryType:5,sql:0,client:4,schemaName:1
timeFormat =

Alibaba Cloud PolarDB for MySQL

quo ="
separator=,
column = 12
format = threadId:2,latency:8,time:11,queryType:5,sql:0,client:4,schemaName:1
timeFormat =

Tencent Cloud TDSQL-C for MySQL

quo ="
separator=,
column = 20
format = threadId:15,latency:9,time:18,queryType:2,sql:6,client:7,schemaName:5
timeFormat = yyyy-MM-dd HH:mm:ss

Amazon Aurora MySQL

quo ='
column = 10
separator = ,
format = threadId:4,time:0,sql:8,client:3,schemaName:7
timeFormat = yyyy-MM-dd'T'HH:mm:ss.SSS'Z'

Amazon RDS MySQL

quo ='
column = 11
separator = ,
format = threadId:4,time:0,sql:8,client:3,schemaName:7
timeFormat = yyyyMMdd HH:mm:ss

Amazon RDS MariaDB

quo ='
column = 11
separator = ,
format = threadId:4,time:0,sql:8,client:3,schemaName:7
timeFormat = yyyyMMdd HH:mm:ss

Self-Managed MySQL

quo = 
separator =\t
column = 3
format = time:0,threadIdAndProtocolType:1,sql:2
//MySQL 5.7 or later
timeFormat = yyyy-MM-dd'T'HH:mm:ss.SSSSSS'Z'
//MySQL 5.5 and 5.6
timeFormat = yyMMdd HH:mm:ss

MariaDB

quo ='
separator=,
column = 10
format = threadId:4,time:0,protocolType:6,sql:8,client:3,schemaName:7
timeFormat = yyyyMMdd HH:mm:ss