Bug #28752 binlog_format variable is empty when binlog is turned off
Submitted: 29 May 2007 15:44 Modified: 6 Jul 2007 3:43
Reporter: Daniel Fischer Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Row Based Replication ( RBR ) Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: Mats Kindahl CPU Architecture:Any

[29 May 2007 15:44] Daniel Fischer
The binlog_format system variable is shown as empty when mysqld is run with binlog disabled.

How to repeat:
Run mysqld with binlog disabled and SHOW VARIABLES LIKE "binlog_format"

Suggested fix:
Make it say "OFF" or "DISABLED" or "UNKNOWN" or maybe something funny. :)
[2 Jun 2007 19:02] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:


ChangeSet@1.2536, 2007-06-02 21:01:30+02:00, mats@kindahl-laptop.dnsalias.net +1 -0
  BUG#28752 (binlog_format variable is empty when binlog is turned off):
  Setting MIXED format instead of UNSPECIFIED format when server is
  started without log-bin.
[21 Jun 2007 20:15] Bugs System
Pushed into 5.1.20-beta
[6 Jul 2007 3:43] Paul DuBois
Noted in 5.1.20 changelog.

The binlog_format system variable value was empty if the server was
started with binary logging disabled. Now it is set to MIXED.