Re: MySQL maintenance

On 28 Jun 2014, at 10:00 am, [email protected] wrote:

> 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

I use mysql for (amongst others) mythtv. I note that on a power fail 3 times out of 4 mysql is FOOBAR.

This sorts corrupt tables, but how why ? etc on ext4 drives

mysqlcheck --auto-repair --check -u mythtv -pmythtv mythconverg

or

mysqlcheck --auto-repair -A -u mythtv -pmythtv mythconverg

perhaps (match to your distro) in rc.local

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