I’ve had this question several times when presenting and once via
an internal email thread so I figure I might as well write about
it: What is the default transactional engine in MariaDB
10.0? The answer is simple – it is XtraDB.
However this answer has some history: initial releases of MariaDB
10 actually shipped with InnoDB from MySQL 5.6. Only in 10.0.9 RC
did the default switch back to being XtraDB. As MariaDB users
previously know, XtraDB was the default InnoDB in 5.1, 5.2, 5.3,
and 5.5 too. As always, you can switch easily between
InnoDB/XtraDB – read more in: Using InnoDB instead of XtraDB.
How do you tell what version of InnoDB or XtraDB you are running?
Simply, run: SHOW GLOBAL VARIABLES LIKE 'innodb_version';
MariaDB 10.0 (read more: …
[Read more]