gistfile1.txt

--- Time in seconds for select min(transactionid)
l.i1    q100    q500    q1000
0.001   12.715  14.787  12.970

--- Perf context stats for query run at the state of each benchmark step.

step=i1
4               SEEK_CHILD_SEEK_COUNT
5               BLOCK_CACHE_HIT_COUNT
12              IO_THREAD_POOL_ID
46              ITER_READ_BYTES
47              USER_KEY_COMPARISON_COUNT

step=q1
65466           BLOCK_READ_COUNT
225827          BLOCK_CACHE_HIT_COUNT
36521600                INTERNAL_DELETE_SKIPPED_COUNT
36521600                INTERNAL_KEY_SKIPPED_COUNT
256113421               USER_KEY_COMPARISON_COUNT
511093703               BLOCK_READ_BYTE
511093703               IO_BYTES_READ

step=q2
731             BLOCK_READ_COUNT
1250            NEXT_ON_MEMTABLE_COUNT
293423          BLOCK_CACHE_HIT_COUNT
5953759         BLOCK_READ_BYTE
5953759         IO_BYTES_READ
36881600                INTERNAL_DELETE_SKIPPED_COUNT
36881600                INTERNAL_KEY_SKIPPED_COUNT
332217298               USER_KEY_COMPARISON_COUNT

step=q3
51              ITER_READ_BYTES
950             NEXT_ON_MEMTABLE_COUNT
4472            BLOCK_READ_COUNT
283850          BLOCK_CACHE_HIT_COUNT
31577524                BLOCK_READ_BYTE
31577524                IO_BYTES_READ
36144100                INTERNAL_DELETE_SKIPPED_COUNT
36144100                INTERNAL_KEY_SKIPPED_COUNT
325566918               USER_KEY_COMPARISON_COUNT

$client -B -e 'select * from information_schema.rocksdb_perf_context_global' > o.pc.q${loop}.1
$client ib -e 'select min(transactionid) from pi1'
$client ib -B -e 'select * from information_schema.rocksdb_perf_context_global' > o.pc.q${loop}.2

m=480; for d0 in $( ls -r | grep ^${m}m\. ); do echo ; echo -n $d0; for d1 in l.i1 q.L1.* q.L2.* q.L3.* ; do grep -h min_trx $d0/$d1/o.ib.* 2> /dev/null | grep get_min | awk '{ print $(NF-1) }'| sort -n | tail -1 | awk '{ printf "\t%s", $1 }'; done ; done

for x in x i1 q1 q2 q3 ; do echo; echo $x; join o.pc.${x}.1 o.pc.${x}.2 | awk '{ printf "%d\t\t%s\n", $3 - $2, $1 }' | sort -n -k 1,1 | tail -10 ; done