Not the answer you need?
Register and ask your own question!

Metric Data Archiving

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


  • MykolaMykola Percona Percona Staff Role
    Hi mldba,

    inside PMM exists two space eaters:
    • Prometheus database (data for graphs)
    • Query Analytics database (mysql)
    Periodic purge for both of them are configurable.
    • QUERIES_RETENTION in days for Query Analytics ("8" default value)
    • METRICS_RETENTION in hours for Prometheus database ("720h" default value)
    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 \
This discussion has been closed.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.