Audit Log Plugin - System Variables

Hi All,

The audit_log_policy writes these things “ALLNONE”
Can we reformat the “audit_log_policy” by query base like update, select, drop…
I need to get the audit log only drop queries.
Please suggest…

Thanks,
Kannan V[/B]

Hi,

AFAIK, there is no direct option to log drop queries in Audit Log Plugin so far. It might become feature request but yes, after audit log for all queries, you can use some shell/php scripts OR pt-query-digest might be useful for you to filter out only drop queries.
[url]http://www.percona.com/doc/percona-toolkit/2.2/pt-query-digest.html[/url]

Hi niljoshi,

Thanks for your response…
If we are enable audit_log then our DB is getting more and more hit, that’s what we are planning to enable only some limited queries. Can you please raise a feature request for this…?