| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jeff <threshar(at)torgo(dot)978(dot)org> |
| Cc: | "Rigmor Ukuhe" <rigmor(dot)ukuhe(at)finestmedia(dot)com>, josh(at)agliodbs(dot)com, pgsql-advocacy(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test? |
| Date: | 2004-02-03 16:46:05 |
| Message-ID: | 19175.1075826765@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy pgsql-performance |
Jeff <threshar(at)torgo(dot)978(dot)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.)
It does scream with only one client though ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff | 2004-02-03 16:55:02 | Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test? |
| Previous Message | Bruce Momjian | 2004-02-03 16:25:05 | Re: Only SEVEN DAYS Until OSCON Deadline! |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff | 2004-02-03 16:55:02 | Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test? |
| Previous Message | Kevin Carpenter | 2004-02-03 16:42:59 | Database conversion woes... |