Unable to view table details of MySQL 5.7 in PMM server 2.33.0

Hi All,
I’m not able to view the table details of a MySQL 5.7 AWS RDS in PMM server 2.33.0. PMM server has been installed using a docker image.

However, table details are being viewed for MySQL 8.0 AWS RDS.

Any help would be appreciated.

Hi @bharat.nedungadi , welcome to the Percona Forums!

Could you share a screenshot of the table details dashboard showing which graphs are not populating?

Can you confirm you provided the same privileges in RDS 5.7 so that the mysqld_exporter is able to properly access data about your tables?

1 Like

Hi Michael,

The same privileges has been provided to both the Databases. Thanks for the response

2 Likes

@Michael_Coburn Any help would be appreciated.

2 Likes

Hi @bharat.nedungadi sorry for the delay responding

Can you share with us the logs from the PMM Server, i am curious if something is showing an error from the mysqld_exporter . You should be able to retrieve these logs by accessing the PMM settings page and downloading the logs.zip file.

1 Like

Hi @Michael_Coburn,

I’ve attached the the mysqld_exporter logs from the PMM server.
MYSQLD_EXPORTER ee8bb417-352e-48cc-b0d1-b10fa424179d.log (12.3 KB)

1 Like

Hi @Michael_Coburn ,
Were you able to find any possible reasons for the same?

1 Like

Hi @bharat.nedungadi my apologies for the delay
I reviewed your log but see no errors. I am not clear why PMM 2.33 cannot read table details from an AWS RDS 5.7 host. If I get a chance I will set up a test environment against RDS 5.7 and see if I can troubleshoot this

1 Like

Hi @Michael_Coburn ,

Thanks for the help, would be great if you could troubleshoot it.