MySQL Enterprise Monitor Features and Benefits

Easy to setup and configure
Zero Configuration, No Agent Agent-less monitoring. Query Analysis works "out of the box" using MySQL 5.6 Performance Schema.
Policy based administration Specify global policies, then override for custom groups.
Centrally view configurations View the configuration for your mysqld instances directly within the monitor.
Best Practice Advisors 14 Advisor Groups and 225+ Advisors provide automated expert guidance, for issues such as poor indexing, blocking, concurrency, long running processes, etc. Easily create custom advisors.
Visual Trend Analysis Easily identify trends for individual servers, groups, or entire topology. Identify outliers. Fix potential problems, before they happen.
Smart Rules & Alerts Rules and alerts adapt to changes in your IT infrastructure, using SMTP & SNMP with customizable thresholds.
Cloud-based remote monitoring
Agent-less, remote monitoring Monitor remote mysqld instances without the need for a remote agent.
Real-time Health & Availability Monitoring
Availability Monitoring Determine ability to meet weekly, monthly, and yearly SLAs.
Health Alerts Monitor health with configurable alerts for important events, using SMTP & SNMP with customizable thresholds.
Real-time Performance Monitoring
Performance Monitoring Monitor key performance metrics for your MySQL instances.
Performance Tuning Get helpful advice on how to improve MySQL configuration, based on live performance metrics, and trend analysis.
Statement Execution Time Get alerts when average query execution times drop below configurable thresholds.
Concurrent Queries Get alerts when you have too many concurrent queries running. Capacity planning allows you to know when you will need to distribute the load to more servers.
Query Pileup Get alerts when queries begin piling up, blocking other queries.
Maximum Connections Know when the capacity of your servers is nearing its limit so that you can head off potential problems.
Long running Processes Get alerts when you have too many processes taking too long to complete.
Visual Query Analysis
Query Analyzer With MySQL 5.6, Performance Schema is used for query analysis. Drill down into detailed query information, pinpoint SQL code that is the root cause of slow downs, and fix performance issues.
Top 10 most expensive queries Identify the queries that use the most resources, generate high load, or simply taking too long to complete.
Drill-down analysis Easily examine the execution plan for the query, see sample queries, see the details of the query execution.
Response Time analysis The Query Response Time index offers immediate insight into the overall query performance of a server, a group, or that of individual queries.
MySQL Cluster Monitoring
MySQL Cluster Memory Monitor Data and Index memory consumed by the data nodes.
MySQL Cluster Log buffers and files Monitor usage of files and buffers for redo and undo logs.
MySQL Cluster cache Monitor the data node cache-hit ration when using disk-based data
MySQL Cluster node status Monitor which data nodes are available.
InnoDB Monitoring
InnoDB Performance Monitor the key metrics for InnoDB engine performance.
InnoDB Configuration Get tips and hints on how to improve your InnoDB configuration based on the current performance and trend analysis.
InnoDB Locking Stay abreast of potential and existing InnoDB locking issues.
InnoDB Buffer Pool Stay on top of your InnoDB buffer pool usage, and the related configuration options.
Index Tuning Get alerts when your index usage needs improvement, followed by advice on how to improve it.
Replication Monitoring
Replication Topology Automatically detect the replication topology, and any changes that occur.
Replication Performance Monitor the live performance, and receive customizable alerts when performance problems have been detected.
Replication Health Monitors the health of your replication environment, sending alerts when any problems are detected.
Slave Lag Sends alerts when a slave falls too far behind its master.
Memory Monitoring
MySQL Memory Usage Monitor MySQL's internal memory usage, as well as its memory usage at the OS level. Get alerts when memory usage is too high.
Configuration Advice Get advice on improving the memory usage characteristics of your monitored assets, based on live status and trend analysis.
Disk Monitoring
Disk I/O Monitor the live Disk I/O being done, as well as analyze longer term usage trends. Get advice on configuration changes to reduce disk I/O and/or reduce the space used on disk.
Disk Space Get pro-active alerts predicting when MySQL will run out of disk space.
OS Monitoring
Auto-discovery of mysqld instances The MEM Agent will automatically detect any unmonitored instances of mysqld.
Load Monitoring Monitor key performance metrics for host machines, and identify trends. Get Alerts when the load average is too high.
CPU Usage Monitor the live CPU usage on host machines, identify trends, as well as outliers in your defined groups. Receive Alerts when CPU usage gets too high.
Swap Usage Monitors swap usage, sending alerts if the usage goes beyond a configurable threshold.
Network Traffic Monitor the network traffic for your ethernet devices.
Memory Usage Get alerts when your free RAM gets below configured thresholds.
Security Administration
Account Management Get alerts if there are accounts with no passwords, weak passwords, overly broad privileges, etc.
Monitor Access Problems Get alerts when network connectivity problems occur, or when there are indications of a potential attack on your systems.
Dashboard for MySQL Enterprise Backup
Backup Alerts Get alerts if your last full backup is too old.
Backup Health Get alerts if your previous backup attempt failed.
Backup Performance Get alerts if your previous backup attempt caused any locking or performance issues for MySQL.