Monitor MySQL servers for crashed tables? - GoFuckYourself.com

Zeiss · 09-15-2014, 10:04 AM

Is there something to monitor for crashed tables? I just found out one of my sites had a table crashed and had to be repaired. It was like this for about 3 days.

Never happened before. How do I get notified about tables "marked as crashed", so I can repair them? Any ideas of a script to repair the crashed table on detection?

EDIT: It was INNODB table but it has never happened on InnoDB tables on the same server.

sarettah · 09-15-2014, 10:35 AM

A couple of years ago I was having an issue with crashed tables. It took about 6 months for the host to find the issue (hardware issue of some sort).

I wrote myself a little monitor script that would go out periodically and do a check on each table and then if it was crashed it would do a repair of the table,

It wasn't real hard to put together.

I am not sure if I still have the code around or not right now.

.

Babaganoosh · 09-15-2014, 10:46 AM

Not sure if you have access to the MySQL log but if so, just create a script and run it via cron to parse the log for crashed tables.

Zeiss · 09-15-2014, 04:28 PM

Yea, I have access to everything. It is cisco cloud, quite good. Some server failed last week and had to be moved to other blades. Maybe it is then it happened and I never saw it.

Quote:

create a script and run it via cron to parse the log for crashed tables

and then to notify and repair

Matt 26z · 09-15-2014, 04:40 PM

What exactly happens to a table that has crashed?

Zeiss · 09-15-2014, 05:07 PM

Quote:

Originally Posted by Matt 26z

What exactly happens to a table that has crashed?

DATE TIME [ERROR] /path/to/mysqld: Table './data_base/tablename' is marked as crashed and should be repaired

woj · 09-16-2014, 04:47 AM

If you want a custom solution coded, icq: 33375924 or email me at woj#a#t#wojfun#.#c#om to discuss details

09-15-2014, 10:04 AM	#1
Zeiss Confirmed User Industry Role: Join Date: May 2012 Location: With your mom Posts: 5,189	Monitor MySQL servers for crashed tables? Is there something to monitor for crashed tables? I just found out one of my sites had a table crashed and had to be repaired. It was like this for about 3 days. Never happened before. How do I get notified about tables "marked as crashed", so I can repair them? Any ideas of a script to repair the crashed table on detection? EDIT: It was INNODB table but it has never happened on InnoDB tables on the same server. __________________ Adult Webmasters Guides Last edited by Zeiss; 09-15-2014 at 10:09 AM..

09-15-2014, 10:35 AM	#2
sarettah see you later, I'm gone Industry Role: Join Date: Oct 2002 Posts: 14,058	A couple of years ago I was having an issue with crashed tables. It took about 6 months for the host to find the issue (hardware issue of some sort). I wrote myself a little monitor script that would go out periodically and do a check on each table and then if it was crashed it would do a repair of the table, It wasn't real hard to put together. I am not sure if I still have the code around or not right now. . __________________ All cookies cleared!

09-15-2014, 10:46 AM	#3
Babaganoosh ♥♥♥ Likes Hugs ♥♥♥ Industry Role: Join Date: Nov 2001 Location: /home Posts: 15,841	Not sure if you have access to the MySQL log but if so, just create a script and run it via cron to parse the log for crashed tables. __________________ I like pie.

09-16-2014, 04:47 AM	#7
woj <&(©¿©)&> Industry Role: Join Date: Jul 2002 Location: Chicago Posts: 47,882	If you want a custom solution coded, icq: 33375924 or email me at woj#a#t#wojfun#.#c#om to discuss details __________________ Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000 Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager

09-15-2014, 04:40 PM	#5
Matt 26z So Fucking Banned Industry Role: Join Date: Apr 2002 Location: ¤ª"˜¨๑۩۞۩๑¨˜"ª¤ Posts: 18,481	What exactly happens to a table that has crashed?