From owner-freebsd-database Tue Nov 21 10:27:48 2000 Delivered-To: freebsd-database@freebsd.org Received: from sampnt500.avantgo.com (unknown [209.220.59.68]) by hub.freebsd.org (Postfix) with ESMTP id 4756437B479 for ; Tue, 21 Nov 2000 10:27:46 -0800 (PST) Received: by sampnt500.avantgo.com with Internet Mail Service (5.5.2650.21) id ; Tue, 21 Nov 2000 10:28:38 -0800 Received: from river.avantgo.com ([10.1.30.114]) by sampnt500.avantgo.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2650.21) id W0LZ2X14; Tue, 21 Nov 2000 10:28:27 -0800 From: Scott Hess To: The Hermit Hacker Cc: Filip Hanik , freebsd-database@FreeBSD.ORG Date: Tue, 21 Nov 2000 10:32:29 -0800 (PST) Subject: Re: PostgreSQL: Which is Better for MySQL FreeBSD or BSDi? In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG 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