From owner-freebsd-questions Tue Dec 21 16:29:27 1999 Delivered-To: freebsd-questions@freebsd.org Received: from disavowed.broken.net (disavowed.broken.net [204.216.142.33]) by hub.freebsd.org (Postfix) with ESMTP id 48D2E1501A; Tue, 21 Dec 1999 16:29:26 -0800 (PST) (envelope-from ian@disavowed.broken.net) Received: (from ian@localhost) by disavowed.broken.net (8.8.7/8.8.7) id QAA27527; Tue, 21 Dec 1999 16:29:19 -0800 (PST) Date: Tue, 21 Dec 1999 16:29:19 -0800 (PST) From: Ian Struble To: scott Cc: freebsd-questions@FreeBSD.ORG, dirk@FreeBSD.ORG Subject: Re: mysql server: how to optimize In-Reply-To: <19991221182333.A11071@chronis.pobox.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG 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