MySQL Bugs: #56327: ndb_index_stat_enable default documented incorrectly

Bug #56327	ndb_index_stat_enable default documented incorrectly
Submitted:	27 Aug 2010 16:45	Modified:	29 Aug 2010 10:30
Reporter:	Isaac Venn	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.1+	OS:	Any
Assigned to:	Jon Stephens	CPU Architecture:	Any
Tags:	ndb_index_stat_enable

Description:
On the page : http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-system-variables.html the variable  ndb_index_stat_enable is stated as default ON however it is OFF by default in current versions.

How to repeat:
Install recent version of mysql server.  Connect and view variable value:

mysql> show global variables like 'ndb_index_stat_en%';
+-----------------------+-------+
| Variable_name         | Value |
+-----------------------+-------+
| ndb_index_stat_enable | OFF   | 
+-----------------------+-------+
1 row in set (0.01 sec)

Suggested fix:
Change documentation to default OFF or change code to default to ON.

For now this is a documentation bug.  The default should remain OFF.  Optimizer hints STRAIGHT_JOIN, FORCE INDEX(), etc. may be employed to improve query performance where index statistics are not utilized.

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.

Corrected Category and lead.