Feeds

Don't look at Maria's SQL, look at MY SQL, pleads Oracle

MySQL 5.7 'development milestone' release

The essential guide to IT transformation

Oracle says it has doubled the performance of its open source MySQL database when running over large datasets across more than 40 cores, as it strives to preserve its lead in a market thronging with credible contenders.

Oracle gave details of a "Development Milestone" release of version 5.7 of its MySQL database on Monday, alongside rival MariaDB going into version 10 of its eponymous system.

The widely used open source MySQL database has received replication, storage, schema, and throughput advances, the company wrote in its announcement.

"What we've done is – all the way from the top down – removed bottlenecks in terms of mostly mutexes and contentions," Oracle's veep of MySQL engineering Tomas Ulin told The Reg.

These changes include tweaks to the relational database's "InnoDB" storage engine, enhancements for semi-synchronous replication, and throughput improvements for queries to data held on solid-state disks.

By doing this, MysQL 5.7 demonstrates almost double the query-per-second performance of MySQL 5.6 on SysBench Read-Only Point Selects benchmarks.

"These performance enhancements are reached at scale when looking at 40 or 50 or 60 cores being used," Ulin explained. "On the low core counts you don't see it."

The company has also added features relating to geographical information systems (GIS) by incorporating spatial index support into InnoDB. This follows non-relational rival MongoDB investing many years in adding GIS features to its own datastore. ®

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
Mozilla's 'Tiles' ads debut in new Firefox nightlies
You can try turning them off and on again
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.