MySQL Forums
Forum List  »  Memory Storage Engine

Re: MEMORY tables appalling insert performance
Posted by: Slawek P
Date: December 31, 2009 10:20AM

Hi,

Thanks for your comment, however by partitioning i meant that there are 10 separate tables, and the partitioning is done manually just by directing queries to appropriate table.

Eg.

table0
...
table9

$table_name = "table".($pri_key)%10;
$query = "INSERT INTO {$table_name} [..]";

So there's a problem with memory engine locking, not any other functionality in mysql.

Options: ReplyQuote


Subject
Views
Written By
Posted
12236
October 26, 2009 11:46AM
Re: MEMORY tables appalling insert performance
5252
December 31, 2009 10:20AM


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.