there should be a command in mysql and mysqladmin which shows the active
processlist
when you have a lot of sleeping processes the show processlist in badly to
handle
I think there should be an output like:
xxx processes sleeping
and then: the same output like in show processlist for the nonsleeping
processes
>Submitter-Id: db4491
Originator: Dieter Becker
Organization:
Dr. med. dipl.-math Dieter Becker Tel.: (0 / +49) 6841 - 16 3046
Medizinische Universitaets- und Poliklinik Fax.: (0 / +49) 6841 - 16 3043
Innere Medizin III
D - 66421 Homburg / Saar Email: [EMAIL PROTECTED]
MySQL support: email support
Synopsis: List of active processes
Severity: non-critical
>Priority: low
Category: mysql and mysqladmin
Class: change-request
Release: mysql-3.23.41 (Source distribution)
Server: /usr/local/bin/mysqladmin Ver 8.21 Distrib 3.23.41, for sun-solaris2.6 on
sparc
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.41-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 1 day 4 hours 41 min 9 sec
Threads: 59 Questions: 223750 Slow queries: 40 Opens: 11010 Flush tables: 3051
Open tables: 3 Queries per second avg: 2.167
>Environment:
System: SunOS ukh3029 5.6 Generic_105181-17 sun4u sparc SUNW,Ultra-2
Architecture: sun4
Some paths: /bin/perl /usr/ccs/bin/make /usr/local/bin/gmake /usr/local/bin/gcc
/d0/workshop/SUNWspro/bin/cc
GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.6/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
-rw-r--r-- 1 bin bin 1607728 Oct 19 1999 /lib/libc.a
lrwxrwxrwx 1 root root 11 Feb 8 1998 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 bin bin 1014088 Oct 19 1999 /lib/libc.so.1
-rw-r--r-- 1 bin bin 1607728 Oct 19 1999 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Feb 8 1998 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 bin bin 1014088 Oct 19 1999 /usr/lib/libc.so.1
Configure command: ./configure --with-charset=latin1 --with-extra-charsets=all
Perl: This is perl, version 5.005_02 built for sun4-solaris
---------------------------------------------------------------------
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
