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.

· Performance Zone ·
Free Resource

xMatters delivers integration-driven collaboration that relays data between systems, while engaging the right people to proactively resolve issues. Read the Monitoring in a Connected Enterprise whitepaper and learn about 3 tools for resolving incidents quickly.

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.

3 Steps to Monitoring in a Connected Enterprise. Check out xMatters.

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

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}