Hello
I've compiled mysql-3.23.35 with innobase support - it runs much
better than BDB for me - and run a simple benchmark with the
following script:
use DBI;
my $DB= DBI->connect("dbi:mysql:innobase","chris",shift) or die;
$DB->{RaiseError}=1;
$DB->do("drop table if exists speedtest");
$DB->do("create table speedtest (a int not null primary key, b int
not null) type=innobase");
$DB->do("set autocommit=0"); # or =1
my $ins=$DB->prepare("insert into speedtest values(?,?)");
foreach (0..1000) {
eval {
$ins->execute(int(rand(10000000)),int(rand(100000)) );
};
if ($@) {warn $@} else {$done++}
}
# $DB->do("commit"); # uncommented for some test
print "have inserted $done entries\n";
On a lightly loaded powermac G3 running linuxppc I get the following results:
myisam table: 2000 inserts/sec.
innobase table:
autocommit=0, rollback after each insert: 59 insert+rollback/sec.
autocommit=0, one rollback at the end: 2926 inserts/sec.
autocommit=0, one commit at the end: 2763 inserts/sec.
autocommit=1: 34 inserts/sec.
In the last case I can hear the head from the hard disk vibrating, it
seems that innobase synches each commit through to the disk oxide.
I'm sure innobase isn't the fastest database in the world if this is
true for everyone. Why could this be the case for me?
Some system info:
LinuxPPC June 1999, Kernel 2.2.17-0.6.1,
glibc-2.1.3-0j
gcc-2.95.3-2f
Innobase data is written to an IDE harddisk.
Cheers
Christian Jaeger
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
