Bug #53777 Include all options and variables in SHOW GLOBAL VARIABLES output

• Submitted: 19 May 2010 6:43
• Modified: 19 May 2010 7:00
• Reporter: Roel Van de Paar
• Status: Duplicate
• Category: MySQL Server: General
• Severity: S4 (Feature request)
• Version: 5.1.46
• OS: Any
• CPU Architecture: Any

[19 May 2010 6:43] Roel Van de Paar

Description:
Certain options are not reported in SHOW GLOBAL VARIABLES.

An example:
http://dev.mysql.com/doc/refman/5.1/en/replication-options-binary-log.html#option_mysqld_b...

mysql> show global variables like '%do%';
+---------------------------+-------+
| Variable_name             | Value |
+---------------------------+-------+
| engine_condition_pushdown | ON    |
| innodb_doublewrite        | ON    |
| innodb_fast_shutdown      | 1     |
| pseudo_thread_id          | 0     |
+---------------------------+-------+
4 rows in set (0.00 sec)

How to repeat:
As per the above

Suggested fix:
Include all options

[19 May 2010 7:00] Valeriy Kravchuk

If this is about replicate-do-* options, I'd say it is a duplicate of bug #48079 and, eventually, bug #29703.