db-benchmarks/important_tests.sh at main · glookka/db-benchmarks · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
./test --test=taxi --engines=elasticsearch:tuned --memory=110000 --dir=results/taxi/elasticsearch
./test --test=taxi --engines=clickhouse --memory=110000 --dir=results/taxi/clickhouse
./test --test=taxi --engines=manticoresearch:columnar --memory=110000 --dir=results/taxi/manticoresearch

./test --test=hn_small --engines=elasticsearch --memory=110000 --dir=results/hn_small/elasticsearch
./test --test=hn_small --engines=clickhouse --memory=110000 --dir=results/hn_small/clickhouse
./test --test=hn_small --engines=manticoresearch --memory=110000 --dir=results/hn_small/manticoresearch
./test --test=hn_small --engines=mysql --memory=110000 --dir=results/hn_small/mysql
./test --test=hn_small --engines=mysql_percona --memory=110000 --dir=results/hn_small/mysql_percona
./test --test=hn_small --engines=meilisearch --memory=110000 --dir=results/hn_small/meilisearch

./test --test=hn_small --engines=elasticsearch --memory=1024 --dir=results/hn_small/elasticsearch
./test --test=hn_small --engines=clickhouse --memory=1024 --dir=results/hn_small/clickhouse
./test --test=hn_small --engines=manticoresearch --memory=1024 --dir=results/hn_small/manticoresearch
./test --test=hn_small --engines=mysql --memory=1024 --dir=results/hn_small/mysql
./test --test=hn_small --engines=mysql_percona --memory=1024 --dir=results/hn_small/mysql_percona
./test --test=hn_small --engines=meilisearch --memory=1024 --dir=results/hn_small/meilisearch

./test --test=hn --engines=mysql:tuned --memory=110000 --dir=results/hn/mysql
./test --test=hn --engines=elasticsearch:tuned --memory=110000 --dir=results/hn/elasticsearch
./test --test=hn --engines=clickhouse --memory=110000 --dir=results/hn/clickhouse
./test --test=hn --engines=manticoresearch:columnar --memory=110000 --dir=results/hn/manticoresearch
./test --test=hn --engines=manticoresearch:rowwise --memory=110000 --dir=results/hn/manticoresearch

./test --test=hn --engines=mysql:tuned --memory=1024 --dir=results/hn/mysql
./test --test=hn --engines=elasticsearch:tuned --memory=1024 --dir=results/hn/elasticsearch
./test --test=hn --engines=clickhouse --memory=1024 --dir=results/hn/clickhouse
./test --test=hn --engines=manticoresearch:columnar --memory=1024 --dir=results/hn/manticoresearch
./test --test=hn --engines=manticoresearch:rowwise --memory=1024 --dir=results/hn/manticoresearch

./test --test=logs10m --engines=elasticsearch --memory=110000 --dir=results/logs10m/elasticsearch --query_timeout=600
./test --test=logs10m --engines=elasticsearch:tuned --memory=110000 --dir=results/logs10m/elasticsearch --query_timeout=600
./test --test=logs10m --engines=clickhouse --memory=110000 --dir=results/logs10m/clickhouse --query_timeout=600
./test --test=logs10m --engines=manticoresearch:columnar --memory=110000 --dir=results/logs10m/manticoresearch --query_timeout=600
./test --test=logs10m --engines=manticoresearch:rowwise --memory=110000 --dir=results/logs10m/manticoresearch --query_timeout=600
./test --test=logs10m --engines=meilisearch --memory=110000 --dir=results/logs10m/meilisearch --query_timeout=600

# hn_small + 1GB RAM + 1 physical (2 virtual) CPU core
./test --test=hn_small --engines=elasticsearch --memory=1024 --limited --dir=results/hn_small/elasticsearch
./test --test=hn_small --engines=clickhouse --memory=1024 --limited --dir=results/hn_small/clickhouse
./test --test=hn_small --engines=manticoresearch --memory=1024 --limited --dir=results/hn_small/manticoresearch
./test --test=hn_small --engines=mysql --memory=1024 --limited --dir=results/hn_small/mysql
./test --test=hn_small --engines=mysql_percona --memory=1024 --limited --dir=results/hn_small/mysql_percona
./test --test=hn_small --engines=meilisearch --memory=1024 --limited --dir=results/hn_small/meilisearch
./test --test=hn_small --engines=postgres --memory=1024 --limited --dir=results/hn_small/postgres
./test --test=hn_small --engines=typesense --memory=1024 --limited --dir=results/hn_small/typesense