Metric Data Archiving

Percona Monitoring and Management (PMM) PMM 1.x
1

Are there any tool(s)/scripts to archive historical data from PMM to avoid having the data store grow and grow and grow?

2

Hi mldba,

inside PMM exists two space eaters:
[LIST]
[]Prometheus database (data for graphs)
[]Query Analytics database (mysql)
[/LIST] Periodic purge for both of them are configurable.
[LIST]
[]QUERIES_RETENTION in days for Query Analytics (“8” default value)
[]METRICS_RETENTION in hours for Prometheus database (“720h” default value)
[/LIST] please use the following command for set them


docker run -d \
-p 80:80 \
--volumes-from pmm-data \
--name pmm-server \
--restart always \
-e METRICS_RETENTION=360h \
-e QUERIES_RETENTION=4 \
percona/pmm-server:1.0.7