详情请看 changelog.
-
Consistent support for IF EXISTS, IF NOT EXISTS, and OR REPLACE clauses:
-
DROP ROLE (MDEV-7288)
-
DROP USER (MDEV-7288)
-
CREATE DATABASE (MDEV-7280)
-
CREATE FUNCTION UDF (MDEV-7283)
-
CREATE ROLE (MDEV-7288)
-
CREATE SERVER (MDEV-7285)
-
CREATE USER (MDEV-7288)
-
CREATE VIEW (MDEV-7283)
-
These statements now also support IF NOT EXISTS and OR REPLACE:
-
These statements now support IF EXISTS:
-
InnoDB/XtraDB Page compression now supports snappy compression method
-
Dump Thread Enhancements from Google (MDEV-7257)
-
The wsrep_dirty_reads system variable for permitting dirty Galera reads.
-
new read-only server variable version_ssl_library that shows the version of currently used SSL library.
-
new command-line option --getopt-prefix-matching that makes it possible to disable historical "unambiguous prefix" matching in the command-line option parsing.
-
INFORMATION_SCHEMA.APPLICABLE_ROLES table has a new IS_DEFAULT column (MDEV-6918). See SET DEFAULT ROLE.
-
INFORMATION_SCHEMA.VIEWS table has a new ALGORITHM column (MDEV-6731).
-
Improved concurrency: table definition cache now has lock-free implementation completely avoiding any global locks.
-
EXPLAIN FORMAT=JSON now supports and prints more optimizations (range+MRR, "range checked for each record", full scan on NULL key, expensive constants, etc)