Created
July 27, 2023 14:30
-
-
Save mdcallag/51807dc102cd5e295ee047239c725c36 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--- 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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment