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 ------------------------------------+