Have I missed Something here? I am installing the Percona Audit Log Plugin (MySQL 5.5).
I can install it fine using:
INSTALL PLUGIN audit_log SONAME 'audit_log.so';
I can then see all the default variables with:
SHOW GLOBAL VARIABLES LIKE 'audit%';
Looking at the documentation it tells me that for the most part they are not Dynamic.
So how do I set them to what I need at the time I install the plugin?
From what I can tell the only option is to add them to my
my.cnf file and restart the Database.
That's fine for a Test System, but I can't go round restarting my LIVE databases, just to install a plugin, surely.