Menu
MySQL 5.7 delivers a 3x speed injection

MySQL 5.7 delivers a 3x speed injection

A major update to the open-source database is about to arrive

It's been more than two years since the general release of MySQL 5.6, and on Monday Oracle announced that its successor will soon arrive bearing a significant boost in performance along with improved security and scalability.

MySQL 5.7 promises speeds as much as three times faster than those of version 5.6. Specifically, in benchmark tests using SysBench Read-only Point-Selects and with 1,024 connections, MySQL 5.7 delivered 1.6 million queries per second, Oracle said.

"This is very competitive against other databases," said Tomas Ulin, Oracle's vice president of MySQL engineering. "These kinds of improvements come from removing internal bottlenecks in the software."

The InnoDB storage engine has also been optimized in this new release, bringing capabilities including increased performance and concurrency, enhanced online operations, spatial indexes and native partitioning, Oracle said.

Enhancements to MySQL’s replication features, meanwhile, include multisource replication, enhanced Global Transaction Identifiers (GTIDs), and improved multithreaded slaves for better scalability and availability.

A new MySQL optimizer dynamic cost model provides better query performance and greater user control.

Complex queries put an increased emphasis on joins and multijoins, and "then the optimizer becomes very important," Ulin said. "With 5.7 we've rewritten a lot of that code, much of which dated back to the early 2000s."

Other changes in MySQL 5.7 include improved security and scalability as well as new JSON capabilities that allow for the efficient and flexible storage, search and manipulation of schema-less data.

Along with Linux, Apache and PHP/Python/Perl, MySQL is one part of the so-called LAMP Stack used for Web development. 

The new release builds upon Development Milestone Releases that have emerged over the past two years, enabling users to preview, test and provide feedback during the development process, Ulin noted.

MySQL 5.7 is scheduled to be available for download on October 26.

Earlier this year, Amazon unveiled a competitor to MySQL known as Aurora.

Also on Monday Oracle announced the general availability of the new MySQL Router, which simplifies application development by intelligently routing queries to MySQL databases for increased performance and uptime.


Follow Us

Join the New Zealand Reseller News newsletter!

Error: Please check your email address.

Featured

Slideshows

Consegna comes to town with AWS cloud offerings launch in Auckland

Consegna comes to town with AWS cloud offerings launch in Auckland

Emerging start-up Consegna has officially launched its cloud offerings in the New Zealand market, through a kick-off event held at Seafarers Building in Auckland.​ Founded in June 2016, the Auckland-based business is backed by AWS and supported by a global team of cloud specialists, leveraging global managed services partnerships with Rackspace locally.

Consegna comes to town with AWS cloud offerings launch in Auckland
Veritas honours top performing trans-Tasman partners

Veritas honours top performing trans-Tasman partners

Veritas honoured its top performing partners across the channel in Australia and New Zealand, recognising innovation and excellence on both sides of the Tasman. Revealed under the Vivid lights in Sydney, Intalock claimed the coveted Partner of the Year 2017 (Pacific) award, with Data#3 acknowledged for 12 months of strong growth across the market. Meanwhile, Datacom took home the New Zealand honours, with Global Storage and Insentra winning service provider and consulting awards respectively. Dicker Data was recognised as the standout distributor of the year, while Hitachi Data Systems claimed the alliance partner award. Photos by Bob Seary.

Veritas honours top performing trans-Tasman partners
An Evening With Eugene Kaspersky for Kiwi partners in Auckland

An Evening With Eugene Kaspersky for Kiwi partners in Auckland

​New Zealand partners came together for An Evening With Eugene Kaspersky in Auckland, an invitation only event as part of Kaspersky Lab Partner Engage. Following an evening of insights and executive networking with the founder of Kaspersky Lab, Eugene Kaspersky, Kiwi partners got up close and personal with Eugene in an unprecedented​ panel discussion. Facilitated by Reseller News, this panel explored channel relationships, successful business strategies, and the latest ground breaking technologies to impact the security market. Photos by Maria Stefina.

An Evening With Eugene Kaspersky for Kiwi partners in Auckland
Show Comments