Skip to content

Instantly share code, notes, and snippets.

💭
for advice ask https://www.percona.com/

Mark Callaghan mdcallag

Block or report user

Report or block mdcallag

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View gist:90e1b7eb567a787964fd424e6be3f4bd
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
View gist:4143e85abf7f37fdf80eb404c1daf5a4
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
View gist:4074fa6642b3932f2f94979e8eb04b17
j=$1
nr=$2
cpri=$3
dyn=$4
secs=$5
dname=$6
vsz=$7
dbdir="./rdb"
View gist:060e773893450ab6518ab97fd437833c
ver=$1
dir=$2
loops=$3
num=$4
pri=$5
key=$6
val=$7
cachemb=$8
dur=$9
View gist:e7e1c905026ff8e845c113f02169403c
# 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
View gist:4634824ce75dabf2cc13eb334db65451
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
View gist:19bc721ce59f3a8430c56a703491e5da
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
View gist:6820718a98913780ec50652b6752dfdb
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
View gist:9f4d22163b3a155efbde839dba4fe1f6
numk=$1
secs=$2
val=$3
batch=$4
dbdir=$5
sync=$6
dbb=$7
# sync, dbdir, concurmt, secs, dop
View gist:09fc94ff585297c00adef6243e6339e3
test server:
* database on /dev/shm
* 2 sockets, 24 CPU cores, 48 HW threads
legend:
* #thr - number of threads
* trx=n - no transaction
* trx=p - pessimistic transaction
* trx=o - optimistic transaction
* numbers are inserts per second
You can’t perform that action at this time.