Feeds

Oracle tweaks MySQL with milestone update

NoSQL ain’t the only story in town

High performance access to file storage

OpenWorld While the news about NoSQL has garnered much attention, Oracle has quietly published a development milestone release (DMR) for MySQL.

The MySQL 5.6.3 DMR includes a major revision of the software’s optimizer, which the company claims will make file-sort optimizations up to three times faster by searching more intelligently and dumping unneeded data during the process.

Index condition pushdowns were also speeded up, with Oracle reporting that operation times for the function had been cut from 15 seconds down to 90 milliseconds.

Batched Key Access has been added to augment the Multi-Range Read capabilities added in the 5.6.2 DMR, enabling indexes to be sorted by data sequence for faster searching. In tests this dropped some execution times from 2000 seconds to 10, albeit with a “sufficiently large” join buffer.

More instrumentation has been added to the performance schema in the new release and further improvements have been made in InnoDB and replication.

With over 40 sessions devoted to MySQL at the Oracle OpenWorld conference this week, it’s clear that the company is maintaining its investment in the MySQL code. That said, some developers have commented privately that they fear for the long-term development of the platform, particularly its perceived creeping commercialization.

High performance access to file storage

More from The Register

next story
Windows 8.1, which you probably haven't upgraded to yet, ALREADY OBSOLETE
Pre-Update versions of new Windows version will no longer support patches
Android engineer: We DIDN'T copy Apple OR follow Samsung's orders
Veep testifies for Samsung during Apple patent trial
OpenSSL Heartbleed: Bloody nose for open-source bleeding hearts
Bloke behind the cockup says not enough people are helping crucial crypto project
Microsoft lobs pre-release Windows Phone 8.1 at devs who dare
App makers can load it before anyone else, but if they do they're stuck with it
Half of Twitter's 'active users' are SILENT STALKERS
Nearly 50% have NEVER tweeted a word
Windows XP still has 27 per cent market share on its deathbed
Windows 7 making some gains on XP Death Day
Internet-of-stuff startup dumps NoSQL for ... SQL?
NoSQL taste great at first but lacks proper nutrients, says startup cloud whiz
US taxman blows Win XP deadline, must now spend millions on custom support
Gov't IT likened to 'a Model T with a lot of things on top of it'
prev story

Whitepapers

Mainstay ROI - Does application security pay?
In this whitepaper learn how you and your enterprise might benefit from better software security.
Five 3D headsets to be won!
We were so impressed by the Durovis Dive headset we’ve asked the company to give some away to Reg readers.
3 Big data security analytics techniques
Applying these Big Data security analytics techniques can help you make your business safer by detecting attacks early, before significant damage is done.
The benefits of software based PBX
Why you should break free from your proprietary PBX and how to leverage your existing server hardware.
Mobile application security study
Download this report to see the alarming realities regarding the sheer number of applications vulnerable to attack, as well as the most common and easily addressable vulnerability errors.