From: Date: July 4 2008 8:31pm Subject: Re: mutex contention for the query cache List-Archive: http://lists.mysql.com/internals/35809 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 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.