From owner-freebsd-stable@FreeBSD.ORG Tue Jun 27 00:06:37 2006 Return-Path: X-Original-To: freebsd-stable@freebsd.org Delivered-To: freebsd-stable@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 0E76B16AA29 for ; Tue, 27 Jun 2006 00:06:37 +0000 (UTC) (envelope-from MH@kernel32.de) Received: from crivens.terrorteam.de (crivens.terrorteam.de [81.169.171.191]) by mx1.FreeBSD.org (Postfix) with ESMTP id C54AA4454C for ; Mon, 26 Jun 2006 23:25:33 +0000 (GMT) (envelope-from MH@kernel32.de) Received: from localhost (localhost [127.0.0.1]) by crivens.terrorteam.de (Postfix) with ESMTP id 077A94557; Tue, 27 Jun 2006 01:25:32 +0200 (CEST) X-Virus-Scanned: amavisd-new at unixoid.de Received: from crivens.terrorteam.de ([127.0.0.1]) by localhost (crivens.unixoid.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id d--h5aiQudfZ; Tue, 27 Jun 2006 01:25:31 +0200 (CEST) Received: from [212.91.238.184] (unknown [212.91.238.184]) by crivens.terrorteam.de (Postfix) with ESMTP id E02A03F27; Tue, 27 Jun 2006 01:25:29 +0200 (CEST) Message-ID: <44A06CE9.7040901@kernel32.de> Date: Tue, 27 Jun 2006 01:25:29 +0200 From: Marian Hettwer User-Agent: Mozilla Thunderbird 1.0.2 (Macintosh/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Marc G. Fournier" References: <20060624221556.O30039@woozle.rinet.ru> <20060624152525.D1114@ganymede.hub.org> <20060625164752.H52500@woozle.rinet.ru> <20060625105843.O1114@ganymede.hub.org> <20060625211510.D52500@woozle.rinet.ru> <20060625154247.N1114@ganymede.hub.org> <20060626014210.P1114@ganymede.hub.org> <20060626014601.E1114@ganymede.hub.org> <20060626045547.GI79678@deviant.kiev.zoral.com.ua> <20060626021616.W1114@ganymede.hub.org> <20060626143038.GK79678@deviant.kiev.zoral.com.ua> <20060626152345.M1114@ganymede.hub.org> In-Reply-To: <20060626152345.M1114@ganymede.hub.org> X-Enigmail-Version: 0.93.0.0 Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: 7bit Cc: Kostik Belousov , freebsd-stable@freebsd.org, Dmitry Morozovsky Subject: Re: vmstat 'b' (disk busy?) field keeps climbing ... 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: Tue, 27 Jun 2006 00:06:37 -0000 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hej there, Marc G. Fournier wrote: > > I think I might have found *at least* one of the problems, and that > being the excessively high blocked states while ps isn't finding > anything ... > > MySQL > > We just recently started allowing clients to run a MySQL server *within* > their vServer ... in a drastic move, I just shut them all down on pluto, > and blocked drop'd from ~86 down to 5 in a matter of moments ... > restarting them all has it climbing once more, being up around 22 > already ... > I don't know wether it helps at all. I guess, not... But I'm seeing blocked processes (mysqld) waiting for disk I/O all over the place when running heavy duty MySQL servers. This is on Linux and FreeBSD. Linux would be either 2.4.31 or 2.6.14 both with MySQL 4.1.x ./Marian -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (Darwin) iD8DBQFEoGzngAq87Uq5FMsRAvk2AKDhWv6DplvGko1/5F4sy7JXuSOcTACcC8zO uF/xKOKq7oyR2V/cP93CKzI= =dv7F -----END PGP SIGNATURE-----