Bug #57716 SHOW PROFILE truncates
Submitted: 25 Oct 2010 17:45 Modified: 25 Oct 2010 20:35
Reporter: Peter Laursen (Basic Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.1.51 OS:Any
Assigned to: CPU Architecture:Any
Tags: qc
Triage: Triaged: D4 (Minor)

[25 Oct 2010 17:45] Peter Laursen
Description:
This is a small cosmetical issue with SHOW PROFILE only.

How to repeat:
-- ensure Query Cache is enabled
SET profiling = 1;
SELECT .. ; -- anything. QC will cache query and result
SELECT .. ; -- result is now sent from QC
SHOW PROFILE; -- see 'sending cached result to client' get truncated to 'sending cached result to clien'

Suggested fix:
Don't have longer strings in SHOW PROFILE output than the character buffer used (rewrite too-long-strings or increase buffer size)
[25 Oct 2010 20:35] Miguel Solorzano
Thank you for the bug report.

mysql 5.1 >SHOW PROFILE;
+--------------------------------+----------+
| Status                         | Duration |
+--------------------------------+----------+
| starting                       | 0.000030 |
| checking query cache for query | 0.000011 |
| checking privileges on cached  | 0.000008 |
| sending cached result to clien | 0.000581 |
| logging slow query             | 0.000003 |
| cleaning up                    | 0.000004 |
+--------------------------------+----------+
6 rows in set (0.00 sec)

mysql 5.1 >
[4 Jan 2011 10:21] Shane Bester
related: bug #59273