Enhancement to provide log file rotation

[creechy]

You have probably thought of this already, but it would be great if the log file support could do daily log file rotation. Having a single log file will undoubtedly become unweildly eventually, nor does it provide for easy archiving.

I am guessing for now, one could write their own log file roller if they use the socket option, but this means another process needs to run and an additional point of failure.

[glicht]

Thanks for submitting the issue.

The way we want to go is support flushing the logs and use logrotate, similar to what MySQL recommends using for other logs. See: http://dev.mysql.com/doc/refman/5.5/en/log-file-maintenance.html

Thing is, that we currently don't have flush logs support. The current option is using a script which will set audit_json_file=off (flush and close the log) and then set back audit_json_file=on. This is not perfect as there is a gap between the off and on. We will check how we can improve on this.