>Description:
Sometimes the query below appears to hang on the table below.
The problem seems worse on queries which come from a
webserver, where persistent DB connections are used. :
The online manual page hints at the same problem elsewhere:
see Tomi Panula-Ontto's comment at
http://www.mysql.com/doc/U/P/UPDATE.html
UPDATE domain_sm
SET age = age + 1, exit_time = NOW(),
exit_env =
'983895322:mxm5480.tc:mxm5480.tc:mxm5480.tc:mxm5480.tc:9'
WHERE identity = 'mjo13684test11.tc'
CREATE TABLE domain_sm (
identity varchar(63) DEFAULT '' NOT NULL,
age int(11) DEFAULT '0' NOT NULL,
state int(11) DEFAULT '0' NOT NULL,
entry_time datetime,
entry_env blob,
exit_time datetime,
exit_env blob,
UNIQUE identity (identity,age),
KEY state (state)
);
>Submitter-Id: <submitter ID>
>Originator: Martin Oldfield
>Organization:
Martin Oldfield,
AdamsNames Ltd.
>
>MySQL support: none
>Synopsis: UPDATE command can sometimes hang
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-3.22.32 (Source distribution)
>Server: /usr/bin/mysqladmin Ver 8.0 Distrib 3.22.32, for pc-linux-gnu on i686
TCX Datakonsult AB, by Monty
Server version 3.22.32-log
Protocol version 10
Connection ptolemy via TCP/IP
TCP port 3306
Uptime: 20 days 1 hour 24 min 22 sec
Threads: 47 Questions: 5773313 Slow queries: 5671 Opens: 68799 Flush tables: 1
Open tables: 63
>Environment:
System: Linux joanna 2.2.17 #1 Thu Oct 19 16:36:18 BST 2000 i686 unknown
Architecture: i686
Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.2/specs
gcc version 2.95.2 20000220 (Debian GNU/Linux)
Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer' CXX='g++'
CXXFLAGS='-O2 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti'
LDFLAGS=''
Configure command: ./configure --enable-shared --without-readline --enable-assembler
--with-mysqld-user=mysql --with-unix-socket-path=/var/run/mysqld/mysqld.sock
--prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc/mysql
--datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info
--includedir=/usr/include --mandir=/usr/share/man
Perl: This is perl, version 5.005_03 built for i386-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
