Sunday, 22 September 2013 15:48

Performance boost for MySQL

By

The latest Development Milestone Release of MySQL 5.7 has set a new performance record for the open source database.

MySQL 5.7.2 Development Milestone Release (DMR), released today, has set a new MySQL performance record of 500,000 queries per second (qps) on the Sysbench InnoDB Read-Only POINT SELECT benchmark.

The previous record of 250,000 qps was set by MySQL 5.6. Both benchmarks were performed on a 4 CPU, 2.27GHz Intel Xeon X7560 system with 256GB RAM running Oracle Linux 6.2.

MySQL 5.7.2 provides linear scaling up to 64 threads.

In addition to doubling the speed of MySQL 5.6 (at least on this measure), version 5.7.2 provides faster connectivity, increased replication speed, and improved manageability.

Other new features include an improved online Alter Table, internal memory and stored program instrumentation, improved dynamic control for triggers, improved JSON explain data, and lossless semi-synchronous replication.

MySQL Community Edition 5.7.2 DMR is available here.

In addition to the Community Edition DMR, an experimental version of MySQL available from labs.mysql.com includes mysqlfabric (which allows scale-out through sharding, with connector support for PHP, Python and Java), multi-source replication (allowing one slave to aggregate data from multiple masters,

"Oracle continues to work closely with the MySQL user community and encourages feedback and input to help rapidly improve product capabilities and quality," said Oracle MySQL Vice President of Engineering Tomas Ulin.

"With the latest MySQL 5.7 development milestone release, Oracle continues to drive MySQL innovation with predictable and consistent releases to closely address user requirements for their modern web, cloud and embedded applications."

The writer attended Oracle OpenWorld as the guest of Oracle.

CHIEF DATA & ANALYTICS OFFICER BRISBANE 2020

26-27 February 2020 | Hilton Brisbane

Connecting the region’s leading data analytics professionals to drive and inspire your future strategy

Leading the data analytics division has never been easy, but now the challenge is on to remain ahead of the competition and reap the massive rewards as a strategic executive.

Do you want to leverage data governance as an enabler?Are you working at driving AI/ML implementation?

Want to stay abreast of data privacy and AI ethics requirements? Are you working hard to push predictive analytics to the limits?

With so much to keep on top of in such a rapidly changing technology space, collaboration is key to success. You don't need to struggle alone, network and share your struggles as well as your tips for success at CDAO Brisbane.

Discover how your peers have tackled the very same issues you face daily. Network with over 140 of your peers and hear from the leading professionals in your industry. Leverage this community of data and analytics enthusiasts to advance your strategy to the next level.

Download the Agenda to find out more

DOWNLOAD NOW!

Stephen Withers

joomla visitors

Stephen Withers is one of Australia¹s most experienced IT journalists, having begun his career in the days of 8-bit 'microcomputers'. He covers the gamut from gadgets to enterprise systems. In previous lives he has been an academic, a systems programmer, an IT support manager, and an online services manager. Stephen holds an honours degree in Management Sciences and a PhD in Industrial and Business Studies.

VENDOR NEWS & EVENTS

REVIEWS

Recent Comments