Does the database check and optimization run automatically?
Article ID: 381657
Updated On:
Products
Issue/Introduction
When encountered a problem related to the database, running the command cc-config database with --repair and --optimize parameters is likely to address the problem. Are there automated running tasks with the same command and parameters that run regularly? If yes, when are they executed? Do those tasks work as same as cc-config command?
Resolution
SMG uses the scheduled expunger tasks to do the automated database optimization, for example, Log Expunger, which purges older logs and prevents the database from exceeding the set limit. The following document shows how to trigger the schedule automated database optimization by doing scheduled expunger tasks:
Managing the log database size
As stated in the above document, when the Log Expunger runs, it deletes log entries in the log database. It does not compact the database.
To compact the database and decrease its size, Symantec Messaging Gateway runs an optimization process, e.g. execute sql commands like “optimize table” And “analyze table”. This process occurs automatically based on disk usage and does not need to be configured.
Additional Information
Feedback
