Re: mutex contention for the query cache

[Brian Aker]

Hi!

On Jul 4, 2008, at 7:44 AM, MARK CALLAGHAN wrote:

> I fear that some of the hardware we are to be offered won't meet the
> needs of the software we have deployed and we will all end up buying

If you end up with multi-core board with multi-processors, if you can  
disable cores you can get a bit more performance. Crazy? Yeah, but it  
happens to be where the main branch is today.

> few changes: partition the query cache and MyISAM key cache so the one
> big lock is replaced with N locks and then use a spin lock built on
> top of pthread mutex rather than using pthread mutex directly.

Have you started working on the MySQL Keycahe feature?

Cheers,
	-Brian


--
_______________________________________________________
Brian "Krow" Aker, brian at tangent.org
Seattle, Washington
http://krow.net/                     <-- Me
http://tangent.org/                <-- Software
_______________________________________________________
You can't grep a dead tree.