[mythtv-users] MySQL recordedseek regularly getting corrupted

[Michael T. Dean]

On 11/30/2016 06:24 AM, Jean-Yves Avenard wrote:
> I had expected the disk to run out of space and replaced it 2 months 
> ago. It's a brand new SSD Samsung 850. It's 80% empty And always for 
> that file is it running out of space? Doesn't make much sense. I did 
> convert the original ext3 partition to btrfs (running ubuntu 14.04) 
> Sorry for top posting, the new gmail app doesn't let me respond in line.
>

Are you sure your MySQL temp directory is on the file system that has 
sufficient space?

https://dev.mysql.com/doc/refman/5.7/en/temporary-files.html

Also, note that things are handled differently with InnoDB versus MyISAM 
storage engines (as explained in the link, above).  Might want to check:

SHOW VARIABLES LIKE '%tmpdir%';

to see if that gives any hints as to what's happening.  Though if the 
temp file error was just myisamcheck , that may just be because you 
weren't in your MySQL data directory when you ran it?

Mike