View all newsletters
Receive our newsletter - data, insights and analysis delivered to you
  1. Technology
October 1, 2012

Oracle releases upgraded version of MySQL Release Candidate

The new release will help users meet the Web, Cloud-based and embedded application requirements

By CBR Staff Writer

Oracle has released the new version of its open-source database, MySQL 5.6 Release Candidate that claims to support demanding Web, Cloud-based and embedded application.

The new Release Candidate claims to offer users with simplified query development and execution, enhanced transactional throughput and application availability, flexible NoSQL access, improved replication and enhanced instrumentation.

MySQL 5.6 RC includes an enhanced MySQL optimiser that delivers enhanced query execution times and diagnostics.

The MySQL optimiser simplifies query development by optimising subqueries prior to execution, delivering substantial improvement in query execution times.

Addition of Index Condition Pushdown (ICP) and Batch Key Access (BKA) can improve selected query throughput by up to 280x and the EXPLAIN for INSERT, UPDATE and DELETE operations will enhance optimiser diagnostics.

The InnoDB storage minimises legacy threading, flushing, purge mutex contentions and bottlenecks, enabling improved concurrency on heavily loaded OLTP systems, and improve throughput for read only workloads.

Online DDL operations enable DBAs to add indexes and perform table alterations while the application remains available for updates, while the flexible NoSQL access to InnoDB provides key-value lookup of InnoDB data via Memcached API.

Content from our partners
How Midsona accelerated efficiency and reduced costs with a modern ERP system
Streamlining your business with hybrid cloud
A hybrid strategy will help distributors execute a successful customer experience

Full-Text Search with InnoDB allows developers to build FULLTEXT indexes on InnoDB tables to represent text-based content and accelerate application searches for words and phrases.

The new MySQL replication features include Self-Healing Replication Clusters, High Performance Replication Clusters, Time-delayed Replication and enhanced PERFORMANCE_SCHEMA.

Self-Healing Replication Clusters adds Global Transaction Identifiers and HA Utilities that automatically detects and recovers from failures.

High Performance Replication Clusters offers up to 5x faster replication through Multi-Threaded Slaves, Binlog Group Commit and Optimized Row-Based Replication, enabling users to maximse the replication performance and efficiency.

Time-delayed Replication provides protection against operational errors made on the master.

Enhanced PERFORMANCE_SCHEMA is a new instrumentation enables users to monitor most resource intensive queries, objects, users and applications.

Websites in our network
Select and enter your corporate email address Tech Monitor's research, insight and analysis examines the frontiers of digital transformation to help tech leaders navigate the future. Our Changelog newsletter delivers our best work to your inbox every week.
  • CIO
  • CTO
  • CISO
  • CSO
  • CFO
  • CDO
  • CEO
  • Architect Founder
  • MD
  • Director
  • Manager
  • Other
Visit our privacy policy for more information about our services, how New Statesman Media Group may use, process and share your personal data, including information on your rights in respect of your personal data and how you can unsubscribe from future marketing communications. Our services are intended for corporate subscribers and you warrant that the email address submitted is your corporate email address.