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