>Description:
1. Handling of string simplification confused, crashes perl!
2. Format of slow log had changed a while back, so now the
timing information is broken in mysqldumpslow
>How-To-Repeat:
uploaded to mysql secret: n54-slow.log.gz
gunzip n54-slow.log.gz
mysqldumpslow n54-slow.log
>Fix:
1. 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. :)
2. Change:
s/^# Time: (\d+) Lock_time: (\d+) Rows_sent: (\d+).*\n//;
To:
s/^# Query_time: (\d+) Lock_time: (\d+) Rows_sent: (\d+).*\n//;
>Submitter-Id: <submitter ID>
>Originator: Steven Roussey
>Organization:
Network54
>MySQL support: [none anymore :( ]
>Synopsis: <synopsis of the problem (one line)>
>Severity: < serious >
>Priority: <[ low | medium | high ] (one line)>
>Category: mysql
>Class: < sw-bug >
>Release: mysql-3.23.47 (Official MySQL binary)
>Server: /usr/local/bin/mysqladmin Ver 8.23 Distrib 3.23.47, for
pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.47-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 5 days 20 hours 57 min 33 sec
Threads: 81 Questions: 693745099 Slow queries: 2238 Opens: 967352
Flush tables: 1 Open tables: 1510 Queries per second avg: 1367.112
>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux trinity 2.4.16-0.13smp #1 SMP Fri Dec 14 05:10:37 EST 2001
i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.1 2.96-98)
Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc'
CXXFLAGS='-O3 -mpentium -felide-constructors' LDFLAGS='-static'
LIBC:
lrwxrwxrwx 1 root root 13 11-16 13:02 /lib/libc.so.6 ->
libc-2.2.4.so
-rwxr-xr-x 1 root root 1283580 10-03 11:10
/lib/libc-2.2.4.so
-rw-r--r-- 1 root root 27314604 10-03 10:52 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 10-03 10:52 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql
'--with-comment=Official MySQL binary' --with-extra-charsets=complex
--with-server-suffix= --enable-thread-safe-client --enable-assembler
--with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static
--disable-shared
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
