[mythtv-users] MySQL recordedseek regularly getting corrupted

[Stuart Auchterlonie]

On 01/12/16 22:37, Jean-Yves Avenard wrote:
>> Seems to me that focusing on where /tmp is, is a waste of time. /tmp may be
>> an issue when trying to repair the corruption, but I think what you really
>> want is to prevent the corruption, right? If so, I would focus on the things
>> that changed when the corruption started to happen. Two things come to mind,
>> based on what you've told us:
>> 1) The SSD
>> 2) the btrfs file system
>> I would try replacing one of those and seeing if that fixes the problem.
> 
> I think you're right on both count.
> 
> The issue may be the SSD and/or the BTRFS file system.
> I found a fair number of errors on it.
> 
> I will upgrade to 16.04 as it includes a newer version of btrfs.
> 14.04 comes with 3.3, which isn't recommended to fix errors either :(

We really should move to innodb for our database tables.

Regards
Stuart