Re: Hardware RAID 1 management tools

On Fri, 25 Aug 2006 08:21:30 +0200
Jeremiah Foster <jeremiah.foster@xxxxxxxxxxxxx> 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
_______________________________________________
freebsd-isp@xxxxxxxxxxx mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-isp
To unsubscribe, send any mail to "freebsd-isp-unsubscribe@xxxxxxxxxxx"

Relevant Pages

  • Re: Hardware RAID 1 management tools
    ... when that happens because the database slows to a crawl. ... In fact I have been using a variety of system monitoring and mysql ... statistically significant changes when a disk fails. ...
    (freebsd-isp)
  • Re: I am totally stumped..with this on..LOAD_FILE Mysql+PHP= FSCK!!
    ... What I am trying to do is to upload files and stuff them in a mysql database. ... I copied the temporary file to somewhere else, and then handed it to MySQL..THAT WORKED.. ... Is there a way to force a close on the file..maybe that's the problem Mysql is opening a file that is not flushed to disk maybe? ... I gew the feeling its maintaining its own picture of file objects, and doesn't actually flush to the disk unless you do a copy or close php.. ...
    (comp.lang.php)
  • Re: MySQL config [WAS: ]uilding a new workstation - dual or quad-core CPU for FreeBSD 7?
    ... flaw in how mysql handles non-zero concurrency values here (innodb ... check if it should try to allow more innodb concurrency. ... instead of being bottlenecked by disk speeds and leaving the CPUs mostly ... We should probably submit a bug to MySQL rather then add a patch to ...
    (freebsd-questions)
  • Re: read-write SQL performance
    ... The reason for this is that the disk ... In fact mysql and pgsql have identical performance ... Faster disk hardware is necessary to explore database performance ...
    (freebsd-arch)
  • Re: read-write SQL performance
    ... The reason for this is that the disk ... In fact mysql and pgsql have identical performance ... Faster disk hardware is necessary to explore database performance ...
    (freebsd-performance)