MySQL Database

The MySQL Databases HTML displays provide extensive visibility into the health and performance of the MySQL database. The HTML version features an overview display, RTView© Enterprise User's Guide Version 6.4 (pictured below), and the following Views which can be found under Components tab > Databases > MySQL Database:

•

MySQL Overview Display

•

All MySQL Instances View

•

RTView© Enterprise User's Guide Version 6.4

MySQL Overview Display

The MySQL Overview is the top-level display for the MySQL Solution Package, which provides a good starting point for immediately getting the status of all your MySQL instances on your Data Server.

You can select the RTView DataServer for which you want to see data and easily view the current data for that DataServer including:

•

The total number of active alerts, including the total number of critical and warning alerts.

•

The number of full joins and scan selects across all servers.

•

The number of threads running and threads created across all servers.

•

The number of slow queries and total queries across all servers.

•

The number of connections.

•

A visual list of the top 10 servers with the most queries.

The total pending messages, the outgoing messages per second, and the incoming messages per second for a selected EMS Server on your connected DataServer.

You can hover over each region in the upper half of the Overview to see more detail. You can also drill down to see even more detail by clicking on each respective region in the Overview.

For example, clicking on the alerts in the CRITICAL and WARNING alerts region opens the Alerts Table display.

The bottom half of the display provides a performance trend graph for queries for a selected instance.

You can hover over the trend graph to see the values at a particular time. You can specify the time range for the trend graph and view data based on a log scale, which enables visualization on a logarithmic scale and should be used when the range in your data is very broad.