Historic Data Utility Command Reference
The Historic Data utility moog_db_split_enabler
is a command line utility
to:
-
Enable and disable the retention of historic data in a separate database.
-
Configure the retention of historic data.
The utility is located at $MOOGSOFT_HOME/bin/utils
.
See Configure Historic Data Retention for more information.
Moogsoft AIOps v7.3.1.5 Update
Moogsoft AIOps v7.3.1.5 adds a flag to configure the number of days to keep the splitter process logs before deleting them.. For example, to set the aged logs period to 30 days:
moog_db_split_enabler --enable --aged_logs_period 30
Usage
moog_db_split_enabler [ --alerts_batch_size <number of alerts> ] [ --disable ] [ --enable ] [ --grace_period <number of seconds> ] [ --loglevel INFO|WARN|DEBUG|TRACE ] [ --database_name <name> ] [ --password <password> ] [ --run_interval <number of seconds> ] [ --sigs_batch_size <number of situations> ] [ --user <username> ] --help
Argument |
Input |
Description |
---|---|---|
|
Integer |
Number of alerts per batch when moving data to the historic database. Increasing this value can speed up the process but places more load on the database. Default is 2000. |
|
- |
Disable the retention of historic data in a separate database. The data in the old historic database is not moved to the active database and becomes effectively inaccessible. |
|
- |
Enable the retention of historic data in a separate database. |
|
Integer |
Period of time since the last update after which closed alerts and Situations are eligible to be included in historic data retention. Default is 3600 (one hour). |
|
String, one of |
Log level controlling the amount of information logged by the utility. Default is INFO. |
|
String |
The name of the historic database. Default is historic_moogdb. |
|
String |
Password for the MySQL user specified in the |
|
Integer |
The number of seconds to wait between database split intervals. Default is 600. |
|
Integer |
Number of Situations to include in each batch when moving data to the historic database. Default is 500. |
|
String |
MySQL user to run the utility. The user must have schema creation privileges. Default is root. |
|
Integer |
Avaliable in Moogsoft AIOps v7.3.1.5 and later. Number of days to retain the splitter process logs. Default is 90 days. |
|
- |
Display the utility options and syntax. |
Example
moog_db_split_enabler --enable --alerts_batch_size 1000 --loglevel INFO --run_interval 400 --sigs_batch_size 250 +-------------- DB split configurations -----------------------------+ Grace period: [3600] Alerts batch size: [1000] Situations batch size: [250] Run interval: [400] Historic database: [historic_moogdb] +-------------- DB split enabled ------------------------------------+