Feeds

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

MySQL 5.7 'development milestone' release

Boost IT visibility and business value

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. ®

Build a business case: developing custom apps

More from The Register

next story
PEAK LANDFILL: Why tablet gloom is good news for Windows users
Sinofsky's hybrid strategy looks dafter than ever
KDE releases ice-cream coloured Plasma 5 just in time for summer
Melty but refreshing - popular rival to Mint's Cinnamon's still a work in progress
Leaked Windows Phone 8.1 Update specs tease details of Nokia's next mobes
New screen sizes, dual SIMs, voice over LTE, and more
Fiendishly complex password app extension ships for iOS 8
Just slip it in, won't hurt a bit, 1Password makers urge devs
Mozilla keeps its Beard, hopes anti-gay marriage troubles are now over
Plenty on new CEO's todo list – starting with Firefox's slipping grasp
Apple: We'll unleash OS X Yosemite beta on the MASSES on 24 July
Starting today, regular fanbois will be guinea pigs, it tells Reg
Another day, another Firefox: Version 31 is upon us ALREADY
Web devs, Mozilla really wants you to like this one
Secure microkernel that uses maths to be 'bug free' goes open source
Hacker-repelling, drone-protecting code will soon be yours to tweak as you see fit
prev story

Whitepapers

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.
Boost IT visibility and business value
How building a great service catalog relieves pressure points and demonstrates the value of IT service management.
Why and how to choose the right cloud vendor
The benefits of cloud-based storage in your processes. Eliminate onsite, disk-based backup and archiving in favor of cloud-based data protection.
The Essential Guide to IT Transformation
ServiceNow discusses three IT transformations that can help CIO's automate IT services to transform IT and the enterprise.
Maximize storage efficiency across the enterprise
The HP StoreOnce backup solution offers highly flexible, centrally managed, and highly efficient data protection for any enterprise.