I am monitoring for a percona mysql cluster with pmm, but I have been seeing data with a delay of approximately 15 minutes on pmm dashboards for 2 weeks. I would like your information about the cause and solution of this.
Hmm. Because it is lagging exactly 15m, I suspect this is a timezone/config issue. Can you check the time on your server, both OS (date) and MySQL (SELECT NOW();) and also check the timezone setting in PMM (click last 5 min menu and at the bottom is a timezone selector).
Hello, I checked the time zone configuration. There doesn’t seem to be a problem, only the time zone of the pmm server was 3 hours behind, I fixed it, but nothing changed. Finally, I rebooted the pmm server. There is no such thing as 15 minutes behind time sometimes it is 11 minutes behind.
I can’t see the last 5 minutes data at all, some of the metrics are already seen as nodata.
Have you examined the logs of PMM server? You need to exec into the docker container and look through all the logs to see if there are any errors. Also, check the logs of the pmm-client on the mysql server.