Date: Thu, 15 Apr 2004 22:46:18 -0400 (EDT) From: Daniel Eischen <eischen@vigrid.com> To: Ganbold <ganbold@micom.mng.net> Cc: threads@freebsd.org Subject: Re: FBSD 5.2.CURRENT-p4 and mysqld problems Message-ID: <Pine.GSO.4.10.10404152229140.3289-100000@pcnet5.pcnet.com> In-Reply-To: <6.0.3.0.2.20040416111531.02b719e8@202.179.0.80>
next in thread | previous in thread | raw e-mail | index | archive | help
On Fri, 16 Apr 2004, Ganbold wrote: > I compiled mysqld with default threading library in FreeBSD 5.2-CURRENT. > > ps axlHwww shows: > > backend2# ps axlHwww | grep mysql > 0 15417 1 0 8 0 1616 1088 wait SL p0 0:00.02 /bin/sh > /usr/local/bin/mysqld_safe --user=mysql --datadir=/var/db/mysql > --pid-file=/var/db/mysql/backend2.pid --log-slow-queries=slow.log > --log=general.log --log-update=update.log --default-character-set=latin1 > 88 15457 15417 0 20 0 450316 449244 kserel > SL p0 0:09.69 (mysqld) > 88 15457 15417 0 20 0 450316 449244 kserel [ ... ] > 88 15457 15417 0 20 0 450316 449244 kserel > SL p0 0:09.69 (mysqld) > 0 15546 778 0 -8 0 1412 820 piperd SL+ p0 0:00.00 grep mysql > 0 13232 796 0 4 0 3472 2664 sbwait SL+ p1 0:00.07 mysql -p > > And I don't see any difference when mapping between different threading > libraries libpthread, libc_r, libkse, libthr. Then you are not doing it correctly. You should only see references to kserel when using libpthread (nee libkse). Please read /usr/src/UPDATING 20040130 and see the -threads archives for related mysql discussions. Unless you rebuild all your ports on that system, you should always use a libmap.conf entry that maps libc_r to your desired thread library as well as mapping libpthread to your desired thread library. To use libpthread, use: libc_r.so.5 libpthread.so.1 libc_r.so libpthread.so To use libc_r, use: libc_r.so.5 libc_r.so.5 libc_r.so libc_r.so libpthread.so.1 libc_r.so.5 libpthread.so libc_r.so To use libthr, use: libc_r.so.5 libthr.so.1 libc_r.so libthr.so libpthread.so.1 libthr.so.1 libpthread.so libthr.so Also, mysql uses scope system threads. I have a patch that makes it use scope process threads and it behaves much better: http://people.freebsd.org/~deischen/mysql40-server.diffs Also, mysql doesn't seem to work correctly when built with --with-libwrap support. It has something to do with compiler flags; see the -threads archives for more info. Also, there are built-in default limits for threads under libpthread. See the output of `sysctl -a | grep kern.threads`. All of the above information can be found in the -threads archives; please use it :-) > > I tried switching all threading libraries in libmap.conf. However output of > the ps axlH command shows always the same and > I'm bit confused. If it worked as it supposed to mysqld with all threading > libs hangs after some time when I run some query. Probably because you are mixing threading libraries. -- Dan Eischen
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.GSO.4.10.10404152229140.3289-100000>