I'm trying to find what causes mysqldumpslow to crash for us every time the log is anything but trivial. The following does not crash it, but it does give incorrect results:
# User@Host: apache[apache] @ morpheus.e [1.1.1.1] # Query_time: 8 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 replace into forums_posts_new_1 (f,m,p,r,d,dm,a,au,l,i,u,aut,e,t,m,h ) values (7451,1014880635,1014815708,1014815708,'no','no','yes','no',0,3538664738 ,'af34b901b897b5ce59c7bf7df3fb620c','Ex','','Re: HTV','Dont worry <BR> <BR> Chow from Japan.',''); Gives Reading mysql slow query log from test.log Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=0.0 (0), apache[apache]@morpheus.e # Query_time: N Lock_time: N Rows_sent: N Rows_examined: N replace into forums_posts_new_1 (f,m,p,r,d,dm,a,au,l,i,u,aut,e,t,m,h ) values (N,N,N,N,'S','S','S','S',N,N,'S','S',''S'Re: HTV'S'Dont worry <BR> <BR> Chow from Japan.'S'') I think it is the '' at the two locations... Sincerely, Steven Roussey http://Network54.com/?pp=e --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
