Functionality Added or Changed
Upgrading from an
Advanced GPL RPM package to
Advanced RPM package did not work. Now on
Linux it is possible to use rpm -U to replace
any installed MySQL product by any other of the same release
family. It is not necessary to remove the old produce with
rpm -e first.
The process of deallocating the
Index was made faster, during shutdown or when turning
off the AHI with the statement:
SET GLOBAL innodb_adaptive_hash_index=OFF;
(Bug #13006367, Bug #62487)
This fix improves the performance of instrumentation code for
InnoDB buffer pool operations.
(Bug #12950803, Bug #62294)
buffer pool management
code was optimized for handling pages from
compressed tables. This
fixes a slowdown that could occur particularly during the
warmup period for the buffer
(Bug #12610930, Bug #61341)
Fixed a compilation problem that affected the
InnoDB source code with
gcc 4.6.1. The affected
InnoDB source file was
InnoDB: Lookups using secondary indexes could give incorrect matches under a specific set of conditions. The conditions involve an index defined on a column prefix, for a BLOB or other long column stored outside the index page, with a table using the Barracuda file format. (Bug #12601439, Bug #12543666)
UPDATE statement for an
InnoDB table could hang. The issue affects
tables using the Barracuda
file format and having multiple indexes on
column prefixes. The
size of an undo log record
could exceed the page
size, even though the total size of the column prefixes
was less than the page size (usually 16KB). In MySQL 5.5 and
higher, this error is now reported using the new code
ER_UNDO_RECORD_TOO_BIG. In MySQL
5.1 with the InnoDB Plugin, this error is reported using the
This fix corrects cases where the MySQL server could hang or
abort with a
long semaphore wait message.
(This is a different issue than when these symptoms occurred
CHECK TABLE statement.)
(Bug #11766591, Bug #59733)
A timing issue could cause a crash while processing the
SHOW ENGINE INNODB STATUS command. This issue
only affected debug builds of the server.
(Bug #11766546, Bug #59682)
Replication: Issuing the following statements, in the order shown, could cause a deadlock between the user thread and I/O thread:
START SLAVE; STOP SLAVE SQL_THREAD; START SLAVE;
References: See also Bug #44312, Bug #11752963, Bug #38715, Bug #38716.
Internal conversion of zero to binary and back could yield a result with incorrect precision. (Bug #12911710)
Valgrind warnings generated by
operations were fixed.
Several improvements were made to the
library bundled with MySQL distributions, and that is available
for all platforms that MySQL supports except Windows.
Navigation keys did not work for UTF-8 input.
Word navigation and delete operations did not work for UTF-8 input with Cyrillic characters.
Nonlatin characters were corrupted in overwrite mode for UTF-8 input.
Long queries caused the statement history file to become corrupted.
The Alt key caused history operations to fail.
(Bug #12605400, Bug #12613725, Bug #12618092, Bug #12624155, Bug #12617651, Bug #12605388)
decimal_round() could cause a server exit
when processing long numeric strings.
With Valgrind enabled,
semaphore wait timeouts were too low and could expire.
An assertion designed to detect zero-length sort keys also was raised when the entire key set fit in memory. (Bug #58200, Bug #11765254)
myisampack could create corrupt
FULLTEXT indexes when compressing tables.
(Bug #53646, Bug #11761180)
If MySQL was configured with
--with-plugin-innodb_plugin, to suppress
building the built-in InnoDB storage engine and build the InnoDB
Plugin instead, the innochecksum utility was
(Bug #47337, Bug #11755544)
A linking problem prevented the
FEDERATED storage engine plugin
(Bug #40942, Bug #11750417)
On Fedora, certain accesses to
/var/lib/mysql/HOSTNAME.err were blocked by
SELinux policy, which made the server fail at startup with the
Manager of pid-file quit without updating
(Bug #37165, Bug #12927740)
FEDERATED tables, loss of
connection to the remote table during some insert operations
could cause a server crash.
(Bug #34660, Bug #11747970)