MySQL Enterprise Monitor 8.0.14 has been released

[Airton Lastori]

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:
http://dev.mysql.com/doc/relnotes/mysql-monitor/8.0/en/news-8-0-14.html (also included at the end of this note for convenience).

Highlights

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

Download

You will find binaries for the new release on My Oracle Support:
http://support.oracle.com

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:
http://edelivery.oracle.com/

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 http://www.mysql.com/trials, or contact Sales at http://www.mysql.com/about/contact.

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 - http://support.oracle.com/
* What's New in 8.0 - https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-comparison.html
* Change log - http://dev.mysql.com/doc/relnotes/mysql-monitor/8.0/en/
* Installation documentation - http://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-installing.html
* Complete documentation - http://dev.mysql.com/doc/mysql-monitor/8.0/en/
* Product information - http://www.mysql.com/products/enterprise/monitor.html
* Download - http://support.oracle.com/ or http://edelivery.oracle.com/

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


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
sql-mode = STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
innodb_file_format = Barracuda
innodb_file_per_table
innodb_support_xa = 0
innodb_adaptive_flushing = 1
innodb_locks_unsafe_for_binlog = 1
skip-external-locking
local-infile = 0
skip-symlink
performance_schema

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

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

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:

performance_schema_consumer_events_statements_history_long=ON

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