30 mins with MySQL Query Rewriter

February 25, 2016

Sometime DBAs have to deal with problematic queries and cannot tackle the problem at the source (problematic queries from ORMs, third party apps,… or source unknown…).
MySQL 5.7 provides a pre and post parse query rewrite APIs where users can write their own plug-ins.
With the post-parse query plugin, you can rewrite problematic queries without the need to make application changes, add hints, modify join order…