MySQL Lists are EOL. Please join:

List:Announcements« Previous MessageNext Message »
From:Airton Lastori Date:January 22 2019 11:07pm
Subject:MySQL Enterprise Monitor 8.0.14 has been released
View as plain text  
We are pleased to announce that MySQL Enterprise Monitor 8.0.14 is now available for
download on the My Oracle Support (MOS) web site. It will also be available for download
via the Oracle Software Delivery Cloud in a few days. 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. 

Starting with version 8.0.14, MySQL Enterprise Monitor is now aligned with the version
number of the whole MySQL product line. 8.0.4 to 8.0.13 are skipped version numbers.

MySQL Enterprise Monitor 8.0.14 includes enhancements and fixes a number of bugs. You can
find more information on the contents of this release in the changelog: (also included at
the end of this note for convenience).


* A redesigned Query Analyzer with more customization options for graph and data
visualization, sorting and filtering by clicking on Configure View button. 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 MySQL Enterprise Monitor Inventory user interface got a new functionality to remove
assets. Now you can select and delete one or multiple entries for clusters, topologies,
agents, hosts, and instances which were monitored, but are no longer in use.

* With the new Views for Agents and Hosts, you can now examine the configuration and
current status of Agents and Hosts in great detail.

* The new NDB Clusters configuration view complements the NDB Cluster monitoring with the
visualization of all currently monitored clusters, their membership, and configurations.

* MySQL Enterprise Monitor 8.0 supports monitoring MySQL Server 8.0.11+, so you can
monitor MySQL Server from version 5.5 onwards. MySQL Enterprise Monitor 8.0 also has MySQL
Server 8.0 as its bundled repository or you can also use MySQL Server 8.0 as an external
data repository. 

* The 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 types, 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

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.14

Important - It is not possible to upgrade to MySQL Enterprise Monitor 8.0.14 from versions
preceding MySQL Enterprise Monitor 3.4. To upgrade an older version, it is recommended you
first upgrade to MySQL Enterprise Monitor 4.0 before running the MySQL Enterprise Monitor
8.0.14 upgrade process.

MySQL Enterprise Service Manager 8.0.14 bundled repository is MySQL Server 8.0.14.

* MySQL Product Versioning
* Functionality Added or Changed
* Bugs Fixed

MySQL Product Versioning

* Important Change: Beginning with version 8.0.14, MySQL Enterprise Monitor is now aligned
with the version number of the MySQL product line. Version numbers 8.0.4 to 8.0.13 are

Functionality Added or Changed

* Important Change: It is now possible to delete obsolete or unused assets from the MySQL
Enterprise Monitor inventory using the user interface.

Important - Deleting assets from the inventory does not delete or uninstall assets from
their installed locations. The delete process removes all record of an asset or group of
assets from the internal record of MySQL Enterprise Service Manager, only. This enables
you to remove entries for clusters, topologies, agents, hosts, and instances which were
monitored, but are no longer in use.

For more information, see Deleting Assets (Bug #26805727)

* Important Change: The MySQL server, bundled with the MySQL Enterprise Service Manager,
has been upgraded to MySQL 8.0.14.

Important - It is strongly recommended you backup your existing MySQL Enterprise Monitor
repository, and test the backup, before upgrading to MySQL Enterprise Monitor 8.0.14.

The following MySQL 5.7-specific configuration parameters have been removed from the MySQL
configuration file included with the bundled repository. These parameters were removed
because they are either obsolete and no longer used by MySQL 8, or because the values
defined by them are now defaults in MySQL 8.

  default-storage-engine = INNODB
  default_tmp_storage_engine = INNODB
  event_scheduler = ON
  explicit_defaults_for_timestamp = 1
  innodb_file_format = Barracuda
  innodb_support_xa = 0
  innodb_adaptive_flushing = 1
  innodb_locks_unsafe_for_binlog = 1
  local-infile = 0

For more information on parameters added, changed, deprecated, or removed in MySQL 8, see
What Is New in MySQL 8.0.

The MySQL X plugin is disabled by default. If enabled in an existing configuration, the
upgrade process disables it.

log-bin is enabled by default. If you disabled this parameter in your configuration, your
setting is preserved by the upgrade process. However, it is recommended you backup your
configuration before upgrading.

* Important Change: New asset views are added in this release. These asset views enable
you to examine, in detail, the configuration and status of Agents, Hosts, and NDB

For more information, see Asset Management

* Important Change: As of this release, to install MySQL Enterprise Monitor on Solaris
platforms, you must install the Oracle Developer Studio 12.6 Runtime libraries first. If
the installer does not detect those libraries, the installation displays an error and
cannot proceed until the prerequisite libraries are present.

* A new configuration view filter form is added in this release. It is used by the Query
Analyzer, and the Agent, Hosts, and NDB Cluster asset views.

These views enable you to define default viewing options such as graphs, filtering and

For more information, see Configuration Views. (Bug #18203424)

* The user interface of the Query Analyzer has been completely redesigned. Building upon
Oracle's JavaScript Extension Toolkit (JET) framework, this new design improves navigation
in the Query Analyzer and introduces advanced configuration options which enable you to
customize, sort, and filter the data displayed.

For more information, see Query Analyzer User Interface. (Bug #18203339)

* As of this release, performance-schema-consumer-events-statements-history-long is
enabled on the bundled repository. If you are using an external repository, you must
enable this consumer by adding the following to your MySQL configuration file:

* The OpenSSL libraries used by the MySQL Enterprise Monitor installers and MySQL
Enterprise Monitor Aggregator have been upgraded to 1.0.2q.

Bugs Fixed

* The documentation describing the Active Directory configuration incorrectly stated that
a port was required in addition to the hostname. The port is 389 and cannot be altered.
(Bug #29173152)

* MySQL Enterprise Service Manager did not start after upgrading from version 3.4 to
version 8.0. The error cannot determine singular foreign key name for
normalized_statements_by_server_by_schema was logged. (Bug #28938022)

* The documentation describing the logic of replica promotion to a source was incorrect.
(Bug #28905972)

* It was not possible to remove the CPU Utilization - Mysql Server - CPU graph from the
Overview if only a single instance was selected. (Bug #28794385)

* Several Advisor tooltips contained broken links and links pointing to outdated content.
(Bug #28171028)

* The graph range selection controls (Cancel selection and Query Analysis) were visible
through any menu or dialog which overlaid the selection. (Bug #17555151)

* It was not possible to use the percentage character (%) in filter names. The filter was
saved and was displayed in the list of available filters, but did not display the
configured data when selected.

* Automatic page refresh did not pause if an asset was selected.

* Null Pointer Exceptions were logged relating to Query Analysis and Explain Plan when
monitoring MySQL 8. These exceptions were caused by the removal of EXPLAIN EXTENDED in
MySQL 8.

As of this release, MySQL Enterprise Monitor checks which MySQL version is being monitored
and only attempts to use EXPLAIN EXTENDED on versions which support it.

* The vertical scroll bar did not behave as expected in Microsoft Internet Explorer 11. No
other browser was affected by this issue.

MySQL Enterprise Monitor 8.0.14 has been releasedAirton Lastori22 Jan