Functionality Added or Changed
Added the innodb_log_sequence_lsn64
innodb_log_flushed_lsn64
innodb_log_checkpoint_lsn64 data collection
items, which are 64-bit variants of their *_lsn counterparts.
(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).
The SQL and API variants
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 "mysql_stmt_init(...);
mysql_stmt_prepare(...); mysql_stmt_execute(...),
mysql_stmt_fetch(...); mysql_stmt_close(...);".
(Bug #13854916)
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 a Query Cache Fragmentation advisor and graph. (Bug #13743414)
The
mysqlenterprise.disableSourceLocation
property was added to the Connector/J plugin, and defaults to
false.
(Bug #13789241)
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
default.
(Bug #13599824)
Added the following configuration options: proxy-connect-timeout, proxy-read-timeout, and proxy-write-timeout. (Bug #13332197)
Added several new error log entries.
New message level entries: Failed and
accepted authentications, and connections to MEM servers.
New debug level entries: HTTP traffic, both
requests and responses.
(Bug #51773, Bug #11759454)
Bugs Fixed
On FreeBSD, the GUI version of the installer no longer supports
GTK. The X Windows GUI is still supported,
and is the new default type.
(Bug #13974672)
The LEFT(), RIGHT() and
NUM() functions were added to the expression
parser.
(Bug #13958008)
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 MySQL Enterprise Backup temporary table
mysql.ibbackup_binlog_marker is now excluded
from the "User Has Rights To Table That Does Not Exist" advisor.
(Bug #13874149)
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
error.
(Bug #13875287)
The "Excessive Number of Long Running Processes" rule was updated to ignore replication threads, as binlog dump entries are now ignored. (Bug #13841872)
The InnoDB Row Lock Detail graph was updated
to work properly with MySQL Server 5.5+.
(Bug #13855055)
The JSON variants of the diagnostic
information was removed from the downloadable package generated
by Manage Servers, Support
Diagnostics.
(Bug #13851543)
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.
(Bug #13795425)
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 Query Analyzer plugin would fail to load with
Connector/J when
useInformationSchema=true was used in the
JDBC connection URL.
(Bug #13807492)
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."
(Bug #13743390)
It was not possible to delete multiple servers within the
Manage Servers dashboard. Attempting to do so
would result in an error.
(Bug #13723310)
On Microsoft Windows, the
gspawn-win32-helper-console tool would fail
to install.
(Bug #13645684)
When performing an update install of the Agent on a 2.3+
MySQL Enterprise Monitor release, the
mysql-monitor-agent.ini and
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
ini+value pairs.
(Bug #13650743, Bug #13583872)
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
were aggr-ssl-address,
aggr-address, and
proxy-address.
(Bug #13626844)
During the initial discovery of a server, MySQL Enterprise Monitor would emit a
ServerDoesNotExistException exception.
(Bug #13632006)
When using the Japanese locale, requesting a report via
Manage Servers, support
diagnostics, would produce a broken link to the
report.
(Bug #13646277)
Line endings (such as \n) are now stripped
from logged ssh keygen errors. The debug log
level continues to include the unstripped ssh stdout messages.
(Bug #13645718)
On Mac OS X, if ssh-keygen fails with an
error message to stdout, then the exit code was not honored. In
other words,
--agent-ssh-keygen-retry
now functions properly.
(Bug #13644842)
When using the Japanese locale, zooming into any graph with
"All Servers" set would emit an unreadable
graph title.
(Bug #13648133)
The recently (2.3.9) introduced --agent-ssh-keygen-attempts and --agent-ssh-keygen-retry options did not function properly, but now work with all operating systems. (Bug #13392272)
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
Gestalt.
(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.
