From owner-freebsd-questions Tue Dec 21 16:53:31 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 91EC914A2B for ; Tue, 21 Dec 1999 16:53:26 -0800 (PST) (envelope-from scott@chronis.pobox.com) Received: by chronis.pobox.com (Postfix, from userid 1001) id 452159B1B; Tue, 21 Dec 1999 19:53:25 -0500 (EST) Date: Tue, 21 Dec 1999 19:53:25 -0500 From: scott To: freebsd-questions@FreeBSD.ORG Subject: Re: mysql server: how to optimize Message-ID: <19991221195325.A11455@chronis.pobox.com> Mail-Followup-To: freebsd-questions@FreeBSD.ORG References: <19991221182333.A11071@chronis.pobox.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.7i In-Reply-To: Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG If it weren't indexed properly, how would it run so much more smoothly under linux with so much less cpu? The indices are fine, individual lookups are virtally instantaneous, except when there are a lot of concurrent threads doing a lot of queries. scott On Tue, Dec 21, 1999 at 04:29:19PM -0800, Ian Struble wrote: > It sounds like you might not have anything indexed. I just worked on > a mysql database that was pegging the machine. The database didn't have > a single field indexed. Throwing a few well placed indexes helped alot. > > Ian > > On Tue, 21 Dec 1999, 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