Re: ext3, ext2, vfat performance on RedHat Enterprise 4

[Peter Zaitsev]

On Thu, 2005-04-07 at 01:16, Bas Meijer wrote:
> 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.
> 

Thanks. This is not exactly SysBench bug but MySQL gocha.    You can
create table as BDB but it may be converted to other table type
(normally MyISAM) silently. 

Anyway perhaps it would be good to add this extra check so it is more
user firendly.  Nowadays SysBench is not only used by us internally.


> 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
> 
-- 
Peter Zaitsev, Senior Performance Engineer
Come to hear my talk at MySQL UC 2005  http://www.mysqluc.com/
MySQL AB, www.mysql.com