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.
Subject
Views
Written By
Posted
12502
October 26, 2009 11:46AM
6221
October 26, 2009 03:57PM
5582
December 31, 2009 01:30AM
Re: MEMORY tables appalling insert performance
5377
December 31, 2009 10:20AM
5853
December 31, 2009 01:43AM
5840
December 31, 2009 10:18AM
5350
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.