Software // Information Management
11:35 AM
Connect Directly
The Analytics Job and Salary Outlook for 2016
Jan 28, 2016
With data science and big data top-of-mind for all types of organizations, hiring analytics profes ...Read More>>

Oracle MySQL 5.7 Release Boosts Performance, Scalability

MySQL 5.7 release exploits latest hardware, introduces beta MySQL Fabric to manage high availability, database sharding.

Oracle on Monday announced MySQL 5.7, an upgrade of the popular open-source database that the vendor says will deliver "significantly higher" performance and improved manageability over MySQL 5.6. To ease management, the company released beta (1.0) MySQL Fabric software for high-availability support and database sharding.

Improving performance at high scale, MySQL 5.7 takes better advantage of high-end, multi-core severs. With MySQL 5.6, performance topped out with 32-core servers, but 5.7 makes the most of top-the-line 64-core servers, according to Tomas Ulin, VP of MySQL engineering.

"MySQL 5.7 is three times faster than 5.5 at high scale and two times faster than 5.6," Ulin told InformationWeek in a phone interview. "We're constantly pushing the limits of where you run into bottlenecks. And it's now at around 60 cores where you see performance flatten out."

[Want more on the new high-scale MySQL branch? Read Big Data Vendors: WebScaleSQL Is No Threat.]

In two other upgrades tied to state-of-the-art hardware, MySQL 5.7 can detect when it has direct access to solid state disks, in which case it can turn off unnecessary performance boosters such as double-write buffering, thereby improving efficiency. The 5.7 query optimizer has also been improved, with better control over seek times, memory, RAM tables, and other hardware features that can improve query performance.

"The flexibility of the 5.6 optimizer was limited, so we created an API that has much more granularity around how you can specify costs and performance attributes," said Ulin. With improved granularity you get better control over optimization choices.

In another performance improvement, the MySQL 5.7 connection layer offers higher capacity for short-lived connections, a common challenge for high-scale Web applications. The number of sustainable database connect and disconnect actions over a given time period has doubled, according to Ulin.

MySQL Fabric offers a ready-made framework for ensuring high availability and supporting database sharding. MySQL users have long solved these reliability and scalability challenges on their own, but MySQL Fabric covers the basics of high availability and sharding and is a starting point for additional features to come, says Ulin. General availability will depend on user feedback, he told us, with review periods generally taking two to six months.

With Monday's announcements Oracle also released MySQL Workbench 6.1, an upgrade offering two new features. Visual Explain lets administrators examine the function of a query so they can better understand performance tradeoffs and bottlenecks. A new performance schema dashboard lets administrators study memory usage and performance characteristics.

The release of MySQL 5.7 comes less than a week after Facebook, Google, LinkedIn, and Twitter introduced WebScaleSQL, a high-scale branch of MySQL based on the MySQL 5.6 Community Edition release. NoSQL and NewSQL vendors insist this high-scale enhancement won't be a threat, but Ulin said WebScaleSQL features, developed to improve scalability and to ease administration at scale, will be folded into future MySQL releases.

What do Uber, Bank of America, and Walgreens have to do with your mobile app strategy? Find out in the new Maximizing Mobility issue of InformationWeek Tech Digest.

Doug Henschen is Executive Editor of InformationWeek, where he covers the intersection of enterprise applications with information management, business intelligence, big data and analytics. He previously served as editor in chief of Intelligent Enterprise, editor in chief of ... View Full Bio

Comment  | 
Print  | 
More Insights
The Agile Archive
The Agile Archive
When it comes to managing data, donít look at backup and archiving systems as burdens and cost centers. A well-designed archive can enhance data protection and restores, ease search and e-discovery efforts, and save money by intelligently moving data from expensive primary storage systems.
Register for InformationWeek Newsletters
White Papers
Current Issue
How to Knock Down Barriers to Effective Risk Management
Risk management today is a hodgepodge of systems, siloed approaches, and poor data collection practices. That isn't how it should be.
Twitter Feed
InformationWeek Radio
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.