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

Boost IT visibility and business value

More from The Register

next story
The Return of BSOD: Does ANYONE trust Microsoft patches?
Sysadmins, you're either fighting fires or seen as incompetents now
Microsoft refuses to nip 'Windows 9' unzip lip slip
Look at the shiny Windows 8.1, why can't you people talk about 8.1, sobs an exec somewhere
Intel's Raspberry Pi rival Galileo can now run Windows
Behold the Internet of Things. Wintel Things
Linux Foundation says many Linux admins and engineers are certifiable
Floats exam program to help IT employers lock up talent
Microsoft cries UNINSTALL in the wake of Blue Screens of Death™
Cache crash causes contained choloric calamity
Eat up Martha! Microsoft slings handwriting recog into OneNote on Android
Freehand input on non-Windows kit for the first time
Linux kernel devs made to finger their dongles before contributing code
Two-factor auth enabled for Kernel.org repositories
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.
7 Elements of Radically Simple OS Migration
Avoid the typical headaches of OS migration during your next project by learning about 7 elements of radically simple OS migration.
BYOD's dark side: Data protection
An endpoint data protection solution that adds value to the user and the organization so it can protect itself from data loss as well as leverage corporate data.
Consolidation: The Foundation for IT Business Transformation
In this whitepaper learn how effective consolidation of IT and business resources can enable multiple, meaningful business benefits.
High Performance for All
While HPC is not new, it has traditionally been seen as a specialist area – is it now geared up to meet more mainstream requirements?