This page has been deprecated and users are recommended to use the Databases Global View dashboard as described in Knowledgebase article 4226596
The MySQL Global View dashboard displays the following metrics, in row format, for each MySQL agent instance deployed:
- Instance Group
- Health Indicator – Shows the overall health of the deployed instance.
- Name – The “Instance Name” of the MySQL agent. This is the name entered when the MySQL agent instance was created.
- Host – Host Name of the MySQL agent instance.
- MySQL Version – The version of the MySQL database being monitored.
- Alarms Group
- Fatal – Provides a count of the “Fatal” alerts for this agent.
- Critical – Provides a count of the “Critical” alerts for this agent.
- Warning – Provides a count of the “Warning” alerts for this agent.
- Query Cache Group
- Hit Ratio – Provides a historical trend and a current value of the Query Cache Hit Ratio for the selected time range.
- Queries – Provides a historical trend and a current value of the number of SQL statements that are in cache for the selected time range.
- Thread Pool Group
- Hit Ratio – Provides a historical trend and a current value of the ratio of the number of threads that were used from the pool to the total number of connections made for the selected time range.
- Threads Running – Provides a historical trend and a current value of the number of active (non-sleeping) threads for the selected time range.
- InnoDB Buffer Pool
- Hit Ratio – Provides a historical trend and a current value of the InnoDB BufferPool Hit Ratio for the selected time range.
To get additional information for some of the metrics, the MySQL Global View dashboard provides a dwell capability (by hovering over the metric) and drill down (clicking on the metric) functionality built-in.
The dwell (hovering over the metric) functionality provides a graphical trend for the selected metric over a specified time range