RealTime IT News

Oracle Advances Open Source MySQL 5.6

Tomas Ulin, VP of MySQL Engineering at Oracle told InternetNews that his company has been focused on performance for MySQL over the past year. Oracle issued its first MySQL 5.6 preview in July of 2011. Ulin noted that for certain types of queries, there has been a performance gain of as much as 200 percent.

MySQL 5.6 includes sub-query optimizations that improve the query execution speeds. The underlying InnoDB storage engine has also been enhanced for throughput performance.

Ulin noted that overall, Oracle has improved the way that milestone releases are developed for MySQL. He noted that in the early days of MySQL and even at Sun, there were a lot of new features packed into each new release, with not as much testing as might have been required.

Under Oracle's guidance the number of new features per release has been cut down to be more manageable. While at the same time, there is more effort going into testing and overall quality.

From a release perspective, Ulin noted that users don't want to upgrade their databases often with big feature releases. He stressed that Oracle has been coming out with a regular stream of maintenance releases though, as the 5.6 release is being developed. The current plan is for major new releases of MySQL every other year. That would place a MySQL 5.6 generally available release for early in 2013.

Read the full story at Database Journal:
Oracle Pushes both MySQL 5.6 and Oracle Database 12c Forward

Sean Michael Kerner is a senior editor at InternetNews.com, the news service of the IT Business Edge Network, the network for technology professionals Follow him on Twitter @TechJournalist.