Not the answer you need?
Register and ask your own question!

PMM Query Analytics doesn't work in My RDS

sowesowe EntrantInactive User Role Beginner
Hi all,
I'm try to connect my PMM with my RDS instance both of them is in AWS .
PMM installed Amazon market , the only mensage i had is this
"There is no query data because the MySQL Server is not configured for monitoring. For details about the required configuration, see Configuring MySQL for Percona Monitoring and Management in PMM documentation."
i following the instructions but still show me this error .
mysql> SHOW VARIABLES LIKE 'performance_schema';0
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| performance_schema | ON    |
+--------------------+-------+

Any idea?

doc : https://www.percona.com/doc/percona-monitoring-and-management/amazon-rds.html and https://www.percona.com/doc/percona-monitoring-and-management/conf-mysql.html

Comments

  • Michael CoburnMichael Coburn Principal Architect, Percona Percona Staff Role
    Hi sowe

    Can you give us the output of
    show global variables like 'long_query_time';

    we want this to be very small, ideally 0.

    Also visit the Dashboard named _PMM Query Analytics Settings and verify that the RDS instance is configured to be monitored for query activity.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.