• MySQL 5.1 Reference Manual :: 15 MySQL Enterprise Monitor :: 15.4 MySQL Enterprise Dashboard
  • 15.4. MySQL Enterprise Dashboard

    Note

    MySQL Enterprise subscription, MySQL Enterprise Monitor, MySQL Replication Monitor, and MySQL Query Analyzer are only available to commercial customers. To learn more, see: http://www.mysql.com/products/enterprise/features.html.

    The purpose of the MySQL Enterprise Dashboard is to provide you with information about your MySQL servers. It provides a list of the latest MySQL Enterprise Advisor reports, server status information, MySQL Enterprise alerts, and updated views of monitored MySQL servers. The Monitor screen gives a quick overview of the status of your MySQL servers.

    The MySQL Enterprise Dashboard interface is provided through a standard web browser. For more details on the supported browsers, see Section 15.12.2, “Supported Browsers”.

    You can open the Dashboard and connect to the MySQL Enterprise Dashboard either using the standard HTTP protocol, or using an SSL connection (HTTPS). By default, you can connect to MySQL Enterprise Dashboard using http://host:18080, where host is the hostname or IP address of the MySQL Enterprise Service Manager. The default SSL URL is http://host:18443. These values can be overridden during installation. You can check the configured values by looking at the configuration_report.txt file within your installation directory.

    Note

    If you are connecting using SSL, the built-in certificate has been self-signed and may be highlighted as 'unsafe' within the browser on initial connection. You should add an exception for the certificate on this server to prevent problems accessing the site.

    The Monitoring page provides an instant health check for all of the MySQL servers across the enterprise.

    From this page users can:

    • View monitoring data and all critical MySQL Advisor Rule violations for all or selected servers.

    • Close and annotate MySQL Advisor Rule violations.

    • Quickly determine if there is a Monitor Agent that is not communicating with the Service Manager.

    • Quickly determine if there is a server that is in trouble or completely down.

    • View indicator value graphs for key MySQL and operating system (OS) level metrics. Graph presentation will default to a thumbnail view but will open into a larger image upon being clicked.

    The monitored server or servers are displayed in a tab on the left known as the Server Tree. You can navigate to a number pages that provide more detailed information. These pages include:

    • Monitor: The overview page providing you with a quick summary of the servers, their status, events, availability and load. The remainder of this chapter details the contents of this page.

    • Advisors: Shows the various advisors configured in your installation and allows you to schedule their execution on different servers, apply and manage rules and manage the advisor installation itself. For more information, see Section 15.7, “The Advisors Page”.

    • Events: Provides an interface into the event system that highlights specific issues and problems on your monitored servers. For more information on using Events, see Section 15.8, “The Events Page”.

    • Query Analyzer: Interfaces to the query monitoring system that can be used to monitor and track the individual queries that are being executed on a system and help to highlight problem queries that may need optimization or that may be affecting server load. For more information, see Section 15.10, “The Query Analyzer Page”.

    • Graphs: Enables you to view and configure a number of individual graphcs covering a range of different statistics. For more details on how to view and use these graphs, see Section 15.9, “The Graphs Page”.

    • Replication: Provides information on the status and structure of your servers that are using replication. This page is only available if you have a suitable subscription level. For more information, see Section 15.11, “The Replication Page”.

    • Settings: Controls the settings for the server, including email configuration, passwords, and server and user management. For more information, see Section 15.5, “The Settings Page”.

    Graphs are shown in the center of the page beneath the tabs. If applicable, you'll also find a list of critical events.

    On the right is the color-coded Heat Chart, showing the advisors that are installed by default. The Heat Chart shows the most important advisors, allowing a quick overview of the state of your servers. You may open the Heat Chart in its own window by clicking the Standalone Heat Chart link. If applicable, you'll also find a list of critical events.

    The Show/Hide Legend link toggles display of the key to the icons used in the Heat Chart.

    Note

    Find colorblind-accessible icons in the alternate directory. On Linux this directory is immediately below the /monitor/apache-tomcat/webapps/ROOT/web/resources/images/ directory. These images are stored in the same directory on Windows. To use them, backup the originals and then copy and paste the alternate set into the images directory.

    If a specific server is selected in the Server Tree details about this server are shown beneath the legend in the Meta Info area. The information shown in this area is the host name, the MySQL version number, the number of scheduled rules, the operating system, and the CPU.

    The Meta Info section also shows how long the agent has been running, when it last contacted the MySQL server it is monitoring, and the last time the agent contacted the dashboard. Mouse over the date shown beside Up Since and a pop-up box displays the time that has elapsed since the server instance was last started. You can also mouse over the Last MySQL Contact and the Last Agent Contact dates.

    Note

    In the case of remote monitoring, the agent runs on a different machine than the MySQL server that it is monitoring. The Hostname, MySQL, and Rules information applies to the system being monitored. The OS and CPU information applies to the machine on which the agent is running. For more information about remote monitoring see, Section 15.3.3.6.4, “Configuring an Agent to Monitor a Remote MySQL Server”.

    The top of the screen shows the refresh cycle and Help and Log Out links. Click the Help link to open the documentation in a separate browser window. Choose Log Out if you wish to leave the Dashboard or to log in as a different user. Different refresh rates are available from the drop-down listbox.

    In the footer are external links to MySQL Enterprise and information about the current user. Users can remain connected to the Dashboard and update their subscription, use the Enterprise Knowledge Base, and contact technical support. Your subscription information is also displayed here, showing the number of days remaining and the number of licenses. The number of licenses indicates to the number of machines that may be monitored; any number of MySQL servers may be running on a specific machine.

    The footer also contains a link to the Settings page. If your subscription is current it reads Subscription is up-to-date. More info..... For more information about the Settings page see Section 15.5.7, “The Product Information Screen”.