Improved Performance In MySQL Developer Milestone Release
Improved Performance In MySQL Developer Milestone Release
Thursday, 12 March 2015

Oracle has released MySQL 5.7.6 developer milestone 16 and claims that its performance has improved by a factor of between two and three times compared to previous releases.

The InnoDB data engine has a number of improvements, including the refactoring needed in preparation for supporting general tablespaces. You can now use InnoDB to create a general tablespace using the CREATE TABLESPACE syntax, so you can choose your own mapping between tables and tablespaces.

Writing about the new DMR on the MySQL Server blog, Geir Hoydalsvik says that this means you could do things such as grouping all tables for a given user or customer within a single tablespace, and thus having all of their data within a single file on the filesystem.

Native partitioning support has also been added to InnoDB. Until now, partitioning support relied on the ha_partition handler, which created a new handler for each partition. This wasted resources when using many partitions. Native partitioning in InnoDB is the first step on the road to better overall partitioning, including things such as parallel query processing, improved partition pruning, foreign key support, global secondary indexes, and full-text searches on partitioned tables. The partitioning interface has also been separated into its own partitioning interface.

Other improvements to InnoDB include support for 32k and 64k pages to improve compression ratios; and support for high priority transactions. These are transactions that shall never be chosen to be aborted in a deadlock scenario. The support for high priority transactions improves support for Group Replication in MySQL, where a transaction cannot be aborted in one replica and committed in another.

A more general change is support for generated columns in CREATE TABLE and ALTER TABLE statements. Values of such columns are computed from an expression specified at column creation time. Generated columns can be virtual (computed “on the fly” when rows are read) or stored (computed when rows are inserted or updated). Uses for generated columns include simplifying queries when applications select from a table using a complex expression, simulating functional indexes, or substituting for views.

Full (and lengthy) release notes give details of more changes and the source code is available for download at dev.mysql.com, or on GitHub.

 

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

 

Banner


Microsoft Buys GitHub - Get Ready For a Bigger Devil
04/06/2018

Microsoft has announced a deal to acquire GitHub valued at $7.5 billion. Microsoft vice president Nat Friedman, formerly CEO of Xamarin, will become GitHub CEO, taking over from GitHub's founder Chris [ ... ]



Are You A Typical Developer?
13/06/2018

JetBrains has conducted a survey of 6000 developers. It found Java to be the most popular programming language followed by JavaScript and Python. Go was discovered to be the language that devs were ke [ ... ]


More News

 

justjsquare

 



 

Comments




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

Last Updated ( Thursday, 12 March 2015 )
 
 

   
Banner
RSS feed of news items only
I Programmer News
Copyright © 2018 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.