mdcallag

pi1_pkey
-[ RECORD 1 ]------+----------
version            | 4
tree_level         | 2
index_size         | 112328704
root_block_no      | 412
internal_pages     | 49
leaf_pages         | 13662
empty_pages        | 0
deleted_pages      | 0

mdcallag

 Unsafe:

   Characters can be unsafe for a number of reasons.  The space
   character is unsafe because significant spaces may disappear and
   insignificant spaces may be introduced when URLs are transcribed or
   typeset or subjected to the treatment of word-processing programs.
   The characters "<" and ">" are unsafe because they are used as the
   delimiters around URLs in free text; the quote mark (""") is used to
   delimit URLs in some systems.  The character "#" is unsafe and should
   always be encoded because it is used in World Wide Web and in other

mdcallag

 Unsafe:

   Characters can be unsafe for a number of reasons.  The space
   character is unsafe because significant spaces may disappear and
   insignificant spaces may be introduced when URLs are transcribed or
   typeset or subjected to the treatment of word-processing programs.
   The characters "<" and ">" are unsafe because they are used as the
   delimiters around URLs in free text; the quote mark (""") is used to
   delimit URLs in some systems.  The character "#" is unsafe and should
   always be encoded because it is used in World Wide Web and in other

mdcallag

j=$1
nr=$2
cpri=$3
dyn=$4
secs=$5
dname=$6
vsz=$7

dbdir="./rdb"

mdcallag

ver=$1
dir=$2
loops=$3
num=$4
pri=$5
key=$6
val=$7
cachemb=$8
dur=$9

mdcallag

# cat xh
notes
fillseq
rr,nopin,L0=4
rr,pin,L0=4
rr,nopin,L0=2
rr,pin,L0=2
rr,nopin,L0=1
rr,pin,L0=1
overwrite

mdcallag

for n in 1000000 10000000 100000000; do echo $n 8 400; bash pp.sh $n 8 400; done

Notes:
* rr = readrandom response time, fillseq/overwrite are response times for those tests
* test was repeated 3 times, median time is listed
* ratio column has value for 5143 / 42
* 42, 547, 575, 5142, 5143 are release nubmers - 4.2, 5.4.7, 5.7.5, 5.14.2, 5.14.3
* nopin/pin is test with pin_l0_filter_and_index_blocks_in_cache set to 0 and 1
* L0 = 1, 2, 4 is value for level0_file_num_compaction_trigger

mdcallag

for n in 10000000 100000000 1000000000; do echo $n 32 10; bash pp.sh $n 32 10; done

Notes:
* rr = readrandom response time, fillseq/overwrite are response times for those tests
* test was repeated 3 times, median time is listed
* ratio column has value for 5143 / 42
* 42, 547, 575, 5142, 5143 are release nubmers - 4.2, 5.4.7, 5.7.5, 5.14.2, 5.14.3
* nopin/pin is test with pin_l0_filter_and_index_blocks_in_cache set to 0 and 1
* L0 = 1, 2, 4 is value for level0_file_num_compaction_trigger

mdcallag

bash r.sh 10000000 60 32 4 ./rdb 0 ./db_bench.5143 > x.10m.90s.32.4

legend:
* #thr - number of threads
* trx=n - no transaction
* trx=p - pessimistic transaction
* trx=o - optimistic transaction
* numbers are inserts per second
* mt0/mt1 - concurrent memtable disabled/enabled

mdcallag

numk=$1
secs=$2
val=$3
batch=$4
dbdir=$5
sync=$6
dbb=$7

# sync, dbdir, concurmt, secs, dop