Bug #35620 | Please make "Repair by sorting" the default method to rebuild indexes | ||
---|---|---|---|
Submitted: | 27 Mar 2008 17:55 | Modified: | 27 Mar 2008 17:59 |
Reporter: | Shane Bester (Platinum Quality Contributor) | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: MyISAM storage engine | Severity: | S4 (Feature request) |
Version: | 5.1.24, 6.0.5 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | myisam_max_sort_file_size, Repair by sorting, Repair with keycache |
[27 Mar 2008 17:55]
Shane Bester
[26 Aug 2009 9:13]
P R
whats the status on this request? this is essential... can a quick, 'use at your own risk' patch please be provided for users? or, can a sure-fire workaround/hack be suggested??? - the method of adjusting the server variables cannot always be trusted, and doesnt guarantee that the repair-by-sort method will be chosen... mysql team, please respond...
[27 Aug 2009 5:44]
MySQL Verification Team
related: bug #46945
[20 Feb 2012 10:06]
Peter Colclough
Albeit 4 years later... I would like to request this too. At least at the 'warning' level. Been hit by trying to reindex 83m rows, and running out of disk space, as Mysql tried to use 'repair by keycache' as a defualt. Looks like a Boolean round the wrong way....