Bug #21054 myisam_stats_method ignored in my.cnf and cmdline
Submitted: 13 Jul 2006 23:53 Modified: 13 Sep 2006 17:50
Reporter: Kolbe Kegel Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.19,5.0.22 OS:
Assigned to: Timothy Smith CPU Architecture:Any
Tags: my.cnf, myisam, myisam_stats_method

[13 Jul 2006 23:53] Kolbe Kegel
The myisam_stats_method variable cannot be set in the my.cnf file or on the commandline.

How to repeat:
mysqld_safe --myisam-stats-method=nulls-equal &
mysqladmin variables | grep myisam_stats_method

kolbe@beluga:~/MySQL/inst/5.0.22> ./bin/mysqld_safe --myisam-stats-method=nulls_equal &

kolbe@beluga:~/MySQL/inst/5.0.22> ./bin/mysqladmin variables | grep myisam_stats
| myisam_stats_method             | nulls_unequal     |

Suggested fix:
This should be repaired in such a way that myisam_stats_method can again be set in the my.cnf file or as a command line option to mysqld.
[6 Sep 2006 21:21] Timothy Smith
Calvin, Ingo:

I'm stealing this one.  Trivial fix included in bug.
[6 Sep 2006 22:10] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:


ChangeSet@1.2539, 2006-09-07 00:11:43+02:00, tsmith@maint1.mysql.com +1 -0
  Bug #21054: myisam_stats_method ignored in my.cnf and cmdline
  Fix OPT_MYISAM_STATS_METHOD case, where the NULLS_EQUAL and NULLS_NOT_EQUAL methods were mixed up
[7 Sep 2006 16:42] Timothy Smith
A typo (actuall, mixed up two identifiers) in option handling in mysqld caused the myisam_stats_method to be handled incorrectly - you'd ask for "nulls_equal" and get "nulls_unequal", and vice versa.

Patch pushed to mysql-5.0-release.  Will be in 5.0.25.

Docs team: please set back to "Patch queued" after documenting for 5.0.

Patch queued to -maint team trees (4.1, 5.0 and 5.1).
[13 Sep 2006 2:29] Paul DuBois
Noted in 5.0.25 changelog.

The myisam_stats_method variable was mishandled when set from an option file or on the command line.

Report set back to Patch Queued pending merge into 4.1, 5.1.
[13 Sep 2006 8:44] Timothy Smith
Pushed to 5.1.12 and 4.1.22.
[13 Sep 2006 17:50] Paul DuBois
Noted in 4.1.22, 5.1.12 changelogs.
[4 Oct 2006 13:57] Chad MILLER
Available in 4.1.22.