Crashed Table - How to report/prevent?

Good day MySQL!

I had a table that crashed last night. There is a cron function that
goes out every 6 hours or so, that does a quick table backup (it's also
replicated, it's just something that we have running now). ANYWAY, I
think it crashed early in the evening, but when the backup ran, it looks
like it marked it as crashed finally (which was about 4 hours later).

The table was able to be read up until then, but it looks like it wasn't
able to be written too.

What I want to know is, is there a quick and easy way to maybe every few
hours, check to see if there are any crashed tables or whatnot?

This is only the 2nd time in the last 1 1/2 years. the table that
crashed, is a table that gets created every month, and is about 5gig in
size at the end of the month (it has a lot of records/fields in it which
is why i create a new one every month).

I could write a quick routine that goes and 'shows' the tables, and if
it fails, then repair it (or report it back to me via email or
something).


Any ideas on a way to automate something that is efficient and quick?

Steve



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Crashed Table - How to report/prevent?

Why not use the mysql tool, mysqlcheck:

http://dev.mysql.com/doc/refman/5.1/en/mysqlcheck.html





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Crashed Table - How to report/prevent?

>From what I read, it puts a lock on the tables (read lock). the tables
in one of the databases are continuously being written/read/updated, so
I dont want to lock them if at all possible.

Are there any other ways?

Steve

On Mon, 2010-09-13 at 15:11 +0100, a.smith@ukgrid.net wrote:
> Why not use the mysql tool, mysqlcheck:
>
> http://dev.mysql.com/doc/refman/5.1/en/mysqlcheck.html
>
>
>
>
>



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Crashed Table - How to report/prevent?

--0022152d6729780b7004903119bd
Content-Type: text/plain; charset=ISO-8859-1

On Mon, Sep 13, 2010 at 4:32 PM, Steve Staples wrote:

> >From what I read, it puts a lock on the tables (read lock). the tables
> in one of the databases are continuously being written/read/updated, so
> I dont want to lock them if at all possible.
>
> Are there any other ways?
>


Well, given that you need to read the entire table to verify it's
integrity... Mysqlcheck does have a few options like --quick, but the check
isn't as thorough either then, obviously.

It seems strange to me, however, that the table wouldn't already have been
marked as crashed if it couldn't be written to - have you checked the
error.log ? Monitoring that may give you a faster indication.



>
> Steve
>
> On Mon, 2010-09-13 at 15:11 +0100, a.smith@ukgrid.net wrote:
> > Why not use the mysql tool, mysqlcheck:
> >
> > http://dev.mysql.com/doc/refman/5.1/en/mysqlcheck.html
> >
> >
> >
> >
> >
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=vegivamp@tuxera.be
>
>


--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--0022152d6729780b7004903119bd--

RE: Crashed Table - How to report/prevent?

SW5ub2RiIGRvZXNuJ3Qgc3VmZmVyIGZyb20gY29ycnVwdGlvbiBpc3N1ZXMg bmVhcmx5IGFzIG9m
dGVuIGFzIG15aXNhbSB0YWJsZXMsIGFuZCBpdCBpcyBhYmxlIHRvIHJlY292 ZXIgb24gaXRzIG93
biBpbiBtYW55IGNhc2VzIChjcmFzaCByZWNvdmVyeS4pICBJbiBteSBleHBl cmllbmNlLCBpZiBp
bm5vZGIgZG9lcyBnZXQgY29ycnVwdGVkLCBpdCdzIG1vc3Qgb2Z0ZW4gYmVj YXVzZSBvZiBoYXJk
d2FyZSBwcm9ibGVtcy4gWW91IGNvdWxkIGNvbnNpZGVyIHVzaW5nIGl0IGlu c3RlYWQuDQoNCi0t
LS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQpGcm9tOiBTdGV2ZSBTdGFwbGVz IFttYWlsdG86c3N0
YXBsZXNAbW5zaS5uZXRdDQpTZW50OiBNb25kYXksIFNlcHRlbWJlciAxMywg MjAxMCA3OjAzIEFN
DQpUbzogbXlzcWxAbGlzdHMubXlzcWwuY29tDQpTdWJqZWN0OiBDcmFzaGVk IFRhYmxlIC0gSG93
IHRvIHJlcG9ydC9wcmV2ZW50Pw0KDQpHb29kIGRheSBNeVNRTCENCg0KSSBo YWQgYSB0YWJsZSB0
aGF0IGNyYXNoZWQgbGFzdCBuaWdodC4gIFRoZXJlIGlzIGEgY3JvbiBmdW5j dGlvbiB0aGF0DQpn
b2VzIG91dCBldmVyeSA2IGhvdXJzIG9yIHNvLCB0aGF0IGRvZXMgYSBxdWlj ayB0YWJsZSBiYWNr
dXAgKGl0J3MgYWxzbw0KcmVwbGljYXRlZCwgaXQncyBqdXN0IHNvbWV0aGlu ZyB0aGF0IHdlIGhh
dmUgcnVubmluZyBub3cpLiAgIEFOWVdBWSwgSQ0KdGhpbmsgaXQgY3Jhc2hl ZCBlYXJseSBpbiB0
aGUgZXZlbmluZywgYnV0IHdoZW4gdGhlIGJhY2t1cCByYW4sIGl0IGxvb2tz DQpsaWtlIGl0IG1h
cmtlZCBpdCBhcyBjcmFzaGVkIGZpbmFsbHkgKHdoaWNoIHdhcyBhYm91dCA0 IGhvdXJzIGxhdGVy
KS4NCg0KVGhlIHRhYmxlIHdhcyBhYmxlIHRvIGJlIHJlYWQgdXAgdW50aWwg dGhlbiwgYnV0IGl0
IGxvb2tzIGxpa2UgaXQgd2Fzbid0DQphYmxlIHRvIGJlIHdyaXR0ZW4gdG9v Lg0KDQpXaGF0IEkg
d2FudCB0byBrbm93IGlzLCBpcyB0aGVyZSBhIHF1aWNrIGFuZCBlYXN5IHdh eSB0byBtYXliZSBl
dmVyeSBmZXcNCmhvdXJzLCBjaGVjayB0byBzZWUgaWYgdGhlcmUgYXJlIGFu eSBjcmFzaGVkIHRh
YmxlcyBvciB3aGF0bm90Pw0KDQpUaGlzIGlzIG9ubHkgdGhlIDJuZCB0aW1l IGluIHRoZSBsYXN0
IDEgMS8yIHllYXJzLiAgdGhlIHRhYmxlIHRoYXQNCmNyYXNoZWQsIGlzIGEg dGFibGUgdGhhdCBn
ZXRzIGNyZWF0ZWQgZXZlcnkgbW9udGgsIGFuZCBpcyBhYm91dCA1Z2lnIGlu DQpzaXplIGF0IHRo
ZSBlbmQgb2YgdGhlIG1vbnRoIChpdCBoYXMgYSBsb3Qgb2YgcmVjb3Jkcy9m aWVsZHMgaW4gaXQg
d2hpY2gNCmlzIHdoeSBpIGNyZWF0ZSBhIG5ldyBvbmUgZXZlcnkgbW9udGgp Lg0KDQpJIGNvdWxk
IHdyaXRlIGEgcXVpY2sgcm91dGluZSB0aGF0IGdvZXMgYW5kICdzaG93cycg dGhlIHRhYmxlcywg
YW5kIGlmDQppdCBmYWlscywgdGhlbiByZXBhaXIgaXQgKG9yIHJlcG9ydCBp dCBiYWNrIHRvIG1l
IHZpYSBlbWFpbCBvcg0Kc29tZXRoaW5nKS4NCg0KDQpBbnkgaWRlYXMgb24g YSB3YXkgdG8gYXV0
b21hdGUgc29tZXRoaW5nIHRoYXQgaXMgZWZmaWNpZW50IGFuZCBxdWljaz8N Cg0KU3RldmUNCg0K
DQoNCi0tDQpNeVNRTCBHZW5lcmFsIE1haWxpbmcgTGlzdA0KRm9yIGxpc3Qg YXJjaGl2ZXM6IGh0
dHA6Ly9saXN0cy5teXNxbC5jb20vbXlzcWwNClRvIHVuc3Vic2NyaWJlOiAg ICBodHRwOi8vbGlz
dHMubXlzcWwuY29tL215c3FsP3Vuc3ViPWd0b3dleUBmZm4uY29tDQoNCg0K VGhpcyBtZXNzYWdl
IGNvbnRhaW5zIGNvbmZpZGVudGlhbCBpbmZvcm1hdGlvbiBhbmQgaXMgaW50 ZW5kZWQgb25seSBm
b3IgdGhlIGluZGl2aWR1YWwgbmFtZWQuICBJZiB5b3UgYXJlIG5vdCB0aGUg bmFtZWQgYWRkcmVz
c2VlLCB5b3UgYXJlIG5vdGlmaWVkIHRoYXQgcmV2aWV3aW5nLCBkaXNzZW1p bmF0aW5nLCBkaXNj
bG9zaW5nLCBjb3B5aW5nIG9yIGRpc3RyaWJ1dGluZyB0aGlzIGUtbWFpbCBp cyBzdHJpY3RseSBw
cm9oaWJpdGVkLiAgUGxlYXNlIG5vdGlmeSB0aGUgc2VuZGVyIGltbWVkaWF0 ZWx5IGJ5IGUtbWFp
bCBpZiB5b3UgaGF2ZSByZWNlaXZlZCB0aGlzIGUtbWFpbCBieSBtaXN0YWtl IGFuZCBkZWxldGUg
dGhpcyBlLW1haWwgZnJvbSB5b3VyIHN5c3RlbS4gRS1tYWlsIHRyYW5zbWlz c2lvbiBjYW5ub3Qg
YmUgZ3VhcmFudGVlZCB0byBiZSBzZWN1cmUgb3IgZXJyb3ItZnJlZSBhcyBp bmZvcm1hdGlvbiBj
b3VsZCBiZSBpbnRlcmNlcHRlZCwgY29ycnVwdGVkLCBsb3N0LCBkZXN0cm95 ZWQsIGFycml2ZSBs
YXRlIG9yIGluY29tcGxldGUsIG9yIGNvbnRhaW4gdmlydXNlcy4gVGhlIHNl bmRlciB0aGVyZWZv
cmUgZG9lcyBub3QgYWNjZXB0IGxpYWJpbGl0eSBmb3IgYW55IGxvc3Mgb3Ig ZGFtYWdlIGNhdXNl
ZCBieSB2aXJ1c2VzIG9yIGVycm9ycyBvciBvbWlzc2lvbnMgaW4gdGhlIGNv bnRlbnRzIG9mIHRo
aXMgbWVzc2FnZSwgd2hpY2ggYXJpc2UgYXMgYSByZXN1bHQgb2YgZS1tYWls IHRyYW5zbWlzc2lv
bi4gW0ZyaWVuZEZpbmRlciBOZXR3b3JrcywgSW5jLiwgMjIwIEh1bWJvbHQg Y291cnQsIFN1bm55
dmFsZSwgQ0EgOTQwODksIFVTQSwgRnJpZW5kRmluZGVyLmNvbQ0K