Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 11 Jan 2001 01:13:18 +0600 (NS)
From:      Max Khon <fjoe@iclub.nsu.ru>
To:        David Miller <dmiller@sparks.net>
Cc:        Alex Kapranoff <alex@kapran.bitmcnit.bryansk.su>, Tom Samplonius <tom@sdf.com>, Lauri Laupmaa <mauri@inspiral.net>, database@FreeBSD.ORG
Subject:   Re: mysql (smp) performance
Message-ID:  <Pine.BSF.4.21.0101110111530.10168-100000@iclub.nsu.ru>
In-Reply-To: <Pine.BSF.4.21.0101101352240.73423-100000@search.sparks.net>

next in thread | previous in thread | raw e-mail | index | archive | help
hi, there!

On Wed, 10 Jan 2001, David Miller wrote:

> > > > It seems that on SMP mysql doesn't scale well. (currently testing on
> > > > dual 833 PIII and running on couple older dual systems)
> > > 
> > >   Because there is no such thing as SMP mysql.  It is a single process,
> > > and can only run on a single processor at a time.
> > 
> >   MySQL is heavily multithreaded and thus should take advantage of good SMP.
> 
> Only if it likes the threads of the host, and if the host manages those
> threads efficiently.  I've "heard all around" that this is a poor area for
> FreeBSD, but would love to hear from someone who can speak with firsthand
> knowledge about freebsd threads and mysql.

FreeBSD threads do not spread over CPUs
-current will have better SMP and better threads implementation
(but AFAIK it is not here yet)

/fjoe



To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-database" in the body of the message




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.4.21.0101110111530.10168-100000>