

The Analyzer window gives you quantity and performance metrics on you SQL queries, and other details recorded by the MySQL Performance Schema. The MySQL Query Analyzer gives you detailed information on the SQL statements performed against your database environment, grouping similar statements together. You can also create you own custom advisors on the Advisor Management page. There are two types of advisors - expression-based for simple filter criteria, and GUI-based for more advanced settings. There are over 200 advisors in MySQL Enterprise Monitor covering 14 different categories, all of them enabled by default. These events will show themselves in Enterprise Monitor until they are manually closed by an operator. This event is fed into one or more Event Handlers, which perform some condition when an event is raised, allowing an email or an SNMP message to go out. When the data meets the advisor's criteria threshold, an Event is raised. AdvisorsĪdvisors are components that parse and evaluate information received from the monitor agents. Let's take a look at some of the key components that make up Enterprise Monitor functionality. It should be noted that this simply removes the agents from Enterprise Monitor and should only be performed on assets no longer in use. Enterprise Monitor allows you to delete assets from the user interface.The Hosts view gives you similar operational information on the host as well as a detail page outlining the hardware and OS details. The Agent view shows you all of the Enterprise Monitor agents registered with your manager instance, with a summary of their operational status and agent details in the detail view. Asset Views were added to include Agents and Hosts.The Query Analyzer has been completely re-written using Oracle JavaScript Extension Toolkit, a free and open source JavaScript SDK to help developers build web apps using a rich set of web components.From here, you can see - in an organized portal - what is happening within your MySQL database environment(s). Nterprise Monitor is the visual command center of your MySQL Enterprise install. MySQL Enterprise Monitor is the visualization dashboard containing all relevant information about the MySQL Servers being monitored - from replication topology to low-level OS configuration settings.
