Percona MySQL InnoDB Storage Summary

Percona Monitoring and Management (PMM) PMM 2.x
, ,
1

Description:

I’m having trouble displaying InnoDB Storage Summary.

Steps to Reproduce:

MySQL > InnoDB Details > InnoDB Storage Summary

Additional Information:

The necessary settings are already enabled, only the InnoDB Storage Summary menu does not display the information, I use MySQL RDS AWS.

Is there any other setting that I forgot to enable?

performance_schema ON
SET GLOBAL innodb_monitor_enable = all;
GRANT SELECT, RELOAD, PROCESS, SHOW DATABASES, REPLICATION CLIENT ON . TO pmm@%

size
size2448×848 135 KB

##Version:
ProjectName: pmm-managed
Version: 2.42.0
PMMVersion: 2.42.0

2

Hello @adamrodrigues98,
When the innodb monitors are enabled, this table information_schema.innodb_metrics is populated with data and scrapped by PMM. Check this table has data in your RDS instance.

3

Hello

Yes, there is data in this table.

4

Hmm. That’s the table which the exporter scans for data

Can you check the PMM agent error logs? The logs would be on the PMM server since the agent is running there for RDS.

5

I found some logs similar to this one.

I’ll check if it’s permission, if it is I’ll let you know the resolution here.

time=“2024-11-07T12:33:29.755+00:00” level=error msg=“ts=2024-11-07T12:33:29.755Z caller=scraper.go:145 level=error component=enhanced msg="Failed to filter log events." error="AccessDeniedException: User: arn:aws:iam::971441073540:user/monitoramento-mysql is not authorized to perform: logs:FilterLogEvents on resource: arn:aws:logs:us-east-1:971441073540:log-group:RDSOSMetrics:log-stream: because no identity-based policy allows the logs:FilterLogEvents action\n\tstatus code: 400, request id: 69a813ab-c859-4a22-b13b-880ee0c8dc7f"” agentID=pmm-server/rds component=agent-process type=rds_exporter