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

Sensu is an open source monitoring event pipeline. Try it today.

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.

Sensu: workflow automation for monitoring. Learn more—download the whitepaper.

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