From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jeff <threshar@torgo.978.org>
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, 03 Feb 2004 12:03:11 -0500
Message-ID: <19418.1075827791@sss.pgh.pa.us> (raw)
In-Reply-To: <20040203115502.51820b31.threshar@torgo.978.org>
References: <20040203085203.5c5f926c.threshar@torgo.978.org>
<OEEHLFAIJHHMABJPIANIGECICIAA.rigmor.ukuhe@finestmedia.com>
<20040203105349.2f700477.threshar@torgo.978.org>
<19175.1075826765@sss.pgh.pa.us>
<20040203115502.51820b31.threshar@torgo.978.org>
Jeff <threshar@torgo.978.org> writes:
> On Tue, 03 Feb 2004 11:46:05 -0500
> Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> 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!
Sure, I wasn't expecting it to actually overlap any operations. (If you
try the same test with Postgres, the scaling factor is a little better
than linear because we do get some overlap.) But that shouldn't result
in a factor-of-seven slowdown. There's something badly wrong with their
low-level locking algorithms I think.
regards, tom lane
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: tgl@sss.pgh.pa.us, threshar@torgo.978.org, rigmor.ukuhe@finestmedia.com, josh@agliodbs.com, pgsql-advocacy@postgresql.org
Subject: Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?
In-Reply-To: <19418.1075827791@sss.pgh.pa.us>
* 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