From owner-freebsd-database Mon Nov 20 14:19:35 2000 Delivered-To: freebsd-database@freebsd.org Received: from thelab.hub.org (CDR22-173.accesscable.net [24.138.22.173]) by hub.freebsd.org (Postfix) with ESMTP id C9D7937B479 for ; Mon, 20 Nov 2000 14:19:30 -0800 (PST) Received: from localhost (scrappy@localhost) by thelab.hub.org (8.11.1/8.11.1) with ESMTP id eAKMJ6V14637; Mon, 20 Nov 2000 18:19:06 -0400 (AST) (envelope-from scrappy@hub.org) X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs Date: Mon, 20 Nov 2000 18:19:06 -0400 (AST) From: The Hermit Hacker To: Filip Hanik Cc: freebsd-database@FreeBSD.ORG Subject: Re: PostgreSQL: Which is Better for MySQL FreeBSD or BSDi? In-Reply-To: <002401c0532b$22b65e10$ef97c93f@pakana.com> 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, Filip Hanik wrote: > Any thoughts on PostgreSQL? Not sure what you are looking for here ... Tim Perdue @ PHPBuilder found that they hit scalability issues with MySQL, and is switching to either PgSQL or Oracle ... last I heard, PgSQL won out, but don't quote me on that ... He wrote an article on it available at the following URL: http://www.phpbuilder.com/columns/tim20001112.php3 Basically, they found that once you hit ~5 simultaneous connections, performance of MySQL nose-dived, whereas the same test on PgSQL peaked and flattened out ... 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 :( > Filip Hanik > Technical Architect > Pakana Corporation > fhanik@pakana.com > 415-371 9200 ext 3529 > > > -----Original Message----- > From: owner-freebsd-database@FreeBSD.ORG > [mailto:owner-freebsd-database@FreeBSD.ORG]On Behalf Of Tom Samplonius > Sent: Wednesday, November 15, 2000 8:29 PM > To: Nicole Harrington > Cc: freebsd-database@freebsd.org > Subject: Re: Which is Better for MySQL FreeBSD or BSDi? > > > > On Wed, 15 Nov 2000, Nicole Harrington wrote: > > > Well in the hope that this list is not dead... > > > > My question> for running MySql, which would be better, FreeBSD or BSDi? > > > > I Thought I had heard that BSDi would be better. > > > > Any opinions, thoughts? > > > > > > Nicole > > I think FreeBSD is better supported by MySQL. However, you should > probably direct this to the MySQL developers. > > I have a 2GB MySQL database under FreeBSD 3.x. It works ok. MySQL's > table-locking stinks, but that isn't an OS issue. If I was going to start > again, I wouldn't use MySQL because of the table-locking issues. > > Tom > > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-database" in the body of the message > > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-database" in the body of the message > > Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message