>Description:
mysqld still seems to hang when nightly table checks are running.
Formerly, this seemed to be due to a race condition that was
hopefully fixed in 3.23.46. Server is up, but all queries are stuck
in "opening tables". mysqld is taking 100% of one CPU. pstack and
other debugging sent under additional cover. Database shutdown
hung, and database was ultimately killed with kill -KILL. Tables
were all marked as closed, though!
>How-To-Repeat:
Run analyze table on all tables while other activity is occuring in
database (particularly connect/disconnects).
>Fix:
Analyze temporarily disabled. However, several large join tables which
are updated nightly need to have analyze run as part of batch stream.
>Submitter-Id: Support #297
>Originator: David Birnbaum
>Organization:
>MySQL support: extended
>Synopsis: mysql stuck on analyze
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.46 (Source distribution)
>Environment:
System: SunOS fosters 5.8 Generic_108528-12 sun4u sparc SUNW,Ultra-4
Architecture: sun4
Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc
GCC: Reading specs from /opt/gcc/3.0.1/lib/gcc-lib/sparc-sun-solaris2.8/3.0.1/specs
Configured with: ../3.0.1/configure --prefix=/opt/gcc/3.0.1
Thread model: posix
gcc version 3.0.1
Compilation info: CC='/opt/gcc/2.95.2/bin/gcc' CFLAGS='-O3 -mcpu=v8
-Wa,-xarch=v8plusa' CXX='/opt/gcc/2.95.2/bin/g++' CXXFLAGS='-O3 -mcpu=v8
-Wa,-xarch=v8plusa -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 11 Mar 31 2001 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root bin 1136748 Nov 27 18:09 /lib/libc.so.1
lrwxrwxrwx 1 root root 11 Mar 31 2001 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root bin 1136748 Nov 27 18:09 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/opt/mysql/3.23.46 --with-berkeley-db
--with-innobase --localstatedir=/export/DB/mysqldb
--with-unix-socket-path=/var/tmp/mysql.sock
---------------------------------------------------------------------
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
