From owner-freebsd-threads@FreeBSD.ORG Wed Apr 14 18:39:03 2004 Return-Path: Delivered-To: freebsd-threads@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id B28CC16A4CE for ; Wed, 14 Apr 2004 18:39:03 -0700 (PDT) Received: from cyber-media.co.uk (cms2.gotadsl.co.uk [81.6.247.204]) by mx1.FreeBSD.org (Postfix) with ESMTP id C41BE43D5C for ; Wed, 14 Apr 2004 18:39:02 -0700 (PDT) (envelope-from ganbold@micom.mng.net) Received: from mail pickup service by cyber-media.co.uk with Microsoft SMTPSVC; Thu, 15 Apr 2004 02:46:02 +0100 thread-index: AcQii2hFafiPi3ogR8a59gNrNGrhCQ== Mailing-List: contact mysql-help@lists.mysql.com; run by ezmlm Precedence: bulk Delivered-To: mailing list mysql@lists.mysql.com Message-ID: <000001c4228b$6845f430$0100000a@cybermedia.local> Content-Transfer-Encoding: 7bit Received-SPF: pass (lists: local policy designates 202.179.0.88 as permitted sender) X-Mailer: QUALCOMM Windows Eudora Version 6.0.3.0 Date: Thu, 15 Apr 2004 02:46:01 +0100 To: From: "Ganbold" In-Reply-To: <20040414143039.511cbf6b@Magellan.Leidinger.net> References: <20040413204833.17d23b10@Magellan.Leidinger.net> <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> MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="us-ascii" X-Virus-Checked: Checked Content-Class: urn:content-classes:message Importance: normal Status: Priority: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.132 X-OriginalArrivalTime: 15 Apr 2004 01:46:02.0046 (UTC) FILETIME=[6864EDE0:01C4228B] cc: mysql@lists.mysql.com cc: julian@elischer.org cc: kenm@icarz.com cc: threads@freebsd.org Subject: Re: FBSD 5.2.CURRENT-p4 and mysqld problems X-BeenThere: freebsd-threads@freebsd.org X-Mailman-Version: 2.1.1 List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 15 Apr 2004 01:39:03 -0000 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 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