MySQL maintenance

I've been using MySQL for CMS and mail like for ever, on physical servers
and vm servers with no problems that I can recall, ever.

on the new vm, in use about 6 month, couple of weeks ago joomla cms went
down, traced to corrupt MySQL table, fixed with phpmyadmin, all good

yesterday noticed cacti not working / failed few weeks ago (perhaps at
similar time to joomla, need to check that), again, traced to corrupt
MySQL table

with two failures, getting a little concerned, need to look into some
regular/preventive maintenance? to detect failure at MySQL before results
of failure are realized ?

what do people do with MySQL in such terms ?
should I run mysqlcheck at regular basis?

thanks for pointers and suggestions

V

-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html