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 | |
-------------- |
NewerOlder