This component performs periodic maintenance on the data archive. This includes removing unused references and optimizing the database backend. This maintenance can take a very long time, so it is not recommended to do interactively.

Usage

da.maintenance.archive [switches…​]

Switches

--cleanup-stale[=BOOLEAN]

When enabled, the maintenance will release all stale locks in the archive.

Default: Enabled

--optimize-database[=BOOLEAN]

When enabled, the maintenance will perform automated optimization and cleaning of the SQL database backend.

--quiet[=BOOLEAN]

If set then no progress output is displayed and any confirmation prompts are bypassed.

Default: Disabled

--recompress[=BOOLEAN]

When enabled, the maintenance will recompress any data that has not been modified for some time using a higher compression algorithm. This reduces the total size of the database and speeds up access, but can take a very long time.

--recompress-age=INTERVALBLOCK

This sets the minimum age of data to recompress. Data that has not been modified for this long will be recompressed.

Default: Six months

When no units are specified the interval is assumed to be in months.

--remove-unused[=BOOLEAN]

When enabled, the maintenance will remove unused references in in the archive.

--split-archive[=BOOLEAN]

This option causes the storage to be restructured so each archive is separated into a different table. Under some database backends, this allows for better concurrency at the small cost of more complicated initialization.

--split-station[=BOOLEAN]

This option causes the storage to be restructured so each station is separated into a different table. Under some database backends, this allows for better concurrency at the small cost of more complicated initialization.

--split-variable[=BOOLEAN]

This option causes the storage to be restructured so each variable is separated into a different table. Under some database backends, this allows for better concurrency at the small cost of more complicated initialization.

Examples

Remove unused references

This will remove all unused references in the database backend.

da.maintenance.archive --remove-unused