Skip site navigation (1)Skip section navigation (2)
Date:      Sun, 21 Mar 2004 13:12:46 +0100
From:      Andy Hilker <ah@crypta.net>
To:        Daniel Eischen <eischen@vigrid.com>
Cc:        current@freebsd.org
Subject:   Re: libpthread / mysql41-server
Message-ID:  <20040321121246.GB93532@mail.crypta.net>
In-Reply-To: <Pine.GSO.4.10.10403202355130.23229-100000@pcnet5.pcnet.com>
References:  <20040321005423.GA48575@mail.crypta.net> <Pine.GSO.4.10.10403202355130.23229-100000@pcnet5.pcnet.com>

next in thread | previous in thread | raw e-mail | index | archive | help
Hi,

> > It seems that i have a similar issue like
> > 
> > http://lists.freebsd.org/pipermail/freebsd-threads/2004-February/001660.html
> > 
> > But maybe it is not fixed or exists again.
> > Bumping up thread sysctls or using libmap.conf are not better. mySQL
> > becomes very unresponsive.
> 
> Mysql uses scope system threads which are limited to
> kern.threads.max_groups_per_proc.  System scope threads
> seem to have unfair scheduling also.  

Thats exactly, what i see. Installed port without options needs
sometimes minutes to answer normal easy queries. mysqld processes
is not killable (only by -9).

With this libmap.conf it seems better. But no good comparison to
formerly linuxthreads performance...


[mysqld]
libpthread.so.1        libc_r.so.5
libpthread.so          libc_r.so

[/usr/local/libexec/mysqld]
libpthread.so.1        libc_r.so.5
libpthread.so          libc_r.so


I will test a few patches i received and see if it helps.

Andy



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20040321121246.GB93532>