Date: Wed, 13 May 2009 16:14:51 -0300 (ADT) From: "Marc G. Fournier" <scrappy@hub.org> To: Steven Hartland <killing@multiplay.co.uk> Cc: freebsd-stable@freebsd.org, John Baldwin <jhb@freebsd.org> Subject: Re: More data on 7.2-RELEASE "hangs" Message-ID: <20090513161014.A17646@hub.org> In-Reply-To: <6670CCCC546E45E0A28628C45B37A074@multiplay.co.uk> References: <20090513040719.D17646@hub.org><200905131009.00403.jhb@freebsd.org><20090513133143.M17646@hub.org> <200905131252.15171.jhb@freebsd.org> <20090513142806.V17646@hub.org> <6670CCCC546E45E0A28628C45B37A074@multiplay.co.uk>
next in thread | previous in thread | raw e-mail | index | archive | help
On Wed, 13 May 2009, Steven Hartland wrote: > We've seen things similar to this when an process uncommon process does > a query which locks the a table for a large amount of time on mysql. Sooooo many reasons why I hate MySQL :( One thing that we are trying right now is actually along these lines ... we've been working with MySQL 5.1 + NDBD for clustering ... after the last hang, we disabled both the NDBD startup, and mysql, to see if that is the cause, so nice to have some validation on this one ... > In our example this turned out to be an admin query in vbulletin. When > it happened it turned a machine which was purring along quite nicely > into a totally unresponsive machine in a matter of a few seconds as > apache spawned more process that also then instantly stalled... Let me check that the next time around ... compare the specific # of http processes between monitor runs and see if there is a 'sudden jump' ... We'll see hwo the next 'test period' works out, with that MySQL stuff offline ... the other thing I've been working on is moving jails off of that server, one at a time, to see if I can narrow down which one is causing the spike ... I will focus on the mysql backend ones going forward, to eliminate those ... Thx ... ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email . scrappy@hub.org MSN . scrappy@hub.org Yahoo . yscrappy Skype: hub.org ICQ . 7615664
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20090513161014.A17646>