Oracle Released MySQL 5.6

The world's leading developer's company, Oracle, has released the General Availability (GA) version of MySQL 5.6, together with the version 5.2.46 of the MySQL Workbench GUI tool. One of the most significant and main changes to MySQL 5.6 are the addition of NoSQL access to the InnoDB database engine and faster sub-queries. The newest version of MySQL 5.6 sub-queries are now optimized using semi-JOINs. According to a blog post by Rob Young of the Oracle MySQL blog, the optimizer is now more efficient in handling subqueries in the FROM clause; materialization of subqueries in the FROM clause is now postponed until their contents are needed during execution, greatly improving performances. The additions of Index Condition Pushdown (ICP) and Batch key Access (BKA) is said to improve selected query throughput by up to 280 times. The MySQL 5.6 has changes such as the Online Data Definition Language (DDL) operations are now supported, so you can change the backend schema while keeping the application online. The condition is achieved by the addition of new ALTER TABLE DLL syntax. The new version now supports full-text search with InnoDB, and you can build FULLTEXT indexes on InnoDB tables so users can search for words and phrases. The InnoDB full-text search supports Natural language/Boolean modes, proximity search and relevance ranking. Here's some important changes for MySQL 5.6 Release: ***Better Performance and Scalability ***Improved InnoDB for better transactional throughput and developer agility ***Improved Optimizer for better query execution times and diagnostics ***New NoSQL Access to InnoDB via Memcached, enabling key-value operations and complex SQL queries across the same data set Improved Replication for high performance, self-healing distributed deployments ***Improved Performance Schema for better instrumentation ***Improved Security for worry-free application deployments For more information visit the following MySQL Blogs. Rob Young MySQL Blog Dev.MySQL blog