安装audit_log

mysql> INSTALL PLUGIN audit_log SONAME 'audit_log.so';

mysql>show flugins;

| audit_log                   | ACTIVE   | AUDIT              | audit_log.so | GPL     |

mysql> show global variables like 'audit%';
+--------------------------+--------------+
| Variable_name            | Value        |
+--------------------------+--------------+
| audit_log_buffer_size    | 1048576      |
| audit_log_file           | audit.log    |
| audit_log_flush          | OFF          |
| audit_log_format         | OLD          |
| audit_log_policy         | ALL          |
| audit_log_rotate_on_size | 0            |
| audit_log_rotations      | 0            |
| audit_log_strategy       | ASYNCHRONOUS |
+--------------------------+--------------+

使用 

在mysql的datadir目录下会生成一个audit.log文件，会记录操作。

官方文档http://www.percona.com/doc/percona-server/5.6/management/audit_log_plugin.html#audit-log-plugin