Re: problem with mysql threads on freebsd

[Leo De Geer]

On Tuesday 11 June 2002 16.30, Dan Nelson wrote:
> In the last episode (Jun 11), Leo De Geer said:
> > im not abel to get mysql to use more then one thread on my freebsd
> > 4.5-stable any one having a klue that wrong?????
>
> Do not assume that the way Linux manages threads is the only one.
> Mysql on FreeBSD does create threads; they are just not visible via top
> (in fact Linux is the only OS that shows threads in top).  FreeBSD's
> threads system, however will not put those threads on multiple CPUs.
> You can work around this by building the mysql port with LinuxThreads:
>
> cd /usr/ports/databases/mysql323-server
> make WITH_LINUXTHREADS=yes
>
> This is only useful if your system is dedicated to mysql, though.  If
> it is a combination webserver/database, the other CPU will be busy
> enough serving webpages, and FreeBSD's regular threads will do fine.
thanks that is the thing i have looking for.

regards leo
-- 
MVH C. Leo De Geer
www.dinsignal.com
www.ktv.se
www.teknikshoppen.nu