Oracle Enterprise Manager for MySQL Database includes support for the system and status variables added in MySQL 5.7.x. For more information on these variables, see What Is New in MySQL 5.7.
Metrics and Compliance Rules have been added for MySQL Enterprise Audit
Oracle Enterprise Manager for MySQL Database includes support for the variables and status counters of MySQL Enterprise Audit. For more information on these variables, see MySQL Enterprise Audit.
Metrics and Compliance Rules have been added for the MySQL Enterprise Firewall
The following MySQL Enterprise Firewall system and status variables are available:
For more information on these variables, see MySQL Enterprise Firewall.
As of this release, the Agent sets
sql_mode=NO_AUTO_CREATE_USERin addition to
NO_ENGINE_SUBSTITUTION. This is set to prevent repeated occurrences of the following error from MySQL 5.7.x:
Warning | 3129 | Unsetting sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be made read-only in a future release.
Section 1.1, “Prerequisites” listed
SUPERas one of the privileges required by the Oracle Enterprise Manager Agent.
SUPERis not required.
If a boolean attribute's value was not present, it was reported as False.
As of this release, if the value is not present, nothing is displayed.
No values were retrieved for
innodb_max_dirty_pages_pct_lwmvariables on MySQL 5.7.7, or higher. NaN was displayed instead.
The Slave Has Been Stopped metric reported that replication had stopped although replication was running normally.