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;
+-+---+---+---+-
Could the problem the Locked data table in this case?
mysql> show processlist;
+-+---+---+---+-+---
-+--+---
---+
| Id | User | Host
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 da
: 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 help quite a bit.
Out of curiousity, why use a temp table in this situation? Why not
Dan:
I had erroneo
-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
'sidte
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, Raym
