Skip to content

Instantly share code, notes, and snippets.

Avatar
🎯
Focusing

Mark Callaghan mdcallag

🎯
Focusing
View GitHub Profile
View gist:21ce47c03f3eb2de01b11769b5760cb0
g++ -fno-rtti -g -W -Wextra -Wall -Wsign-compare -Wshadow -Wunused-parameter -Werror -I. -I./include -std=c++11 -faligned-new -DHAVE_ALIGNED_NEW -DROCKSDB_PLATFORM_POSIX -DROCKSDB_LIB_IO_POSIX -DOS_LINUX -fno-builtin-memcmp -DROCKSD
B_FALLOCATE_PRESENT -DSNAPPY -DGFLAGS=1 -DZLIB -DLZ4 -DZSTD -DNUMA -DROCKSDB_MALLOC_USABLE_SIZE -DROCKSDB_PTHREAD_ADAPTIVE_MUTEX -DROCKSDB_BACKTRACE -DROCKSDB_RANGESYNC_PRESENT -DROCKSDB_SCHED_GETCPU_PRESENT -march=native -DHAVE_SSE42
-DHAVE_PCLMUL -DROCKSDB_SUPPORT_THREAD_LOCAL -DROCKSDB_JEMALLOC -DJEMALLOC_NO_DEMANGLE -isystem ./third-party/gtest-1.7.0/fused-src -O2 -fno-omit-frame-pointer -momit-leaf-frame-pointer -DNDEBUG -Woverloaded-virtual -Wnon-virtual-dto
r -Wno-missing-field-initializers -c db/column_family.cc -o db/column_family.o
In file included from ./db/memtable.h:21,
from ./db/memtable_list.h:17,
from ./db/column_family.h:17,
from ./db/db_impl/db_impl.h:22,
from tools/db_bench_tool.cc:32:
./d
View gist:710019d1f9cafc93f4c8a313a83e6d95
v64 v611 v612 v613 v614 v615 v616 v617 test
3.1 3.2 3.2 3.2 3.2 3.2 3.2 3.2 fillrandom
14.3 14.4 13.4 13.1 13.9 13.5 14.1 14.0 overwrite
0.3 0.4 0.4 0.4 0.4 0.4 0.4 0.4 readseq
14.5 17.2 16.0 16.1 16.1 19.6 19.5 14.6 readrandom
29.7 41.3 29.4 30.4 29.4 41.5 35.2 28.6 seekrandom
0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 readseq
16.1 18.5 17.2 17.1 17.0 15.7 18.8 16.9 readrandom
34.5 46.0 32.6 34.8 34.0 31.0 40.3 33.4 seekrandom
33.4 46.0 32.7 34.5 34.4 31.2 42.1 35.2 seekrandom
View gist:55a7ff9baada1bd053c6a5328578ae68
v64 v611 v612 v613 v614 v615 v616 v617 test
3.1 3.2 3.2 3.2 3.2 3.2 3.2 3.2 fillrandom
14.3 14.4 13.4 13.1 13.9 13.5 14.1 14.0 overwrite
0.3 0.4 0.4 0.4 0.4 0.4 0.4 0.4 readseq
14.5 17.2 16.0 16.1 16.1 19.6 19.5 14.6 readrandom
29.7 41.3 29.4 30.4 29.4 41.5 35.2 28.6 seekrandom
0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 readseq
16.1 18.5 17.2 17.1 17.0 15.7 18.8 16.9 readrandom
34.5 46.0 32.6 34.8 34.0 31.0 40.3 33.4 seekrandom
33.4 46.0 32.7 34.5 34.4 31.2 42.1 35.2 seekrandom
View gist:49c17bf658f89c160de5ad42703f9b28
v64 v611 v612 v613 v614 v615 v616 v617 test
3.1 3.2 3.2 3.2 3.2 3.2 3.2 3.2 fillrandom
14.3 14.4 13.4 13.1 13.9 13.5 14.1 14.0 overwrite
0.3 0.4 0.4 0.4 0.4 0.4 0.4 0.4 readseq
14.5 17.2 16.0 16.1 16.1 19.6 19.5 14.6 readrandom
29.7 41.3 29.4 30.4 29.4 41.5 35.2 28.6 seekrandom
0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 readseq
16.1 18.5 17.2 17.1 17.0 15.7 18.8 16.9 readrandom
34.5 46.0 32.6 34.8 34.0 31.0 40.3 33.4 seekrandom
33.4 46.0 32.7 34.5 34.4 31.2 42.1 35.2 seekrandom
View gist:4a0a927c5965939e559af777a66d2b27
v64 v611 v612 v613 v614 v615 v616 v617 test
3.2 3.2 3.2 3.2 3.2 3.2 3.3 3.2 fillrandom
3.1 3.2 3.3 3.2 3.2 3.2 3.2 3.2 overwrite
0.4 0.4 0.4 0.4 0.4 0.4 0.4 0.4 readseq
7.5 9.4 9.7 9.1 9.3 9.3 10.9 9.9 readrandom
16.9 17.2 17.0 17.1 17.3 16.5 25.3 17.0 seekrandom
0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 readseq
6.2 7.3 7.8 7.7 7.8 7.6 7.7 7.5 readrandom
16.9 18.4 17.4 17.7 17.6 16.8 15.6 17.3 seekrandom
17.3 17.9 17.6 18.0 19.0 17.9 15.7 17.8 seekrandom
View gist:d90cdfb36c3f92ee8a0c51eb131d68b6
v64 v611 v612 v613 v614 v615 v616 v617 test
2.8 2.9 3.0 2.9 2.9 2.9 2.9 2.9 fillrandom
2.9 2.9 2.9 3.0 3.1 3.0 3.0 2.9 overwrite
0.4 0.4 0.3 0.3 0.3 0.4 0.4 0.4 readseq
6.3 7.7 8.3 8.1 8.2 7.4 8.3 7.3 readrandom
13.0 13.6 15.4 14.0 20.2 10.7 15.5 10.2 seekrandom
0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 readseq
4.6 5.9 5.9 6.0 5.6 5.2 5.9 5.1 readrandom
13.0 13.5 14.9 13.6 12.0 10.5 15.0 10.3 seekrandom
13.0 13.7 15.2 14.0 12.3 10.7 15.4 10.6 seekrandom
View gist:d36ca71263da26bea192718545ca7bae
v64 v611 v612 v613 v614 v615 v616 v617 test
2.9 2.9 2.9 2.9 2.9 2.9 2.9 3.0 fillrandom
2.9 3.1 3.0 3.0 3.0 2.9 2.9 3.0 overwrite
0.3 0.4 0.3 0.4 0.4 0.4 0.4 0.4 readseq
6.0 7.5 7.6 8.9 8.3 8.3 11.5 8.3 readrandom
12.6 17.2 15.0 20.3 14.0 14.0 10.5 13.9 seekrandom
0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 readseq
4.5 6.1 5.8 5.7 5.9 5.7 5.3 6.0 readrandom
12.4 16.9 14.8 12.0 13.6 13.6 10.6 13.5 seekrandom
12.7 17.2 15.3 12.2 13.8 13.9 10.8 13.8 seekrandom
View gist:dee88d2d915a28c2d8a5391dce899ebb
LSM tree shapes during the "Read-only after write-heavy" tests
LSM tree for 5.6.35
Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 14.5 14.5 0.0 1.0 0.0 255.9 57.88 52.37 81 0.715 0 0
L5 17/0 1004.18 MB 1.0 29.7 13.4 16.3 22.7 6.4 0.0 1.7 242.1 184.9 125.45 111.21 19 6.603 181M 33M
L6 28/0 2.00 GB 0.0 16.1 4.7 11.4 11.5 0.1 1.9 2.4 214.0 152.6 77.19 71.02 74 1.043 136M 24M
Sum 45/0 2.98 GB 0.0 45.8 18.1 27.7 48.6 21.0
View gist:3c40a6cc8a673469e94b28d2c55027d2
--------------
set long_query_time=0
--------------
Query OK, 0 rows affected (0.00 sec)
--------------
flush status
--------------
View gist:ce7575d9ea578390d5c1a87679039b77
--------------
drop table if exists ten
--------------
Query OK, 0 rows affected (0.03 sec)
--------------
drop table if exists one_k
--------------