MySQL Enterprise Monitor 8.0.0 GA has been released

[Andy Bang]

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:

http://dev.mysql.com/doc/relnotes/mysql-monitor/8.0/en/news-8-0-0.html
(also included at the end of this note for convenience)

Highlights

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

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

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
#17731793)

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