MySQL 5.6 enhanced cloud services

With enhanced performance, scalability, reliability, and manageability, Oracle fully launched the open source database MySQL 5.6 to help users meet the most demanding network, cloud, and embedded application requirements.

Through subquery optimization, online data definition language DDL operations, NoSQL access to InnoDB, new performance architecture detection and better conditional processing, MySQL 5.6 can greatly improve the flexibility of developers.

Tomas Ulin, vice president of MySQL integration, said: "The launch of the new MySQL 5.6 version has aroused enthusiastic responses from the community, allowing us to more effectively push mature technologies to the market. The new enhancements of MySQL 5.6 further demonstrate how to promote MySQL innovation and enable excellent products such as MySQL to cater to the most demanding network, cloud, and embedded application requirements in the current market, correctness of Oracle Investment."

Carl Olofson, vice president of IDC database management and data integration software research, said: "by introducing the latest version, Oracle has proved its continued commitment to the MySQL Community. These are the great advances made by MySQL technology. This open source relational database management system will meet and surpass the expectations of a larger scale and more users ."

Brent Juelich, senior director of managed services at Savvis, said: "Over the past year, we have seen a huge demand for MySQL cloud services. Considering the significant performance enhancement and more new features of MySQL 5.6 and the huge value-added value of MySQL Enterprise Edition, we can expect more people to be interested in these products in the future ."

Constantly innovating MySQL Community

The new enhancements of MySQL 5.6 in MySQL Community edition are now available to MySQL users.

MySQL 5.6 provides enhanced linear scalability to help users make full use of modern hardware capabilities.

With this version, you can get simplified query development and faster execution speed, better processing capacity and application availability, flexible NoSQL access, improved replication, and enhanced detection.

Highlights of MySQL 5.6

Improve MySQL optimization diagnosis to provide better query execution time and diagnosis functions:

Subquery optimization: optimizes subqueries before execution to simplify query development. The new efficiency is reflected in the query execution time, which significantly improves the selection, classification, and return delivery of result sets.

Index Condition Pushdown) and Batch Key Access (Batch Key Access) features are added to increase the number of queries selected by up to 280 times.

Enhanced optimized diagnostic functions: INSERT, UPDATE, and DELETE operations are performed through EXPLAIN. The EXPLAIN Plan is output in JSON format to provide more precise optimization metrics and better readability. Optimization tracking Optimizer Traces) can be used to track the optimization decision-making process.

Improve performance and application availability by enhancing the InnoDB Storage engine:

Improve Processing and read-only by up to 230%: Through InnoDB reconstruction, we can minimize traditional threads, flush and clear mutex conflicts and bottlenecks, so as to achieve better concurrency in High-load OLTP systems, in addition, the read-only workload and processing significantly increase the processing capacity.

Improve availability: Online DDL operations allow database administrators to add indexes and perform table changes, and applications can still be used for updates.

InnoDB full-text search: allows developers to create full-text indexes on InnoDB tables to represent text-based content and accelerate word and phrase application search.

Simple and key value search: flexible NoSQL access to InnoDB through the familiar Memcached API provides simple and key value search for InnoDB data. You can achieve a "win-win" effect for key value operations and complex SQL queries in the same database.

New Features of MySQL replication improve scalability and availability, including:

Self-repair feature replication cluster: the new Global processing identification and use program Global Transaction Identifiers and Utilities can more easily implement automatic detection and recovery from faults. The Crash-Safe Replication function enables binary logs and slave loads to be automatically restored to the correct position of the Replication stream when Replication crashes and resumes Replication, without administrator intervention. With automatic detection and warning errors, Checksums can maintain data integrity across clusters.

High-performance Replication cluster: multi-threaded slave device 3), Binlog Group Commit and Row-Based Replication optimization Binlog Group Commit and Optimized Row-Based Replication improve the Replication capability by 5 times, this allows you to maximize the replication performance and efficiency when expanding the workload across product systems ..

Delayed replication: prevents operation errors on the host and allows you to delete External tables.

Enhanced Performance architecture PERFORMANCE_SCHEMA): new detection enables users to better monitor the most resource-intensive queries, objects, users, and applications. You can also query, thread, user, host, and object to generate a summary of the new statistical information. The enhancement feature allows simpler default configurations and only consumes less than 5% of the cost.

MySQL5.6 includes new enhancements, including geographic information systems, precise space operations, enhanced IPv6 compliance, and optimized Server default settings.

Edit recommendations]

1. MySQL 5.6.10 vs Percona 5.6.6 TPCCC performance test
2. MariaDB has become a turning point in the fate of MySQL?
3. Rollback in case of a DELETE misoperation in MySQL
4. One-step migration from MySQL to Redis
5. Two ways to solve the problem of master-slave synchronization in mysql