From owner-freebsd-threads@FreeBSD.ORG Fri Jan 19 20:04:05 2007 Return-Path: X-Original-To: threads@freebsd.org Delivered-To: freebsd-threads@FreeBSD.ORG Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 60E3116A402 for ; Fri, 19 Jan 2007 20:04:05 +0000 (UTC) (envelope-from gordon_s_smith@hotmail.com) Received: from bay0-omc1-s16.bay0.hotmail.com (bay0-omc1-s16.bay0.hotmail.com [65.54.246.88]) by mx1.freebsd.org (Postfix) with ESMTP id 4EC4913C442 for ; Fri, 19 Jan 2007 20:04:05 +0000 (UTC) (envelope-from gordon_s_smith@hotmail.com) Received: from hotmail.com ([65.55.138.83]) by bay0-omc1-s16.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Fri, 19 Jan 2007 11:52:05 -0800 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Fri, 19 Jan 2007 11:52:05 -0800 Message-ID: Received: from 65.55.138.123 by by133fd.bay133.hotmail.msn.com with HTTP; Fri, 19 Jan 2007 19:52:00 GMT X-Originating-IP: [68.192.174.20] X-Originating-Email: [gordon_s_smith@hotmail.com] X-Sender: gordon_s_smith@hotmail.com From: "Gordon Smith" To: threads@freebsd.org Date: Fri, 19 Jan 2007 14:52:00 -0500 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 19 Jan 2007 19:52:05.0288 (UTC) FILETIME=[4B845280:01C73C03] X-Mailman-Approved-At: Mon, 22 Jan 2007 05:05:31 +0000 Cc: Subject: Recommended MySQL 4.1 Installation X-BeenThere: freebsd-threads@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 19 Jan 2007 20:04:05 -0000 Now that FreeBSD 6.2 is out, can anyone recommend specific configurations for FBSD and MySQL V.4.1 that deliver a really stable and fast (emphasizing stable) DB platform on 6.2? In the absence of such, info about 6.1 would also be greatly appreciated. Would I need to compile a specific threading library into FreeBSD to avoid panics or other problems that may occur under high load? I'm happy to RTFM on this. The last really good info I remember seeing about this (specifically about FBSD and MySQL) was from: - Jeremy Zawodny's blog entry http://jeremy.zawodny.com/blog/archives/000697.html - the mysql.com doc page http://dev.mysql.com/doc/refman/4.1/en/freebsd.html I would be willing to sacrifice some reasonable degree of performance for stability (if needed), so I want to be careful here. Running the Linux compatability layer is an option, if needed - I'm not sure if the Linux compatability layer is needed to support Linux threads (if Linux threads are the best choice of threading library to use with MySQL). Has anyone done recent benchmarks to compare threading libraries? Anyone have any contacts in MySQL AG that might be able provide suggestions? If I've missed some obvious documentation, I apologize in advance. Thank you. Gordon Smith From owner-freebsd-threads@FreeBSD.ORG Mon Jan 22 08:42:32 2007 Return-Path: X-Original-To: threads@freebsd.org Delivered-To: freebsd-threads@FreeBSD.ORG Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id EB05616A400 for ; Mon, 22 Jan 2007 08:42:32 +0000 (UTC) (envelope-from almarrie@gmail.com) Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.169]) by mx1.freebsd.org (Postfix) with ESMTP id 896B913C4A7 for ; Mon, 22 Jan 2007 08:42:32 +0000 (UTC) (envelope-from almarrie@gmail.com) Received: by ug-out-1314.google.com with SMTP id o2so920628uge for ; Mon, 22 Jan 2007 00:42:31 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=AIZx7WjNjGPdF/ZtbK+uv1hZ4bVqfOLxETBJiz9GP9OkUC+aZYjT2Le3nx5AZ3pJ2C9HwH4ubPU9TrzurDurRHHkYeBWWAEb+38BLQIsvKlB1FG4JXGLALaWQb+/GAEnajbECLUPkowdAOUg8lQxVke4klyO/B2SF6SICr8FcBI= Received: by 10.67.117.2 with SMTP id u2mr7132997ugm.1169453705253; Mon, 22 Jan 2007 00:15:05 -0800 (PST) Received: by 10.66.255.10 with HTTP; Mon, 22 Jan 2007 00:15:05 -0800 (PST) Message-ID: <499c70c0701220015m49d09cc0s95e2c165197d0478@mail.gmail.com> Date: Mon, 22 Jan 2007 11:15:05 +0300 From: "Abdullah Al-Marrie" To: "Gordon Smith" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: Cc: threads@freebsd.org Subject: Re: Recommended MySQL 4.1 Installation X-BeenThere: freebsd-threads@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 22 Jan 2007 08:42:33 -0000 On 1/19/07, Gordon Smith wrote: > Now that FreeBSD 6.2 is out, can anyone recommend specific configurations > for FBSD and MySQL V.4.1 that deliver a really stable and fast (emphasizing > stable) DB platform on 6.2? In the absence of such, info about 6.1 would > also be greatly appreciated. > > Would I need to compile a specific threading library into FreeBSD to avoid > panics or other problems that may occur under high load? > > I'm happy to RTFM on this. The last really good info I remember seeing > about this (specifically about FBSD and MySQL) was from: > - Jeremy Zawodny's blog entry > http://jeremy.zawodny.com/blog/archives/000697.html > - the mysql.com doc page > http://dev.mysql.com/doc/refman/4.1/en/freebsd.html > > I would be willing to sacrifice some reasonable degree of performance for > stability (if needed), so I want to be careful here. Running the Linux > compatability layer is an option, if needed - I'm not sure if the Linux > compatability layer is needed to support Linux threads (if Linux threads are > the best choice of threading library to use with MySQL). > > Has anyone done recent benchmarks to compare threading libraries? I'm just wondering why don't you go for MySQL 5.0.27 with libthr instead of using linuxthreads? MySQL 5.0.x with libthr runs faster than 4.1.x. http://wikitest.freebsd.org/MySQL -- Regards, -Abdullah Ibn Hamad Al-Marri Arab Portal http://www.WeArab.Net/ From owner-freebsd-threads@FreeBSD.ORG Mon Jan 22 11:08:51 2007 Return-Path: X-Original-To: freebsd-threads@FreeBSD.org Delivered-To: freebsd-threads@FreeBSD.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id F11D216A66D for ; Mon, 22 Jan 2007 11:08:51 +0000 (UTC) (envelope-from owner-bugmaster@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [69.147.83.40]) by mx1.freebsd.org (Postfix) with ESMTP id D3C9113C461 for ; Mon, 22 Jan 2007 11:08:51 +0000 (UTC) (envelope-from owner-bugmaster@FreeBSD.org) Received: from freefall.freebsd.org (linimon@localhost [127.0.0.1]) by freefall.freebsd.org (8.13.4/8.13.4) with ESMTP id l0MB8pvR037098 for ; Mon, 22 Jan 2007 11:08:51 GMT (envelope-from owner-bugmaster@FreeBSD.org) Received: (from linimon@localhost) by freefall.freebsd.org (8.13.4/8.13.4/Submit) id l0MB8ogb037094 for freebsd-threads@FreeBSD.org; Mon, 22 Jan 2007 11:08:50 GMT (envelope-from owner-bugmaster@FreeBSD.org) Date: Mon, 22 Jan 2007 11:08:50 GMT Message-Id: <200701221108.l0MB8ogb037094@freefall.freebsd.org> X-Authentication-Warning: freefall.freebsd.org: linimon set sender to owner-bugmaster@FreeBSD.org using -f From: FreeBSD bugmaster To: freebsd-threads@FreeBSD.org Cc: Subject: Current problem reports assigned to you X-BeenThere: freebsd-threads@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 22 Jan 2007 11:08:52 -0000 Current FreeBSD problem reports Critical problems S Tracker Resp. Description -------------------------------------------------------------------------------- s threa/76690 threads fork hang in child for -lc_r 1 problem total. Serious problems S Tracker Resp. Description -------------------------------------------------------------------------------- o kern/20016 threads pthreads: Cannot set scheduling timer/Cannot set virtu s threa/24472 threads libc_r does not honor SO_SNDTIMEO/SO_RCVTIMEO socket o s threa/24632 threads libc_r delicate deviation from libc in handling SIGCHL s bin/32295 threads pthread dont dequeue signals s threa/34536 threads accept() blocks other threads o kern/38549 threads the procces compiled whith pthread stopped in pthread_ s threa/39922 threads [threads] [patch] Threaded applications executed with s threa/48856 threads Setting SIGCHLD to SIG_IGN still leaves zombies under s threa/49087 threads Signals lost in programs linked with libc_r s kern/64313 threads FreeBSD (OpenBSD) pthread implicit set/unset O_NONBLOC o threa/70975 threads unexpected and unreliable behaviour when using SYSV se o threa/72353 threads Assertion fails in /usr/src/lib/libpthread/sys/lock.c, o threa/72429 threads threads blocked in stdio (fgets, etc) are not cancella o threa/72953 threads fork() unblocks blocked signals w/o PTHREAD_SCOPE_SYST o threa/75273 threads FBSD 5.3 libpthread (KSE) bug o threa/75374 threads pthread_kill() ignores SA_SIGINFO flag s threa/76694 threads fork cause hang in dup()/close() function in child (-l o threa/79683 threads svctcp_create() fails if multiple threads call at the o threa/80435 threads panic on high loads o threa/83914 threads [libc] popen() doesn't work in static threaded program s threa/84483 threads problems with devel/nspr and -lc_r on 4.x o threa/85160 threads [libthr] [patch] libobjc + libpthread/libthr crash pro o threa/90278 threads libthr, ULE and -current produces >100% WCPU with apac o kern/91266 threads [threads] Trying sleep, but thread marked as sleeping s threa/94467 threads send(), sendto() and sendmsg() are not correct in libc f threa/98256 threads gnome-system-monitor core dumps from pthread_testcance s threa/100815 threads FBSD 5.5 broke nanosleep in libc_r o threa/101323 threads fork(2) in threaded programs broken. o threa/103975 threads Implicit loading/unloading of libpthread.so may crash 29 problems total. Non-critical problems S Tracker Resp. Description -------------------------------------------------------------------------------- s kern/19247 threads uthread_sigaction.c does not do anything wrt SA_NOCLDW s kern/22190 threads A threaded read(2) from a socketpair(2) fd can sometim s threa/30464 threads pthread mutex attributes -- pshared s threa/37676 threads libc_r: msgsnd(), msgrcv(), pread(), pwrite() need wra s threa/40671 threads pthread_cancel doesn't remove thread from condition qu s threa/69020 threads pthreads library leaks _gc_mutex o threa/79887 threads [patch] freopen() isn't thread-safe o threa/80992 threads abort() sometimes not caught by gdb depending on threa o threa/81534 threads [libc_r] [patch] libc_r close() will fail on any fd ty 9 problems total. From owner-freebsd-threads@FreeBSD.ORG Mon Jan 22 14:51:22 2007 Return-Path: X-Original-To: threads@freebsd.org Delivered-To: freebsd-threads@FreeBSD.ORG Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 0C06D16A400 for ; Mon, 22 Jan 2007 14:51:22 +0000 (UTC) (envelope-from gordon_s_smith@hotmail.com) Received: from bay0-omc2-s3.bay0.hotmail.com (bay0-omc2-s3.bay0.hotmail.com [65.54.246.139]) by mx1.freebsd.org (Postfix) with ESMTP id EC6B413C474 for ; Mon, 22 Jan 2007 14:51:21 +0000 (UTC) (envelope-from gordon_s_smith@hotmail.com) Received: from hotmail.com ([65.55.138.105]) by bay0-omc2-s3.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Mon, 22 Jan 2007 06:51:22 -0800 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 22 Jan 2007 06:51:21 -0800 Message-ID: Received: from 65.55.138.123 by by133fd.bay133.hotmail.msn.com with HTTP; Mon, 22 Jan 2007 14:51:18 GMT X-Originating-IP: [68.192.174.20] X-Originating-Email: [gordon_s_smith@hotmail.com] X-Sender: gordon_s_smith@hotmail.com From: "Gordon Smith" To: threads@freebsd.org Date: Mon, 22 Jan 2007 09:51:18 -0500 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 22 Jan 2007 14:51:21.0572 (UTC) FILETIME=[C7DD0240:01C73E34] Cc: Subject: Recommended MySQL 4.1 Installation X-BeenThere: freebsd-threads@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 22 Jan 2007 14:51:22 -0000 Now that FreeBSD 6.2 is out, can anyone recommend specific configurations for FBSD and MySQL V.4.1 that deliver a really stable and fast (emphasizing stable) DB platform on 6.2? In the absence of such, info about 6.1 would also be greatly appreciated. Would I need to compile a specific threading library into FreeBSD to avoid panics or other problems that may occur under high load? I'm happy to RTFM on this. The last really good info I remember seeing about this (specifically about FBSD and MySQL) was from: - Jeremy Zawodny's blog entry http://jeremy.zawodny.com/blog/archives/000697.html - the mysql.com doc page http://dev.mysql.com/doc/refman/4.1/en/freebsd.html I would be willing to sacrifice some reasonable degree of performance for stability (if needed), so I want to be careful here. Running the Linux compatability layer is an option, if needed - I'm not sure if the Linux compatability layer is needed to support Linux threads (if Linux threads are the best choice of threading library to use with MySQL). Has anyone done recent benchmarks to compare threading libraries? Anyone have any contacts in MySQL AG that might be able provide suggestions? If I've missed some obvious documentation, I apologize in advance. Thank you. Gordon Smith From owner-freebsd-threads@FreeBSD.ORG Mon Jan 22 14:57:48 2007 Return-Path: X-Original-To: threads@freebsd.org Delivered-To: freebsd-threads@FreeBSD.ORG Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id BCAFF16A400 for ; Mon, 22 Jan 2007 14:57:48 +0000 (UTC) (envelope-from gordon_s_smith@hotmail.com) Received: from bay0-omc2-s16.bay0.hotmail.com (bay0-omc2-s16.bay0.hotmail.com [65.54.246.152]) by mx1.freebsd.org (Postfix) with ESMTP id A802213C45D for ; Mon, 22 Jan 2007 14:57:48 +0000 (UTC) (envelope-from gordon_s_smith@hotmail.com) Received: from hotmail.com ([65.55.138.117]) by bay0-omc2-s16.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Mon, 22 Jan 2007 06:57:49 -0800 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 22 Jan 2007 06:57:47 -0800 Message-ID: Received: from 65.55.138.123 by by133fd.bay133.hotmail.msn.com with HTTP; Mon, 22 Jan 2007 14:57:47 GMT X-Originating-IP: [68.192.174.20] X-Originating-Email: [gordon_s_smith@hotmail.com] X-Sender: gordon_s_smith@hotmail.com In-Reply-To: <499c70c0701220015m49d09cc0s95e2c165197d0478@mail.gmail.com> From: "Gordon Smith" To: almarrie@gmail.com Date: Mon, 22 Jan 2007 09:57:47 -0500 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 22 Jan 2007 14:57:47.0883 (UTC) FILETIME=[AE1F63B0:01C73E35] Cc: threads@freebsd.org Subject: Re: Recommended MySQL 4.1 Installation X-BeenThere: freebsd-threads@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Threading on FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 22 Jan 2007 14:57:48 -0000 Abdullah, Thanks for the feedback. The reason (at the moment) is that some of the application code to be implemented in FBSD uses outer join queries, which are executed differently under 4.1 and 5.0. It looks like MySQL changed their outer join implementation for 5.0 to make it comply with an ANSI standard, so until the app code is changed and thoroughly tested the DB needs to stay at 4.1... unless someone is aware of a MySQL switch that will let us toggle between the old and new outer join behavior (sorry, that question is probably outside the scope of this list...). Gordon ----Original Message Follows---- From: "Abdullah Al-Marrie" To: "Gordon Smith" CC: threads@freebsd.org Subject: Re: Recommended MySQL 4.1 Installation Date: Mon, 22 Jan 2007 11:15:05 +0300 On 1/19/07, Gordon Smith wrote: >Now that FreeBSD 6.2 is out, can anyone recommend specific configurations >for FBSD and MySQL V.4.1 that deliver a really stable and fast (emphasizing >stable) DB platform on 6.2? In the absence of such, info about 6.1 would >also be greatly appreciated. > >Would I need to compile a specific threading library into FreeBSD to avoid >panics or other problems that may occur under high load? > >I'm happy to RTFM on this. The last really good info I remember seeing >about this (specifically about FBSD and MySQL) was from: >- Jeremy Zawodny's blog entry > http://jeremy.zawodny.com/blog/archives/000697.html >- the mysql.com doc page > http://dev.mysql.com/doc/refman/4.1/en/freebsd.html > >I would be willing to sacrifice some reasonable degree of performance for >stability (if needed), so I want to be careful here. Running the Linux >compatability layer is an option, if needed - I'm not sure if the Linux >compatability layer is needed to support Linux threads (if Linux threads >are >the best choice of threading library to use with MySQL). > >Has anyone done recent benchmarks to compare threading libraries? I'm just wondering why don't you go for MySQL 5.0.27 with libthr instead of using linuxthreads? MySQL 5.0.x with libthr runs faster than 4.1.x. http://wikitest.freebsd.org/MySQL -- Regards, -Abdullah Ibn Hamad Al-Marri Arab Portal http://www.WeArab.Net/