Bug #56972 Large slow_log entries freeze Workbench
Submitted: 23 Sep 2010 15:22 Modified: 20 Nov 2010 22:51
Reporter: Ben Vaughn Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:5.2.28 OS:Any
Assigned to: CPU Architecture:Any

[23 Sep 2010 15:22] Ben Vaughn 
Description:
I noticed that if a large entry (ie, an INSERT that contains a 20MB blob) shows up in the slow_log, it causes Workbench to grind to a halt for 30+ seconds.  Moving to a page of queries past the large one restores functionality to the tool.

How to repeat:
Trigger a slow_query that contains a lot of data -- like an INSERT with a large BLOB.

Suggested fix:
Truncate query output to 32KB or something similar -- the process viewer portion of the Administrator tool uses SHOW PROCESSLIST instead of SHOW FULL PROCESSLIST.  Similarly, showing less data in the slow query viewer should fix the problem.
[20 Oct 2010 22:51] MySQL Verification Team 
Thank you for the bug report. Could you please try new version 5.2.29 and if the issue continues provide the create table statement and the output of Help->System Info. Thanks in advance.
[21 Nov 2010 0:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".