发布于 2014-10-19 00:32:48 | 162 次阅读 | 评论: 0 | 来源: 网友投递
MariaDB数据库
MariaDB基于事务的Maria存储引擎，替换了MySQL的MyISAM存储引擎，它使用了Percona的 XtraDB，InnoDB的变体，分支的开发者希望提供访问即将到来的MySQL 5.4 InnoDB性能。这个版本还包括了 PrimeBase XT (PBXT) 和 FederatedX存储引擎。
MariaDB 10.1.1-alpha 发布，此版本现已提供下载。
值得关注的更新内容如下：
Triggers can now be run on the slave for row-based events.
Default roles allow roles to be enabled automatically when a user connects.
InnoDB: merged the Facebook/Kakao defragmentation patch (use OPTIMIZE TABLE to defragment InnoDB tablespaces).
Performance Schema tables no longer use .frm files.
Galera is merged into MariaDB server, MariaDB 10.1.1 binaries automatically support Galera out of the box.
InnoDB: report progress of inplace alter table (Kakao patch).
Statements that exceed a certain execution time can now be aborted.
PREPARE statement now supports out parameters.
The engine_condition_pushdown optimizer_switch flag has been deprecated. Engine condition pushdown is now always enabled for all engines that support it.
New Information Schema table SYSTEM_VARIABLES shows for every system variable its session and global variable values as well as various metadata.
Information Schema plugins can now support SHOW and FLUSH statements. New statements in this release:
Two new columns added to the CLIENT_STATISTICS and USER_STATISTICS Information Schema tables (TOTAL_SSL_CONNECTIONS and MAX_STATEMENT_TIME_EXCEEDED).
MariaDB can execute UNION ALL without a temporary table. (MySQL 5.7 patch)
@@sql_log_slow is now a session variable, not global.
Merge with MariaDB 10.0.14
As per the MariaDB Deprecation Policy, this will be the last release of MariaDB 10.1 for both Ubuntu 13.10 "Saucy" and Mint 16 "Petra".
With the recent release of CentOS 7 and RHEL 7, we are pleased to now provide packages for both distributions. Instructions for how to enable the repositories can be found by visiting the "Installing MariaDB with YUM" page and the repository configuration tool.
更多内容请看更新日志。