From owner-freebsd-stable@FreeBSD.ORG Wed May 13 20:52:10 2009 Return-Path: Delivered-To: freebsd-stable@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 1BDCD1065696; Wed, 13 May 2009 20:52:10 +0000 (UTC) (envelope-from prvs=1384594dfb=killing@multiplay.co.uk) Received: from mail1.multiplay.co.uk (core6.multiplay.co.uk [85.236.96.23]) by mx1.freebsd.org (Postfix) with ESMTP id 6C10E8FC18; Wed, 13 May 2009 20:52:09 +0000 (UTC) (envelope-from prvs=1384594dfb=killing@multiplay.co.uk) DKIM-Signature: v=1; a=rsa-sha256; c=simple; d=multiplay.co.uk; s=Multiplay; t=1242247927; x=1242852727; q=dns/txt; h=Received: Message-ID:From:To:Cc:References:Subject:Date:MIME-Version: Content-Type:Content-Transfer-Encoding; bh=CUETGWalDBsRblPURd/FP u2cjmrRgUrI69usIqDz3E4=; b=eWPjT7i76OXn5PIPeL6VwCv5DqbwfA3T8AsLB 15CcfU5Dtq1+RMCRrHdTmYDgFlAco8GRTZtKmLTaehUnhUjRJOyyTQXhj7N8xMDb IyPP43pqv/57kZDtavVLqY8gCVQ9/vzzKCRrql5NPaTzfkw2AUJk7f2LENIZyJ10 yyf2zQ= X-MDAV-Processed: mail1.multiplay.co.uk, Wed, 13 May 2009 21:52:07 +0100 Received: from r2d2 by mail1.multiplay.co.uk (MDaemon PRO v10.0.4) with ESMTP id md50007509389.msg; Wed, 13 May 2009 21:52:06 +0100 X-Spam-Processed: mail1.multiplay.co.uk, Wed, 13 May 2009 21:52:06 +0100 (not processed: message from trusted or authenticated source) X-Authenticated-Sender: Killing@multiplay.co.uk X-MDRemoteIP: 85.236.106.102 X-Return-Path: prvs=1384594dfb=killing@multiplay.co.uk X-Envelope-From: killing@multiplay.co.uk Message-ID: <005C678EA6964926B9EE95B0EF252CE9@multiplay.co.uk> From: "Steven Hartland" To: "Marc G. Fournier" 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> <20090513161014.A17646@hub.org> Date: Wed, 13 May 2009 21:52:13 +0100 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.5512 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579 Cc: freebsd-stable@freebsd.org, John Baldwin Subject: Re: More data on 7.2-RELEASE "hangs" X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 13 May 2009 20:52:14 -0000 ----- Original Message ----- From: "Marc G. Fournier" > 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 ... Another good way to help id issues like this that are related to mysql is: http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html If you can get a mysql process list run when the machine is in this state it will likely help you id the issue quite quickly. Regards Steve ================================================ This e.mail is private and confidential between Multiplay (UK) Ltd. and the person or entity to whom it is addressed. In the event of misdirection, the recipient is prohibited from using, copying, printing or otherwise disseminating it or any information contained in it. In the event of misdirection, illegible or incomplete transmission please telephone +44 845 868 1337 or return the E.mail to postmaster@multiplay.co.uk.