A.11 Changes in Oracle Enterprise Manager for MySQL Database 12.1.0.3.0 (2015-10-22)

Functionality Added or Changed

• 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 https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html.

• 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:

  • System Variables:

    • mysql_firewall_max_query_size

    • mysql_firewall_mode

    • mysql_firewall_trace

  • Status Variables:

    • Firewall_access_denied

    • Firewall_access_granted

    • Firewall_cached_entries

  For more information on these variables, see MySQL Enterprise Firewall.

Bugs Fixed

• As of this release, the Agent sets sql_mode=NO_AUTO_CREATE_USER in addition to STRICT_TRANS_TABLES and 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.

• Bug #21127348

  Section 1.1, “Prerequisites” listed SUPER as one of the privileges required by the Oracle Enterprise Manager Agent. SUPER is 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 and innodb_max_dirty_pages_pct_lwm variables 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.