From: Bas Meijer
Date: April 7 2005 8:16am
Subject: Re: ext3, ext2, vfat performance on RedHat Enterprise 4
List-Archive: http://lists.mysql.com/benchmarks/135
Message-Id: <23263.212.123.215.13.1112861780.squirrel@212.123.215.13>
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Peter Zaitsev wrote:
>
>
> By the way what are the server settings ? I'm surprised with such major
> difference in Innodb vs BDB.   1mil records - you get just 10.000
> records/sec which is very small for sysbench.
>

Thank you Peter!! You pointed out a serious error that is not detected by
sysbench,
the table isn't actually a BDB one!!! I filed a bug on
sysbench.sourceforge.net
Could you please remove the postings with the BDB timings? I can prepare
new ones.

time sysbench --mysql-user=root --mysql-db=core3 --num-threads=50
--test=oltp --mysql-table-type=bdb --oltp-table-size=1000000 prepare
sysbench v0.3.1:  multi-threaded system evaluation benchmark

Creating table 'sbtest'...
Creating 1000000 records in table 'sbtest'...

real    0m19.858s
user    0m0.550s
sys     0m0.122s

# file sbtest*
sbtest.frm: MySQL table definition file Version 9
sbtest.MYD: data
sbtest.MYI: MySQL MISAM compressed data file Version 1

Bas Meijer