g run, consider switching to InnoDB; it is self-repairing.
> -Original Message-
> From: Adrian Fita [mailto:adrian.f...@gmail.com]
> Sent: Thursday, May 10, 2012 11:40 AM
> To: mysql@lists.mysql.com
> Subject: How to quickly detect if there are any crashed tables
>
>
On Thu, May 10, 2012 at 10:26 PM, Steven Staples wrote:
> I think you can scan the syslog for the mysql daemon, and it will show you
> any crashed, or problematic tables?
>
> If this is in fact the case, you could try that, and then run though the
> tables to check them later?
Indeed, I was think
> AFAIK the tables will be locked one by one until checked/repaired.
>
> On May 10, 2012, at 3:07 PM, Adrian Fita wrote:
>
> > On 10/05/12 21:51, Mihail Manolov wrote:
> >> You can enable check/recovery automatically by using
> >> "myisam_recover". Look it up in the documentation.
> >>
> >> There
AFAIK the tables will be locked one by one until checked/repaired.
On May 10, 2012, at 3:07 PM, Adrian Fita wrote:
> On 10/05/12 21:51, Mihail Manolov wrote:
>> You can enable check/recovery automatically by using
>> "myisam_recover". Look it up in the documentation.
>>
>> There is no way to rep
On 10/05/12 21:51, Mihail Manolov wrote:
> 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.
Thanks for the quick response. This definetly looks like a useable
solution. Do you know if dur
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 p
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
