How do you clean up the InControl server database?

Last modified on 9 Apr, 2021. Revision 11
Is it possible to clean-up the InControl server database?
Up to date for
InControl 2.33.00
Supported since
InControl 1.20
Status OK

Question:

How can the InControl server database be cleaned up and also have its size on disk reduced?

Answer:

The InControl database contains configuration history, domains etc. Over time, the database will grow following configuration check-ins and other operations.

Automatic cleanup of the database can be enabled by opening the “InControl Server Settings” interface, selecting “Database” and enabling the “AutoCleanDatabase” option. This will cause an automatic database cleanup to occur when the server is started and then periodically during operation.

In addition, the following cleanup options can be set:

  • MaximumDaysToKeepConfiguration

This will remove any configurations older than the specified number of days during cleanup.

  • MinimumConfigurationsToKeep

When a cleanup runs, if there are more than this number of configurations in the history for a given firewall then the excess will be deleted for that firewall.

Important note about reducing disk usage:

If you enable the automatic cleanup function, it will clean up the database but its size on disk will not be reduced unless the "VacuumDatabase" option is also enabled. This option will also compact the database to its smallest size on disk during both startup and automatic clean-up. However, this option should be used with caution because it will require time for the database to be rebuilt during which the InControl server may not be able to process incoming traffic.

All the server options covered in this article are described in more depth in the separate “InControl Administration Guide” publication.

Related articles

How to disable IP Reputation in cOS Core
21 Mar, 2023 core ipreputation log
Where to find logs related to the InControl server, client, ILA or Log receiver
14 Dec, 2022 incontrol ida log
HA: disallowed_on_sync_iface log events with rule=HA_RestrictSyncIf for Reverse ARP, RARP, and IGMP
23 Aug, 2022 vmware log ha rarp arp core
Where to find logs to the OneConnect client for MacOS
27 Oct, 2022 oneconnect log
The TCP Window Scale Log Event
15 Nov, 2022 tcp log core
Details about the cOS Core WebUI memory log (memlog)
27 Mar, 2023 core log webui memlog
Automatically stop active PCAPdump or Logsnoop in the CLI
7 Dec, 2022 pcapdump log cli core logsnoop
Why some log category ID's are missing
23 May, 2022 core log logreceiver
PuTTY to local console connection using a pipe with cOS Core under Hyper-V
19 Apr, 2023 core hyperv serial console log
The meaning of the Default_Access_Rule log entry
7 Nov, 2022 core arp log routing
How to optimize InControl Log File storage
17 Feb, 2021 incontrol log
Erroneous bandwidth output when making Log Analyzer queries with set time interval
5 Feb, 2021 incontrol log



Tagsincontrol