Tasks #53035
in dbstore add config to set sqlite pragma performance tuning options
% Done:
0%
Tags:
Reviewed:
Affected Versions:
Pull request ID:
Description
in benchmarks
changing the defaults to for example
PRAGMA journal_mode=OFF; PRAGMA synchronous=0; PRAGMA cache_size=32768; PRAGMA locking_mode=EXCLUSIVE; PRAGMA temp_store=MEMORY;
increases performance of hsbench PUT load:
numactl -N 1 -m 1 -- ~/go/bin/hsbench -a 0555b35654ad1656d804 -s h7GhxuBLTrlhVUyxSPUKUV8r/2EI4ngqJxD7iBdBYLhwluN30JaT3Q== -u http://127.0.0.1:8000 -z 64K -d -1 -t $(numactl -N 1 -- nproc) -b
from 901 IO/s to 3089 IO/s
2021/10/25 17:49:24 Loop: 0, Int: TOTAL, Dur(s): 9.7, Mode: PUT, Ops: 30000, MB/s: 193.08, IO/s: 3089, Lat(ms): [ min: 4.1, avg: 18.1, 99%: 32.9, max: 104.4 ], Slowdowns: 0