Re: MySQL maintenance

 Not sure of this case but I've seen some web hosts using non-ECC memory.

Darin


On Sat, Jun 28, 2014 at 2:45 PM, James Linder <[email protected]> wrote:

>
> 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
>
-- 
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html