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

MySQL Questions chart had wrong values on the MySQL Overview dashboard

fiendfiend EntrantCurrent User Role Contributor
Hi,
My environmental information is as follows:
./pmm-info.sh
QA PMM Info Script v0.10
==================== uname -a
Linux lgy-0927-149.11-dba.cn 3.10.0-862.el7.x86_64 #1 SMP Fri Apr 20 16:44:24 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
==================== /proc/version
Linux version 3.10.0-862.el7.x86_64 ([email protected]) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-28) (GCC) ) #1 SMP Fri Apr 20 16:44:24 UTC 2018
==================== OS Release (filtered cat /etc/*-release):
CentOS Linux release 7.5.1804 (Core)
HOME_URL="https://www.centos.org/"
ID="centos"
ID_LIKE="rhel fedora"
NAME="CentOS Linux"
PRETTY_NAME="CentOS Linux 7 (Core)"
VERSION="7 (Core)"
VERSION_ID="7"
==================== Docker release (docker --version):
Docker version 18.09.7, build 2d0083d
==================== SELinux status if present (sestatus):
SELinux status: disabled
==================== PMM server images (sudo docker images | grep pmm):
percona/pmm-server 1.17.2 cc8e60d34a15 3 months ago 1.2GB
percona/pmm-server 1.17.1 deac61541b67 11 months ago 1.08GB
==================== PMM server state (sudo docker ps -a | grep pmm):
3c7634d20213 percona/pmm-server:1.17.2 "/opt/entrypoint.sh" 3 weeks ago Up 3 weeks pmm-server
c308bd20230c percona/pmm-server:1.17.1 "/opt/entrypoint.sh" 4 weeks ago Exited (0) 3 weeks ago pmm-server-backup
183c93cb8427 percona/pmm-server:1.17.1 "/bin/true" 7 months ago Created pmm-data

Sometimes the value is very large, much higher than normal, please see the picture

Querying the data obtained by prometheus found that the value of the next timestamp will be smaller than the previous one:
mysql_global_status_questions{instance=~"49.43_3701_db-class_s"}[1m]
7416455280 @1581027089.465
7416455376 @1581027094.465
7416455333 @1581027099.465
7416455356 @1581027104.465
7416455389 @1581027109.465

what should I do,Any advice would be greatly appreciated..
Thank you
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.