## params: wal_level=replica mode=none pages=100 count=353 scale=20
(% are relative to "before")
before: tps  246.1 (100.0%), lat    44.551 ms (100.0%) (29 samples)
during: tps  134.7 ( 54.7%), lat    92.139 ms (206.8%) (31 samples)
 after: tps  177.4 ( 72.1%), lat    76.089 ms (170.8%) (90 samples)
DDL time:  30812 ms ( 100.0% relative to mode=none)
## params: wal_level=minimal mode=sync pages=100 count=353 scale=20
(% are relative to "before")
before: tps  224.8 (100.0%), lat    54.024 ms (100.0%) (29 samples)
during: tps  123.0 ( 54.7%), lat    89.375 ms (165.4%) (68 samples)
 after: tps  276.5 (123.0%), lat    37.129 ms ( 68.7%) (53 samples)
DDL time:  67581 ms ( 219.3% relative to mode=none)
## params: wal_level=minimal mode=WAL pages=100 count=353 scale=20
(% are relative to "before")
before: tps  249.3 (100.0%), lat    42.831 ms (100.0%) (29 samples)
during: tps  159.5 ( 64.0%), lat    66.353 ms (154.9%) (26 samples)
 after: tps  170.2 ( 68.3%), lat   136.414 ms (318.5%) (95 samples)
DDL time:  25761 ms (  83.6% relative to mode=none)
## params: wal_level=replica mode=none pages=250 count=258 scale=20
(% are relative to "before")
before: tps   96.9 (100.0%), lat   138.142 ms (100.0%) (29 samples)
during: tps   59.1 ( 61.0%), lat   263.514 ms (190.8%) (70 samples)
 after: tps  188.9 (195.0%), lat    89.134 ms ( 64.5%) (51 samples)
DDL time:  69459 ms ( 100.0% relative to mode=none)
## params: wal_level=minimal mode=sync pages=250 count=258 scale=20
(% are relative to "before")
before: tps  248.2 (100.0%), lat    43.087 ms (100.0%) (29 samples)
during: tps  103.7 ( 41.8%), lat   121.729 ms (282.5%) (89 samples)
 after: tps  273.7 (110.3%), lat    44.923 ms (104.3%) (32 samples)
DDL time:  88047 ms ( 126.8% relative to mode=none)
## params: wal_level=minimal mode=WAL pages=250 count=258 scale=20
(% are relative to "before")
before: tps  222.0 (100.0%), lat    54.662 ms (100.0%) (29 samples)
during: tps   85.6 ( 38.6%), lat   180.007 ms (329.3%) (48 samples)
 after: tps  165.8 ( 74.7%), lat   109.681 ms (200.7%) (73 samples)
DDL time:  47951 ms (  69.0% relative to mode=none)
## params: wal_level=replica mode=none pages=500 count=185 scale=20
(% are relative to "before")
before: tps  243.8 (100.0%), lat    45.361 ms (100.0%) (29 samples)
during: tps   72.0 ( 29.5%), lat   160.006 ms (352.7%) (66 samples)
 after: tps  233.7 ( 95.9%), lat    45.122 ms ( 99.5%) (55 samples)
DDL time:  65966 ms ( 100.0% relative to mode=none)
## params: wal_level=minimal mode=sync pages=500 count=185 scale=20
(% are relative to "before")
before: tps  241.8 (100.0%), lat    46.134 ms (100.0%) (29 samples)
during: tps  135.0 ( 55.9%), lat    90.905 ms (197.0%) (63 samples)
 after: tps  270.6 (111.9%), lat    39.766 ms ( 86.2%) (58 samples)
DDL time:  62494 ms (  94.7% relative to mode=none)
## params: wal_level=minimal mode=WAL pages=500 count=185 scale=20
(% are relative to "before")
before: tps  166.0 (100.0%), lat    71.909 ms (100.0%) (29 samples)
during: tps  104.5 ( 63.0%), lat   175.767 ms (244.4%) (55 samples)
 after: tps  154.6 ( 93.1%), lat   121.293 ms (168.7%) (66 samples)
DDL time:  54086 ms (  82.0% relative to mode=none)
## params: wal_level=replica mode=none pages=1000 count=118 scale=20
(% are relative to "before")
before: tps  260.6 (100.0%), lat    41.299 ms (100.0%) (29 samples)
during: tps   54.9 ( 21.1%), lat   237.027 ms (573.9%) (76 samples)
 after: tps  263.6 (101.1%), lat    41.954 ms (101.6%) (45 samples)
DDL time:  75496 ms ( 100.0% relative to mode=none)
## params: wal_level=minimal mode=sync pages=1000 count=118 scale=20
(% are relative to "before")
before: tps  219.8 (100.0%), lat    50.440 ms (100.0%) (29 samples)
during: tps  150.3 ( 68.4%), lat    70.372 ms (139.5%) (55 samples)
 after: tps  267.2 (121.5%), lat    39.785 ms ( 78.9%) (66 samples)
DDL time:  54412 ms (  72.1% relative to mode=none)
## params: wal_level=minimal mode=WAL pages=1000 count=118 scale=20
(% are relative to "before")
before: tps  224.2 (100.0%), lat    49.999 ms (100.0%) (29 samples)
during: tps   79.2 ( 35.3%), lat   227.462 ms (454.9%) (72 samples)
 after: tps  246.7 (110.1%), lat    78.495 ms (157.0%) (49 samples)
DDL time:  71758 ms (  95.0% relative to mode=none)
## params: wal_level=replica mode=none pages=2500 count=58 scale=20
(% are relative to "before")
before: tps  235.9 (100.0%), lat    45.647 ms (100.0%) (29 samples)
during: tps   44.5 ( 18.9%), lat   309.332 ms (677.7%) (87 samples)
 after: tps  265.6 (112.6%), lat    42.123 ms ( 92.3%) (64 samples)
DDL time:  86565 ms ( 100.0% relative to mode=none)
## params: wal_level=minimal mode=sync pages=2500 count=58 scale=20
(% are relative to "before")
before: tps  224.6 (100.0%), lat    48.433 ms (100.0%) (29 samples)
during: tps   96.4 ( 42.9%), lat   207.118 ms (427.6%) (65 samples)
 after: tps  260.7 (116.1%), lat    42.837 ms ( 88.4%) (86 samples)
DDL time:  64332 ms (  74.3% relative to mode=none)
## params: wal_level=minimal mode=WAL pages=2500 count=58 scale=20
(% are relative to "before")
before: tps  238.5 (100.0%), lat    51.151 ms (100.0%) (29 samples)
during: tps  111.4 ( 46.7%), lat   126.393 ms (247.1%) (71 samples)
 after: tps  274.4 (115.1%), lat    40.161 ms ( 78.5%) (80 samples)
DDL time:  70804 ms (  81.8% relative to mode=none)
## params: wal_level=replica mode=none pages=5000 count=32 scale=20
(% are relative to "before")
before: tps  248.8 (100.0%), lat    52.838 ms (100.0%) (29 samples)
during: tps   42.8 ( 17.2%), lat   358.860 ms (679.2%) (92 samples)
 after: tps  265.0 (106.5%), lat    50.268 ms ( 95.1%) (59 samples)
DDL time:  91258 ms ( 100.0% relative to mode=none)
## params: wal_level=minimal mode=sync pages=5000 count=32 scale=20
(% are relative to "before")
before: tps  243.8 (100.0%), lat    42.561 ms (100.0%) (29 samples)
during: tps  146.8 ( 60.2%), lat    92.972 ms (218.4%) (55 samples)
 after: tps  270.9 (111.1%), lat    39.125 ms ( 91.9%) (96 samples)
DDL time:  54922 ms (  60.2% relative to mode=none)
## params: wal_level=minimal mode=WAL pages=5000 count=32 scale=20
(% are relative to "before")
before: tps  226.7 (100.0%), lat    53.777 ms (100.0%) (29 samples)
during: tps  104.1 ( 45.9%), lat   260.554 ms (484.5%) (80 samples)
 after: tps  257.6 (113.7%), lat    47.419 ms ( 88.2%) (71 samples)
DDL time:  79389 ms (  87.0% relative to mode=none)
## params: wal_level=replica mode=none pages=10000 count=18 scale=20
(% are relative to "before")
before: tps  258.2 (100.0%), lat    41.087 ms (100.0%) (29 samples)
during: tps   38.6 ( 14.9%), lat   447.074 ms (1088.1%) (102 samples)
 after: tps  245.6 ( 95.1%), lat    53.516 ms (130.3%) (119 samples)
DDL time: 101724 ms ( 100.0% relative to mode=none)
## params: wal_level=minimal mode=sync pages=10000 count=18 scale=20
(% are relative to "before")
before: tps  246.6 (100.0%), lat    43.430 ms (100.0%) (29 samples)
during: tps  153.7 ( 62.3%), lat   187.624 ms (432.0%) (58 samples)
 after: tps  272.9 (110.7%), lat    38.546 ms ( 88.8%) (163 samples)
DDL time:  57553 ms (  56.6% relative to mode=none)
## params: wal_level=minimal mode=WAL pages=10000 count=18 scale=20
(% are relative to "before")
before: tps  244.5 (100.0%), lat    46.904 ms (100.0%) (29 samples)
during: tps  108.2 ( 44.3%), lat   382.168 ms (814.8%) (85 samples)
 after: tps  264.8 (108.3%), lat    40.084 ms ( 85.5%) (136 samples)
DDL time:  84637 ms (  83.2% relative to mode=none)
## params: wal_level=replica mode=none pages=100 count=2250 scale=20
(% are relative to "before")
before: tps 3195.7 (100.0%), lat     3.131 ms (100.0%) (29 samples)
during: tps  920.4 ( 28.8%), lat    11.823 ms (377.6%) (82 samples)
 after: tps  994.9 ( 31.1%), lat    10.098 ms (322.5%) (39 samples)
DDL time:  81774 ms ( 100.0% relative to mode=none)
## params: wal_level=minimal mode=sync pages=100 count=2250 scale=20
(% are relative to "before")
before: tps 3139.4 (100.0%), lat     3.202 ms (100.0%) (29 samples)
during: tps 1079.9 ( 34.4%), lat    10.023 ms (313.0%) (103 samples)
 after: tps 1082.6 ( 34.5%), lat     9.251 ms (288.9%) (18 samples)
DDL time: 102527 ms ( 125.4% relative to mode=none)
## params: wal_level=minimal mode=WAL pages=100 count=2250 scale=20
(% are relative to "before")
before: tps 3153.6 (100.0%), lat     3.186 ms (100.0%) (29 samples)
during: tps 1118.2 ( 35.5%), lat     9.685 ms (304.0%) (61 samples)
 after: tps 1068.3 ( 33.9%), lat     9.380 ms (294.4%) (60 samples)
DDL time:  61000 ms (  74.6% relative to mode=none)
## params: wal_level=replica mode=none pages=250 count=1162 scale=20
(% are relative to "before")
before: tps 2904.6 (100.0%), lat     3.738 ms (100.0%) (29 samples)
during: tps  769.3 ( 26.5%), lat    13.103 ms (350.5%) (89 samples)
 after: tps  959.0 ( 33.0%), lat    10.472 ms (280.1%) (32 samples)
DDL time:  88951 ms ( 100.0% relative to mode=none)
## params: wal_level=minimal mode=sync pages=250 count=1162 scale=20
(% are relative to "before")
before: tps 3088.2 (100.0%), lat     3.255 ms (100.0%) (29 samples)
during: tps 1070.3 ( 34.7%), lat    10.162 ms (312.2%) (86 samples)
 after: tps  951.5 ( 30.8%), lat    10.531 ms (323.5%) (35 samples)
DDL time:  85776 ms (  96.4% relative to mode=none)
## params: wal_level=minimal mode=WAL pages=250 count=1162 scale=20
(% are relative to "before")
before: tps 3166.3 (100.0%), lat     3.164 ms (100.0%) (29 samples)
during: tps 1097.6 ( 34.7%), lat     9.852 ms (311.4%) (69 samples)
 after: tps 1103.7 ( 34.9%), lat     9.102 ms (287.7%) (52 samples)
DDL time:  68087 ms (  76.5% relative to mode=none)
## params: wal_level=replica mode=none pages=500 count=564 scale=20
(% are relative to "before")
before: tps 2642.5 (100.0%), lat     4.441 ms (100.0%) (29 samples)
during: tps  771.6 ( 29.2%), lat    13.024 ms (293.3%) (85 samples)
 after: tps 1080.0 ( 40.9%), lat     9.387 ms (211.4%) (36 samples)
DDL time:  84847 ms ( 100.0% relative to mode=none)
## params: wal_level=minimal mode=sync pages=500 count=564 scale=20
(% are relative to "before")
before: tps 3160.6 (100.0%), lat     3.168 ms (100.0%) (29 samples)
during: tps 1126.9 ( 35.7%), lat     9.603 ms (303.1%) (73 samples)
 after: tps  969.8 ( 30.7%), lat    10.346 ms (326.6%) (48 samples)
DDL time:  72723 ms (  85.7% relative to mode=none)
## params: wal_level=minimal mode=WAL pages=500 count=564 scale=20
(% are relative to "before")
before: tps 3166.8 (100.0%), lat     3.162 ms (100.0%) (29 samples)
during: tps 1113.3 ( 35.2%), lat     9.749 ms (308.3%) (69 samples)
 after: tps 1092.7 ( 34.5%), lat     9.223 ms (291.7%) (52 samples)
DDL time:  68327 ms (  80.5% relative to mode=none)
## params: wal_level=replica mode=none pages=1000 count=297 scale=20
(% are relative to "before")
before: tps 2859.6 (100.0%), lat     3.796 ms (100.0%) (29 samples)
during: tps  779.9 ( 27.3%), lat    12.883 ms (339.3%) (85 samples)
 after: tps 1096.6 ( 38.3%), lat     9.201 ms (242.4%) (36 samples)
DDL time:  84030 ms ( 100.0% relative to mode=none)
## params: wal_level=minimal mode=sync pages=1000 count=297 scale=20
(% are relative to "before")
before: tps 3146.9 (100.0%), lat     3.183 ms (100.0%) (29 samples)
during: tps 1227.8 ( 39.0%), lat     8.992 ms (282.5%) (68 samples)
 after: tps  960.6 ( 30.5%), lat    10.439 ms (327.9%) (53 samples)
DDL time:  67220 ms (  80.0% relative to mode=none)
## params: wal_level=minimal mode=WAL pages=1000 count=297 scale=20
(% are relative to "before")
before: tps 3094.3 (100.0%), lat     3.257 ms (100.0%) (29 samples)
during: tps 1131.7 ( 36.6%), lat     9.705 ms (298.0%) (70 samples)
 after: tps 1111.3 ( 35.9%), lat     9.051 ms (277.9%) (51 samples)
DDL time:  69172 ms (  82.3% relative to mode=none)
## params: wal_level=replica mode=none pages=2500 count=123 scale=20
(% are relative to "before")
before: tps 2886.6 (100.0%), lat     3.933 ms (100.0%) (29 samples)
during: tps  776.1 ( 26.9%), lat    12.952 ms (329.3%) (85 samples)
 after: tps 1115.1 ( 38.6%), lat     9.036 ms (229.8%) (36 samples)
DDL time:  84141 ms ( 100.0% relative to mode=none)
## params: wal_level=minimal mode=sync pages=2500 count=123 scale=20
(% are relative to "before")
before: tps 3090.2 (100.0%), lat     3.270 ms (100.0%) (29 samples)
during: tps 1276.5 ( 41.3%), lat     8.850 ms (270.6%) (64 samples)
 after: tps  950.8 ( 30.8%), lat    10.529 ms (322.0%) (57 samples)
DDL time:  63655 ms (  75.7% relative to mode=none)
## params: wal_level=minimal mode=WAL pages=2500 count=123 scale=20
(% are relative to "before")
before: tps 3106.2 (100.0%), lat     3.234 ms (100.0%) (29 samples)
during: tps 1084.7 ( 34.9%), lat     9.834 ms (304.1%) (71 samples)
 after: tps 1099.4 ( 35.4%), lat     9.136 ms (282.5%) (50 samples)
DDL time:  70035 ms (  83.2% relative to mode=none)
## params: wal_level=replica mode=none pages=5000 count=63 scale=20
(% are relative to "before")
before: tps 2814.8 (100.0%), lat     4.044 ms (100.0%) (29 samples)
during: tps  761.5 ( 27.1%), lat    13.217 ms (326.8%) (85 samples)
 after: tps 1112.0 ( 39.5%), lat     9.084 ms (224.6%) (36 samples)
DDL time:  84752 ms ( 100.0% relative to mode=none)
## params: wal_level=minimal mode=sync pages=5000 count=63 scale=20
(% are relative to "before")
before: tps 3045.7 (100.0%), lat     3.311 ms (100.0%) (29 samples)
during: tps 1266.6 ( 41.6%), lat     8.760 ms (264.5%) (64 samples)
 after: tps 1008.6 ( 33.1%), lat     9.979 ms (301.3%) (57 samples)
DDL time:  63673 ms (  75.1% relative to mode=none)
## params: wal_level=minimal mode=WAL pages=5000 count=63 scale=20
(% are relative to "before")
before: tps 3166.9 (100.0%), lat     3.164 ms (100.0%) (29 samples)
during: tps 1102.2 ( 34.8%), lat     9.990 ms (315.8%) (72 samples)
 after: tps 1088.9 ( 34.4%), lat     9.295 ms (293.8%) (49 samples)
DDL time:  71449 ms (  84.3% relative to mode=none)
## params: wal_level=replica mode=none pages=10000 count=32 scale=20
(% are relative to "before")
before: tps 2311.3 (100.0%), lat     5.618 ms (100.0%) (29 samples)
during: tps  765.9 ( 33.1%), lat    13.198 ms (234.9%) (86 samples)
 after: tps 1050.8 ( 45.5%), lat     9.551 ms (170.0%) (35 samples)
DDL time:  85659 ms ( 100.0% relative to mode=none)
## params: wal_level=minimal mode=sync pages=10000 count=32 scale=20
(% are relative to "before")
before: tps 3119.4 (100.0%), lat     3.211 ms (100.0%) (29 samples)
during: tps 1237.8 ( 39.7%), lat     9.075 ms (282.7%) (64 samples)
 after: tps  978.9 ( 31.4%), lat    10.245 ms (319.1%) (57 samples)
DDL time:  63814 ms (  74.5% relative to mode=none)
## params: wal_level=minimal mode=WAL pages=10000 count=32 scale=20
(% are relative to "before")
before: tps 3095.1 (100.0%), lat     3.242 ms (100.0%) (29 samples)
during: tps 1118.0 ( 36.1%), lat    10.208 ms (314.9%) (73 samples)
 after: tps 1118.8 ( 36.1%), lat     9.006 ms (277.8%) (48 samples)
DDL time:  72242 ms (  84.3% relative to mode=none)
=====================================
Testset: hdd
	tps-repl	tps-sync	tps-wal	lat-repl	lat-sync	lat-wal	DDLtime-repl	DDLtime-sync	DDLtime-wal
100	54.7	54.7	64.0	206.8	165.4	154.9	30812.0	67581.0	25761.0
250	61.0	41.8	38.6	190.8	282.5	329.3	69459.0	88047.0	47951.0
500	29.5	55.9	63.0	352.7	197.0	244.4	65966.0	62494.0	54086.0
1000	21.1	68.4	35.3	573.9	139.5	454.9	75496.0	54412.0	71758.0
2500	18.9	42.9	46.7	677.7	427.6	247.1	86565.0	64332.0	70804.0
5000	17.2	60.2	45.9	679.2	218.4	484.5	91258.0	54922.0	79389.0
10000	14.9	62.3	44.3	1088.1	432.0	814.8	101724.0	57553.0	84637.0
Testset: ssd
	tps-repl	tps-sync	tps-wal	lat-repl	lat-sync	lat-wal	DDLtime-repl	DDLtime-sync	DDLtime-wal
100	28.8	34.4	35.5	377.6	313.0	304.0	81774.0	102527.0	61000.0
250	26.5	34.7	34.7	350.5	312.2	311.4	88951.0	85776.0	68087.0
500	29.2	35.7	35.2	293.3	303.1	308.3	84847.0	72723.0	68327.0
1000	27.3	39.0	36.6	339.3	282.5	298.0	84030.0	67220.0	69172.0
2500	26.9	41.3	34.9	329.3	270.6	304.1	84141.0	63655.0	70035.0
5000	27.1	41.6	34.8	326.8	264.5	315.8	84752.0	63673.0	71449.0
10000	33.1	39.7	36.1	234.9	282.7	314.9	85659.0	63814.0	72242.0
