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