Functionality Added or Changed
Added four new InnoDB graphs: InnoDB Row Lock Time (the total time spent acquiring row locks), InnoDB Row Lock Time Statistics (the average and maximum time spent acquiring row locks), and InnoDB Row Lock Wait (the number of times a row lock had to be waited for), and InnoDB Redo Log Checkpoint Lag (tracks both flush and checkpoint differences against the maximum log file size). (Bug #13855084, Bug #13855055, Bug #13854527)
Added four new prepared statement graphs: Prepared Statement SQL, Prepared Statement API, Prepared Statement API Invalidations (stmt_reprepare), and Prepared Statement Utilization (Open/Max).
differ in that there are two forms of prepared statements. Those
within SQL, such as
"PREPARE ...; EXECUTE ...;
DEALLOCATE PREPARE ...;", and those using the protocol
API, such as
innodb_log_checkpoint_lsn64 data collection
items, which are 64-bit variants of their *_lsn counterparts.
property was added to the Connector/J plugin, and defaults to
Added a Query Cache Fragmentation advisor and graph. (Bug #13743414)
The bundled MySQL version has been upgraded to version 5.5.21. The previous version was 5.1.56.
Note: On Linux, MySQL Server 5.5.10 and greater depends on the
libaio library being available on the server.
Therefore, this dependency affects the bundled MySQL Server.
Solaris, Windows, and Mac OS X enable AIO functionality by
Added several new error log entries.
message level entries: Failed and
accepted authentications, and connections to MEM servers.
debug level entries: HTTP traffic, both
requests and responses.
(Bug #51773, Bug #11759454)
On FreeBSD, the GUI version of the installer no longer supports
X Windows GUI is still supported,
and is the new default type.
NUM() functions were added to the expression
The "Query Cache Has Sub-Optimal Hit Rate" rule would trigger a critical alert when more than 25% of the cache was free, instead of when more than 25% of the cache was used. (Bug #13921932)
The Installer/Updater would emit a warning when the required
libaio was not detected, but it would
continue with the incomplete installation. It now prompts to
enter the path, and the unattended installer exits with an
The MySQL Enterprise Backup temporary table
mysql.ibbackup_binlog_marker is now excluded
from the "User Has Rights To Table That Does Not Exist" advisor.
InnoDB Row Lock Detail graph was updated
to work properly with MySQL Server 5.5+.
JSON variants of the diagnostic
information was removed from the downloadable package generated
by Manage Servers, Support
The Update script would not update properly if a non-bundled version of MySQL was used previously, and a version configured as localhost or 127.0.0.1. (Bug #13847215)
The "Excessive Number of Long Running Processes" rule was updated to ignore replication threads, as binlog dump entries are now ignored. (Bug #13841872)
The Query Analyzer plugin would fail to load with
useInformationSchema=true was used in the
JDBC connection URL.
When an agent is used along with MySQL Enterprise Agent Proxy Service, the
LOAD DATA LOCAL INFILE statement could cause
memory exhaustion with large files, due to the entire file/query
being buffered before execution.
Updated the "
Query Cache Not Enabled"
description, along with its associated advice. The new suggested
size is "
query_cache_size = 32M" instead of
query_cache_size = 25% of total RAM."
It was not possible to delete multiple servers within the
Manage Servers dashboard. Attempting to do so
would result in an error.
When performing an update install of the Agent on a 2.3+
MySQL Enterprise Monitor release, the
agent-instance.ini ini files are now fully
preserved during the update, which includes custom comments and
options. Updating from a 2.2 or earlier MySQL Enterprise Monitor release will
behave as done previously, which is to only preserve known
(Bug #13650743, Bug #13583872)
When using the Japanese locale, zooming into any graph with
All Servers" set would emit an unreadable
When using the Japanese locale, requesting a report via
diagnostics, would produce a broken link to the
Line endings (such as
\n) are now stripped
from logged ssh keygen errors. The
level continues to include the unstripped ssh stdout messages.
On Microsoft Windows, the
gspawn-win32-helper-console tool would fail
On Mac OS X, if
ssh-keygen fails with an
error message to stdout, then the exit code was not honored. In
now functions properly.
During the initial discovery of a server, MySQL Enterprise Monitor would emit a
Upgrading MySQL Enterprise Monitor could create a broken .ini file, by removing
the host from certain ini settings. For example, it would change
aggr-ssl-address = 127.0.0.1:3357 into
aggr-ssl-address=:3357. Affected ini settings
Sorting the Manage Servers page by Agent would sometimes result in an unhandled exception. (Bug #13335253)
On Mac OS X 10.6, the Agent did not use
launchd correctly and would crash in
(Bug #12768198, Bug #13738592)
The Installer/Upgrader would not back up all files. The mechanism that chooses which files are backed up has changed from a whitelist to a blacklist. (Bug #12678942)
With Internet Explorer 8.0, the bullet list on the left side of the "What's New?" page would be hidden.