general log vs audit log

0

A customer was asked by an auditor to enable general logs (general_log) in RDS Aurora MySQL. Recently we had an issue with this cluster and we enabled audit logs (server_audit_logs). After checking some sources it looks like if the audit log has QUERY, QUERY_DCL, QUERY_DDL, QUERY_DML enabled it should have the same info as the general log.

Is it recommended to use Audit log instead of general log in Aurora MySQL?

1 回答
1
已接受的回答

It is. General log can be very heavy, and will profile everything, which is pretty hard on write performance. Audit log is specifically designed for auditing purpose, and is lightweight.

More info on audit log can be found here.

AWS
已回答 4 年前
profile picture
专家
已审核 6 个月前
profile picture
专家
已审核 1 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则