Housekeeping table
Jump to navigation
Jump to search
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