MySQL Bugs: #35192: Six system variables are not shown as result of the SHOW VARIABLES

Bug #35192	Six system variables are not shown as result of the SHOW VARIABLES
Submitted:	10 Mar 2008 19:50	Modified:	21 May 2008 19:49
Reporter:	Santo Leto	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S2 (Serious)
Version:	5.1.23-rc	OS:	Windows (XPSP2)
Assigned to:	Paul DuBois	CPU Architecture:	Any
Tags:	have_archive, have_blackhole_engine, have_example_engine, have_federated_engine, have_merge_engine, innodb_buffer_pool_awe_mem_mb, show variables

Description:
The following system variables are absent (they answer the roll call in ver.5.0.51a but they do not in ver.5.1.23-rc):

	innodb_buffer_pool_awe_mem_mb	
	have_merge_engine		
	have_federated_engine	
	have_example_engine	
	have_blackhole_engine	
	have_archive

How to repeat:
Simply execute the SHOW VARIABLES LIKE 'variable_name'; query to observe an empty set.

Test Script:

SELECT VERSION();
SHOW VARIABLES LIKE 'innodb_buffer_pool_awe_mem_mb';
SHOW VARIABLES LIKE 'have_merge_engine';
SHOW VARIABLES LIKE 'have_federated_engine';
SHOW VARIABLES LIKE 'have_example_engine';
SHOW VARIABLES LIKE 'have_blackhole_engine';
SHOW VARIABLES LIKE 'have_archive';

Script Output:

mysql> SELECT VERSION();
+-------------------------+
| VERSION()               |
+-------------------------+
| 5.1.23-rc-community-log |
+-------------------------+
1 row in set (0.00 sec)

mysql> SHOW VARIABLES LIKE 'innodb_buffer_pool_awe_mem_mb';
Empty set (0.00 sec)

mysql> SHOW VARIABLES LIKE 'have_merge_engine';
Empty set (0.00 sec)

mysql> SHOW VARIABLES LIKE 'have_federated_engine';
Empty set (0.00 sec)

mysql> SHOW VARIABLES LIKE 'have_example_engine';
Empty set (0.00 sec)

mysql> SHOW VARIABLES LIKE 'have_blackhole_engine';
Empty set (0.00 sec)

mysql> SHOW VARIABLES LIKE 'have_archive';
Empty set (0.00 sec)

It appears the InnoDB variable may have been removed in 5.1.13, and the have_xxx variables may have been removed in 5.1.14?

The variable innodb_buffer_pool_awe_mem_mb it is for a special server according
the Manual: http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#option_mysqld_innodb_buffer_...

"To take advantage of AWE memory, you will need to recompile MySQL yourself. The current project settings needed for doing this can be found in the storage/innobase/os/os0proj.c source file.".

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.

innodb_buffer_pool_awe_mem_mb: removed in 5.1.13.
have_merge_engine: removed in 5.1.3.
have_federated_engine: removed in 5.1.14
have_example_engine: removed in 5.1.14
have_blackhole_engine: removed in 5.1.14
have_archive: removed in 5.1.14