Filesystems comparison using sql-bench and mySQL
(comparison between 64MB and 2GB of memory)

Raw results can be found here.
This results have been made using original values of loop in test scripts and only one time (no average)
In the case of 64MB tests, kernel has been booted using "mem=64M"

Summary of the results

alter-table

Memory size has a big impact on ext2, ext3 delalloc and jfs. We can suppose in the case of 2GB a lot of blocks are cached in memory.
This cache management could explain why ext3 data=ordered,delalloc has an impact on performance.

ATIS

Results are not enough accurate to have conclusion.
(seems faster with 64MB...)

big-tables

Results are not enough accurate to have conclusion. (no real differences)

connect

This test is normally a test of connection, so memory is not a real issue

create

Memory has a big impact on xfs (x5.53) and reiserfs (x2.06)

insert

This test is very memory size sensitive.
All filesystems are between 2.44 and 4.54 slower.
More sensitive filesystem is ext3 data=ordered, less sensitive is jfs

select

No real impact. In some cases 64 MB is faster !!!

wisconsin

Results are not enough accurate to have conclusion. (no real differences)

Results

alter-table

alter-table 2GB 64MB 64MB/2GB
ext2_defaults 55.00 119.00 x 2.16
ext3_data=ordered 70.00 80.00 x 1.14
ext3_data=ordered,extents 70.00 84.00 x 1.20
ext3_data=ordered,mballoc,delalloc,extents 52.00 81.00 x 1.56
ext3_data=ordered,mballoc,extents 75.00 90.00 x 1.20
ext3_data=writeback 67.00 78.00 x 1.16
ext3_data=writeback,extents 66.00 84.00 x 1.27
ext3_data=writeback,mballoc,delalloc,extents 52.00 80.00 x 1.54
ext3_data=writeback,mballoc,extents 69.00 89.00 x 1.29
jfs_defaults 72.00 115.00 x 1.60
reiserfs_defaults 69.00 68.00 x 0.99
xfs_defaults 72.00 92.00 x 1.28
alter-table

ATIS

ATIS 2GB 64MB 64MB/2GB
ext2_defaults 15.00 14.00 x 0.93
ext3_data=ordered 15.00 14.00 x 0.93
ext3_data=ordered,extents 15.00 14.00 x 0.93
ext3_data=ordered,mballoc,delalloc,extents 15.00 14.00 x 0.93
ext3_data=ordered,mballoc,extents 15.00 15.00 x 1.00
ext3_data=writeback 15.00 15.00 x 1.00
ext3_data=writeback,extents 15.00 15.00 x 1.00
ext3_data=writeback,mballoc,delalloc,extents 14.00 15.00 x 1.07
ext3_data=writeback,mballoc,extents 15.00 15.00 x 1.00
jfs_defaults 15.00 15.00 x 1.00
reiserfs_defaults 14.00 15.00 x 1.07
xfs_defaults 16.00 15.00 x 0.94
ATIS

big-tables

big-tables 2GB 64MB 64MB/2GB
ext2_defaults 10.00 11.00 x 1.10
ext3_data=ordered 10.00 10.00 x 1.00
ext3_data=ordered,extents 10.00 10.00 x 1.00
ext3_data=ordered,mballoc,delalloc,extents 10.00 11.00 x 1.10
ext3_data=ordered,mballoc,extents 10.00 10.00 x 1.00
ext3_data=writeback 10.00 10.00 x 1.00
ext3_data=writeback,extents 11.00 10.00 x 0.91
ext3_data=writeback,mballoc,delalloc,extents 10.00 10.00 x 1.00
ext3_data=writeback,mballoc,extents 10.00 11.00 x 1.10
jfs_defaults 10.00 10.00 x 1.00
reiserfs_defaults 10.00 10.00 x 1.00
xfs_defaults 10.00 10.00 x 1.00
big-tables

connect

connect 2GB 64MB 64MB/2GB
ext2_defaults 28.00 28.00 x 1.00
ext3_data=ordered 28.00 29.00 x 1.04
ext3_data=ordered,extents 29.00 29.00 x 1.00
ext3_data=ordered,mballoc,delalloc,extents 29.00 29.00 x 1.00
ext3_data=ordered,mballoc,extents 28.00 29.00 x 1.04
ext3_data=writeback 29.00 29.00 x 1.00
ext3_data=writeback,extents 28.00 30.00 x 1.07
ext3_data=writeback,mballoc,delalloc,extents 28.00 29.00 x 1.04
ext3_data=writeback,mballoc,extents 29.00 29.00 x 1.00
jfs_defaults 28.00 30.00 x 1.07
reiserfs_defaults 28.00 29.00 x 1.04
xfs_defaults 29.00 30.00 x 1.03
connect

create

create 2GB 64MB 64MB/2GB
ext2_defaults 59.00 65.00 x 1.10
ext3_data=ordered 80.00 95.00 x 1.19
ext3_data=ordered,extents 82.00 90.00 x 1.10
ext3_data=ordered,mballoc,delalloc,extents 75.00 86.00 x 1.15
ext3_data=ordered,mballoc,extents 82.00 94.00 x 1.15
ext3_data=writeback 80.00 91.00 x 1.14
ext3_data=writeback,extents 80.00 90.00 x 1.12
ext3_data=writeback,mballoc,delalloc,extents 76.00 87.00 x 1.14
ext3_data=writeback,mballoc,extents 83.00 96.00 x 1.16
jfs_defaults 280.00 364.00 x 1.30
reiserfs_defaults 32.00 66.00 x 2.06
xfs_defaults 34.00 188.00 x 5.53
create

insert

insert 2GB 64MB 64MB/2GB
ext2_defaults 779.00 2655.00 x 3.41
ext3_data=ordered 1102.00 4999.00 x 4.54
ext3_data=ordered,extents 1189.00 4467.00 x 3.76
ext3_data=ordered,mballoc,delalloc,extents 798.00 2414.00 x 3.03
ext3_data=ordered,mballoc,extents 1054.00 3011.00 x 2.86
ext3_data=writeback 785.00 2493.00 x 3.18
ext3_data=writeback,extents 781.00 2930.00 x 3.75
ext3_data=writeback,mballoc,delalloc,extents 783.00 3295.00 x 4.21
ext3_data=writeback,mballoc,extents 788.00 2743.00 x 3.48
jfs_defaults 787.00 1923.00 x 2.44
reiserfs_defaults 803.00 2533.00 x 3.15
xfs_defaults 791.00 2014.00 x 2.55
insert

select

select 2GB 64MB 64MB/2GB
ext2_defaults 383.00 381.00 x 0.99
ext3_data=ordered 370.00 389.00 x 1.05
ext3_data=ordered,extents 380.00 364.00 x 0.96
ext3_data=ordered,mballoc,delalloc,extents 391.00 381.00 x 0.97
ext3_data=ordered,mballoc,extents 388.00 366.00 x 0.94
ext3_data=writeback 385.00 382.00 x 0.99
ext3_data=writeback,extents 368.00 382.00 x 1.04
ext3_data=writeback,mballoc,delalloc,extents 384.00 365.00 x 0.95
ext3_data=writeback,mballoc,extents 370.00 366.00 x 0.99
jfs_defaults 381.00 378.00 x 0.99
reiserfs_defaults 374.00 376.00 x 1.01
xfs_defaults 396.00 372.00 x 0.94
select

wisconsin

wisconsin 2GB 64MB 64MB/2GB
ext2_defaults 5.00 5.00 x 1.00
ext3_data=ordered 6.00 5.00 x 0.83
ext3_data=ordered,extents 5.00 6.00 x 1.20
ext3_data=ordered,mballoc,delalloc,extents 6.00 5.00 x 0.83
ext3_data=ordered,mballoc,extents 6.00 5.00 x 0.83
ext3_data=writeback 5.00 6.00 x 1.20
ext3_data=writeback,extents 6.00 5.00 x 0.83
ext3_data=writeback,mballoc,delalloc,extents 5.00 5.00 x 1.00
ext3_data=writeback,mballoc,extents 6.00 6.00 x 1.00
jfs_defaults 5.00 5.00 x 1.00
reiserfs_defaults 5.00 5.00 x 1.00
xfs_defaults 5.00 5.00 x 1.00
wisconsin