>Description:
We have a mysql-slow.log activated. We found many queries with a Time of 0.
See here:
# Time: 010206 13:54:51
# User@Host: xx[xx] @ xx.mobilcom.de [xx]
# Time: 0 Lock_time: 0 Rows_sent: 18
select st_klasse,st_wert from stati group by st_klasse,st_wert order by
st_klasse,st_wert;
And the Result:
cut here....
mysql> select st_klasse,st_wert from stati group by st_klasse,st_wert order by
st_klasse,st_wert;
+-------------------+------------------------------+
| st_klasse | st_wert |
+-------------------+------------------------------+
| | |
| Abbruch | Boni Negativ |
| Abbruch | Eingabe abgebrochen |
| Abbruch | Storno lt. CallCenter Kiel |
| Abbruch | Vertragsverhältnis abgelehnt |
| datenaufnahme | abgebrochen |
| datenaufnahme | läuft |
| Eingabe Storniert | Eingabe abgebrochen |
| Storniert | msisdn freigeben |
| Surfstation | Eingetragen |
| TEST | Beendet |
| token | erzeugt |
| token | unvollständig! |
| workflow | Auftrag erledigt |
| workflow | Auftrag genehmigt |
| workflow | Auftrag storniert |
| workflow | Auftrag wird geprüft |
| workflow | Vertragsverhältnis abgelehnt |
+-------------------+------------------------------+
18 rows in set (0.01 sec)
mysql>
cut here...
Watch the time 0.01 sec ...
>How-To-Repeat:
I think activate mysql-slow.log in startscript or my.cnf.
Make a select on a table and watch the mysql-slow.log File.
>Fix:
I dont now.
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
MobilCom Communication GmbH
>MySQL support: none
>Synopsis: mysql-slow.log entries with time of zero.
>Severity: serious
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.32 (Source distribution)
>Server: /usr/bin/mysqladmin Ver 8.14 Distrib 3.23.32, 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.32-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/mysql/mysql.sock
Uptime: 1 day 2 hours 9 min 43 sec
Threads: 1 Questions: 1141038 Slow queries: 12720 Opens: 5222 Flush tables: 1
Open tables: 512 Queries per second avg: 12.115
>Environment:
System: Linux wsh-101 2.4.1-pre11 #2 SMP Mon Jan 29 16:00:51 CET 2001 i686 unknown
Architecture: i686
Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.2/specs
gcc version 2.95.2 19991024 (release)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
-rwxr-xr-x 1 root root 4071014 Jan 17 19:22 /lib/libc.so.6
-rw-r--r-- 1 root root 19190032 Dez 30 13:22 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Dez 30 13:22 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr --localstatedir=/var
--with-unix-socket-path=/tmp/mysql.sock --with-mysqld-user=mysql --without-debug
--with-extra-charsets=german1,dos
Perl: This is perl, version 5.005_03 built for i586-linux
---------------------------------------------------------------------
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
