I have experienced the same problems on a dual processor machine running
4.2-STABLE and mysql 3.23.36 from the ports tree.
regards,
Lars Andersson
At 16:03 2001-04-09 -0400, Andrew Schmidt wrote:
>Have you tried this under a 'stable' version of freebsd?
>
>In FreeBSD 4.2 beta, mysql would crash with user locks. Not mysql's fault.
>
>now, I understand RC's are generally stable; but I would still make sure
>that this bug doesn't show up in a stable os.
>
>regards,
>
>-- Andrew
>
>----- Original Message -----
>From: <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Monday, April 09, 2001 3:34 PM
>Subject: mysql uses 99% cpu under freebsd 4.3
>
>
> > >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-except
>ions' 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 --witho
>ut-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
---------------------------------------------------------------------
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
