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.

Join the Good Gear Guide newsletter!

Error: Please check your email address.

Our Back to Business guide highlights the best products for you to boost your productivity at home, on the road, at the office, or in the classroom.

Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Katherine Noyes

IDG News Service
Show Comments

Cool Tech

Crucial Ballistix Elite 32GB Kit (4 x 8GB) DDR4-3000 UDIMM

Learn more >

Gadgets & Things

Lexar® Professional 1000x microSDHC™/microSDXC™ UHS-II cards

Learn more >

Family Friendly

Lexar® JumpDrive® S57 USB 3.0 flash drive 

Learn more >

Stocking Stuffer

Plox Star Wars Death Star Levitating Bluetooth Speaker

Learn more >

Christmas Gift Guide

Click for more ›

Most Popular Reviews

Latest News Articles

Resources

GGG Evaluation Team

Kathy Cassidy

STYLISTIC Q702

First impression on unpacking the Q702 test unit was the solid feel and clean, minimalist styling.

Anthony Grifoni

STYLISTIC Q572

For work use, Microsoft Word and Excel programs pre-installed on the device are adequate for preparing short documents.

Steph Mundell

LIFEBOOK UH574

The Fujitsu LifeBook UH574 allowed for great mobility without being obnoxiously heavy or clunky. Its twelve hours of battery life did not disappoint.

Andrew Mitsi

STYLISTIC Q702

The screen was particularly good. It is bright and visible from most angles, however heat is an issue, particularly around the Windows button on the front, and on the back where the battery housing is located.

Simon Harriott

STYLISTIC Q702

My first impression after unboxing the Q702 is that it is a nice looking unit. Styling is somewhat minimalist but very effective. The tablet part, once detached, has a nice weight, and no buttons or switches are located in awkward or intrusive positions.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?