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...
Showing entries 1 to 1
Feb
25
2016
Showing entries 1 to 1