Seeing its slightly over a month since MariaDB 1.5 Beta was released for Linux and a couple of days now since the Windows Win32 Version came into being I felt it prudent to mention a little a bit about it for now.

So to start off I’d like to mention about it’s history. For starters the goal of MariaDB is to provide a community developed, stable, and always Free branch of MySQL that is, on the user level, compatible with the main version.

In other words you could say MariaDB is a community developed branch of the MySQL database. This Database is developed under the Monty Program AB, founded by Michael “Monty” Widenius who also created MySQL. This program also has a bunch of the original MySQL Engineers plus a bunch of new comers.

MariaDB you could say id MySQL which uses the Maria Storage Engine as its default Transactional and Non-Transactional storage Engine.

MariaDB compares to MySQL in one way or another such as other than working exactly as MySQL in a manner in which all commands, interfaces, libraries and APIs that exist in MySQL also exist in MariaDB, There are a few main differences that I will mention here.

• The Maria storage engine version 1.5 (the crash-safe version) is included in the source and binaries by default.
• If you use the source, you can of course easily disable the Maria storage engine when configuring MariaDB.
• XtraDB storage engine is included.
• Percona XtraDB version 6 replaces InnoDB in the MariaDB 5.1 tree.
• XtraDB is a drop in replacement of InnoDB which has the same table formats so there is no need to convert any data.
• XtraDB gives you similar performance improvements for multi-cpu systems in MariaDB 5.1 that you can expect from using InnoDB in MySQL 5.4.
• The PBXT storage engine is included in the source and binaries by default.
• It as faster complex queries. These are queries which normally use disk-based temporary tables.
• The Maria storage engine is used for internal temporary tables, which should give you a speedup when doing complex selects. Maria is usually faster for temporary tables when compared to MyISAM because Maria caches row data in memory and normally doesn’t have to write the temporary rows to disk.
• Pool of Threads has limited sets of threads handling all queries.
• Fewer warnings when compiling based in the belief that compiler warnings can indicate bugs, and strive toward reduction to 0.This goes as far as fewer bugs.
• There are some improvements to DBUG code to make its execution faster when debug is compiled in but not used.
• CHECKSUM TABLE is faster.
• 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 0×00 – 0x7f.

Extensions.

• MariaDB can handle up to 32 key segments per key (up from 16).
• Added a new handler function: prepare_index_scan() that is called before a key scan is done.
• Added –abort-source-on-error to the mysql client.

Better testing of features.

• Wrong mutex usage detector. This helps find and fix deadlocks when taking mutex in inconsistent orders. In MariaDB has removed several deadlocks which exist in the normal MySQL code.
• Table elimination.
• Slow Query Log Extended Statistics. This is based on the microslow patch from Percona.
• Microsecond Precision in Processlist. This is based on the microsec_process patch from Percona.

Now that I have mentioned some of the differences, I think it is also important to mention some of the incompatibilities and compatibilities between the two Databases.