GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Audit Log Plugin - System Variables

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Audit Log Plugin - System Variables

    Hi All,

    The audit_log_policy writes these things "ALL, LOGINS, QUERIES, NONE"
    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


  • #2
    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.
    http://www.percona.com/doc/percona-t...ry-digest.html

    Comment


    • #3
      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...?

      Comment

      Working...
      X