MySQL Forums
Forum List  »  Memory Storage Engine

Deleting rows extremely slow using memory engine
Posted by: pgb 205
Date: December 05, 2008 11:52AM

server=mysql 5.

all the tables in database except for one are myisam but the largest table i converted to memory engine in the hopes of improved performance. Select shows it
as being about 50 pct faster than with MyISAM engine. However when i try to delete old data from the table it takes forever to delete a few thousand rows. I've found some reports that it's a bug in mysql but no idea on how to fix this.
EDIT: The same thing happens when i try to drop indexes on the memory table.


Edited 1 time(s). Last edit at 12/05/2008 11:59AM by pgb 205.

Options: ReplyQuote

Written By
Deleting rows extremely slow using memory engine
December 05, 2008 11:52AM

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.