>>>>> "Suresh" == Suresh Rajagopalan <sraja@stripped> writes:
Suresh> Hi;
Suresh> Comparing the benchmark results I have got from a P450/Linux 2.2.5 box vs
Suresh> the one supplied by Monty, I find that the insert test is much slower.
Suresh> All other tests compare well.
Suresh> I've tried both my compiled version (using the Pentium optimized settings)
Suresh> and also the binary RPM from the distribution.
Suresh> I'm not sure if the slowness can be attributed to 1 less CPU and the
Suresh> lesser amount of RAM. The machine I used had a SCSI disk.
Suresh> In both cases, logging was turned off and debug was *not* compiled in.
Suresh> key_buffer was set to 16m in both tests.
Suresh> Thanks for any pointers.
Suresh> Suresh
Suresh> ------------------------------------------------------------
Suresh> The result logs which where found and the options:
Suresh> 1 mysql-Linux-2.2.5_450Mhz, : MySQL3.22.21
Suresh> PIII 450 1 CPU 128M key_buffer=16m static compiled, egcs 1.1.2, SCSI
Suresh> 2 mysql-Linux-2.2.5_450Mhz_binary_RPM : MySQL 3.22.21
Suresh> PIII 450 1 CPU 128M key_buffer=16m binary RPM, SCSI
Suresh> 3 mysql-Linux_2.2.1_i686 : MySQL 3.22.18
Suresh> pentiumpro 400mz x2, 256M, SCSI, gcc 2.9 compiled, key_buffer=16M
<cut>
Suresh> insert_key (100000) | 1948| 1317| 156|
Hi!
The insert_key() tests insert 100000 rows in a table with 16 simply
keys and one key 16 key parts. This creates a table which uses about
50M disk space. In this case the extra 128M memory in my machine is
probably the reason for the speed difference.
Regards,
Monty
