Re: mutex contention for the query cache

[Brian Aker]

Hi!

On Jul 3, 2008, at 12:27 PM, MARK CALLAGHAN wrote:

> 1) global mutex on query cache
> 2) global mutex on MyISAM key cache
> 3) global mutex on InnoDB memory allocator
> 4) inefficient rw-mutex in InnoDB
> 5) contention on transaction log mutex in InnoDB

Depending on what you are doing the memory engine is also an issue.  
You can replace it with an internally built hash table engine that  
since you know the largest possible number of rows (and it is not  
concurrent) you can speed up a number of operations.

There are a number of other locks that are also problematic around  
ACL, etc...

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.