#JetBrains 六折贺新春!IntelliJ IDEA,PyCharm,WebStorm,PhpStorm 优惠!
MariaDB 今天发布两个更新版本,分别是 10.0.17 和 10.1.3 。
其中 10.0.17 值得关注的改进内容有:
InnoDB updated to 5.6.23
XtraDB updated to 5.6.22-72.0
TokuDB updated to 7.5.5
mroonga updated to 5.0
Spider updated to 3.2.18
Connect updated to 1.03.0005
HeidiSQL updated to 9.1 ( MDEV-7290 )
--galera-sst-mode
option removed from mysqldump ( MDEV-7615 )
mysqlbinlog --binlog-row-event-max-size
support added ( MDEV-6703 )
详情请看 changelog .
而 10.1.3 版本改进内容包括:
Table and Tablespace Encryption .
Optimistic mode of in-order parallel replication ( MDEV-6676 ) and two new associated system variables:
slave_parallel_mode
skip_parallel_replication
Enhanced semisync replication ( MDEV-162 )
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)
下载地址: https://blog.mariadb.org/mariadb-10-0-17-and-10-1-3-now-available/