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 newsletter!

Or

Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.

Brand Post

Featured

Slideshows

The Kiwi channel gathers for the 2020 Reseller News Women in ICT Awards

The Kiwi channel gathers for the 2020 Reseller News Women in ICT Awards

Hundreds of leaders from the New Zealand IT industry gathered at the Hilton in Auckland on 17 November to celebrate the finest female talent in the Kiwi channel and recognise the winners of the Reseller News Women in ICT Awards (WIICTA) 2020.

The Kiwi channel gathers for the 2020 Reseller News Women in ICT Awards
Leading female front runners honoured at the 2020 Reseller News Women in ICT Awards

Leading female front runners honoured at the 2020 Reseller News Women in ICT Awards

The leading female front runners of the New Zealand ICT industry joined together for the annual Reseller News Women in ICT Awards event at the Hilton in Auckland, during which hundreds of guests celebrated 13 outstanding individuals who won awards, chosen from more than 50 finalists representing over 30 organisations.

Leading female front runners honoured at the 2020 Reseller News Women in ICT Awards
Channel gathers to celebrate the Reseller News Innovation Awards 2020 winners

Channel gathers to celebrate the Reseller News Innovation Awards 2020 winners

More than 500 channel leaders gathered in Auckland on 21 October at the ​Reseller News Innovation Awards ​2020 to celebrate the achievements of the New Zealand technology industry's top partners, start-ups, vendors, distributors and individuals.

Channel gathers to celebrate the Reseller News Innovation Awards 2020 winners
Show Comments