>Description:
When the system is loaded down and using the max number of connections,
if you do a mysqladmin shutdown, it kills all the mysql processes except
a few. One of the mysqld processes uses 100% cpu and writes this out
to the log file continuously:
010203 22:57:22 Delayed insert thread couldn't get requested lock for
table ArtistRatings
This happens on several tables.
>Fix:
Have to kill -9 the processes
>Release: mysql-3.23.32 (Official MySQL RPM)
>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/lib/mysql/mysql.sock
Uptime: 20 hours 46 min 35 sec
Threads: 99 Questions: 48299363 Slow queries: 34 Opens: 500 Flush tables: 1 Open
tables: 494 Queries per second avg: 645.757
>Environment:
System: Linux db1.audiogalaxy.com 2.2.19pre7 #2 SMP Tue Jan 23 14:13:04 CST 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.0)
Compilation info: CC='egcs' CFLAGS='-O6 -fomit-frame-pointer -mpentium' CXX='egcs'
CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti -mpentium' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 14 Dec 18 04:16 /lib/libc.so.6 ->
libc-2.1.94.so
-rwxr-xr-x 1 root root 4796386 Oct 5 16:46 /lib/libc-2.1.94.so
-rw-r--r-- 1 root root 22737326 Oct 5 16:09 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Oct 5 16:09 /usr/lib/libc.so
Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql
--infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --without-berkeley-db
'--with-comment=Official MySQL RPM'
---------------------------------------------------------------------
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
