DELETE query slow on Memory storage engine
I have a table that gets updated constantly with bulk inserts, and is queried every 5 mintes minute for the prior 5-minutes worth of data. Every minute I also purge data older than 10 minutes from the table. At peak times there gets to be about 600k rows in the table and about 50 MB in size. I'm currently using the MyISAM storage engine, but that is quite disk intensive.
I've tried converting this table over the MEMORY storage engine and it works great until I go to purge the old data from the table with this query:
DELETE FROM table WHERE timestamp < 1184612613
But that sometimes takes 8-10 minutes to complete, which is clearly too long. The same query with MyISAM completes in a few seconds which doesn't really make sense to me since it is disk-based.
Have I got something configured weird for my MEMORY engine?
Subject
Views
Written By
Posted
DELETE query slow on Memory storage engine
19887
July 16, 2007 01:27PM
9225
July 16, 2007 05:53PM
8923
July 25, 2007 09:00PM
6983
January 28, 2009 07:41AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.