Date: Tue, 21 Dec 1999 16:29:19 -0800 (PST) From: Ian Struble <ian@broken.net> To: scott <scott@chronis.pobox.com> Cc: freebsd-questions@FreeBSD.ORG, dirk@FreeBSD.ORG Subject: Re: mysql server: how to optimize Message-ID: <Pine.BSF.3.91.991221162441.23637c-100000@disavowed.broken.net> In-Reply-To: <19991221182333.A11071@chronis.pobox.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.3.91.991221162441.23637c-100000>