PMM instalation from AWS IAM
after add new aws rds instance ( pmm - pmm add instance ) they displayed in the home dashboard ( with all metrics ) but not added to PMM QA.
Can you assist ?
1 Like
also try to add with mysql - pmm user and aws rds db super-user = the result is the same
1 Like
Sorry for delay in replies (holidays!). Is this still an issue? It does typically take time for QAN data to start populating. Also after scanning AWS for instances and selecting the instance to add did you check the box (or it leave it checked) for “Use performance schema”?
1 Like
Hi Steve! thank you for reply
i tried different options and i got localize the problem.
If i add mysql-server (aws rds ( like rds or externalMysql) or mysql server via externalMysql = all works perfect
If i try tu add amazon aurora instance - the no to be avavible in tthe QAN
PMM server installed from AWS IAM and from Docker, same result.
1 Like
Hi @NazarD,
Could you check PMM Inventory page / Agents Tab?
Can you see QAN agent there and what is the status of QAN agent?
Thank you.
1 Like
Thank you @NazarD ,
Could you execute following query on Aurora instance and check if you have any value there?
Select * from performance_schema.events_statements_summary_by_digest
Also could you check logs of pmm-agent for errors? Can be downloaded by calling PMM_SERVER_URL/logs.zip
Thank you
1 Like
Nurlan,
Select * from performance_schema.events_statements_summary_by_digest ;
Empty set
I se error with aws aurora instances. like " Error 1054: Unknown column ’ . Probably is the aws bug?
pmm-agent.log (335.9 KB)
1 Like
Yeah looks like something wrong with aurora configuration.
Unknown column is not related to QAN as far as I see.