From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 00:23:46 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 BF6A016A4DB for ; Thu, 15 Apr 2004 00:23:46 -0700 (PDT) Received: from publicd.ub.mng.net (publicd.ub.mng.net [202.179.0.88]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8432443D3F for ; Thu, 15 Apr 2004 00:23:43 -0700 (PDT) (envelope-from ganbold@micom.mng.net) Received: from [202.179.0.164] (helo=ganbold.micom.mng.net) by publicd.ub.mng.net with asmtp (Exim 4.30; FreeBSD) id 1BE25y-000Jx6-JK; Thu, 15 Apr 2004 16:19:38 +0800 Message-Id: <6.0.3.0.2.20040415162511.02afd010@202.179.0.80> X-Sender: ganbold@micom.mng.net@202.179.0.80 X-Mailer: QUALCOMM Windows Eudora Version 6.0.3.0 Date: Thu, 15 Apr 2004 16:28:45 +0900 To: den From: Ganbold In-Reply-To: <407E3725.9020307@myrealbox.com> References: <407E3725.9020307@myrealbox.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed 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 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 15 Apr 2004 07:23:46 -0000 Hi, Probably your mysql wasn't compiled with threads support. You will see difference if you run big query. Mysql will serve to that query and puts into the queue all other queries. You should use threads. regards, Ganbold At 04:17 PM 15.04.2004, you wrote: >I'm sorry that my question is not exactly in essence of problem. >I compile mysql 4.17 ( static compilation ) on 5.2 from ports. I don't >choose linuxthreads , so as I think libpthread was used . >I don't have any problem with mysql on the box. >But when I do >ps axH >I don't see any threads at all. Actually >ps ax >and >ps axH >almost are not differ. >Can you tell me why this is happened ? > >Thanks. >Denis. > >Julian Elischer wrote: > >>firstly, >>how many threads did it create? >>how much memory did it use? >>what does ps -p[pid] -H show? >> >>is it using system scope or process scope threads? >> >>Other people have found that there are tricks to compiling it >>(something to do with compiler options) and tuning considerations.. >> >> >> >> >>On Thu, 15 Apr 2004, Ganbold wrote: >> >> >> >>>Hi, >>> >>>I compiled mysql-4.0.18 from ports on CURRENT machine with >>>BUILD_STATIC=yes option with libpthread. >>>After installation everything seemed OK. However after few minutes it >>>hang again. >>>It seems mysql with libpthread is even more unstable than using >>>linuxthreads. >>> >>>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 >>>> >>> >> >>_______________________________________________ >>freebsd-threads@freebsd.org mailing list >>http://lists.freebsd.org/mailman/listinfo/freebsd-threads >>To unsubscribe, send any mail to "freebsd-threads-unsubscribe@freebsd.org" >> >> >> > >_______________________________________________ >freebsd-threads@freebsd.org mailing list >http://lists.freebsd.org/mailman/listinfo/freebsd-threads >To unsubscribe, send any mail to "freebsd-threads-unsubscribe@freebsd.org" >