MySQL Forums
Forum List  »  Memory Storage Engine

DELETE query slow on Memory storage engine
Posted by: Brandon Checketts
Date: July 16, 2007 01:27PM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
DELETE query slow on Memory storage engine
18698
July 16, 2007 01:27PM


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.