From owner-freebsd-isp@FreeBSD.ORG Fri Aug 25 07:27:09 2006 Return-Path: X-Original-To: freebsd-isp@freebsd.org Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 4AAB616A4DA for ; Fri, 25 Aug 2006 07:27:09 +0000 (UTC) (envelope-from andrey.baznikin@krasinform.ru) Received: from hq.sibinet.ru (ns.fliknet.ru [213.24.217.225]) by mx1.FreeBSD.org (Postfix) with ESMTP id B951C43D4C for ; Fri, 25 Aug 2006 07:27:07 +0000 (GMT) (envelope-from andrey.baznikin@krasinform.ru) Received: from localhost (unknown [127.0.0.1]) by hq.sibinet.ru (Postfix) with ESMTP id 265835F30; Fri, 25 Aug 2006 15:27:04 +0800 (KRAST) Received: from hq.sibinet.ru ([127.0.0.1]) by localhost (hq.sibinet.ru [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 39597-03; Fri, 25 Aug 2006 15:26:56 +0800 (KRAST) Received: from dikiy.book (unknown [80.255.153.182]) by hq.sibinet.ru (Postfix) with ESMTP id 3E7935F35; Fri, 25 Aug 2006 15:26:53 +0800 (KRAST) Date: Fri, 25 Aug 2006 15:27:29 +0800 From: Andrew I Baznikin To: freebsd-isp@freebsd.org Message-ID: <20060825152729.5987f94e@dikiy.book> In-Reply-To: <1156486891.9152.7.camel@localhost.localdomain> References: <1156229799.4893.150.camel@localhost.localdomain> <20060824163915.GJ12155@ns2.wananchi.com> <1156486891.9152.7.camel@localhost.localdomain> X-Mailer: Sylpheed-Claws 2.3.1 (GTK+ 2.8.20; i386-portbld-freebsd6.1) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at intraline.ru Cc: jeremiah.foster@clickstore.se Subject: Re: Hardware RAID 1 management tools X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 25 Aug 2006 07:27:09 -0000 On Fri, 25 Aug 2006 08:21:30 +0200 Jeremiah Foster wrote: > On Thu, 2006-08-24 at 19:39 +0300, Odhiambo Washington wrote: > > > and find out when the RAID disks are failing, right now I can tell > > > when that happens because the database slows to a crawl. > > > > That reasoning does not sound technical at all. Please find out why > > the MySQL server itself is slowing down by using tools like mytop (in > > the ports, log-slow-queries, etc). > > In fact I have been using a variety of system monitoring and mysql > monitoring tools. Mytop has been used extensively, all the logs have > been analyzed, the huge mysql config is being used, the database has > been refactored, top and as well as other system tools have been used. > All show dramatic, statistically significant changes when a disk fails. > When we replace the disk mysql goes back to using very little processor > from using 80% or more. So in fact it is quite technical. > > What I want is a tool that will warn me of disk failures before mysql > does, is such a thing available for FreeBSD? Smarttools can monitor SMART attributes on harddisks, do offline testing and so on. -- Andrew I Baznikin # /\ ASCII ribbon # \/ campaign # /\ against # / \ HTML email