X-Original-To: pgsql-advocacy-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id F2243D1B4B5 for ; Tue, 3 Feb 2004 16:52:27 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 14883-03 for ; Tue, 3 Feb 2004 12:52:20 -0400 (AST) Received: from jefftrout.com (h00a0cc4084e5.ne.client2.attbi.com [24.128.241.68]) by svr1.postgresql.org (Postfix) with SMTP id 50FFCD1D2DB for ; Tue, 3 Feb 2004 12:52:17 -0400 (AST) Received: (qmail 34884 invoked from network); 3 Feb 2004 16:52:20 -0000 Received: from localhost (HELO squeegit) (threshar@127.0.0.1) by localhost with SMTP; 3 Feb 2004 16:52:20 -0000 Date: Tue, 3 Feb 2004 11:55:02 -0500 From: Jeff To: Tom Lane Cc: rigmor.ukuhe@finestmedia.com, josh@agliodbs.com, pgsql-advocacy@postgresql.org, pgsql-performance@postgresql.org Subject: Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test? Message-Id: <20040203115502.51820b31.threshar@torgo.978.org> In-Reply-To: <19175.1075826765@sss.pgh.pa.us> References: <20040203085203.5c5f926c.threshar@torgo.978.org> <20040203105349.2f700477.threshar@torgo.978.org> <19175.1075826765@sss.pgh.pa.us> X-Mailer: Sylpheed version 0.9.9 (GTK+ 1.2.10; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/20 X-Sequence-Number: 3591 On Tue, 03 Feb 2004 11:46:05 -0500 Tom Lane wrote: > Jeff writes: > > Not sure at what point it will topple, in my case it didn't matter > > if it ran good with 5 clients as I'll always have many more clients > > than 5. > > I did some idle, very unscientific tests the other day that indicated > that MySQL insert performance starts to suck with just 2 concurrent > inserters. Given a file containing 10000 INSERT commands, a single > mysql client ran the file in about a second. So if I feed the file > simultaneously to two mysqls in two shell windows, it should take > about two seconds total to do the 20000 inserts, right? The observed > times were 13 to 15 seconds. (I believe this is with a MyISAM table, > since I just said CREATE TABLE without any options.) > MyISAM is well known to suck if you update/insert/delete because it simply aquires a full table lock when you perform those operations! InnoDB is supposed to be better at that. So your results are fairly in line with what you should see. -- Jeff Trout http://www.jefftrout.com/ http://www.stuarthamm.net/