audit log will not rotate when the file size exceeds global variable setting

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:

for i in {1..20}; do mysql -ufail -pfail; done

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:
server_audit_file_rotations
server_audit_syslog_ident

We should fix them alltogether.