MySQL Update
MySQL Update
Written by Kay Ewbank   
Wednesday, 09 April 2014

Oracle has announced a Development Milestone release for MySQL 5.7, with benchmarked speeds twice those of MySQL 5.6

MSQL  5.7.4, which is available for download as a Development Release, offers improvements in replication, security, and instrumentation.

A release candidate of MySQL Fabric, which can be used for high availability management and sharding support, is also available. MySQL Workbench 6.1 has also been released with the ability to assess performance and optimize queries.

Some of the improvements to the performance come from improvements in the handling of Solid State Disks (SSD). An improved InnoDB buffer pool and metadata locking are also included, giving higher throughput. The MySQL semi-synchronous replication performance has also been improved.

The various changes were benchmarked using SysBench Read-only Point-Selects, at 1024 connections, with MySQL 5.7 delivering 512,000 QPS, 2x better than MySQL 5.6, and 3x better than MySQL 5.5.

The management features have also been improved, with more accurate cost calculations from the optimizer. The Performance Schema has more instrumentation, and you can now use AES 256-bit encryption for password management.

Other improvements to MySQL 5.7 features include better GIS support including spatial index support in InnoDB, as well as improved accuracy and performance; and continued development of multi-source replication.

The changes to MySQL Workbench include new performance dashboard and reports; an enhanced version of Explain plans to help optimize query performance; and a new schema. The MySQL “SYS” schema gives you simplified views on MySQL performance and instrumentation schemas.

 

Preview of MySQL 5.6.5

 

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

  

Banner


Alexa Gadgets SDK For Voice-Enabled Play
02/10/2017

At the same time as launching new Echo products, Amazon has announced Alexa Gadgets and unveiled Echo Buttons, which can be controlled using the Alexa Gadgets SDK and the Gadgets S [ ... ]



Kotlin Begins Its Takeover Of Android
11/10/2017

Google made Kotlin its lead language for Android development back in May of this year (2017) and it has been interesting to watch for signs of its take up or outright rejection. Now we have the first  [ ... ]


More News

 

 
 

 

blog comments powered by Disqus

Last Updated ( Wednesday, 09 April 2014 )
 
 

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