From owner-freebsd-questions@FreeBSD.ORG  Thu Aug  3 19:36:13 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@freebsd.org
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id A89C516A4DD
	for <freebsd-questions@freebsd.org>;
	Thu,  3 Aug 2006 19:36:13 +0000 (UTC)
	(envelope-from usleepless@gmail.com)
Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.238])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 31FAD43D53
	for <freebsd-questions@freebsd.org>;
	Thu,  3 Aug 2006 19:36:12 +0000 (GMT)
	(envelope-from usleepless@gmail.com)
Received: by wr-out-0506.google.com with SMTP id 70so103977wra
	for <freebsd-questions@freebsd.org>;
	Thu, 03 Aug 2006 12:36:11 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=D0h24jHreWVTF+CaBzW8slc5D5V10xsBJfmF0UTLWKKiJddbxgeNTUWceIgvgx7NdDCGDc0KyRxbzr/cLErUpvEyecYC/TpV8Vnx9Xlezr6cy9qyMmvPgKGu6+3gOOa6jjSmGgKV3sb8mgAd4aAhZD1b2U2CTrBiyUh/WcQ0mV0=
Received: by 10.78.165.13 with SMTP id n13mr1003768hue;
	Thu, 03 Aug 2006 12:36:09 -0700 (PDT)
Received: by 10.78.166.18 with HTTP; Thu, 3 Aug 2006 12:36:09 -0700 (PDT)
Message-ID: <c39ec84c0608031236y5edd061bh97634e80c1b0e2f2@mail.gmail.com>
Date: Thu, 3 Aug 2006 21:36:09 +0200
From: usleepless@gmail.com
To: "Richard Morse" <remorse@partners.org>
In-Reply-To: <1E8F77CE-AC74-4C24-89DC-89201CD4E113@partners.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <31F1465C-5B87-4B79-8D58-0A538BF30562@partners.org>
	<D1FBD2B5-CEB6-479B-8254-497E199462CF@partners.org>
	<80f4f2b20608020636o3dd712c9vf1aad9b6f3ba6e6f@mail.gmail.com>
	<B4660167-78AB-4A4D-AF7C-9AD258185E7C@partners.org>
	<80f4f2b20608020700l53410a09u6efb90aadb6294cb@mail.gmail.com>
	<1E8F77CE-AC74-4C24-89DC-89201CD4E113@partners.org>
Cc: freebsd-questions@freebsd.org
Subject: Re: Problems with MySQL since upgrade
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 03 Aug 2006 19:36:13 -0000

Dear Ricky,

On 8/2/06, Richard Morse <remorse@partners.org> wrote:
> No, they were all normal (the latter two were 0, the first was about
> 110).  FWIW, the query usually proceeds normally; it's only when it
> doesn't that things go bad.
>
> I'm wondering if this is a problem with threads -- I've been doing
> research, and a number of places say that there are threading issues
> on FreeBSD 5 with MySQL thread when using the standard threading
> library.  I'm going to recompile MySQL with the linuxpthreads option,
> and see if that stops this...

i understand if this is of no use to you, but: switch to PostgreSQL as
soon as you can. MySQL has given me nothing but trouble, especially on
FBSD ( threads ).

PGSQL is more complete, and faster on harder queries.

regards,

usleep