Re: mysqldumpslow

When I run your script I get this:
Reading mysql slow query log from c:\mysql\slowLog20060518.txt
Count: 1  Time=0.00s (0s)  Lock=0.00s (0s)  Rows=0.0 (0), 0users@0hosts
  C : \ m y s q l \ b i n \ m y s q l d - m a x - n t ,   V e r s i o n 
:   N . N . N N - n t - m a x - l o g .   s t a
  t e d   w i t h :
   T C P   P o r t :   N N N N ,   N a m e d   P i p e :   ( n u l l )
   T i m e                                   I d   C o m m a n d         
A r g u m e n t
   #   T i m e :   N N N N N N   N N : N N : N N
   #   U s e r @ H o s t :   r o o t [ r o o t ]   @   l o c a l h o s 
t   [ N N N . N . N . N ]
   #   Q u e r y _ t i m e :   N     L o c k _ t i m e :   N     R o w s 
_ s e n t :   N     R o w s _ e x a m i n e d :
   N
   S H O W   V A R I A B L E S   L I K E   'S' ;
   #   U s e r @ H o s t :   r o o t [ r o o t ]   @   l o c a l h o s 
t   [ N N N . N . N . N ]
   #   Q u e r y _ t i m e :   N     L o c k _ t i m e :   N     R o w s 
_ s e n t :   N     R o w s _ e x a m i n e d :
   N
   S H O W   V A R I A B L E S   L I K E   'S' ;
   C : \ m y s q l \ b i n \ m y s q l d - m a x - n t ,   V e r s i o n 
:   N . N . N N - n t - m a x - l o g .   s t a
 r t e d   w i t h :
   T C P   P o r t :   N N N N ,   N a m e d   P i p e :   ( n u l l )
   T i m e                                   I d   C o m m a n d         
A r g u m e n t
   C : \ m y s q l \ b i n \ m y s q l d - m a x - n t ,   V e r s i o n 
:   N . N . N N - n t - m a x - l o g .   s t a
 r t e d   w i t h :
   T C P   P o r t :   N N N N ,   N a m e d   P i p e :   ( n u l l )
   T i m e                                   I d   C o m m a n d         
A r g u m e n t

Yes, there really is a space between each character.

My slow log looks different than yours.
It doesn't have the first few lines. It starts right off with a query_time:
# Query_time: 11  Lock_time: 0  Rows_sent: 1  Rows_examined: 4
SELECT g.GroupID, groupName, firstName, lastName FROM activeusers u, 
ugroup g, usergroup ug WHERE  g.groupID = ug.groupID AND u.userID = 
g.createdBy AND g.createdBy<> 767223 AND ug.userID= 767223 ORDER BY 
g.groupName;
# Time: 060508 12:26:27
# User@Host: youthhood[youthhood] @ localhost [127.0.0.1]
# Query_time: 12  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
SELECT g.GroupID, groupName, firstName, lastName FROM activeusers u, 
ugroup g, usergroup ug WHERE  g.groupID = ug.groupID AND u.userID = 
g.createdBy AND g.createdBy<> 3963 AND ug.userID= 3963 ORDER BY g.groupName;
# Time: 060508 12:26:28
# User@Host: youthhood[youthhood] @ localhost [127.0.0.1]
# Query_time: 12  Lock_time: 0  Rows_sent: 1  Rows_examined: 4
SELECT g.GroupID, groupName, firstName, lastName FROM activeusers u, 
ugroup g, usergroup ug WHERE  g.groupID = ug.groupID AND u.userID = 
g.createdBy AND g.createdBy<> 590404 AND ug.userID= 590404 ORDER BY 
g.groupName;

I use views but not prepared statements. I changed my server log 
location and I got the same headers that you have. I'll generate some 
queries and see how it goes. Do you know why I'm getting all of the spaces?

Thanks
Joelle



-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]