pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jeff <threshar@torgo.978.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: rigmor.ukuhe@finestmedia.com
Cc: josh@agliodbs.com
Cc: pgsql-advocacy@postgresql.org
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?
Date: Tue, 3 Feb 2004 11:55:02 -0500
Message-ID: <20040203115502.51820b31.threshar@torgo.978.org> (raw)
In-Reply-To: <19175.1075826765@sss.pgh.pa.us>
References: <20040203085203.5c5f926c.threshar@torgo.978.org>
	<OEEHLFAIJHHMABJPIANIGECICIAA.rigmor.ukuhe@finestmedia.com>
	<20040203105349.2f700477.threshar@torgo.978.org>
	<19175.1075826765@sss.pgh.pa.us>

On Tue, 03 Feb 2004 11:46:05 -0500
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Jeff <threshar@torgo.978.org> 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 <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/



view thread (27+ messages)  latest in thread

Message-ID: <20040203115502.51820b31.threshar@torgo.978.org>
Permalink:  ../20040203115502.51820b31.threshar@torgo.978.org/
Also on:    postgresql.org/message-id/20040203115502.51820b31.threshar@torgo.978.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: threshar@torgo.978.org, tgl@sss.pgh.pa.us, rigmor.ukuhe@finestmedia.com, josh@agliodbs.com, pgsql-advocacy@postgresql.org
  Subject: Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?
  In-Reply-To: <20040203115502.51820b31.threshar@torgo.978.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox