libpthread / mysql41-server

[Andy Hilker]

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