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

How to clear data in PMM

aleksey.filippovaleksey.filippov ContributorCurrent User Role Beginner
I have separated AWS instance for PMM, CentOS 7, BTRFS

[[email protected] ~]# docker version
Client:
Version: 17.03.1-ce
API version: 1.27
Go version: go1.7.5
Git commit: c6d412e
Built: Mon Mar 27 17:05:44 2017
OS/Arch: linux/amd64

Server:
Version: 17.03.1-ce
API version: 1.27 (minimum version 1.12)
Go version: go1.7.5
Git commit: c6d412e
Built: Mon Mar 27 17:05:44 2017
OS/Arch: linux/amd64
Experimental: false

/var/lib/docker is a simlink to /data/docker

[[email protected] ~]# ls -l /var/lib | grep docker
lrwxrwxrwx. 1 root root 12 Апр 25 10:05 docker -> /data/docker
[
/data/ mountpoint 50G size

[[email protected] ~]# df -hl | grep data | grep dev
/dev/xvdb1 50G 3,4G 47G 7% /data

In official documentation about space requirement for PMM we can see:

3.3.2 What are the minimum system requirements for PMM?
• PMM Server
Any system which can run Docker version 1.12.6 or later.
It needs roughly 1 GB of storage for each monitored database node with data retention set to one week.
Minimum memory is 2 GB for one monitored database node, but it is not linear when you increase more nodes.
For example, data from 20 nodes should be easily handled with 16 GB.

For now i have 5 MySQL instances in PMM, and yesterday all space was eaten by PMM docker.
Because i was sure, that 50Gb enough for me, i do not monitored free space, but i do it now.
I reinstalled all from 0 yesterday, for now i have this statistics:

docker exec -it pmm-server bash

[[email protected] opt]# date
Wed May 3 11:05:21 EEST 2017
[[email protected] opt]# du -hs /var/lib/mysql
151M /var/lib/mysql
[[email protected] opt]# du -hs /opt/prometheus/
1.6G /opt/prometheus/

[[email protected] opt]# date
Wed May 3 11:46:33 EEST 2017
[[email protected] opt]du -hs /var/lib/mysql
156M /var/lib/mysql
[[email protected] opt]du -hs /opt/prometheus/
1.6G /opt/prometheus/

[[email protected] opt]# date
Wed May 3 15:37:06 EEST 2017
[[email protected] opt]# du -hs /var/lib/mysql
176M /var/lib/mysql
[[email protected] opt]# du -hs /opt/prometheus/
2.0G /opt/prometheus/

We have next situation:
DB size increased for 25M in 4h 30m
Prometheus size increased for 400M in 4h 30m

In 24 hour it will be about 2.5Gb, so 50Gb will end in 20 days.
According to official documentation, it must not happent, because data rotate in 7 day cicle.
But in my situation something go wrong.

I need to understand, how to fix this problem.

Comments

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.