Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Query Rewrite Plugin: Scalability Fix in MySQL 5.7.14

DZone's Guide to

Query Rewrite Plugin: Scalability Fix in MySQL 5.7.14

In this post, we’ll look at a scalability fix for issues the query rewrite plugin had on performance.

Free Resource

Transform incident management with machine learning and analytics to help you maintain optimal performance and availability while keeping pace with the growing demands of digital business with this eBook, brought to you in partnership with BMC.

In this post, we’ll look at a scalability fix for issues the query rewrite plugin had on performance.

Several months ago, Vadim blogged about the impact of a query rewrite plugin on performance. We decided to re-evaluate the latest release of 5.7(5.7.14), which includes fixes for this issue.

I reran tests for MySQL 5.7.13 and 5.7.14 using the same setup and the same test: sysbench OLTP_RO without and with the query rewrite plugin enabled.

Image title

MySQL 5.7.14 performs much better, with almost no overhead. Let’s check PMP for these runs:

MySQL 5.7.13

MySQL 5.7.14

Also, note that the fix for this issue should help to improve performance for any other audit based API plugins.

Evolve your approach to Application Performance Monitoring by adopting five best practices that are outlined and explored in this e-book, brought to you in partnership with BMC.

Topics:
scalability ,database ,fix ,plugin ,mysql ,api ,performance ,percona

Published at DZone with permission of Alexey Stroganov, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}