I've had the same problem on an Intel P-III 800 w 256M RAM running FreeBSD 4.1-RELEASE
with
both the distribution from the ports tree and the source dist. from mysql.com.
I tried to solve the problem with analysing all the database traffic, but mysql were
taking all free CPU
that were availble on the same database traffic (same database) that were running fine
on a debian linux
machine (Pentium 166, 192M RAM) ... So something weird is happening on some FreeBSD
machines.
But I also have two machines that are _dedicated_ mysql servers of the same
configuration, but other
hardware brand (motherboard, scsi controllers, disks) that runs perfect on the same
FreeBSD release!
The machine with the problem were also running Apache/PHP ..
(How )is MySQL using sharedmemory segments ? I know that Oracle takes up loads of them
and may
bring problem for apache that also needs some seg's.. ?
Regards,
Johan Andersson
Consultant Qbranch
----- Original Message -----
From: "Lars Andersson" <[EMAIL PROTECTED]>
To: "Andrew Schmidt" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Monday, April 09, 2001 11:26 PM
Subject: Re: mysql uses 99% cpu under freebsd 4.3
> 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
>
>
---------------------------------------------------------------------
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