If the Lighthouse database becomes overloaded with data, it can cause performance issues and delays in the Endpoint Security (HX) server. A full vacuum removes bloat from the database to address this performance issue. Use the CLI commands in this topic to perform a full vacuum on the Lighthouse database.
Administrator access
Go to CLI configuration mode:
hostname > enable hostname # configure terminal
Perform a full vacuum on the Lighthouse database:
hostname (config) # hx server db full-vacuumUse the optional
trackparameter to perform a full vacuum in the foreground. Use the optionalno-confirmparameter to perform a full vacuum without confirmation, for example, to automate a task.Confirm that you want to continue:
hostname (config) # yesVerify the status of the full vacuum:
hostname (config) # show hx server db full-vacuum status
Example
The following example shows how to perform a full vacuum on the server Lighthouse database, and how to verify the status of the full vacuum.
hostname (config) # hx server db full-vacuumThis will disable tasking and the web interface while being completed and run in
It will be re-enabled after completion.
Do you want to continue?.
Type 'yes' to confirm: yesBeginning Lighthouse DB vacuum in the background. See logs for output.
hostname (config) # show hx server db full-vacuum statusVacuum Status
Last Run Info
Start Date : 2021-03-02 17:23:29
End Date : 2021-03-02 17:23:33
Size before vacuum: 45 MB
Size after vacuum : 39 MB
State : vacuum is NOT running.