question Re: How can we delete old data of Ambari Metric server? in Archives of Support Questions (Read Only)

How can we delete old data of Ambari Metric server?

prasad4u_com — Wed, 03 Feb 2016 02:38:44 GMT

We implemented ambari-metrics-collector in embedded mode. Now, it is taking more disk space under /hadoop/var/lib/ambari-metrics-collector/hbase/data/default. How can we delete prior data in the metrics collector? What are the precautions to be taken while deleting directories in the above location. Which directories need to be untouched? I saw Metric Aggregator took 2.8GB,Metric Record monitor took 1.4 GB.

Re: How can we delete old data of Ambari Metric server?

prasad4u_com — Wed, 03 Feb 2016 02:43:52 GMT

Is there any parameter to set auto delete old metrics based on time frame?

Re: How can we delete old data of Ambari Metric server?

aervits — Wed, 03 Feb 2016 02:45:20 GMT

@Ram D

recommendation is to migrate to distributed mode and then you can clean up old directories. There's also time to live properties you can find them here this is Hortonworks documentation for TTL settings.

Re: How can we delete old data of Ambari Metric server?

nsabharwal — Wed, 03 Feb 2016 02:46:50 GMT

@Ram D

See this https://cwiki.apache.org/confluence/display/AMBARI/Configuration

Metric Collector - ams-site - Configuration details

Modifying retention interval for time aggregated data. Refer to Aggregation section for more information on aggregation: API spec (Note: In Ambari 2.0 and 2.1, the Phoenix version does not support Alter TTL queries. So these can be modified from the UI, only at install time. Please refer to Known Issues section for workaround.)

Property	Default value	Description
timeline.metrics.host.aggregator.daily.ttl	31536000	Host based daily resolution data purge interval. Default is 1 year.
timeline.metrics.cluster.aggregator.minute.ttl	2592000	Cluster wide minute resolution data purge interval. Default is 30 days.
timeline.metrics.cluster.aggregator.hourly.ttl	31536000	Cluster wide hourly resolution data purge interval. Default is 1 year.
timeline.metrics.cluster.aggregator.daily.ttl	63072000	Cluster wide daily resolution data purge interval. Default is 2 years.

Re: How can we delete old data of Ambari Metric server?

prasad4u_com — Wed, 03 Feb 2016 03:03:44 GMT

What is the recommended value instead of 1 year for host and 1 year for cluster?