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
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.
Hi @Michael_Coburn ,
Any update on the above issue?