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/