Hi!

>>>>> "Steven" == Steven Roussey <[EMAIL PROTECTED]> writes:

>> Description:
Steven>         1. Handling of string simplification confused, crashes perl!
Steven>         2. Format of slow log had changed a while back, so now the
Steven> timing information is broken in mysqldumpslow

>> How-To-Repeat:
Steven>         uploaded to mysql secret: n54-slow.log.gz
Steven>                 gunzip n54-slow.log.gz
Steven>                 mysqldumpslow n54-slow.log
>> Fix:
Steven> 1. Change:
Steven>        s/'([^\\\']|\\.|\'\')+'/'S'/g;
Steven>        s/"([^\\\"]|\\.|\"\")+"/"S"/g;

Steven> To:
Steven>         s/''/'S'/g;
Steven>         s/""/"S"/g;

Steven>         s/(\\')//g;
Steven>         s/(\\")//g;

Steven>         s/'[^']+'/'S'/g;
Steven>         s/"[^"]+"/"S"/g;

Steven> I'm not a perl wizzard, so there is likely a better way. But this
Steven> actually works. :)

Steven> 2. Change:

Steven>     s/^# Time: (\d+)  Lock_time: (\d+)  Rows_sent: (\d+).*\n//;

Steven> To:

Steven>     s/^# Query_time: (\d+)  Lock_time: (\d+)  Rows_sent: (\d+).*\n//;

<cut>

Applied to 4.0.2 source.

Thanks!

Regards,
Monty

-- 
For technical support contracts, goto https://order.mysql.com/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Michael Widenius <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, CTO
/_/  /_/\_, /___/\___\_\___/   Helsinki, Finland
       <___/   www.mysql.com

---------------------------------------------------------------------
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

Reply via email to