Project

General

Profile

Tasks #53035

in dbstore add config to set sqlite pragma performance tuning options

Added by Mark Kogan over 2 years ago.

Status:
In Progress
Priority:
Normal
Assignee:
Target version:
-
% 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

Also available in: Atom PDF