audit log will not rotate when the file size exceeds global variable setting
Setting server_audit_file_rotate_now = ON does work though.
To reproduce, try setting server_audit_events = 'connect' and server_audit_file_rotate_size = 1000. Then connect with a bad password about 20 times:
Notice that the server_audit.log file does not rotate even though its size is 2700 bytes when the rotate size is 1000 bytes.
Same can be said about 2 more variables:
We should fix them alltogether.