System Health and Maintenance › Maintenance Tasks › Database Status and Usage

Database Status and Usage

The statistics on the Database Status page describe database status and usage. Use this information as a guide when selecting purge (File Retention) settings on the Application Settings page. The information in the Database Usage section is especially useful for determining when to purge older database entries containing metrics from 1-minute intervals.

The Database Status page provides the following information:

Database

The name of the local databases on the Multi-Port Monitor appliance.

Status

Status of a database: UP, DOWN, SHUTTING DOWN, or INITIALIZING.

Start/Stop

Links that let you start or stop a database. Stop a database before you shut down or restart the appliance.

Date of oldest data

The oldest time stamp of the data in a database.

Date of newest data

The most recent time stamp of the data in a database.

Rows in database

The total number of rows in the database that are in use. The maximum number of rows is 12 billion. If the maximum threshold is exceeded, the nightly maintenance routine prunes it to less than 12 billion.

Rows for past day

The number of database rows in use during the past 24 hours.

Rows for past 7 days

The number of database rows in use during the past week.

Tips:

• The Database Usage section provides a range of dates to show when the oldest and most recent data was inserted, and several database row counts. This information helps you gauge how quickly data is accumulating. Based on this information, you can adjust the number of days that information is kept in the database.
• To reduce the number of rows added to the database, adjust the filters that are applied to each logical port. For example, instead of using the default filter that captures all protocol traffic, you can capture only TCP packets.
• The status of the database is automatically updated every 60 seconds. The row counts are updated only when you navigate to the Database Status page or when you refresh the browser.
• Users who do not have the Administrator product permission can review the database status on the System Status page. All Multi-Port Monitor users can access the System Status page.

More information:

Set Global Preferences

Command Line Syntax

System Status

Using Hardware Filters to Manage Data