-
Titre
No data displayed in the "Statements" tab for MySQL Aurora instances -
Description
When opening the "Statements" tab within the MySQL dashboard, the charts are empty. All metrics are missing.
-
Cause
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.
-
Résolution
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
Also, please verify that the performance schema instrumentation is turned on and that the erformance_schema.events_statements_summary_by_digest table actually has statements to collect.