Bug #4473 MA confuses sort_buffer and myisam_sort_buffer_size
Submitted: 8 Jul 2004 22:24 Modified: 16 Jul 2004 17:35
Reporter: Harrison Fisk Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.0.6-beta OS:Linux (Debian Linux)
Assigned to: Ulrich Bayer CPU Architecture:Any

[8 Jul 2004 22:24] Harrison Fisk
Description:
In the configuration editor on the front page is an option called sort buffer.  One would think that sort buffer relates to the variable called sort_buffer, but it actually refers to myisam_sort_buffer_size.  The real sort_buffer variable is on the Advanced page near the end.  Since sort_buffer is something that is set very often, I don't think it should be hidden in the back, nor confused with the myisam setting.  Also myisam_sort_buffer_size should go onto the MyISAM page, since it is myisam specific.

How to repeat:
1.  Set myisam_sort_buffer_size in your my.cnf.  
2.  Start up MA.
3.  Notice that the value called sort_buffer is based on myisam_sort_buffer_size.

Suggested fix:
I think the following should be done to make the tool more intiutive:

1.  Move the front page Sort Buffer on to the MyISAM page of variables.  (maybe rename it too?)
2.  Move the real sort_buffer_size setting from the advanced page onto the front page where the old myisam_sort_buffer_size is.
[16 Jul 2004 17:35] Ulrich Bayer
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.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Thanks Harrison!