Bug #50882 Query Analyzer does not normalize "multi-statements"
Submitted: 3 Feb 2010 14:55 Modified: 22 May 2017 8:16
Reporter: Mark Leith Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Enterprise Monitor: Agent Severity:S3 (Non-critical)
Version:2.1.0.1093 OS:Any
Assigned to: Assigned Account CPU Architecture:Any
Tags: windmill

[3 Feb 2010 14:55] Mark Leith 
Description:
If a client sends multiple statements in a single packet, quan does not recognize this, and only normalizes out the literals, it doesn't split the statements by a delimiter. 

See an example of this here:

http://pastebin.com/m1d37825e

How to repeat:
Use self-monitoring of the MEM application, which batches DELETE statements on the rule_eval_results table. 

Suggested fix:
Normalize multi-statements to the statement level.
[22 May 2017 8:16] Mark Leith 
Using Performance Schema, this is done appropriately. Those using Multi-Statements should be using this instrumentation instead. Closing as Won't Fix now.