MySQL Reaches Milestone 8 Release
Written by Kay Ewbank   
Tuesday, 13 September 2016

There's a major new release of MySQL with improvements including a transactional data dictionary.

This is a development milestone release, for use at developers own risk. In MySQL terms, milestone releases mean that significant development changes have taken place and you may encounter compatibility issues.

The new version is MySQL 8.0.0. If you're wondering why there's a jump from 5.7 (the previous stable release) to 8.0.0, the answer is that version 6 was cancelled and version 7 is the Cluster version. 

One of the main improvements to the new version is support for a transactional data dictionary. This is implemented as a set of SQL tables stored in InnoDB, and has been mostly implemented in this  DMR. The implementation means that DDL statements become atomic and crash safe and reliability is increased. MyISAM is now in principle optional as all system tables have been moved from MyISAM to InnoDB.

The new version also implements standard SQL Roles for the first time. A role is a named collection of privileges that can be granted to specific users.  The developers have also provided a SQL function that returns a graphml document representing role subgraphs. Writing about the new version on the MySQL blog, Geir Hoydalsvik said:

"In the future, we expect to utilize “system roles” when breaking up the super privilege into finer grained components."

Support for invisible indexes been added to the new version.  An invisible index is not considered by the optimizer when it makes the query execution plan, but because the index is still maintained in the background, it is cheap to make it visible again.

mysqlinvis

 

Explaining the new feature on the blog, Hoydalsvik said:

"The purpose of this is for a DBA / DevOp to determine if an index can be dropped. If you suspect an index of not being used you first make it invisible, then monitor query performance, and finally remove the index if no query slow down is experienced. This feature has been asked for by many users, for example Dropbox."

Other improvements include an extension of the bit-wise operations to include the option of using them on binary data types, IPV6 and UUID manipulation; the addition of Set Persist for global variables so you can persist global, dynamic server variables, and have the setting survive a server restart.

The Performance Schema has been improved, with the ability to look at aggregated counts of error messages reported by the server, and faster schema queries through the addition of 100 predefined indexes on performance schema tables. 

The blog post about the new release includes details of all the other improvements, and a deep dive into the transactional data dictionary.

mysql

More Information

MySQL Blog

MySQL Download Page

Related Articles

MySQL 5.7

Improved Performance In MySQL Developer Milestone Release

MySQL 5.7 Hits 1 million NoSQL Queries per Second

Amazon Launches Supercharged MySQL Alternative

 

To be informed about new articles on I Programmer, sign up for our weekly newsletter,subscribe to the RSS feed and follow us on, Twitter, FacebookGoogle+ or Linkedin

 

Banner


Generative AI Training For All On Coursera
04/03/2024

Generative AI is on the loose, getting into business and commerce as well as into art, poetry and coding. Already useful, it  will become ever more useful as long as we use it properly. Coursera  [ ... ]



iOS 17.4 Released With Support For App Stores In The EU
06/03/2024

I have written about Apple's approach to complying with regulation, characterizing it as malicious compliance. It also seems that Apple is a master of creating the unintended consequence and letting i [ ... ]


More News

 

raspberry pi books

 

Comments




or email your comment to: comments@i-programmer.info

Last Updated ( Tuesday, 13 September 2016 )