Ben Clewett wrote:
Jeff,
Thanks for your idea. Deleting data x rows at a time would certainly
help, if AUTOCOMMIT=TRUE. But I have no idea how :) I have tried:
DELETE FROM very_large_table WHERE delete_flag=1 LIMIT 10;
But the LIMIT is not understood (4.1.8).
What do you mean? That
Jeff,
Thanks for your idea. Deleting data x rows at a time would certainly
help, if AUTOCOMMIT=TRUE. But I have no idea how :) I have tried:
DELETE FROM very_large_table WHERE delete_flag=1 LIMIT 10;
But the LIMIT is not understood (4.1.8).
Unfortunately my 'delete_flag' is not key.
Dear MySQL,
I am having a lot of problems deleting a large amount of data. Say 20GB
from a 40GB table. I seem to get failure quite a lot (due NOT to mysql,
but bad hardware), then MySQL roles back the transaction, which takes as
many hours and starting the transaction. I also get this a lot:
On Monday 14 February 2005 03:52 am, Ben Clewett wrote:
I am having a lot of problems deleting a large amount of data. Say 20GB
from a 40GB table. I seem to get failure quite a lot (due NOT to mysql,
but bad hardware), then MySQL roles back the transaction, which takes as
many hours and