Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 10 Jan 2001 13:54:28 -0500 (EST)
From:      David Miller <dmiller@sparks.net>
To:        Alex Kapranoff <alex@kapran.bitmcnit.bryansk.su>
Cc:        Tom Samplonius <tom@sdf.com>, Lauri Laupmaa <mauri@inspiral.net>, database@freebsd.org
Subject:   Re: mysql (smp) performance
Message-ID:  <Pine.BSF.4.21.0101101352240.73423-100000@search.sparks.net>
In-Reply-To: <20010110205447.A824@kapran.bitmcnit.bryansk.su>

next in thread | previous in thread | raw e-mail | index | archive | help
On Wed, 10 Jan 2001, Alex Kapranoff wrote:

> On Wed, Jan 10, 2001 at 08:24:04AM -0800, Tom Samplonius wrote:
> > On Wed, 10 Jan 2001, Lauri Laupmaa 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.

Thanks,

--- David



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.0101101352240.73423-100000>