Sophia microbench, compared to LMDB

Source code is available at http://symas.com/mdb/microbench/db_bench_sophia.cc. Build it using the LevelDB microbench source code.

Sophia
Date:           Sun Nov  3 07:41:52 2013
CPU:            4 * Intel(R) Core(TM)2 Extreme CPU Q9300  @ 2.53GHz
CPUCache:       6144 KB
Keys:       16 bytes each
Values:     100 bytes each (50 bytes after compression)
Entries:    1000000
RawSize:    110.6 MB (estimated)
FileSize:   62.9 MB (estimated)
------------------------------------------------
fillseqsync  :       5.360 micros/op;   20.6 MB/s
132	/tmp/leveldbtest-1000/dbbench_sph-1
1806128	/tmp/leveldbtest-1000/dbbench_mdb-1
1806260	/tmp/leveldbtest-1000
fillrandsync :       5.337 micros/op;   20.7 MB/s
129912	/tmp/leveldbtest-1000/dbbench_sph-2
129912	/tmp/leveldbtest-1000
fillseq      :       4.042 micros/op;   27.4 MB/s
130804	/tmp/leveldbtest-1000/dbbench_sph-3
130804	/tmp/leveldbtest-1000
fillseqbatch :       1.635 micros/op;   67.7 MB/s
130992	/tmp/leveldbtest-1000/dbbench_sph-4
130992	/tmp/leveldbtest-1000
fillrandom   :       5.119 micros/op;   21.6 MB/s
129908	/tmp/leveldbtest-1000/dbbench_sph-5
129908	/tmp/leveldbtest-1000
fillrandbatch :       2.595 micros/op;   42.6 MB/s
235940	/tmp/leveldbtest-1000/dbbench_sph-6
235940	/tmp/leveldbtest-1000
overwrite    :       5.320 micros/op;   20.8 MB/s
189472	/tmp/leveldbtest-1000/dbbench_sph-6
189472	/tmp/leveldbtest-1000
readrandom   :       3.212 micros/op;
readseq      :       0.082 micros/op; 1353.5 MB/s
readreverse  :       0.081 micros/op; 1370.0 MB/s

MDB:    version MDB 0.9.6: (January 10, 2013)
Date:           Sun Nov  3 07:42:29 2013
CPU:            4 * Intel(R) Core(TM)2 Extreme CPU Q9300  @ 2.53GHz
CPUCache:       6144 KB
Keys:       16 bytes each
Values:     100 bytes each (50 bytes after compression)
Entries:    1000000
RawSize:    110.6 MB (estimated)
FileSize:   62.9 MB (estimated)
------------------------------------------------
fillseqsync  :       5.898 micros/op;   18.8 MB/s
172	/tmp/leveldbtest-1000/dbbench_mdb-1
133520	/tmp/leveldbtest-1000/dbbench_sph-6
133692	/tmp/leveldbtest-1000
fillrandsync :       5.995 micros/op;   18.5 MB/s
180836	/tmp/leveldbtest-1000/dbbench_mdb-2
180836	/tmp/leveldbtest-1000
fillseq      :       2.159 micros/op;   51.2 MB/s
126680	/tmp/leveldbtest-1000/dbbench_mdb-3
126680	/tmp/leveldbtest-1000
fillseqbatch :       0.428 micros/op;  258.2 MB/s
126680	/tmp/leveldbtest-1000/dbbench_mdb-4
126680	/tmp/leveldbtest-1000
fillrandom   :       4.197 micros/op;   26.4 MB/s
180720	/tmp/leveldbtest-1000/dbbench_mdb-5
180720	/tmp/leveldbtest-1000
fillrandbatch :       3.472 micros/op;   31.9 MB/s
192544	/tmp/leveldbtest-1000/dbbench_mdb-6
192544	/tmp/leveldbtest-1000
overwrite    :      10.839 micros/op;   10.2 MB/s
192544	/tmp/leveldbtest-1000/dbbench_mdb-6
192544	/tmp/leveldbtest-1000
readrandom   :       1.326 micros/op;
readseq      :       0.071 micros/op; 1551.3 MB/s
readreverse  :       0.079 micros/op; 1397.5 MB/s


Using 100,000 byte values:
violino:/home/software/leveldb> ./db_bench_sophia --value_size=100000 --num=10000
Sophia 1.1
Date:           Sun Nov  3 13:07:41 2013
CPU:            4 * Intel(R) Core(TM)2 Extreme CPU Q9300  @ 2.53GHz
CPUCache:       6144 KB
Keys:       16 bytes each
Values:     100000 bytes each (50000 bytes after compression)
Entries:    10000
RawSize:    953.8 MB (estimated)
FileSize:   477.0 MB (estimated)
------------------------------------------------
fillseqsync  :     307.012 micros/op;  310.7 MB/s
980	/tmp/leveldbtest-1000/dbbench_sph-1
138264	/tmp/leveldbtest-1000/dbbench_sph-6
139244	/tmp/leveldbtest-1000
fillrandsync :     209.313 micros/op;  455.7 MB/s
976888	/tmp/leveldbtest-1000/dbbench_sph-2
976888	/tmp/leveldbtest-1000
fillseq      :     222.895 micros/op;  427.9 MB/s
976888	/tmp/leveldbtest-1000/dbbench_sph-3
976888	/tmp/leveldbtest-1000
fillseqbatch :     218.425 micros/op;  436.7 MB/s
976888	/tmp/leveldbtest-1000/dbbench_sph-4
976888	/tmp/leveldbtest-1000
fillrandom   :     209.467 micros/op;  455.4 MB/s
976888	/tmp/leveldbtest-1000/dbbench_sph-5
976888	/tmp/leveldbtest-1000
fillrandbatch :     219.503 micros/op;  434.5 MB/s
976888	/tmp/leveldbtest-1000/dbbench_sph-6
976888	/tmp/leveldbtest-1000
overwrite    :     205.772 micros/op;  463.5 MB/s
1953772	/tmp/leveldbtest-1000/dbbench_sph-6
1953772	/tmp/leveldbtest-1000
readrandom   :      20.275 micros/op;
readseq      :       0.290 micros/op; 328351.9 MB/s
readreverse  :       0.148 micros/op; 645785.3 MB/s

violino:/home/software/leveldb> ./db_bench_mdb --value_size=100000 --num=10000
MDB:    version MDB 0.9.6: (January 10, 2013)
Date:           Sun Nov  3 13:08:16 2013
CPU:            4 * Intel(R) Core(TM)2 Extreme CPU Q9300  @ 2.53GHz
CPUCache:       6144 KB
Keys:       16 bytes each
Values:     100000 bytes each (50000 bytes after compression)
Entries:    10000
RawSize:    953.8 MB (estimated)
FileSize:   477.0 MB (estimated)
------------------------------------------------
fillseqsync  :     148.582 micros/op;  642.0 MB/s
1036	/tmp/leveldbtest-1000/dbbench_mdb-1
1953772	/tmp/leveldbtest-1000/dbbench_sph-6
1954808	/tmp/leveldbtest-1000
fillrandsync :      95.437 micros/op;  999.4 MB/s
1000540	/tmp/leveldbtest-1000/dbbench_mdb-2
1000540	/tmp/leveldbtest-1000
fillseq      :      92.622 micros/op; 1029.8 MB/s
1000380	/tmp/leveldbtest-1000/dbbench_mdb-3
1000380	/tmp/leveldbtest-1000
fillseqbatch :      90.041 micros/op; 1059.3 MB/s
1000380	/tmp/leveldbtest-1000/dbbench_mdb-4
1000380	/tmp/leveldbtest-1000
fillrandom   :      93.742 micros/op; 1017.5 MB/s
1000516	/tmp/leveldbtest-1000/dbbench_mdb-5
1000516	/tmp/leveldbtest-1000
fillrandbatch :      90.742 micros/op; 1051.1 MB/s
1001352	/tmp/leveldbtest-1000/dbbench_mdb-6
1001352	/tmp/leveldbtest-1000
overwrite    :      51.941 micros/op; 1836.4 MB/s
1001552	/tmp/leveldbtest-1000/dbbench_mdb-6
1001552	/tmp/leveldbtest-1000
readrandom   :       0.999 micros/op;
readseq      :       0.082 micros/op; 1163314.9 MB/s
readreverse  :       0.079 micros/op; 1213786.4 MB/s