[mythtv-users] mysql filling up hard drive

[Bill Meek]

On 05/07/2015 05:14 PM, Scott Moncrieff wrote:
> Something disastrous seems to have happened to my Mythtv backend.
>
> I got a low disk space warning pop up and the computer became unresponsive.
> I powered off and rebooted and it happened again so next time I opened the
> system monitor and watched the hard drive fill up from 23% full up to 99%
> in the space of 5 minutes then jump back down to 23% and start again and it
> keeps cycling round like this.
>
> The process writing to the disk is mysqld - usr/sbin/mysqld
>
> I managed to use backup and restore in the Mythbuntu Control centre to
> backup to a flash drive. I then restored a clonzilla backup of the system
> from 6 months ago and it runs ok until I restore the database backup and
> then the hard drive starts filling up again.
>
> Any idea what may be happening or how to trouble shoot it? The drive is
> filling up very quickly (128gb SSD) and the system becomes unresponsive so
> it I only have a minute or so to do anything after re booting.
>

Hi,

After rebooting, stop the backend and then stop mysql. If mysql is the
culprit, that will give you time to investigate.

Maybe just stopping the BE would be enough. You get to try that.

I'd start in /var/log/mysql/error.log. You could also look in
/var/lib/mysql/mythconverg. The biggest file in mine is:

     recordedseek.MYI @ 100M

Your DB could be stored elsewhere, and the problem could be in non-
mythconverg files under .../mysql too, but that's a start.

You could restart mysql and the BE and tail mythbackend.log. Then,
in another window type: mythbackend --setverbose database and watch
the fun in the 1st window for a possible reason to what is being
written to the DB. I'd do this as a last resort.

-- 
Bill