Good afternoon... I had a huge issue this weekend, we had a table crash (again), it is a high usage table, where there are MANY writes, and reads from it all the time (it is a radius accounting table). the problem is, is that i did: check table radius.radacct201010 quick and it came back fine... i did it for radacct201009 and it was fine too (takes about 1-2 minutes each query to finish).
So, I was wondering what was going on, and I did a check table from my sql yog, and selected all the tables (oops), and 2 1/2 hrs later, it wasn't finished. In the mean time, my boss has a script that does a dump of some of the other tables on the sql server (not any of these tables), but at that time, it somehow crashed 2 tables, and corrupted another. It only happened that I was in on sunday (or i would not have known about this until this morning) and I caught and corrected this, but my question is, is how can i prevent this, in the event that I am not in on the weekends?? can i run the mysqlcheck -AF -uUSER -pPASS, and will the 'fast' check return back if a table is corrupt, or crashed, or has a problem? then if so, I can either get an email, or automate a repair table {tablename} quick; ? the quick repair has alsways worked for me, and it takes like 20minutes, to 1hr+ to repair the tables, but should I do somethign different? if i can run the mysqlcheck -AF say daily, and it would pick up any issues that would be great... any ideas/thoughts would be welcomed. Thanks Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org