From owner-freebsd-questions  Tue Dec 21 15:23:36 1999
Delivered-To: freebsd-questions@freebsd.org
Received: from chronis.pobox.com (chronis.pobox.com [208.210.124.49])
	by hub.freebsd.org (Postfix) with ESMTP
	id AD603150E6; Tue, 21 Dec 1999 15:23:34 -0800 (PST)
	(envelope-from scott@chronis.pobox.com)
Received: by chronis.pobox.com (Postfix, from userid 1001)
	id CC5D29B1B; Tue, 21 Dec 1999 18:23:33 -0500 (EST)
Date: Tue, 21 Dec 1999 18:23:33 -0500
From: scott <scott@chronis.pobox.com>
To: freebsd-questions@freebsd.org
Cc: dirk@freebsd.org
Subject: mysql server: how to optimize
Message-ID: <19991221182333.A11071@chronis.pobox.com>
Mail-Followup-To: freebsd-questions@freebsd.org, dirk@freebsd.org
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Mailer: Mutt 0.95.7i
Sender: owner-freebsd-questions@FreeBSD.ORG
Precedence: bulk
X-Loop: FreeBSD.ORG

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