MySQL Lists are EOL. Please join:

List:Announcements« Previous MessageNext Message »
From:andy bang Date:April 19 2018 4:57pm
Subject:MySQL Enterprise Monitor 8.0.0 GA has been released
View as plain text  
We are very happy to announce the general availability of MySQL
Enterprise Monitor, Version 8.0. MySQL Enterprise Monitor is the best-
in-class tool for monitoring and management of your MySQL assets and
is included with your MySQL Enterprise Edition and MySQL Enterprise
Carrier Grade subscriptions.

You’ll find information about what’s new here:
   (also included at the end of this note for convenience)


* MySQL Enterprise Monitor 8.0 supports monitoring MySQL Server 8.0.11
   and later. You can also use MySQL Server 8.0 as an external data
   repository for MySQL Enterprise Monitor 8.0.

* Significant improvements have been made to the performance and user
   interface of the Query Analyzer. When you click on a SQL statement,
   the new Statement Details page enables you to browse all example
   statements in the specified time range, rather than just the one
   with the worst run time. Drill into any of these examples to see
   their individual statistics, literals used, and EXPLAIN plan. Graphs
   display the execution pattern of the selected query during the
   specified time period.

* The new Global Memory Usage report builds upon the Memory
   instrumentation exposed within Performance Schema to provide greater
   insight into where memory is being allocated within the MySQL
   Instance - not just at the InnoDB Buffer Pool level, but for all
   memory allocations, across all connections and threads within MySQL.
   The report breaks down memory by allocation type, such as memory
   allocated for sorting, the buffer pool, or various other internal
   buffers used for statement processing.


You will find binaries for the new release on My Oracle Support:

Choose the "Patches & Updates" tab, and then choose the "Product or
Family (Advanced Search)" side tab in the "Patch Search" portlet.

You will also find the binaries on the Oracle Software Delivery Cloud:

Search "All Categories" for "MySQL" and choose from the results
accordingly.  You will find the Enterprise Monitor along with other
MySQL products.

If you are not a MySQL Enterprise customer and want to try the Monitor
and Query Analyzer using our 30-day free customer trial, go to, or contact Sales at

Please open a bug or a ticket on My Oracle Support to report problems,
request features, or give us general feedback about how this release
meets your needs.

Useful URLs

* My Oracle Support -
* What's New in 8.0 -
* Change log -
* Installation documentation -
* Complete documentation -
* Product information -
* Download - or

Thanks and Happy Monitoring!

- The MySQL Enterprise Tools Development Team


Changes in MySQL Enterprise Monitor 8.0.0

Functionality Added or Changed

* MySQL Enterprise Service Manager supports monitoring of MySQL 8.

   Important: Due to password plugin changes in the server, only MEM
   8.0 and later support monitoring MySQL 8.0.11, or higher.

   Note: If you intend to use MySQL 8 as an external repository, the
   installer no longer checks for innodb_file_format or
   innodb_locks_unsafe_for_binlog as they are deprecated in MySQL 8.

   For more information, see Prerequisites.

   Several system and status variables used by the MySQL Enterprise
   Service Manager's advisors were deprecated in MySQL 8. As such, some
   advisors do not evaluate for MySQL 8. Instead of presenting advice,
   as they do for earlier versions of MySQL, a warning is displayed,
   advising you that the advisor does not evaluate against MySQL 8, or

   The following advisors do no evaluate for MySQL 8:

   - InnoDB Not Using Newest File Format

   - Insecure Password Authentication Option is Enabled

   - Next-Key Locking Disabled For InnoDB But Binary Logging Enabled

   - Warnings Not Being Logged

   - Query Cache Has Sub-Optimal Hit Rate

   - Query Cache Is Excessively Fragmented

   - Query Cache Potentially Undersized

   The InnoDB Undo Logs graph is not displayed for MySQL 8 instances.

   For more information on the variables added and removed in this
   release, see Server and Status Variables and Options Added,
   Deprecated, or Removed in MySQL 8.0. (Bug #25877130)

* System variables introduced in MySQL 8 are available in MySQL
   Enterprise Monitor views such as the per-instance drilldown on the
   MySQL instance dashboard. For more information on the variables
   added and removed in this release, see Server and Status Variables
   and Options Added, Deprecated, or Removed in MySQL 8.0.

* The MySQL server, bundled with the MySQL Enterprise Service Manager,
   has been upgraded to MySQL 5.7.22.

* Memory Usage report enables you to view how memory is allocated
   within the MySQL Instance.

   For more information, see Memory Usage Report.

* Query Analyzer Statement Details view is updated in this release.

   For more information, see Detailed Query Information.

Bugs Fixed

* The Time Span and Graph From: labels did not display multibyte
   characters correctly. The character codes were displayed instead of
   the characters themselves. (Bug #27695440)

* The Zoom links on the Query Analyzer page did not alter the graph
   time range. (Bug #27410942)

* The columns of the Current Emergency & Critical Events list, on the
   Overview page, contained chevrons, indicating it was possible to
   sort the events. It is not possible to sort the events of this list,
   the emergency events are always listed first, and the list is sorted
   by Current and Time. (Bug #27011755, Bug #27720503)

* Retrieving Query Analyzer data for the Statement details report
   resulted in resource-intensive index scans on the
   normalized_statements_by_server_by_schema_data table.

   As part of the Query Analyzer performance improvements in MySQL
   Enterprise Monitor 8.0, this index scan is no longer performed. (Bug

* On Windows platforms, the agent service description contained an
   incorrect version number.

* The emailed links were incorrect for events generated by the SQL
   Statement Generates Warnings or Errors and Average Statement
   Execution Time Advisor advisors.

* It was not possible to edit any notification groups other than the
   first 10 displayed. The remaining groups were displayed as inactive.

* The link to the Settings page, in the Important Product-Related
   Announcements section of the What's New page, did not link to the
   Settings page.
MySQL Enterprise Monitor 8.0.0 GA has been releasedandy bang19 Apr