FBSD 5.2.CURRENT-p4 and mysqld problems

[Julian Elischer]

Are you linking dynamically or statically?


On Thu, 15 Apr 2004, Daniel Eischen wrote:

> 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
> 
> _______________________________________________
> freebsd-threads at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-threads
> To unsubscribe, send any mail to "freebsd-threads-unsubscribe at freebsd.org"
>