Bug #9968 slow query log contains useless entries
Submitted: 18 Apr 2005 9:31 Modified: 6 Aug 2005 23:23
Reporter: Georg Richter Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0 OS:Any (all)
Assigned to: Georg Richter CPU Architecture:Any

[18 Apr 2005 9:31] Georg Richter
Description:
When using prepared statements the slow query log contains no information about the statement itself, which makes it impossible to optimize statements:

<cut>
# Time: 050418  1:45:41
# User@Host: SAPMY1[SAPMY1] @  [10.17.70.89]
# Query_time: 103  Lock_time: 0  Rows_sent: 483077  Rows_examined: 483077
# administrator command: Execute;
</cut>

How to repeat:
-
[25 Jul 2005 23:05] Boris Burtin
I would definitely like to see this fixed.  The slow query is instrumental in helping me find performance problems.  It would be great if all problematic were logged reliably.
[27 Jul 2005 10:38] Georg Richter
MySQL 4.1.14 works ok, so the bug is only in 5.
[27 Jul 2005 10:47] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/27630
[29 Jul 2005 22:16] Georg Richter
fixed in 5.0.11
[6 Aug 2005 23:23] Mike Hillyer
Documented in 5.0.11 changelog:

<listitem><para>
 Prepared statements were not being written to the Slow Query log. (Bug #9968)
</para></listitem>
[8 Aug 2005 19:34] Boris Burtin
I saw this in 4.1.10a.  I'll check the logs once we upgrade to 4.1.14 or later to see if it's still happening.