[PMM 3] How to configure different retention periods for QAN (30 days) and Metrics (6 months)?

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

Hello,

I am using PMM 3 and my QAN data is generating a very large volume, which is causing disk space issues.

I need to configure different retention periods for my data:

  1. QAN Data (Query Analytics): I only need to keep this for 30 days.

  2. Metrics Data (Node/System load, etc.): I need to keep this for at least 6 months (e.g., 180 days).

2

Hello @frank.pan,
Having different retention periods is not supported at this time. You can manually delete data out of QAN by shell’ing into the pmm docker container, accessing the clickhouse db, and simply executing a DELETE sql.

1 Like