Hello root!
> >Description:
> Can't delete from incredibly fat table.
> >Synopsis: unable to delete table data, running out of disk space for it!
Well, that pretty much wraps it up, doesn't it? This is a hardware
problem, not a software problem.
The software must read the old table and create and entirely new table
-before- it deletes the old table. So it takes 10M - 1k of free drive
space to delete 1k from the original table.
Try deleteing a 'several months' worth of data at one shot as you
mentioned.
You can mysqldump the table and edit it manually and reload it but that
still requires a lot of drive space.
If you can dump the table, you can delete the real table and very likely
have enough drive space to edit and reload but that takes a bit of faith,
crossed fingers, and a few heart thumping moments.
If you can dump the table but not edit it you can ftp it over to another
machine that has enough drive space to edit it. Then ftp it back and
reload it.
(By coincidence my htdig froze up last night during the nightly update. I
usually have about 500M free but forgot to clean up a few things yesterday
and left only about 200M free. Gonna write a cron to log free space during
that period to find out the the real limit is.)
Have a :) day!
jb
--
jim barchuk
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
