MySQL Forums
Forum List  »  MyISAM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Multiple key cache / staging table issue
2978
November 03, 2011 08:00AM


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.