List:General Discussion« Previous MessageNext Message »
From:Mihail Manolov Date:May 10 2012 6:51pm
Subject:Re: How to quickly detect if there are any crashed tables
View as plain text  
You can enable check/recovery automatically by using "myisam_recover". Look it up in the
documentation.

There is no way to repair them "faster", though.

On May 10, 2012, at 2:40 PM, Adrian Fita wrote:

> Hi.
> 
> I have several hundreds of databases with MyISAM tables in a server and
> after a power outage, I have to manually repair them with mysqlcheck.
> Sometimes I forget and it's not nice. So I am thinking of making a
> Nagios plugin to check if there are any crashed tables that need repairing.
> 
> I tried using "mysqlcheck --all-databases --quick --check
> --check-only-changed --fast", but it still took around 2h to run.
> 
> I also tried using myisamchk with "find /var/lib/mysql -name '*.MYI'
> -exec myisamchk --silent --fast '{}' \;", but still, after 15 minutes,
> it hasn't finished.
> 
> I am looking for a solution that will give me an answer in at least 3-4
> minutes.
> 
> I apreciate any sugestions you might have.
> 
> Thanks,
> -- 
> Fita Adrian
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
> 

Thread
How to quickly detect if there are any crashed tablesAdrian Fita10 May
  • Re: How to quickly detect if there are any crashed tablesMihail Manolov10 May
    • Re: How to quickly detect if there are any crashed tablesAdrian Fita10 May
      • Re: How to quickly detect if there are any crashed tablesMihail Manolov10 May
        • RE: How to quickly detect if there are any crashed tablesSteven Staples10 May
          • Re: How to quickly detect if there are any crashed tablesAdrian Fita11 May
  • RE: How to quickly detect if there are any crashed tablesRick James11 May