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/