A MySQL/MariaDB DBA/Consultant/Trainer with Expertise in Database Designing, Development, Maintenance, Installation, Upgradation, Configuration optimization, Setting and Managing Replication, Backup and Restore,Cross Database Migration, Optimization, Synchronization of replicated database, Performance and Monitoring, High Availability
Monday, October 1, 2012
Oracle Announces MySQL 5.6 Release Candidate
Hi Guys, Finally MySQL 5.6 is here. With great features for DBA and Product.. Below is some of key features from Oracle Keynot.
Candidate Delivers a Wide Range of Innovations
MySQL 5.6 RC provides enhanced
linear scalability, helping users to leverage modern hardware capabilities.
With this Release Candidate, users
can experience simplified query development and execution, better transactional
throughput and application availability, flexible NoSQL access, improved
replication and enhanced instrumentation.
New features and benefits include:
üBetter Query Execution Times and Diagnostics provided
through an enhanced MySQL Optimizer that includes:
Optimizations: simplify query development by
optimizing subqueries prior to execution. New efficiencies in how result sets are
selected, sorted and returned deliver substantial improvement in query
üThe addition of Index Condition Pushdown (ICP) and Batch Key
Access (BKA) can improve selected query throughput by up to 280x(1).
Optimizer Diagnostics: with
EXPLAIN for INSERT, UPDATE, and DELETE operations. EXPLAIN plan output in JSON
format delivers more precise optimizer metrics and better readability, and
Optimizer Traces enables to track the optimizer decision-making process.
üBetter Transactional Throughput and Application Availability
with an improved InnoDB storage engine:
Transactional and Read Only Throughput:
InnoDB has been re-factored to minimize legacy threading, flushing, purge mutex
contentions and bottlenecks, enabling better concurrency on heavily loaded OLTP
systems, and resulting in significantly improved throughput for read only
Availability: Online DDL operations enable DBAs
to add indexes and perform table alterations while the application remains
available for updates.
Search with InnoDB: allows developers to build FULLTEXT
indexes on InnoDB tables to represent text-based content and speed up
application searches for words and phrases.
Key Value Lookup: flexible NoSQL access to InnoDB
provides simple, key-value lookup of InnoDB data via the familiar Memcached
API. Users get the “best of both worlds,” combining key-value operations and
complex SQL queries in the same database.
Scale-Out and High Availability:
with new features in MySQL replication including:
Replication Clusters: the addition of Global Transaction
Identifiers and HA Utilities make it simple to automatically detect and recover
from failures. Crash-Safe Replication enables the binary log and slaves to
automatically recover correct positions in the replication stream in case of a
crash, and resume replication without administrator intervention. Checksums
maintain data integrity across the cluster by automatically detecting and
alerting on errors.
Performance Replication Clusters:
up to 5x faster replication through Multi-Threaded Slaves(3), Binlog Group
Commit and Optimized Row-Based Replication enable users to maximize the
performance and efficiency of replication as they scale-out their workloads
across commodity systems.
Replication: provides protection against
operational errors made on the master, for example accidentally dropping
PERFORMANCE_SCHEMA: new instrumentation enables users
to better monitor most resource intensive queries, objects, users and
applications. New summaries with aggregated statistics grouped by query,
thread, user, host and object are also available. The enhancements allow for
easier default configuration with less than five percent overhead.
The MySQL 5.6 RC includes additional
enhancements and is a feature complete aggregation of the Development
Milestones Releases Oracle previously delivered to the MySQL community.