[mythtv-users] controlling disk space on "/" on mythtv backend

[Stephen Worthington]

On Sat, 13 Jan 2018 12:28:18 +0000, you wrote:

>
>Whenever you manage to have / run out of space, you should always make
>sure you run:
>
>/usr/share/doc/mythtv-backend/contrib/maintenance/optimize_mythdb.pl
>
>to repair and optimise the database before running mythbackend again,
>as the database may well have one or more tables crashed due to the
>lack of space.  Fortunately MySQL and MariaDB are very forgiving about
>what happens when the space runs out, so a simple repair normally
>fixes everything.  Unfortunately, mythbackend can appear to be running
>normally when tables are crashed, but it will in fact be unable to
>write to the crashed tables.  There will normally be log messages
>about SQL problems, but mythbackend will not otherwise notify you that
>it has a problem.
>
>
>Is the optimize_mythdb.pl script something that should be run regularly??
>
>Jim A

Absolutely - run it daily.  If you do not regularly do a check and
repair on mysql databases, you risk losing your tables to corruption.
The way it seem to work is that if there is a simple problem with a
table, the check and repair process can just fix it for you, with no
loss of data.  But if a problem remains unfixed, and another problem
happens, that can then make the table unrepairable.