Re: MySQL million tables

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all,

I dont think this kind of test could have any meaning, given that table
creation time doesnt import in any way.

... but I was curious, so I made the test :)

>>Also, can we beat his estimate of 27 hours for creation?

We would need his complete machine specs to be sure we can beat him.

> for i in `seq 1 1000000`;
> do
> echo "create table test$i (ts timestamp);"|psql tabletorture;
> done

Just tried that script (still running) on a Dell PowerEdge 2800 (not my
prefered, but only one I could use for that test...)

2 physical CPUS in ht:  Intel(R) Xeon(TM) CPU 3.00GHz with 2m cache
2Gb ram

Builtin Perc4, with Raid 5 and 5+1 10Krpm disks

Linux ***** 2.4.27-2-686-smp #1 SMP Wed Aug 17 10:05:21 UTC 2005 i686
GNU/Linux

I can send more details if you want (postgresql.conf..)

> Now I got ~2600 tables in 4 minutes, so it might take a day to get the
> million. However, the MySQL-guy has no statements about his
> test-machine, so it's not comparable.

I got a rate of 12 tables created per second (fluctuating from 10 to 13
so thats an approximation I do, Ill get final results on the end).

So at the moment I'll have 1M table in about 23 hours on that server.

I'll send complete results when it will be finished.

- --
Jean-Paul Argudo
www.PostgreSQLFr.org
www.dalibo.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFED+9anDfYiZOkHKQRAgkSAJ0SUM5GfouYbushribtHPzGtfWBPQCffWNc
4vwrAr9z8p+8AAqL2ndFlP4=
=bX5g
-----END PGP SIGNATURE-----