Oracle Enterprise Manager for MySQL Database 13.2.1.0.0 has been released

[Andy Bang]

Dear MySQL users,

The MySQL development team is pleased to announce that the fifth
release of Oracle Enterprise Manager for MySQL Database is now
Generally Available (GA).

Oracle Enterprise Manager for MySQL Database is the official MySQL
plug-in that provides comprehensive performance, availability, and
configuration information for Oracle's integrated enterprise IT
management product line, Oracle Enterprise Manager (13c or later).

This is a maintenance release that includes a few enhancements and
fixes a number of bugs. You can find more information on the contents
of this release in the change log:

https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-changelog-13-2-1-0-0.html
(also included at the end of this note for convenience)

Use Self-Update to deploy Oracle Enterprise Manager for MySQL Database
13.2.1.0.0, or use My Oracle Support to download and install manually:

https://support.oracle.com

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

Packages are also be available on the Oracle Software Delivery Cloud.

Please open a ticket on My Oracle Support to report problems, request
features, or give us general feedback about how this release meets
your needs.

All the best!

- The MySQL Enterprise Tools Development Team

Useful URLs

* My Oracle Support - http://support.oracle.com/
* Installation documentation - http://dev.mysql.com/doc/mysql-em-plugin/en/myoem-installation-reference.html
* Complete documentation - http://dev.mysql.com/doc/mysql-em-plugin/en/index.html
* Product information - https://www.mysql.com/products/enterprise/em.html
* Release Notes - https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-release-notes.html

Changes in Oracle Enterprise Manager for MySQL Database 13.2.1.0.0

Functionality Added or Changed

* IMPORTANT: This version requires the Oracle Enterprise Manager
Extensibility Development Kit 13.2.0.0.

* The User Interface was upgraded from Adobe Flash to Oracle
JavaScript Extension Toolkit (JET).

* Query Analyzer is added in this release. This report provides a
point-in-time snapshot of queries on the monitored database. For
more information, see Section 3.1, "Query Analyzer".

* The configuration metric, Sys Schema, is added in this release.

This metric contains the version number of the sys schema installed
on the monitored server.

* The following new metrics rely on sys schema. To use them, sys
schema 1.5.1, or higher, must be installed on the monitored MySQL
server.

- sys schema Configuration Metric.

- Sys Schema InnoDB Row Lock Waits : based on the innodb_lock_waits
view. For more information, see Section 4.30, "Sys Schema InnoDB
Row Lock Waits Metrics".

- Sys Schema IO By Host: based on the host_summary_by_file_io view.
For more information, see Section 4.31, "Sys Schema IO By Host
Metrics".

- Sys Schema IO By Thread By Latency: based on the
io_by_thread_by_latency sys schema view. For more information, see
Section 4.32, "Sys Schema IO By Thread By Latency Metrics".

- Sys Schema IO Global By File By Latency: based on the
io_global_by_file_by_latency sys schema view. For more
information, see Section 4.33, "Sys Schema IO Global By File By
Latency Metrics".

- Sys Schema IO Global By Wait By Latency: based on the
io_global_by_wait_by_latency sys schema view. For more
information, see Section 4.34, "Sys Schema IO Global By Wait By
Latency Metrics".

- Processes: based on the processlist sys schema view. For more
information, see Section 4.35, "Sys Schema Processes Metrics".

- Sys Schema Statement Analysis: based on the statement_analysis sys
schema view. For more information, see Section 4.36, "Sys Schema
Statement Analysis Metrics".

- Sys Schema Table Metadata Lock Waits: based on the
schema_table_lock_waits sys schema view. For more information, see
Section 4.37, "Sys Schema Table Metadata Lock Waits Metrics".

- Sys Schema Table Statistics: based on the schema_table_statistics
sys schema view. For more information, see Section 4.38, "Sys
Schema Table Statistics Metrics".

- Sys Schema User Statistics: based on the user_summary sys schema
view. For more information, see Section 4.39, "Sys Schema User
Statistics Metrics".

- Sys Schema Global Memory Usage: based on the
memory_global_by_current_bytes sys schema view. For more
information, see Section 4.29, "Sys Schema Global Memory Usage
Metrics".

Bugs Fixed

* Database connections were not properly closed. Bug #25236136

* The advice text for the Prepared Statements Not Being Used
Effectively metric incorrectly referred to the variables
Com_stmt_prepare and Com_stmt_execute. The correct variables are
Com_prepare_sql and Com_execute_sql. Bug #26950052