| Bug #16567 | binlog_format option does not show when doing ./mysqd --help --verbose | ||
|---|---|---|---|
| Submitted: | 17 Jan 2006 16:30 | Modified: | 9 Mar 2007 15:53 |
| Reporter: | Jonathan Miller | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Row Based Replication ( RBR ) | Severity: | S3 (Non-critical) |
| Version: | 5.1.6-alpha | OS: | Linux (Linux) |
| Assigned to: | Andrei Elkin | CPU Architecture: | Any |
[17 Jan 2006 16:30]
Jonathan Miller
[17 Jan 2006 16:48]
MySQL Verification Team
libexec/mysqld Ver 5.1.6-alpha-debug for suse-linux on i686 (Source distribution)
Copyright (C) 2000 MySQL AB, by Monty and others
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
<cut>
--bind-address=name IP address to bind to.
--binlog-format=name
Tell the master the form of binary logging to use: either
'row' for row-based binary logging (which automatically
turns on innodb_locks_unsafe_for_binlog as it is safe in
this case), or 'statement' for statement-based logging.
If ndbcluster is enabled, the default will be set to
'row'.
<cut>
[17 Jan 2006 16:56]
Jonathan Miller
Has to do with variable output not the options.
[17 Dec 2006 12:59]
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: http://lists.mysql.com/commits/17094 ChangeSet@1.2365, 2006-12-17 14:59:14+02:00, aelkin@dsl-hkibras-fe24f900-214.dhcp.inet.fi +1 -0 Bug #16567 binlog_format option does not show when doing ./mysqd --help --verbose implementing this feature also as a part of wl#3368. Supplied by my.cnf or explicitly in command line option is displayed. When not supplied `(No default value)' is displayed. The option is different object from @@global.binlog_format variable. The default `mixed' for the latter is dependant on presence of `--log-bin' option, particularly the value of the var is getting NULL (undefined), if no --log-bin supplied. Comments on NDB and mixed format updated. todo/fixme: turning @@global.binlog_format to be read-only when it's set to NULL (no binlog). todo/fixme: options dependacy (acyclic) graph, particularly to solve a task of setting defaults values for the leaf nodes only when parents' nodes are set.
[17 Dec 2006 13:09]
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: http://lists.mysql.com/commits/17095 ChangeSet@1.2365, 2006-12-17 15:09:21+02:00, aelkin@dsl-hkibras-fe24f900-214.dhcp.inet.fi +1 -0 Bug #16567 binlog_format option does not show when doing ./mysqd --help --verbose implementing this feature also as a part of wl#3368. Supplied by my.cnf or explicitly in command line option is displayed. When not supplied `(No default value)' is displayed. The option is different object from @@global.binlog_format variable. The default `mixed' for the latter is dependant on presence of `--log-bin' option, particularly the value of the var is getting NULL (undefined), if no --log-bin supplied. Comments on NDB and mixed format updated. todo/fixme: turning @@global.binlog_format to be read-only when it's set to NULL (no binlog). todo/fixme: options dependacy (acyclic) graph, particularly to solve a task of setting defaults values for the leaf nodes only when parents' nodes are set. (this line just a test of post-commit trigger: bug#0)
[17 Dec 2006 13:16]
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: http://lists.mysql.com/commits/17096 ChangeSet@1.2365, 2006-12-17 15:16:25+02:00, aelkin@dsl-hkibras-fe24f900-214.dhcp.inet.fi +1 -0 Bug #16567 binlog_format option does not show when doing ./mysqd --help --verbose implementing this feature also as a part of worklog 3368. Supplied by my.cnf or explicitly in command line option is displayed. When not supplied `(No default value)' is displayed. The option is different object from @@global.binlog_format variable. The default `mixed' for the latter is dependant on presence of `--log-bin' option, particularly the value of the var is getting NULL (undefined), if no --log-bin supplied. Comments on NDB and mixed format updated. todo/fixme: turning @@global.binlog_format to be read-only when it's set to NULL (no binlog). todo/fixme: options dependacy (acyclic) graph, particularly to solve a task of setting defaults values for the leaf nodes only when parents' nodes are set. (this line just a test of post-commit trigger: bug#4294967295)
[20 Dec 2006 17:01]
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: http://lists.mysql.com/commits/17233 ChangeSet@1.2365, 2006-12-20 19:00:35+02:00, aelkin@dsl-hkibras-fe24f900-214.dhcp.inet.fi +1 -0 Bug #16567 binlog_format option does not show when doing ./mysqd --help --verbose Implementing this feature also as a part of wl#3368. Supplied by my.cnf or explicitly in command line option gets be displayed. When not supplied `(No default value)' is displayed, even though --log-bin might be supplied. The option is different object from @@global.binlog_format variable. The default `mixed' for the latter is dependant on presence of `--log-bin' option, otherwise the value of the var is set to NULL (undefined): var := opt | MIXED when binlog-in-use var := NULL otherwise (no binlog, no format) Comments on NDB and mixed format updated, also dependency the option on --log-bin aka binlog-in-use is worded. todo/fixme: turning @@global.binlog_format to be read-only when it's set to NULL (no binlog). todo/fixme: options dependacy (acyclic) graph, particularly to solve a task of setting defaults values for the leaf nodes only when parents' nodes are set.
[20 Dec 2006 17:48]
Chuck Bell
Patch looks good. All of my questions have been addressed.
[12 Jan 2007 18:00]
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: http://lists.mysql.com/commits/18047 ChangeSet@1.2374, 2007-01-12 20:00:30+02:00, aelkin@dsl-hkibras-fe36f900-97.dhcp.inet.fi +3 -0 Bug #16567 binlog_format option does not show when doing ./mysqd --help --verbose Implementing this feature connected to wl#3368 mixed binlog_format default. Supplied by my.cnf or explicitly in command line option gets be displayed. When not supplied `(No default value)' is displayed, even though --log-bin might be supplied. The option is different object from @@global.binlog_format variable. The default `mixed' for the latter is dependant on presence of `--log-bin' option, otherwise the value of the var is set to NULL (undefined): var := opt | MIXED when binlog-in-use var := NULL otherwise (no binlog, no format) Comments on NDB and mixed format updated, also dependency the option on --log-bin aka binlog-in-use is worded. Making t/rpl_switch_stm_row_mixed.test to interprete DEFAULT for binlog_format as MIXED. todo/fixme: turning @@global.binlog_format to be read-only when it's set to NULL (no binlog). todo/fixme: options dependacy (acyclic) graph, particularly to solve a task of setting defaults values for the leaf nodes only when parents' nodes are set.
[12 Jan 2007 21:23]
Chuck Bell
Reviewed latest patch on 12 January. Patch looks good to go.
[15 Jan 2007 14:01]
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: http://lists.mysql.com/commits/18114 ChangeSet@1.2374, 2007-01-15 16:01:00+02:00, aelkin@dsl-hkibras-fe36f900-97.dhcp.inet.fi +3 -0 Bug #16567 binlog_format option does not show when doing ./mysqd --help --verbose Implementing this feature connected to wl#3368 mixed binlog_format default. Supplied by my.cnf or explicitly in command line option gets be displayed. When not supplied `(No default value)' is displayed, even though --log-bin might be supplied. The option is different object from @@global.binlog_format variable. The default `mixed' for the latter is dependant on presence of `--log-bin' option, otherwise the value of the var is set to NULL (undefined): var := opt | MIXED when binlog-in-use var := NULL otherwise (no binlog, no format) Comments on NDB and mixed format updated, also dependency the option on --log-bin aka binlog-in-use is worded. Making t/rpl_switch_stm_row_mixed.test to interprete DEFAULT for binlog_format as MIXED. Comments on what the test covers are added. todo/fixme: turning @@global.binlog_format to be read-only when it's set to NULL (no binlog). todo/fixme: options dependacy (acyclic) graph, particularly to solve a task of setting defaults values for the leaf nodes only when parents' nodes are set.
[8 Mar 2007 7:57]
Andrei Elkin
5.1.17-beta
[9 Mar 2007 15:53]
MC Brown
No documentation changes required, and no changelog entry created.
