From owner-freebsd-questions@FreeBSD.ORG Tue Oct 28 10:55:16 2003 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 9A14816A4CE for ; Tue, 28 Oct 2003 10:55:16 -0800 (PST) Received: from mail.7f000001.org (kyblik.pieskovisko.sk [213.215.72.42]) by mx1.FreeBSD.org (Postfix) with SMTP id D002D43F93 for ; Tue, 28 Oct 2003 10:55:14 -0800 (PST) (envelope-from f-freebsd@7f000001.org) Received: (qmail 60160 invoked by uid 19508); 28 Oct 2003 18:55:12 -0000 Date: Tue, 28 Oct 2003 19:55:11 +0100 From: f-freebsd@7f000001.org To: questions@freebsd.org Message-ID: <20031028185511.GA34294@kyblik.pieskovisko.sk> Mail-Followup-To: f-freebsd@7f000001.org, questions@freebsd.org References: Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="a8Wt8u1KmwUX3Y2C" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.4i Subject: Re: Load Average more than 400 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 28 Oct 2003 18:55:16 -0000 X-List-Received-Date: Tue, 28 Oct 2003 18:55:16 -0000 --a8Wt8u1KmwUX3Y2C Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Oct 28, 2003 at 08:05:15PM +0300, Varshavchick Alexander wrote: > Hi gurus, >=20 > can you please hint as what parameters I have monitor to find the cause of > sudden splashes of load of a FreeBSD 4.6.2-RELEASE server? This box is > acting as a database/mysql server and periodically goes up to 400 of load > average values and then gradually returns to a normal 4-5 value. The > server is a dual Xeon with 4G phisical memory, mysql 4.0.7/linuxthreads. > During the highest load, the amount of Inact memory remains of about 2G, > and swap is used only minimally, so this cannot be the case. There are no > messages in a system log or mysql log. >=20 > Any help is greatly appreciated, thanks is advance MySQL has done this to me after an unclean shutdown. Try stopping mysqld and running myisamchk -r on all tables. m&f --=20 What do you care what other people think? --a8Wt8u1KmwUX3Y2C Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (FreeBSD) iD8DBQE/nruP4PY2BaN84VwRAhpCAJ4kxArO1SxhBzEP9b3dJE2NjyZGJACcCUGp NEeXHMbAhNHw/r/N0IE9qh8= =zzrg -----END PGP SIGNATURE----- --a8Wt8u1KmwUX3Y2C--