MySQL Bugs: #37935: QUAN does not track prepared statements

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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.

Verified fixed on 2.0.0.7078