From: Date: July 3 2008 9:38pm Subject: Re: mutex contention for the query cache List-Archive: http://lists.mysql.com/internals/35790 Message-Id: MIME-Version: 1.0 (Apple Message framework v924) Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit 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.