更新时间:2024-11-29 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'
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
自建MySQL
quo = separator =\t column = 3 format = time:0,threadIdAndProtocolType:1,sql:2 //MySQL 5.7及以上版本 timeFormat = yyyy-MM-dd'T'HH:mm:ss.SSSSSS'Z' //MySQL 5.5、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