发布于 2014-07-01 00:29:42 | 195 次阅读 | 评论: 0 | 来源: 网友投递
MariaDB数据库
MariaDB基于事务的Maria存储引擎，替换了MySQL的MyISAM存储引擎，它使用了Percona的 XtraDB，InnoDB的变体，分支的开发者希望提供访问即将到来的MySQL 5.4 InnoDB性能。这个版本还包括了 PrimeBase XT (PBXT) 和 FederatedX存储引擎。
MariaDB 10.1.0 发布了首个 Alpha 版本，该版本值得关注的改进包括：
InnoDB/XtraDB
MDEV-6075, Allow > 16K pages on InnoDB - InnoDB now allows page size to be configured as 16K, 32K and 64K. Note that single row size must be < 16K. This feature will allow especially more blob columns to be created.
MDEV-5335, Force PK option - Added a new dynamic configuration variable innodb_force_primary_key default off. If option is true, create table without primary key or unique key where all keyparts are NOT NULL is not accepted. Instead an error message is printed. Variable value can be changed with set global innodb_force_primary_key = <value>.
Security
MDEV-5730, enhance security using special compilation options - MariaDB is now compiled with security hardening options by default. It is an additional protection layer that makes new, yet unknown, security vulnerabilities more difficult to exploit.
Storage Engine functionality
MDEV-6107, merge default_tmp_storage_engine - Added default_tmp_storage_engine server variable and the command line option.
MDEV-4260, Don't create frm files for temporary tables - Temporary tables no longer create frm files on disk. Which means that if the temporary table is created in MEMORY engine, it will not touch the disk at all.
Replication
MDEV-5095, Executing triggers on slave in row-based replication - The server has a new command-line option --slave-run-triggers. When slave-run-triggers=yes, execution of row-based events by the slave SQL thread will cause triggers to be invoked. Triggers will be invoked for each row inserted, updated, or deleted. If a trigger fails with an error, replication will stop with an error.
Optimizer
MDEV-406, ANALYZE $stmt - Check how close the optimizer's estimates about the query plan are to the reality. See https://mariadb.com/kb/en/analyze-statement/
Administration
MDEV-6248, GUI-friendly cmake options to enable/disable plugins - MariaDB now uses PLUGIN_xxx cmake options to enable or disable plugins, not a combination of WITH_xxx, WITHOUT_xxx, WITH_PLUGINX_xxx, WITHOUT_PLUGIN_xxx, WITH_xxx_STORAGE_ENGINE, WITHOUT_xxx_STORAGE_ENGINE. See https://mariadb.com/kb/en/specifying-what-plugins-to-build/
Improvements from WebScaleSQL
MDEV-6314 - Compile/run MariaDB with ASan (fixed in 10.0.13)
MDEV-6315 - TokuDB: ERROR: AddressSanitizer: attempting to call malloc_usable_size() for pointer which is not owned: 0x601200008f80 (not fixed)
MDEV-6323 - ‘explain_node’ may be used uninitialized in this function (not fixed)
MDEV-6325 - TokuDB: hatoku_hton.cc:1021:5: warning: ‘do_commit’ may be used uninitialized in this function (not fixed)
Fix errors detected by ASan at compile time - Not merged but ASan was run against MariaDB. It generated the following:
MDEV-6329, Fix errors detected by ASan at runtime. Merged to 5.5.39.
Use single quotes for perl paths, in case of special symbols. Merged to 10.0.13.
Stop spawning dummy threads on client library initialization. Merged to 10.0.13.
Performance
MDEV-6249, Disable PerfSchema By Default
相关链接：
- Release Notes: https://mariadb.com/kb/en/mariadb-1010-release-notes/
- Changelog: https://mariadb.com/kb/en/mariadb-1010-changelog/
- Downloads: https://downloads.mariadb.org/mariadb/10.1.0/