{"id":2863,"date":"2014-02-01T01:45:26","date_gmt":"2014-02-01T06:45:26","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=2863"},"modified":"2014-02-01T01:45:26","modified_gmt":"2014-02-01T06:45:26","slug":"changes-in-mysql-5-7","status":"publish","type":"post","link":"https:\/\/www.bytebot.net\/blog\/archives\/2014\/02\/01\/changes-in-mysql-5-7","title":{"rendered":"Changes in MySQL 5.7"},"content":{"rendered":"<p>I wish more discussion happened on the <a href=\"http:\/\/lists.mysql.com\/internals\">internals<\/a> mailing list, but if you&#8217;re interested in finding out what&#8217;s upcoming\/changing in MySQL 5.7, so far the best resources I&#8217;ve found are:<\/p>\n<ul>\n<li>The <a href=\"http:\/\/www.youtube.com\/watch?v=Q7E0b6lfJmA\">video<\/a>\u00a0(1h41m is worth a watch), and <a href=\"http:\/\/mysqlblog.fivefarmers.com\/2014\/01\/27\/sf-mysql-meetup-presentation-changes-in-mysql-5-7\/\">blog post<\/a> from Todd Farmer<\/li>\n<li>A <a href=\"http:\/\/www.slideshare.net\/morgo\/mysql-57upcomingchanges\">presentation<\/a> from Morgan Tocker (I wonder if we&#8217;ll see this at FOSDEM too)<\/li>\n<li>All of Morgan Tocker&#8217;s posts tagged <a href=\"http:\/\/www.tocker.ca\/categories\/community\">community<\/a><\/li>\n<li>The <a href=\"http:\/\/dev.mysql.com\/doc\/relnotes\/mysql\/5.7\/en\/\">5.7 release notes<\/a>\u00a0(in particular the change log)<\/li>\n<\/ul>\n<p>I like this &#8220;train&#8221; development model, but I wonder how it really syncs with the <a href=\"http:\/\/labs.mysql.com\/\">labs<\/a> releases. Multi-source replication is still against 5.7.2?<\/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%20Changes%20in%20MySQL%205.7&body=https%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2014%2F02%2F01%2Fchanges-in-mysql-5-7&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=\"65029d0b32\" data-email-share-track-url=\"https:\/\/www.bytebot.net\/blog\/archives\/2014\/02\/01\/changes-in-mysql-5-7?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-2863\" class=\"share-facebook sd-button share-icon\" href=\"https:\/\/www.bytebot.net\/blog\/archives\/2014\/02\/01\/changes-in-mysql-5-7?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-2863\" class=\"share-linkedin sd-button share-icon\" href=\"https:\/\/www.bytebot.net\/blog\/archives\/2014\/02\/01\/changes-in-mysql-5-7?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-2863\" class=\"share-twitter sd-button share-icon\" href=\"https:\/\/www.bytebot.net\/blog\/archives\/2014\/02\/01\/changes-in-mysql-5-7?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>I wish more discussion happened on the internals mailing list, but if you&#8217;re interested in finding out what&#8217;s upcoming\/changing in MySQL 5.7, so far the best resources I&#8217;ve found are: The video\u00a0(1h41m is worth a watch), and blog post from Todd Farmer A presentation from Morgan Tocker (I wonder if we&#8217;ll see this at FOSDEM [&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%20Changes%20in%20MySQL%205.7&body=https%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2014%2F02%2F01%2Fchanges-in-mysql-5-7&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=\"65029d0b32\" data-email-share-track-url=\"https:\/\/www.bytebot.net\/blog\/archives\/2014\/02\/01\/changes-in-mysql-5-7?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-2863\" class=\"share-facebook sd-button share-icon\" href=\"https:\/\/www.bytebot.net\/blog\/archives\/2014\/02\/01\/changes-in-mysql-5-7?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-2863\" class=\"share-linkedin sd-button share-icon\" href=\"https:\/\/www.bytebot.net\/blog\/archives\/2014\/02\/01\/changes-in-mysql-5-7?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-2863\" class=\"share-twitter sd-button share-icon\" href=\"https:\/\/www.bytebot.net\/blog\/archives\/2014\/02\/01\/changes-in-mysql-5-7?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":[23],"tags":[1775,1552],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-Kb","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":3131,"url":"https:\/\/www.bytebot.net\/blog\/archives\/2015\/11\/10\/ubuntu-online-summit-mysql-variants-in-16-04","url_meta":{"origin":2863,"position":0},"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":[]},{"id":2701,"url":"https:\/\/www.bytebot.net\/blog\/archives\/2013\/04\/24\/biggest-mysql-related-news-in-the-last-24-hours-day-2","url_meta":{"origin":2863,"position":1},"title":"Biggest MySQL related news in the last 24 hours, Day 2","date":"24\/4\/2013","format":false,"excerpt":"Continuing on from yesterday, the biggest news that I've noted in the past 24 hours: The commitment from Oracle's MySQL team to release a new GA about once every 24 months, with a Developer Milestone Release (DMR), with \"GA quality\" every 4-6 months. Tomas Ulin announced MySQL 5.7 DMR1 (milestone\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3199,"url":"https:\/\/www.bytebot.net\/blog\/archives\/2016\/04\/08\/tweet-summary-of-percona-live-2015","url_meta":{"origin":2863,"position":2},"title":"(tweet) Summary of Percona Live 2015","date":"8\/4\/2016","format":false,"excerpt":"The problem with Twitter is that we talk about something and before you know it, people forget. (e.g. does WebScaleSQL have an async client library?) How many blog posts are there about Percona Live Santa Clara 2015? This time (2016), I'm going to endeavour to write more than to just\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3182,"url":"https:\/\/www.bytebot.net\/blog\/archives\/2016\/02\/29\/amazon-rds-updates-february-2016","url_meta":{"origin":2863,"position":3},"title":"Amazon RDS updates February 2016","date":"29\/2\/2016","format":false,"excerpt":"I think one of the big announcements that came out from the Amazon Web Services world in October 2015 was the fact that you could spin up instances of MariaDB Server on it. You would get MariaDB Server 10.0.17. As of this writing, you are still getting that (the MySQL\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3209,"url":"https:\/\/www.bytebot.net\/blog\/archives\/2016\/04\/13\/major-post-ga-features-in-the-5-7-release","url_meta":{"origin":2863,"position":4},"title":"Major post-GA features in the 5.7 release!","date":"13\/4\/2016","format":false,"excerpt":"Interesting developments in the MySQL world - it can now be used as a document store and you can query the database using JavaScript instead of SQL (via the MySQL Shell). There is also a new X Plugin (see: mysql-5.7.12\/rapid\/) (which now makes use of protocol buffers (see: mysql-5.7.12\/extra\/protobuf\/)). I\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2933,"url":"https:\/\/www.bytebot.net\/blog\/archives\/2014\/05\/04\/per-query-variable-settings-in-mysqlpercona-serverwebscalesql","url_meta":{"origin":2863,"position":5},"title":"Per query variable settings in MySQL\/Percona Server\/WebScaleSQL","date":"4\/5\/2014","format":false,"excerpt":"Recently there was a discussion on the webscalesql mailing list\u00a0started by Chip Turner on a proposed change to the MAX_STATEMENT_TIME patch. This feature has been known as per query variable settings (WL#681)\u00a0and even shipping in Percona Server 5.6 as per-query variable statement. This feature has piqued my interest since 2009,\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2863"}],"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=2863"}],"version-history":[{"count":1,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2863\/revisions"}],"predecessor-version":[{"id":2864,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2863\/revisions\/2864"}],"wp:attachment":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=2863"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=2863"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=2863"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}