To access the Database Health page
Details of the Database Health page
The Database Health page displays metrics that tell you the health and performance of your database, providing details about database uptime, query times, key cache, table cache, table lock acquisitions, lock threads, and connections.
To access the Database Health page:
- In the Main Menu, click System Information.
- In the System Information table, click the icon (either a green tick or a red cross) in the Database column.
- This will take you to the Database Health page.
Details of the Database Health page:
The information shown on this page is as follows:
Row Name | Row Description |
---|---|
Database Uptime | time since the database's last start. |
Slow Queries (> 15s) | a query that takes longer than the set value, which is 15 seconds by default. A high value identifies a possible opportunity for database query optimization. |
Past Hour: | number of queries exceeding the slow query threshold in the past hour. |
Avg. per Hour: | average number of queries per hour exceeding the slow query threshold since the last database restart. |
Past 24 Hours: | number of queries exceeding the slow query threshold in the past 24 hours. If the database uptime is less than 24 hours, this figure will be adjusted accordingly. |
Avg. per 24 Hours: | average number of queries per day exceeding the slow query threshold since the last database restart. |
Key Cache | |
Size | size of the configured key cache |
Hits in Past 24 Hours: | cache-hit percentage in the past 24 hours. If the database uptime is less than 24 hours, this figure will be adjusted accordingly. |
Table Cache | |
Size: | size of the current table cache |
Tables Opened in Past 24 Hours: | number of tables opened in the past 24 hours. If the database uptime is less than 24 hours, this figure will be adjusted accordingly. |
Avg. per 24 Hours: | average number of tables opened per day since the last database restart. |
Table Lock Acquisitions | |
Total | number of table lock acquisitions, over the past hour and the past 24 hours. If the database uptime is less than 24 hours, this second figure will be adjusted accordingly. |
Immediate | number of immediate table lock acquisitions, over the past hour and the past 24 hours. If the database uptime is less than 24 hours, this second figure will be adjusted accordingly. |
Waited | number of delayed table lock acquisitions, over the past hour and the past 24 hours. If the database uptime is less than 24 hours, this second figure will be adjusted accordingly. |
Threads | |
Non-Sleeping: | number of current non-sleeping lock threads. |
Average: | average number of non-sleeping lock threads since the last database restart. |
Waiting on User Lock: | number of current waiting-on-user lock threads. |
Average: | average number of waiting-on-user lock threads since the last database restart. |
Maximum Open Connections: | maximum number of open connections since the last database restart. |
Current Open Connections: | current number of open connections. |
Avg. per 24 Hours: | average number of open connections per day since the last database restart. |
A large number of slow queries corresponds to a large database load.
A higher number of open connections indicates higher database utilization.
Comments
0 comments
Please sign in to leave a comment.