Oracle oznamuje nejnovější milníkovou verzi MYSQL 5.7

Verze poskytuje lepší možnosti správy, škálovatelnosti a rekordní výkon – pět set tisíc dotazů za sekundu (QPS) změřených na Sysbench testu. (TZ)

ORACLE OPENWORLD, SAN FRANCISCO – September 21, 2013

News Summary

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.

News Facts

  • 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).
  • Manageability
    • 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.
Notes to Editors

Supporting Resources

Oracle vytváří hardware a software pro spolupráci v cloudu a v datových centrech. Pro více informací o společnosti Oracle (NASDAQ: ORCL) navštivte www.oracle.com.