mdcallag

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

mdcallag

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

mdcallag

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

mdcallag

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

mdcallag

./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

mdcallag

./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

mdcallag

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

mdcallag

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 

mdcallag

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

mdcallag

./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