MySQL Enterprise Monitor 4.0 Release Notes
Data Purge Behaviorenables you to automatically remove old data from the repository according to a schedule. The default purge interval is4周. To purge data, change this setting by choosing from the drop-down list. Choosing12 months, for example, removes all data that is older than a year
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:
雷莫ve 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.
雷莫ve Hourly Aggregated Metric Data Older Than:配置持续时间每小时的总成件ed data collected from your monitored assets is retained. This includes all data collections, including CPU, memory and connections and activity statistics.
雷莫ve 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.
雷莫ve 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_tablefor the repository database and using anOPTIMIZE TABLEoperation 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 TABLEon the MySQL tables for MySQL Enterprise Service Manager to reclaim the space from the purged rows.