MySQL Enterprise Monitor 8.0.14 has been released

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.=20

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:=20
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=20

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

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

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

Download=20

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

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

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

http://edelivery.oracle.com/=20

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

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.=20

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.=20

Useful URLs=20

* My Oracle Support - http://support.oracle.com/=20
* What's New in 8.0 - =
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-comparison.html=20
* Change log - http://dev.mysql.com/doc/relnotes/mysql-monitor/8.0/en/=20=

* Installation documentation - =
http://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-installing.html=20
* Complete documentation - =
http://dev.mysql.com/doc/mysql-monitor/8.0/en/=20
* Product information - =
http://www.mysql.com/products/enterprise/monitor.html=20
* Download - http://support.oracle.com/ or http://edelivery.oracle.com/=20=


Thanks and Happy Monitoring!=20

- The MySQL Enterprise Tools Development Team=20

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20

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 =3D INNODB
  default_tmp_storage_engine =3D INNODB
  event_scheduler =3D ON
  explicit_defaults_for_timestamp =3D 1
  sql-mode =3D =
STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
  innodb_file_format =3D Barracuda
  innodb_file_per_table
  innodb_support_xa =3D 0
  innodb_adaptive_flushing =3D 1
  innodb_locks_unsafe_for_binlog =3D 1
  skip-external-locking
  local-infile =3D 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=3DON=20
=20
* 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 Announce Mailing List
For list archives: http://lists.mysql.com/announce
To unsubscribe:    http://lists.mysql.com/announce