Contact Sales

USA: +1-866-221-0634
Canada: +1-866-221-0634

Germany: +49 89 143 01280
France: +33 1 57 60 83 57
Italy: +39 02 249 59 120
UK: +44 207 553 8447

Japan: 0120-065556
China: 10800-811-0823
India: 0008001005870
Brazil: +55 11 5189-1097

MySQL Enterprise Edition Trial - Try Now

MySQL Enterprise Monitor Features and Benefits

Consolidated View of all MySQL Servers
Enterprise Dashboard	Browser-based solution allows DBAs to monitor all MySQL servers from a centralized console.
Server Heat Chart	Provides at-a-glance, color-coded view in the health, performance and availability of all MySQL servers.
Explorer Based Navigation	Allows for easy navigation and filtering of MySQL server monitoring data.
Auto Detection of MySQL Environments
All MySQL Servers and Metrics	After the Service Agent is installed, Enterprise Dashboard provides immediate visibility of all MySQL server and OS specific metrics.
All MySQL Replication and Scale-Out Topologies	Replication and Scale-out Topologies are auto-detected and maintained without the need for DBA set up or configuration.
Auto grouping of MySQL Replication and Scale-Out Topologies	Replication and Scale-out Topologies are auto-grouped without the need for DBA set up or configuration.
Advanced Query Analyzer for Scale Out Environments
Easy Query Collection and Aggregation without reliance on SQL Query Log or SHOW PROCESSLIST	Helps DBA/Developer quickly find expensive queries by collecting execution statistics across all MySQL Servers and aggregating results for total executions, total execution time, total rows, total size of data. Queries are shown in normalized format with drill downs into sampled executions. Query Analyzer enablement options and benefits of each are described in the MySQL Documentation.
Correlation of MySQL and System Graphs with Query Activity	Allows DBAs and developers to highlight specific regions of the MySQL Enterprise Monitor graphs and launch the Query Analyzer which provides a context-sensitive, filtered view of the queries that were running during the selected time. This helps to quickly and easily reveal the queries that may be the root cause of spikes in key system resources.
Advanced Query Analyzer	Provides multiple options for quickly finding worst offenders. Collected queries can be sorted and filtered by server, database, query type, query content. Analysis can be done by current time intervals or by historical date/time range.
Sample Query Executions Drill-downs/EXPLAIN	Provides fully qualified execution details and EXPLAIN of worst execution in the aggregation period. Helps DBA and developers understand how the code should be tuned for optimal performance.
Query Specific Execution Graphs	Helps DBAs and developers view execution pattern for specific query to determine "normal" behavior and if performance issues are tied to variable combinations or specific windows of time.
Ability to alias and tag specific queries for watching	Allows DBAs and developers to alias and watch specific queries by tagging them with descriptive, meaningful titles for easy identification.
Ability to monitor when new/changed queries are "First Seen"	Allows DBAs and developers to quickly see if new or changed queries are affecting the performance of their systems.
Advanced Monitoring of MySQL and OS Specific Metrics
MySQL Replication Monitoring	Replication Monitor provides a consolidated, real-time view into the performance and status of all Master/Slave relationships, including those configured for semi-synchronous replication.
MySQL Heat Chart Metrics	Provides DBA with MySQL Up/Down Status and visual health check and drill-downs on: Connections Lock Connections MyISAM Cache Query Cache Temp Tables to Disk Table Scans
OS Heat Chart Metrics	Provides DBA with visual check and drill-downs on: CPU Disk IO RAM Usage
MySQL and OS Metric Graphs	Allows DBA to monitor and correlate 60+ graphs that monitor these metrics: InnoDB Transactional throughput Disk and File IO Cache Hit Ratios Database Activity (Selects, Inserts, Updates, Deletes) Connections Innodb specific performance metrics Query Cache Efficiency Row Access/Writes Replication Delay Sort Activity Table Locks Temporary Tables Thread Cache CPU Utilization RAM Usage Virtual Memory Usage More ... Users can mouse over and highlight specific regions of any Monitor graph to launch the Query Analyzer which provides a context-sensitive, filtered view of the queries that were running during the selected time. Users are also enabled to easily create their own custom graphs to meet specific needs. Information on this is available in the MySQL documentation.
MySQL Advisors and Rules-Based Monitoring for MySQL Best Practices
MySQL Enterprise Backup Advisor	Monitors and Advises on MySQL Enterprise Backup operations, status and MySQL servers needing to be backed up.
MySQL Cluster Advisor	Monitors and Advises on health, performance and availability of MySQL Cluster data nodes.
Upgrade Advisor	Monitors and advises on specific bugs that can potentially impact versions of MySQL Enterprise Server deployed within an environment. Advises on specific upgrade path to version of MySQL that provides fix for identified bugs.
Administration Advisor	Monitors and advises on problems relating to general MySQL administration, recoverability and performance configuration settings.
Security Advisor	Monitors and advises on unplanned security changes and vulnerabilities in a MySQL Server.
Heat Chart Advisor	Monitors and Identifies MySQL and OS specific metrics that impact the health, performance and availability of MySQL systems.
Memory Usage Advisor	Monitors dynamic memory related server metrics (cache usage, hit ratios, etc.) and advises on adjustments to related configuration settings.
Replication Advisor	Monitors and advises on issues relating to replication setup or master/slave latency and performance problems.
Schema Advisor	Monitors and advises on unexpected changes to database schema and objects.
Performance Advisor	Monitors and advises on dynamic performance related server metrics and advises on adjustments to related configuration and variable settings.
Custom Advisors	Allows DBAs to create Advisors and Rules to fit specific needs.
Productivity Through Automation
Automatic Data Collections	MySQL server data is automatically collected and stored in a centralized repository for Advisor monitoring, graphing and historical analysis.
24 X 7 Automated Monitoring of all MySQL Servers	MySQL Advisors and Rules can be scheduled so key systems are monitored around the clock.
Scriptable Calendar Based Monitoring	MySQL Advisors and Rules can be scheduled to monitor around calendar-based events such as weekends, holidays and maintenance windows.
Custom Scheduling Options	Advisor Rule level scheduling provides maximum flexibility.
Threshold-Driven Events/Detailed Resolution
Info, Severe, Critical Best Practice Violation Events	MySQL and User-defined severities can be assigned to Best Practice violation Events identified by the MySQL Advisors.
MySQL and User-Defined Thresholds	MySQL and User-defined thresholds can be assigned to determine what criteria triggers a Best Practice violation Event.
Detailed Advice and Commands on Event Resolution	Each Advisor provides detailed, expert advice and corrective actions that can be employed to resolve a Best Practice violation Event.
Annotation History for Closed Events	Users can attached resolution notes to Events as they are closed.
Multi Event Close Option	Users can save time by closing and annotating multiple Events at the same time if needed.
Flexible Notification Options
Enterprise Dashboard	Browser-based solution allows DBAs to view/monitor all MySQL server monitoring related Events from a centralized console.
SNMP Enabled	Notifications can be plugged into an existing SNMP enabled infrastructure (Openview, Tivoli, Nagios, Cacti, others).
SMTP Enabled	Email notifications can be sent to distribution lists, multi recipients, or any email enabled device.
Custom Notification Options	Global and Advisor Rule level notification options provide maximum flexibility.
Customization Options
Server Groupings	Servers can be grouped by application, location, ownership, etc making it easy to manage/monitor multiple servers as a single entity.
Notification Groups	Notifications can be sent to single or group recipients using this smart grouping option.
Graphing	DBAs can select specific graph favorities from the Graphs Gallery for display on the Monitor page of the Enterprise Dashboard.
Custom Advisors and Rules	Allows DBAs to create Advisors and Rules to fit specific needs.
Easy Installation and Configuration
Full/Upgrade Installers for all Supported Platforms	Installation is made easy via step-by-step installers for both new and existing deployments.
Online Advisor/Rule/Graph Updates	Regular Advisor, Rule and Graph updates can be automatically downloaded and imported
Flexible Query Analyzer configuration and enablement options	Query Analyzer can be enabled and populated for Development, QA and Production environments using several flexible options.
Easy Support Updates and Diagnostics
Integrated with My Oracle Support	Enterprise Dashboard can be configured to receive product updates on new product releases and updates on open My Oracle Support Requests
Application Diagnostic Log/File Extract	Commonly requested diagnostic reports are generated, zipped and ready to send to Oracle's MySQL support team.
Internationalization
English	Full product functionality
Japanese	Full product functionality