New enhancements include InnoDB storage engine and enhanced replication capabilities
Oracle has launched new MySQL 5.6, an open source database with new enhancements including: InnoDB storage engine, and enhanced replication capabilities.
The new MySQL 5.6 allows the MySQL community to test significant new features such as NoSQL access to InnoDB via the Memcached protocol.
The MySQL 5.6 delivers: increased performance and scalability, including: an improved optimiser enabling better query performance; more partitioning options providing faster access to relevant data; and an enhanced PERFORMANCE_SCHEMA facilitating better performance monitoring and tuning.
The improved InnoDB storage engine includes: persistent optimiser statistics that produce improved, more predictable optimiser plans, as well as reduce start-up time; multi-threaded purge delivering steady performance by making purge operations more efficient; and configurable data dictionary cache enabling DBAs to more efficiently deploy systems with a large number of tables.
Oracle said that the enhanced replication provides: new crash-safe slaves and replication checksums that improve data integrity and detect errors that could cause slave corruption; and optimised row-based replication improving replication performance and reducing system resource consumption.
Oracle MySQL vice-president of engineering Tomas Ulin said from significantly investing in the technology, to working closely with the community, Oracle continues to make MySQL better.
"With this first MySQL 5.6 development milestone release, we are offering early access to new stable features for testing and the company continues to innovate and enhance the MySQL Database, delivering a higher performing, more scalable, reliable, and easier to use MySQL," Ulin said.