Functionality added or changed:
Added the INFORMATION_SCHEMA ENGINES
table.
Added the INFORMATION_SCHEMA PLUGINS
table
and the SHOW PLUGIN
statement.
Added the binlog_format
system variable
that controls whether to use row-based or statement-based
binary logging. Added the --binlog-format
and
--binlog-row-event-max-size
server options
for binary logging control. See
Abschnitt 6.3, „Zeilenbasierte Replikation“.
Plugins now can have status variables that are displayed in
the output from SHOW STATUS
.
Added the XML functions ExtractValue()
and
UpdateXML()
.
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 Abschnitt 12.9, „XML-Funktionen“.
Added the --base64-output
option 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.
Added the --port-open-timeout
option 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)
Two new Hungarian collations are included:
utf8_hungarian_ci
and
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; this issue will be fixed in a future release.
Bugs fixed:
InnoDB
: An UPDATE
statement with no index column in the WHERE
condition locked all the rows in the table. (Bug#3300)
INSERT DELAYED
caused
mysqld to crash. (Bug#16095)
The output of mysqldump --triggers did not
contain the DEFINER
clause in dumped
trigger definitions. (Bug#15110)
The output of SHOW TRIGGERS
contained
extraneous whitespace. (Bug#15103)
An INSERT ... SELECT
statement between
tables in a MERGE
set can return errors
when statement involves insert into child table from merge
table or vice-versa. (Bug#5390)
A COMMIT
statement followed by a
ALTER TABLE
statement on a BDB table caused
server crash. (Bug#14212)
InnoDB
: Comparison of indexed
VARCHAR CHARACTER SET ucs2 COLLATE ucs2_bin
columns using LIKE
could fail. (Bug#14583)
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)
Issuing a DROP USER
command could cause
some users to encounter a
error. (Bug#15775)
hostname
is not allowed to
connect to this MySQL server
The --plugin_dir
option was not working. Also
fix error with specifying parser name for fulltext. (Bug#16068)
Attempting to insert into a table partitioned by
LIST
a 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 v
, where
v
is the out-of-range value. (Bug#15819)
Dies ist eine Übersetzung des MySQL-Referenzhandbuchs, das sich auf dev.mysql.com befindet. Das ursprüngliche Referenzhandbuch ist auf Englisch, und diese Übersetzung ist nicht notwendigerweise so aktuell wie die englische Ausgabe. Das vorliegende deutschsprachige Handbuch behandelt MySQL bis zur Version 5.1.