Date: Tue, 21 Nov 2000 10:32:29 -0800 (PST) From: Scott Hess <scott@avantgo.com> To: The Hermit Hacker <scrappy@hub.org> Cc: Filip Hanik <fhanik@pakana.com>, freebsd-database@FreeBSD.ORG Subject: Re: PostgreSQL: Which is Better for MySQL FreeBSD or BSDi? Message-ID: <Pine.LNX.4.21.0011211011160.16898-100000@river.avantgo.com> In-Reply-To: <Pine.BSF.4.21.0011201814280.10727-100000@thelab.hub.org>
next in thread | previous in thread | raw e-mail | index | archive | help
On Mon, 20 Nov 2000, The Hermit Hacker wrote: > My theory is that in most cases where MySQL users are talking about how > well it performs, they are dealing with very low hit sites where the > database isn't having to deal with heavy traffic, so its more an 'SQL > over flatfile' situation :( I know of at least one high-volume site running MySQL on FreeBSD... it did require a fair bit of tuning, such as moving most blobs out of MySQL and into a simple external solution. Also, we run with multiple mysqld against the same tables, because FreeBSD3.x's pthread library is suboptimal for apps with heavy disk I/O (disk I/O's are always ready, and userland pthreads rely heavily on non-blocking I/O working). During peak times, we have well over 1000 db connections on a single box, split across 8 mysqld. Not all connections are running a query at any give time, of course, but certainly more than 5 :-). Later, scott To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.LNX.4.21.0011211011160.16898-100000>