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


Pachyderm Gets Faster And Gets Funding
21/11/2018

Data lake company Pachyderm has announced a new version of its software, along with $10 million in funding for future development. The developers say the new version of Pachyderm has more than a thous [ ... ]



Chrome Working Towards Faster, Smoother UX
22/11/2018

One announcement from the 2-day Chrome Dev Summit that took place in mid-November was that Google has pledged $200,000 for JavaScript Frameworks. Here's a round up of news from the event.


More News

Python

 



 

Comments




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

Last Updated ( Tuesday, 30 September 2014 )