Bug #26673 cluster related parameters cannot be set in my.cnf
Submitted: 27 Feb 2007 10:09 Modified: 19 Mar 2014 16:17
Reporter: Oli Sennhauser Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:mysql-5.1 OS:Any
Assigned to: CPU Architecture:Any
Tags: 5.1.14

[27 Feb 2007 10:09] Oli Sennhauser
Description:
The following 4 parameters cannot be set in the my.cnf

#multi_read_range                    = 256
#ndb_index_stat_cache_entries        = 32
#ndb_index_stat_update_freq          = 20
#ndb_use_transactions                = 1

How to repeat:
I got the error message:

bin/mysqld: unknown variable 'multi_read_range=256'
bin/mysqld: unknown variable 'ndb_index_stat_cache_entries=32'
bin/mysqld: unknown variable 'ndb_index_stat_update_freq=20'
bin/mysqld: unknown variable 'ndb_use_transactions=1'

But they are listed in the docu and shown with show variables.
multi_read_range is not even listed in show variables but documented in the 5.1 docu.

Suggested fix:
Either clean out in docu or add in startup parser
[27 Feb 2007 11:43] Sveta Smirnova
According to our documentation variables ndb_index_stat_cache_entries and ndb_index_stat_update_freq can not be set in the configuration file. See also http://dev.mysql.com/doc/refman/5.1/en/mysqld-option-tables.html
[27 Feb 2007 11:52] Sveta Smirnova
Bug is partially verified.

multi_read_range is not possible to set in the configuration file, but it is not documented anywhere. (May be should be treated as documentation bug?)

ndb_use_transactions is possible to set in the configuration file.
[27 Feb 2007 18:28] Hartmut Holzgraefe
multi_read_range was renamed to multi_range_count, manual source was updated
on Feb 9th, but not online yet?

http://lists.mysql.com/commits/19629?f=plain
[28 Feb 2007 8:35] Sveta Smirnova
Hartmut,

at server options it has updated, but at http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html there is no word about multi_read_range is deprecated. And this variable still visible by show variables.
[18 Mar 2014 11:08] Jon Stephens
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/
[18 Mar 2014 11:17] Jon Stephens
My mistake--there's a software issue here that's being fixed and will be documented shortly.
[19 Mar 2014 16:17] Jon Stephens
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

Documented fix as follows in the NDB 7.1.31, 7.2.16, and 7.3.5 changelogs:

        The server system variables ndb_index_cache_entries and
        ndb_index_stat_freq, which had been deprecated in a previous 
        MySQL Cluster release series, have now been removed.      

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html