Difference between revisions of "Housekeeping table"

From MythTV Official Wiki
Jump to: navigation, search
(Added to Category:DB Table)
m (Updated the page introduction)
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
The '''housekeeping table''' lists housekeeping events (cleanup and recovery tasks) and the time at which they were last performed.
+
{{Wrongtitle|housekeeping table}}
 +
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 ==
 +
{| border="1" cellspacing="0" cellpadding="5" style="border-collapse:collapse; border-color:#8eabd0; background:#e7edf5"
 +
|- style="background: lightsteelblue"
 +
!  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 ==
 +
<pre>
 +
    tag: JobQueueCleanup
 +
lastrun: 2006-10-11 11:10:14
 +
</pre>
 +
<pre>
 +
    tag: InUseProgramsCleanup
 +
lastrun: 2006-10-11 11:05:14
 +
</pre>
 +
<pre>
 +
    tag: JobQueueRecover-localhost.localdomain
 +
lastrun: 2007-03-12 09:36:17
 +
</pre>
 +
<pre>
 +
    tag: MythFillDB
 +
lastrun: 2007-03-12 18:40:58
 +
</pre>
 +
<pre>
 +
    tag: DailyCleanup
 +
lastrun: 2007-03-12 09:36:17
 +
</pre>
 +
<pre>
 +
        tag: ThemeUpdateNotifications
 +
  hostname: NULL
 +
    lastrun: 2019-01-24 06:27:15
 +
lastsuccess: 2019-01-24 06:27:15
 +
</pre>
 +
<pre>
 +
        tag: DBCleanup
 +
  hostname: NULL
 +
    lastrun: 2019-01-23 18:38:22
 +
lastsuccess: 2019-01-23 18:38:22
 +
</pre>
 +
<pre>
 +
        tag: HardwareProfiler
 +
  hostname: <backend device>
 +
    lastrun: 2019-01-03 00:07:52
 +
lastsuccess: 2018-12-04 18:28:38
 +
</pre>
 +
 
 
[[Category:DB Table]]
 
[[Category:DB Table]]

Latest revision as of 07:30, 24 January 2019

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