(BTW, mysqldumpslow does not seem to be in the RPMs for v4.)
mysqldumpslow (perl itself, I guess) dumps core and acts incorrectly
when dealing with simplifying strings.
Fix:
Change:
s/'([^\\\']|\\.|\'\')+'/'S'/g;
s/"([^\\\"]|\\.|\"\")+"/"S"/g;
To:
s/''/'S'/g;
s/""/"S"/g;
s/(\\')//g;
s/(\\")//g;
s/'[^']+'/'S'/g;
s/"[^"]+"/"S"/g;
I'm not a perl wizzard, so there is likely a better way. But this
actually works. :)
Also, there is a bug with getting the query and lock times.
Change:
s/^# Time: (\d+) Lock_time: (\d+) Rows_sent: (\d+).*\n//;
To:
s/^# Query_time: (\d+) Lock_time: (\d+) Rows_sent: (\d+).*\n//;
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
sql,query
---------------------------------------------------------------------
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
