MariaDB versus MySQL - Features
You are viewing an old version of this article. View
the current version here.
Upgrading from MySQL to MariaDB? Let us help you!
Contact UsSee also Compatiblity between MariaDB and MySQL
More Storage Engines
In addition to the standard MyISAM, Blackhole, CSV, Memory, and Archive storage engines, the following are also included with MariaDB Source and Binary packages:
- Aria
- XtraDB (drop-in replacement for InnoDB)
- PBXT
- FederatedX (drop-in replacement for Federated)
- OQGRAPH — new in 5.2
- SphinxSE — new in 5.2
Speed improvements
- There are some improvements to DBUG code to make its execution faster when debug is compiled in but not used.
- CHECKSUM TABLE is faster.
- We have eliminated/improved some not needed character set conversions. Overall speed improvements is 1-5 % (according to sql-bench) but can be higher for big results sets with all characters between 0x00-0x7f.
- Our use of the Aria storage engine enables faster complex queries (queries which normally use disk-based temporary tables). The Aria storage engine is used for internal temporary tables, which should give you a speedup when doing complex selects. Aria is usually faster for temporary tables when compared to MyISAM because Aria caches row data in memory and normally doesn't have to write the temporary rows to disk.
- The test suite is extend and now runs much faster than before even if it tests more things.
Extensions & new features
We've added a lot of new features to MariaDB. If a patch or feature is useful, safe, and stable — we make every effort to include it in MariaDB.
- MariaDB can handle up to 32 key segments per key (up from 16)
- Added
--abort-source-on-error
to the mysql client. - Microsecond Precision in Processlist
- Pool of Threads
- Table Elimination
- mysqltest extensions
- Virtual Columns — new in 5.2
- Extended User Statistics — new in 5.2
- Segmented Key Cache — new in 5.2
- Pluggable Authentication — new in 5.2
- Storage-engine-specific CREATE TABLE — new in 5.2
- Enhancements to INFORMATION SCHEMA.PLUGINS table — new in 5.2
Better Testing
- More tests in the test suite.
- Bugs in tests fixed.
- Test builds with different configure options to get better feature testing.
- Remove invalid tests. (e.g. Don't test feature ''X'' if that feature is not in the build you are testing.)
Fewer warnings and bugs
- Bugs are bad. Fix as many bugs as possible and try to not introduce new ones.
- Compiler warnings are also bad. Eliminate as many compiler warnings as possible.
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.