Bug #69440 | Documented minimal value of myisam_sort_buffer_size is wrong | ||
---|---|---|---|
Submitted: | 11 Jun 2013 9:47 | Modified: | 12 Jun 2013 14:23 |
Reporter: | Tsubasa Tanaka (OCA) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
Version: | 5.1.70, 5.5.32, 5.6.12, 5.7.1 | OS: | Any |
Assigned to: | Paul DuBois | CPU Architecture: | Any |
[11 Jun 2013 9:47]
Tsubasa Tanaka
[11 Jun 2013 10:20]
MySQL Verification Team
Hello tsubasa, Thank you for the report. Verified as described. Thanks, Umesh
[12 Jun 2013 7:40]
Tsubasa Tanaka
5.7.1-m11 too. http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_myisam_sort_buf... in mysql-5.7.1-m11/storage/myisam/ha_myisam.cc 87 static MYSQL_THDVAR_ULONGLONG(sort_buffer_size, PLUGIN_VAR_RQCMDARG, 88 "The buffer that is allocated when sorting the index when doing " 89 "a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE", NULL, NULL, 90 8192 * 1024, (long) (MIN_SORT_BUFFER + MALLOC_OVERHEAD), SIZE_T_MAX, 1); in mysql-5.7.1-m11/storage/myisam/myisamdef.h 675 #define MIN_SORT_BUFFER (4096-MALLOC_OVERHEAD) 2013-06-12 16:40:03 23664 [Warning] option 'myisam-sort-buffer-size': unsigned value 4 adjusted to 4096
[12 Jun 2013 14:23]
Paul DuBois
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.