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

Written By
October 26, 2009 11:46AM
Re: MEMORY tables appalling insert performance
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.