>Description:
mysql uses 99% cpu and becomes extremely unresponsive under high load
>How-To-Repeat:
send about 300 simultaneous visitors to www.chicagobusiness.com and tell them to click
around.
>Fix:
restart mysql. this usally helps, at least for a few minutes. sometimes it climbs
back to 99% though.
>Submitter-Id: <submitter ID>
>Originator: Jon Nathan
>Organization:
Chaffee Interactive
>MySQL support: extended email support
>Synopsis: mysql uses 99% cpu and becomes unresponsive
>Severity: serious
>Priority: high
>Category: mysql
>Class: support
>Release: mysql-3.23.36 (Source distribution) from freebsd ports
>Environment:
System: FreeBSD d1.crain.com 4.3-RC FreeBSD 4.3-RC #1: Tue Apr 3 16:17:52 GMT 2001
[EMAIL PROTECTED]:/usr/obj/usr/src/sys/CHAFFEE i386
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.2 19991024 (release)
Compilation info: CC='cc' CFLAGS='-O2 -pipe -mpentiumpro ' CXX='c++' CXXFLAGS='-O2
-pipe -mpentiumpro -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1170734 Apr 3 12:24 /usr/lib/libc.a
lrwxr-xr-x 1 root wheel 9 Apr 3 12:24 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 559764 Apr 3 12:24 /usr/lib/libc.so.4
Configure command: ./configure --localstatedir=/data/db --without-perl
--without-debug --without-readline --without-bench --with-mit-threads=no
--with-libwrap --with-low-memory --enable-assembler --with-berkeley-db
--with-charset=latin1 --prefix=/usr/local i386--freebsd4.3
Perl: This is perl, version 5.005_03 built for i386-freebsd
---------------------------------------------------------------------
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