From: Date: July 8 2008 1:01am Subject: bzr commit into mysql-5.1 branch (chad:2689) Bug#34129 List-Archive: http://lists.mysql.com/commits/49139 X-Bug: 34129 Message-Id: <20080707230129.5793A8305D@cornsilk.net> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit #At file:///home/cmiller/work/mysqlbzr/mysql-5.1-bugteam--bug34129/ 2689 Chad MILLER 2008-07-07 Bug#34129: mysqldumpslow does not aggregate times Query times were changed to contain subsecond information after a decimal. Change the capturing regex to account for decimal also. modified: scripts/mysqldumpslow.sh === modified file 'scripts/mysqldumpslow.sh' --- a/scripts/mysqldumpslow.sh 2007-12-28 00:02:28 +0000 +++ b/scripts/mysqldumpslow.sh 2008-07-07 22:56:53 +0000 @@ -83,7 +83,7 @@ while ( defined($_ = shift @pending) or s/^#? Time: \d{6}\s+\d+:\d+:\d+.*\n//; my ($user,$host) = s/^#? User\@Host:\s+(\S+)\s+\@\s+(\S+).*\n// ? ($1,$2) : ('',''); - s/^# Query_time: (\d+) Lock_time: (\d+) Rows_sent: (\d+).*\n//; + s/^# Query_time: ([0-9.]+) Lock_time: ([0-9.]+) Rows_sent: ([0-9.]+).*\n//; my ($t, $l, $r) = ($1, $2, $3); $t -= $l unless $opt{l};