Skip to content

Instantly share code, notes, and snippets.

@hyc
Created September 28, 2017 01:53
Show Gist options
  • Save hyc/4422efdca16512363ef201507cd624f4 to your computer and use it in GitHub Desktop.
Save hyc/4422efdca16512363ef201507cd624f4 to your computer and use it in GitHub Desktop.
dbbench quick test
violino:/home/software/dbbench/bin> foreach i (*)
foreach? rm -rf /tmp/dbbench-1000/*
foreach? ./$i
foreach? end
Basho LevelDB: version 1.9
Date: Thu Sep 28 02:45:11 2017
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)
------------------------------------------------
fillrandsync : 2.317 micros/op 431592 ops/sec; 47.7 MB/s (1000 ops)
148 /tmp/dbbench-1000/basho
fillrandom : 3.683 micros/op 271553 ops/sec; 30.0 MB/s
98240 /tmp/dbbench-1000/basho
fillrandbatch : 3.104 micros/op 322175 ops/sec; 35.6 MB/s
95336 /tmp/dbbench-1000/basho
fillseqsync : 2.896 micros/op 345303 ops/sec; 38.2 MB/s (1000 ops)
148 /tmp/dbbench-1000/basho
fillseq : 2.005 micros/op 498701 ops/sec; 55.2 MB/s
115676 /tmp/dbbench-1000/basho
fillseqbatch : 1.535 micros/op 651641 ops/sec; 72.1 MB/s
160692 /tmp/dbbench-1000/basho
overwrite : 3.709 micros/op 269620 ops/sec; 29.8 MB/s
304444 /tmp/dbbench-1000/basho
readrandom : 7.660 micros/op 130554 ops/sec; 14.4 MB/s (1000000 of 1000000 found)
readseq : 0.319 micros/op 3132783 ops/sec; 346.6 MB/s
readreverse : 0.947 micros/op 1056276 ops/sec; 116.9 MB/s
BerkeleyDB: version Berkeley DB 5.3.28: (September 9, 2013)
Date: Thu Sep 28 02:45:35 2017
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)
------------------------------------------------
fillrandsync : 17.245 micros/op 57987 ops/sec; 6.4 MB/s (1000 ops)
14408 /tmp/dbbench-1000/bdb
fillrandom : 38.436 micros/op 26017 ops/sec; 2.9 MB/s
140564 /tmp/dbbench-1000/bdb
fillrandbatch : 16.902 micros/op 59166 ops/sec; 6.5 MB/s
178920 /tmp/dbbench-1000/bdb
fillseqsync : 13.198 micros/op 75769 ops/sec; 8.4 MB/s (1000 ops)
14292 /tmp/dbbench-1000/bdb
fillseq : 27.955 micros/op 35771 ops/sec; 4.0 MB/s
161952 /tmp/dbbench-1000/bdb
fillseqbatch : 5.650 micros/op 176992 ops/sec; 19.6 MB/s
199764 /tmp/dbbench-1000/bdb
overwrite : 43.604 micros/op 22933 ops/sec; 2.5 MB/s
181656 /tmp/dbbench-1000/bdb
readrandom : 13.425 micros/op 74488 ops/sec; 8.2 MB/s (1000000 of 1000000 found)
readseq : 1.361 micros/op 734576 ops/sec; 81.3 MB/s
readreverse : 1.333 micros/op 750000 ops/sec; 83.0 MB/s
HyperLevelDB: version 1.17
Date: Thu Sep 28 02:48:04 2017
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)
------------------------------------------------
fillrandsync : 5.458 micros/op 183217 ops/sec; 20.3 MB/s (1000 ops)
148 /tmp/dbbench-1000/hyper
fillrandom : 3.402 micros/op 293919 ops/sec; 32.5 MB/s
127344 /tmp/dbbench-1000/hyper
fillrandbatch : 2.265 micros/op 441583 ops/sec; 48.9 MB/s
143492 /tmp/dbbench-1000/hyper
fillseqsync : 3.264 micros/op 306372 ops/sec; 33.9 MB/s (1000 ops)
148 /tmp/dbbench-1000/hyper
fillseq : 2.427 micros/op 412068 ops/sec; 45.6 MB/s
112912 /tmp/dbbench-1000/hyper
fillseqbatch : 1.688 micros/op 592525 ops/sec; 65.5 MB/s
112380 /tmp/dbbench-1000/hyper
overwrite : 3.222 micros/op 310371 ops/sec; 34.3 MB/s
187128 /tmp/dbbench-1000/hyper
readrandom : 5.636 micros/op 177441 ops/sec; 19.6 MB/s (1000000 of 1000000 found)
readseq : 0.284 micros/op 3516310 ops/sec; 389.0 MB/s
readreverse : 0.506 micros/op 1976421 ops/sec; 218.6 MB/s
LevelDB: version 1.20
Date: Thu Sep 28 02:48:24 2017
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)
------------------------------------------------
fillrandsync : 104.239 micros/op 9593 ops/sec; 1.1 MB/s (1000 ops)
148 /tmp/dbbench-1000/leveldb
fillrandom : 3.666 micros/op 272763 ops/sec; 30.2 MB/s
101648 /tmp/dbbench-1000/leveldb
fillrandbatch : 2.070 micros/op 483117 ops/sec; 53.4 MB/s
95876 /tmp/dbbench-1000/leveldb
fillseqsync : 3.236 micros/op 309023 ops/sec; 34.2 MB/s (1000 ops)
148 /tmp/dbbench-1000/leveldb
fillseq : 3.150 micros/op 317424 ops/sec; 35.1 MB/s
112552 /tmp/dbbench-1000/leveldb
fillseqbatch : 1.340 micros/op 746290 ops/sec; 82.6 MB/s
112348 /tmp/dbbench-1000/leveldb
overwrite : 3.705 micros/op 269870 ops/sec; 29.9 MB/s
149300 /tmp/dbbench-1000/leveldb
readrandom : 5.737 micros/op 174318 ops/sec; 19.3 MB/s (1000000 of 1000000 found)
readseq : 0.233 micros/op 4299947 ops/sec; 475.7 MB/s
readreverse : 0.477 micros/op 2095605 ops/sec; 231.8 MB/s
LMDB: version LMDB 0.9.70: (December 19, 2015)
Date: Thu Sep 28 02:48:45 2017
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)
------------------------------------------------
fillrandsync : 4.957 micros/op 201734 ops/sec; 22.3 MB/s (1000 ops)
224 /tmp/dbbench-1000/lmdb
fillrandom : 4.391 micros/op 227719 ops/sec; 25.2 MB/s
116832 /tmp/dbbench-1000/lmdb
fillrandbatch : 3.339 micros/op 299474 ops/sec; 33.1 MB/s
126548 /tmp/dbbench-1000/lmdb
fillseqsync : 3.909 micros/op 255819 ops/sec; 28.3 MB/s (1000 ops)
172 /tmp/dbbench-1000/lmdb
fillseq : 2.222 micros/op 450050 ops/sec; 49.8 MB/s
125872 /tmp/dbbench-1000/lmdb
fillseqbatch : 0.443 micros/op 2259626 ops/sec; 250.0 MB/s
125872 /tmp/dbbench-1000/lmdb
overwrite : 4.916 micros/op 203397 ops/sec; 22.5 MB/s
125872 /tmp/dbbench-1000/lmdb
readrandom : 0.694 micros/op 1440270 ops/sec; 159.3 MB/s (1000000 of 1000000 found)
readseq : 0.066 micros/op 15165761 ops/sec;1677.7 MB/s
readreverse : 0.055 micros/op 18027112 ops/sec;1994.3 MB/s
RocksDB: version 5.7.3
Date: Thu Sep 28 02:49:02 2017
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)
------------------------------------------------
fillrandsync : 30.802 micros/op 32465 ops/sec; 3.6 MB/s (1000 ops)
76340 /tmp/dbbench-1000/rocksdb
fillrandom : 15.660 micros/op 63856 ops/sec; 7.1 MB/s
160472 /tmp/dbbench-1000/rocksdb
fillrandbatch : 7.116 micros/op 140534 ops/sec; 15.5 MB/s
160496 /tmp/dbbench-1000/rocksdb
fillseqsync : 29.543 micros/op 33848 ops/sec; 3.7 MB/s (1000 ops)
76340 /tmp/dbbench-1000/rocksdb
fillseq : 13.379 micros/op 74744 ops/sec; 8.3 MB/s
181652 /tmp/dbbench-1000/rocksdb
fillseqbatch : 4.130 micros/op 242113 ops/sec; 26.8 MB/s
181692 /tmp/dbbench-1000/rocksdb
overwrite : 15.740 micros/op 63533 ops/sec; 7.0 MB/s
188652 /tmp/dbbench-1000/rocksdb
readrandom : 16.343 micros/op 61189 ops/sec; 6.8 MB/s (1000000 of 1000000 found)
readseq : 0.482 micros/op 2075485 ops/sec; 229.6 MB/s
readreverse : 0.736 micros/op 1358372 ops/sec; 150.3 MB/s
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment