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
