Re: MySQL/InnoDB benchmarks

On Thu, 2002-02-21 at 11:00, Tom Lane wrote:

"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:

Now, the InnoDB guys have done some benchmarks:

If I did some benchmarks comparing Postgres and MySQL, and they came out
in favor of PG, I'm sure the MySQL guys would cry foul --- and with good
reason, seeing that I have no clue how to configure MySQL optimally.
But we are supposed to consider their tests to be unbiased? Get real.

Still they show the theoretical possibility of speeding up these two
features:

INSERT INTO ... SELECT FROM - seems we have still room for improving
btree inserts - I did the same tests with my desktop pc (RH7.1, PG 7.2,
default conf) and got 4.83sec with primary key on T2 and 1.17 without.
INSERT + CREATE UNIQUE INDEX took 4.56 sec.

SELECT SUM(T1.B) FROM T1, T2 WHERE T1.A = T2.B - Most likely InnoDB can
do this from index only for T2. I guess it would be possible for PG to
at least cache tmin and tmax for index tuples in memory, if not on disk.

What really needs to be done here is a set of tests designed and
conducted by an *impartial* third party, with advice from experts in
each camp on how to properly configure their own DB. I haven't seen
any prospects for such a thing to happen, though. In the meantime,
I put no credence in MySQL-sponsored benchmarks, and I see no reason
for us to spend time generating our own equally-not-unbiased responses.

It could be educating to run something simple like pgbench on both.

--------------
Hannu