From owner-freebsd-questions  Tue Dec 21 16:37:38 1999
Delivered-To: freebsd-questions@freebsd.org
Received: from mail.alpha.net.au (mail2.alpha.net.au [203.41.44.8])
	by hub.freebsd.org (Postfix) with ESMTP
	id 717C114A20; Tue, 21 Dec 1999 16:37:35 -0800 (PST)
	(envelope-from dannyh@idx.com.au)
Received: from psych ([203.41.44.247])
	by mail.alpha.net.au (8.9.3/8.9.3) with SMTP id LAA12194;
	Wed, 22 Dec 1999 11:37:56 +1100
Message-Id: <3.0.32.19991222113831.006eccd8@idx.com.au>
X-Sender: dannyh@idx.com.au
X-Mailer: Windows Eudora Pro Version 3.0 (32)
Date: Wed, 22 Dec 1999 11:38:37 +1100
To: scott <scott@chronis.pobox.com>, freebsd-questions@FreeBSD.ORG
From: Danny <dannyh@idx.com.au>
Subject: Re: mysql server: how to optimize
Cc: dirk@FreeBSD.ORG
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Sender: owner-freebsd-questions@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.ORG

To get a better understanding of mysql what version of mysql are you running?

At 18:23 21/12/99 -0500, scott wrote:
>I tried running a mysql server on a freebsd box that was handling
>approx 15 queries per second accross 75-100 connections, and it nearly
>blew up :)  The cpu it was using was at nearly 100% all the while.
>This was on a PII 450.  Now, I've got the same load running on an
>older P166 with linux, and it uses much less of that cpu.
>
>Is this an issue with how freebsd does threads?  If so, will using the
>mit-pthreads that come with mysql help?  what are the drawbacks of
>that?
>
>Thanks in advance for anyone who can shed some light on the situation.
>
>scott
>
>
>
>To Unsubscribe: send mail to majordomo@FreeBSD.org
>with "unsubscribe freebsd-questions" in the body of the message
>


To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message