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
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
