SAN FRANCISCO, CA -- (Marketwired) -- 09/21/13 -- ORACLE OPENWORLD -- Oracle (NYSE: ORCL)
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.