Hi,
Due to poor database design and heavy load, database tables get corrupted a
lot.
I want to monitor that process and once a table to get corrupted to repair
it on the fly and send email to the support team that table is corrupted and
reapired automatically including the hostaname, and mysql version info.
I think about a perl script in cron job that do this. Is that the correct
way ?. Any ideas which is better to the perl system call to myisamchk or
'REPAIR TABLE'...any ideas are appreciated ...
Peter