| Bug #16567 | binlog_format option does not show when doing ./mysqd --help --verbose | ||
|---|---|---|---|
| Submitted: | 17 Jan 2006 17:30 | Modified: | 9 Mar 2007 16:53 |
| Reporter: | Jonathan Miller | ||
| Status: | Closed | ||
| Category: | Server: RBR | Severity: | S3 (Non-critical) |
| Version: | 5.1.6-alpha | OS: | Linux (Linux) |
| Assigned to: | Andrei Elkin | Target Version: | |
[17 Jan 2006 17:30]
Jonathan Miller
[17 Jan 2006 17:48]
Miguel Solorzano
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 17:56]
Jonathan Miller
Has to do with variable output not the options.
[17 Dec 2006 13: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 14: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 14: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 18: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 18:48]
Chuck Bell
Patch looks good. All of my questions have been addressed.
[12 Jan 2007 19: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 22:23]
Chuck Bell
Reviewed latest patch on 12 January. Patch looks good to go.
[15 Jan 2007 15: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 8:57]
Andrei Elkin
5.1.17-beta
[9 Mar 2007 16:53]
MC Brown
No documentation changes required, and no changelog entry created.
