Housekeeping table

From MythTV Official Wiki
Jump to: navigation, search

Important.png Note: The correct title of this article is housekeeping table. It appears incorrectly here due to technical restrictions.

The housekeeping table lists housekeeping events and the time at which they were last performed and succeeded.

Some examples of the events recorded are database backups, cleanups, etc, as well as other events such as when the hardware profiler was run, logs cleaned, etc.

The hostname where the housekeeping took place is also recorded in some cases.

Table Description

Field name Type Null Key Default Extras
tag varchar(64) PRI NULL
hostname varchar(64) YES NULL
lastrun datetime YES NULL
lastsuccess datetime YES NULL

Example Entries

    tag: JobQueueCleanup
lastrun: 2006-10-11 11:10:14
    tag: InUseProgramsCleanup
lastrun: 2006-10-11 11:05:14
    tag: JobQueueRecover-localhost.localdomain
lastrun: 2007-03-12 09:36:17
    tag: MythFillDB
lastrun: 2007-03-12 18:40:58
    tag: DailyCleanup
lastrun: 2007-03-12 09:36:17
        tag: ThemeUpdateNotifications
   hostname: NULL
    lastrun: 2019-01-24 06:27:15
lastsuccess: 2019-01-24 06:27:15
        tag: DBCleanup
   hostname: NULL
    lastrun: 2019-01-23 18:38:22
lastsuccess: 2019-01-23 18:38:22
        tag: HardwareProfiler
   hostname: <backend device>
    lastrun: 2019-01-03 00:07:52
lastsuccess: 2018-12-04 18:28:38