Could the problem the Locked data table in this case?
mysql> show processlist;
+-----+-------+-----------------------------------+-------+---------+---
-----+--------------+---------------------------------------------------
---------------------------------------------------+
| Id | User | Host | db | Command |
Time | State | Info
|
+-----+-------+-----------------------------------+-------+---------+---
-----+--------------+---------------------------------------------------
---------------------------------------------------+
| 1 | goat | xxxxxxxxxxxxxxxxxxxxxxxxxxx:62693 | snort | Query |
424668 | Locked | INSERT INTO data (sid,cid,data_payload) VALUES
('2','13305243','00000000450000C10FEF40002F11D162CD9E |
| 524 | root | localhost | snort | Query |
424669 | Sending data | DELETE data from data JOIN sidtemp ON data.cid =
sidtemp.cid |
| 537 | root | localhost | snort | Query |
242922 | Locked | DELETE data
FROM data, event
WHERE data.cid = event.cid
AND event.timestamp < "2006-05-01" |
| 542 | root | localhost | NULL | Query |
0 | NULL | show processlist
|
+-----+-------+-----------------------------------+-------+---------+---
-----+--------------+-----------------------------
I killed 524 & 537, started over and CPU went down. The query is still
slow.
Do I need to bring the database down to single user mode(I don't know
the correct
Term so I just am guessing single user mode exists) then do the delete?
Thank you,
Raymond
