Statistic database options
The
tab is for enabling/disabling engine encryption. Selecting a site enables the encryption options for the internal, error, and SMAT databases for that site. In earlier versions, these settings were on the Site Init tool.Configuration options are stored at the site level at $HCISITEDIR/siteSecurityInfo.
On the
tab is a read-only indication of whether the internal and error databases are encrypted.For the SMAT database, the
tab has a read-only Database Options panel. This displays the state of SMAT data encryption and where it is saved.Statistic Database tab
This table shows the available options on the
tab.Option | Description |
---|---|
Enables the settings to cycle the old statistic database file. Selecting this option enables:
This is saved to the |
|
When and are selected, the statistic history related options can be modified. |
|
Statistic Store Interval |
Configure an interval for update frequency, or use the default. The default interval is 15 minutes. |
Statistic Database Automatic Cycling Threshold |
Configure a threshold, or use the default. (40MB) |
Statistic Schema List in Database |
Select which statistics to store. |
Delete the oldest statistic database history file when history files' number exceeds xxfiles |
This is the maximum number of backed up statistic database files. This deletes the oldest statistic database history file when the number of history files exceeds the specified number. SMAT cycling is used to back up the files. This is saved to the |
Delete the oldest statistic database history file when history files' total size exceeds xx KB |
This is the maximum size in KB of the total backed up statistic database files. This deletes the oldest statistic database history file when the history file's total size exceed the specified number. This is saved to the |
Delete statistic database history file when it is older than xx days |
The maximum age in days to keep history statistic database files. This deletes the oldest statistic database history file when a history file's age exceeds the specified number. This is saved to the |
Statistic database History Location |
This saves the statistic database history outside of the site folder. This creates a link path, where you can write the actual location in which to save the SMAT history. The default value is null. When the value in the text field exceeds
number, this is saved to the
|
siteInfo file
The siteInfo file has a section that is for statistics that are exported to the database.
# Monitord statistics information exporting to external DB configuration:
# monitord4stats2db - exporting engine statistics information to db.
# 0 - disabled by default.
# 1 - enabled.
# monitord4stats2dbinterval - exporting frequency in seconds(15 minutes by default, 15 secs as min one).
# monitord4stats2dbschema - stats table list for exporting.
# monitord4stats2dbsizecycle - stats db file automatic cycling threshold(in KB),
# 0 - disable auto cycling
monitord4stats2db=0
monitord4stats2dbinterval=900
monitord4stats2dbschema=host,site,processes,threads,interthreads
monitord4stats2dbsizecycle=40960
StatsDB is a sqlite database instance file, located in the monitord directory under the site. For example: $HCISITEDIR/exec/hcimonitord/mdstatsdb.sdb.
StatsDB cycling is not on every restart, but is an option. The cycled StatsDB file is named with the timestamp YYYY-MM-DD_HH-mm-SS. For example $HCISITEDIR/exec/hcimonitord/statsdb.sdb.YYYY-MM-DD_HH-mm-SS.
The cyclestatsdb command is for manually cycling StatsDB. For example: D:\ >hcicmd -t d -c "cyclestatsdb".
Response is one of:
- cyclestatsdb {Stats DB cycled}
- cyclestatsdb {Statsdb files failed}
- cyclestyclestatsdb {Statsdb files failed}atsdb {Statsdb files is not enabled/supported}
Example
User 1 has defined a new lab interface and deployed it into a new site (lab2). User 1 also needs to enable encryption on SMAT Database. To do this:
- User 1 logs into the Server Administration tool and selects the Databases tab.
- From lab2 from the list. , User 1 selects the
- User 1 then selects for the Internal, Error, and SMAT databases for the lab2 selected site.
- User 1 also sets a custom password for each object.