Skip to content

Instantly share code, notes, and snippets.

@hyc
Created July 5, 2014 17:57
Show Gist options
  • Save hyc/1620cece7067e905813d to your computer and use it in GitHub Desktop.
Save hyc/1620cece7067e905813d to your computer and use it in GitHub Desktop.
PGO results for LMDB in-memory
violino:~/OD/mdb/libraries/liblmdb> rm -rf /tmp/leveldbtest-1000/*
violino:~/OD/mdb/libraries/liblmdb> ./db_bench_mdb.no_profile --num=10000000
LMDB: version LMDB 0.9.14: (June 20, 2014)
Date: Sat Jul 5 10:47:17 2014
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: 10000000
RawSize: 1106.3 MB (estimated)
FileSize: 629.4 MB (estimated)
------------------------------------------------
fillrandsync : 6.018 micros/op 166162 ops/sec; 18.4 MB/s (10000 ops)
1888 /tmp/leveldbtest-1000/dbbench_mdb-1
1888 /tmp/leveldbtest-1000
fillrandom : 5.299 micros/op 188712 ops/sec; 20.9 MB/s
1166112 /tmp/leveldbtest-1000/dbbench_mdb-2
1166112 /tmp/leveldbtest-1000
fillrandbatch : 4.702 micros/op 212694 ops/sec; 23.5 MB/s
1180420 /tmp/leveldbtest-1000/dbbench_mdb-3
1180420 /tmp/leveldbtest-1000
fillseqsync : 4.608 micros/op 217004 ops/sec; 24.0 MB/s (10000 ops)
1312 /tmp/leveldbtest-1000/dbbench_mdb-4
1312 /tmp/leveldbtest-1000
fillseq : 2.308 micros/op 433367 ops/sec; 47.9 MB/s
1258128 /tmp/leveldbtest-1000/dbbench_mdb-5
1258128 /tmp/leveldbtest-1000
fillseqbatch : 0.440 micros/op 2271685 ops/sec; 251.3 MB/s
1258128 /tmp/leveldbtest-1000/dbbench_mdb-6
1258128 /tmp/leveldbtest-1000
overwrite : 6.071 micros/op 164706 ops/sec; 18.2 MB/s
1258128 /tmp/leveldbtest-1000/dbbench_mdb-6
1258128 /tmp/leveldbtest-1000
readrandom : 1.690 micros/op 591578 ops/sec; (10000000 of 10000000 found)
readseq : 0.055 micros/op 18098499 ops/sec; 2002.2 MB/s
readreverse : 0.051 micros/op 19581542 ops/sec; 2166.2 MB/s
violino:~/OD/mdb/libraries/liblmdb> rm -rf /tmp/leveldbtest-1000/*
violino:~/OD/mdb/libraries/liblmdb> ./db_bench_mdb.profiled --num=10000000
LMDB: version LMDB 0.9.14: (June 20, 2014)
Date: Sat Jul 5 10:43:50 2014
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: 10000000
RawSize: 1106.3 MB (estimated)
FileSize: 629.4 MB (estimated)
------------------------------------------------
fillrandsync : 5.662 micros/op 176612 ops/sec; 19.5 MB/s (10000 ops)
1888 /tmp/leveldbtest-1000/dbbench_mdb-1
1888 /tmp/leveldbtest-1000
fillrandom : 4.909 micros/op 203697 ops/sec; 22.5 MB/s
1166112 /tmp/leveldbtest-1000/dbbench_mdb-2
1166112 /tmp/leveldbtest-1000
fillrandbatch : 4.620 micros/op 216433 ops/sec; 23.9 MB/s
1180420 /tmp/leveldbtest-1000/dbbench_mdb-3
1180420 /tmp/leveldbtest-1000
fillseqsync : 4.326 micros/op 231171 ops/sec; 25.6 MB/s (10000 ops)
1312 /tmp/leveldbtest-1000/dbbench_mdb-4
1312 /tmp/leveldbtest-1000
fillseq : 1.984 micros/op 504040 ops/sec; 55.8 MB/s
1258128 /tmp/leveldbtest-1000/dbbench_mdb-5
1258128 /tmp/leveldbtest-1000
fillseqbatch : 0.424 micros/op 2359528 ops/sec; 261.0 MB/s
1258128 /tmp/leveldbtest-1000/dbbench_mdb-6
1258128 /tmp/leveldbtest-1000
overwrite : 5.620 micros/op 177921 ops/sec; 19.7 MB/s
1258128 /tmp/leveldbtest-1000/dbbench_mdb-6
1258128 /tmp/leveldbtest-1000
readrandom : 1.585 micros/op 631099 ops/sec; (10000000 of 10000000 found)
readseq : 0.054 micros/op 18570309 ops/sec; 2054.4 MB/s
readreverse : 0.049 micros/op 20518207 ops/sec; 2269.9 MB/s
fillrandsync 1.062 (6.2% speedup)
fillrandom 1.079
fillrandbatch 1.017
fillseqsync 1.065
fillseq 1.163
fillseqbatch 1.038
overwrite 1.080
readrandom 1.066
readseq 1.026
readreverse 1.047
@hyc
Copy link
Author

hyc commented Jul 5, 2014

Using gcc (Ubuntu/Linaro 4.7.3-1ubuntu1) 4.7.3

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment