Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 25 Aug 2006 15:27:29 +0800
From:      Andrew I Baznikin <andrey.baznikin@krasinform.ru>
To:        freebsd-isp@freebsd.org
Cc:        jeremiah.foster@clickstore.se
Subject:   Re: Hardware RAID 1 management tools
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>

next in thread | previous in thread | raw e-mail | index | archive | help
On Fri, 25 Aug 2006 08:21:30 +0200
Jeremiah Foster <jeremiah.foster@clickstore.se> 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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20060825152729.5987f94e>