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
