MySQL Forums
Forum List  »  Memory Storage Engine

MEMORY tables appalling insert performance
Posted by: Slawek P
Date: October 26, 2009 11:46AM

mySQL 5.0.51a

Small MEMORY table, 100k rows, 80% insert, 20% select, 500q/sec.

inserts are ON DUPLICATE KEY UPDATE

All by UNIQUE PRI key, B-Tree index, index isn't changed during the update.

Now the problem is that INSERTS blocks for 1-2 sec every 10-30 sec. How do i know that INSERT is blocking? Because there are no SELECT / DELETE threads, only INSERT / UPDATE, with insert in LOCKED state.

I partitioned the table 10x 10k rows, nothing.
Turned off the query cache, nothing.

Any idea / software that'll be better suitable for this kind of traffic (for PHP)? InnoDB is not suitable (too many I/O writes).

Options: ReplyQuote


Subject
Views
Written By
Posted
MEMORY tables appalling insert performance
12262
October 26, 2009 11:46AM


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.