{"id":2820,"date":"2013-11-20T04:56:59","date_gmt":"2013-11-20T09:56:59","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=2820"},"modified":"2013-11-20T04:57:04","modified_gmt":"2013-11-20T09:57:04","slug":"mysql-5-6-system-variables-in-the-mariadb-10-server","status":"publish","type":"post","link":"http:\/\/www.bytebot.net\/blog\/archives\/2013\/11\/20\/mysql-5-6-system-variables-in-the-mariadb-10-server","title":{"rendered":"MySQL 5.6 system variables in the MariaDB 10 server"},"content":{"rendered":"<p>Since MariaDB aims to be a compatible\/drop-in replacement to MySQL, its crucial that in 10.0 we support all the 5.6 options\/<a href=\"https:\/\/mariadb.com\/kb\/en\/system-variables\/\">system variables<\/a>, else we have to clearly document them in the Knowledgebase article <a href=\"https:\/\/mariadb.com\/kb\/en\/mariadb-vs-mysql-compatibility\/\">MariaDB versus MySQL &#8211; Compatibility<\/a>.<\/p>\n<p>To this extent,\u00a0Sergey Vojtovich (svoj) has created <a href=\"https:\/\/mariadb.atlassian.net\/browse\/MDEV-5277\">MDEV-5277<\/a> as a tracker. There is also plenty of <a href=\"https:\/\/lists.launchpad.net\/maria-developers\/msg06485.html\">discussion on this topic<\/a> at the <a href=\"https:\/\/launchpad.net\/~maria-developers\">maria-developers mailing list<\/a>. I encourage current users of MySQL 5.6 to take a look at the list and comment either in Jira or on the mailing list to ensure that when we are ready for MariaDB 10.0, we cover what you&#8217;re using.<\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20MySQL%205.6%20system%20variables%20in%20the%20MariaDB%2010%20server&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2013%2F11%2F20%2Fmysql-5-6-system-variables-in-the-mariadb-10-server&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"4685e60e72\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2013\/11\/20\/mysql-5-6-system-variables-in-the-mariadb-10-server?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-2820\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2013\/11\/20\/mysql-5-6-system-variables-in-the-mariadb-10-server?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-2820\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2013\/11\/20\/mysql-5-6-system-variables-in-the-mariadb-10-server?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-2820\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2013\/11\/20\/mysql-5-6-system-variables-in-the-mariadb-10-server?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Since MariaDB aims to be a compatible\/drop-in replacement to MySQL, its crucial that in 10.0 we support all the 5.6 options\/system variables, else we have to clearly document them in the Knowledgebase article MariaDB versus MySQL &#8211; Compatibility. To this extent,\u00a0Sergey Vojtovich (svoj) has created MDEV-5277 as a tracker. There is also plenty of discussion [&hellip;]<\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20MySQL%205.6%20system%20variables%20in%20the%20MariaDB%2010%20server&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2013%2F11%2F20%2Fmysql-5-6-system-variables-in-the-mariadb-10-server&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"4685e60e72\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2013\/11\/20\/mysql-5-6-system-variables-in-the-mariadb-10-server?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-2820\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2013\/11\/20\/mysql-5-6-system-variables-in-the-mariadb-10-server?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-2820\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2013\/11\/20\/mysql-5-6-system-variables-in-the-mariadb-10-server?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-2820\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2013\/11\/20\/mysql-5-6-system-variables-in-the-mariadb-10-server?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_options":[]},"categories":[1064,23],"tags":[1610,1333],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-Ju","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":2924,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2014\/05\/02\/mysql-5-6-gtid-mariadb-10-replication","url_meta":{"origin":2820,"position":0},"title":"MySQL 5.6 + GTID &#038; MariaDB 10 replication","date":"2\/5\/2014","format":false,"excerpt":"While at the keynote of\u00a0Tomas Ulin\u00a0at Percona Live MySQL Conference & Expo Santa Clara 2014, he asked the audience what they were running, and most of the audience was on MySQL 5.5 while about 15% of the audience was on MySQL 5.6. This number is steadily increasing I\u2019m sure, so\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2840,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2013\/12\/27\/mariadb-distributions-update-dec-2013","url_meta":{"origin":2820,"position":1},"title":"MariaDB &#038; distributions update, Dec 2013","date":"27\/12\/2013","format":false,"excerpt":"A few things to note recently, amongst MariaDB in distributions.\u00a0 Ubuntu keeps MySQL 5.5 despite MariaDB's success. There's a lot of reasons for this, but remember the key takeaway here is MySQL 5.5 & the fact that MariaDB wasn't even in Debian yet when the decision was made. MariaDB is\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2743,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2013\/06\/11\/homebrew-mac-os-x-and-mariadb-10-0-series","url_meta":{"origin":2820,"position":2},"title":"Homebrew (Mac OS X) and MariaDB 10.0 series","date":"11\/6\/2013","format":false,"excerpt":"Today I performed a brew update. I noticed that MariaDB now exists as stable (5.5.30) and devel (10.0.2). Brew formulas also exist for MySQL (5.6.10) and Percona Server (5.5.30-30.2) now. 10.0.3 is around the corner but I wanted to run 10.0.2 now. This is how I did it: brew unlink\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2295,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2012\/02\/05\/replication-features-of-2011-by-sergey-petrunia","url_meta":{"origin":2820,"position":3},"title":"Replication features of 2011 by Sergey Petrunia","date":"5\/2\/2012","format":false,"excerpt":"Sergey Petrunia of the\u00a0MariaDB project & Monty Program. MySQL 5.5 GA at the end of 2010. MariaDB 5.3 RC towards the end of 2011 (beta in June 2011). MySQL 5.5 is merged to Percona Server 5.5 which included semi-sync replication, slave fsync options, atuomatic relay log recovery, RBR slave type\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2889,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2014\/04\/09\/book-in-korean-real-mariadb","url_meta":{"origin":2820,"position":4},"title":"Book in Korean: Real MariaDB","date":"9\/4\/2014","format":false,"excerpt":"For some months now, there have been some back & forth emails with Matt, one of the senior DBAs behind the popular messaging service, KakaoTalk\u00a0(yes, they are powered by MariaDB). Today I got some positive information: the book published entirely in the Korean language, titled Real MariaDB is now available.\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3131,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2015\/11\/10\/ubuntu-online-summit-mysql-variants-in-16-04","url_meta":{"origin":2820,"position":5},"title":"Ubuntu Online Summit: MySQL &#038; Variants in 16.04","date":"10\/11\/2015","format":false,"excerpt":"I personally have always enjoyed the Ubuntu Developer Summits (UDS), but nowadays they have been converted to the Ubuntu Online Summits (UOS). Attending them is not always convenient (timezone issues, might be travelling, etc.) so I watched the recorded video of a session I was interested in: MySQL & Variants\u2026","rel":"","context":"In &quot;Distributions&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"amp_enabled":true,"_links":{"self":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2820"}],"collection":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=2820"}],"version-history":[{"count":1,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2820\/revisions"}],"predecessor-version":[{"id":2821,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2820\/revisions\/2821"}],"wp:attachment":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=2820"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=2820"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=2820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}