Perhaps your index file (.MYI) is growing larger than 2GB, the file-size limit on 2.2.x kernels?
Or, if you have moved the tables with symlinks, MySQL will put the new file (most of the time?) in the configured data directory and not where the symlink points. --Bill Mike Lucente wrote: > 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 -- Bill Adams TriQuint Semiconductor --------------------------------------------------------------------- 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
