MariaDB 10.1.4 发布,MySQL 衍生版
MariaDB 是一个采用 Aria 存储引擎的 MySQL 分支版本,是由原来 MySQL 的作者 Michael Widenius 创办的公司所开发的免费开源的数据库服务器。
与 MySQL 相比较,MariaDB 更强的地方在于:
-
Maria 存储引擎
-
PBXT 存储引擎
-
XtraDB 存储引擎
-
FederatedX 存储引擎
-
更快的复制查询处理
-
线程池
-
更少的警告和bug
-
运行速度更快
-
更多的 Extensions (More index parts, new startup options etc)
-
更好的功能测试
-
数据表消除
-
慢查询日志的扩展统计
-
支持对 Unicode 的排序
这是 MariaDB 10.1 的第二个 Beta 测试版本,也是第 5 个发行版本,该版本值得关注的改进内容包括:
-
Encryption: 很多跟表和表空间加密的改变在该版本得以实现,详情请看 updated documentation 和 nice summarization here
-
Consistent support for IF EXISTS, IF NOT EXISTS, and OR REPLACE clauses was added to:
-
New server variable: New server variable enforce_storage_engine
-
New status variable: New status variables to show the number of grants on different objects (Also see Status Variables Added in MariaDB 10.1)
-
New status variable: New status variables to track MASTER_GTID_WAIT time. This feature was contributed by Daniel Black.
-
New status variable: New status variable Slave_skipped_errors. This feature was contributed by Daniel Black.
-
Performance: xid cache scalability was significantly improved (by using lock-free hash)
-
Performance: VIEW definitions are now cached in memory (in the table definition cache)
-
Replication: Starting with this release, commits in certain instances in parallel replication complete immediately, avoiding losing throughput when many transactions need conflicting locks. See binlog_commit_wait_count.
完整改进记录:https://mariadb.com/kb/en/mariadb/mariadb-1014-changelog/