Statistic database options

The Server Administration > Databases 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 IDE > Options > Site Preferences > Internal/Error Database tab is a read-only indication of whether the internal and error databases are encrypted.

For the SMAT database, the Site Preferences > SMAT tab has a read-only Database Options panel. This displays the state of SMAT data encryption and where it is saved.

Note: The Statistic database supports a cycle similar to SMAT.

Statistic Database tab

This table shows the available options on the Site Preferences > Statistic Database tab.

Note: When the Site Documentation is generated, the Statistic History settings display when Store runtime statistics into database and Enable statistic database history are both checked.
Option Description
Enable statistic database history

Enables the settings to cycle the old statistic database file. Selecting this option enables:

  • Delete the oldest statistic database history file when history files' number exceeds xxfiles
  • Delete the oldest statistic database history file when history files' total size exceeds xx KB
  • Delete statistic database history file when it is older than xx days
  • Statistic database History Location

This is saved to the siteInfo key monitord4stats2dbhistoryenabled.

Store runtime statistics into database

When Enable statistic database history and Store runtime statistics into database 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 siteInfo key monitord4stats2dbhistorymaxfiles.

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 siteInfo key. monitord4stats2dbhistorymaxdiskuse.

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 siteInfo key monitord4stats2dbhistorymaxage.

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 key monitord4stats2dbhistorylinkpath.

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:

  1. User 1 logs into the Server Administration tool and selects the Databases tab.
  2. From Site, User 1 selects the lab2 from the list.
  3. User 1 then selects Enable for the Internal, Error, and SMAT databases for the lab2 selected site.
  4. User 1 also sets a custom password for each object.