Bug #85359 please make audit_log_strategy and audit_log_buffer_size dynamic variable

• Submitted: 8 Mar 2017 6:25
• Reporter: Shane Bester (Platinum Quality Contributor)
• Status: Verified
• Category: MySQL Server: Security: Audit
• Severity: S4 (Feature request)
• Version: 5.6
• OS: Any
• CPU Architecture: Any

[8 Mar 2017 6:25] Shane Bester

Description:
mysql> set global audit_log_buffer_size=1024*1024*2;
ERROR 1238 (HY000): Variable 'audit_log_buffer_size' is a read only variable
mysql> set global audit_log_strategy=PERFORMANCE;
ERROR 1238 (HY000): Variable 'audit_log_strategy' is a read only variable
mysql> select version();
+---------------------------------------+
| version()                             |
+---------------------------------------+
| 5.7.17-enterprise-commercial-advanced |
+---------------------------------------+
1 row in set (0.00 sec)

How to repeat:
set global audit_log_buffer_size=1024*1024*2;
set global audit_log_strategy=PERFORMANCE;

Suggested fix:
we must make all variables dynamic unless it doesn't make sense to do so.