Similar problems on FreeBSD 4.2-RELEASE.
Dedicated Mysql server is pinning the CPU, under a load of 500+ queries
per second. Memory is not exausted, and Disk usage is 0.
Just the CPU is pinned.
[EMAIL PROTECTED] wrote:
>
> >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
---------------------------------------------------------------------
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
