{"id":2929,"date":"2014-05-03T09:09:20","date_gmt":"2014-05-03T14:09:20","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=2929"},"modified":"2014-05-03T09:09:20","modified_gmt":"2014-05-03T14:09:20","slug":"mariadb-10-xtradb-innodb-versions","status":"publish","type":"post","link":"https:\/\/www.bytebot.net\/blog\/archives\/2014\/05\/03\/mariadb-10-xtradb-innodb-versions","title":{"rendered":"MariaDB 10 – XtraDB & InnoDB versions"},"content":{"rendered":"

I\u2019ve 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?<\/strong>\u00a0The answer is simple – it is XtraDB.<\/p>\n

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<\/a>.\u00a0<\/p>\n

How do you tell what version of InnoDB or XtraDB you are running? Simply, run:\u00a0SHOW GLOBAL VARIABLES LIKE 'innodb_version';<\/tt><\/span><\/p>\n

MariaDB 10.0 (read more: What is MariaDB 10.0<\/a>):<\/span><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Version<\/strong><\/td>\nInnoDB<\/strong><\/td>\nXtraDB<\/strong><\/td>\nStatus<\/strong><\/td>\nDate<\/strong><\/td>\n<\/tr>\n
10.0.10<\/td>\n5.6.15<\/a><\/td>\n5.6.15-63.0<\/a> *<\/td>\nGA<\/td>\n31 Mar 2014<\/td>\n<\/tr>\n
10.0.9<\/td>\n5.6.15<\/a><\/td>\n5.6.15-63.0<\/a> *<\/td>\nRC<\/td>\n10 Mar 2014<\/td>\n<\/tr>\n
10.0.8<\/td>\n5.6.14<\/a> *<\/td>\n5.6.14-62.0<\/a><\/td>\nRC<\/td>\n10 Feb 2014<\/td>\n<\/tr>\n
10.0.7<\/td>\n5.6.10<\/a> *<\/td>\n5.6.14-62.0<\/a>\u00a0<\/td>\nBeta<\/td>\n27 Dec 2013<\/td>\n<\/tr>\n
10.0.6<\/td>\n1.2.6 *<\/td>\nn\/a<\/td>\nBeta<\/td>\n18 Nov 2013<\/td>\n<\/tr>\n
10.0.5<\/td>\n1.2.5 *<\/td>\nn\/a<\/td>\nBeta<\/td>\n7 Nov 2013<\/td>\n<\/tr>\n
10.0.4<\/td>\n1.2.4 * (5.6.10 merge<\/a>)<\/td>\nn\/a<\/td>\nAlpha<\/td>\n16 Aug 2013<\/td>\n<\/tr>\n
10.0.3<\/td>\n10.0.3-MariaDB *<\/td>\nn\/a<\/td>\nAlpha<\/td>\n11 Jun 2013<\/td>\n<\/tr>\n
10.0.2<\/td>\n10.0.2-MariaDB *<\/td>\nn\/a<\/td>\nAlpha<\/td>\n24 Apr 2013<\/td>\n<\/tr>\n
10.0.1<\/td>\n1.2.1 *\u00a0<\/td>\nn\/a<\/td>\nAlpha<\/td>\n6 Feb 2013<\/td>\n<\/tr>\n
10.0.0<\/td>\n1.2.0 (5.6.5 merge<\/a>)<\/td>\nn\/a<\/td>\nAlpha<\/td>\n12 Nov 2012<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

The asterisk (*) denotes the default engine choice.<\/p>\n

Why are there odd InnoDB versions from 10.0.0 – 10.0.6? I can only point this to merge oddities. storage\/innobase\/include\/univ.i<\/tt> is the file which contains common definitions such as INNODB_VERSION_MAJOR<\/tt>, INNODB_VERSION_MINOR<\/tt> and INNODB_VERSION_BUGFIX<\/tt>. INNODB_VERSION_BUGFIX<\/tt> in 10.0.6 pointed to MYSQL_VERSION_PATCH<\/tt> which you get from the VERSION<\/tt> file. For XtraDB, you will also see PERCONA_INNODB_VERSION<\/tt> in univ.i<\/tt>.<\/p>\n

So, when XtraDB is the default (10.0.9 and 10.0.10 and releases going forward) you can put in my.cnf to load InnoDB:<\/p>\n

ignore_builtin_innodb\nplugin_load=innodb=ha_innodb.so<\/pre>\n
When InnoDB is the default (10.0.8 and 10.0.7) and XtraDB was merged, you can put in my.cnf to load XtraDB:<\/p>\n
ignore_builtin_innodb\nplugin_load=innodb=ha_xtradb.so<\/pre>\n
Percona Server only became GA with 5.6.13-61.0<\/a> which was 7 Oct 2013 which explains why the MariaDB 10.0.6 beta didn\u2019t include a XtraDB.<\/p>\n
Percona Server only ships XtraDB (source code in storage\/innobase<\/tt>) while MariaDB ships both InnoDB (storage\/innobase<\/tt>) as well as XtraDB (storage\/xtradb<\/tt>).<\/p>\n
If you want older release information about InnoDB plugin versions, a great resource is Chris Calendar\u2019s blog post: InnoDB Plugin Versions<\/a>. I\u2019m just glad that going forward the InnoDB version will just match the release version as you can see with 10.0.7 and later.<\/p>\n","protected":false},"excerpt":{"rendered":"
I\u2019ve 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?\u00a0The answer is simple – it is XtraDB. However this answer has some history: initial releases of MariaDB 10 actually shipped with […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1064,23],"tags":[1669,1052,1610,1670],"class_list":["post-2929","post","type-post","status-publish","format-standard","hentry","category-mariadb-databases","category-mysql","tag-innodb","tag-mariadb","tag-mariadb-10-0","tag-xtradb"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/p4vJD-Lf","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2929","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=2929"}],"version-history":[{"count":1,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2929\/revisions"}],"predecessor-version":[{"id":2930,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2929\/revisions\/2930"}],"wp:attachment":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=2929"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=2929"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=2929"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}