Skip site navigation (1) Skip section navigation (2)

Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?

From: "Rigmor Ukuhe" <rigmor(dot)ukuhe(at)finestmedia(dot)com>
To: "Jeff" <threshar(at)torgo(dot)978(dot)org>, <josh(at)agliodbs(dot)com>
Cc: <pgsql-advocacy(at)postgresql(dot)org>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?
Date: 2004-02-03 14:02:00
Message-ID: OEEHLFAIJHHMABJPIANIGECICIAA.rigmor.ukuhe@finestmedia.com (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-performance
> script [I also decided to use this perl script for testing PG to be
> fair].
>
> For one client mysql simply screamed.
>

If already have test case set up, you could inform us, from where Postgres
starts to beat MySql. Because if with 5 clients it still "screams" then i
would give it a try in case of that kind of requirements.

Rigmor Ukuhe

> Then I decided to see what happens with 20 clients.
>
> MySQL clocked in at 650 seconds.  During this time the machine was VERY
> unresponsive.  To be fair, that could be Linux, not MySQL.
>
> PG (7.3.4) clocked in at 220 seconds.  The machine was perfectly fine
> during the test -  nice and responsive.
>
> The hardware wasn't much - dual p2-450 running stock RH8. (2x15k 18g
> scsi drives for the data volume)
>
> Then I decided to try the "beloved" InnoDB.
>
> Well.. after it sat for a few hours at 100% cpu loading the data I
> killed it off and gave up on InnoDB.. I am interested in the numbers.
> Perhaps I'll fire it up again someday and let it finish loading.
>
> Remember -  you cannot judge mysql by since connection performance - you
> can't beat it.  But just add up the concurrency and watch the cookies
> tumble
>
> --
> Jeff Trout <jeff(at)jefftrout(dot)com>
> http://www.jefftrout.com/
> http://www.stuarthamm.net/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.564 / Virus Database: 356 - Release Date: 19.01.2004
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.564 / Virus Database: 356 - Release Date: 19.01.2004


In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2004-02-03 14:53:13
Subject: Re: PQexecParams and types
Previous:From: JeffDate: 2004-02-03 13:52:03
Subject: Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?

pgsql-advocacy by date

Next:From: JeffDate: 2004-02-03 15:53:49
Subject: Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?
Previous:From: JeffDate: 2004-02-03 13:52:03
Subject: Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group