Multiple key cache / staging table issue
Posted by:
Slawek P
Date: November 03, 2011 08:00AM
Hi Guys,
I have a problem with choosing appropriate technique. We're building an adserver and we need stats... so we have one staging table where we write impressions, unique impressions, etc.
Then we merge the staging with main innoDB/myISAM table.
I have read that on myisam there's key cache mutex problem so we need multiple KC to scale the thing efficiently. My question is: does multiple key cache works also for MEMORY tables?
Earlier i tried sharding, so i created 10 same MEMORY tables that would hold the data, but it hasn't improved the situation in any way. The tables got locked as frequently as when i was using just one table.
So ... currently. Any type of engine i use for staging table - it'll still trigger some global MUTEXes, so i can't create shards because it'll be limited to single core speed anyway?
Thanks,
Slawomir.
Subject
Views
Written By
Posted
Multiple key cache / staging table issue
2978
November 03, 2011 08:00AM
1478
November 04, 2011 08:44AM
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.