LOGIN | REGISTER NOW | SUBSCRIBE
 
Print

MySQL 5.6 boasts better speed


By Alex Handy


 Alex Handy
Email
February 5, 2013 —  While the development world continues to be spellbound by NoSQL revolutions, the decidedly SQL-based MySQL hasn't stood still. Today, Oracle announced the release of MySQL 5.6, which includes numerous speedups, and a new take on the NoSQL model based on Memcached.

Tomas Ulin, vice president of MySQL engineering at Oracle, said that there are a number of major optimizations included in 5.6. Queries should run faster for many types of workloads, for instance.

Ulin said there should be “better query execution times and better diagnostics. We have sub-query optimizations. We've rewritten how we handle sub-queries. There's really no new features there, just faster execution.”

Those optimizations extend down into InnoDB, as well, where the MySQL team has added index condition pushdown optimizations. These optimizations allow the MySQL server to hand off some data conditions to the storage engine, allowing said engine to match conditions before reading in an entire row of data. Using these optimizations, InnoDB (MySQL's default storage engine) shouldn't have to do as many reads when doing a row retrieval.

Elsewhere in this release, Ulin said a lot of work has been done to increase transparency when troubleshooting database problems. The team at Oracle, he said, has added optimized traces and query execution plans. InnoDB has also been optimized, and through this work, MySQL 5.6 can support up to 48 cores.

“We can now handle much more concurrent load without getting congestion, which means we can scale out with more cores,” said Ulin. “We now have linear scalability to 48 cores on both read and write loads. The transactional throughput has improved three times in the scale-out scenario. What this really means is that MySQL can now utilize the modern hardware.”

InnoDB has also added full text search capabilities.

Perhaps the most interesting new addition to MySQL 5.6 is the inclusion of NoSQL-like capabilities, created through the addition of Memcached. “We announced a year ago we were adding the Memcached API to access and update data in InnoDB,” said Ulin. “We can join the best of both worlds in the SQL/NoSQL discussion. We think we can make it much easier to gain the benefits of NoSQL-type access. We give you a flexible, powerful language to go through your data. We've observed up to nine-times improvements using the NoSQL interface.”




Related Search Term(s): InnoDB, MySQL, Oracle


Share this link: http://sdt.bz/37372
 
Most Read  Latest News  Resources
SAP unveils SAP HANA platform innovations for Big Data and spatial processing
Features include smart data access and expanded cloud deployment options
Alteryx raises $12 million to put Big Data analytics in the hands of all business analysts
Quest founder's firm, Toba Capital, selects Alteryx as its first analytics investment
Google I/O kicks off
Developers get new APIs and tools, and the Go language hits version 1.1
Jelastic launches new version of its Java and PHP hosting platform
Jelastic today announced the launch of a new version of its ultra-scalable cloud hosting platform
Digg!  Digg
Reddit  Reddit
Slashdot  Slashdot
Share on facebook  Facebook
Share on Twitter  Twitter


close
NEXT ARTICLE
Oracle completes Sun acquisition
As Oracle maps out its future, greater attention is paid to PostgreSQL, which is considered a counterbalance to MySQL Read More...
 
 
 




News on Monday  more>>
Android Developer News  more>>
SharePoint Tech Report  more>>
Big Data TechReport  more>>

   
 
 

 


Download Current Issue
MAY 2013 PDF ISSUE

Need Back Issues?
DOWNLOAD HERE

Want to subscribe?