MySQL 5.7 Hits 1 million NoSQL Queries per Second
MySQL 5.7 Hits 1 million NoSQL Queries per Second
Written by Kay Ewbank   
Tuesday, 30 September 2014

Oracle has made several announcements about MySQL at Oracle World, starting with a new development milestone release that has improvements in both performance and manageability.

According to Oracle, in benchmarks the new release achieved 645,000 SQL queries per second and more than 1 million NoSQL queries per second. Oracle also announced a variety of additional MySQL product releases and early access features, along with making MySQL source code available on GitHub.

The improved performance has been achieved using a new optimizer dynamic cost model, improved InnoDB performance, and replication performance improvements. The MySQL Optimizer Cost Model should give better query performance, and will also provide more control over execution plans and costs. The costs estimates the optimizer uses are stored in tables that you can configure.

The performance of InnoDB has also been improved for faster online and bulk load operations. Replication performance improvements mean many transactions can to be applied in parallel while maintaining full consistency and supporting transaction retries.

In benchmark tests using SysBench Read-only Point-Selects, at 1,024 connections, MySQL 5.7 delivered 645,000 queries per second (QPS), two times better than MySQL 5.6. More than 1 million NoSQL QPS to InnoDB via Memcached were achieved with MySQL 5.7, which is six times more than with MySQL 5.6.

Alongside the improvements to MySQL, Oracle has announced the first MySQL Cluster 7.4 development milestone release. This has enhancements to increase scalability, uptime, and agility. It supports active-active replication so you can replicate between clusters in different locations with automated conflict detection and resolution; you can also use more cores within each node for better scale out of throughput.

Oracle is providing early access to features under development, including MySQL Group Replication and multisource replication, for community testing and feedback through http://labs.mysql.com.

You can download the free Community Server Edition of MySQL 5.7.5 m15 via the Development Releases tab on the MySQL Downloads page and the MySQL source code is also being made publicly available on GitHub.

 

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


Canada's RAND Immigration Lottery Not Random!
17/06/2018

Well of course it isn't, but that doesn't stop people who should no better from stirring up a mock disgust and alarm. Oh dear we programmers are at it again, cutting corners with our job lot of not-qu [ ... ]



Firefox Share Below 10 Percent
06/06/2018

Despite any confidence we expressed about Firefox Quantum's ability to regain popularity as a desktop browser, its market share has continued to decline and has dipped below 10% for the first tim [ ... ]


More News

justjsquare

 



 

Comments




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

Last Updated ( Tuesday, 30 September 2014 )
 
 

   
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.