A.5 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

• The Binary Log Automatically Removed Too Quickly compliance rule, part of the MySQL Administration Standard rules, was updated to use binlog_expire_logs_seconds instead of the deprecated expire_logs_days.

• The following metrics were added to InnoDB Fulltext Configuration configuration metric:

  • Enable Diag Print for innodb_ft_enable_diag_print

  • Result Cache Limit for innodb_ft_result_cache_limit

  • Total Cache Size for innodb_ft_total_cache_size

  For more information, see Section 7.14, “InnoDB Fulltext Configuration Metrics”.

• Several Database File I/O dashboards were added:

  • Database File I/O By Host

  • Database File I/O By Thread

  • Database File I/O By File

  • Database File I/O By Type

• A Memory Usage dashboard was added in this release. For more information, see Section 4.2, “Memory Usage”.

• A Database Processes dashboard was added in this release. For more information, see Section 3.1, “Database Processes”.

• A Table Statistics dashboard was added in this release. For more information, see Section 5.6, “Per Table Statistics”.

• A User Statistics dashboard was added in this release. For more information, see Section 5.7, “Per User Statistics”.

• A InnoDB Row Lock Waits dashboard was added in this release. For more information, see InnoDB Row Lock Waits.

• A Table Metadata Lock Waits dashboard was added in this release. For more information, see Table Metadata Lock Waits.

• The Query Cache metrics and graphs are removed in this release. Query Cache is deprecated in MySQL 5.7 and is not present in MySQL 8.0.

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.