Not the answer you need?
Register and ask your own question!

Audit Log Plugin - System Variables

kannan2410kannan2410 EntrantInactive User Role Beginner
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...

Kannan V[/B]


  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner

    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.
  • kannan2410kannan2410 Entrant Inactive User Role Beginner
    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...?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.