Oracle Enterprise Manager for MySQL Database
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.
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:
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.
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.