更新时间:2023-12-14 GMT+08:00
审计日志格式说明
创建DRS流量回放任务时,源数据库引擎可选不同来源。不同源数据库来源对应的审计日志格式不同,具体说明可参考如下说明。
参数 |
说明 |
---|---|
Quo |
包裹符号,一般审计日志中的SQL是会被该符号包裹起来。 |
Column |
每行总列数。 |
Separator |
审计日志分割符号。 |
Format |
关键列表示的含义,从0开始计数。 |
timeFormat: |
日期格式,为空时表示时间戳。 |
华为云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'
华为云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 =
阿里云RDS MySQL版
quo =" column = 16 separator = , format = threadId:2,latency:8,time:10,queryType:5,sql:0,client:4,schemaName:1 timeFormat =
阿里云PolarDB MySQL版
quo =" separator=, column = 12 format = threadId:2,latency:8,time:11,queryType:5,sql:0,client:4,schemaName:1 timeFormat =
腾讯云TDSQL-C 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'
MariaDB
quo =' separator=, column = 10 format = threadId:4,time:0,protocolType:6,sql:8,client:3,schemaName:7 timeFormat = yyyyMMdd HH:mm:ss