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

[Jim Abernathy]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20180113/0ed944db/attachment.html>