I've seen what's probably the same thing under 4.2-STABLE.
The poll() system call returns 1 but there's no corresponding
file handle marked in the data structures that were passed to poll().
(It could be a mysqld bug if they're asking to poll() for certain kinds
of events but then not checking for those events, but that seems
unlikely. I've no time to check the code.)
Tim.
On Mon, Apr 09, 2001 at 04:03:05PM -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
