Bug #10737 PS API queries in --log-slow-queries are unusable
Submitted: 19 May 2005 11:38 Modified: 19 May 2005 13:57
Reporter: Vadim Tkachenko Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.12 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[19 May 2005 11:38] Vadim Tkachenko
Description:
Description:
I tried to debug my slow queries (application uses PS API) via log-slow-queries file,
but log file contains unusable info:

# Time: 050519 13:31:21                                                                                                             
# User@Host: root[root] @ localhost []                                                                                              
# Query_time: 8  Lock_time: 0  Rows_sent: 1  Rows_examined: 6000000                                                                 
# administrator command: Execute;

for example I used PHP script:

$query = "SELECT * FROM tblApplications WHERE status=?";                                                                      
$stmt = mysqli_stmt_init($link);                                                                                                    
mysqli_stmt_prepare($stmt , $query);                                                                                                
                                                                                                                                    
mysqli_stmt_bind_param($stmt, "s", $val1);                                                                                    
                                                                                                                                    
$val1 = 's2';                                                                                                                 
                                                                                                                                    
/* Execute the statement */                                                                                                   
mysqli_stmt_execute($stmt);                                                                                                   

How to repeat:
1. run
./mysqld --log-slow-queries=/tmp/1.txt --long_query_time=1
2. run application with slow query & PS API
[19 May 2005 13:57] Georg Richter
Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.

Thank you for your interest in MySQL.

Additional info:

see bug #9968