mdcallag

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

mdcallag

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

mdcallag

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

mdcallag

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

mdcallag

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

mdcallag

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

mdcallag

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

mdcallag

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  

mdcallag

--------------
set long_query_time=0
--------------

Query OK, 0 rows affected (0.00 sec)

--------------
flush status
--------------

mdcallag

--------------
drop table if exists ten
--------------

Query OK, 0 rows affected (0.03 sec)

--------------
drop table if exists one_k
--------------