FBSD 5.2.CURRENT-p4 and mysqld problems

[Julian Elischer]

2 processes, ok, but ps doesn;t shouw you how many threads..
try ps -auxH


On Thu, 15 Apr 2004, Ganbold wrote:

> Hi,
> 
> I compiled mysql-4.0.18 from ports on CURRENT machine with BUILD_STATIC=yes 
> option.
> However ps ax shows only 2 processes:
> 
> 61652  p0  S      0:00.03 /bin/sh /usr/local/bin/mysqld_safe --user=mysql 
> --datadir=/var/db/mysql --pid-file=/var/db/mysql/ta
> 61671  p0  S      0:00.82 /usr/local/libexec/mysqld --basedir=/usr/local 
> --datadir=/var/db/mysql --user=mysql --pid-file=/var
> 
> But when I compile with linuxthreads I see many threads:
> 
>     88 36250 68876   0  87 11 458452 441436 select 
> SN    ??    0:02.59  (mysqld)
>     88 36253 36250   0  87 11 458452 441436 select 
> SN    ??    0:00.06  (mysqld)
>     88 36254 36253   0  20 14 458452 441436 
> pause  SN    ??    0:00.00  (mysqld)
>     88 36255 36253   0  20 14 458452 441436 
> pause  SN    ??    0:00.00  (mysqld)
>     88 36256 36253   0  20 14 458452 441436 
> pause  SN    ??    0:00.00  (mysqld)
>     88 36257 36253   0  20 14 458452 441436 
> pause  SN    ??    0:00.00  (mysqld)
>     88 36258 36253   0  20 14 458452 441436 
> pause  SN    ??    0:00.00  (mysqld)
>     88 36259 36253   0  90 14 458452 441436 select 
> SN    ??    0:00.77  (mysqld)
>     88 36260 36253   0  20 14 458452 441436 
> pause  SN    ??    0:00.00  (mysqld)
>     88 36270 36253   0  20 11 458452 441436 
> pause  SN    ??    0:00.10  (mysqld)
>     88 36271 36253   0  20 12 458452 441436 
> pause  SN    ??    0:00.00  (mysqld)
>     88 36272 36253   0   4 14 458452 441436 sbwait 
> SN    ??    0:36.24  (mysqld)
>     88 36273 36253   0   4 14 458452 441436 sbwait 
> SN    ??    0:00.25  (mysqld)
>     88 36274 36253   0   4 14 458452 441436 sbwait 
> SN    ??    0:02.07  (mysqld)
>     88 36288 36253   0  20 14 458452 441436 
> pause  SN    ??    0:00.65  (mysqld)
>     88 36297 36253   0   4 14 458452 441436 sbwait 
> SN    ??    0:18.40  (mysqld)
>     88 36298 36253   0  20 14 458452 441436 
> pause  SN    ??    0:02.81  (mysqld)
>     88 38326 36253   0  20 14 458452 441436 
> pause  SN    ??    0:01.60  (mysqld)
>     88 38843 36253   0  20 14 458452 441436 
> pause  SN    ??    0:00.60  (mysqld)
>      0 68876     1   0   8  0  1568 1024 wait   S     p5-   0:00.03 /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
> 
> I thought after default compile of mysqld server and start, it should 
> create several mysql threads.
> I think I compiled mysql without any thread support. How can I compile it 
> to use libpthread?
> 
> thanks in advance,
> 
> Ganbold
> 
> 
> At 09:30 PM 14.04.2004, you wrote:
> >On Wed, 14 Apr 2004 20:44:30 +0900
> >Ganbold <ganbold at micom.mng.net> wrote:
> >
> > > Can you give me some hints and tricks to compile mysql with libpthread?
> > > What compiler options should I use?
> >
> >None, it's the default threading lib with a recent -current. You just
> >have to recompile (every application which may use threads, since mixing
> >the thread libs is not possible, alternatively you can have a look at
> >the man-page of libmap.conf).
> >
> >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
> 
> _______________________________________________
> 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"
>