Viewing Performance Hub
Performance Hub displays SQL statement information for the selected time period, and you can improve the performance of your database applications by monitoring query performance. It enables you to accurately find out the root cause of a slow down in the SQL code, and improve SQL code during development as well as continuously monitor and tune queries running on production systems.
Using the Console
Use the console to view Performance Hub to monitor and analyze SQL performance and obtain greater visibility into performance issues.
This task requires the following:
- A running DB system with MySQL version 8.0.33 or higher.
- Policies required for Database Management. See Permissions Required to Use Database Management.
Do the following to view Performance Hub:
- Open the navigation menu, and select Databases, and under MySQL HeatWave, select DB systems.
- Click the name of the DB system to open the DB system details page.
- Click the Performance Hub button present at the top of the page to open the Performance Hub page.
You can see average statement latency, top 100 SQL statements, and other
details.
Related Topics