Kicking-off its second MySQL Connect conference at Oracle OpenWorld 2013, Oracle has 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.
Key features include “mysqlfabric,” for scale out through sharding, and multi-source replication:
* 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.
* 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.
* Realtime 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, 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,” says Tomas Ulin, Oracle’s MySQL VP 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.”