InnoDB stats missing in MariaDB 10.6
Description
How to test
How to document
Attachments
Smart Checklist
Activity
Aaditya Dubey April 6, 2022 at 3:15 PM
Hi ,
Thank you for the report and patch.
As i can see request is already acknowledged and it will be processed as per the schedule.
Tomas Aravan February 18, 2022 at 12:25 AM
Created pull request - https://github.com/percona/mysqld_exporter/pull/92
Please merge ASAP.
Tomas Aravan February 18, 2022 at 12:17 AM
So the solution seems to be to port
https://github.com/prometheus/mysqld_exporter/commit/662d1a17f7f33b70286ab3a35b6f8a045dad0e7c
to
Tomas Aravan February 17, 2022 at 11:16 PM
Seems MariaDB 10.6 has a bit different schema of INFORMATION_SCHEMA.INNODB_METRICS
10.4:
10.6
Tomas Aravan February 17, 2022 at 11:10 PM
The newly upgraded server is replice. The master which runs MariaDB 10.4 works without issues with same pmm server and pmm2-client packages (exporters)
Details
Details
Assignee
Reporter
Tomas AravanPriority
HighComponents
Needs QA
Needs Doc
Affects versions
Environment
OS: Centos 7
PMM server 2.26.0 running in docker
MariaDB is 10.6.7
PMM2-Client package:
pmm-agent --version
ProjectName: pmm-agent
Version: 2.26.0
PMMVersion: 2.26.0
Timestamp: 2022-02-03 14:03:52 (UTC)
FullCommit: c74f5ae58331dc29af34d29c2b6905b8f47cc3ab
Smart Checklist
Open Smart Checklist
Smart Checklist
I have updated MariaDB from 10.4.13 to 10.6.7 and lot of innodb stats are missing.
I have done
SET GLOBAL innodb_monitor_enable=all;
I have also enabled usererstat. Most of the fields are blank, but some are fetched correctly. See screenshot