Re: [SLUG] MySQL maintenance

2014-06-28 Thread Jeremy Visser
On 28 Jun 2014, at 18:45, Jake Anderson wrote: > I suggested to the myth devs that they change to innodb by default and was > basically laughed at This is pretty common, and pretty indicative of the MythTV developers’ attitude in general. I once suggested they support PulseAudio natively and I

Re: [SLUG] MySQL maintenance

2014-06-28 Thread Jake Anderson
On 28/06/14 14:45, James Linder wrote: 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-re

Re: [SLUG] MySQL maintenance

2014-06-28 Thread Darin McLean
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 wrote: > > On 28 Jun 2014, at 10:00 am, slug-requ...@slug.org.au wrote: > > > I've been using MySQL for CMS and mail like for ever, on physical servers > > and vm serve