Yes, it builds a new index file before deleteing the old.
Oswaldo Castro wrote:
>Hi List
>
>I have a table with 90 Millions records and 8 indexes (75GB). I am
>trying to drop one of them but I get an errorcode 28 (no space left on
>device). df- v gives me an extra 27% of free space.
>
>My questions:
>
>Does MySQL use temporary areas to drop indexes and for what ?
>
>Is there a way to tell to MySQL to ignore this ?
>
>Thanks in advance
>
>Oswaldo Castro
>
>
>
>
>
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php