I've had to delete large amounts of records from tables with over 200 millions records. You are correct in that you want to do it in
chunks. How you divide the deletes is up to you to decide. You would want to do it based on a indexed column, like a date, and
specify a range.
DELETE data
FROM
Could the problem the Locked data table in this case?
mysql show processlist;
+-+---+---+---+-+---
-+--+---
---+
| Id | User | Host
It appears that every time I start query the event or the data table
gets Locked.
Could this have any affect on why it takes so long to delete records.
Grasping at straws,
Thank you,
Raymond
mysql show processlist;
+-+---+---+---+-
Raymond, I would expect that adding an index on 'cid' column in your
'sidtemp' table would help quite a bit.
Out of curiousity, why use a temp table in this situation? Why not
DELETE data
FROM data, event
WHERE data.cid = event.cid
AND event.timestamp 2006-05-01
Dan
On 7/7/06, Jacob,
-Original Message-
From: Dan Buettner [mailto:[EMAIL PROTECTED]
Sent: Friday, July 07, 2006 15:48
To: Jacob, Raymond A Jr
Cc: mysql@lists.mysql.com
Subject: Re: How does one speed up delete.
Raymond, I would expect that adding an index on 'cid' column in your
'sidtemp' table would
Subject: Re: How does one speed up delete.
Raymond, I would expect that adding an index on 'cid' column in your
'sidtemp' table would help quite a bit.
Out of curiousity, why use a temp table in this situation? Why not
Dan:
I had erroneously assumed that the delete would delete rows from data
