发布于 2015-03-03 01:54:16 | 176 次阅读 | 评论: 0 | 来源: 网友投递
MariaDB数据库
MariaDB基于事务的Maria存储引擎，替换了MySQL的MyISAM存储引擎，它使用了Percona的 XtraDB，InnoDB的变体，分支的开发者希望提供访问即将到来的MySQL 5.4 InnoDB性能。这个版本还包括了 PrimeBase XT (PBXT) 和 FederatedX存储引擎。
MariaDB 今天发布两个更新版本，分别是 10.0.17 和 10.1.3 。
MariaDB基于事务的Maria存储引擎，替换了MySQL的MyISAM存储引擎，它使用了Percona的 XtraDB，InnoDB的变体，分支的开发者希望提供访问即将到来的MySQL 5.4 InnoDB性能。这个版本还包括了 PrimeBase XT (PBXT) 和 FederatedX存储引擎。
其中 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
mysqlbinlog --binlog-row-event-max-size support added (MDEV-6703)
详情请看 changelog.
而 10.1.3 版本改进内容包括：
Optimistic mode of in-order parallel replication (MDEV-6676) and two new associated system variables:
Enhanced semisync replication (MDEV-162)
Consistent support for IF EXISTS, IF NOT EXISTS, and OR REPLACE clauses:
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/