From owner-freebsd-threads@FreeBSD.ORG Mon Apr 12 11:01:36 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 8739916A4CE for ; Mon, 12 Apr 2004 11:01:36 -0700 (PDT) Received: from freefall.freebsd.org (freefall.freebsd.org [216.136.204.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6A73D43D3F for ; Mon, 12 Apr 2004 11:01:36 -0700 (PDT) (envelope-from owner-bugmaster@freebsd.org) Received: from freefall.freebsd.org (peter@localhost [127.0.0.1]) i3CI1abv084502 for ; Mon, 12 Apr 2004 11:01:36 -0700 (PDT) (envelope-from owner-bugmaster@freebsd.org) Received: (from peter@localhost) by freefall.freebsd.org (8.12.10/8.12.10/Submit) id i3CI1Zid084496 for freebsd-threads@freebsd.org; Mon, 12 Apr 2004 11:01:35 -0700 (PDT) (envelope-from owner-bugmaster@freebsd.org) Date: Mon, 12 Apr 2004 11:01:35 -0700 (PDT) Message-Id: <200404121801.i3CI1Zid084496@freefall.freebsd.org> X-Authentication-Warning: freefall.freebsd.org: peter set sender to owner-bugmaster@freebsd.org using -f From: FreeBSD bugmaster To: freebsd-threads@FreeBSD.org Subject: Current problem reports assigned to you 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: Mon, 12 Apr 2004 18:01:36 -0000 Current FreeBSD problem reports Critical problems S Submitted Tracker Resp. Description ------------------------------------------------------------------------------- o [2000/06/13] kern/19247 threads uthread_sigaction.c does not do anything s [2004/03/15] kern/64313 threads FreeBSD (OpenBSD) pthread implicit set/un 2 problems total. Serious problems S Submitted Tracker Resp. Description ------------------------------------------------------------------------------- o [2000/07/18] kern/20016 threads pthreads: Cannot set scheduling timer/Can o [2000/08/26] misc/20861 threads libc_r does not honor socket timeouts o [2001/01/19] bin/24472 threads libc_r does not honor SO_SNDTIMEO/SO_RCVT o [2001/01/25] bin/24632 threads libc_r delicate deviation from libc in ha o [2001/01/25] misc/24641 threads pthread_rwlock_rdlock can deadlock o [2001/11/26] bin/32295 threads pthread dont dequeue signals o [2002/02/01] i386/34536 threads accept() blocks other threads o [2002/05/25] kern/38549 threads the procces compiled whith pthread stoppe o [2002/06/27] bin/39922 threads [PATCH?] Threaded applications executed w o [2002/08/04] misc/41331 threads Pthread library open sets O_NONBLOCK flag o [2003/03/02] bin/48856 threads Setting SIGCHLD to SIG_IGN still leaves z o [2003/03/10] bin/49087 threads Signals lost in programs linked with libc a [2003/04/08] bin/50733 threads buildworld won't build, because of linkin o [2003/05/07] bin/51949 threads thread in accept cannot be cancelled 14 problems total. Non-critical problems S Submitted Tracker Resp. Description ------------------------------------------------------------------------------- o [2000/05/25] misc/18824 threads gethostbyname is not thread safe o [2000/10/21] misc/22190 threads A threaded read(2) from a socketpair(2) f o [2001/09/09] bin/30464 threads pthread mutex attributes -- pshared o [2002/05/02] bin/37676 threads libc_r: msgsnd(), msgrcv(), pread(), pwri s [2002/07/16] misc/40671 threads pthread_cancel doesn't remove thread from 5 problems total. From owner-freebsd-threads@FreeBSD.ORG Mon Apr 12 12:20: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 4384716A4CE; Mon, 12 Apr 2004 12:20:46 -0700 (PDT) Received: from mail.vicor-nb.com (bigwoop.vicor-nb.com [208.206.78.2]) by mx1.FreeBSD.org (Postfix) with ESMTP id 92AD443D31; Mon, 12 Apr 2004 12:20:45 -0700 (PDT) (envelope-from julian@vicor.com) Received: from vicor.com (julian.vicor-nb.com [208.206.78.97]) by mail.vicor-nb.com (Postfix) with ESMTP id D24677A41E; Mon, 12 Apr 2004 12:20:44 -0700 (PDT) Message-ID: <407AEC0C.2050801@vicor.com> Date: Mon, 12 Apr 2004 12:20:44 -0700 From: Julian Elischer Organization: VICOR User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.3.1) Gecko/20030516 X-Accept-Language: en, hu MIME-Version: 1.0 To: current@freebsd.org, threads@freebsd.org Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Subject: heavy threads users, test? 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: Mon, 12 Apr 2004 19:20:46 -0000 Appologies if you've seen this before. I never saw my previous post come back to me from -current.. I don't know where it went.. Hi, If you have a system that is using threads heavily (either libthr or libpthreads) or have a heavy (possibly varying) load (the heavier the better) (and the more varying and different (threaded or not) apps you run on it the better), then I would like to ask you to try get the following information for me.. The basic command is: julian@jules:sysctl vm.zone | grep -E "THREAD|PROC|REQUESTS" ITEM SIZE LIMIT USED FREE REQUESTS THREAD: 328, 0, 162, 30, 1061173 PROC: 440, 0, 130, 32, 92919 What I need to see is the variation in the total number of threads and processes available and in use as a function of time.. basically, "In a real world scenario, how much does the total of "USED and FREE" change over time?" This is because, for both processes and threads, there are significant resources (e.g. kernel stack) allocated as these entities are created and freed when they are destroyed and I'm trying to work out how much "thrashing" we are getting (or avoiding) by caching them in a system that is under varying load. Should we add more hysteresis or less? Theoretically when a system reaches "steady state (if such thing exists) then threads should hopefully move between the thread cache and active use but hopefully we should not be creating and destroying many (if any). The following hacked up script reports whenever threads have been recently created or destroyed: #!/bin/sh PREV="0" while : do LINE=`sysctl vm.zone | grep "THREAD:"` IFS=' ,' set $LINE NEW=$(($4 + $5)) if [ $PREV != $NEW ] then echo `date`": total threads changed from $PREV to $NEW" sysctl vm.zone | grep -E "THREAD:|PROC:|REQUESTS" fi PREV=$NEW sleep 60 done If you have an "interesting' load (under -current) I would like to see the output of the above script run over the course of a day or two (or longer). (sample output below) julian@jules:sh /tmp/xx.sh Mon Apr 12 00:32:22 PDT 2004: total threads changed from 0 to 192 ITEM SIZE LIMIT USED FREE REQUESTS THREAD: 328, 0, 162, 30, 1061173 PROC: 440, 0, 130, 32, 92919 Mon Apr 12 00:34:23 PDT 2004: total threads changed from 192 to 264 ITEM SIZE LIMIT USED FREE REQUESTS THREAD: 328, 0, 243, 21, 1061896 PROC: 440, 0, 191, 52, 93640 Thanks! Julian From owner-freebsd-threads@FreeBSD.ORG Mon Apr 12 18:35:18 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 9225616A4CE for ; Mon, 12 Apr 2004 18:35:18 -0700 (PDT) Received: from rwcrmhc12.comcast.net (rwcrmhc12.comcast.net [216.148.227.85]) by mx1.FreeBSD.org (Postfix) with ESMTP id 74EAA43D45 for ; Mon, 12 Apr 2004 18:35:18 -0700 (PDT) (envelope-from julian@elischer.org) Received: from interjet.elischer.org ([24.7.73.28]) by comcast.net (rwcrmhc12) with ESMTP id <20040413013517014001is7ne>; Tue, 13 Apr 2004 01:35:18 +0000 Received: from localhost (localhost.elischer.org [127.0.0.1]) by InterJet.elischer.org (8.9.1a/8.9.1) with ESMTP id SAA13736; Mon, 12 Apr 2004 18:35:16 -0700 (PDT) Date: Mon, 12 Apr 2004 18:35:15 -0700 (PDT) From: Julian Elischer To: Ganbold In-Reply-To: <6.0.3.0.2.20040413101504.02b09968@202.179.0.80> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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: Tue, 13 Apr 2004 01:35:18 -0000 huh? you are running -current and you don't know we have 3 threading libraries? libc_r libthr (one kernel thread per user thread, system contention scope) libpthreads (pretty much all the bells and whistles). do you mean 5.2-RELEASE-p4 or 5.2.1-RELEASE? what exactly are you running? (it makes a difference because libpthread only became the default after 5.2.1) there is even a whole thread about running mysql linked with -lpthread. I've cc'd the threads list as I've never run Mysql (ever). but many on this list have and they can tell you the "gotcha's". On Tue, 13 Apr 2004, Ganbold wrote: > Hi, > > At 09:57 AM 13.04.2004, you wrote: > > > >On Tue, 13 Apr 2004, Ganbold wrote: > > > > > Ken, > > > > > > Thank you very much for reply. I'm having this problem since March 13th, > > > and having big trouble. > > > I compiled mysql with linuxthreads-2.2.3-15. > > > >Is there a reason you don't use one of the FreeBSD threading libraries? > > What kind of libraries? Can you mention those? How can I compile mysql to > use one of threading libraries? > > tia, > > Ganbold > > > > > > > From owner-freebsd-threads@FreeBSD.ORG Tue Apr 13 14:49:49 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 A90D016A4CE for ; Tue, 13 Apr 2004 14:49:49 -0700 (PDT) Received: from sccrmhc11.comcast.net (sccrmhc11.comcast.net [204.127.202.55]) by mx1.FreeBSD.org (Postfix) with ESMTP id 010CC43D54 for ; Tue, 13 Apr 2004 14:49:49 -0700 (PDT) (envelope-from julian@elischer.org) Received: from interjet.elischer.org ([24.7.73.28]) by comcast.net (sccrmhc11) with ESMTP id <20040413214941011009f0vre>; Tue, 13 Apr 2004 21:49:48 +0000 Received: from localhost (localhost.elischer.org [127.0.0.1]) by InterJet.elischer.org (8.9.1a/8.9.1) with ESMTP id OAA24605; Tue, 13 Apr 2004 14:49:41 -0700 (PDT) Date: Tue, 13 Apr 2004 14:49:41 -0700 (PDT) From: Julian Elischer To: Alexander Leidinger In-Reply-To: <20040413204833.17d23b10@Magellan.Leidinger.net> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII cc: Ken Menzel 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: Tue, 13 Apr 2004 21:49:49 -0000 So is this with system scope threads or process scope threads? what is the performance like? On Tue, 13 Apr 2004, Alexander Leidinger wrote: > On Tue, 13 Apr 2004 06:15:55 -0700 (PDT) > Julian Elischer wrote: > > > Is this still te case? > > I can't reproduce the issue with -current as of today on a different > machine. > > 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-current@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-current > To unsubscribe, send any mail to "freebsd-current-unsubscribe@freebsd.org" > From owner-freebsd-threads@FreeBSD.ORG Tue Apr 13 18:44:21 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 0ADE116A4CE for ; Tue, 13 Apr 2004 18:44:21 -0700 (PDT) Received: from exchhz01.viatech.com.cn (ip-40-162-97-218.anlai.com [218.97.162.40]) by mx1.FreeBSD.org (Postfix) with ESMTP id A8C2A43D58 for ; Tue, 13 Apr 2004 18:44:10 -0700 (PDT) (envelope-from davidxu@freebsd.org) Received: from freebsd.org (DAVIDWNT [10.4.1.99]) by exchhz01.viatech.com.cn with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2650.21) id 2KSL2K9Q; Wed, 14 Apr 2004 09:35:02 +0800 Message-ID: <407C9584.10805@freebsd.org> Date: Wed, 14 Apr 2004 09:36:04 +0800 From: David Xu User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.5b) Gecko/20030723 Thunderbird/0.1 X-Accept-Language: en-us, en MIME-Version: 1.0 To: threads@FreeBSD.org Content-Type: multipart/mixed; boundary="------------060209070405000405090909" Subject: [Fwd: cvs commit: src/sys/kern kern_fork.c kern_thr.c kern_thread.c src/sys/sys proc.h] 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: Wed, 14 Apr 2004 01:44:21 -0000 This is a multi-part message in MIME format. --------------060209070405000405090909 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit This commit would change the way how gdb searches a thread by using ptrace interface in my thread debugging patch: http://people.freebsd.org/~davidxu/kse/thread_db the patch is now supporting libpthread and libthr, however because libthr is using another type of thread identify thr_id_t, if I follow the commit, the patch won't work, libthr and its interfaces need to be changed to use integer tid, libpthread won't be affected because it never uses kernel thread id. David Xu --------------060209070405000405090909 Content-Type: message/rfc822;src/sys/sysproc.h" Content-Transfer-Encoding: 7bit Content-Disposition: inline;kern_thread.c src/sys/sysproc.h" Received: from exchange.via.com.tw (EXCHANGE [202.145.217.203]) by exchhz01.viatech.com.cn with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2650.21) id HNTCCTWQ; Sun, 4 Apr 2004 00:01:21 +0800 Received: by exchange.vntek.com.tw with Internet Mail Service (5.5.2650.21) id ; Sun, 4 Apr 2004 00:00:39 +0800 Received: from exchsh01.viatech.com.cn (ip-33-237-104-152.anlai.com [152.104.237.33]) by exchange.via.com.tw with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2650.21) id G6LCKB6Y; Sun, 4 Apr 2004 00:00:37 +0800 Received: by exchsh01.viatech.com.cn with Internet Mail Service (5.5.2653.19) id ; Sun, 4 Apr 2004 00:00:53 +0800 Received: from mx2.freebsd.org ([216.136.204.119]) by exchsh01.viatech.com.cn with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id HZZH4KSZ; Sun, 4 Apr 2004 00:00:52 +0800 Received: from hub.freebsd.org (hub.freebsd.org [216.136.204.18]) by mx2.freebsd.org (Postfix) with ESMTP id E821657680; Sat, 3 Apr 2004 07:59:33 -0800 (PST) (envelope-from owner-src-committers@FreeBSD.org) Received: by hub.freebsd.org (Postfix) id D3D2316A509; Sat, 3 Apr 2004 07:59:27 -0800 (PST) Received: by hub.freebsd.org (Postfix, from userid 538) id 7D7C816A4D1; Sat, 3 Apr 2004 07:59:27 -0800 (PST) Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 5FD1016A4CE; Sat, 3 Apr 2004 07:59:16 -0800 (PST) Received: from repoman.freebsd.org (repoman.freebsd.org [216.136.204.115]) by mx1.FreeBSD.org (Postfix) with ESMTP id 586D843D2F; Sat, 3 Apr 2004 07:59:16 -0800 (PST) (envelope-from marcel@FreeBSD.org) Received: from repoman.freebsd.org (localhost [127.0.0.1]) by repoman.freebsd.org (8.12.10/8.12.10) with ESMTP id i33FxDGe085917; Sat, 3 Apr 2004 07:59:13 -0800 (PST) (envelope-from marcel@repoman.freebsd.org) Received: (from marcel@localhost) by repoman.freebsd.org (8.12.10/8.12.10/Submit) id i33FxDMt085916; Sat, 3 Apr 2004 07:59:13 -0800 (PST) (envelope-from marcel) Delivered-To: davidxu@freebsd.org Delivered-To: src-committers@freebsd.org Message-Id: <200404031559.i33FxDMt085916@repoman.freebsd.org> From: Marcel Moolenaar Date: Sat, 3 Apr 2004 07:59:13 -0800 (PST) To: src-committers@FreeBSD.org, cvs-src@FreeBSD.org, cvs-all@FreeBSD.org Subject: cvs commit: src/sys/kern kern_fork.c kern_thr.c kern_thread.c src/sys/sys proc.h X-FreeBSD-CVS-Branch: HEAD Sender: owner-src-committers@FreeBSD.org Precedence: bulk X-Loop: FreeBSD.ORG marcel 2004/04/03 07:59:13 PST FreeBSD src repository Modified files: sys/kern kern_fork.c kern_thr.c kern_thread.c sys/sys proc.h Log: Assign thread IDs to kernel threads. The purpose of the thread ID (tid) is twofold: 1. When a 1:1 or M:N threaded process dumps core, we need to put the register state of each of its kernel threads in the core file. This can only be done by differentiating the pid field in the respective note. For this we need the tid. 2. When thread support is present for remote debugging the kernel with gdb(1), threads need to be identified by an integer due to limitations in the remote protocol. This requires having a tid. To minimize the impact of having thread IDs, threads that are created as part of a fork (i.e. the initial thread in a process) will inherit the process ID (i.e. tid=pid). Subsequent threads will have IDs larger than PID_MAX to avoid interference with the pid allocation algorithm. The assignment of tids is handled by thread_new_tid(). The thread ID allocation algorithm has been written with 3 assumptions in mind: 1. IDs need to be created as fast a possible, 2. Reuse of IDs may happen instantaneously, 3. Someone else will write a better algorithm. Revision Changes Path 1.225 +1 -0 src/sys/kern/kern_fork.c 1.18 +1 -0 src/sys/kern/kern_thr.c 1.175 +98 -2 src/sys/kern/kern_thread.c 1.373 +2 -0 src/sys/sys/proc.h --------------060209070405000405090909-- From owner-freebsd-threads@FreeBSD.ORG Wed Apr 14 01:10:24 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 372F216A4CE; Wed, 14 Apr 2004 01:10:24 -0700 (PDT) Received: from sccrmhc13.comcast.net (sccrmhc13.comcast.net [204.127.202.64]) by mx1.FreeBSD.org (Postfix) with ESMTP id D5FD643D4C; Wed, 14 Apr 2004 01:10:23 -0700 (PDT) (envelope-from julian@elischer.org) Received: from interjet.elischer.org ([24.7.73.28]) by comcast.net (sccrmhc13) with ESMTP id <20040414081022016003g9que>; Wed, 14 Apr 2004 08:10:23 +0000 Received: from localhost (localhost.elischer.org [127.0.0.1]) by InterJet.elischer.org (8.9.1a/8.9.1) with ESMTP id BAA30240; Wed, 14 Apr 2004 01:10:21 -0700 (PDT) Date: Wed, 14 Apr 2004 01:10:20 -0700 (PDT) From: Julian Elischer To: David Xu In-Reply-To: <407C9584.10805@freebsd.org> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII cc: threads@FreeBSD.org Subject: Re: [Fwd: cvs commit: src/sys/kern kern_fork.c kern_thr.ckern_thread.c src/sys/sys proc.h] 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: Wed, 14 Apr 2004 08:10:24 -0000 On Wed, 14 Apr 2004, David Xu wrote: > This commit would change the way how gdb searches a thread by using > ptrace interface > in my thread debugging patch: > http://people.freebsd.org/~davidxu/kse/thread_db > the patch is now supporting libpthread and libthr, however because > libthr is using another type > of thread identify thr_id_t, if I follow the commit, the patch won't > work, libthr and its interfaces > need to be changed to use integer tid, libpthread won't be affected > because it never uses kernel > thread id. > > David Xu After discussing this with marcel, this code may change a bit. you only need a TID in the case where sizeof(void *) != sizeof(int) From owner-freebsd-threads@FreeBSD.ORG Wed Apr 14 03:40:57 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 064FB16A4CE for ; Wed, 14 Apr 2004 03:40:57 -0700 (PDT) Received: from mailout09.sul.t-online.com (mailout09.sul.t-online.com [194.25.134.84]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5EC5143D48 for ; Wed, 14 Apr 2004 03:40:56 -0700 (PDT) (envelope-from Alexander@Leidinger.net) Received: from fwd09.aul.t-online.de by mailout09.sul.t-online.com with smtp id 1BDhp7-0004NV-03; Wed, 14 Apr 2004 12:40:53 +0200 Received: from Andro-Beta.Leidinger.net (SyGed8ZCQe307m6MXNUvBE7+WgVWCh3nY+3DLcmaK91elvhO5O1k8w@[217.83.19.131]) by fmrl09.sul.t-online.com with esmtp id 1BDhox-07YZKy0; Wed, 14 Apr 2004 12:40:43 +0200 Received: from Magellan.Leidinger.net (Magellan.Leidinger.net [192.168.1.1]) i3EAecbq050852; Wed, 14 Apr 2004 12:40:38 +0200 (CEST) (envelope-from Alexander@Leidinger.net) Date: Wed, 14 Apr 2004 12:41:03 +0200 From: Alexander Leidinger To: Julian Elischer Message-Id: <20040414124103.6ba2b65c@Magellan.Leidinger.net> In-Reply-To: References: <20040413204833.17d23b10@Magellan.Leidinger.net> X-Mailer: Sylpheed version 0.9.10claws (GTK+ 1.2.10; i386-portbld-freebsd5.2) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Seen: false X-ID: SyGed8ZCQe307m6MXNUvBE7+WgVWCh3nY+3DLcmaK91elvhO5O1k8w@t-dialin.net cc: Alexander Leidinger cc: threads@freebsd.org cc: Ken Menzel 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: Wed, 14 Apr 2004 10:40:57 -0000 On Tue, 13 Apr 2004 14:49:41 -0700 (PDT) Julian Elischer wrote: > So is this with system scope threads or process scope threads? Whatever MySQL uses when compiled to use libpthread. > what is the performance like? It's a different system (2.4 GHz P4, vinum-stripe on 2 SATA disks (ICH5), 1GB RAM) and the kernel is compiled with icc, so I can't compare. But it was fast. Just some seconds to add this with the mysql client program: % wc nurdaten.sql 30161 180515 4781902 nurdaten.sql % grep INSERT nurdaten.sql | wc -l 30007 The other system (2.8 GHz P4, ATA-stripe (Promise) on 2 SATA disks, 1GB RAM) with a -current as of March 19 needed several seconds longer (with linuxthreads instead of pthreads). But we're comparing apples with oranges here. 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 From owner-freebsd-threads@FreeBSD.ORG Wed Apr 14 03:54: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 D12AF16A4CE for ; Wed, 14 Apr 2004 03:54: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 0EA1D43D2D for ; Wed, 14 Apr 2004 03:54: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 1BDiuO-000P9o-RI; Wed, 14 Apr 2004 19:50:24 +0800 Message-Id: <6.0.3.0.2.20040414195314.02a5ac88@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: Wed, 14 Apr 2004 19:59:33 +0900 To: Alexander Leidinger From: Ganbold In-Reply-To: <20040414124103.6ba2b65c@Magellan.Leidinger.net> References: <20040413204833.17d23b10@Magellan.Leidinger.net> <20040414124103.6ba2b65c@Magellan.Leidinger.net> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed cc: kenm@icarz.com cc: mysql@lists.mysql.com cc: julian@elischer.org 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: Wed, 14 Apr 2004 10:54:46 -0000 Hi, So what threading library should I use with mysql? Can somebody recommend me which to use? Because I'm bit confused. I used to use linuxthreads and it was pretty good. Now there appears some other threading libraries:) Which one is reliable and has good performance? Ganbold At 07:41 PM 14.04.2004, you wrote: >On Tue, 13 Apr 2004 14:49:41 -0700 (PDT) >Julian Elischer wrote: > > > So is this with system scope threads or process scope threads? > >Whatever MySQL uses when compiled to use libpthread. > > > what is the performance like? > >It's a different system (2.4 GHz P4, vinum-stripe on 2 SATA disks >(ICH5), 1GB RAM) and the kernel is compiled with icc, so I can't >compare. But it was fast. Just some seconds to add this with the mysql >client program: > % wc nurdaten.sql > 30161 180515 4781902 nurdaten.sql > > % grep INSERT nurdaten.sql | wc -l > 30007 > >The other system (2.8 GHz P4, ATA-stripe (Promise) on 2 SATA disks, 1GB >RAM) with a -current as of March 19 needed several seconds longer (with >linuxthreads instead of pthreads). But we're comparing apples with >oranges here. > >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 From owner-freebsd-threads@FreeBSD.ORG Wed Apr 14 04:11:59 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 1A40E16A4CE for ; Wed, 14 Apr 2004 04:11:59 -0700 (PDT) Received: from cyber-media.co.uk (cms2.gotadsl.co.uk [81.6.247.204]) by mx1.FreeBSD.org (Postfix) with ESMTP id C3EEE43D5E for ; Wed, 14 Apr 2004 04:11:57 -0700 (PDT) (envelope-from ganbold@micom.mng.net) Received: from mail pickup service by cyber-media.co.uk with Microsoft SMTPSVC; Wed, 14 Apr 2004 12:16:05 +0100 thread-index: AcQiEeChFi5rkpCLQJarKoqfJdkCpg== Mailing-List: contact mysql-help@lists.mysql.com; run by ezmlm Precedence: bulk Delivered-To: mailing list mysql@lists.mysql.com Message-ID: <000f01c42211$e0a45130$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: Wed, 14 Apr 2004 12:16:05 +0100 To: From: "Ganbold" Content-Class: urn:content-classes:message In-Reply-To: <20040414124103.6ba2b65c@Magellan.Leidinger.net> Importance: normal Priority: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.132 References: <20040413204833.17d23b10@Magellan.Leidinger.net> <20040414124103.6ba2b65c@Magellan.Leidinger.net> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Virus-Checked: Checked Status: X-OriginalArrivalTime: 14 Apr 2004 11:16:05.0359 (UTC) FILETIME=[E0BE8FF0:01C42211] cc: kenm@icarz.com cc: mysql@lists.mysql.com cc: julian@elischer.org 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: Wed, 14 Apr 2004 11:11:59 -0000 Hi, So what threading library should I use with mysql? Can somebody recommend me which to use? Because I'm bit confused. I used to use linuxthreads and it was pretty good. Now there appears some other threading libraries:) Which one is reliable and has good performance? Ganbold At 07:41 PM 14.04.2004, you wrote: >On Tue, 13 Apr 2004 14:49:41 -0700 (PDT) >Julian Elischer wrote: > > > So is this with system scope threads or process scope threads? > >Whatever MySQL uses when compiled to use libpthread. > > > what is the performance like? > >It's a different system (2.4 GHz P4, vinum-stripe on 2 SATA disks >(ICH5), 1GB RAM) and the kernel is compiled with icc, so I can't >compare. But it was fast. Just some seconds to add this with the mysql >client program: > % wc nurdaten.sql > 30161 180515 4781902 nurdaten.sql > > % grep INSERT nurdaten.sql | wc -l > 30007 > >The other system (2.8 GHz P4, ATA-stripe (Promise) on 2 SATA disks, 1GB >RAM) with a -current as of March 19 needed several seconds longer (with >linuxthreads instead of pthreads). But we're comparing apples with >oranges here. > >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 From owner-freebsd-threads@FreeBSD.ORG Wed Apr 14 04:31:18 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 140D416A4CE for ; Wed, 14 Apr 2004 04:31:17 -0700 (PDT) Received: from mailout06.sul.t-online.com (mailout06.sul.t-online.com [194.25.134.19]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9678243D41 for ; Wed, 14 Apr 2004 04:31:17 -0700 (PDT) (envelope-from Alexander@Leidinger.net) Received: from fwd07.aul.t-online.de by mailout06.sul.t-online.com with smtp id 1BDibg-0003n9-03; Wed, 14 Apr 2004 13:31:04 +0200 Received: from Andro-Beta.Leidinger.net (S8b4haZrgebvV1zObLv89U6X83cqS44Ma7LvE35j0M9TKu-X8VLpwh@[217.83.19.131]) by fmrl07.sul.t-online.com with esmtp id 1BDibN-1oifyq0; Wed, 14 Apr 2004 13:30:45 +0200 Received: from Magellan.Leidinger.net (Magellan.Leidinger.net [192.168.1.1]) i3EBUfCP057936; Wed, 14 Apr 2004 13:30:41 +0200 (CEST) (envelope-from Alexander@Leidinger.net) Date: Wed, 14 Apr 2004 13:31:06 +0200 From: Alexander Leidinger To: Ganbold Message-Id: <20040414133106.7dfc60b7@Magellan.Leidinger.net> In-Reply-To: <6.0.3.0.2.20040414195314.02a5ac88@202.179.0.80> References: <20040413204833.17d23b10@Magellan.Leidinger.net> <20040414124103.6ba2b65c@Magellan.Leidinger.net> <6.0.3.0.2.20040414195314.02a5ac88@202.179.0.80> X-Mailer: Sylpheed version 0.9.10claws (GTK+ 1.2.10; i386-portbld-freebsd5.2) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Seen: false X-ID: S8b4haZrgebvV1zObLv89U6X83cqS44Ma7LvE35j0M9TKu-X8VLpwh@t-dialin.net cc: kenm@icarz.com cc: mysql@lists.mysql.com cc: julian@elischer.org 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: Wed, 14 Apr 2004 11:31:18 -0000 On Wed, 14 Apr 2004 19:59:33 +0900 Ganbold wrote: > So what threading library should I use with mysql? > Can somebody recommend me which to use? Because I'm bit confused. > I used to use linuxthreads and it was pretty good. Now there appears some > other threading libraries:) > Which one is reliable and has good performance? At least with a recent -current: libpthread (the default) is not obviously bad. With 5.2.1 I suggest to use linuxthreads (libc_r is the default with 5.2.1). 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 From owner-freebsd-threads@FreeBSD.ORG Wed Apr 14 04:39:34 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 AF6D216A4CE for ; Wed, 14 Apr 2004 04:39:34 -0700 (PDT) Received: from publicd.ub.mng.net (publicd.ub.mng.net [202.179.0.88]) by mx1.FreeBSD.org (Postfix) with ESMTP id C2DD043D45 for ; Wed, 14 Apr 2004 04:39:33 -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 1BDjby-000PNR-Rt; Wed, 14 Apr 2004 20:35:26 +0800 Message-Id: <6.0.3.0.2.20040414204141.02a97588@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: Wed, 14 Apr 2004 20:44:30 +0900 To: Alexander Leidinger From: Ganbold In-Reply-To: <20040414133106.7dfc60b7@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> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed 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 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 14 Apr 2004 11:39:34 -0000 Hi, Can you give me some hints and tricks to compile mysql with libpthread? What compiler options should I use? thanks, Ganbold At 08:31 PM 14.04.2004, you wrote: >On Wed, 14 Apr 2004 19:59:33 +0900 >Ganbold wrote: > > > So what threading library should I use with mysql? > > Can somebody recommend me which to use? Because I'm bit confused. > > I used to use linuxthreads and it was pretty good. Now there appears some > > other threading libraries:) > > Which one is reliable and has good performance? > >At least with a recent -current: libpthread (the default) is not >obviously bad. > >With 5.2.1 I suggest to use linuxthreads (libc_r is the default with >5.2.1). > >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 From owner-freebsd-threads@FreeBSD.ORG Wed Apr 14 04:53:33 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 C563C16A4CE for ; Wed, 14 Apr 2004 04:53:33 -0700 (PDT) Received: from cyber-media.co.uk (cms2.gotadsl.co.uk [81.6.247.204]) by mx1.FreeBSD.org (Postfix) with ESMTP id 2593F43D5D for ; Wed, 14 Apr 2004 04:53:33 -0700 (PDT) (envelope-from ganbold@micom.mng.net) Received: from mail pickup service by cyber-media.co.uk with Microsoft SMTPSVC; Wed, 14 Apr 2004 13:00:38 +0100 thread-index: AcQiGBoskLzo1Bo8RDquu8DUdoKCUg== Mailing-List: contact mysql-help@lists.mysql.com; run by ezmlm Precedence: bulk Delivered-To: mailing list mysql@lists.mysql.com Message-ID: <000001c42218$1a2c0af0$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: Wed, 14 Apr 2004 13:00:38 +0100 To: From: "Ganbold" In-Reply-To: <20040414133106.7dfc60b7@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> 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: 14 Apr 2004 12:00:38.0890 (UTC) FILETIME=[1A4B04A0:01C42218] 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: Wed, 14 Apr 2004 11:53:33 -0000 Hi, Can you give me some hints and tricks to compile mysql with libpthread? What compiler options should I use? thanks, Ganbold At 08:31 PM 14.04.2004, you wrote: >On Wed, 14 Apr 2004 19:59:33 +0900 >Ganbold wrote: > > > So what threading library should I use with mysql? > > Can somebody recommend me which to use? Because I'm bit confused. > > I used to use linuxthreads and it was pretty good. Now there appears some > > other threading libraries:) > > Which one is reliable and has good performance? > >At least with a recent -current: libpthread (the default) is not >obviously bad. > >With 5.2.1 I suggest to use linuxthreads (libc_r is the default with >5.2.1). > >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 From owner-freebsd-threads@FreeBSD.ORG Wed Apr 14 05:30:51 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 78B4516A4CE for ; Wed, 14 Apr 2004 05:30:51 -0700 (PDT) Received: from mailout05.sul.t-online.com (mailout05.sul.t-online.com [194.25.134.82]) by mx1.FreeBSD.org (Postfix) with ESMTP id C7EDF43D1D for ; Wed, 14 Apr 2004 05:30:50 -0700 (PDT) (envelope-from Alexander@Leidinger.net) Received: from fwd02.aul.t-online.de by mailout05.sul.t-online.com with smtp id 1BDjXN-0000yw-03; Wed, 14 Apr 2004 14:30:41 +0200 Received: from Andro-Beta.Leidinger.net (X7fekyZVweFARgS8bV3VGtO0QivJ7DxYXN-AyVadpwprVFBIeob6r6@[217.83.19.131]) by fmrl02.sul.t-online.com with esmtp id 1BDjX4-1pfFOi0; Wed, 14 Apr 2004 14:30:22 +0200 Received: from Magellan.Leidinger.net (Magellan.Leidinger.net [192.168.1.1]) i3ECUEDn066392; Wed, 14 Apr 2004 14:30:15 +0200 (CEST) (envelope-from Alexander@Leidinger.net) Date: Wed, 14 Apr 2004 14:30:39 +0200 From: Alexander Leidinger To: Ganbold Message-Id: <20040414143039.511cbf6b@Magellan.Leidinger.net> In-Reply-To: <6.0.3.0.2.20040414204141.02a97588@202.179.0.80> 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> X-Mailer: Sylpheed version 0.9.10claws (GTK+ 1.2.10; i386-portbld-freebsd5.2) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Seen: false X-ID: X7fekyZVweFARgS8bV3VGtO0QivJ7DxYXN-AyVadpwprVFBIeob6r6@t-dialin.net 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 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 14 Apr 2004 12:30:51 -0000 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 From owner-freebsd-threads@FreeBSD.ORG Wed Apr 14 10:19:36 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 AD19E16A4CE for ; Wed, 14 Apr 2004 10:19:36 -0700 (PDT) Received: from rwcrmhc13.comcast.net (rwcrmhc13.comcast.net [204.127.198.39]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8205543D31 for ; Wed, 14 Apr 2004 10:19:36 -0700 (PDT) (envelope-from julian@elischer.org) Received: from interjet.elischer.org ([24.7.73.28]) by comcast.net (rwcrmhc13) with ESMTP id <2004041417193301500rlnree>; Wed, 14 Apr 2004 17:19:36 +0000 Received: from localhost (localhost.elischer.org [127.0.0.1]) by InterJet.elischer.org (8.9.1a/8.9.1) with ESMTP id KAA35321; Wed, 14 Apr 2004 10:19:33 -0700 (PDT) Date: Wed, 14 Apr 2004 10:19:32 -0700 (PDT) From: Julian Elischer To: Alexander Leidinger In-Reply-To: <20040414133106.7dfc60b7@Magellan.Leidinger.net> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII cc: kenm@icarz.com cc: mysql@lists.mysql.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 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 14 Apr 2004 17:19:36 -0000 On Wed, 14 Apr 2004, Alexander Leidinger wrote: > On Wed, 14 Apr 2004 19:59:33 +0900 > Ganbold wrote: > > > So what threading library should I use with mysql? > > Can somebody recommend me which to use? Because I'm bit confused. > > I used to use linuxthreads and it was pretty good. Now there appears some > > other threading libraries:) > > Which one is reliable and has good performance? > > At least with a recent -current: libpthread (the default) is not > obviously bad. > > With 5.2.1 I suggest to use linuxthreads (libc_r is the default with > 5.2.1). in 5.2.1 the native (real) threads were called libkse. you could try them.. > > 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 > From owner-freebsd-threads@FreeBSD.ORG Wed Apr 14 10:35:00 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 9019416A4CE for ; Wed, 14 Apr 2004 10:35:00 -0700 (PDT) Received: from hutcs.cs.hut.fi (hutcs.cs.hut.fi [130.233.192.7]) by mx1.FreeBSD.org (Postfix) with ESMTP id 194C143D31 for ; Wed, 14 Apr 2004 10:35:00 -0700 (PDT) (envelope-from kirma@cs.hut.fi) Received: from kirma (helo=localhost) by hutcs.cs.hut.fi with local-esmtp (Exim 4.30) id 1BDoHq-0003ve-JZ for freebsd-threads@freebsd.org; Wed, 14 Apr 2004 20:34:58 +0300 Date: Wed, 14 Apr 2004 20:34:58 +0300 (EEST) From: Jari Kirma To: freebsd-threads@freebsd.org Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Subject: Co-operative process yield/handoff syscall? 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: Wed, 14 Apr 2004 17:35:00 -0000 I have been considering implementing concurrent queues between processes or between kernel driver and process(es) while attempting to removing unnecessary system calls and context switches in general. There are several good algorithms for this, FreeBSD has machine/atomic.h which provides nice atomic operations for both kernel and userland (which supposedly don't work nicely with MP Itanium without some help from kernel side, though). After reading some papers on the subject, I read one [1] which states that sched_yield that doesn't necessarily yield CPU to other runnable process if one exists can cause considerable performance hit on these algorithms. Quick look at FreeBSD kernel suggested me that sched_yield really yields CPU only if there's higher-priority process runnable. Is there any good way to emulate the co-operative "handoff" system call suggested on the paper? Primary feature of such a system call would be to avoid returning to the same process after sched_yield if any other runnable processes exist. I suppose inside a multithreaded process, pthread_yield performs what's expected in this case. [1] E. Unrau and O. Krieger, "Efficient Sleep/Wake-up Protocols for User-Level IPC", -kirma From owner-freebsd-threads@FreeBSD.ORG Wed Apr 14 12:33:05 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 BDEF616A4CE for ; Wed, 14 Apr 2004 12:33:05 -0700 (PDT) Received: from mailout10.sul.t-online.com (mailout10.sul.t-online.com [194.25.134.21]) by mx1.FreeBSD.org (Postfix) with ESMTP id 865D743D78 for ; Wed, 14 Apr 2004 12:33:05 -0700 (PDT) (envelope-from Alexander@Leidinger.net) Received: from fwd11.aul.t-online.de by mailout10.sul.t-online.com with smtp id 1BDq7j-0006Dj-02; Wed, 14 Apr 2004 21:32:39 +0200 Received: from Andro-Beta.Leidinger.net (bj-ARGZUrebDpg8dscz-exAsCV1S0VUyF3qRwyxIOTXsLHgaCrY5rd@[217.229.215.93]) by fmrl11.sul.t-online.com with esmtp id 1BDq7R-15aBFY0; Wed, 14 Apr 2004 21:32:21 +0200 Received: from Magellan.Leidinger.net (Magellan.Leidinger.net [192.168.1.1]) i3EJW1Ua026367; Wed, 14 Apr 2004 21:32:01 +0200 (CEST) (envelope-from Alexander@Leidinger.net) Date: Wed, 14 Apr 2004 21:32:26 +0200 From: Alexander Leidinger To: Julian Elischer Message-Id: <20040414213226.3ff29f4e@Magellan.Leidinger.net> In-Reply-To: References: <20040414133106.7dfc60b7@Magellan.Leidinger.net> X-Mailer: Sylpheed version 0.9.10claws (GTK+ 1.2.10; i386-portbld-freebsd5.2) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Seen: false X-ID: bj-ARGZUrebDpg8dscz-exAsCV1S0VUyF3qRwyxIOTXsLHgaCrY5rd@t-dialin.net cc: kenm@icarz.com cc: mysql@lists.mysql.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 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 14 Apr 2004 19:33:05 -0000 On Wed, 14 Apr 2004 10:19:32 -0700 (PDT) Julian Elischer wrote: > in 5.2.1 the native (real) threads were called libkse. > you could try them.. But AFAIK there where several changes after the renaming to libpthread. And I think some of those are fixes for one or another problem... 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 From owner-freebsd-threads@FreeBSD.ORG Wed Apr 14 18:27:44 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 E718A16A4CE for ; Wed, 14 Apr 2004 18:27:43 -0700 (PDT) Received: from publicd.ub.mng.net (publicd.ub.mng.net [202.179.0.88]) by mx1.FreeBSD.org (Postfix) with ESMTP id 0AF8343D1D for ; Wed, 14 Apr 2004 18:27:42 -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 1BDwXM-000BSG-OQ; Thu, 15 Apr 2004 10:23:32 +0800 Message-Id: <6.0.3.0.2.20040415102606.02b00f90@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 10:32:36 +0900 To: Alexander Leidinger 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; charset="us-ascii"; format=flowed 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 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 01:27:44 -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 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 From owner-freebsd-threads@FreeBSD.ORG Wed Apr 14 18:48:57 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 8373316A4CE for ; Wed, 14 Apr 2004 18:48:57 -0700 (PDT) Received: from rwcrmhc13.comcast.net (rwcrmhc13.comcast.net [204.127.198.39]) by mx1.FreeBSD.org (Postfix) with ESMTP id A468F43D49 for ; Wed, 14 Apr 2004 18:48:56 -0700 (PDT) (envelope-from julian@elischer.org) Received: from interjet.elischer.org ([24.7.73.28]) by comcast.net (rwcrmhc13) with ESMTP id <2004041501485501500rhafce>; Thu, 15 Apr 2004 01:48:56 +0000 Received: from localhost (localhost.elischer.org [127.0.0.1]) by InterJet.elischer.org (8.9.1a/8.9.1) with ESMTP id SAA40033; Wed, 14 Apr 2004 18:48:53 -0700 (PDT) Date: Wed, 14 Apr 2004 18:48:51 -0700 (PDT) From: Julian Elischer To: Ganbold In-Reply-To: <6.0.3.0.2.20040415102606.02b00f90@202.179.0.80> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII cc: Alexander Leidinger cc: threads@freebsd.org cc: kenm@icarz.com cc: mysql@lists.mysql.com 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 01:48:57 -0000 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 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" > From owner-freebsd-threads@FreeBSD.ORG Wed Apr 14 22:57:17 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 ADC1316A4CE for ; Wed, 14 Apr 2004 22:57:17 -0700 (PDT) Received: from publicd.ub.mng.net (publicd.ub.mng.net [202.179.0.88]) by mx1.FreeBSD.org (Postfix) with ESMTP id BDE5143D45 for ; Wed, 14 Apr 2004 22:57:16 -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 1BE0kC-000JMz-3Y; Thu, 15 Apr 2004 14:53:04 +0800 Message-Id: <6.0.3.0.2.20040415145916.02ae6708@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 15:01:58 +0900 To: Alexander Leidinger From: Ganbold Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed 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 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 05:57:17 -0000 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 From owner-freebsd-threads@FreeBSD.ORG Wed Apr 14 23:08:15 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 0DE1516A4CE for ; Wed, 14 Apr 2004 23:08:15 -0700 (PDT) Received: from cyber-media.co.uk (cms2.gotadsl.co.uk [81.6.247.204]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5459143D5A for ; Wed, 14 Apr 2004 23:08:14 -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 07:15:19 +0100 thread-index: AcQisQcbG4w8sShZSLeigx0DIc2zoA== Mailing-List: contact mysql-help@lists.mysql.com; run by ezmlm Precedence: bulk Message-ID: <000001c422b1$071bba70$0100000a@cybermedia.local> Delivered-To: mailing list mysql@lists.mysql.com 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 07:15:19 +0100 To: From: "Ganbold" MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="us-ascii" Content-Class: urn:content-classes:message X-Virus-Checked: Checked Importance: normal Status: Priority: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.132 X-OriginalArrivalTime: 15 Apr 2004 06:15:19.0906 (UTC) FILETIME=[073AB420:01C422B1] 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 06:08:15 -0000 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 -- 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 From owner-freebsd-threads@FreeBSD.ORG Wed Apr 14 23:12:45 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 8BBA216A4CE for ; Wed, 14 Apr 2004 23:12:45 -0700 (PDT) Received: from sccrmhc13.comcast.net (sccrmhc13.comcast.net [204.127.202.64]) by mx1.FreeBSD.org (Postfix) with ESMTP id E9B0743D5A for ; Wed, 14 Apr 2004 23:12:44 -0700 (PDT) (envelope-from julian@elischer.org) Received: from interjet.elischer.org ([24.7.73.28]) by comcast.net (sccrmhc13) with ESMTP id <20040415061242016003h30pe>; Thu, 15 Apr 2004 06:12:44 +0000 Received: from localhost (localhost.elischer.org [127.0.0.1]) by InterJet.elischer.org (8.9.1a/8.9.1) with ESMTP id XAA42160; Wed, 14 Apr 2004 23:12:41 -0700 (PDT) Date: Wed, 14 Apr 2004 23:12:39 -0700 (PDT) From: Julian Elischer To: Ganbold In-Reply-To: <6.0.3.0.2.20040415145916.02ae6708@202.179.0.80> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII cc: Alexander Leidinger cc: threads@freebsd.org cc: kenm@icarz.com cc: mysql@lists.mysql.com 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 06:12:45 -0000 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 > > From owner-freebsd-threads@FreeBSD.ORG Wed Apr 14 23:29:43 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 4BDEF16A4CE for ; Wed, 14 Apr 2004 23:29:43 -0700 (PDT) Received: from publicd.ub.mng.net (publicd.ub.mng.net [202.179.0.88]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3D01143D2F for ; Wed, 14 Apr 2004 23:29:37 -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 1BE1Fc-000Ja6-42; Thu, 15 Apr 2004 15:25:32 +0800 Message-Id: <6.0.3.0.2.20040415152523.02ad4b10@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 15:34:23 +0900 To: Julian Elischer From: Ganbold In-Reply-To: References: <6.0.3.0.2.20040415145916.02ae6708@202.179.0.80> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed cc: threads@freebsd.org cc: Alexander@Leidinger.net cc: kenm@icarz.com 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 06:29:43 -0000 Hi, I did cvsup today and updated FreeBSD 5.2-CURRENT. I used top command to see how much memory it is using. It was OK. Machine itself has 3GB memory. Is there any trick compiling mysql with libpthread? Without any trick it just hangs. ps axH shows first time after mysql start: 8826 p1 SL 0:00.02 /bin/sh /usr/local/bin/mysqld_safe --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/ba 8863 p1 SL 0:02.81 (mysqld) 8863 p1 SL 0:02.81 (mysqld) 8863 p1 SL 0:02.81 (mysqld) 8863 p1 SL 0:02.81 (mysqld) 8863 p1 SL 0:02.81 (mysqld) 8863 p1 SL 0:02.81 (mysqld) 8863 p1 SL 0:02.81 (mysqld) 8863 p1 SL 0:02.81 (mysqld) 8863 p1 SL 0:02.81 (mysqld) 8863 p1 SL 0:02.81 (mysqld) ps axHlwww|grep mysql shows: backend2# ps axHlwww|grep mysql 0 8826 1 0 8 0 1580 1236 wait SL p1 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 8863 8826 0 20 0 449804 449156 kserel SL p1 0:02.82 (mysqld) 88 8863 8826 0 76 0 449804 449156 select SL p1 0:02.82 (mysqld) 88 8863 8826 0 20 0 449804 449156 kserel SL p1 0:02.82 (mysqld) 88 8863 8826 0 20 0 449804 449156 kserel SL p1 0:02.82 (mysqld) 88 8863 8826 0 20 0 449804 449156 kserel SL p1 0:02.82 (mysqld) 88 8863 8826 0 20 0 449804 449156 kserel SL p1 0:02.82 (mysqld) 88 8863 8826 0 20 0 449804 449156 sigwai SL p1 0:02.82 (mysqld) 88 8863 8826 0 20 0 449804 449156 ksesig SL p1 0:02.82 (mysqld) 88 8863 8826 0 20 0 449804 449156 kserel SL p1 0:02.82 (mysqld) 88 8863 8826 0 20 0 449804 449156 kserel SL p1 0:02.82 (mysqld) 0 8879 796 0 76 0 1332 828 Giant LL+ p1 0:00.00 grep mysql After sometime: backend2# ps axHlwww | grep mysql 0 8890 778 0 5 0 3392 2904 ttyin SL+ p0 0:00.03 mysql -p 0 8826 1 0 8 0 1580 1236 wait SL p1 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 8863 8826 0 4 0 450316 449264 sbwait SL p1 0:03.51 (mysqld) 88 8863 8826 0 20 0 450316 449264 ksesig SL p1 0:03.51 (mysqld) 88 8863 8826 0 20 0 450316 449264 sigwai SL p1 0:03.51 (mysqld) 88 8863 8826 0 20 0 450316 449264 kserel SL p1 0:03.51 (mysqld) 88 8863 8826 0 20 0 450316 449264 kserel SL p1 0:03.51 (mysqld) 88 8863 8826 0 4 0 450316 449264 sbwait SL p1 0:03.51 (mysqld) 88 8863 8826 0 4 0 450316 449264 sbwait SL p1 0:03.51 (mysqld) 88 8863 8826 0 4 0 450316 449264 sbwait SL p1 0:03.51 (mysqld) 88 8863 8826 0 20 0 450316 449264 kserel SL p1 0:03.51 (mysqld) 88 8863 8826 0 20 0 450316 449264 kserel SL p1 0:03.51 (mysqld) 88 8863 8826 0 20 0 450316 449264 kserel SL p1 0:03.51 (mysqld) 88 8863 8826 0 20 0 450316 449264 kserel SL p1 0:03.51 (mysqld) 88 8863 8826 0 20 0 450316 449264 kserel SL p1 0:03.51 (mysqld) 88 8863 8826 0 76 0 450316 449264 select SL p1 0:03.51 (mysqld) 0 9395 796 0 76 0 1328 824 Giant LL+ p1 0:00.00 grep mysql mysql show processlist shows at hang time: mysql> show processlist; +----+-------+---------------------------+-----------+-------------+------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------+---------------------------+-----------+-------------+------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ | 14 | root | localhost | NULL | Query | 0 | NULL | show processlist | | 17 | admin | xxx:3773 | radius | Sleep | 40 | | NULL | | 18 | admin | xxx:3774 | radius | Query | 22 | update | insert into VOIP_TERMINATION (acctdelaytime,acctinputoctets,acctoutputoctets,acctsessionid,acctsessi | | 25 | admin | radiator1.ub.mng.net:4435 | radius | Query | 22 | update | insert into ACCOUNTING (ACCTDELAYTIME,ACCTINPUTOCTETS,ACCTOUTPUTOCTETS,ACCTSESSIONID,ACCTSESSIONTIME | | 52 | admin | localhost | customers | Query | 14 | statistics | select count(*) from users where userid='ganbold' | +----+-------+---------------------------+-----------+-------------+------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ 6 rows in set (0.00 sec) thanks in advance, Ganbold At 03:12 PM 15.04.2004, you 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 > > > > From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 00:10:32 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 3020316A4CE for ; Thu, 15 Apr 2004 00:10:32 -0700 (PDT) Received: from relay.sparc.spb.su (relay.sparc.spb.su [193.125.194.2]) by mx1.FreeBSD.org (Postfix) with ESMTP id D44B443D31 for ; Thu, 15 Apr 2004 00:10:31 -0700 (PDT) (envelope-from moreau@myrealbox.com) Received: from mail.sparc.spb.su (unknown [192.168.205.210]) by relay.sparc.spb.su (Postfix) with ESMTP id 158AFAD7A; Thu, 15 Apr 2004 11:10:30 +0400 (MSD) Received: from myrealbox.com (den.sparc.spb.su [192.168.205.185]) by mail.sparc.spb.su (8.12.11/8.12.11) with ESMTP id i3F7AT0m008822; Thu, 15 Apr 2004 11:10:29 +0400 (MSD) (envelope-from moreau@myrealbox.com) Message-ID: <407E3725.9020307@myrealbox.com> Date: Thu, 15 Apr 2004 11:17:57 +0400 From: den User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Julian Elischer References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: clamd / ClamAV version devel-20040408, clamav-milter version 0.70g 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:10:32 -0000 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" > > > > From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 00:23:11 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 4DEB616A4CE for ; Thu, 15 Apr 2004 00:23:11 -0700 (PDT) Received: from rwcrmhc11.comcast.net (rwcrmhc11.comcast.net [204.127.198.35]) by mx1.FreeBSD.org (Postfix) with ESMTP id 09AAA43D2D for ; Thu, 15 Apr 2004 00:23:11 -0700 (PDT) (envelope-from julian@elischer.org) Received: from interjet.elischer.org ([24.7.73.28]) by comcast.net (rwcrmhc11) with ESMTP id <2004041507231001300fck1de>; Thu, 15 Apr 2004 07:23:10 +0000 Received: from localhost (localhost.elischer.org [127.0.0.1]) by InterJet.elischer.org (8.9.1a/8.9.1) with ESMTP id AAA42766; Thu, 15 Apr 2004 00:23:09 -0700 (PDT) Date: Thu, 15 Apr 2004 00:23:08 -0700 (PDT) From: Julian Elischer To: den In-Reply-To: <407E3725.9020307@myrealbox.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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:11 -0000 On Thu, 15 Apr 2004, den 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 ? you are using libc_r because libpthreads has only been introduced since AFTER 5.2 > > 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" > > > > > > > > > > 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" > From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 00:33:05 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 4482516A4CE for ; Thu, 15 Apr 2004 00:33:05 -0700 (PDT) Received: from rwcrmhc13.comcast.net (rwcrmhc13.comcast.net [204.127.198.39]) by mx1.FreeBSD.org (Postfix) with ESMTP id 2047F43D55 for ; Thu, 15 Apr 2004 00:33:05 -0700 (PDT) (envelope-from julian@elischer.org) Received: from interjet.elischer.org ([24.7.73.28]) by comcast.net (rwcrmhc13) with ESMTP id <2004041507330301500rahr9e>; Thu, 15 Apr 2004 07:33:04 +0000 Received: from localhost (localhost.elischer.org [127.0.0.1]) by InterJet.elischer.org (8.9.1a/8.9.1) with ESMTP id AAA42922; Thu, 15 Apr 2004 00:33:03 -0700 (PDT) Date: Thu, 15 Apr 2004 00:33:02 -0700 (PDT) From: Julian Elischer To: Ganbold In-Reply-To: <6.0.3.0.2.20040415152523.02ad4b10@202.179.0.80> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII cc: threads@freebsd.org cc: kenm@icarz.com cc: Alexander@Leidinger.net 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:33:05 -0000 On Thu, 15 Apr 2004, Ganbold wrote: > Hi, > > I did cvsup today and updated FreeBSD 5.2-CURRENT. > I used top command to see how much memory it is using. It was OK. Machine > itself has 3GB memory. > Is there any trick compiling mysql with libpthread? Without any trick it > just hangs. by default your data space is limited to 512MBytes how much dataspace does your process use? (top shows this) I know nothing about Mysql so I suggest you talk to petri.. look in the threads mailing list archive.. look for MySQL. > > ps axH shows first time after mysql start: > > 8826 p1 SL 0:00.02 /bin/sh /usr/local/bin/mysqld_safe --user=mysql > --datadir=/var/db/mysql --pid-file=/var/db/mysql/ba > 8863 p1 SL 0:02.81 (mysqld) > 8863 p1 SL 0:02.81 (mysqld) > 8863 p1 SL 0:02.81 (mysqld) > 8863 p1 SL 0:02.81 (mysqld) > 8863 p1 SL 0:02.81 (mysqld) > 8863 p1 SL 0:02.81 (mysqld) > 8863 p1 SL 0:02.81 (mysqld) > 8863 p1 SL 0:02.81 (mysqld) > 8863 p1 SL 0:02.81 (mysqld) > 8863 p1 SL 0:02.81 (mysqld) > > ps axHlwww|grep mysql shows: > > backend2# ps axHlwww|grep mysql > 0 8826 1 0 8 0 1580 1236 wait SL p1 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 8863 8826 0 20 0 449804 449156 kserel > SL p1 0:02.82 (mysqld) > 88 8863 8826 0 76 0 449804 449156 select > SL p1 0:02.82 (mysqld) > 88 8863 8826 0 20 0 449804 449156 kserel > SL p1 0:02.82 (mysqld) > 88 8863 8826 0 20 0 449804 449156 kserel > SL p1 0:02.82 (mysqld) > 88 8863 8826 0 20 0 449804 449156 kserel > SL p1 0:02.82 (mysqld) > 88 8863 8826 0 20 0 449804 449156 kserel > SL p1 0:02.82 (mysqld) > 88 8863 8826 0 20 0 449804 449156 sigwai > SL p1 0:02.82 (mysqld) > 88 8863 8826 0 20 0 449804 449156 ksesig > SL p1 0:02.82 (mysqld) > 88 8863 8826 0 20 0 449804 449156 kserel > SL p1 0:02.82 (mysqld) > 88 8863 8826 0 20 0 449804 449156 kserel > SL p1 0:02.82 (mysqld) > 0 8879 796 0 76 0 1332 828 Giant LL+ p1 0:00.00 grep mysql > > After sometime: > > backend2# ps axHlwww | grep mysql > 0 8890 778 0 5 0 3392 2904 ttyin SL+ p0 0:00.03 mysql -p > 0 8826 1 0 8 0 1580 1236 wait SL p1 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 8863 8826 0 4 0 450316 449264 sbwait > SL p1 0:03.51 (mysqld) > 88 8863 8826 0 20 0 450316 449264 ksesig > SL p1 0:03.51 (mysqld) > 88 8863 8826 0 20 0 450316 449264 sigwai > SL p1 0:03.51 (mysqld) > 88 8863 8826 0 20 0 450316 449264 kserel > SL p1 0:03.51 (mysqld) > 88 8863 8826 0 20 0 450316 449264 kserel > SL p1 0:03.51 (mysqld) > 88 8863 8826 0 4 0 450316 449264 sbwait > SL p1 0:03.51 (mysqld) > 88 8863 8826 0 4 0 450316 449264 sbwait > SL p1 0:03.51 (mysqld) > 88 8863 8826 0 4 0 450316 449264 sbwait > SL p1 0:03.51 (mysqld) > 88 8863 8826 0 20 0 450316 449264 kserel > SL p1 0:03.51 (mysqld) > 88 8863 8826 0 20 0 450316 449264 kserel > SL p1 0:03.51 (mysqld) > 88 8863 8826 0 20 0 450316 449264 kserel > SL p1 0:03.51 (mysqld) > 88 8863 8826 0 20 0 450316 449264 kserel > SL p1 0:03.51 (mysqld) > 88 8863 8826 0 20 0 450316 449264 kserel > SL p1 0:03.51 (mysqld) > 88 8863 8826 0 76 0 450316 449264 select > SL p1 0:03.51 (mysqld) > 0 9395 796 0 76 0 1328 824 Giant LL+ p1 0:00.00 grep mysql > > mysql show processlist shows at hang time: > > mysql> show processlist; > +----+-------+---------------------------+-----------+-------------+------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ > | Id | User | Host | db | Command | Time | > State | > Info > | > +----+-------+---------------------------+-----------+-------------+------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ > | 14 | root | localhost | NULL | Query | 0 | > NULL | show > processlist > | > | 17 | admin | xxx:3773 | radius | Sleep | > 40 | | > NULL > | > | 18 | admin | xxx:3774 | radius | Query | 22 | > update | insert > into VOIP_TERMINATION > (acctdelaytime,acctinputoctets,acctoutputoctets,acctsessionid,acctsessi | > | 25 | admin | radiator1.ub.mng.net:4435 | radius | Query | 22 | > update | insert > into ACCOUNTING > (ACCTDELAYTIME,ACCTINPUTOCTETS,ACCTOUTPUTOCTETS,ACCTSESSIONID,ACCTSESSIONTIME | > | 52 | admin | localhost | customers | Query | 14 | > statistics | select > count(*) from users where > userid='ganbold' | > +----+-------+---------------------------+-----------+-------------+------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ > 6 rows in set (0.00 sec) > > thanks in advance, > > Ganbold > > > At 03:12 PM 15.04.2004, you 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" > From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 00:36:55 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 D66A616A4CE for ; Thu, 15 Apr 2004 00:36:54 -0700 (PDT) Received: from relay.sparc.spb.su (relay.sparc.spb.su [193.125.194.2]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6D8BE43D55 for ; Thu, 15 Apr 2004 00:36:54 -0700 (PDT) (envelope-from moreau@myrealbox.com) Received: from mail.sparc.spb.su (unknown [192.168.205.210]) by relay.sparc.spb.su (Postfix) with ESMTP id 6E713AD79; Thu, 15 Apr 2004 11:36:53 +0400 (MSD) Received: from myrealbox.com (den.sparc.spb.su [192.168.205.185]) by mail.sparc.spb.su (8.12.11/8.12.11) with ESMTP id i3F7arPb016317; Thu, 15 Apr 2004 11:36:53 +0400 (MSD) (envelope-from moreau@myrealbox.com) Message-ID: <407E3D55.1020502@myrealbox.com> Date: Thu, 15 Apr 2004 11:44:21 +0400 From: den User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Julian Elischer References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: clamd / ClamAV version devel-20040408, clamav-milter version 0.70g 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:36:55 -0000 Julian Elischer wrote: >On Thu, 15 Apr 2004, den 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 ? >> >> > >you are using libc_r because libpthreads has only been introduced since >AFTER 5.2 > > > > >>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" >>> >>> >>> >>> >>> >>> >> >> > > > > > Julian , Ganbold thanks for answers, please tell me - how stable libpthreads at current moment ? Is using of libpthreads preferable then libc_r ( and what qualitative chracteristics ) ? Is libpthreads better then linuxthreads ? Thanks for your answers. From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 00:49:41 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 90DCA16A4CE for ; Thu, 15 Apr 2004 00:49:41 -0700 (PDT) Received: from publicd.ub.mng.net (publicd.ub.mng.net [202.179.0.88]) by mx1.FreeBSD.org (Postfix) with ESMTP id CB1F643D49 for ; Thu, 15 Apr 2004 00:49:37 -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 1BE2Ux-000K7l-Mx; Thu, 15 Apr 2004 16:45:27 +0800 Message-Id: <6.0.3.0.2.20040415165032.02b06a10@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:54:31 +0900 To: Julian Elischer From: Ganbold In-Reply-To: References: <6.0.3.0.2.20040415152523.02ad4b10@202.179.0.80> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed cc: threads@freebsd.org cc: kenm@icarz.com cc: alexander@Leidinger.net 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:49:41 -0000 I compiled kernel with option MAXDSIZ=(1024*1024*1024). I thought in this case mysql can use data space up to 1GB. Am I right? Ganbold At 04:33 PM 15.04.2004, you wrote: >On Thu, 15 Apr 2004, Ganbold wrote: > > > Hi, > > > > I did cvsup today and updated FreeBSD 5.2-CURRENT. > > I used top command to see how much memory it is using. It was OK. Machine > > itself has 3GB memory. > > Is there any trick compiling mysql with libpthread? Without any trick it > > just hangs. > > >by default your data space is limited to 512MBytes >how much dataspace does your process use? >(top shows this) > > >I know nothing about Mysql >so I suggest you talk to petri.. >look in the threads mailing list archive.. look for MySQL. > > > > > ps axH shows first time after mysql start: > > > > 8826 p1 SL 0:00.02 /bin/sh /usr/local/bin/mysqld_safe --user=mysql > > --datadir=/var/db/mysql --pid-file=/var/db/mysql/ba > > 8863 p1 SL 0:02.81 (mysqld) > > 8863 p1 SL 0:02.81 (mysqld) > > 8863 p1 SL 0:02.81 (mysqld) > > 8863 p1 SL 0:02.81 (mysqld) > > 8863 p1 SL 0:02.81 (mysqld) > > 8863 p1 SL 0:02.81 (mysqld) > > 8863 p1 SL 0:02.81 (mysqld) > > 8863 p1 SL 0:02.81 (mysqld) > > 8863 p1 SL 0:02.81 (mysqld) > > 8863 p1 SL 0:02.81 (mysqld) > > > > ps axHlwww|grep mysql shows: > > > > backend2# ps axHlwww|grep mysql > > 0 8826 1 0 8 0 1580 1236 wait SL p1 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 8863 8826 0 20 0 449804 449156 kserel > > SL p1 0:02.82 (mysqld) > > 88 8863 8826 0 76 0 449804 449156 select > > SL p1 0:02.82 (mysqld) > > 88 8863 8826 0 20 0 449804 449156 kserel > > SL p1 0:02.82 (mysqld) > > 88 8863 8826 0 20 0 449804 449156 kserel > > SL p1 0:02.82 (mysqld) > > 88 8863 8826 0 20 0 449804 449156 kserel > > SL p1 0:02.82 (mysqld) > > 88 8863 8826 0 20 0 449804 449156 kserel > > SL p1 0:02.82 (mysqld) > > 88 8863 8826 0 20 0 449804 449156 sigwai > > SL p1 0:02.82 (mysqld) > > 88 8863 8826 0 20 0 449804 449156 ksesig > > SL p1 0:02.82 (mysqld) > > 88 8863 8826 0 20 0 449804 449156 kserel > > SL p1 0:02.82 (mysqld) > > 88 8863 8826 0 20 0 449804 449156 kserel > > SL p1 0:02.82 (mysqld) > > 0 8879 796 0 76 0 1332 828 Giant LL+ p1 0:00.00 > grep mysql > > > > After sometime: > > > > backend2# ps axHlwww | grep mysql > > 0 8890 778 0 5 0 3392 2904 ttyin SL+ p0 0:00.03 > mysql -p > > 0 8826 1 0 8 0 1580 1236 wait SL p1 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 8863 8826 0 4 0 450316 449264 sbwait > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 20 0 450316 449264 ksesig > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 20 0 450316 449264 sigwai > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 20 0 450316 449264 kserel > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 20 0 450316 449264 kserel > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 4 0 450316 449264 sbwait > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 4 0 450316 449264 sbwait > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 4 0 450316 449264 sbwait > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 20 0 450316 449264 kserel > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 20 0 450316 449264 kserel > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 20 0 450316 449264 kserel > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 20 0 450316 449264 kserel > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 20 0 450316 449264 kserel > > SL p1 0:03.51 (mysqld) > > 88 8863 8826 0 76 0 450316 449264 select > > SL p1 0:03.51 (mysqld) > > 0 9395 796 0 76 0 1328 824 Giant LL+ p1 0:00.00 > grep mysql > > > > mysql show processlist shows at hang time: > > > > mysql> show processlist; > > > +----+-------+---------------------------+-----------+-------------+------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ > > | Id | User | Host | db | Command | > Time | > > State | > > Info > > | > > > +----+-------+---------------------------+-----------+-------------+------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ > > | 14 | root | localhost | NULL | Query | > 0 | > > NULL | show > > processlist > > | > > | 17 | admin | xxx:3773 | radius | Sleep | > > 40 | | > > NULL > > | > > | 18 | admin | xxx:3774 | radius | Query | 22 | > > update | insert > > into VOIP_TERMINATION > > (acctdelaytime,acctinputoctets,acctoutputoctets,acctsessionid,acctsessi | > > | 25 | admin | radiator1.ub.mng.net:4435 | radius | Query | > 22 | > > update | insert > > into ACCOUNTING > > > (ACCTDELAYTIME,ACCTINPUTOCTETS,ACCTOUTPUTOCTETS,ACCTSESSIONID,ACCTSESSIONTIME | > > | 52 | admin | localhost | customers | Query | > 14 | > > statistics | select > > count(*) from users where > > userid='ganbold' | > > > +----+-------+---------------------------+-----------+-------------+------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ > > 6 rows in set (0.00 sec) > > > > thanks in advance, > > > > Ganbold > > > > > > At 03:12 PM 15.04.2004, you 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" > > From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 00:51:39 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 1B96816A4CE for ; Thu, 15 Apr 2004 00:51:39 -0700 (PDT) Received: from rms04.rommon.net (rms04.rommon.net [212.54.2.140]) by mx1.FreeBSD.org (Postfix) with ESMTP id C6C0D43D5C for ; Thu, 15 Apr 2004 00:51:37 -0700 (PDT) (envelope-from pete@he.iki.fi) Received: from he.iki.fi (h91.vuokselantie10.fi [193.64.42.145]) by rms04.rommon.net (8.12.10/8.12.9) with ESMTP id i3F7oumo045963; Thu, 15 Apr 2004 10:50:57 +0300 (EEST) (envelope-from pete@he.iki.fi) Message-ID: <407E3EDB.8020508@he.iki.fi> Date: Thu, 15 Apr 2004 10:50:51 +0300 From: Petri Helenius User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Julian Elischer References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit cc: threads@freebsd.org cc: Alexander@Leidinger.net cc: kenm@icarz.com 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:51:39 -0000 Julian Elischer wrote: > >I know nothing about Mysql >so I suggest you talk to petri.. >look in the threads mailing list archive.. look for MySQL. > > The same problem I have had since quite a while still persist. The problem is that after running for a while, mysqld stops responding to SIGTERM and a clean shutdown is not possible. I should probably check if this issue still persists with -CURRENT but just haven´t taken the time to upgrade our application test machines. (mostly because I haven´t had the time to check if going there would mean breaking some unrelated things) I´ll try to get there eventually. This is on 5.2.1-RELEASE-p1. Using libmap.conf of ; > cat /etc/libmap.conf libc_r.so.5 libkse.so.1 libc_r.so libkse.so > ps axH |grep mysql 651 ?? IL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? IL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? IL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? SL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? SL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? SL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? SL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? SL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? IL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? IL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? IL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? SL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? SL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 651 ?? SL 1194:05,89 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/var/db/mysql --user=mysql 30988 p4 DL+ 0:00,00 grep mysql 574 con- IL 0:00,02 /bin/sh /usr/local/bin/mysqld_safe --user=mysql --datadir=/var/db/mysql --pid-file=/ Pete From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 01:15:19 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 51CFC16A4CE for ; Thu, 15 Apr 2004 01:15:19 -0700 (PDT) Received: from publicd.ub.mng.net (publicd.ub.mng.net [202.179.0.88]) by mx1.FreeBSD.org (Postfix) with ESMTP id 60C0143D53 for ; Thu, 15 Apr 2004 01:15:18 -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 1BE2to-000KKG-7d; Thu, 15 Apr 2004 17:11:08 +0800 Message-Id: <6.0.3.0.2.20040415171747.02ae2790@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 17:20:07 +0900 To: Petri Helenius From: Ganbold In-Reply-To: <407E3EDB.8020508@he.iki.fi> References: <407E3EDB.8020508@he.iki.fi> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1"; format=flowed Content-Transfer-Encoding: quoted-printable 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 08:15:19 -0000 What threading library do you suggest for mysql in FreeBSD-CURRENT? Mostly I'm using linuxthreads on machines updated before March 23, 2004. Ganbold At 04:50 PM 15.04.2004, you wrote: >Julian Elischer wrote: > >> >>I know nothing about Mysql >>so I suggest you talk to petri.. look in the threads mailing list=20 >>archive.. look for MySQL. >> >The same problem I have had since quite a while still persist. The problem= =20 >is that after running for a while, mysqld stops responding to SIGTERM and= =20 >a clean shutdown is not possible. I should probably check if this issue=20 >still persists with -CURRENT but just haven=B4t taken the time to upgrade= =20 >our application test machines. (mostly because I haven=B4t had the time to= =20 >check if going there would mean breaking some unrelated things) I=B4ll try= =20 >to get there eventually. > >This is on 5.2.1-RELEASE-p1. Using libmap.conf of ; > > cat /etc/libmap.conf > >libc_r.so.5 libkse.so.1 >libc_r.so libkse.so > > > ps axH |grep mysql > 651 ?? IL 1194:05,89 /usr/local/libexec/mysqld --basedir=3D/usr/local= =20 > --datadir=3D/var/db/mysql --user=3Dmysql > 651 ?? IL 1194:05,89 /usr/local/libexec/mysqld --basedir=3D/usr/local= =20 > --datadir=3D/var/db/mysql --user=3Dmysql > 651 ?? IL 1194:05,89 /usr/local/libexec/mysqld --basedir=3D/usr/local= =20 > --datadir=3D/var/db/mysql --user=3Dmysql > 651 ?? SL 1194:05,89 /usr/local/libexec/mysqld --basedir=3D/usr/local= =20 > --datadir=3D/var/db/mysql --user=3Dmysql > 651 ?? SL 1194:05,89 /usr/local/libexec/mysqld --basedir=3D/usr/local= =20 > --datadir=3D/var/db/mysql --user=3Dmysql > 651 ?? SL 1194:05,89 /usr/local/libexec/mysqld --basedir=3D/usr/local= =20 > --datadir=3D/var/db/mysql --user=3Dmysql > 651 ?? SL 1194:05,89 /usr/local/libexec/mysqld --basedir=3D/usr/local= =20 > --datadir=3D/var/db/mysql --user=3Dmysql > 651 ?? SL 1194:05,89 /usr/local/libexec/mysqld --basedir=3D/usr/local= =20 > --datadir=3D/var/db/mysql --user=3Dmysql > 651 ?? IL 1194:05,89 /usr/local/libexec/mysqld --basedir=3D/usr/local= =20 > --datadir=3D/var/db/mysql --user=3Dmysql > 651 ?? IL 1194:05,89 /usr/local/libexec/mysqld --basedir=3D/usr/local= =20 > --datadir=3D/var/db/mysql --user=3Dmysql > 651 ?? IL 1194:05,89 /usr/local/libexec/mysqld --basedir=3D/usr/local= =20 > --datadir=3D/var/db/mysql --user=3Dmysql > 651 ?? SL 1194:05,89 /usr/local/libexec/mysqld --basedir=3D/usr/local= =20 > --datadir=3D/var/db/mysql --user=3Dmysql > 651 ?? SL 1194:05,89 /usr/local/libexec/mysqld --basedir=3D/usr/local= =20 > --datadir=3D/var/db/mysql --user=3Dmysql > 651 ?? SL 1194:05,89 /usr/local/libexec/mysqld --basedir=3D/usr/local= =20 > --datadir=3D/var/db/mysql --user=3Dmysql >30988 p4 DL+ 0:00,00 grep mysql > 574 con- IL 0:00,02 /bin/sh /usr/local/bin/mysqld_safe --user=3Dmysql= =20 > --datadir=3D/var/db/mysql --pid-file=3D/ > >Pete > > From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 01:26:34 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 C54DD16A4CE for ; Thu, 15 Apr 2004 01:26:34 -0700 (PDT) Received: from rms04.rommon.net (rms04.rommon.net [212.54.2.140]) by mx1.FreeBSD.org (Postfix) with ESMTP id 178A143D54 for ; Thu, 15 Apr 2004 01:26:34 -0700 (PDT) (envelope-from pete@he.iki.fi) Received: from he.iki.fi (h91.vuokselantie10.fi [193.64.42.145]) by rms04.rommon.net (8.12.10/8.12.9) with ESMTP id i3F8Pxmo046086; Thu, 15 Apr 2004 11:25:59 +0300 (EEST) (envelope-from pete@he.iki.fi) Message-ID: <407E4712.1070804@he.iki.fi> Date: Thu, 15 Apr 2004 11:25:54 +0300 From: Petri Helenius User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Julian Elischer References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit cc: threads@freebsd.org cc: Alexander@Leidinger.net cc: kenm@icarz.com 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 08:26:34 -0000 Julian Elischer wrote: > > > > >hmmm but you don't see the 'hang' that he sees.. > > > The application runs fine, even after I tell it to shut down, it keeps going and going and going .... :-) Obviously SIGKILL takes care of it, but shutting db engines with SIGKILL might lower confidence in production systems. >if you upgrade, be aware that it is now libpthread not libkse.... > > > When I upgrade, how do I best approach the problem, if it´s mysql or something in the library associated with delivering signals? I have not patched mysql to use process scope threads so I suppose everything runs system scope. Our in-house applications which also use threads, some quite heavily, get SIGTERM just fine so my suspicion would be something in mysql disagrees with the threads implementation in FreeBSD. Pete From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 01:28:00 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 76C6416A4CE for ; Thu, 15 Apr 2004 01:28:00 -0700 (PDT) Received: from rms04.rommon.net (rms04.rommon.net [212.54.2.140]) by mx1.FreeBSD.org (Postfix) with ESMTP id 10F8D43D1F for ; Thu, 15 Apr 2004 01:27:59 -0700 (PDT) (envelope-from pete@he.iki.fi) Received: from he.iki.fi (h91.vuokselantie10.fi [193.64.42.145]) by rms04.rommon.net (8.12.10/8.12.9) with ESMTP id i3F8Rxmo046089; Thu, 15 Apr 2004 11:28:00 +0300 (EEST) (envelope-from pete@he.iki.fi) Message-ID: <407E478A.10406@he.iki.fi> Date: Thu, 15 Apr 2004 11:27:54 +0300 From: Petri Helenius User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Ganbold References: <407E3EDB.8020508@he.iki.fi> <6.0.3.0.2.20040415171747.02ae2790@202.179.0.80> In-Reply-To: <6.0.3.0.2.20040415171747.02ae2790@202.179.0.80> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit 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 08:28:00 -0000 Ganbold wrote: > What threading library do you suggest for mysql in FreeBSD-CURRENT? > Mostly I'm using linuxthreads on machines updated before March 23, 2004. > I'm using libkse (in current it´s renamed to libpthread) with test systems and linuxthreads in production at this time. Pete >> > From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 01:44:41 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 9289016A4CE for ; Thu, 15 Apr 2004 01:44:41 -0700 (PDT) Received: from publicd.ub.mng.net (publicd.ub.mng.net [202.179.0.88]) by mx1.FreeBSD.org (Postfix) with ESMTP id A5AD043D3F for ; Thu, 15 Apr 2004 01:44:40 -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 1BE3MN-000KY5-2U; Thu, 15 Apr 2004 17:40:39 +0800 Message-Id: <6.0.3.0.2.20040415174616.02ae1f38@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 17:49:36 +0900 To: Petri Helenius From: Ganbold In-Reply-To: <407E478A.10406@he.iki.fi> References: <407E3EDB.8020508@he.iki.fi> <6.0.3.0.2.20040415171747.02ae2790@202.179.0.80> <407E478A.10406@he.iki.fi> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1"; format=flowed Content-Transfer-Encoding: quoted-printable 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 08:44:41 -0000 Can you tell me the performance on test machine? Is it better than production with linuxthreads? Ganbold At 05:27 PM 15.04.2004, you wrote: >Ganbold wrote: > >>What threading library do you suggest for mysql in FreeBSD-CURRENT? >>Mostly I'm using linuxthreads on machines updated before March 23, 2004. >I'm using libkse (in current it=B4s renamed to libpthread) with test= systems=20 >and linuxthreads in production at this time. > >Pete > > > From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 01:52:16 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 DEEC816A4CE for ; Thu, 15 Apr 2004 01:52:16 -0700 (PDT) Received: from mailout04.sul.t-online.com (mailout04.sul.t-online.com [194.25.134.18]) by mx1.FreeBSD.org (Postfix) with ESMTP id EA77943D5D for ; Thu, 15 Apr 2004 01:52:15 -0700 (PDT) (envelope-from Alexander@Leidinger.net) Received: from fwd01.aul.t-online.de by mailout04.sul.t-online.com with smtp id 1BE2bH-00064G-00; Thu, 15 Apr 2004 10:51:59 +0200 Received: from Andro-Beta.Leidinger.net (TzISjBZ-8eIgYetDu2hAIuRgA2nYk0+erIf2r19RthxgS0TbuOl00X@[217.229.215.93]) by fmrl01.sul.t-online.com with esmtp id 1BE2ao-16xQPY0; Thu, 15 Apr 2004 10:51:30 +0200 Received: from Magellan.Leidinger.net (Magellan.Leidinger.net [192.168.1.1]) i3F8pHmm039558; Thu, 15 Apr 2004 10:51:18 +0200 (CEST) (envelope-from Alexander@Leidinger.net) Date: Thu, 15 Apr 2004 10:51:44 +0200 From: Alexander Leidinger To: Petri Helenius Message-Id: <20040415105144.0cf661b3@Magellan.Leidinger.net> In-Reply-To: <407E4712.1070804@he.iki.fi> References: <407E4712.1070804@he.iki.fi> X-Mailer: Sylpheed version 0.9.10claws (GTK+ 1.2.10; i386-portbld-freebsd5.2) Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Seen: false X-ID: TzISjBZ-8eIgYetDu2hAIuRgA2nYk0+erIf2r19RthxgS0TbuOl00X@t-dialin.net cc: threads@freebsd.org cc: Julian Elischer cc: kenm@icarz.com 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 08:52:17 -0000 On Thu, 15 Apr 2004 11:25:54 +0300 Petri Helenius wrote: > >if you upgrade, be aware that it is now libpthread not libkse.... > > > > =20 > > > When I upgrade, how do I best approach the problem, if it=B4s mysql or=20 > something in the library associated with delivering signals? I have not=20 > patched mysql to use process scope threads so I suppose everything runs=20 > system scope. Our in-house applications which also use threads, some=20 > quite heavily, get SIGTERM just fine so my suspicion would be something=20 > in mysql disagrees with the threads implementation in FreeBSD. If I remember the commit logs right, libpthread was changed from using signals for internal signalling to something else. Bye, Alexander. --=20 I'm available to get hired. http://www.Leidinger.net Alexander @ Leidinger.net GPG fingerprint =3D C518 BC70 E67F 143F BE91 3365 79E2 9C60 B006 3FE7 From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 01:57:41 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 9EB3E16A4CE for ; Thu, 15 Apr 2004 01:57:41 -0700 (PDT) Received: from mailout03.sul.t-online.com (mailout03.sul.t-online.com [194.25.134.81]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5625943D4C for ; Thu, 15 Apr 2004 01:57:41 -0700 (PDT) (envelope-from Alexander@Leidinger.net) Received: from fwd05.aul.t-online.de by mailout03.sul.t-online.com with smtp id 1BE2fM-0000p9-00; Thu, 15 Apr 2004 10:56:12 +0200 Received: from Andro-Beta.Leidinger.net (VTuCEEZr8eVEGgiHipjFIDT8arJfl2MkWrUuaO9ViG0glSaQomep88@[217.229.215.93]) by fmrl05.sul.t-online.com with esmtp id 1BE2et-0JNwm00; Thu, 15 Apr 2004 10:55:43 +0200 Received: from Magellan.Leidinger.net (Magellan.Leidinger.net [192.168.1.1]) i3F8tWWZ040135; Thu, 15 Apr 2004 10:55:32 +0200 (CEST) (envelope-from Alexander@Leidinger.net) Date: Thu, 15 Apr 2004 10:55:59 +0200 From: Alexander Leidinger To: Ganbold Message-Id: <20040415105559.7fe9929b@Magellan.Leidinger.net> In-Reply-To: <6.0.3.0.2.20040415152523.02ad4b10@202.179.0.80> References: <6.0.3.0.2.20040415145916.02ae6708@202.179.0.80> <6.0.3.0.2.20040415152523.02ad4b10@202.179.0.80> X-Mailer: Sylpheed version 0.9.10claws (GTK+ 1.2.10; i386-portbld-freebsd5.2) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Seen: false X-ID: VTuCEEZr8eVEGgiHipjFIDT8arJfl2MkWrUuaO9ViG0glSaQomep88@t-dialin.net cc: threads@freebsd.org cc: Julian Elischer cc: kenm@icarz.com 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 08:57:41 -0000 On Thu, 15 Apr 2004 15:34:23 +0900 Ganbold wrote: > I did cvsup today and updated FreeBSD 5.2-CURRENT. Did you also recompile MySQL? You use BUILD_STATIC, so MySQL doesn't use the new libs, you have to recompile (or don't use BUILD_STATIC). > 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. 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 From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 02:03:18 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 5697316A4CE for ; Thu, 15 Apr 2004 02:03:18 -0700 (PDT) Received: from publicd.ub.mng.net (publicd.ub.mng.net [202.179.0.88]) by mx1.FreeBSD.org (Postfix) with ESMTP id D8D5943D58 for ; Thu, 15 Apr 2004 02:03:12 -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 1BE3eC-000Kgh-C9; Thu, 15 Apr 2004 17:59:04 +0800 Message-Id: <6.0.3.0.2.20040415180553.02adc870@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 18:07:55 +0900 To: Alexander Leidinger From: Ganbold In-Reply-To: <20040415105559.7fe9929b@Magellan.Leidinger.net> References: <6.0.3.0.2.20040415145916.02ae6708@202.179.0.80> <6.0.3.0.2.20040415152523.02ad4b10@202.179.0.80> <20040415105559.7fe9929b@Magellan.Leidinger.net> 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 09:03:18 -0000 Hi, At 05:55 PM 15.04.2004, you wrote: >On Thu, 15 Apr 2004 15:34:23 +0900 >Ganbold wrote: > > > I did cvsup today and updated FreeBSD 5.2-CURRENT. > >Did you also recompile MySQL? You use BUILD_STATIC, so MySQL doesn't use >the new libs, you have to recompile (or don't use BUILD_STATIC). Yes, I rebuild mysql. > > 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? thanks, Ganbold >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 From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 02:25:14 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 8C58D16A4CE for ; Thu, 15 Apr 2004 02:25:14 -0700 (PDT) Received: from rms04.rommon.net (rms04.rommon.net [212.54.2.140]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4988D43D2F for ; Thu, 15 Apr 2004 02:25:13 -0700 (PDT) (envelope-from pete@he.iki.fi) Received: from he.iki.fi (h91.vuokselantie10.fi [193.64.42.145]) by rms04.rommon.net (8.12.10/8.12.9) with ESMTP id i3F9PCmo046281; Thu, 15 Apr 2004 12:25:13 +0300 (EEST) (envelope-from pete@he.iki.fi) Message-ID: <407E54F3.5060900@he.iki.fi> Date: Thu, 15 Apr 2004 12:25:07 +0300 From: Petri Helenius User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Ganbold References: <407E3EDB.8020508@he.iki.fi> <6.0.3.0.2.20040415171747.02ae2790@202.179.0.80> <407E478A.10406@he.iki.fi> <6.0.3.0.2.20040415174616.02ae1f38@202.179.0.80> In-Reply-To: <6.0.3.0.2.20040415174616.02ae1f38@202.179.0.80> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit 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 09:25:14 -0000 Ganbold wrote: > Can you tell me the performance on test machine? > Is it better than production with linuxthreads? > It feels faster but due to different hardware, I cannot make accurate benchmarks. Next time we add hardware I can run some benchmarks. However in our environment we´re disk-limited instead of cpu-limited and because of that our focus has been on optimizing the disk arrangements. Pete From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 02:26:25 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 1FC2916A4CE for ; Thu, 15 Apr 2004 02:26:25 -0700 (PDT) Received: from rms04.rommon.net (rms04.rommon.net [212.54.2.140]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4FCF943D3F for ; Thu, 15 Apr 2004 02:26:24 -0700 (PDT) (envelope-from pete@he.iki.fi) Received: from he.iki.fi (h91.vuokselantie10.fi [193.64.42.145]) by rms04.rommon.net (8.12.10/8.12.9) with ESMTP id i3F9Pkmo046284; Thu, 15 Apr 2004 12:25:47 +0300 (EEST) (envelope-from pete@he.iki.fi) Message-ID: <407E5515.3020207@he.iki.fi> Date: Thu, 15 Apr 2004 12:25:41 +0300 From: Petri Helenius User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Alexander Leidinger References: <407E4712.1070804@he.iki.fi> <20040415105144.0cf661b3@Magellan.Leidinger.net> In-Reply-To: <20040415105144.0cf661b3@Magellan.Leidinger.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit cc: threads@freebsd.org cc: Julian Elischer cc: kenm@icarz.com 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 09:26:25 -0000 Alexander Leidinger wrote: > >If I remember the commit logs right, libpthread was changed from using >signals for internal signalling to something else. > > > Has this happened after 5.2.1 ? Pete From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 03:00:41 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 3A70D16A4CE for ; Thu, 15 Apr 2004 03:00:41 -0700 (PDT) Received: from mailout07.sul.t-online.com (mailout07.sul.t-online.com [194.25.134.83]) by mx1.FreeBSD.org (Postfix) with ESMTP id A984343D60 for ; Thu, 15 Apr 2004 03:00:40 -0700 (PDT) (envelope-from Alexander@Leidinger.net) Received: from fwd02.aul.t-online.de by mailout07.sul.t-online.com with smtp id 1BE3fb-0005Wt-02; Thu, 15 Apr 2004 12:00:31 +0200 Received: from Andro-Beta.Leidinger.net (GEBdwiZYreHcsIxOTRldi8CQvBok623DNcRSuG6FHT5Ib8DpPUanUN@[217.229.215.93]) by fmrl02.sul.t-online.com with esmtp id 1BE3fE-1Smt8K0; Thu, 15 Apr 2004 12:00:08 +0200 Received: from Magellan.Leidinger.net (Magellan.Leidinger.net [192.168.1.1]) i3F9xnNw049177; Thu, 15 Apr 2004 11:59:49 +0200 (CEST) (envelope-from Alexander@Leidinger.net) Date: Thu, 15 Apr 2004 12:00:16 +0200 From: Alexander Leidinger To: Petri Helenius Message-Id: <20040415120016.0a35a2af@Magellan.Leidinger.net> In-Reply-To: <407E5515.3020207@he.iki.fi> References: <407E4712.1070804@he.iki.fi> <20040415105144.0cf661b3@Magellan.Leidinger.net> <407E5515.3020207@he.iki.fi> X-Mailer: Sylpheed version 0.9.10claws (GTK+ 1.2.10; i386-portbld-freebsd5.2) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Seen: false X-ID: GEBdwiZYreHcsIxOTRldi8CQvBok623DNcRSuG6FHT5Ib8DpPUanUN@t-dialin.net cc: threads@freebsd.org cc: Julian Elischer cc: kenm@icarz.com 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 10:00:41 -0000 On Thu, 15 Apr 2004 12:25:41 +0300 Petri Helenius wrote: > Alexander Leidinger wrote: > > > > >If I remember the commit logs right, libpthread was changed from using > >signals for internal signalling to something else. > > > > > > > Has this happened after 5.2.1 ? Yes. 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 From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 03:02:54 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 2FB3716A4CE for ; Thu, 15 Apr 2004 03:02:54 -0700 (PDT) Received: from mailout01.sul.t-online.com (mailout01.sul.t-online.com [194.25.134.80]) by mx1.FreeBSD.org (Postfix) with ESMTP id C284343D5F for ; Thu, 15 Apr 2004 03:02:53 -0700 (PDT) (envelope-from Alexander@Leidinger.net) Received: from fwd11.aul.t-online.de by mailout01.sul.t-online.com with smtp id 1BE3hs-0005qK-01; Thu, 15 Apr 2004 12:02:52 +0200 Received: from Andro-Beta.Leidinger.net (TnwVcOZDoeTvD-tRDjJqJZFIWT8y+U8auyS7DKTWdPhf90Bn7l3P6J@[217.229.215.93]) by fmrl11.sul.t-online.com with esmtp id 1BE3hZ-08NzU00; Thu, 15 Apr 2004 12:02:33 +0200 Received: from Magellan.Leidinger.net (Magellan.Leidinger.net [192.168.1.1]) i3FA2Rj0049550; Thu, 15 Apr 2004 12:02:27 +0200 (CEST) (envelope-from Alexander@Leidinger.net) Date: Thu, 15 Apr 2004 12:02:54 +0200 From: Alexander Leidinger To: Ganbold Message-Id: <20040415120254.4318c248@Magellan.Leidinger.net> In-Reply-To: <6.0.3.0.2.20040415180553.02adc870@202.179.0.80> References: <6.0.3.0.2.20040415145916.02ae6708@202.179.0.80> <6.0.3.0.2.20040415152523.02ad4b10@202.179.0.80> <20040415105559.7fe9929b@Magellan.Leidinger.net> <6.0.3.0.2.20040415180553.02adc870@202.179.0.80> X-Mailer: Sylpheed version 0.9.10claws (GTK+ 1.2.10; i386-portbld-freebsd5.2) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Seen: false X-ID: TnwVcOZDoeTvD-tRDjJqJZFIWT8y+U8auyS7DKTWdPhf90Bn7l3P6J@t-dialin.net 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 10:02:54 -0000 On Thu, 15 Apr 2004 18:07:55 +0900 Ganbold 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 From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 07:30:16 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 1525E16A4CF for ; Thu, 15 Apr 2004 07:30:16 -0700 (PDT) Received: from mail.pcnet.com (mail.pcnet.com [204.213.232.4]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6AE3D43D2D for ; Thu, 15 Apr 2004 07:30:15 -0700 (PDT) (envelope-from eischen@vigrid.com) Received: from mail.pcnet.com (mail.pcnet.com [204.213.232.4]) by mail.pcnet.com (8.12.10/8.12.1) with ESMTP id i3FEU0tf018588; Thu, 15 Apr 2004 10:30:00 -0400 (EDT) Date: Thu, 15 Apr 2004 10:30:00 -0400 (EDT) From: Daniel Eischen X-Sender: eischen@pcnet5.pcnet.com To: Alexander Leidinger In-Reply-To: <20040415120016.0a35a2af@Magellan.Leidinger.net> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII cc: threads@freebsd.org cc: kenm@icarz.com cc: Julian Elischer 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 14:30:16 -0000 On Thu, 15 Apr 2004, Alexander Leidinger wrote: > On Thu, 15 Apr 2004 12:25:41 +0300 > Petri Helenius wrote: > > > Alexander Leidinger wrote: > > > > > > > >If I remember the commit logs right, libpthread was changed from using > > >signals for internal signalling to something else. > > > > > > > > > > > Has this happened after 5.2.1 ? > > Yes. libpthread (nee libkse) never used signals for internal signalling. That was libthr I believe. -- Dan Eischen From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 08:22:24 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 3721C16A4DA for ; Thu, 15 Apr 2004 08:22:24 -0700 (PDT) Received: from mailout04.sul.t-online.com (mailout04.sul.t-online.com [194.25.134.18]) by mx1.FreeBSD.org (Postfix) with ESMTP id B8C9043D2F for ; Thu, 15 Apr 2004 08:22:23 -0700 (PDT) (envelope-from Alexander@Leidinger.net) Received: from fwd05.aul.t-online.de by mailout04.sul.t-online.com with smtp id 1BE8gy-0007Ze-03; Thu, 15 Apr 2004 17:22:16 +0200 Received: from Andro-Beta.Leidinger.net (bRUQriZDwezDA-a9t2XPIXDigpqbN52v8uVesVWUeOVvqzEIAtDhr4@[217.229.215.93]) by fmrl05.sul.t-online.com with esmtp id 1BE8ge-07tT3Q0; Thu, 15 Apr 2004 17:21:56 +0200 Received: from Magellan.Leidinger.net (Magellan.Leidinger.net [192.168.1.1]) i3FFLs5t006611; Thu, 15 Apr 2004 17:21:54 +0200 (CEST) (envelope-from Alexander@Leidinger.net) Date: Thu, 15 Apr 2004 17:22:22 +0200 From: Alexander Leidinger To: Daniel Eischen Message-Id: <20040415172222.66a0912c@Magellan.Leidinger.net> In-Reply-To: References: <20040415120016.0a35a2af@Magellan.Leidinger.net> X-Mailer: Sylpheed version 0.9.10claws (GTK+ 1.2.10; i386-portbld-freebsd5.2) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Seen: false X-ID: bRUQriZDwezDA-a9t2XPIXDigpqbN52v8uVesVWUeOVvqzEIAtDhr4@t-dialin.net cc: threads@freebsd.org cc: kenm@icarz.com cc: Julian Elischer 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 15:22:24 -0000 On Thu, 15 Apr 2004 10:30:00 -0400 (EDT) Daniel Eischen wrote: > libpthread (nee libkse) never used signals for internal signalling. > That was libthr I believe. src/lib/libthr/thread/thr_cond.c: ---snip--- revision 1.11 date: 2004/03/27 14:39:21; author: mtm; state: Exp; lines: +1 -1 Stop using signals for synchronizing threads. The performance penalty was too much. ---snip--- Thanks for correcting this. 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 From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 11:40:49 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 B0A1216A4CF for ; Thu, 15 Apr 2004 11:40:49 -0700 (PDT) Received: from rwcrmhc11.comcast.net (rwcrmhc11.comcast.net [204.127.198.35]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8A2CD43D39 for ; Thu, 15 Apr 2004 11:40:49 -0700 (PDT) (envelope-from julian@elischer.org) Received: from interjet.elischer.org ([24.7.73.28]) by comcast.net (rwcrmhc11) with ESMTP id <2004041518404801300fj0uie>; Thu, 15 Apr 2004 18:40:49 +0000 Received: from localhost (localhost.elischer.org [127.0.0.1]) by InterJet.elischer.org (8.9.1a/8.9.1) with ESMTP id LAA50110; Thu, 15 Apr 2004 11:40:47 -0700 (PDT) Date: Thu, 15 Apr 2004 11:40:46 -0700 (PDT) From: Julian Elischer To: Alexander Leidinger In-Reply-To: <20040415105144.0cf661b3@Magellan.Leidinger.net> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=X-UNKNOWN Content-Transfer-Encoding: QUOTED-PRINTABLE cc: threads@freebsd.org cc: kenm@icarz.com 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 18:40:49 -0000 On Thu, 15 Apr 2004, Alexander Leidinger wrote: > On Thu, 15 Apr 2004 11:25:54 +0300 > Petri Helenius wrote: >=20 > > >if you upgrade, be aware that it is now libpthread not libkse.... > > > > > > =20 > > > > > When I upgrade, how do I best approach the problem, if it=B4s mysql or= =20 > > something in the library associated with delivering signals? I have not= =20 > > patched mysql to use process scope threads so I suppose everything runs= =20 > > system scope. Our in-house applications which also use threads, some=20 > > quite heavily, get SIGTERM just fine so my suspicion would be something= =20 > > in mysql disagrees with the threads implementation in FreeBSD. >=20 > If I remember the commit logs right, libpthread was changed from using > signals for internal signalling to something else. that was libthr. (you could try that too) >=20 > Bye, > Alexander. >=20 > --=20 > I'm available to get hired. >=20 > http://www.Leidinger.net Alexander @ Leidinger.net > GPG fingerprint =3D 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= " >=20 From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 11:43:24 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 49EBD16A4D6 for ; Thu, 15 Apr 2004 11:43:24 -0700 (PDT) Received: from rwcrmhc12.comcast.net (rwcrmhc12.comcast.net [216.148.227.85]) by mx1.FreeBSD.org (Postfix) with ESMTP id D5A5543D48 for ; Thu, 15 Apr 2004 11:43:23 -0700 (PDT) (envelope-from julian@elischer.org) Received: from interjet.elischer.org ([24.7.73.28]) by comcast.net (rwcrmhc12) with ESMTP id <200404151843160140017ta4e>; Thu, 15 Apr 2004 18:43:23 +0000 Received: from localhost (localhost.elischer.org [127.0.0.1]) by InterJet.elischer.org (8.9.1a/8.9.1) with ESMTP id LAA50135; Thu, 15 Apr 2004 11:43:16 -0700 (PDT) Date: Thu, 15 Apr 2004 11:43:16 -0700 (PDT) From: Julian Elischer To: Petri Helenius In-Reply-To: <407E5515.3020207@he.iki.fi> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII cc: Alexander Leidinger 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 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 18:43:24 -0000 yes, but it was libthr (but there were some fixes for libpthreads after 5.2.1 too.) 5.2.1 is definitly only beta quality WRT the threads. On Thu, 15 Apr 2004, Petri Helenius wrote: > Alexander Leidinger wrote: > > > > >If I remember the commit logs right, libpthread was changed from using > >signals for internal signalling to something else. > > > > > > > Has this happened after 5.2.1 ? > > Pete > > From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 18:29: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 57B8016A4CE for ; Thu, 15 Apr 2004 18:29:03 -0700 (PDT) Received: from publicd.ub.mng.net (publicd.ub.mng.net [202.179.0.88]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7E85543D53 for ; Thu, 15 Apr 2004 18:29:01 -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 1BEJ26-000A1E-VS; Fri, 16 Apr 2004 10:24:47 +0800 Message-Id: <6.0.3.0.2.20040416103300.02b01860@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: Fri, 16 Apr 2004 10:33:51 +0900 To: Alexander Leidinger From: Ganbold In-Reply-To: <20040415120254.4318c248@Magellan.Leidinger.net> References: <6.0.3.0.2.20040415145916.02ae6708@202.179.0.80> <6.0.3.0.2.20040415152523.02ad4b10@202.179.0.80> <20040415105559.7fe9929b@Magellan.Leidinger.net> <6.0.3.0.2.20040415180553.02adc870@202.179.0.80> <20040415120254.4318c248@Magellan.Leidinger.net> 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: Fri, 16 Apr 2004 01:29:03 -0000 How do I know what threading library is using at the moment? Is there any command? tia, Ganbold At 07:02 PM 15.04.2004, you wrote: >On Thu, 15 Apr 2004 18:07:55 +0900 >Ganbold 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 From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 19:24:11 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 316CE16A4CE for ; Thu, 15 Apr 2004 19:24:11 -0700 (PDT) Received: from publicd.ub.mng.net (publicd.ub.mng.net [202.179.0.88]) by mx1.FreeBSD.org (Postfix) with ESMTP id 1B53B43D58 for ; Thu, 15 Apr 2004 19:24:10 -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 1BEJtd-000Ete-SJ; Fri, 16 Apr 2004 11:20:05 +0800 Message-Id: <6.0.3.0.2.20040416111531.02b719e8@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: Fri, 16 Apr 2004 11:29:12 +0900 To: Alexander Leidinger From: Ganbold Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed cc: threads@freebsd.org cc: kenm@icarz.com 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: Fri, 16 Apr 2004 02:24:11 -0000 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 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 From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 19:46:20 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 ED9F516A4CE for ; Thu, 15 Apr 2004 19:46:20 -0700 (PDT) Received: from mail.pcnet.com (mail.pcnet.com [204.213.232.4]) by mx1.FreeBSD.org (Postfix) with ESMTP id 66D1543D2F for ; Thu, 15 Apr 2004 19:46:20 -0700 (PDT) (envelope-from eischen@vigrid.com) Received: from mail.pcnet.com (mail.pcnet.com [204.213.232.4]) by mail.pcnet.com (8.12.10/8.12.1) with ESMTP id i3G2kItf008382; Thu, 15 Apr 2004 22:46:19 -0400 (EDT) Date: Thu, 15 Apr 2004 22:46:18 -0400 (EDT) From: Daniel Eischen X-Sender: eischen@pcnet5.pcnet.com To: Ganbold In-Reply-To: <6.0.3.0.2.20040416111531.02b719e8@202.179.0.80> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII cc: Alexander Leidinger 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 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 16 Apr 2004 02:46:21 -0000 On Fri, 16 Apr 2004, Ganbold wrote: > 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 [ ... ] > 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. Then you are not doing it correctly. You should only see references to kserel when using libpthread (nee libkse). Please read /usr/src/UPDATING 20040130 and see the -threads archives for related mysql discussions. Unless you rebuild all your ports on that system, you should always use a libmap.conf entry that maps libc_r to your desired thread library as well as mapping libpthread to your desired thread library. To use libpthread, use: libc_r.so.5 libpthread.so.1 libc_r.so libpthread.so To use libc_r, use: libc_r.so.5 libc_r.so.5 libc_r.so libc_r.so libpthread.so.1 libc_r.so.5 libpthread.so libc_r.so To use libthr, use: libc_r.so.5 libthr.so.1 libc_r.so libthr.so libpthread.so.1 libthr.so.1 libpthread.so libthr.so Also, mysql uses scope system threads. I have a patch that makes it use scope process threads and it behaves much better: http://people.freebsd.org/~deischen/mysql40-server.diffs Also, mysql doesn't seem to work correctly when built with --with-libwrap support. It has something to do with compiler flags; see the -threads archives for more info. Also, there are built-in default limits for threads under libpthread. See the output of `sysctl -a | grep kern.threads`. All of the above information can be found in the -threads archives; please use it :-) > > 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. Probably because you are mixing threading libraries. -- Dan Eischen From owner-freebsd-threads@FreeBSD.ORG Thu Apr 15 22:51:13 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 3CEBA16A4CE for ; Thu, 15 Apr 2004 22:51:13 -0700 (PDT) Received: from publicd.ub.mng.net (publicd.ub.mng.net [202.179.0.88]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3BE9943D58 for ; Thu, 15 Apr 2004 22:51:11 -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 1BEN83-000GQX-5t; Fri, 16 Apr 2004 14:47:11 +0800 Message-Id: <6.0.3.0.2.20040416144532.02b9fe90@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: Fri, 16 Apr 2004 14:55:56 +0900 To: Daniel Eischen From: Ganbold In-Reply-To: References: <6.0.3.0.2.20040416111531.02b719e8@202.179.0.80> 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: Fri, 16 Apr 2004 05:51:13 -0000 Dan, Julian, Petri and Alexander, Thank you for your great help. Before I was using kernel SCHED_ULE and BUILD_STATIC option to build mysql. I switched back to SCHED_4BSD and patched mysql with Dan's patch. Mysql is dynamically linked and compiled with libpthread. Let us see what will happen. Below are outputs of ldd and ps: backend2# ldd /usr/local/libexec/mysqld /usr/local/libexec/mysqld: libpthread.so.1 => /usr/lib/libpthread.so.1 (0x48357000) libz.so.2 => /lib/libz.so.2 (0x4837a000) libcrypt.so.2 => /lib/libcrypt.so.2 (0x48387000) libstdc++.so.4 => /usr/lib/libstdc++.so.4 (0x4839f000) libm.so.2 => /lib/libm.so.2 (0x48451000) libc.so.5 => /lib/libc.so.5 (0x48469000) backend2# ps axlHwww | grep mysql 88 764 672 1 4 0 451940 450128 sbwait SL ?? 0:37.47 (mysqld) 88 764 672 0 20 0 451940 450128 ksesig SL ?? 0:37.47 (mysqld) 88 764 672 1 4 0 451940 450128 sbwait SL ?? 0:37.47 (mysqld) 88 764 672 1 96 0 451940 450128 select SL ?? 0:37.47 (mysqld) 88 764 672 1 20 0 451940 450128 kserel SL ?? 0:37.47 (mysqld) 88 764 672 1 20 0 451940 450128 kserel SL ?? 0:37.47 (mysqld) 88 764 672 1 4 0 451940 450128 sbwait SL ?? 0:37.47 (mysqld) 88 764 672 1 20 0 451940 450128 kserel SL ?? 0:37.47 (mysqld) 88 764 672 1 4 0 451940 450128 sbwait SL ?? 0:37.47 (mysqld) 88 764 672 1 20 0 451940 450128 kserel SL ?? 0:37.47 (mysqld) 0 777 772 0 5 0 3512 3008 ttyin SL+ p0 0:00.06 mysql -p 0 672 1 532 8 0 1616 1168 wait IL con- 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 If there will be a problem again, I will continue to experiment with other threading libraries. Thanks a lot again, Ganbold At 11:46 AM 16.04.2004, you wrote: >On Fri, 16 Apr 2004, Ganbold wrote: > > > 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 >[ ... ] > > 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. > >Then you are not doing it correctly. You should only see >references to kserel when using libpthread (nee libkse). > >Please read /usr/src/UPDATING 20040130 and see the -threads >archives for related mysql discussions. > >Unless you rebuild all your ports on that system, you should >always use a libmap.conf entry that maps libc_r to your >desired thread library as well as mapping libpthread to >your desired thread library. > >To use libpthread, use: > >libc_r.so.5 libpthread.so.1 >libc_r.so libpthread.so > >To use libc_r, use: > >libc_r.so.5 libc_r.so.5 >libc_r.so libc_r.so >libpthread.so.1 libc_r.so.5 >libpthread.so libc_r.so > >To use libthr, use: > >libc_r.so.5 libthr.so.1 >libc_r.so libthr.so >libpthread.so.1 libthr.so.1 >libpthread.so libthr.so > >Also, mysql uses scope system threads. I have a patch >that makes it use scope process threads and it behaves >much better: > > http://people.freebsd.org/~deischen/mysql40-server.diffs > >Also, mysql doesn't seem to work correctly when built with >--with-libwrap support. It has something to do with compiler >flags; see the -threads archives for more info. > >Also, there are built-in default limits for threads under >libpthread. See the output of `sysctl -a | grep kern.threads`. > >All of the above information can be found in the -threads >archives; please use it :-) > > > > > 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. > >Probably because you are mixing threading libraries. > >-- >Dan Eischen From owner-freebsd-threads@FreeBSD.ORG Fri Apr 16 10:33:21 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 E576916A50E for ; Fri, 16 Apr 2004 10:33:19 -0700 (PDT) Received: from rwcrmhc11.comcast.net (rwcrmhc11.comcast.net [204.127.198.35]) by mx1.FreeBSD.org (Postfix) with ESMTP id 37F4D43D54 for ; Fri, 16 Apr 2004 10:33:19 -0700 (PDT) (envelope-from julian@elischer.org) Received: from interjet.elischer.org ([24.7.73.28]) by comcast.net (rwcrmhc11) with ESMTP id <2004041617331101300fkhike>; Fri, 16 Apr 2004 17:33:18 +0000 Received: from localhost (localhost.elischer.org [127.0.0.1]) by InterJet.elischer.org (8.9.1a/8.9.1) with ESMTP id KAA63860; Fri, 16 Apr 2004 10:33:10 -0700 (PDT) Date: Fri, 16 Apr 2004 10:33:09 -0700 (PDT) From: Julian Elischer To: Daniel Eischen In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII cc: Alexander Leidinger cc: threads@freebsd.org cc: kenm@icarz.com 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: Fri, 16 Apr 2004 17:33:21 -0000 Are you linking dynamically or statically? On Thu, 15 Apr 2004, Daniel Eischen wrote: > On Fri, 16 Apr 2004, Ganbold wrote: > > > 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 > [ ... ] > > 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. > > Then you are not doing it correctly. You should only see > references to kserel when using libpthread (nee libkse). > > Please read /usr/src/UPDATING 20040130 and see the -threads > archives for related mysql discussions. > > Unless you rebuild all your ports on that system, you should > always use a libmap.conf entry that maps libc_r to your > desired thread library as well as mapping libpthread to > your desired thread library. > > To use libpthread, use: > > libc_r.so.5 libpthread.so.1 > libc_r.so libpthread.so > > To use libc_r, use: > > libc_r.so.5 libc_r.so.5 > libc_r.so libc_r.so > libpthread.so.1 libc_r.so.5 > libpthread.so libc_r.so > > To use libthr, use: > > libc_r.so.5 libthr.so.1 > libc_r.so libthr.so > libpthread.so.1 libthr.so.1 > libpthread.so libthr.so > > Also, mysql uses scope system threads. I have a patch > that makes it use scope process threads and it behaves > much better: > > http://people.freebsd.org/~deischen/mysql40-server.diffs > > Also, mysql doesn't seem to work correctly when built with > --with-libwrap support. It has something to do with compiler > flags; see the -threads archives for more info. > > Also, there are built-in default limits for threads under > libpthread. See the output of `sysctl -a | grep kern.threads`. > > All of the above information can be found in the -threads > archives; please use it :-) > > > > > 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. > > Probably because you are mixing threading libraries. > > -- > Dan Eischen > > _______________________________________________ > 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" > From owner-freebsd-threads@FreeBSD.ORG Fri Apr 16 18:08:17 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 3E65716A4CE for ; Fri, 16 Apr 2004 18:08:17 -0700 (PDT) Received: from mailout04.sul.t-online.com (mailout04.sul.t-online.com [194.25.134.18]) by mx1.FreeBSD.org (Postfix) with ESMTP id C226843D2F for ; Fri, 16 Apr 2004 18:08:16 -0700 (PDT) (envelope-from Alexander@Leidinger.net) Received: from fwd02.aul.t-online.de by mailout04.sul.t-online.com with smtp id 1BEeIn-0003QK-00; Sat, 17 Apr 2004 03:07:25 +0200 Received: from Andro-Beta.Leidinger.net (Gz+WEmZbQeycdT0qs77LJGBUkrWKQftXdxw2j-tp3wpJKxPkXWt7rB@[217.83.16.110]) by fmrl02.sul.t-online.com with esmtp id 1BEeIg-0MPU800; Sat, 17 Apr 2004 03:07:18 +0200 Received: from Magellan.Leidinger.net (Magellan.Leidinger.net [192.168.1.1]) i3G8lKBZ055340; Fri, 16 Apr 2004 10:47:20 +0200 (CEST) (envelope-from Alexander@Leidinger.net) Date: Fri, 16 Apr 2004 10:47:49 +0200 From: Alexander Leidinger To: Ganbold Message-Id: <20040416104749.7ba0eb02@Magellan.Leidinger.net> In-Reply-To: <6.0.3.0.2.20040416103300.02b01860@202.179.0.80> References: <6.0.3.0.2.20040415145916.02ae6708@202.179.0.80> <6.0.3.0.2.20040415152523.02ad4b10@202.179.0.80> <20040415105559.7fe9929b@Magellan.Leidinger.net> <6.0.3.0.2.20040415180553.02adc870@202.179.0.80> <20040415120254.4318c248@Magellan.Leidinger.net> <6.0.3.0.2.20040416103300.02b01860@202.179.0.80> X-Mailer: Sylpheed version 0.9.10claws (GTK+ 1.2.10; i386-portbld-freebsd5.2) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Seen: false X-ID: Gz+WEmZbQeycdT0qs77LJGBUkrWKQftXdxw2j-tp3wpJKxPkXWt7rB@t-dialin.net 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: Sat, 17 Apr 2004 01:08:17 -0000 On Fri, 16 Apr 2004 10:33:51 +0900 Ganbold wrote: > How do I know what threading library is using at the moment? > Is there any command? ldd /usr/local/libexec/mysqld | grep 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