(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