MySQL Lists are EOL. Please join:

List:Announcements« Previous MessageNext Message »
From:andy bang Date:July 5 2017 8:44pm
Subject:MySQL Enterprise Monitor 3.4.2 has been released
View as plain text  
We are pleased to announce that MySQL Enterprise Monitor 3.4.2 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 Cluster
Carrier Grade Edition subscriptions.

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

Highlights of MySQL Enterprise Monitor 3.4 include:

* The Replication Dashboard is extended to provide monitoring support
   for Group Replication, which was introduced in MySQL Server 5.7.17.
   The Topology view provides a visual representation of your group
   replication topologies, and the Status drill downs are updated with
   Group Replication-specific information. The status of the entire
   group is reported on, also showing node failure tolerances and
   whether Group Replication has quorum.

* New Group Replication Configuration and Group Replication Status
   Advisors provide continuous analysis of the condition of your group
   replication topologies. The Configuration Advisor checks for
   misconfigurations which could lead to unstable or insecure
   installations; the Status Advisor continuously monitors for servers
   which go offline or fall out of sync with the other members of the

* The new Table Statistics report utilizes sys schema and its
   schema_table_statistics view to show detailed table statistics in
   both table and treemap forms. Available on MySQL 5.6 and above,
   report details include total latencies, total number of rows
   deleted, total I/O write requests.

* In general, the user interface page-loading times and page
   responsiveness are improved in 3.4. In addition, time series graphs
   are much faster in this release, particularly when you specify a
   long time period. This graph performance improvement is gained by
   continuous aggregation of time series data. If you are updating from
   an earlier version, a one-time aggregation of your historic time
   series data is performed when you first start the Service Manager
   (as shown by a progress indicator next to the System Status


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

Choose "MySQL Database" as the Product Pack and 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 3.4 -
* Change log -
* Installation documentation -
* Complete documentation -
* Product information -
* Download - (available now) or

Thanks and Happy Monitoring!

- The MySQL Enterprise Tools Development Team


Changes in MySQL Enterprise Monitor 3.4.2

Agent-specific Issues in 3.4.2

* Important Change: As MySQL Enterprise Monitor is enhanced over time,
   it is not always possible to maintain backward compatibility between
   new MySQL Enterprise Service Managers and older MySQL Enterprise
   Monitor Agents. Running mismatched versions can result in
   unpredictable behaviour.

   The Wrong Version Agent Tracker advisor is updated in this release
   and renamed Unsupported Agent Version Advisor. This advisor checks
   all agents connecting to the MySQL Enterprise Service Manager and
   raises events for unsupported agents.

   It is strongly recommended that you upgrade your agents after
   upgrading your MySQL Enterprise Service Manager. MySQL Enterprise
   Service Manager and MySQL Enterprise Monitor Agent should be the
   same version.

* If the following reports were run from a MySQL Enterprise Service
   Manager 3.4.1, which used older MySQL Enterprise Monitor Agents, a
   deserialization error occurred:

   - InnoDB Buffer Pool Usage

   - Processes

   - Lock Waits

   - Database File I/O

   - Table Statistics

   Important: To run those reports, the MySQL Enterprise Monitor Agent
   version must match the MySQL Enterprise Service Manager version.
   That is, if you are running MySQL Enterprise Service Manager 3.4.2,
   you must also run MySQL Enterprise Monitor Agent 3.4.2.
   (Bug #26307003)

* The MySQL User Account advisor in MySQL Enterprise Service Manager
   3.4.1 could not evaluate data from MySQL Enterprise Monitor Agents
   of version 3.4.0 or earlier.

* If MySQL Enterprise Monitor Agents were upgraded before the MySQL
   Enterprise Service Manager, under certain circumstances they
   disconnected and threw serialization errors.

   It is strongly recommended that you upgrade your agents after
   upgrading your MySQL Enterprise Service Manager. MySQL Enterprise
   Service Manager and MySQL Enterprise Monitor Agent should be the
   same version.

Functionality Added or Changed

* The following advisors were removed and their functionality added to
   the MySQL User Account:

   - Non-root User Has GRANT Privileges On All Databases

   - Non-root User Has Server Admin Privileges

   - Account Has Strong MySQL Privileges

   For more information, see MySQL User Account. (Bug #26130781)

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

* As of this release, if you are using a MySQL Server repository other
   than the installation bundled with the MySQL Enterprise Service
   Manager installation, the installer checks the MySQL Server for the
   following, minimum requirements:

   - MySQL Server version: versions older then MySQL 5.7.9 are not

   - SSL: SSL must be enabled on the MySQL Server.

   - innodb_file_format: innodb_file_format must be barracuda.

   - innodb_file_per_table: innodb_file_per_table must be enabled.

   If any of those checks fail, the installer displays an error and
   cannot proceed until the configuration is corrected.

   The upgrade process performs the same checks.

   To check your repository is correctly configured, the MySQL
   Enterprise Service Manager's configuration utility is extended with
   the parameter --mysql-check-requirements.

   For more information, see Service Manager Configuration Utilities.

Bugs Fixed

* It was not possible to install the MySQL Enterprise Service Manager
   on Solaris due to a missing file, (Bug #26336679)

* The MySQL Enterprise Service Manager upgrade installer did not check
   the version of the MySQL server used as the repository. If the
   repository version was less than 5.7.9, the upgrade completed, but
   MySQL Enterprise Service Manager did not behave as expected.

   As of this release, the MySQL Enterprise Service Manager upgrade
   package requires MySQL server 5.7.9, or later, and will not install
   if the version is lower than 5.7.9. (Bug #25953683)

* Validation messages were not displayed on the Settings page after a
   successful change was made.
MySQL Enterprise Monitor 3.4.2 has been releasedandy bang5 Jul