[mythtv-users] Database internals

Gary Buhrmaster gary.buhrmaster at gmail.com
Sat Jan 4 18:00:43 UTC 2014


On Sat, Jan 4, 2014 at 5:51 PM, Gary Buhrmaster
<gary.buhrmaster at gmail.com> wrote:
> On Sat, Jan 4, 2014 at 5:42 PM, Paul Gardiner <lists at glidos.net> wrote:
>> ... Maybe I've misunderstood what you are
>> saying.
>
> Nope, sounds like you got it.

One additional point.  At least some of the background
jobs run by the backend clean up rows in some
related tables.  So, in some case, the database will
"self correct".  However, there are some related tables
where the only real fix would be "delete all ... from all
systems".  Again, only in worst case, but worst case
also includes running out of space on the partition that
contains you DB (often /var).  MySQL does not always
deal well with running out of disk space, leaving the DB
in "interesting" conditions.


More information about the mythtv-users mailing list