Oracle Announces Latest MySQL 5.7 Development Milestone Release
Release Provides Improved Manageability, Scalability and Record Performance -- Delivering Five Hundred Thousand Queries per Second (QPS) on Sysbench Test
ORACLE OPENWORLD, SAN FRANCISCO – September 21, 2013
Oracle announced the immediate availability of the latest Development Milestone Release (DMR) for MySQL 5.7. The new release further extends the performance, reliability, scalability, and manageability of the world’s most popular open source database, allowing developers and database administrators to build modern web, cloud-based and embedded applications capable of processing ever increasing volumes of data.
Kicking-off its second MySQL Connect conference at Oracle OpenWorld 2013, Oracle announced the availability of the second Development Milestone Release (DMR) for MySQL 5.7, continuing to drive MySQL technology innovation.
Available for download in the MySQL Developer Zone, this MySQL Community Edition 5.7.2 DMR delivers faster connectivity, higher transaction throughput, increased replication speed, memory instrumentation and other enhancements, enabling higher performance and improved manageability.
In addition to the new DMR, Oracle is providing early access to features under development for community testing and feedback through http://labs.mysql.com. Key features include “mysqlfabric,” for scale out through sharding, and multi-source replication.
New Enhancements Improve Performance, Scalability and Manageability
Performance & Scalability
MySQL 5.7.2 DMR delivers: A performance record of 500,000 queries per second (qps) for Sysbench InnoDB Read-Only POINT SELECT; linear scaling up to 64 CPU threads; and doubles the previous record performance of 250,000 ReadOnly qps(1).
Improved replication slave throughput: Uses new multi-threaded inter-transactional replication event handling on slaves threading. Runs disjointed transactions in separate parallel worker threads, even when acting on the same schema database.
Improved Online Alter Table: Provides support for renaming indexes and enlarging varchar datatypes.
Internal Memory Instrumentation in the Performance Schema: Supports tracking memory allocations and usage throughout mysqld. Native memory usage tracking and instrumentation for the first time in MySQL’s history. Monitoring with usage metrics for sizing, operation counts, and moving minimum/maximum windows from the Performance Schema.
Stored Program instrumentation in the Performance Schema: Provides added insight through detailed information on internal instructions executed within stored programs.
Stored Programs with stacked diagnostic areas: Use GET STACKED DIAGNOSTICS as a new tool to create and clear diagnostics needed to investigate issues within stored programs.
Improved dynamic control for triggers: Support for multiple triggers per event type on the same table. Support for trigger order control using FOLLOWS and PRECEDES.
Real-time execution analysis: Provides an execution plan on currently running statements using EXPLAIN for another running thread.
Improved JSON Explain Data: Allows a more detailed view into the query plans by adding total query cost, cost per table, total data volume that provides insights into the optimizer’s cost based calculations. See not only what execution plan was chosen, but why.
MySQL 5.7.2 DMR also delivers lossless semi-synchronous replication, enabling transactions to only be committed to the storage engine and externalized on the master after the slave has acknowledged receipt.
The following key features are also available through http://labs.mysql.com, for early testing and feedback from the MySQL community:
mysqlfabric in MySQL Utilities 1.4.0: Allows scale-out through sharding. Connector support is initially provided for PHP, Python and Java.
Multi-Source MySQL Replication: Enables a single slave to aggregate data from multiple masters.
"Oracle continues to work closely with the MySQL user community and encourages feedback and input to help rapidly improve product capabilities and quality,” said Tomas Ulin, Oracle’s MySQL vice president of Engineering. “With the latest MySQL 5.7 development milestone release, Oracle continues to drive MySQL innovation with predictable and consistent releases to closely address user requirements for their modern web, cloud and embedded applications.”
Oracle engineers hardware and software to work together in the cloud and in your data center. For more information about Oracle (NYSE:ORCL), visit www.oracle.com.
About Oracle OpenWorld
Oracle OpenWorld San Francisco is the most important educational and networking event of the year for Oracle technologists, customers, and partners. This information technology event is dedicated to helping businesses optimize existing systems and understand upcoming technology breakthroughs. The conference, which is expected to draw more than 60,000 attendees from over 145 countries, offers more than 2,500 educational sessions, 400 product demos, exhibitions from 500 partners and customers showcasing applications, middleware, database, server and storage systems, industries, management and infrastructure – all engineered for innovation. Oracle OpenWorld 2013 is being held September 22-26 at The Moscone Center in San Francisco. For more information, to register, or to watch Oracle OpenWorld keynotes, sessions and more live, please visit www.oracle.com/openworld. Join the Oracle OpenWorld discussion on Twitter, Facebook and the Oracle OpenWorld Blog.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
THIS DOCUMENT IS FOR INFORMATIONAL PURPOSES ONLY AND MAY NOT BE INCORPORATED INTO A CONTRACT OR AGREEMENT.
(1) Sysbench benchmark of MySQL 5.7.2 vs. MySQL 5.6 performed on Intel Xeon X7560 x86_64; 4 CPU x 8 Cores/CPU; 2.27 GHz, 256GB RAM; Oracle Linux 6.2