Possible Threading problem with -CURRENT / MySQL?

[Lasse Laursen]

Hi Claus,

How many queries per second does the machine handle? We are at approx 100
queries per second in prime time. The load on the server is low and the
performance is OK (haven't tried anything else but FreeBSD so I can't
compare with Linux). Everything is working fine until a single thread
suddenly locks up the entire system. :(

There are no special compile options for neither FreeBSD or for MySQL (from
ports).

Regards
--
Lasse Laursen · VP, Hosting Technology · NetGroup Processing Aps
St. Kongensgade 40H · DK-1264 Copenhagen K, Denmark
Phone: +45 3370 1526 · Fax: +45 3313 0066

- Don't be fooled by cheap finnish imitations - BSD is the One True Code
----- Original Message ----- 
From: "Claus Guttesen" <cguttesen at yahoo.dk>
To: "Daniel Eischen" <eischen at vigrid.com>; "Lasse Laursen"
<laursen at netgroup.dk>
Cc: <freebsd-current at freebsd.org>; "Cedric Tabary" <cedric at carpediem.fr>;
"mike" <mike at mike2k.com>; <freebsd-threads at freebsd.org>
Sent: Tuesday, June 15, 2004 7:12 PM
Subject: Re: Possible Threading problem with -CURRENT / MySQL?


> > > We just had our first lockup for today - and the
> > last one. Next step is to
> > > downgrade to Linux :( *crud*
> >
>
> Maby not the greatest comfort, but I've had a Dell
> 2650 with the Perc3-controller working for weeks. I
> installed rt3 (troubleticket-system) which needed
> Mysql (or postgresql). I installed Mysql 4.0 and
> haven't had problems with it. I increased the amount
> of RAM than Mysql can utilize, but that's about it.
>
> All installed from /usr/ports using portinstall.
>
> FreeBSD 5.2.1, 2 GB RAM, dual Xeon @ 2.4 Ghz. Other
> than enabling -O2 and CPUTYPE=i686 in /etc/make.conf
> and make a customized kernel with amr in my kernel,
> everything else is pretty much default.
>
> I never touched HTT in BIOS nor using sysctl, that's
> working out of the box.
>
> /etc/make.conf:
> CPUTYPE=i686
> CFLAGS= -O2 -pipe -funroll-loops -fno-strict-aliasing
> COPTFLAGS= -O2 -pipe -funroll-loops
> ...
> etc. etc. etc.
>
> /usr/src/sys/i386/conf/DELL2650:
> machine     i386
> cpu            I686_CPU
> ident          DELL
> options      SCHED_4BSD              #4BSD scheduler
> options      SMP                     # Symmetric
> MultiProcessor Kernel
> device        apic
> device        amr             # AMI MegaRAID
> device        bge             # Broadcom BCM570xx
> Gigabit Ethernet
>
> regards
> Claus
>
>
> Yahoo! Mail (http://dk.mail.yahoo.com) - Gratis: 6 MB lagerplads,
spamfilter og virusscan
> _______________________________________________
> freebsd-current at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-current
> To unsubscribe, send any mail to "freebsd-current-unsubscribe at freebsd.org"
>