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

How to purge QAN data without docker

Hi I would like to use pmm in AWS to monitor our RDS MySQL service. I did setup a new ec2 server with the linked AMI from your Website. I updated PMM as it was outdated on image you referred. I also did test a bit with capturing metrics and query statistics from our aws mysql rds. But now I want to clear the data and I am struggeling. I found a command to purge the metrics data via pmm-admin purge mysql:metrics but nothing similar for QAN data. I also did google a bit and found that it is common to drop the data with setting retention option. docker run ... -e METRICS_RETENTION=192h ... percona/pmm-server:latest Thats fine so far, but as I have installed pmm via AWS image from the marketplace docker is missing on my environment. Is there a way to set this METRICS_RETENTION Option without docker. Or do you guys anyway recommend to install docker on ec2?​​​ Regards Fredy

Comments

  • Michael CoburnMichael Coburn Principal Architect, Percona Percona Staff Role
    Hi Frederic

    You're right, we don't have a supported method for deletion of data from Query Analytics. The default retention on this data set is 8 days - so waiting that time will automatically remove the records.

    If you're interested in a deeper exploration of how the purging is done for Query Analytics, I direct you to qan-purge-data which shows how we leverage pt-archiver. We purge against four tables:
    1. agent_log
    2. query_examples
    3. query_global_metrics
    4. query_class_metrics
    What you can do is change the variable INTERVAL to something less than 8 days and run the script again, or log into MySQL directly and truncate the tables listed above.

    https://github.com/percona/pmm-serve...purge-qan-data
Sign In or Register to comment.

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