Oracle Enterprise Manager for MySQL Database User's Guide  /  Oracle Enterprise Manager for MySQL Database Release Notes  /  Changes in Oracle Enterprise Manager for MySQL Database 13.2.4.0.0 (2018-10-12)

A.2 Changes in Oracle Enterprise Manager for MySQL Database 13.2.4.0.0 (2018-10-12)

Important

As of this release, 13.2.4.0.0, MySQL 8 is supported. It is not possible to monitor MySQL 8 with earlier versions of Oracle Enterprise Manager for MySQL Database.

For more information on the variables added and removed in MySQL 8, see Server and Status Variables and Options Added, Deprecated, or Removed in MySQL 8.0

The following metrics were added for MySQL 8 support:

  • Sys Schema Table Metadata Lock Waits replaces the Table Metadata Lock Waits metric.

The following metrics were updated for MySQL 8 support:

  • Instance Activity: the following was added:

    • ACL Cache Items Count

  • Performance Schema Activity: the following was added:

    • Session Connect Attrs Longest Seen (Delta)

  • Sys Schema Activity: the following was added:

    • Current Memory

    • Progress

  • Sys Schema Statement Analysis: the following was added:

    • Rows Affected Avg

    • Rows Examined Avg

    • Rows Sent Avg

The following configuration metrics were added for MySQL 8 support:

  • Data Dictionary

  • Information Schema

The following configuration metrics were updated for MySQL 8 support:

  • Binary Logs: the following were added:

    • Binlog Expire Logs Seconds

    • Binlog Row Metadata

    • Binlog Row Value Options

    • Binlog Transaction Dependency History Size

    • Binlog Transaction Dependency Tracking

  • Environment: the following were added:

    • Persisted Globals Load Enabled

  • InnoDB Configuration: the following were added:

    • Dedicated Server Enabled

    • Print DDL Logs Enabled

    • Redo Log Encrypt Enabled

    • Scan Directories

    • Temp Dir

    • Undo Log Encrypt Enabled

  • InnoDB Fulltext: the following were added:

    • Enable Diag Print

    • Result Cache Limit

    • Total Cache Size

  • Logging: the following was added:

    • Log Error Services

  • MySQL Instance Activity: the following was added:

    • ACL Cache Items Count

  • Optimizer: the following were added:

    • Histogram Generation Max Mem Size

    • Windowing Use High Precision Enabled

  • Performance Schema: the following were added:

    • Error Size

    • Max Digest Sample Age

  • Security: the following were added:

    • Activate All Roles On Login Enabled

    • Caching Sha2 Password Private Key Path

    • Caching Sha2 Password Public Key Path

    • Mandatory Roles

    • Password History

    • Password Reuse Interval

  • Statement Processing: the following were added:

    • CTE Max Recursion Depth

    • Internal Tmp Mem Storage Engine

    • Temptable Max Ram

The Compliance rule, InnoDB Strict Mode is Off was also updated for MySQL 8. In previous versions, this rule checked the ignore_builtin_innodb variable, which is deprecated in MySQL 8.

Functionality Added or Changed

Bugs Fixed

  • Bug #27845235

    Line returns defined by /r were not correctly parsed.

  • InnoDB Configuration Configuration Metrics did not include the Temp Dir metric for innodb_tmpdir.

  • It was not possible to monitor a MySQL database target if the user's password included an equals sign (=). Access was denied.

  • The following attributes were not included in the Query Analyzer dashboard:

    • Rows Affected Avg

    • Rows Examined Avg

    • Rows Sent Avg

    The following attributes were not included in the Processes dashboard:

    • Current Memory

    • Progress

  • Bug #27739130

    Under certain circumstances a connection settings issue resulted in the following error: CONNECTION SETTINGS DOES NOT DEFINE A SUPER USER.