A.9 Changes in Oracle Enterprise Manager for MySQL Database 13.2.1.0.0 (2018-02-02)

Important

This version requires the Oracle Enterprise Manager Extensibility Development Kit 13.2.0.0.

Functionality Added or Changed

• The User Interface was upgraded from Adobe Flash to Oracle JavaScript Extension Toolkit (JET).

• Query Analyzer is added in this release. This report provides a point-in-time snapshot of queries on the monitored database. For more information, see Section 4.1, “Query Analyzer”.

• The configuration metric, Sys Schema, is added in this release.

  This metric contains the version number of the sys schema installed on the monitored server.

• The following new metrics rely on sys schema. To use them, sys schema 1.5.1, or higher, must be installed on the monitored MySQL server.

  • sys schema Configuration Metric.

  • Sys Schema InnoDB Row Lock Waits : based on the innodb_lock_waits view. For more information, see Section 6.32, “Sys Schema InnoDB Row Lock Waits Metrics”.

  • Sys Schema IO By Host: based on the host_summary_by_file_io view. For more information, see Section 6.33, “Sys Schema IO By Host Metrics”.

  • Sys Schema IO By Thread By Latency: based on the io_by_thread_by_latency sys schema view. For more information, see Section 6.34, “Sys Schema IO By Thread By Latency Metrics”.

  • Sys Schema IO Global By File By Latency: based on the io_global_by_file_by_latency sys schema view. For more information, see Section 6.35, “Sys Schema IO Global By File By Latency Metrics”.

  • Sys Schema IO Global By Wait By Latency: based on the io_global_by_wait_by_latency sys schema view. For more information, see Section 6.36, “Sys Schema IO Global By Wait By Latency Metrics”.

  • Processes: based on the processlist sys schema view. For more information, see Section 6.37, “Sys Schema Processes Metrics”.

  • Sys Schema Statement Analysis: based on the statement_analysis sys schema view. For more information, see Section 6.38, “Sys Schema Statement Analysis by First Time Seen Metrics”.

  • Sys Schema Table Metadata Lock Waits: based on the schema_table_lock_waits sys schema view. For more information, see Section 6.41, “Sys Schema Table Metadata Lock Waits Metrics”.

  • Sys Schema Table Statistics: based on the schema_table_statistics sys schema view. For more information, see Section 6.42, “Sys Schema Table Statistics Metrics”.

  • Sys Schema User Statistics: based on the user_summary sys schema view. For more information, see Section 6.43, “Sys Schema User Statistics Metrics”.

  • Sys Schema Global Memory Usage: based on the memory_global_by_current_bytes sys schema view. For more information, see Section 6.31, “Sys Schema Global Memory Usage Metrics”.

Bugs Fixed

• Bug #25236136

  Database connections were not properly closed.

• Bug #26950052

  The advice text for the Prepared Statements Not Being Used Effectively metric incorrectly referred to the variables Com_stmt_prepare and Com_stmt_execute. The correct variables are Com_prepare_sql and Com_execute_sql.