install plugin server_audit soname 'server_audit';
set global server_audit_file_buffer_size=8192;
show variables like 'server_audit%';
Variable_name	Value
server_audit_events	
server_audit_excl_users	
server_audit_file_buffer_size	8192
server_audit_file_path	server_audit.log
server_audit_file_rotate_now	OFF
server_audit_file_rotate_size	1000000
server_audit_file_rotations	9
server_audit_incl_users	
server_audit_logging	OFF
server_audit_mode	0
server_audit_output_type	file
server_audit_query_log_limit	1024
server_audit_sync_log_file	OFF
server_audit_syslog_facility	LOG_USER
server_audit_syslog_ident	mysql-server_auditing
server_audit_syslog_info	
server_audit_syslog_priority	LOG_INFO
set global server_audit_logging=on;
set global server_audit_sync_log_file=on;
Line count in file: 52
set global server_audit_file_buffer_size= 16384;
Line count in file: 52
set global server_audit_sync_log_file=on;
Line count in file: 104
set global server_audit_sync_log_file=on;
Line count in file: 1105
set global server_audit_file_buffer_size=0;
Line count in file: 1206
set global server_audit_sync_log_file=on;
Line count in file: 1207
SET GLOBAL server_audit_file_buffer_size=0;
set global server_audit_logging=off;
uninstall plugin server_audit;
Warnings:
Warning	1620	Plugin is busy and will be uninstalled on shutdown