MySQL Forums
Forum List  »  Memory Storage Engine

Re: MEMORY tables appalling insert performance
Posted by: Slawek P
Date: October 26, 2009 03:57PM

I'm wondering why partitioning doesn't work. Is that because there is one "memory pool" that gets locked for each write/update operation (so when value is inserted all the memory tables are locked?).

Maybe there is some concurrency problem? Did maybe someone tried a FIFO buffer in form of a NON-BLOCKING proxy that takes INSERT/UPDATE/DELETE ops and executes them one-by-one?

Options: ReplyQuote


Subject
Views
Written By
Posted
12287
October 26, 2009 11:46AM
Re: MEMORY tables appalling insert performance
6122
October 26, 2009 03:57PM


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.