Date: Fri, 25 Aug 2006 08:21:30 +0200 From: Jeremiah Foster <jeremiah.foster@clickstore.se> To: freebsd-isp@freebsd.org Subject: Re: Hardware RAID 1 management tools Message-ID: <1156486891.9152.7.camel@localhost.localdomain> In-Reply-To: <20060824163915.GJ12155@ns2.wananchi.com> References: <1156229799.4893.150.camel@localhost.localdomain> <20060824163915.GJ12155@ns2.wananchi.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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? Jeremiah
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1156486891.9152.7.camel>