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).
Subject
Views
Written By
Posted
MEMORY tables appalling insert performance
12500
October 26, 2009 11:46AM
6220
October 26, 2009 03:57PM
5581
December 31, 2009 01:30AM
5376
December 31, 2009 10:20AM
5852
December 31, 2009 01:43AM
5838
December 31, 2009 10:18AM
5349
December 31, 2009 08:54PM
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.