MySQL Bugs: #41808: Query analyzer uses excessive CPU for some kinds of INSERT statements

Bug #41808	Query analyzer uses excessive CPU for some kinds of INSERT statements
Submitted:	31 Dec 2008 15:11
Reporter:	Kay Roepke
Status:	Verified
Category:	Monitoring: Agent	Severity:	S2 (Serious)
Version:	2.0.0.7097	OS:	Any
Assigned to:	Kay Roepke	Target Version:
Tags:	performance, quan
Triage:	Needs Triage: D2 (Serious) / R4 (High) / E5 (Major)

View
Add Comment
Files
Developer
Edit Submission
View Progress Log

Description:
Sending a large number of INSERT statements through Query Analyzer leads to high CPU
usage.

How to repeat:
Send a large number of INSERT statements that contain big VALUES() lists.
The same behavior should occur when doing SELECT with large IN() lists in the where
clause.

Suggested fix:
Optimize query normalization.