Documentation Home
MySQL Enterprise Monitor 8.0 Manual
Related Documentation Download this Manual
PDF (US Ltr) - 6.0Mb
PDF (A4) - 6.0Mb


15.4 Data Purge Behavior

Data Purge Behavior enables you to automatically remove old data from the repository according to a schedule. The default purge interval is 4 weeks. To purge data, change this setting by choosing from the drop-down list. Choosing 12 months, for example, removes all data that is older than a year

Figure 15.3 Data Purge Behavior

Content is described in the surrounding text.

Purging data permanently removes information from the repository. Events derived from that data are purged with the data.

Note

The purge functionality purges closed events and related data, only.

The purge process is started approximately once every day, or when the MySQL Enterprise Monitor User Interface is restarted. If you change the purge duration from a large timespan to a smaller one, the data is purged in increments of one hour, from oldest to newest, until the new data retention policy is met. This is done to reduce the load on the repository.

You can configure the data purge behavior in the following ways:

  • Remove Non-Aggregated Metric Data Older Than: configures the duration that the non-aggregated data collected from your monitored assets is retained. This includes all data collections, including CPU, memory and connections and activity statistics.

  • Remove Hourly Aggregated Metric Data Older Than: configures the duration that the hourly aggregated data collected from your monitored assets is retained. This includes all data collections, including CPU, memory and connections and activity statistics.

  • Remove Daily Aggregated Metric Data Older Than: configures the duration that the daily aggregated data collected from your monitored assets is retained. This includes all data collections, including CPU, memory and connections and activity statistics.

  • Remove Query Analyzer Data Older Than: configures the duration that the query analyzer statistics and information about individual queries is retained.

Notes for setting purge behavior:

  • Purging can be carried out manually by enabling innodb_file_per_table for the repository database and using an OPTIMIZE TABLE operation to reclaim space from deleted rows in the table.

  • If you change the purge value from a high value to a very low value, the space used by the purged data is not reclaimed from the InnoDB tablespaces. Do this by running OPTIMIZE TABLE on the MySQL tables for MySQL Enterprise Service Manager to reclaim the space from the purged rows.