When opening the "Statements" tab within the MySQL dashboard, the charts are empty. All metrics are missing.
The most common issue is that the performance schema is not enabled on the MySQL instance.
For "Workload" and "Total Statements Count" charts, the performance schema needs to be ON.
For "CPU Utilization", "Logical Disk Reads Rate" and "Physical Disks Bytes Read Rate" charts will not show data because MySQL Aurora is a PaaS and AWS do not share this information.
The top x number of statements are collected by the provided parameter from the performance_schema.events_statements_summary_by_digest table.
Please refer to this link to see how to enable performance schema in a RDS MySQL Aurora instance:
Enable performance schema - AWS RDS MySQL Aurora
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 이용 약관 개인정보 보호정책 Cookie Preference Center