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:
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

[27 Aug 2010 16:45] Isaac Venn
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.
[27 Aug 2010 16:58] MySQL Verification Team
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.
[29 Aug 2010 10:30] Jon Stephens
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.
[29 Aug 2010 10:38] Jon Stephens
Corrected Category and lead.