Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 15 Apr 2004 02:46:01 +0100
From:      "Ganbold" <ganbold@micom.mng.net>
To:        <RCorbet@FreeBSD.ORG>
Cc:        threads@freebsd.org
Subject:   Re: FBSD 5.2.CURRENT-p4 and mysqld problems
Message-ID:  <000001c4228b$6845f430$0100000a@cybermedia.local>
In-Reply-To: <20040414143039.511cbf6b@Magellan.Leidinger.net>
References:  <20040413204833.17d23b10@Magellan.Leidinger.net> <Pine.BSF.4.21.0404131448450.24460-100000@InterJet.elischer.org> <20040414124103.6ba2b65c@Magellan.Leidinger.net> <6.0.3.0.2.20040414195314.02a5ac88@202.179.0.80> <20040414133106.7dfc60b7@Magellan.Leidinger.net> <6.0.3.0.2.20040414204141.02a97588@202.179.0.80> <20040414143039.511cbf6b@Magellan.Leidinger.net>

Next in thread | Previous in thread | Raw E-Mail | Index | Archive | Help
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@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


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=Roland@cyber-media.co.uk




Want to link to this message? Use this URL: <http://docs.FreeBSD.org/cgi/mid.cgi?000001c4228b$6845f430$0100000a>