Bug #57560 please make all binary log options dynamically settable

• Submitted: 19 Oct 2010 9:41
• Reporter: Shane Bester (Platinum Quality Contributor)
• Status: Verified
• Category: MySQL Server: Replication
• Severity: S4 (Feature request)
• Version: 5.1, 5.5
• OS: Any
• Assigned to: Assigned Account
• CPU Architecture: Any

[19 Oct 2010 9:41] Shane Bester

Description:
This is a feature request to make log-bin and log-bin-index dynamic variables.
log-bin-index is not even viewable in show global variables, so please show the current value too.

Often a super user needs to disable binlogs on the fly.
Enabling binlogs could be done for new transactions/connections.

How to repeat:
mysql> set global log_bin='binlog';
ERROR 1238 (HY000): Variable 'log_bin' is a read only variable

Suggested fix:
a workaround to stop non-super users would be to put this into my.cnf

init-connect='set sql_log_bin=0;'

[19 Oct 2010 9:52] MySQL Verification Team

related: bug #35611

[20 Oct 2010 5:54] MySQL Verification Team

part of this feature request is to make log_slave_updates dynamically settable on slaves.

mysql> set global log_slave_updates=1;
ERROR 1238 (HY000): Variable 'log_slave_updates' is a read only variable

[9 Feb 2011 13:17] MySQL Verification Team

related bug for tmpdir: bug #60036