Set up a loop where you delete with a LIMIT,
pause a few milliseconds to give others a chance to get in,
and loop until no records are deleted.
Philip Mak wrote:
I have a table in a database. I'm trying to delete 5 million rows from
it. But whenever I try to do this, while the delete command is
Hi.
On Sun 2003-01-12 at 22:01:37 -0500, [EMAIL PROTECTED] wrote:
> On Sun, Jan 12, 2003 at 08:12:35PM -0700, Rodney Broom wrote:
> > > I'm trying to delete 5 million rows...
[...]
> If I was deleting things regularly, I'd have to delete maybe a couple
> hundred thousand rows every day.
[...]
> Wh
> > > I'm trying to delete 5 million rows...
Can you drop the table, then re-create it for further use?
Anything besides the 5,000,000 you want to keep?
> >
> > Do you have to do this often?
>
> Sort of. I have a process that logs to MySQL, and I want to delete old
> log entries. I haven't been
On Sun, Jan 12, 2003 at 08:12:35PM -0700, Rodney Broom wrote:
> > I'm trying to delete 5 million rows...
>
> Do you have to do this often?
Sort of. I have a process that logs to MySQL, and I want to delete old
log entries. I haven't been deleting old entries at all recently
because it will freeze
From: Philip Mak <[EMAIL PROTECTED]>
> I'm trying to delete 5 million rows...
Do you have to do this often?
> ...access to the other tables in the database are blocked...
How do you mean "blocked"? Do you mean that you're getting an error message someplace,
or that other operations take way t