I'm running out of space while creating indexes on some fairly large (1.8
GB) tables, even though I have quite a bit of space available in the
partition (utilization is at 30%).
I know that the create process works as follows (from the manual):
Create a new table named `A-xxx' with the requested changes.
All rows from the old table are copied to `A-xxx'.
The old table is renamed `B-xxx'.
`A-xxx' is renamed to your old table name.
`B-xxx' is deleted.
Given that, I should have plenty of room. Disk utilization doesn't appear
to exceed 60% during the process.
Any idea what could be causing this?
** Running RH 7.1 on a Dell 2450. MySQL version 3.23.29a-gamma-log.
---------------------------------------------------------------------
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
