View gist:076c54bad719621f1881efe5660585e6
*************************** 1. row ***************************
TABLE_SCHEMA: test
TABLE_NAME: sbtest1
TABLE_ENGINE: ROCKSDB
ROWS_INSERTED: 20472606
ROWS_UPDATED: 12733033
ROWS_DELETED: 472607
ROWS_READ: 228870313
ROWS_REQUESTED: 228870314
COMPRESSED_PAGE_SIZE: 0
View gist:3758b58e671c1fd984cd1b4676376285
*************************** 4. row ***************************
Type: CF_COMPACTION
Name: default
Status:
** Compaction Stats [default] **
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) Comp(cnt) Avg(sec) KeyIn KeyDrop
----------------------------------------------------------------------------------------------------------------------------------------------------------
L0 2/0 24.49 MB 0.5 0.0 0.0 0.0 1.6 1.6 0.0 1.0 0.0 135.9 12 101 0.122 0 0
L5 3/0 77.14 MB 1.0 2.3 1.0 1.3 1.8 0.5 0.4 1.8 109.2 84.4 21 21 1.012 28M 4684K
L6 27/0 811.94 MB 0.0 2.9 0.4 2.5 2.7 0.2 0.6 6.3 125.3 115.5 24 22 1.083 34M 2679K
View gist:fd8dbfad127ad36bc3eafc85da0a461a
--- my.cnf for 5.6.35
[mysqld]
sql_mode=no_engine_substitution,no_unsigned_subtraction
default_tmp_storage_engine=MyISAM
tmpdir=/data/m/my
query_cache_size=0
query_cache_type=0
long_query_time=5
log_bin=/data/m/my/binlogs/bl
View gist:fc47a8e6574fea8439a39c58aaaa61ea
--- my.cnf for 5.6.35
[mysqld]
sql_mode=no_engine_substitution,no_unsigned_subtraction
default_tmp_storage_engine=MyISAM
tmpdir=/data/m/my
query_cache_size=0
query_cache_type=0
long_query_time=5
log_bin=/data/m/my/binlogs/bl
View gist:3e36f9dc89f7b15b8c7b98f982bf8085
./sysbench --test=/home/mdcallag/b/sysbench/share/sysbench/oltp_update_index.lua --db-driver=mysql --mysql-user=root --mysql-password=pw --mysql-host=127.0.0.1 --mysql-db=test --mysql-storage-engine=innodb --range-size=100 --table-size=1000000 --tables=1 --events=0 --time=180 prepare
./sysbench --test=/home/mdcallag/b/sysbench/share/sysbench/oltp_update_index.lua --db-driver=mysql --mysql-user=root --mysql-password=pw --mysql-host=127.0.0.1 --mysql-db=test --mysql-storage-engine=innodb --range-size=100 --table-size=1000000 --tables=1 --threads=1 --events=0 --time=180 run
./sysbench --test=/home/mdcallag/b/sysbench/share/sysbench/oltp_update_non_index.lua --db-driver=mysql --mysql-user=root --mysql-password=pw --mysql-host=127.0.0.1 --mysql-db=test --mysql-storage-engine=innodb --range-size=100 --table-size=1000000 --tables=1 --threads=1 --events=0 --time=180 run
./sysbench --test=/home/mdcallag/b/sysbench/share/sysbench/oltp_read_only.lua --db-driver=mysql --mysql-user=root --mysql-password=pw --mysql-host
View gist:51b4e6489bc6ceaf92a59563b0437bc3
./sysbench --test=/home/mdcallag/b/sysbench/share/sysbench/oltp_update_index.lua --db-driver=mysql --mysql-user=root --mysql-password=pw --mysql-host=127.0.0.1 --mysql-db=test --mysql-storage-engine=myisam --range-size=100 --table-size=1000000 --tables=1 --events=0 --time=180 prepare
./sysbench --test=/home/mdcallag/b/sysbench/share/sysbench/oltp_update_index.lua --db-driver=mysql --mysql-user=root --mysql-password=pw --mysql-host=127.0.0.1 --mysql-db=test --mysql-storage-engine=myisam --range-size=100 --table-size=1000000 --tables=1 --threads=1 --events=0 --time=180 run
./sysbench --test=/home/mdcallag/b/sysbench/share/sysbench/oltp_update_non_index.lua --db-driver=mysql --mysql-user=root --mysql-password=pw --mysql-host=127.0.0.1 --mysql-db=test --mysql-storage-engine=myisam --range-size=100 --table-size=1000000 --tables=1 --threads=1 --events=0 --time=180 run
./sysbench --test=/home/mdcallag/b/sysbench/share/sysbench/oltp_read_only.lua --db-driver=mysql --mysql-user=root --mysql-password=pw --mysql-host
View gist:35aa43ff2e5da7bd5fc09db7e848ee17
--- my.cnf for 5.6.35
[mysqld]
sql_mode=no_engine_substitution,no_unsigned_subtraction
default_tmp_storage_engine=MyISAM
tmpdir=/data/m/my
query_cache_size=0
query_cache_type=0
long_query_time=5
log_bin=/data/m/my/binlogs/bl
View gist:a859908a58d7243051aced4197250f13
rw1.sh to setup database
./db_bench --benchmarks=fillseq --num=$1 --db=./ldb --statistics=$3 --stats_per_interval=0 --stats_interval_seconds=10 --cache_size=10737418240 --disable_wal=1 --compression_type=none --threads=1 --level_compaction_dynamic_level_bytes=1 --max_background_compactions=8 --max_background_flushes=3 --max_write_buffer_number=4 --write_buffer_size=33554432 --bytes_per_sync=4194304 --max_bytes_for_level_base=134217728 --memtablerep=$2
./db_bench --benchmarks=overwrite --num=$1 --db=./ldb --statistics=$3 --stats_per_interval=0 --stats_interval_seconds=10 --cache_size=10737418240 --disable_wal=1 --compression_type=none --threads=1 --level_compaction_dynamic_level_bytes=1 --max_background_compactions=8 --max_background_flushes=3 --max_write_buffer_number=4 --write_buffer_size=33554432 --bytes_per_sync=4194304 --max_bytes_for_level_base=134217728 --memtablerep=$2 --use_existing_db=1 --duration=60
ro2.sh to run readonly test
./db_bench --benchmarks=readrandom --num=$1 --db=./ldb --statistics=$3
View gist:56253a09d8278d582e60e575e1320c91
rw1.sh - to setup database
./db_bench --benchmarks=fillseq --num=$1 --db=./ldb --statistics=$3 --stats_per_interval=0 --stats_interval_seconds=10 --cache_size=10737418240 --disable_wal=1 --compression_type=none --threads=1 --level_compaction_dynamic_level_bytes=1 --max_background_compactions=8 --max_background_flushes=3 --max_write_buffer_number=4 --write_buffer_size=33554432 --bytes_per_sync=4194304 --max_bytes_for_level_base=134217728 --memtablerep=$2
./db_bench --benchmarks=overwrite --num=$1 --db=./ldb --statistics=$3 --stats_per_interval=0 --stats_interval_seconds=10 --cache_size=10737418240 --disable_wal=1 --compression_type=none --threads=1 --level_compaction_dynamic_level_bytes=1 --max_background_compactions=8 --max_background_flushes=3 --max_write_buffer_number=4 --write_buffer_size=33554432 --bytes_per_sync=4194304 --max_bytes_for_level_base=134217728 --memtablerep=$2 --use_existing_db=1 --duration=60
rw2.sh - to run readwhilewriting QPS
./db_bench --benchmarks=readwhilewriting --num=$1 --db=./ldb
View gist:ca1da5f7a34a64c0e14359a113ef21e1
./db_bench --benchmarks=fillseq --num=$1 --db=./ldb --statistics=$3 --stats_per_interval=0 --stats_interval_seconds=10 --cache_size=10737418240 --disable_wal=1 --compression_type=none --threads=1 --level_compaction_dynamic_level_bytes=1 --max_background_compactions=8 --max_background_flushes=3 --max_write_buffer_number=4 --write_buffer_size=33554432 --bytes_per_sync=4194304 --max_bytes_for_level_base=134217728 --memtablerep=$2