Bug #14787 | dropping last index from table should be optimized | ||
---|---|---|---|
Submitted: | 9 Nov 2005 15:08 | Modified: | 17 Dec 2010 7:45 |
Reporter: | Elan Ruusamäe (OCA) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S4 (Feature request) |
Version: | 5.0.15 | OS: | Any (PLD Linux) |
Assigned to: | CPU Architecture: | Any |
[9 Nov 2005 15:08]
Elan Ruusamäe
[15 Mar 2007 10:44]
Ingo Strüwing
The header of the MYI file contains important information about the table layout. We cannot just drop that file. Indeed in this version every ALTER TABLE makes a copy of the data file and rebuilds all indexes. However, in 5.1 we began to do some optimizations. And we will continue to do so. Eventually your feature request will be implemented.
[17 Dec 2010 7:45]
Susanne Ebrecht
I will close this bug report because there is already lots of work done on that topic.