FBSD 5.2.CURRENT-p4 and mysqld problems
Ganbold
ganbold at micom.mng.net
Thu Apr 15 19:24:11 PDT 2004
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
SL p0 0:09.69 (mysqld)
88 15457 15417 0 20 0 450316 449244 kserel
SL p0 0:09.69 (mysqld)
88 15457 15417 0 20 0 450316 449244 kserel
SL p0 0:09.69 (mysqld)
88 15457 15417 0 20 0 450316 449244 sigwai
SL p0 0:09.69 (mysqld)
88 15457 15417 0 20 0 450316 449244 ksesig
SL p0 0:09.69 (mysqld)
88 15457 15417 0 20 0 450316 449244 kserel
SL p0 0:09.69 (mysqld)
88 15457 15417 0 20 0 450316 449244 kserel
SL p0 0:09.69 (mysqld)
88 15457 15417 0 76 0 450316 449244 select
SL p0 0:09.69 (mysqld)
88 15457 15417 0 4 0 450316 449244 sbwait
SL p0 0:09.69 (mysqld)
88 15457 15417 0 20 0 450316 449244 kserel
SL p0 0:09.69 (mysqld)
88 15457 15417 0 20 0 450316 449244 kserel
SL p0 0:09.69 (mysqld)
88 15457 15417 0 20 0 450316 449244 kserel
SL p0 0:09.69 (mysqld)
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.
But when I use linuxthreads it shows:
backend2# ps axlHwww | grep mysql
0 16207 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 16247 16207 0 87 11 458008 442512 select
SNL p0 0:02.12 (mysqld)
88 16248 16247 0 87 11 458008 442512 select
SNL p0 0:00.01 (mysqld)
88 16249 16248 0 20 14 458008 442512
pause SNL p0 0:00.00 (mysqld)
88 16250 16248 0 20 14 458008 442512
pause SNL p0 0:00.00 (mysqld)
88 16251 16248 0 20 14 458008 442512
pause SNL p0 0:00.00 (mysqld)
88 16252 16248 0 20 14 458008 442512
pause SNL p0 0:00.00 (mysqld)
88 16253 16248 0 20 14 458008 442512
pause SNL p0 0:00.00 (mysqld)
88 16254 16248 0 90 14 458008 442512 select
SNL p0 0:00.08 (mysqld)
88 16255 16248 0 20 14 458008 442512
pause SNL p0 0:00.00 (mysqld)
88 16257 16248 0 20 11 458008 442512
pause SNL p0 0:00.01 (mysqld)
88 16258 16248 0 20 12 458008 442512
pause SNL p0 0:00.00 (mysqld)
88 16260 16248 0 20 14 458008 442512
pause SNL p0 0:00.11 (mysqld)
88 16268 16248 0 139 14 458008 442512
- RNL p0 0:46.80 (mysqld)
88 16274 16248 0 4 14 458008 442512 sbwait
SNL p0 0:00.12 (mysqld)
88 16275 16248 0 4 14 458008 442512 sbwait
SNL p0 0:00.25 (mysqld)
88 16276 16248 0 4 14 458008 442512 sbwait
SNL p0 0:02.80 (mysqld)
88 16277 16248 0 20 14 458008 442512
pause SNL p0 0:00.10 (mysqld)
0 16827 778 0 76 0 1364 768 Giant LL+ p0 0:00.00 grep mysql
0 16273 796 0 4 0 3476 2672 sbwait SL+ p1 0:00.04 mysql -p
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.
But linuxthreads seems more stable, it hangs once per 24 hours, every
morning around 8.20AM GMT+9.
I still don't know the reason. Is it hangs because thread count reaches
some number? Or is it hangs because query count reaches some
number? Because it hangs always at same time around 8.20am. No any database
script is running at this time.
tia,
Ganbold
At 07:02 PM 15.04.2004, you wrote:
>On Thu, 15 Apr 2004 18:07:55 +0900
>Ganbold <ganbold at micom.mng.net> wrote:
>
> > > > Is there any trick compiling mysql with libpthread? Without any
> trick it
> > > > just hangs.
> > >
> > >This may be a bug. Please rebuild without BUILD_STATIC and use
> > >libmap.conf to try all 3 thread libs (libc_r, libpthread and libthr). If
> > >only libpthread shows this behavior, it may be a bug in libpthread.
> >
> > I will try libmap.conf to map between threads. Is there any special option
> > should I compile in kernel in order to use libmap.conf?
>
>No.
>
>Use
>---snip---
>libpthread.so.1 libc_r.so.5
>libpthread.so libc_r.so
>---snip---
>to globally map libpthread to libc_r.
>
>Use
>---snip---
>libpthread.so.1 libthr.so.1
>libpthread.so libthr.so
>---snip---
>to globally map to libthr.
>
>
>Bye,
>Alexander.
>
>--
> I'm available to get hired.
>
>http://www.Leidinger.net Alexander @ Leidinger.net
> GPG fingerprint = C518 BC70 E67F 143F BE91 3365 79E2 9C60 B006 3FE7
More information about the freebsd-threads
mailing list