MySQL Questions chart had wrong values on the MySQL Overview dashboard

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 (builder@kbuilder.dev.centos.org) (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
[COLOR=#FF0000]7416455376 @1581027094.465
[COLOR=#FF0000]7416455333 @1581027099.465
7416455356 @1581027104.465
7416455389 @1581027109.465

what should I do,Any advice would be greatly appreciated…
Thank you

How are you judging what is ‘normal’? What are you comparing the Questions chart to?

1 Like

Thank you for your answer

I think my problem is the same as him, it is a MySQL bug,Our MySQL version is 5.7.14

https://bugs.mysql.com/bug.php?id=90351

1 Like