Replication: Added the
binlog_formatsystem variable that controls whether to use row-based or statement-based binary logging. Added the
--binlog-row-event-max-sizeserver options for binary logging control. See Replication Formats.
--port-open-timeoutoption to mysqld to control how many seconds the server should wait for the TCP/IP port to become free if it cannot be opened. (Bug #15591)
A new statement,
BINLOG, is generated by mysqlbinlog to represent row-based events in binary log files. The statement argument, a base 64-encoded string, is decoded by the server to determine the data change indicated by the corresponding event.
Two new Hungarian collations are included:
ucs2_hungarian_ci. These support the correct sort order for Hungarian vowels. However, they do not support the correct order for sorting Hungarian consonant contractions; we expect to fix this issue in a future release.
Added the XML functions
ExtractValue()returns the content of a fragment of XML matching a given XPath expression.
UpdateXML()replaces the element selected from a fragment of XML by an XPath expression supplied by the user with a second XML fragment (also user-supplied), and returns the modified XML. See XML Functions.
--slaveoptions for mysqlslap.
INFORMATION_SCHEMA PLUGINStable and the
innodb_locks_unsafe_for_binlogis enabled or if the transaction isolation mode is
InnoDBcan use “semi-consistent” reads. This affects treatment by
UPDATEstatements for rows that are already locked by another transaction. If a row is locked,
InnoDBreturns the latest committed version to MySQL so that MySQL can determine whether the row matches the
WHEREcondition of the
UPDATE. If the row matches (must be updated), MySQL reads the row again and this time
InnoDBeither locks it or waits for a lock on it.
References: See also Bug #3300.
--base64-outputoption to mysqlbinlog to print all binary log entries using base64 encoding. This is for debugging only. Logs produced using this option should not be applied on production systems.
INSERT DELAYEDcaused mysqld to crash. (Bug #16095)
--plugin_diroption was not working. Specifying the parser name for full-text also did not work correctly. (Bug #16068)
Attempting to insert into a table partitioned by
LISTa value less than any specified in one of the table's partition definitions resulted in a server crash. In such cases, mysqld now returns ERROR 1500 (HY000): Table has no partition for value
vis the out-of-range value. (Bug #15819)
DROP USERstatement could cause some users to encounter a
hostnameis not permitted to connect to this MySQL server
The output of mysqldump --triggers did not contain the
DEFINERclause in dumped trigger definitions. (Bug #15110)
The output of
SHOW TRIGGERScontained extraneous whitespace. (Bug #15103)
Creating a trigger caused a server crash if the table or trigger database was not known because no default database had been selected. (Bug #14863)
InnoDB: Comparison of indexed
VARCHAR CHARACTER SET ucs2 COLLATE ucs2_bincolumns using
LIKEcould fail. (Bug #14583)
INSERT ... SELECTstatement between tables in a
MERGEset can return errors when statement involves insert into child table from merge table or vice-versa. (Bug #5390)
InnoDB: A semi-consistent read for an
UPDATEstatement with no index column in the
WHEREcondition locked all the rows in the table. (Bug #3300)