目前升级到2.5.9版本依旧没有这个字段。但是同样版本的其他集群则有这个字段。
同版本,不同集群下执行查询sql 审计日志记录的字段:
有MemCostBytes字段的:
2023-07-28 06:59:01,191 [query] |Client=10.2.29.104:11886|User=read_user|AuthorizedUser=‘read_user’@’%’|ResourceGroup=default_wg|Catalog=default_catalog|Db=xxxxx|State=EOF|ErrorCode=|Time=44|ScanBytes=0|ScanRows=0|ReturnRows=0|CpuCostNs=9909858|MemCostBytes=10808|StmtId=13|QueryId=2d19173c-2cd1-11ee-aba1-02420387bafd|IsQuery=true|feIp=10.2.29.105|Stmt=/* tid = 1690498741043 */ select COLUMN_NAME from information_schema.COLUMNS where table_name = ‘xxxx’|Digest=|PlanCpuCost=0.0|PlanMemCost=0.0
无字段的:
2023-07-28 09:19:52,210 [query] |Client=10.9.65.102:37516|User=rd_app_user|AuthorizedUser=‘rd_app_user’@‘10.9.%.%’|ResourceGroup=default_wg|Catalog=default_catalog|Db=xxxxx|State=EOF|ErrorCode=|Time=11|ScanBytes=614782|ScanRows=1|ReturnRows=1|StmtId=1161|QueryId=da5149c8-2ce4-11ee-95f3-02426ef29be6|IsQuery=true|feIp=10.9.2.154|Stmt=/* tid = 1690507192188 */ SELECT employee_code , open_id , username , phone_number , id_card_no , id , gender , department_info_json , xxxxxxx, id_card_type , job_number from xxxxxx
where is_hrm=1 and tenant_id=‘00ptbnd6680584221679734567057167’ and staff_open_id in (‘00ptbnd1305092552168191363975316’) order by id desc LIMIT 0,1000|Digest=|PlanCpuCost=1152.4009056016655|PlanMemCost=768.2672704011103