Oracle announces the release of MySQL 5.6 official version

In addition, the performance improvement of subqueries is also one of the main tasks of MySQL 5.6. in MySQL 5.6, a semi-join (semi-joins) and materialized processing are used to speed up the execution of subqueries, this means that you do not need to manually replace SQL statements containing subqueries with join operations. In addition, most data structure modification operations (such as alter table) can be performed online, avoiding long suspension of the database. The EXPLAIN Statement supports the execution plan information of UPDATE, DELETE, and INSERT statements. Other Optimizations to queries include eliminating table scans when a small LIMIT value is used.

In terms of replication, MySQL row-oriented replication supports the new "row image control", which only records modified columns rather than all columns in the row, this can save a lot of processing capability for some data containing BLOGs fields. Therefore, this improvement not only saves disk space, but also improves performance. In addition, "Index Condition Pushdown" is a new optimization measure that allows the query to prioritize the use of Index fields, and then the WHERE Condition.

MySQL 5.6 also introduces NoSQL interfaces and provides memcached-compatible APIs. This feature allows applications to directly access the InnoDB Storage engine. At the underlying layer, it maintains consistency with the relational database engine. At the same time, the underlying InnoDB engine also enhances the persistence of optimized statistics, eliminates multithreading, and provides more system tables and monitoring data.

MySQL product manager Tomas Ulin explained the open source community's Criticism of Oracle's patch policy. He said: this is a process of continuous verification. We provide security patches every three months, but in fact, most users do not update this frequently. Community Edition users complain that Oracle does not provide a detailed description of the CVE number in the release notes. They simply point to the internal error codes of Oracle. The company will not publish such details.

MySQL 5.6 significantly improves performance and availability and supports the next generation of Web, embedded and cloud computing applications.

MySQL Database 5.6 has the following features:

New! Online DDL/change data architecture supports dynamic applications and developer flexibility

New! Supports self-repairing clusters by copying global transaction IDs

New! Replication without crash slave can improve availability

New! High Performance of multi-thread replication slave

New! NoSQL access to InnoDB allows you to quickly complete key-value operations and extract data to complete Big Data deployment.

Improvement! In Linux, the performance is improved by up to 230%.

Improvement! Higher scalability in today's multi-core and multi-CPU Hardware

Improvement! InnoDB performance is improved to process transactions and read-only loads more efficiently

Improvement! Faster query and enhanced Diagnosis

Improvement! Performance Schema monitors resource usage by users/Applications

Improvement! Security is ensured through policy-based password management and implementation

Highly Reliable and ensures uninterrupted system operation without intervention

Easy to use. It takes only 3 minutes to complete the installation and configuration process from download to development environment.

Low management requirements and minimal Database Maintenance

The replication function supports flexible topology architecture for outward scaling and high availability.

Partitioning helps improve performance and manage super-large database Environments

ACID transactions support building secure and reliable key business applications

Stored Procedures can improve developers' Efficiency

Trigger can implement complex business rules at the database level

View ensures that sensitive information is not attacked

Information Schema facilitates metadata access

The plug-in storage engine architecture maximizes flexibility

Oracle MySQL 5.6.10 can be downloaded here

MySQL Installer 5.5.30 GA and MySQL WorkBench 5.2.26 GA are also released.