Bug #37935 QUAN does not track prepared statements
Submitted: 7 Jul 2008 15:52 Modified: 27 Oct 2008 19:42
Reporter: Kay Roepke Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Agent Severity:S4 (Feature request)
Version:2.0 OS:Any
Assigned to: Kay Roepke CPU Architecture:Any
Tags: query analysis

[7 Jul 2008 15:52] Kay Roepke
Description:
Using prepared statements with Quan results in an error message from the lua script and prepared statements are not being sent up to the dashboard.

How to repeat:
Use sysbench's OLTP test with Quan. Note that no queries will not show up on the Query Analysis tab.

Suggested fix:
quan.lua should track COM_STMT_PREPARE packets, record the statement name and the query and retrieve it when a COM_STMT_EXECUTE comes along.
[27 Oct 2008 19:42] Diego Medina
Verified fixed on 2.0.0.7078