Feeds

Oracle tweaks MySQL with milestone update

NoSQL ain’t the only story in town

The essential guide to IT transformation

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.

The essential guide to IT transformation

More from The Register

next story
Apple promises to lift Curse of the Drained iPhone 5 Battery
Have you tried turning it off and...? Never mind, here's a replacement
China: You, Microsoft. Office-Windows 'compatibility'. You have 20 days to explain
Told to cough up more details as antitrust probe goes deeper
BBC: We're going to slip CODING into kids' TV
Pureed-carrot-in-ice cream C++ surprise
Linux turns 23 and Linus Torvalds celebrates as only he can
No, not with swearing, but by controlling the release cycle
Scratched PC-dispatch patch patched, hatched in batch rematch
Windows security update fixed after triggering blue screens (and screams) of death
This is how I set about making a fortune with my own startup
Would you leave your well-paid job to chase your dream?
prev story

Whitepapers

Endpoint data privacy in the cloud is easier than you think
Innovations in encryption and storage resolve issues of data privacy and key requirements for companies to look for in a solution.
Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Advanced data protection for your virtualized environments
Find a natural fit for optimizing protection for the often resource-constrained data protection process found in virtual environments.
Boost IT visibility and business value
How building a great service catalog relieves pressure points and demonstrates the value of IT service management.
Next gen security for virtualised datacentres
Legacy security solutions are inefficient due to the architectural differences between physical and virtual environments.