Introduction

This is a report for the insert benchmark with 60M docs and 1 client(s). It is generated by scripts (bash, awk, sed) and Tufte might not be impressed. An overview of the insert benchmark is here and a short update is here. Below, by DBMS, I mean DBMS+version.config. An example is my8020.c10b40 where my means MySQL, 8020 is version 8.0.20 and c10b40 is the name for the configuration file.

The test server has a Beelink SER7 with 8 AMD cores, 32G RAM and an NVMe SSD. It is described here. The benchmark was run with 1 client and there were 1 or 3 connections per client (1 for queries or inserts without rate limits, 1+1 for rate limited inserts+deletes). It uses 1 table. It loads 60M rows per table without secondary indexes, creates 3 secondary indexes per table, then inserts 50m+50m rows per table with a delete per insert to avoid growing the table. It then does 6 read+write tests for 1800s each that do queries as fast as possible with 100,100,500,500,1000,1000 inserts/s and the same for deletes/s per client concurrent with the queries. The database is cached in memory. Clients and the DBMS share one server. The per-database configs are in the per-database subdirectories here.

The tested DBMS are:


Contents


Summary

The numbers are inserts/s for l.i0, l.i1 and l.i2, indexed docs (or rows) /s for l.x and queries/s for qr100, qp100 thru qr1000, qp1000" The values are the average rate over the entire test for inserts (IPS) and queries (QPS). The range of values for IPS and QPS is split into 3 parts: bottom 25%, middle 50%, top 25%. Values in the bottom 25% have a red background, values in the top 25% have a green background and values in the middle have no color. A gray background is used for values that can be ignored because the DBMS did not sustain the target insert rate. Red backgrounds are not used when the minimum value is within 80% of the max value.

dbmsl.i0l.xl.i1l.i2qr100qp100qr500qp500qr1000qp1000
fbmy5635_rel_202104072149.cza1_ser7 2173911986767168425189373568763110688851027080
fbmy5635_rel_202203072101.cza1_ser7 2135231986767029925189389767823777673837626819
fbmy5635_rel_202205192101.cza1_ser7 2105261973696932424450462266673690667637606822
fbmy5635_rel_202208092101.cza1_ser7 2083331973696920424450405366393652670036466900
fbmy5635_rel_202210112144.cza1_ser7 2105261980206884724154544969394331690436116911
fbmy5635_rel_202302162102.cza1_ser7 2040821986767054724450328668323858670638017083
fbmy5635_rel_202304122154.cza1_ser7 2083331993367042224450316468823596684633097019
fbmy5635_rel_202305292102.cza1_ser7 2076121980206932424272386067243168676137006949
fbmy5635_rel_20230529_832.cza1_ser7 2076122000007017524570362369493696676330157025
fbmy5635_rel_20230529_843.cza1_ser7 2068961993367079624272356966513269672038626862
fbmy5635_rel_20230529_850.cza1_ser7 2068961973697067124390442268113878689234287052
fbmy5635_rel_221222.cza1_ser7 2068961941756956524038242568623462678935777020

This table has relative throughput, throughput for the DBMS relative to the DBMS in the first line, using the absolute throughput from the previous table. Values less than 0.95 have a yellow background. Values greater than 1.05 have a blue background.

dbmsl.i0l.xl.i1l.i2qr100qp100qr500qp500qr1000qp1000
fbmy5635_rel_202104072149.cza1_ser7 1.001.001.001.001.001.001.001.001.001.00
fbmy5635_rel_202203072101.cza1_ser7 0.981.000.981.001.040.991.210.980.740.96
fbmy5635_rel_202205192101.cza1_ser7 0.970.990.970.971.240.971.190.970.740.96
fbmy5635_rel_202208092101.cza1_ser7 0.960.990.970.971.090.971.170.970.710.97
fbmy5635_rel_202210112144.cza1_ser7 0.971.000.960.961.461.011.391.000.710.98
fbmy5635_rel_202302162102.cza1_ser7 0.941.000.980.970.880.991.240.970.751.00
fbmy5635_rel_202304122154.cza1_ser7 0.961.000.980.970.851.001.160.990.650.99
fbmy5635_rel_202305292102.cza1_ser7 0.961.000.970.961.030.981.020.980.730.98
fbmy5635_rel_20230529_832.cza1_ser7 0.961.010.980.980.971.011.190.980.590.99
fbmy5635_rel_20230529_843.cza1_ser7 0.951.000.990.960.960.971.050.980.760.97
fbmy5635_rel_20230529_850.cza1_ser7 0.950.990.990.971.180.991.251.000.671.00
fbmy5635_rel_221222.cza1_ser7 0.950.980.970.950.651.001.110.990.700.99

This lists the average rate of inserts/s for the tests that do inserts concurrent with queries. For such tests the query rate is listed in the table above. The read+write tests are setup so that the insert rate should match the target rate every second. Cells that are not at least 95% of the target have a red background to indicate a failure to satisfy the target.

dbmsqr100.L1qp100.L2qr500.L3qp500.L4qr1000.L5qp1000.L6
fbmy5635_rel_202104072149.cza1_ser7100100499499998998
fbmy5635_rel_202203072101.cza1_ser7100100499499998998
fbmy5635_rel_202205192101.cza1_ser7100100499499998998
fbmy5635_rel_202208092101.cza1_ser7100100499499998998
fbmy5635_rel_202210112144.cza1_ser7100100499499998998
fbmy5635_rel_202302162102.cza1_ser7100100499499998998
fbmy5635_rel_202304122154.cza1_ser7100100499499998998
fbmy5635_rel_202305292102.cza1_ser7100100499499998998
fbmy5635_rel_20230529_832.cza1_ser7100100499499998998
fbmy5635_rel_20230529_843.cza1_ser7100100499499998998
fbmy5635_rel_20230529_850.cza1_ser7100100499499998998
fbmy5635_rel_221222.cza1_ser7100100499499998998
target10010050050010001000

l.i0

l.i0: load without secondary indexes. Graphs for performance per 1-second interval are here.

Average throughput:

Image

Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For the max column values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
fbmy5635_rel_202104072149.cza1_ser799.8710.0810.045nonzero0.0030.107
fbmy5635_rel_202203072101.cza1_ser799.8770.0730.046nonzero0.0030.110
fbmy5635_rel_202205192101.cza1_ser799.8730.0770.046nonzero0.0030.119
fbmy5635_rel_202208092101.cza1_ser799.8800.0690.0470.0030.108
fbmy5635_rel_202210112144.cza1_ser799.8730.0760.047nonzero0.0030.115
fbmy5635_rel_202302162102.cza1_ser799.8630.0850.048nonzero0.0030.106
fbmy5635_rel_202304122154.cza1_ser799.8830.0670.046nonzero0.0030.130
fbmy5635_rel_202305292102.cza1_ser799.8740.0750.0480.0030.109
fbmy5635_rel_20230529_832.cza1_ser799.8740.0750.046nonzero0.0030.102
fbmy5635_rel_20230529_843.cza1_ser799.8710.0770.048nonzero0.0030.119
fbmy5635_rel_20230529_850.cza1_ser799.8720.0770.047nonzero0.0030.118
fbmy5635_rel_221222.cza1_ser799.8730.0750.048nonzero0.0030.114

Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
217391	0	0	0.0	102.7	37.7	0.000	0.000	0.000	0.178	22519	11.0	0.104	4	1.8	3.2	0.3	0.107	218776	193283	fbmy5635_rel_202104072149.cza1_ser7
213523	0	0	0.0	99.3	37.2	0.000	0.000	0.000	0.179	22270	11.1	0.104	4	1.8	3.2	0.3	0.110	215784	188598	fbmy5635_rel_202203072101.cza1_ser7
210526	0	0	0.0	97.3	36.7	0.000	0.000	0.000	0.179	21928	10.9	0.104	4	1.8	3.2	0.3	0.119	212062	182798	fbmy5635_rel_202205192101.cza1_ser7
208333	0	0	0.0	98.1	36.2	0.000	0.000	0.000	0.178	21545	10.9	0.103	4	1.8	3.2	0.3	0.108	209502	184886	fbmy5635_rel_202208092101.cza1_ser7
210526	0	0	0.0	99.1	36.5	0.000	0.000	0.000	0.178	21912	10.9	0.104	4	1.8	3.2	0.3	0.115	210963	184806	fbmy5635_rel_202210112144.cza1_ser7
204082	0	0	0.0	94.5	35.6	0.000	0.000	0.000	0.179	21369	10.8	0.105	4	1.8	3.2	0.3	0.106	205576	181003	fbmy5635_rel_202302162102.cza1_ser7
208333	0	0	0.0	97.0	36.4	0.000	0.000	0.000	0.179	21743	11.0	0.104	4	1.8	3.2	0.3	0.130	210763	182703	fbmy5635_rel_202304122154.cza1_ser7
207612	0	0	0.0	97.3	36.2	0.000	0.000	0.000	0.179	21549	10.9	0.104	4	1.8	3.2	0.3	0.109	209366	186391	fbmy5635_rel_202305292102.cza1_ser7
207612	0	0	0.0	97.2	36.1	0.000	0.000	0.000	0.178	21553	10.9	0.104	4	1.8	3.2	0.3	0.102	208265	182578	fbmy5635_rel_20230529_832.cza1_ser7
206896	0	0	0.0	97.1	36.1	0.000	0.000	0.000	0.179	21562	10.8	0.104	4	1.8	3.2	0.3	0.119	208572	183994	fbmy5635_rel_20230529_843.cza1_ser7
206896	0	0	0.0	96.3	35.8	0.000	0.000	0.000	0.177	21486	10.8	0.104	4	1.8	3.2	0.3	0.118	207572	182405	fbmy5635_rel_20230529_850.cza1_ser7
206896	0	0	0.0	96.2	35.9	0.000	0.000	0.000	0.177	21625	10.9	0.105	4	1.8	3.2	0.3	0.114	207983	179297	fbmy5635_rel_221222.cza1_ser7

l.x

l.x: create secondary indexes.

Average throughput:

Image

Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
198676	0	0	0.0	79.8	30.8	0.000	0.000	0.000	0.158	199	5.9	0.001	2	4.0	5.4	3.6	0.001	NA	NA	fbmy5635_rel_202104072149.cza1_ser7
198676	0	0	0.0	78.6	31.6	0.000	0.000	0.000	0.163	218	5.9	0.001	2	4.0	5.4	3.9	0.002	NA	NA	fbmy5635_rel_202203072101.cza1_ser7
197369	0	0	0.0	78.4	31.2	0.000	0.000	0.000	0.162	204	5.9	0.001	2	4.0	5.4	3.9	0.001	NA	NA	fbmy5635_rel_202205192101.cza1_ser7
197369	0	0	0.0	79.1	31.3	0.000	0.000	0.000	0.162	987	5.9	0.005	2	4.0	5.4	3.9	0.002	NA	NA	fbmy5635_rel_202208092101.cza1_ser7
198020	0	0	0.0	79.8	31.5	0.000	0.000	0.000	0.163	955	5.8	0.005	2	4.0	5.4	3.9	0.001	NA	NA	fbmy5635_rel_202210112144.cza1_ser7
198676	0	0	0.0	78.3	31.5	0.000	0.000	0.000	0.162	184	5.9	0.001	2	4.0	5.4	3.9	0.001	NA	NA	fbmy5635_rel_202302162102.cza1_ser7
199336	0	0	0.0	79.5	31.8	0.000	0.000	0.000	0.163	183	5.9	0.001	2	4.0	5.4	3.9	0.001	NA	NA	fbmy5635_rel_202304122154.cza1_ser7
198020	0	0	0.0	78.8	31.4	0.000	0.000	0.000	0.163	217	5.9	0.001	2	4.0	5.4	3.9	0.001	NA	NA	fbmy5635_rel_202305292102.cza1_ser7
200000	0	0	0.0	79.5	31.7	0.000	0.000	0.000	0.162	208	5.9	0.001	2	4.0	5.4	3.6	0.001	NA	NA	fbmy5635_rel_20230529_832.cza1_ser7
199336	0	0	0.0	80.1	31.7	0.000	0.000	0.000	0.163	297	5.9	0.001	2	4.0	5.4	3.9	0.001	NA	NA	fbmy5635_rel_20230529_843.cza1_ser7
197369	0	0	0.0	78.9	31.3	0.000	0.000	0.000	0.163	220	5.9	0.001	2	4.0	5.4	3.9	0.001	NA	NA	fbmy5635_rel_20230529_850.cza1_ser7
194175	0	0	0.0	77.5	30.8	0.000	0.000	0.000	0.162	208	5.9	0.001	2	4.0	5.4	4.0	0.002	NA	NA	fbmy5635_rel_221222.cza1_ser7

l.i1

l.i1: continue load after secondary indexes created with 50 inserts per transaction. Graphs for performance per 1-second interval are here.

Average throughput:

Image

Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For the max column values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
fbmy5635_rel_202104072149.cza1_ser799.1020.8250.068nonzero0.0040.101
fbmy5635_rel_202203072101.cza1_ser798.9910.9350.0690.0010.0040.098
fbmy5635_rel_202205192101.cza1_ser798.8521.0730.071nonzero0.0040.102
fbmy5635_rel_202208092101.cza1_ser798.8491.0770.070nonzero0.0040.137
fbmy5635_rel_202210112144.cza1_ser798.8291.0960.0700.0010.0040.133
fbmy5635_rel_202302162102.cza1_ser799.1760.7510.0680.0010.0040.099
fbmy5635_rel_202304122154.cza1_ser799.2420.6850.069nonzero0.0040.095
fbmy5635_rel_202305292102.cza1_ser799.1330.7930.0700.0010.0040.095
fbmy5635_rel_20230529_832.cza1_ser799.1560.7700.0690.0010.0040.098
fbmy5635_rel_20230529_843.cza1_ser799.0860.8410.0680.0010.0040.098
fbmy5635_rel_20230529_850.cza1_ser798.9440.9820.0690.0010.0040.108
fbmy5635_rel_221222.cza1_ser798.8441.0810.0700.0010.0040.101

Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For the max column values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
fbmy5635_rel_202104072149.cza1_ser799.1700.7510.0720.0040.0040.101
fbmy5635_rel_202203072101.cza1_ser799.1300.7870.0740.0040.0040.097
fbmy5635_rel_202205192101.cza1_ser798.9950.9230.0750.0030.0040.102
fbmy5635_rel_202208092101.cza1_ser798.9900.9280.0750.0030.0040.137
fbmy5635_rel_202210112144.cza1_ser799.0280.8890.0760.0050.0040.132
fbmy5635_rel_202302162102.cza1_ser799.2500.6720.0720.0020.0040.099
fbmy5635_rel_202304122154.cza1_ser799.3290.5930.0720.0020.0040.095
fbmy5635_rel_202305292102.cza1_ser799.2620.6590.0720.0030.0040.095
fbmy5635_rel_20230529_832.cza1_ser799.2050.7140.0730.0030.0040.098
fbmy5635_rel_20230529_843.cza1_ser799.1940.7250.0740.0040.0040.098
fbmy5635_rel_20230529_850.cza1_ser799.0280.8900.0740.0040.0040.108
fbmy5635_rel_221222.cza1_ser798.9970.9210.0730.0040.0040.102

Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
71684	0	32	4.0	385.7	156.4	0.000	0.058	0.005	2.234	34387	24.4	0.480	27	5.0	5.5	8.1	0.101	72671	58737	fbmy5635_rel_202104072149.cza1_ser7
70299	0	32	4.0	374.2	153.1	0.000	0.058	0.005	2.230	33994	24.8	0.484	28	5.3	5.7	8.3	0.098	71549	58187	fbmy5635_rel_202203072101.cza1_ser7
69324	0	31	3.9	372.8	152.9	0.000	0.058	0.005	2.259	33686	24.9	0.486	29	5.1	5.5	8.5	0.102	70070	56989	fbmy5635_rel_202205192101.cza1_ser7
69204	0	31	3.9	381.9	155.0	0.000	0.058	0.006	2.293	33617	24.9	0.486	29	5.1	5.5	8.5	0.137	69875	58740	fbmy5635_rel_202208092101.cza1_ser7
68847	0	31	3.9	370.6	151.5	0.000	0.057	0.005	2.254	33430	24.9	0.486	29	5.0	5.4	8.5	0.133	69524	57239	fbmy5635_rel_202210112144.cza1_ser7
70547	0	32	4.0	343.1	136.4	0.000	0.058	0.005	1.980	33227	24.2	0.471	27	5.3	5.8	6.2	0.099	70872	59136	fbmy5635_rel_202302162102.cza1_ser7
70422	0	32	4.0	342.5	136.5	0.000	0.058	0.005	1.986	33079	24.1	0.470	27	5.6	6.1	6.3	0.095	70723	60334	fbmy5635_rel_202304122154.cza1_ser7
69324	0	31	3.9	334.2	133.4	0.000	0.058	0.005	1.971	32509	24.7	0.469	29	4.9	5.3	6.4	0.095	69426	59032	fbmy5635_rel_202305292102.cza1_ser7
70175	0	32	3.9	344.0	137.7	0.000	0.057	0.005	2.009	32889	24.3	0.469	28	4.7	5.2	6.5	0.098	70221	59784	fbmy5635_rel_20230529_832.cza1_ser7
70796	0	32	4.0	373.0	150.6	0.000	0.058	0.005	2.179	33833	25.6	0.478	29	4.8	5.2	6.6	0.098	71571	59336	fbmy5635_rel_20230529_843.cza1_ser7
70671	0	924	4.0	368.5	147.8	0.013	0.057	0.005	2.141	35310	25.6	0.500	29	5.3	5.7	6.6	0.108	71363	57991	fbmy5635_rel_20230529_850.cza1_ser7
69565	0	683	3.9	361.9	145.5	0.010	0.057	0.005	2.142	34366	25.1	0.494	29	4.9	5.3	6.7	0.101	69880	57336	fbmy5635_rel_221222.cza1_ser7

l.i2

l.i2: continue load after secondary indexes created with 5 inserts per transaction. Graphs for performance per 1-second interval are here.

Average throughput:

Image

Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For the max column values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
fbmy5635_rel_202104072149.cza1_ser799.8090.1700.0010.019nonzerononzero0.094
fbmy5635_rel_202203072101.cza1_ser799.7970.1820.0010.019nonzero0.0010.083
fbmy5635_rel_202205192101.cza1_ser799.7590.2200.0010.020nonzerononzero0.087
fbmy5635_rel_202208092101.cza1_ser799.7850.1940.0010.020nonzerononzero0.103
fbmy5635_rel_202210112144.cza1_ser799.7660.2120.0010.0200.001nonzero0.100
fbmy5635_rel_202302162102.cza1_ser799.7800.1990.0010.0190.001nonzero0.093
fbmy5635_rel_202304122154.cza1_ser799.7780.2010.0010.020nonzerononzero0.086
fbmy5635_rel_202305292102.cza1_ser799.7850.1940.0010.020nonzerononzero0.087
fbmy5635_rel_20230529_832.cza1_ser799.7930.1860.0010.020nonzerononzero0.084
fbmy5635_rel_20230529_843.cza1_ser799.7740.2040.0010.020nonzerononzero0.093
fbmy5635_rel_20230529_850.cza1_ser799.7680.2110.0010.019nonzerononzero0.083
fbmy5635_rel_221222.cza1_ser799.7930.1850.0010.0200.001nonzero0.087

Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For the max column values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
fbmy5635_rel_202104072149.cza1_ser799.3990.5780.0020.020nonzerononzero0.094
fbmy5635_rel_202203072101.cza1_ser799.4900.4880.0010.020nonzero0.0010.083
fbmy5635_rel_202205192101.cza1_ser799.2670.711nonzero0.020nonzerononzero0.087
fbmy5635_rel_202208092101.cza1_ser799.2830.6950.0010.020nonzerononzero0.104
fbmy5635_rel_202210112144.cza1_ser799.3230.6540.0010.0210.001nonzero0.100
fbmy5635_rel_202302162102.cza1_ser799.3330.6450.0010.0200.001nonzero0.094
fbmy5635_rel_202304122154.cza1_ser799.3150.6630.0010.020nonzerononzero0.086
fbmy5635_rel_202305292102.cza1_ser799.2580.7200.0010.020nonzerononzero0.088
fbmy5635_rel_20230529_832.cza1_ser799.4260.5520.0010.020nonzerononzero0.084
fbmy5635_rel_20230529_843.cza1_ser799.2570.7210.0010.020nonzerononzero0.093
fbmy5635_rel_20230529_850.cza1_ser799.2910.6870.0010.020nonzerononzero0.084
fbmy5635_rel_221222.cza1_ser799.2300.7480.0010.0210.001nonzero0.087

Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
25189	0	0	0.0	269.5	97.1	0.000	0.000	0.011	3.949	104574	20.3	4.152	64	4.2	4.4	10.1	0.094	25136	21951	fbmy5635_rel_202104072149.cza1_ser7
25189	0	0	0.0	260.6	93.7	0.000	0.000	0.010	3.808	104261	20.5	4.139	65	4.2	4.4	10.3	0.083	25332	22390	fbmy5635_rel_202203072101.cza1_ser7
24450	0	0	0.0	268.3	95.8	0.000	0.000	0.011	4.012	101664	20.4	4.158	67	4.3	4.4	10.3	0.087	24518	21801	fbmy5635_rel_202205192101.cza1_ser7
24450	0	0	0.0	258.2	92.0	0.000	0.000	0.011	3.854	101671	20.4	4.158	67	4.6	4.7	10.1	0.103	24484	21221	fbmy5635_rel_202208092101.cza1_ser7
24154	0	0	0.0	259.7	92.4	0.000	0.000	0.011	3.919	100243	20.5	4.150	68	4.4	4.5	10.3	0.100	24224	21570	fbmy5635_rel_202210112144.cza1_ser7
24450	0	0	0.0	231.3	85.6	0.000	0.000	0.009	3.583	101265	20.2	4.142	66	4.2	4.4	7.6	0.093	24503	22063	fbmy5635_rel_202302162102.cza1_ser7
24450	0	0	0.0	236.7	87.2	0.000	0.000	0.010	3.652	101509	20.2	4.152	66	4.4	4.5	7.6	0.086	24513	21894	fbmy5635_rel_202304122154.cza1_ser7
24272	0	0	0.0	214.8	79.1	0.000	0.000	0.009	3.336	100144	20.2	4.126	67	4.4	4.5	7.4	0.087	24366	21666	fbmy5635_rel_202305292102.cza1_ser7
24570	0	0	0.0	234.6	86.8	0.000	0.000	0.010	3.619	101746	20.1	4.141	65	4.4	4.6	7.8	0.084	24593	22251	fbmy5635_rel_20230529_832.cza1_ser7
24272	0	0	0.0	231.7	86.2	0.000	0.000	0.010	3.637	100374	20.3	4.135	67	4.4	4.6	8.0	0.093	24264	21551	fbmy5635_rel_20230529_843.cza1_ser7
24390	0	0	0.0	234.6	86.4	0.000	0.000	0.010	3.626	101035	20.4	4.142	67	4.2	4.4	7.9	0.083	24504	21666	fbmy5635_rel_20230529_850.cza1_ser7
24038	0	0	0.0	241.3	88.6	0.000	0.000	0.010	3.773	100168	20.4	4.167	68	4.4	4.6	8.0	0.087	24170	21377	fbmy5635_rel_221222.cza1_ser7

qr100.L1

qr100.L1: range queries with 100 insert/s per client. Graphs for performance per 1-second interval are here.

Average throughput:

Image

Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
fbmy5635_rel_202104072149.cza1_ser770.77819.04410.179nonzerononzero0.038
fbmy5635_rel_202203072101.cza1_ser773.90421.5644.532nonzerononzero0.036
fbmy5635_rel_202205192101.cza1_ser766.64533.3540.001nonzerononzero0.039
fbmy5635_rel_202208092101.cza1_ser768.68930.1071.204nonzerononzero0.040
fbmy5635_rel_202210112144.cza1_ser786.76913.2260.0050.002
fbmy5635_rel_202302162102.cza1_ser766.84519.83113.324nonzero0.038
fbmy5635_rel_202304122154.cza1_ser766.63329.8353.532nonzero0.038
fbmy5635_rel_202305292102.cza1_ser777.03622.9380.0260.002
fbmy5635_rel_20230529_832.cza1_ser766.70830.4082.8840.003
fbmy5635_rel_20230529_843.cza1_ser766.62629.9133.461nonzero0.035
fbmy5635_rel_20230529_850.cza1_ser776.64423.1710.185nonzero0.039
fbmy5635_rel_221222.cza1_ser766.50626.7376.757nonzero0.039

Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
fbmy5635_rel_202104072149.cza1_ser76.13993.6110.2500.008
fbmy5635_rel_202203072101.cza1_ser72.19497.5560.2500.008
fbmy5635_rel_202205192101.cza1_ser72.08397.5830.3330.008
fbmy5635_rel_202208092101.cza1_ser71.38998.1940.4170.009
fbmy5635_rel_202210112144.cza1_ser712.58387.0830.3330.008
fbmy5635_rel_202302162102.cza1_ser70.97298.5000.5280.008
fbmy5635_rel_202304122154.cza1_ser72.13997.3890.4720.008
fbmy5635_rel_202305292102.cza1_ser72.66796.9440.3890.008
fbmy5635_rel_20230529_832.cza1_ser74.25095.4720.2780.008
fbmy5635_rel_20230529_843.cza1_ser72.50097.0000.5000.009
fbmy5635_rel_20230529_850.cza1_ser73.47296.0280.5000.008
fbmy5635_rel_221222.cza1_ser74.30695.3890.3060.015

Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
fbmy5635_rel_202104072149.cza1_ser77.13992.5830.2780.008
fbmy5635_rel_202203072101.cza1_ser711.11188.6110.2780.008
fbmy5635_rel_202205192101.cza1_ser75.61194.0830.3060.008
fbmy5635_rel_202208092101.cza1_ser74.97294.6940.3330.008
fbmy5635_rel_202210112144.cza1_ser77.25092.4170.3330.008
fbmy5635_rel_202302162102.cza1_ser72.86196.6940.4440.008
fbmy5635_rel_202304122154.cza1_ser71.69497.9720.3330.008
fbmy5635_rel_202305292102.cza1_ser717.47282.2500.2780.008
fbmy5635_rel_20230529_832.cza1_ser75.91793.7500.3330.008
fbmy5635_rel_20230529_843.cza1_ser75.41794.1390.4440.008
fbmy5635_rel_20230529_850.cza1_ser77.69491.9170.3890.008
fbmy5635_rel_221222.cza1_ser78.05691.6390.3060.015

Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
100	3735	0	0.0	4.7	0.5	0.000	0.000	0.047	5.304	14413	5.8	3.859	124	4.2	4.2	10.4	0.038	3739	3483	fbmy5635_rel_202104072149.cza1_ser7
100	3897	0	0.0	4.7	0.5	0.000	0.000	0.047	5.322	15026	5.8	3.856	119	4.2	4.2	10.6	0.036	3884	3578	fbmy5635_rel_202203072101.cza1_ser7
100	4622	0	0.0	5.0	0.6	0.000	0.000	0.051	6.575	17792	5.8	3.849	100	4.1	4.2	10.7	0.039	4601	4379	fbmy5635_rel_202205192101.cza1_ser7
100	4053	0	0.0	7.3	0.7	0.000	0.000	0.073	7.385	15648	5.8	3.861	114	4.1	4.2	10.5	0.040	4058	3868	fbmy5635_rel_202208092101.cza1_ser7
100	5449	0	0.0	6.6	0.5	0.000	0.000	0.067	5.131	20951	5.8	3.845	85	4.2	4.2	10.6	0.002	5433	5033	fbmy5635_rel_202210112144.cza1_ser7
100	3286	0	0.0	4.8	0.6	0.000	0.000	0.049	5.832	12700	6.0	3.865	146	4.2	4.2	7.9	0.038	3293	2988	fbmy5635_rel_202302162102.cza1_ser7
100	3164	0	0.0	4.6	0.5	0.000	0.000	0.046	4.918	12238	6.1	3.868	154	4.2	4.2	8.1	0.038	3179	2891	fbmy5635_rel_202304122154.cza1_ser7
100	3860	0	0.0	4.5	0.5	0.000	0.000	0.045	4.869	14883	5.8	3.855	120	4.2	4.2	7.8	0.002	3868	3580	fbmy5635_rel_202305292102.cza1_ser7
100	3623	0	0.0	4.5	0.5	0.000	0.000	0.046	4.998	13979	5.8	3.859	128	4.2	4.2	8.1	0.003	3612	3420	fbmy5635_rel_20230529_832.cza1_ser7
100	3569	0	0.0	4.4	0.4	0.000	0.000	0.044	4.544	13772	5.8	3.859	130	4.1	4.2	8.4	0.035	3579	3292	fbmy5635_rel_20230529_843.cza1_ser7
100	4422	0	0.0	5.2	0.7	0.000	0.000	0.052	7.041	17044	5.8	3.854	105	4.1	4.1	8.2	0.039	4394	4172	fbmy5635_rel_20230529_850.cza1_ser7
100	2425	0	0.0	4.6	0.5	0.000	0.000	0.046	4.996	9407	6.6	3.879	218	4.2	4.2	8.6	0.039	2429	2254	fbmy5635_rel_221222.cza1_ser7

qp100.L2

qp100.L2: point queries with 100 insert/s per client. Graphs for performance per 1-second interval are here.

Average throughput:

Image

Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
fbmy5635_rel_202104072149.cza1_ser799.8470.153nonzero0.003
fbmy5635_rel_202203072101.cza1_ser799.8040.196nonzero0.001
fbmy5635_rel_202205192101.cza1_ser799.7890.211nonzero0.002
fbmy5635_rel_202208092101.cza1_ser799.8010.199nonzero0.001
fbmy5635_rel_202210112144.cza1_ser799.8160.184nonzero0.001
fbmy5635_rel_202302162102.cza1_ser799.7640.236nonzero0.001
fbmy5635_rel_202304122154.cza1_ser799.8290.171nonzero0.001
fbmy5635_rel_202305292102.cza1_ser799.7570.243nonzero0.001
fbmy5635_rel_20230529_832.cza1_ser799.8160.184nonzero0.001
fbmy5635_rel_20230529_843.cza1_ser799.7430.257nonzero0.001
fbmy5635_rel_20230529_850.cza1_ser799.7750.225nonzero0.001
fbmy5635_rel_221222.cza1_ser799.8000.200nonzero0.001

Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
fbmy5635_rel_202104072149.cza1_ser74.75094.9170.3330.008
fbmy5635_rel_202203072101.cza1_ser75.00094.6390.3610.008
fbmy5635_rel_202205192101.cza1_ser73.97295.6940.3330.010
fbmy5635_rel_202208092101.cza1_ser72.88996.7220.3890.008
fbmy5635_rel_202210112144.cza1_ser72.63996.9720.3890.009
fbmy5635_rel_202302162102.cza1_ser72.25097.3610.3890.008
fbmy5635_rel_202304122154.cza1_ser76.91792.6940.3890.014
fbmy5635_rel_202305292102.cza1_ser76.72292.9440.3330.008
fbmy5635_rel_20230529_832.cza1_ser79.83389.8330.3330.008
fbmy5635_rel_20230529_843.cza1_ser72.27897.3060.4170.012
fbmy5635_rel_20230529_850.cza1_ser71.83397.7220.4440.008
fbmy5635_rel_221222.cza1_ser75.80693.8890.3060.009

Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
fbmy5635_rel_202104072149.cza1_ser77.36192.3330.3060.008
fbmy5635_rel_202203072101.cza1_ser73.33396.3060.3610.008
fbmy5635_rel_202205192101.cza1_ser72.19497.5280.2780.010
fbmy5635_rel_202208092101.cza1_ser72.50097.2220.2780.008
fbmy5635_rel_202210112144.cza1_ser73.41796.2780.3060.008
fbmy5635_rel_202302162102.cza1_ser75.30694.3610.3330.008
fbmy5635_rel_202304122154.cza1_ser76.27893.3060.4170.013
fbmy5635_rel_202305292102.cza1_ser73.69496.0000.3060.008
fbmy5635_rel_20230529_832.cza1_ser76.55693.1940.2500.008
fbmy5635_rel_20230529_843.cza1_ser74.08395.5830.3330.012
fbmy5635_rel_20230529_850.cza1_ser72.55697.0560.3890.009
fbmy5635_rel_221222.cza1_ser78.55691.1670.2780.008

Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
100	6876	0	0.0	4.9	0.7	0.000	0.000	0.049	7.042	27684	6.6	4.026	77	4.1	4.2	13.7	0.003	6630	6009	fbmy5635_rel_202104072149.cza1_ser7
100	6782	0	0.0	4.7	0.7	0.000	0.000	0.047	6.772	27285	6.2	4.023	73	4.2	4.2	14.0	0.001	6440	6153	fbmy5635_rel_202203072101.cza1_ser7
100	6667	0	0.0	4.3	0.5	0.000	0.000	0.043	5.205	26826	6.2	4.024	74	4.2	4.2	14.0	0.002	6345	5928	fbmy5635_rel_202205192101.cza1_ser7
100	6639	0	0.0	6.3	0.5	0.000	0.000	0.063	5.011	26739	6.3	4.028	76	4.2	4.2	13.8	0.001	6377	6121	fbmy5635_rel_202208092101.cza1_ser7
100	6939	0	0.0	6.4	0.5	0.000	0.000	0.064	5.422	27893	6.0	4.020	69	4.2	4.2	13.8	0.001	6535	5831	fbmy5635_rel_202210112144.cza1_ser7
100	6832	0	0.0	4.3	0.5	0.000	0.000	0.043	4.863	27472	6.3	4.021	74	4.2	4.3	11.0	0.001	6457	5897	fbmy5635_rel_202302162102.cza1_ser7
100	6882	0	0.0	4.6	0.6	0.000	0.000	0.046	5.942	27682	6.5	4.023	76	4.2	4.2	11.1	0.001	6517	6217	fbmy5635_rel_202304122154.cza1_ser7
100	6724	0	0.0	4.8	0.7	0.000	0.000	0.048	6.845	27045	6.7	4.022	80	4.1	4.2	10.8	0.001	6377	5832	fbmy5635_rel_202305292102.cza1_ser7
100	6949	0	0.0	4.6	0.6	0.000	0.000	0.046	6.074	27933	6.0	4.020	69	4.2	4.2	11.1	0.001	6535	6247	fbmy5635_rel_20230529_832.cza1_ser7
100	6651	0	0.0	4.3	0.5	0.000	0.000	0.043	4.846	26758	6.2	4.023	75	4.2	4.3	11.5	0.001	6297	5817	fbmy5635_rel_20230529_843.cza1_ser7
100	6811	0	0.0	4.2	0.4	0.000	0.000	0.042	4.350	27362	6.6	4.017	78	4.1	4.2	11.3	0.001	6407	6217	fbmy5635_rel_20230529_850.cza1_ser7
100	6862	0	0.0	4.6	0.6	0.000	0.000	0.046	5.697	27583	6.3	4.020	73	4.2	4.2	11.6	0.001	6489	6217	fbmy5635_rel_221222.cza1_ser7

qr500.L3

qr500.L3: range queries with 500 insert/s per client. Graphs for performance per 1-second interval are here.

Average throughput:

Image

Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
fbmy5635_rel_202104072149.cza1_ser766.63523.03210.333nonzerononzero0.035
fbmy5635_rel_202203072101.cza1_ser773.78422.0644.152nonzerononzero0.040
fbmy5635_rel_202205192101.cza1_ser766.61933.3720.009nonzero0.036
fbmy5635_rel_202208092101.cza1_ser771.69427.5190.787nonzerononzero0.041
fbmy5635_rel_202210112144.cza1_ser767.03232.9530.014nonzerononzero0.042
fbmy5635_rel_202302162102.cza1_ser773.66222.3054.034nonzerononzero0.034
fbmy5635_rel_202304122154.cza1_ser771.32122.2726.407nonzerononzero0.035
fbmy5635_rel_202305292102.cza1_ser766.77930.5092.712nonzerononzero0.034
fbmy5635_rel_20230529_832.cza1_ser773.50424.2782.218nonzerononzero0.040
fbmy5635_rel_20230529_843.cza1_ser769.52923.6946.777nonzerononzero0.039
fbmy5635_rel_20230529_850.cza1_ser770.18025.1664.655nonzero0.034
fbmy5635_rel_221222.cza1_ser776.80319.1264.072nonzerononzero0.034

Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
fbmy5635_rel_202104072149.cza1_ser78.26191.5280.2110.009
fbmy5635_rel_202203072101.cza1_ser723.68976.1670.1440.008
fbmy5635_rel_202205192101.cza1_ser73.11196.7170.1720.008
fbmy5635_rel_202208092101.cza1_ser79.63990.2610.1000.008
fbmy5635_rel_202210112144.cza1_ser74.12895.7000.1720.009
fbmy5635_rel_202302162102.cza1_ser719.73980.0890.1720.008
fbmy5635_rel_202304122154.cza1_ser710.11189.7170.1720.008
fbmy5635_rel_202305292102.cza1_ser73.41196.3830.2060.008
fbmy5635_rel_20230529_832.cza1_ser76.21193.6110.1780.008
fbmy5635_rel_20230529_843.cza1_ser73.42896.3890.1830.008
fbmy5635_rel_20230529_850.cza1_ser74.88994.8890.2220.011
fbmy5635_rel_221222.cza1_ser77.86791.9390.1940.013

Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
fbmy5635_rel_202104072149.cza1_ser713.66186.1280.2110.008
fbmy5635_rel_202203072101.cza1_ser78.71191.1170.1720.009
fbmy5635_rel_202205192101.cza1_ser77.37892.4560.1670.008
fbmy5635_rel_202208092101.cza1_ser76.02293.8170.1610.008
fbmy5635_rel_202210112144.cza1_ser715.53384.2940.1720.008
fbmy5635_rel_202302162102.cza1_ser78.47291.3500.1780.008
fbmy5635_rel_202304122154.cza1_ser719.19480.6330.1720.008
fbmy5635_rel_202305292102.cza1_ser77.10092.7000.2000.009
fbmy5635_rel_20230529_832.cza1_ser714.81785.0060.1780.008
fbmy5635_rel_20230529_843.cza1_ser77.51192.3060.1830.008
fbmy5635_rel_20230529_850.cza1_ser715.42284.3500.2280.012
fbmy5635_rel_221222.cza1_ser76.80693.0330.1610.014

Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
499	3110	0	0.0	10.1	3.2	0.000	0.000	0.020	6.668	12340	6.8	3.968	175	4.2	4.5	15.0	0.035	3100	2684	fbmy5635_rel_202104072149.cza1_ser7
499	3777	0	0.0	10.1	3.3	0.000	0.000	0.020	6.701	14864	6.4	3.935	136	4.2	4.5	15.2	0.040	3500	3019	fbmy5635_rel_202203072101.cza1_ser7
499	3690	0	0.0	10.3	3.3	0.000	0.000	0.021	6.820	14534	6.5	3.939	141	4.2	4.4	15.1	0.036	3676	3228	fbmy5635_rel_202205192101.cza1_ser7
499	3652	0	0.0	12.1	3.2	0.000	0.000	0.024	6.661	14397	6.5	3.942	142	4.2	4.4	15.1	0.041	3564	3069	fbmy5635_rel_202208092101.cza1_ser7
499	4331	0	0.0	12.6	3.5	0.000	0.000	0.025	7.266	17000	6.2	3.925	115	4.1	4.4	14.9	0.042	4300	3613	fbmy5635_rel_202210112144.cza1_ser7
499	3858	0	0.0	9.8	3.1	0.000	0.000	0.020	6.322	15160	6.3	3.929	131	4.2	4.5	12.1	0.034	3836	2861	fbmy5635_rel_202302162102.cza1_ser7
499	3596	0	0.0	9.6	3.1	0.000	0.000	0.019	6.354	14168	6.5	3.940	145	4.2	4.5	12.2	0.035	3580	3005	fbmy5635_rel_202304122154.cza1_ser7
499	3168	0	0.0	9.6	3.0	0.000	0.000	0.019	6.147	12552	6.8	3.961	172	4.2	4.5	12.2	0.034	3164	2685	fbmy5635_rel_202305292102.cza1_ser7
499	3696	0	0.0	10.0	3.2	0.000	0.000	0.020	6.555	14570	6.5	3.942	141	4.1	4.4	12.4	0.040	3309	2764	fbmy5635_rel_20230529_832.cza1_ser7
499	3269	0	0.0	9.8	3.1	0.000	0.000	0.020	6.443	12916	6.7	3.951	164	4.2	4.4	12.7	0.039	3133	2685	fbmy5635_rel_20230529_843.cza1_ser7
499	3878	0	0.0	9.6	3.1	0.000	0.000	0.019	6.348	15243	6.3	3.930	130	4.1	4.4	12.4	0.034	3867	3244	fbmy5635_rel_20230529_850.cza1_ser7
499	3462	0	0.0	10.2	3.3	0.000	0.000	0.020	6.686	13651	6.6	3.943	153	4.1	4.4	12.9	0.034	3196	2685	fbmy5635_rel_221222.cza1_ser7

qp500.L4

qp500.L4: point queries with 500 insert/s per client. Graphs for performance per 1-second interval are here.

Average throughput:

Image

Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
fbmy5635_rel_202104072149.cza1_ser799.8360.164nonzero0.001
fbmy5635_rel_202203072101.cza1_ser799.7350.265nonzero0.002
fbmy5635_rel_202205192101.cza1_ser799.7440.256nonzero0.002
fbmy5635_rel_202208092101.cza1_ser799.6900.310nonzero0.003
fbmy5635_rel_202210112144.cza1_ser799.7840.216nonzerononzero0.004
fbmy5635_rel_202302162102.cza1_ser799.7520.248nonzero0.002
fbmy5635_rel_202304122154.cza1_ser799.7580.242nonzero0.001
fbmy5635_rel_202305292102.cza1_ser799.7360.264nonzero0.003
fbmy5635_rel_20230529_832.cza1_ser799.7470.253nonzero0.002
fbmy5635_rel_20230529_843.cza1_ser799.7040.296nonzero0.001
fbmy5635_rel_20230529_850.cza1_ser799.7360.264nonzero0.002
fbmy5635_rel_221222.cza1_ser799.7680.232nonzero0.003

Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
fbmy5635_rel_202104072149.cza1_ser76.95092.8170.2330.008
fbmy5635_rel_202203072101.cza1_ser76.76193.0390.2000.012
fbmy5635_rel_202205192101.cza1_ser710.32889.4670.2060.014
fbmy5635_rel_202208092101.cza1_ser79.44490.3560.2000.008
fbmy5635_rel_202210112144.cza1_ser77.51792.3000.1830.008
fbmy5635_rel_202302162102.cza1_ser75.53394.2940.1720.009
fbmy5635_rel_202304122154.cza1_ser711.21188.5780.2110.009
fbmy5635_rel_202305292102.cza1_ser79.53990.2720.1890.013
fbmy5635_rel_20230529_832.cza1_ser76.71193.0890.2000.008
fbmy5635_rel_20230529_843.cza1_ser79.20090.5940.2060.008
fbmy5635_rel_20230529_850.cza1_ser76.30093.4560.2440.008
fbmy5635_rel_221222.cza1_ser710.11789.6720.2110.008

Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
fbmy5635_rel_202104072149.cza1_ser79.23990.5280.2330.008
fbmy5635_rel_202203072101.cza1_ser76.89492.9060.2000.012
fbmy5635_rel_202205192101.cza1_ser79.46190.3390.2000.013
fbmy5635_rel_202208092101.cza1_ser78.93990.8610.2000.008
fbmy5635_rel_202210112144.cza1_ser710.09489.7110.1940.009
fbmy5635_rel_202302162102.cza1_ser79.69490.1220.1830.008
fbmy5635_rel_202304122154.cza1_ser712.83386.9500.2170.008
fbmy5635_rel_202305292102.cza1_ser79.45690.3390.2060.012
fbmy5635_rel_20230529_832.cza1_ser711.67288.1170.2110.008
fbmy5635_rel_20230529_843.cza1_ser714.10685.6830.2110.008
fbmy5635_rel_20230529_850.cza1_ser711.12288.6390.2390.009
fbmy5635_rel_221222.cza1_ser713.63386.1560.2110.008

Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
499	6888	0	0.0	10.3	3.4	0.000	0.000	0.021	6.918	28012	6.9	4.067	80	4.2	4.7	16.6	0.001	6631	6297	fbmy5635_rel_202104072149.cza1_ser7
499	6738	0	0.0	9.9	3.2	0.000	0.000	0.020	6.542	27396	6.9	4.066	82	4.2	4.6	16.5	0.002	6393	6200	fbmy5635_rel_202203072101.cza1_ser7
499	6676	0	0.0	9.8	3.2	0.000	0.000	0.020	6.546	27152	6.7	4.067	80	4.2	4.6	16.6	0.002	6375	6169	fbmy5635_rel_202205192101.cza1_ser7
499	6700	0	0.0	11.8	3.2	0.000	0.000	0.024	6.520	27252	7.0	4.068	84	4.2	4.7	16.8	0.003	6409	6153	fbmy5635_rel_202208092101.cza1_ser7
499	6904	0	0.0	11.5	3.0	0.000	0.000	0.023	6.161	28046	6.7	4.062	78	4.2	4.6	16.1	0.004	6522	6217	fbmy5635_rel_202210112144.cza1_ser7
499	6706	0	0.0	9.1	2.9	0.000	0.000	0.018	5.877	27254	6.9	4.064	82	4.2	4.6	13.0	0.002	6362	6201	fbmy5635_rel_202302162102.cza1_ser7
499	6846	0	0.0	9.6	3.0	0.000	0.000	0.019	6.255	27816	7.2	4.063	84	4.1	4.6	13.1	0.001	6505	6233	fbmy5635_rel_202304122154.cza1_ser7
499	6761	0	0.0	9.3	2.9	0.000	0.000	0.019	5.972	27485	6.8	4.065	80	4.2	4.6	13.1	0.003	6409	6201	fbmy5635_rel_202305292102.cza1_ser7
499	6763	0	0.0	9.0	2.8	0.000	0.000	0.018	5.680	27472	6.7	4.062	79	4.2	4.7	13.2	0.002	6425	6217	fbmy5635_rel_20230529_832.cza1_ser7
499	6720	0	0.0	9.2	2.9	0.000	0.000	0.018	5.912	27296	6.8	4.062	81	4.2	4.6	13.6	0.001	6360	6137	fbmy5635_rel_20230529_843.cza1_ser7
499	6892	0	0.0	8.8	2.7	0.000	0.000	0.018	5.564	27975	6.8	4.059	79	4.2	4.6	13.3	0.002	6474	6217	fbmy5635_rel_20230529_850.cza1_ser7
499	6789	0	0.0	9.3	2.9	0.000	0.000	0.019	6.052	27582	6.9	4.063	81	4.1	4.6	13.7	0.003	6489	6221	fbmy5635_rel_221222.cza1_ser7

qr1000.L5

qr1000.L5: range queries with 1000 insert/s per client. Graphs for performance per 1-second interval are here.

Average throughput:

Image

Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
fbmy5635_rel_202104072149.cza1_ser787.31311.7800.907nonzerononzero0.050
fbmy5635_rel_202203072101.cza1_ser769.95926.6213.419nonzerononzero0.035
fbmy5635_rel_202205192101.cza1_ser775.40019.1065.494nonzerononzerononzero0.168
fbmy5635_rel_202208092101.cza1_ser773.19720.6496.153nonzerononzero0.036
fbmy5635_rel_202210112144.cza1_ser775.24721.2433.510nonzerononzero0.038
fbmy5635_rel_202302162102.cza1_ser777.91317.1754.912nonzero0.038
fbmy5635_rel_202304122154.cza1_ser773.21019.9466.844nonzerononzero0.036
fbmy5635_rel_202305292102.cza1_ser772.75121.6165.633nonzerononzero0.035
fbmy5635_rel_20230529_832.cza1_ser770.67421.1718.154nonzerononzero0.036
fbmy5635_rel_20230529_843.cza1_ser772.95925.1051.936nonzerononzero0.036
fbmy5635_rel_20230529_850.cza1_ser772.88123.7983.320nonzerononzero0.035
fbmy5635_rel_221222.cza1_ser772.73725.0332.229nonzerononzero0.036

Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
fbmy5635_rel_202104072149.cza1_ser76.40393.4330.1610.0030.048
fbmy5635_rel_202203072101.cza1_ser710.64289.1470.2080.0030.049
fbmy5635_rel_202205192101.cza1_ser711.71988.1390.1390.0030.047
fbmy5635_rel_202208092101.cza1_ser77.93391.8080.2530.0060.055
fbmy5635_rel_202210112144.cza1_ser74.76195.0890.1470.0030.056
fbmy5635_rel_202302162102.cza1_ser74.74795.0860.1640.0030.037
fbmy5635_rel_202304122154.cza1_ser78.54491.2940.1580.0030.048
fbmy5635_rel_202305292102.cza1_ser710.85388.9780.1670.0030.049
fbmy5635_rel_20230529_832.cza1_ser710.85388.9890.1560.0030.038
fbmy5635_rel_20230529_843.cza1_ser79.19790.6530.1470.0030.038
fbmy5635_rel_20230529_850.cza1_ser76.08193.7190.1970.0030.040
fbmy5635_rel_221222.cza1_ser710.37889.4440.1750.0030.049

Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
fbmy5635_rel_202104072149.cza1_ser710.15389.7060.1390.0030.048
fbmy5635_rel_202203072101.cza1_ser716.18983.6080.2000.0030.049
fbmy5635_rel_202205192101.cza1_ser79.49490.3530.1470.0060.061
fbmy5635_rel_202208092101.cza1_ser714.28985.4360.2690.0060.056
fbmy5635_rel_202210112144.cza1_ser714.82585.0080.1610.0060.055
fbmy5635_rel_202302162102.cza1_ser75.57894.2610.1580.0030.038
fbmy5635_rel_202304122154.cza1_ser710.01189.8280.1580.0030.048
fbmy5635_rel_202305292102.cza1_ser78.91790.9060.1720.0060.049
fbmy5635_rel_20230529_832.cza1_ser79.60890.2220.1670.0030.038
fbmy5635_rel_20230529_843.cza1_ser714.61985.2390.1390.0030.038
fbmy5635_rel_20230529_850.cza1_ser78.55891.2500.1890.0030.039
fbmy5635_rel_221222.cza1_ser79.93189.8830.1780.0080.056

Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
998	5102	4	0.3	18.1	6.8	0.001	0.052	0.018	7.025	20323	6.8	3.983	107	4.1	5.0	18.5	0.050	3884	2765	fbmy5635_rel_202104072149.cza1_ser7
998	3762	5	0.3	19.9	7.7	0.001	0.087	0.020	7.870	15274	7.0	4.060	149	4.1	5.0	18.8	0.035	3676	2876	fbmy5635_rel_202203072101.cza1_ser7
998	3760	2	0.1	20.2	7.8	0.000	0.019	0.020	7.997	15255	7.0	4.058	149	4.2	5.0	18.9	0.168	3788	2924	fbmy5635_rel_202205192101.cza1_ser7
998	3646	1	0.1	19.9	6.8	0.000	0.019	0.020	6.971	14761	7.0	4.048	154	4.2	5.1	19.1	0.036	3643	2861	fbmy5635_rel_202208092101.cza1_ser7
998	3611	1	0.0	19.7	6.7	0.000	0.013	0.020	6.912	14639	7.0	4.054	155	4.2	5.1	18.6	0.038	3660	2669	fbmy5635_rel_202210112144.cza1_ser7
998	3801	0	0.0	16.2	6.1	0.000	0.000	0.016	6.306	15316	6.9	4.029	145	4.2	5.1	15.3	0.038	3660	2366	fbmy5635_rel_202302162102.cza1_ser7
998	3309	0	0.0	16.2	6.2	0.000	0.000	0.016	6.379	13449	7.1	4.065	172	4.2	5.1	15.5	0.036	3292	2589	fbmy5635_rel_202304122154.cza1_ser7
998	3700	0	0.0	16.4	6.3	0.000	0.000	0.016	6.452	14944	7.0	4.039	151	4.2	5.1	15.3	0.035	3644	2765	fbmy5635_rel_202305292102.cza1_ser7
998	3015	0	0.0	16.3	6.3	0.000	0.000	0.016	6.440	12314	7.1	4.084	188	4.2	5.1	15.7	0.036	2941	2493	fbmy5635_rel_20230529_832.cza1_ser7
998	3862	0	0.0	16.6	6.4	0.000	0.000	0.017	6.559	15576	7.0	4.033	145	4.1	5.0	15.7	0.036	3708	3101	fbmy5635_rel_20230529_843.cza1_ser7
998	3428	0	0.0	16.4	6.3	0.000	0.000	0.016	6.464	13902	7.1	4.056	166	4.2	5.1	15.6	0.035	3484	2605	fbmy5635_rel_20230529_850.cza1_ser7
998	3577	0	0.0	15.9	6.1	0.000	0.000	0.016	6.301	14450	7.0	4.040	157	4.2	5.1	15.8	0.036	3548	2781	fbmy5635_rel_221222.cza1_ser7

qp1000.L6

qp1000.L6: point queries with 1000 insert/s per client. Graphs for performance per 1-second interval are here.

Average throughput:

Image

Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
fbmy5635_rel_202104072149.cza1_ser799.8140.186nonzerononzerononzero0.025
fbmy5635_rel_202203072101.cza1_ser799.3070.692nonzerononzero0.012
fbmy5635_rel_202205192101.cza1_ser799.4380.562nonzerononzero0.010
fbmy5635_rel_202208092101.cza1_ser799.7090.291nonzerononzero0.009
fbmy5635_rel_202210112144.cza1_ser799.7570.243nonzerononzero0.006
fbmy5635_rel_202302162102.cza1_ser799.7160.284nonzero0.002
fbmy5635_rel_202304122154.cza1_ser799.7600.240nonzerononzero0.006
fbmy5635_rel_202305292102.cza1_ser799.7490.251nonzero0.001
fbmy5635_rel_20230529_832.cza1_ser799.7070.293nonzero0.001
fbmy5635_rel_20230529_843.cza1_ser799.6880.312nonzero0.001
fbmy5635_rel_20230529_850.cza1_ser799.7280.272nonzero0.003
fbmy5635_rel_221222.cza1_ser799.7460.254nonzero0.004

Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
fbmy5635_rel_202104072149.cza1_ser78.16491.7360.0970.0030.047
fbmy5635_rel_202203072101.cza1_ser710.28689.6220.0890.0030.054
fbmy5635_rel_202205192101.cza1_ser79.08990.7110.1970.0030.047
fbmy5635_rel_202208092101.cza1_ser79.05090.8060.1420.0030.053
fbmy5635_rel_202210112144.cza1_ser79.93189.8330.2330.0030.045
fbmy5635_rel_202302162102.cza1_ser712.00887.8190.1690.0030.047
fbmy5635_rel_202304122154.cza1_ser76.82292.9970.1780.0030.048
fbmy5635_rel_202305292102.cza1_ser711.89787.9360.1640.0030.048
fbmy5635_rel_20230529_832.cza1_ser711.79288.0250.1810.0030.052
fbmy5635_rel_20230529_843.cza1_ser77.84491.9640.1890.0030.047
fbmy5635_rel_20230529_850.cza1_ser712.88686.9610.1500.0030.047
fbmy5635_rel_221222.cza1_ser712.46787.3580.1720.0030.037

Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
fbmy5635_rel_202104072149.cza1_ser713.49486.4000.1030.0030.047
fbmy5635_rel_202203072101.cza1_ser713.58986.3110.0970.0030.054
fbmy5635_rel_202205192101.cza1_ser711.46788.3530.1780.0030.048
fbmy5635_rel_202208092101.cza1_ser713.48186.3780.1390.0030.053
fbmy5635_rel_202210112144.cza1_ser78.63991.1500.2080.0030.045
fbmy5635_rel_202302162102.cza1_ser711.03988.7690.1890.0030.047
fbmy5635_rel_202304122154.cza1_ser711.42288.3970.1780.0030.048
fbmy5635_rel_202305292102.cza1_ser710.85088.9750.1720.0030.048
fbmy5635_rel_20230529_832.cza1_ser715.27584.5560.1670.0030.051
fbmy5635_rel_20230529_843.cza1_ser79.83989.9670.1890.0060.052
fbmy5635_rel_20230529_850.cza1_ser711.06988.7530.1750.0030.047
fbmy5635_rel_221222.cza1_ser711.70388.1280.1670.0030.037

Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
998	7080	5	0.6	18.7	6.7	0.001	0.090	0.019	6.889	29113	7.2	4.112	81	4.2	5.4	20.3	0.025	6649	6297	fbmy5635_rel_202104072149.cza1_ser7
998	6819	87	1.1	18.0	6.5	0.013	0.165	0.018	6.638	28229	7.1	4.140	83	4.2	5.5	20.7	0.012	6442	3852	fbmy5635_rel_202203072101.cza1_ser7
998	6822	58	1.0	17.9	6.4	0.009	0.157	0.018	6.601	28154	7.3	4.127	86	4.2	5.4	20.5	0.010	6393	4569	fbmy5635_rel_202205192101.cza1_ser7
998	6900	8	0.9	20.5	6.8	0.001	0.128	0.021	6.998	28397	7.3	4.115	85	4.1	5.4	20.4	0.009	6458	6105	fbmy5635_rel_202208092101.cza1_ser7
998	6911	6	0.7	19.9	6.6	0.001	0.102	0.020	6.769	28455	7.5	4.117	87	4.2	5.4	20.4	0.006	6505	6169	fbmy5635_rel_202210112144.cza1_ser7
998	7083	0	0.0	15.9	6.1	0.000	0.000	0.016	6.266	29129	7.2	4.112	81	4.2	5.4	16.9	0.002	6664	6142	fbmy5635_rel_202302162102.cza1_ser7
998	7019	0	0.0	16.0	6.1	0.000	0.000	0.016	6.273	28889	7.4	4.116	84	4.1	5.4	17.0	0.006	6601	6201	fbmy5635_rel_202304122154.cza1_ser7
998	6949	0	0.0	15.7	6.0	0.000	0.000	0.016	6.172	28605	7.2	4.116	83	4.2	5.5	16.8	0.001	6553	6201	fbmy5635_rel_202305292102.cza1_ser7
998	7025	0	0.0	16.0	6.1	0.000	0.000	0.016	6.221	28903	7.2	4.114	82	4.1	5.4	17.3	0.001	6617	6169	fbmy5635_rel_20230529_832.cza1_ser7
998	6862	0	0.0	15.6	5.9	0.000	0.000	0.016	6.057	28264	7.1	4.119	83	4.2	5.5	17.2	0.001	6425	6074	fbmy5635_rel_20230529_843.cza1_ser7
998	7052	8	0.0	15.8	5.9	0.001	0.005	0.016	6.084	29010	7.3	4.114	83	4.2	5.5	17.3	0.003	6648	6185	fbmy5635_rel_20230529_850.cza1_ser7
998	7020	6	0.0	16.0	6.1	0.001	0.005	0.016	6.225	28903	7.1	4.117	81	4.2	5.5	17.3	0.004	6633	6201	fbmy5635_rel_221222.cza1_ser7

l.i0

l.i0: load without secondary indexes

Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
217391	0	0	0.0	102.7	37.7	0.000	0.000	0.000	0.178	22519	11.0	0.104	4	1.8	3.2	0.3	0.107	218776	193283	fbmy5635_rel_202104072149.cza1_ser7
213523	0	0	0.0	99.3	37.2	0.000	0.000	0.000	0.179	22270	11.1	0.104	4	1.8	3.2	0.3	0.110	215784	188598	fbmy5635_rel_202203072101.cza1_ser7
210526	0	0	0.0	97.3	36.7	0.000	0.000	0.000	0.179	21928	10.9	0.104	4	1.8	3.2	0.3	0.119	212062	182798	fbmy5635_rel_202205192101.cza1_ser7
208333	0	0	0.0	98.1	36.2	0.000	0.000	0.000	0.178	21545	10.9	0.103	4	1.8	3.2	0.3	0.108	209502	184886	fbmy5635_rel_202208092101.cza1_ser7
210526	0	0	0.0	99.1	36.5	0.000	0.000	0.000	0.178	21912	10.9	0.104	4	1.8	3.2	0.3	0.115	210963	184806	fbmy5635_rel_202210112144.cza1_ser7
204082	0	0	0.0	94.5	35.6	0.000	0.000	0.000	0.179	21369	10.8	0.105	4	1.8	3.2	0.3	0.106	205576	181003	fbmy5635_rel_202302162102.cza1_ser7
208333	0	0	0.0	97.0	36.4	0.000	0.000	0.000	0.179	21743	11.0	0.104	4	1.8	3.2	0.3	0.130	210763	182703	fbmy5635_rel_202304122154.cza1_ser7
207612	0	0	0.0	97.3	36.2	0.000	0.000	0.000	0.179	21549	10.9	0.104	4	1.8	3.2	0.3	0.109	209366	186391	fbmy5635_rel_202305292102.cza1_ser7
207612	0	0	0.0	97.2	36.1	0.000	0.000	0.000	0.178	21553	10.9	0.104	4	1.8	3.2	0.3	0.102	208265	182578	fbmy5635_rel_20230529_832.cza1_ser7
206896	0	0	0.0	97.1	36.1	0.000	0.000	0.000	0.179	21562	10.8	0.104	4	1.8	3.2	0.3	0.119	208572	183994	fbmy5635_rel_20230529_843.cza1_ser7
206896	0	0	0.0	96.3	35.8	0.000	0.000	0.000	0.177	21486	10.8	0.104	4	1.8	3.2	0.3	0.118	207572	182405	fbmy5635_rel_20230529_850.cza1_ser7
206896	0	0	0.0	96.2	35.9	0.000	0.000	0.000	0.177	21625	10.9	0.105	4	1.8	3.2	0.3	0.114	207983	179297	fbmy5635_rel_221222.cza1_ser7

l.x

l.x: create secondary indexes

Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
198676	0	0	0.0	79.8	30.8	0.000	0.000	0.000	0.158	199	5.9	0.001	2	4.0	5.4	3.6	0.001	NA	NA	fbmy5635_rel_202104072149.cza1_ser7
198676	0	0	0.0	78.6	31.6	0.000	0.000	0.000	0.163	218	5.9	0.001	2	4.0	5.4	3.9	0.002	NA	NA	fbmy5635_rel_202203072101.cza1_ser7
197369	0	0	0.0	78.4	31.2	0.000	0.000	0.000	0.162	204	5.9	0.001	2	4.0	5.4	3.9	0.001	NA	NA	fbmy5635_rel_202205192101.cza1_ser7
197369	0	0	0.0	79.1	31.3	0.000	0.000	0.000	0.162	987	5.9	0.005	2	4.0	5.4	3.9	0.002	NA	NA	fbmy5635_rel_202208092101.cza1_ser7
198020	0	0	0.0	79.8	31.5	0.000	0.000	0.000	0.163	955	5.8	0.005	2	4.0	5.4	3.9	0.001	NA	NA	fbmy5635_rel_202210112144.cza1_ser7
198676	0	0	0.0	78.3	31.5	0.000	0.000	0.000	0.162	184	5.9	0.001	2	4.0	5.4	3.9	0.001	NA	NA	fbmy5635_rel_202302162102.cza1_ser7
199336	0	0	0.0	79.5	31.8	0.000	0.000	0.000	0.163	183	5.9	0.001	2	4.0	5.4	3.9	0.001	NA	NA	fbmy5635_rel_202304122154.cza1_ser7
198020	0	0	0.0	78.8	31.4	0.000	0.000	0.000	0.163	217	5.9	0.001	2	4.0	5.4	3.9	0.001	NA	NA	fbmy5635_rel_202305292102.cza1_ser7
200000	0	0	0.0	79.5	31.7	0.000	0.000	0.000	0.162	208	5.9	0.001	2	4.0	5.4	3.6	0.001	NA	NA	fbmy5635_rel_20230529_832.cza1_ser7
199336	0	0	0.0	80.1	31.7	0.000	0.000	0.000	0.163	297	5.9	0.001	2	4.0	5.4	3.9	0.001	NA	NA	fbmy5635_rel_20230529_843.cza1_ser7
197369	0	0	0.0	78.9	31.3	0.000	0.000	0.000	0.163	220	5.9	0.001	2	4.0	5.4	3.9	0.001	NA	NA	fbmy5635_rel_20230529_850.cza1_ser7
194175	0	0	0.0	77.5	30.8	0.000	0.000	0.000	0.162	208	5.9	0.001	2	4.0	5.4	4.0	0.002	NA	NA	fbmy5635_rel_221222.cza1_ser7

l.i1

l.i1: continue load after secondary indexes created with 50 inserts per transaction

Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
71684	0	32	4.0	385.7	156.4	0.000	0.058	0.005	2.234	34387	24.4	0.480	27	5.0	5.5	8.1	0.101	72671	58737	fbmy5635_rel_202104072149.cza1_ser7
70299	0	32	4.0	374.2	153.1	0.000	0.058	0.005	2.230	33994	24.8	0.484	28	5.3	5.7	8.3	0.098	71549	58187	fbmy5635_rel_202203072101.cza1_ser7
69324	0	31	3.9	372.8	152.9	0.000	0.058	0.005	2.259	33686	24.9	0.486	29	5.1	5.5	8.5	0.102	70070	56989	fbmy5635_rel_202205192101.cza1_ser7
69204	0	31	3.9	381.9	155.0	0.000	0.058	0.006	2.293	33617	24.9	0.486	29	5.1	5.5	8.5	0.137	69875	58740	fbmy5635_rel_202208092101.cza1_ser7
68847	0	31	3.9	370.6	151.5	0.000	0.057	0.005	2.254	33430	24.9	0.486	29	5.0	5.4	8.5	0.133	69524	57239	fbmy5635_rel_202210112144.cza1_ser7
70547	0	32	4.0	343.1	136.4	0.000	0.058	0.005	1.980	33227	24.2	0.471	27	5.3	5.8	6.2	0.099	70872	59136	fbmy5635_rel_202302162102.cza1_ser7
70422	0	32	4.0	342.5	136.5	0.000	0.058	0.005	1.986	33079	24.1	0.470	27	5.6	6.1	6.3	0.095	70723	60334	fbmy5635_rel_202304122154.cza1_ser7
69324	0	31	3.9	334.2	133.4	0.000	0.058	0.005	1.971	32509	24.7	0.469	29	4.9	5.3	6.4	0.095	69426	59032	fbmy5635_rel_202305292102.cza1_ser7
70175	0	32	3.9	344.0	137.7	0.000	0.057	0.005	2.009	32889	24.3	0.469	28	4.7	5.2	6.5	0.098	70221	59784	fbmy5635_rel_20230529_832.cza1_ser7
70796	0	32	4.0	373.0	150.6	0.000	0.058	0.005	2.179	33833	25.6	0.478	29	4.8	5.2	6.6	0.098	71571	59336	fbmy5635_rel_20230529_843.cza1_ser7
70671	0	924	4.0	368.5	147.8	0.013	0.057	0.005	2.141	35310	25.6	0.500	29	5.3	5.7	6.6	0.108	71363	57991	fbmy5635_rel_20230529_850.cza1_ser7
69565	0	683	3.9	361.9	145.5	0.010	0.057	0.005	2.142	34366	25.1	0.494	29	4.9	5.3	6.7	0.101	69880	57336	fbmy5635_rel_221222.cza1_ser7

l.i2

l.i2: continue load after secondary indexes created with 5 inserts per transaction

Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
25189	0	0	0.0	269.5	97.1	0.000	0.000	0.011	3.949	104574	20.3	4.152	64	4.2	4.4	10.1	0.094	25136	21951	fbmy5635_rel_202104072149.cza1_ser7
25189	0	0	0.0	260.6	93.7	0.000	0.000	0.010	3.808	104261	20.5	4.139	65	4.2	4.4	10.3	0.083	25332	22390	fbmy5635_rel_202203072101.cza1_ser7
24450	0	0	0.0	268.3	95.8	0.000	0.000	0.011	4.012	101664	20.4	4.158	67	4.3	4.4	10.3	0.087	24518	21801	fbmy5635_rel_202205192101.cza1_ser7
24450	0	0	0.0	258.2	92.0	0.000	0.000	0.011	3.854	101671	20.4	4.158	67	4.6	4.7	10.1	0.103	24484	21221	fbmy5635_rel_202208092101.cza1_ser7
24154	0	0	0.0	259.7	92.4	0.000	0.000	0.011	3.919	100243	20.5	4.150	68	4.4	4.5	10.3	0.100	24224	21570	fbmy5635_rel_202210112144.cza1_ser7
24450	0	0	0.0	231.3	85.6	0.000	0.000	0.009	3.583	101265	20.2	4.142	66	4.2	4.4	7.6	0.093	24503	22063	fbmy5635_rel_202302162102.cza1_ser7
24450	0	0	0.0	236.7	87.2	0.000	0.000	0.010	3.652	101509	20.2	4.152	66	4.4	4.5	7.6	0.086	24513	21894	fbmy5635_rel_202304122154.cza1_ser7
24272	0	0	0.0	214.8	79.1	0.000	0.000	0.009	3.336	100144	20.2	4.126	67	4.4	4.5	7.4	0.087	24366	21666	fbmy5635_rel_202305292102.cza1_ser7
24570	0	0	0.0	234.6	86.8	0.000	0.000	0.010	3.619	101746	20.1	4.141	65	4.4	4.6	7.8	0.084	24593	22251	fbmy5635_rel_20230529_832.cza1_ser7
24272	0	0	0.0	231.7	86.2	0.000	0.000	0.010	3.637	100374	20.3	4.135	67	4.4	4.6	8.0	0.093	24264	21551	fbmy5635_rel_20230529_843.cza1_ser7
24390	0	0	0.0	234.6	86.4	0.000	0.000	0.010	3.626	101035	20.4	4.142	67	4.2	4.4	7.9	0.083	24504	21666	fbmy5635_rel_20230529_850.cza1_ser7
24038	0	0	0.0	241.3	88.6	0.000	0.000	0.010	3.773	100168	20.4	4.167	68	4.4	4.6	8.0	0.087	24170	21377	fbmy5635_rel_221222.cza1_ser7

qr100.L1

qr100.L1: range queries with 100 insert/s per client

Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
100	3735	0	0.0	4.7	0.5	0.000	0.000	0.047	5.304	14413	5.8	3.859	124	4.2	4.2	10.4	0.038	3739	3483	fbmy5635_rel_202104072149.cza1_ser7
100	3897	0	0.0	4.7	0.5	0.000	0.000	0.047	5.322	15026	5.8	3.856	119	4.2	4.2	10.6	0.036	3884	3578	fbmy5635_rel_202203072101.cza1_ser7
100	4622	0	0.0	5.0	0.6	0.000	0.000	0.051	6.575	17792	5.8	3.849	100	4.1	4.2	10.7	0.039	4601	4379	fbmy5635_rel_202205192101.cza1_ser7
100	4053	0	0.0	7.3	0.7	0.000	0.000	0.073	7.385	15648	5.8	3.861	114	4.1	4.2	10.5	0.040	4058	3868	fbmy5635_rel_202208092101.cza1_ser7
100	5449	0	0.0	6.6	0.5	0.000	0.000	0.067	5.131	20951	5.8	3.845	85	4.2	4.2	10.6	0.002	5433	5033	fbmy5635_rel_202210112144.cza1_ser7
100	3286	0	0.0	4.8	0.6	0.000	0.000	0.049	5.832	12700	6.0	3.865	146	4.2	4.2	7.9	0.038	3293	2988	fbmy5635_rel_202302162102.cza1_ser7
100	3164	0	0.0	4.6	0.5	0.000	0.000	0.046	4.918	12238	6.1	3.868	154	4.2	4.2	8.1	0.038	3179	2891	fbmy5635_rel_202304122154.cza1_ser7
100	3860	0	0.0	4.5	0.5	0.000	0.000	0.045	4.869	14883	5.8	3.855	120	4.2	4.2	7.8	0.002	3868	3580	fbmy5635_rel_202305292102.cza1_ser7
100	3623	0	0.0	4.5	0.5	0.000	0.000	0.046	4.998	13979	5.8	3.859	128	4.2	4.2	8.1	0.003	3612	3420	fbmy5635_rel_20230529_832.cza1_ser7
100	3569	0	0.0	4.4	0.4	0.000	0.000	0.044	4.544	13772	5.8	3.859	130	4.1	4.2	8.4	0.035	3579	3292	fbmy5635_rel_20230529_843.cza1_ser7
100	4422	0	0.0	5.2	0.7	0.000	0.000	0.052	7.041	17044	5.8	3.854	105	4.1	4.1	8.2	0.039	4394	4172	fbmy5635_rel_20230529_850.cza1_ser7
100	2425	0	0.0	4.6	0.5	0.000	0.000	0.046	4.996	9407	6.6	3.879	218	4.2	4.2	8.6	0.039	2429	2254	fbmy5635_rel_221222.cza1_ser7

qp100.L2

qp100.L2: point queries with 100 insert/s per client

Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
100	6876	0	0.0	4.9	0.7	0.000	0.000	0.049	7.042	27684	6.6	4.026	77	4.1	4.2	13.7	0.003	6630	6009	fbmy5635_rel_202104072149.cza1_ser7
100	6782	0	0.0	4.7	0.7	0.000	0.000	0.047	6.772	27285	6.2	4.023	73	4.2	4.2	14.0	0.001	6440	6153	fbmy5635_rel_202203072101.cza1_ser7
100	6667	0	0.0	4.3	0.5	0.000	0.000	0.043	5.205	26826	6.2	4.024	74	4.2	4.2	14.0	0.002	6345	5928	fbmy5635_rel_202205192101.cza1_ser7
100	6639	0	0.0	6.3	0.5	0.000	0.000	0.063	5.011	26739	6.3	4.028	76	4.2	4.2	13.8	0.001	6377	6121	fbmy5635_rel_202208092101.cza1_ser7
100	6939	0	0.0	6.4	0.5	0.000	0.000	0.064	5.422	27893	6.0	4.020	69	4.2	4.2	13.8	0.001	6535	5831	fbmy5635_rel_202210112144.cza1_ser7
100	6832	0	0.0	4.3	0.5	0.000	0.000	0.043	4.863	27472	6.3	4.021	74	4.2	4.3	11.0	0.001	6457	5897	fbmy5635_rel_202302162102.cza1_ser7
100	6882	0	0.0	4.6	0.6	0.000	0.000	0.046	5.942	27682	6.5	4.023	76	4.2	4.2	11.1	0.001	6517	6217	fbmy5635_rel_202304122154.cza1_ser7
100	6724	0	0.0	4.8	0.7	0.000	0.000	0.048	6.845	27045	6.7	4.022	80	4.1	4.2	10.8	0.001	6377	5832	fbmy5635_rel_202305292102.cza1_ser7
100	6949	0	0.0	4.6	0.6	0.000	0.000	0.046	6.074	27933	6.0	4.020	69	4.2	4.2	11.1	0.001	6535	6247	fbmy5635_rel_20230529_832.cza1_ser7
100	6651	0	0.0	4.3	0.5	0.000	0.000	0.043	4.846	26758	6.2	4.023	75	4.2	4.3	11.5	0.001	6297	5817	fbmy5635_rel_20230529_843.cza1_ser7
100	6811	0	0.0	4.2	0.4	0.000	0.000	0.042	4.350	27362	6.6	4.017	78	4.1	4.2	11.3	0.001	6407	6217	fbmy5635_rel_20230529_850.cza1_ser7
100	6862	0	0.0	4.6	0.6	0.000	0.000	0.046	5.697	27583	6.3	4.020	73	4.2	4.2	11.6	0.001	6489	6217	fbmy5635_rel_221222.cza1_ser7

qr500.L3

qr500.L3: range queries with 500 insert/s per client

Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
499	3110	0	0.0	10.1	3.2	0.000	0.000	0.020	6.668	12340	6.8	3.968	175	4.2	4.5	15.0	0.035	3100	2684	fbmy5635_rel_202104072149.cza1_ser7
499	3777	0	0.0	10.1	3.3	0.000	0.000	0.020	6.701	14864	6.4	3.935	136	4.2	4.5	15.2	0.040	3500	3019	fbmy5635_rel_202203072101.cza1_ser7
499	3690	0	0.0	10.3	3.3	0.000	0.000	0.021	6.820	14534	6.5	3.939	141	4.2	4.4	15.1	0.036	3676	3228	fbmy5635_rel_202205192101.cza1_ser7
499	3652	0	0.0	12.1	3.2	0.000	0.000	0.024	6.661	14397	6.5	3.942	142	4.2	4.4	15.1	0.041	3564	3069	fbmy5635_rel_202208092101.cza1_ser7
499	4331	0	0.0	12.6	3.5	0.000	0.000	0.025	7.266	17000	6.2	3.925	115	4.1	4.4	14.9	0.042	4300	3613	fbmy5635_rel_202210112144.cza1_ser7
499	3858	0	0.0	9.8	3.1	0.000	0.000	0.020	6.322	15160	6.3	3.929	131	4.2	4.5	12.1	0.034	3836	2861	fbmy5635_rel_202302162102.cza1_ser7
499	3596	0	0.0	9.6	3.1	0.000	0.000	0.019	6.354	14168	6.5	3.940	145	4.2	4.5	12.2	0.035	3580	3005	fbmy5635_rel_202304122154.cza1_ser7
499	3168	0	0.0	9.6	3.0	0.000	0.000	0.019	6.147	12552	6.8	3.961	172	4.2	4.5	12.2	0.034	3164	2685	fbmy5635_rel_202305292102.cza1_ser7
499	3696	0	0.0	10.0	3.2	0.000	0.000	0.020	6.555	14570	6.5	3.942	141	4.1	4.4	12.4	0.040	3309	2764	fbmy5635_rel_20230529_832.cza1_ser7
499	3269	0	0.0	9.8	3.1	0.000	0.000	0.020	6.443	12916	6.7	3.951	164	4.2	4.4	12.7	0.039	3133	2685	fbmy5635_rel_20230529_843.cza1_ser7
499	3878	0	0.0	9.6	3.1	0.000	0.000	0.019	6.348	15243	6.3	3.930	130	4.1	4.4	12.4	0.034	3867	3244	fbmy5635_rel_20230529_850.cza1_ser7
499	3462	0	0.0	10.2	3.3	0.000	0.000	0.020	6.686	13651	6.6	3.943	153	4.1	4.4	12.9	0.034	3196	2685	fbmy5635_rel_221222.cza1_ser7

qp500.L4

qp500.L4: point queries with 500 insert/s per client

Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
499	6888	0	0.0	10.3	3.4	0.000	0.000	0.021	6.918	28012	6.9	4.067	80	4.2	4.7	16.6	0.001	6631	6297	fbmy5635_rel_202104072149.cza1_ser7
499	6738	0	0.0	9.9	3.2	0.000	0.000	0.020	6.542	27396	6.9	4.066	82	4.2	4.6	16.5	0.002	6393	6200	fbmy5635_rel_202203072101.cza1_ser7
499	6676	0	0.0	9.8	3.2	0.000	0.000	0.020	6.546	27152	6.7	4.067	80	4.2	4.6	16.6	0.002	6375	6169	fbmy5635_rel_202205192101.cza1_ser7
499	6700	0	0.0	11.8	3.2	0.000	0.000	0.024	6.520	27252	7.0	4.068	84	4.2	4.7	16.8	0.003	6409	6153	fbmy5635_rel_202208092101.cza1_ser7
499	6904	0	0.0	11.5	3.0	0.000	0.000	0.023	6.161	28046	6.7	4.062	78	4.2	4.6	16.1	0.004	6522	6217	fbmy5635_rel_202210112144.cza1_ser7
499	6706	0	0.0	9.1	2.9	0.000	0.000	0.018	5.877	27254	6.9	4.064	82	4.2	4.6	13.0	0.002	6362	6201	fbmy5635_rel_202302162102.cza1_ser7
499	6846	0	0.0	9.6	3.0	0.000	0.000	0.019	6.255	27816	7.2	4.063	84	4.1	4.6	13.1	0.001	6505	6233	fbmy5635_rel_202304122154.cza1_ser7
499	6761	0	0.0	9.3	2.9	0.000	0.000	0.019	5.972	27485	6.8	4.065	80	4.2	4.6	13.1	0.003	6409	6201	fbmy5635_rel_202305292102.cza1_ser7
499	6763	0	0.0	9.0	2.8	0.000	0.000	0.018	5.680	27472	6.7	4.062	79	4.2	4.7	13.2	0.002	6425	6217	fbmy5635_rel_20230529_832.cza1_ser7
499	6720	0	0.0	9.2	2.9	0.000	0.000	0.018	5.912	27296	6.8	4.062	81	4.2	4.6	13.6	0.001	6360	6137	fbmy5635_rel_20230529_843.cza1_ser7
499	6892	0	0.0	8.8	2.7	0.000	0.000	0.018	5.564	27975	6.8	4.059	79	4.2	4.6	13.3	0.002	6474	6217	fbmy5635_rel_20230529_850.cza1_ser7
499	6789	0	0.0	9.3	2.9	0.000	0.000	0.019	6.052	27582	6.9	4.063	81	4.1	4.6	13.7	0.003	6489	6221	fbmy5635_rel_221222.cza1_ser7

qr1000.L5

qr1000.L5: range queries with 1000 insert/s per client

Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
998	5102	4	0.3	18.1	6.8	0.001	0.052	0.018	7.025	20323	6.8	3.983	107	4.1	5.0	18.5	0.050	3884	2765	fbmy5635_rel_202104072149.cza1_ser7
998	3762	5	0.3	19.9	7.7	0.001	0.087	0.020	7.870	15274	7.0	4.060	149	4.1	5.0	18.8	0.035	3676	2876	fbmy5635_rel_202203072101.cza1_ser7
998	3760	2	0.1	20.2	7.8	0.000	0.019	0.020	7.997	15255	7.0	4.058	149	4.2	5.0	18.9	0.168	3788	2924	fbmy5635_rel_202205192101.cza1_ser7
998	3646	1	0.1	19.9	6.8	0.000	0.019	0.020	6.971	14761	7.0	4.048	154	4.2	5.1	19.1	0.036	3643	2861	fbmy5635_rel_202208092101.cza1_ser7
998	3611	1	0.0	19.7	6.7	0.000	0.013	0.020	6.912	14639	7.0	4.054	155	4.2	5.1	18.6	0.038	3660	2669	fbmy5635_rel_202210112144.cza1_ser7
998	3801	0	0.0	16.2	6.1	0.000	0.000	0.016	6.306	15316	6.9	4.029	145	4.2	5.1	15.3	0.038	3660	2366	fbmy5635_rel_202302162102.cza1_ser7
998	3309	0	0.0	16.2	6.2	0.000	0.000	0.016	6.379	13449	7.1	4.065	172	4.2	5.1	15.5	0.036	3292	2589	fbmy5635_rel_202304122154.cza1_ser7
998	3700	0	0.0	16.4	6.3	0.000	0.000	0.016	6.452	14944	7.0	4.039	151	4.2	5.1	15.3	0.035	3644	2765	fbmy5635_rel_202305292102.cza1_ser7
998	3015	0	0.0	16.3	6.3	0.000	0.000	0.016	6.440	12314	7.1	4.084	188	4.2	5.1	15.7	0.036	2941	2493	fbmy5635_rel_20230529_832.cza1_ser7
998	3862	0	0.0	16.6	6.4	0.000	0.000	0.017	6.559	15576	7.0	4.033	145	4.1	5.0	15.7	0.036	3708	3101	fbmy5635_rel_20230529_843.cza1_ser7
998	3428	0	0.0	16.4	6.3	0.000	0.000	0.016	6.464	13902	7.1	4.056	166	4.2	5.1	15.6	0.035	3484	2605	fbmy5635_rel_20230529_850.cza1_ser7
998	3577	0	0.0	15.9	6.1	0.000	0.000	0.016	6.301	14450	7.0	4.040	157	4.2	5.1	15.8	0.036	3548	2781	fbmy5635_rel_221222.cza1_ser7

qp1000.L6

qp1000.L6: point queries with 1000 insert/s per client

Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
998	7080	5	0.6	18.7	6.7	0.001	0.090	0.019	6.889	29113	7.2	4.112	81	4.2	5.4	20.3	0.025	6649	6297	fbmy5635_rel_202104072149.cza1_ser7
998	6819	87	1.1	18.0	6.5	0.013	0.165	0.018	6.638	28229	7.1	4.140	83	4.2	5.5	20.7	0.012	6442	3852	fbmy5635_rel_202203072101.cza1_ser7
998	6822	58	1.0	17.9	6.4	0.009	0.157	0.018	6.601	28154	7.3	4.127	86	4.2	5.4	20.5	0.010	6393	4569	fbmy5635_rel_202205192101.cza1_ser7
998	6900	8	0.9	20.5	6.8	0.001	0.128	0.021	6.998	28397	7.3	4.115	85	4.1	5.4	20.4	0.009	6458	6105	fbmy5635_rel_202208092101.cza1_ser7
998	6911	6	0.7	19.9	6.6	0.001	0.102	0.020	6.769	28455	7.5	4.117	87	4.2	5.4	20.4	0.006	6505	6169	fbmy5635_rel_202210112144.cza1_ser7
998	7083	0	0.0	15.9	6.1	0.000	0.000	0.016	6.266	29129	7.2	4.112	81	4.2	5.4	16.9	0.002	6664	6142	fbmy5635_rel_202302162102.cza1_ser7
998	7019	0	0.0	16.0	6.1	0.000	0.000	0.016	6.273	28889	7.4	4.116	84	4.1	5.4	17.0	0.006	6601	6201	fbmy5635_rel_202304122154.cza1_ser7
998	6949	0	0.0	15.7	6.0	0.000	0.000	0.016	6.172	28605	7.2	4.116	83	4.2	5.5	16.8	0.001	6553	6201	fbmy5635_rel_202305292102.cza1_ser7
998	7025	0	0.0	16.0	6.1	0.000	0.000	0.016	6.221	28903	7.2	4.114	82	4.1	5.4	17.3	0.001	6617	6169	fbmy5635_rel_20230529_832.cza1_ser7
998	6862	0	0.0	15.6	5.9	0.000	0.000	0.016	6.057	28264	7.1	4.119	83	4.2	5.5	17.2	0.001	6425	6074	fbmy5635_rel_20230529_843.cza1_ser7
998	7052	8	0.0	15.8	5.9	0.001	0.005	0.016	6.084	29010	7.3	4.114	83	4.2	5.5	17.3	0.003	6648	6185	fbmy5635_rel_20230529_850.cza1_ser7
998	7020	6	0.0	16.0	6.1	0.001	0.005	0.016	6.225	28903	7.1	4.117	81	4.2	5.5	17.3	0.004	6633	6201	fbmy5635_rel_221222.cza1_ser7

l.i0

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	99.871	0.081	0.045	nonzero	0.003	0.000	0.000	0.000	0.000	0.107	fbmy5635_rel_202104072149.cza1_ser7
0.000	99.877	0.073	0.046	nonzero	0.003	0.000	0.000	0.000	0.000	0.110	fbmy5635_rel_202203072101.cza1_ser7
0.000	99.873	0.077	0.046	nonzero	0.003	0.000	0.000	0.000	0.000	0.119	fbmy5635_rel_202205192101.cza1_ser7
0.000	99.880	0.069	0.047	0.000	0.003	0.000	0.000	0.000	0.000	0.108	fbmy5635_rel_202208092101.cza1_ser7
0.000	99.873	0.076	0.047	nonzero	0.003	0.000	0.000	0.000	0.000	0.115	fbmy5635_rel_202210112144.cza1_ser7
0.000	99.863	0.085	0.048	nonzero	0.003	0.000	0.000	0.000	0.000	0.106	fbmy5635_rel_202302162102.cza1_ser7
0.000	99.883	0.067	0.046	nonzero	0.003	0.000	0.000	0.000	0.000	0.130	fbmy5635_rel_202304122154.cza1_ser7
0.000	99.874	0.075	0.048	0.000	0.003	0.000	0.000	0.000	0.000	0.109	fbmy5635_rel_202305292102.cza1_ser7
0.000	99.874	0.075	0.046	nonzero	0.003	0.000	0.000	0.000	0.000	0.102	fbmy5635_rel_20230529_832.cza1_ser7
0.000	99.871	0.077	0.048	nonzero	0.003	0.000	0.000	0.000	0.000	0.119	fbmy5635_rel_20230529_843.cza1_ser7
0.000	99.872	0.077	0.047	nonzero	0.003	0.000	0.000	0.000	0.000	0.118	fbmy5635_rel_20230529_850.cza1_ser7
0.000	99.873	0.075	0.048	nonzero	0.003	0.000	0.000	0.000	0.000	0.114	fbmy5635_rel_221222.cza1_ser7

l.x

TODO - determine whether there is data for create index response time


l.i1

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	99.102	0.825	0.068	nonzero	0.004	0.000	0.000	0.000	0.000	0.101	fbmy5635_rel_202104072149.cza1_ser7
0.000	98.991	0.935	0.069	0.001	0.004	0.000	0.000	0.000	0.000	0.098	fbmy5635_rel_202203072101.cza1_ser7
0.000	98.852	1.073	0.071	nonzero	0.004	0.000	0.000	0.000	0.000	0.102	fbmy5635_rel_202205192101.cza1_ser7
0.000	98.849	1.077	0.070	nonzero	0.004	0.000	0.000	0.000	0.000	0.137	fbmy5635_rel_202208092101.cza1_ser7
0.000	98.829	1.096	0.070	0.001	0.004	0.000	0.000	0.000	0.000	0.133	fbmy5635_rel_202210112144.cza1_ser7
0.000	99.176	0.751	0.068	0.001	0.004	0.000	0.000	0.000	0.000	0.099	fbmy5635_rel_202302162102.cza1_ser7
0.000	99.242	0.685	0.069	nonzero	0.004	0.000	0.000	0.000	0.000	0.095	fbmy5635_rel_202304122154.cza1_ser7
0.000	99.133	0.793	0.070	0.001	0.004	0.000	0.000	0.000	0.000	0.095	fbmy5635_rel_202305292102.cza1_ser7
0.000	99.156	0.770	0.069	0.001	0.004	0.000	0.000	0.000	0.000	0.098	fbmy5635_rel_20230529_832.cza1_ser7
0.000	99.086	0.841	0.068	0.001	0.004	0.000	0.000	0.000	0.000	0.098	fbmy5635_rel_20230529_843.cza1_ser7
0.000	98.944	0.982	0.069	0.001	0.004	0.000	0.000	0.000	0.000	0.108	fbmy5635_rel_20230529_850.cza1_ser7
0.000	98.844	1.081	0.070	0.001	0.004	0.000	0.000	0.000	0.000	0.101	fbmy5635_rel_221222.cza1_ser7

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	99.170	0.751	0.072	0.004	0.004	0.000	0.000	0.000	0.000	0.101	fbmy5635_rel_202104072149.cza1_ser7
0.000	99.130	0.787	0.074	0.004	0.004	0.000	0.000	0.000	0.000	0.097	fbmy5635_rel_202203072101.cza1_ser7
0.000	98.995	0.923	0.075	0.003	0.004	0.000	0.000	0.000	0.000	0.102	fbmy5635_rel_202205192101.cza1_ser7
0.000	98.990	0.928	0.075	0.003	0.004	0.000	0.000	0.000	0.000	0.137	fbmy5635_rel_202208092101.cza1_ser7
0.000	99.028	0.889	0.076	0.005	0.004	0.000	0.000	0.000	0.000	0.132	fbmy5635_rel_202210112144.cza1_ser7
0.000	99.250	0.672	0.072	0.002	0.004	0.000	0.000	0.000	0.000	0.099	fbmy5635_rel_202302162102.cza1_ser7
0.000	99.329	0.593	0.072	0.002	0.004	0.000	0.000	0.000	0.000	0.095	fbmy5635_rel_202304122154.cza1_ser7
0.000	99.262	0.659	0.072	0.003	0.004	0.000	0.000	0.000	0.000	0.095	fbmy5635_rel_202305292102.cza1_ser7
0.000	99.205	0.714	0.073	0.003	0.004	0.000	0.000	0.000	0.000	0.098	fbmy5635_rel_20230529_832.cza1_ser7
0.000	99.194	0.725	0.074	0.004	0.004	0.000	0.000	0.000	0.000	0.098	fbmy5635_rel_20230529_843.cza1_ser7
0.000	99.028	0.890	0.074	0.004	0.004	0.000	0.000	0.000	0.000	0.108	fbmy5635_rel_20230529_850.cza1_ser7
0.000	98.997	0.921	0.073	0.004	0.004	0.000	0.000	0.000	0.000	0.102	fbmy5635_rel_221222.cza1_ser7

l.i2

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.809	0.170	0.001	0.019	nonzero	nonzero	0.000	0.000	0.000	0.000	0.094	fbmy5635_rel_202104072149.cza1_ser7
99.797	0.182	0.001	0.019	nonzero	0.001	0.000	0.000	0.000	0.000	0.083	fbmy5635_rel_202203072101.cza1_ser7
99.759	0.220	0.001	0.020	nonzero	nonzero	0.000	0.000	0.000	0.000	0.087	fbmy5635_rel_202205192101.cza1_ser7
99.785	0.194	0.001	0.020	nonzero	nonzero	0.000	0.000	0.000	0.000	0.103	fbmy5635_rel_202208092101.cza1_ser7
99.766	0.212	0.001	0.020	0.001	nonzero	0.000	0.000	0.000	0.000	0.100	fbmy5635_rel_202210112144.cza1_ser7
99.780	0.199	0.001	0.019	0.001	nonzero	0.000	0.000	0.000	0.000	0.093	fbmy5635_rel_202302162102.cza1_ser7
99.778	0.201	0.001	0.020	nonzero	nonzero	0.000	0.000	0.000	0.000	0.086	fbmy5635_rel_202304122154.cza1_ser7
99.785	0.194	0.001	0.020	nonzero	nonzero	0.000	0.000	0.000	0.000	0.087	fbmy5635_rel_202305292102.cza1_ser7
99.793	0.186	0.001	0.020	nonzero	nonzero	0.000	0.000	0.000	0.000	0.084	fbmy5635_rel_20230529_832.cza1_ser7
99.774	0.204	0.001	0.020	nonzero	nonzero	0.000	0.000	0.000	0.000	0.093	fbmy5635_rel_20230529_843.cza1_ser7
99.768	0.211	0.001	0.019	nonzero	nonzero	0.000	0.000	0.000	0.000	0.083	fbmy5635_rel_20230529_850.cza1_ser7
99.793	0.185	0.001	0.020	0.001	nonzero	0.000	0.000	0.000	0.000	0.087	fbmy5635_rel_221222.cza1_ser7

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.399	0.578	0.002	0.020	nonzero	nonzero	0.000	0.000	0.000	0.000	0.094	fbmy5635_rel_202104072149.cza1_ser7
99.490	0.488	0.001	0.020	nonzero	0.001	0.000	0.000	0.000	0.000	0.083	fbmy5635_rel_202203072101.cza1_ser7
99.267	0.711	nonzero	0.020	nonzero	nonzero	0.000	0.000	0.000	0.000	0.087	fbmy5635_rel_202205192101.cza1_ser7
99.283	0.695	0.001	0.020	nonzero	nonzero	0.000	0.000	0.000	0.000	0.104	fbmy5635_rel_202208092101.cza1_ser7
99.323	0.654	0.001	0.021	0.001	nonzero	0.000	0.000	0.000	0.000	0.100	fbmy5635_rel_202210112144.cza1_ser7
99.333	0.645	0.001	0.020	0.001	nonzero	0.000	0.000	0.000	0.000	0.094	fbmy5635_rel_202302162102.cza1_ser7
99.315	0.663	0.001	0.020	nonzero	nonzero	0.000	0.000	0.000	0.000	0.086	fbmy5635_rel_202304122154.cza1_ser7
99.258	0.720	0.001	0.020	nonzero	nonzero	0.000	0.000	0.000	0.000	0.088	fbmy5635_rel_202305292102.cza1_ser7
99.426	0.552	0.001	0.020	nonzero	nonzero	0.000	0.000	0.000	0.000	0.084	fbmy5635_rel_20230529_832.cza1_ser7
99.257	0.721	0.001	0.020	nonzero	nonzero	0.000	0.000	0.000	0.000	0.093	fbmy5635_rel_20230529_843.cza1_ser7
99.291	0.687	0.001	0.020	nonzero	nonzero	0.000	0.000	0.000	0.000	0.084	fbmy5635_rel_20230529_850.cza1_ser7
99.230	0.748	0.001	0.021	0.001	nonzero	0.000	0.000	0.000	0.000	0.087	fbmy5635_rel_221222.cza1_ser7

qr100.L1

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
70.778	19.044	10.179	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.038	fbmy5635_rel_202104072149.cza1_ser7
73.904	21.564	4.532	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.036	fbmy5635_rel_202203072101.cza1_ser7
66.645	33.354	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.039	fbmy5635_rel_202205192101.cza1_ser7
68.689	30.107	1.204	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.040	fbmy5635_rel_202208092101.cza1_ser7
86.769	13.226	0.005	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	fbmy5635_rel_202210112144.cza1_ser7
66.845	19.831	13.324	0.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.038	fbmy5635_rel_202302162102.cza1_ser7
66.633	29.835	3.532	0.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.038	fbmy5635_rel_202304122154.cza1_ser7
77.036	22.938	0.026	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	fbmy5635_rel_202305292102.cza1_ser7
66.708	30.408	2.884	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	fbmy5635_rel_20230529_832.cza1_ser7
66.626	29.913	3.461	0.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.035	fbmy5635_rel_20230529_843.cza1_ser7
76.644	23.171	0.185	0.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.039	fbmy5635_rel_20230529_850.cza1_ser7
66.506	26.737	6.757	0.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.039	fbmy5635_rel_221222.cza1_ser7

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	6.139	93.611	0.250	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202104072149.cza1_ser7
0.000	2.194	97.556	0.250	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202203072101.cza1_ser7
0.000	2.083	97.583	0.333	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202205192101.cza1_ser7
0.000	1.389	98.194	0.417	0.000	0.000	0.000	0.000	0.000	0.000	0.009	fbmy5635_rel_202208092101.cza1_ser7
0.000	12.583	87.083	0.333	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202210112144.cza1_ser7
0.000	0.972	98.500	0.528	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202302162102.cza1_ser7
0.000	2.139	97.389	0.472	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202304122154.cza1_ser7
0.000	2.667	96.944	0.389	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202305292102.cza1_ser7
0.000	4.250	95.472	0.278	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_20230529_832.cza1_ser7
0.000	2.500	97.000	0.500	0.000	0.000	0.000	0.000	0.000	0.000	0.009	fbmy5635_rel_20230529_843.cza1_ser7
0.000	3.472	96.028	0.500	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_20230529_850.cza1_ser7
0.000	4.306	95.389	0.306	0.000	0.000	0.000	0.000	0.000	0.000	0.015	fbmy5635_rel_221222.cza1_ser7

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	7.139	92.583	0.278	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202104072149.cza1_ser7
0.000	11.111	88.611	0.278	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202203072101.cza1_ser7
0.000	5.611	94.083	0.306	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202205192101.cza1_ser7
0.000	4.972	94.694	0.333	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202208092101.cza1_ser7
0.000	7.250	92.417	0.333	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202210112144.cza1_ser7
0.000	2.861	96.694	0.444	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202302162102.cza1_ser7
0.000	1.694	97.972	0.333	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202304122154.cza1_ser7
0.000	17.472	82.250	0.278	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202305292102.cza1_ser7
0.000	5.917	93.750	0.333	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_20230529_832.cza1_ser7
0.000	5.417	94.139	0.444	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_20230529_843.cza1_ser7
0.000	7.694	91.917	0.389	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_20230529_850.cza1_ser7
0.000	8.056	91.639	0.306	0.000	0.000	0.000	0.000	0.000	0.000	0.015	fbmy5635_rel_221222.cza1_ser7

qp100.L2

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.847	0.153	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	fbmy5635_rel_202104072149.cza1_ser7
99.804	0.196	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	fbmy5635_rel_202203072101.cza1_ser7
99.789	0.211	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	fbmy5635_rel_202205192101.cza1_ser7
99.801	0.199	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	fbmy5635_rel_202208092101.cza1_ser7
99.816	0.184	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	fbmy5635_rel_202210112144.cza1_ser7
99.764	0.236	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	fbmy5635_rel_202302162102.cza1_ser7
99.829	0.171	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	fbmy5635_rel_202304122154.cza1_ser7
99.757	0.243	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	fbmy5635_rel_202305292102.cza1_ser7
99.816	0.184	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	fbmy5635_rel_20230529_832.cza1_ser7
99.743	0.257	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	fbmy5635_rel_20230529_843.cza1_ser7
99.775	0.225	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	fbmy5635_rel_20230529_850.cza1_ser7
99.800	0.200	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	fbmy5635_rel_221222.cza1_ser7

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	4.750	94.917	0.333	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202104072149.cza1_ser7
0.000	5.000	94.639	0.361	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202203072101.cza1_ser7
0.000	3.972	95.694	0.333	0.000	0.000	0.000	0.000	0.000	0.000	0.010	fbmy5635_rel_202205192101.cza1_ser7
0.000	2.889	96.722	0.389	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202208092101.cza1_ser7
0.000	2.639	96.972	0.389	0.000	0.000	0.000	0.000	0.000	0.000	0.009	fbmy5635_rel_202210112144.cza1_ser7
0.000	2.250	97.361	0.389	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202302162102.cza1_ser7
0.000	6.917	92.694	0.389	0.000	0.000	0.000	0.000	0.000	0.000	0.014	fbmy5635_rel_202304122154.cza1_ser7
0.000	6.722	92.944	0.333	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202305292102.cza1_ser7
0.000	9.833	89.833	0.333	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_20230529_832.cza1_ser7
0.000	2.278	97.306	0.417	0.000	0.000	0.000	0.000	0.000	0.000	0.012	fbmy5635_rel_20230529_843.cza1_ser7
0.000	1.833	97.722	0.444	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_20230529_850.cza1_ser7
0.000	5.806	93.889	0.306	0.000	0.000	0.000	0.000	0.000	0.000	0.009	fbmy5635_rel_221222.cza1_ser7

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	7.361	92.333	0.306	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202104072149.cza1_ser7
0.000	3.333	96.306	0.361	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202203072101.cza1_ser7
0.000	2.194	97.528	0.278	0.000	0.000	0.000	0.000	0.000	0.000	0.010	fbmy5635_rel_202205192101.cza1_ser7
0.000	2.500	97.222	0.278	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202208092101.cza1_ser7
0.000	3.417	96.278	0.306	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202210112144.cza1_ser7
0.000	5.306	94.361	0.333	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202302162102.cza1_ser7
0.000	6.278	93.306	0.417	0.000	0.000	0.000	0.000	0.000	0.000	0.013	fbmy5635_rel_202304122154.cza1_ser7
0.000	3.694	96.000	0.306	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202305292102.cza1_ser7
0.000	6.556	93.194	0.250	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_20230529_832.cza1_ser7
0.000	4.083	95.583	0.333	0.000	0.000	0.000	0.000	0.000	0.000	0.012	fbmy5635_rel_20230529_843.cza1_ser7
0.000	2.556	97.056	0.389	0.000	0.000	0.000	0.000	0.000	0.000	0.009	fbmy5635_rel_20230529_850.cza1_ser7
0.000	8.556	91.167	0.278	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_221222.cza1_ser7

qr500.L3

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
66.635	23.032	10.333	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.035	fbmy5635_rel_202104072149.cza1_ser7
73.784	22.064	4.152	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.040	fbmy5635_rel_202203072101.cza1_ser7
66.619	33.372	0.009	0.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.036	fbmy5635_rel_202205192101.cza1_ser7
71.694	27.519	0.787	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.041	fbmy5635_rel_202208092101.cza1_ser7
67.032	32.953	0.014	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.042	fbmy5635_rel_202210112144.cza1_ser7
73.662	22.305	4.034	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.034	fbmy5635_rel_202302162102.cza1_ser7
71.321	22.272	6.407	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.035	fbmy5635_rel_202304122154.cza1_ser7
66.779	30.509	2.712	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.034	fbmy5635_rel_202305292102.cza1_ser7
73.504	24.278	2.218	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.040	fbmy5635_rel_20230529_832.cza1_ser7
69.529	23.694	6.777	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.039	fbmy5635_rel_20230529_843.cza1_ser7
70.180	25.166	4.655	0.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.034	fbmy5635_rel_20230529_850.cza1_ser7
76.803	19.126	4.072	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.034	fbmy5635_rel_221222.cza1_ser7

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	8.261	91.528	0.211	0.000	0.000	0.000	0.000	0.000	0.000	0.009	fbmy5635_rel_202104072149.cza1_ser7
0.000	23.689	76.167	0.144	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202203072101.cza1_ser7
0.000	3.111	96.717	0.172	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202205192101.cza1_ser7
0.000	9.639	90.261	0.100	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202208092101.cza1_ser7
0.000	4.128	95.700	0.172	0.000	0.000	0.000	0.000	0.000	0.000	0.009	fbmy5635_rel_202210112144.cza1_ser7
0.000	19.739	80.089	0.172	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202302162102.cza1_ser7
0.000	10.111	89.717	0.172	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202304122154.cza1_ser7
0.000	3.411	96.383	0.206	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202305292102.cza1_ser7
0.000	6.211	93.611	0.178	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_20230529_832.cza1_ser7
0.000	3.428	96.389	0.183	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_20230529_843.cza1_ser7
0.000	4.889	94.889	0.222	0.000	0.000	0.000	0.000	0.000	0.000	0.011	fbmy5635_rel_20230529_850.cza1_ser7
0.000	7.867	91.939	0.194	0.000	0.000	0.000	0.000	0.000	0.000	0.013	fbmy5635_rel_221222.cza1_ser7

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	13.661	86.128	0.211	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202104072149.cza1_ser7
0.000	8.711	91.117	0.172	0.000	0.000	0.000	0.000	0.000	0.000	0.009	fbmy5635_rel_202203072101.cza1_ser7
0.000	7.378	92.456	0.167	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202205192101.cza1_ser7
0.000	6.022	93.817	0.161	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202208092101.cza1_ser7
0.000	15.533	84.294	0.172	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202210112144.cza1_ser7
0.000	8.472	91.350	0.178	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202302162102.cza1_ser7
0.000	19.194	80.633	0.172	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202304122154.cza1_ser7
0.000	7.100	92.700	0.200	0.000	0.000	0.000	0.000	0.000	0.000	0.009	fbmy5635_rel_202305292102.cza1_ser7
0.000	14.817	85.006	0.178	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_20230529_832.cza1_ser7
0.000	7.511	92.306	0.183	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_20230529_843.cza1_ser7
0.000	15.422	84.350	0.228	0.000	0.000	0.000	0.000	0.000	0.000	0.012	fbmy5635_rel_20230529_850.cza1_ser7
0.000	6.806	93.033	0.161	0.000	0.000	0.000	0.000	0.000	0.000	0.014	fbmy5635_rel_221222.cza1_ser7

qp500.L4

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.836	0.164	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	fbmy5635_rel_202104072149.cza1_ser7
99.735	0.265	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	fbmy5635_rel_202203072101.cza1_ser7
99.744	0.256	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	fbmy5635_rel_202205192101.cza1_ser7
99.690	0.310	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	fbmy5635_rel_202208092101.cza1_ser7
99.784	0.216	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.004	fbmy5635_rel_202210112144.cza1_ser7
99.752	0.248	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	fbmy5635_rel_202302162102.cza1_ser7
99.758	0.242	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	fbmy5635_rel_202304122154.cza1_ser7
99.736	0.264	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	fbmy5635_rel_202305292102.cza1_ser7
99.747	0.253	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	fbmy5635_rel_20230529_832.cza1_ser7
99.704	0.296	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	fbmy5635_rel_20230529_843.cza1_ser7
99.736	0.264	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	fbmy5635_rel_20230529_850.cza1_ser7
99.768	0.232	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	fbmy5635_rel_221222.cza1_ser7

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	6.950	92.817	0.233	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202104072149.cza1_ser7
0.000	6.761	93.039	0.200	0.000	0.000	0.000	0.000	0.000	0.000	0.012	fbmy5635_rel_202203072101.cza1_ser7
0.000	10.328	89.467	0.206	0.000	0.000	0.000	0.000	0.000	0.000	0.014	fbmy5635_rel_202205192101.cza1_ser7
0.000	9.444	90.356	0.200	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202208092101.cza1_ser7
0.000	7.517	92.300	0.183	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202210112144.cza1_ser7
0.000	5.533	94.294	0.172	0.000	0.000	0.000	0.000	0.000	0.000	0.009	fbmy5635_rel_202302162102.cza1_ser7
0.000	11.211	88.578	0.211	0.000	0.000	0.000	0.000	0.000	0.000	0.009	fbmy5635_rel_202304122154.cza1_ser7
0.000	9.539	90.272	0.189	0.000	0.000	0.000	0.000	0.000	0.000	0.013	fbmy5635_rel_202305292102.cza1_ser7
0.000	6.711	93.089	0.200	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_20230529_832.cza1_ser7
0.000	9.200	90.594	0.206	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_20230529_843.cza1_ser7
0.000	6.300	93.456	0.244	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_20230529_850.cza1_ser7
0.000	10.117	89.672	0.211	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_221222.cza1_ser7

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	9.239	90.528	0.233	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202104072149.cza1_ser7
0.000	6.894	92.906	0.200	0.000	0.000	0.000	0.000	0.000	0.000	0.012	fbmy5635_rel_202203072101.cza1_ser7
0.000	9.461	90.339	0.200	0.000	0.000	0.000	0.000	0.000	0.000	0.013	fbmy5635_rel_202205192101.cza1_ser7
0.000	8.939	90.861	0.200	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202208092101.cza1_ser7
0.000	10.094	89.711	0.194	0.000	0.000	0.000	0.000	0.000	0.000	0.009	fbmy5635_rel_202210112144.cza1_ser7
0.000	9.694	90.122	0.183	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202302162102.cza1_ser7
0.000	12.833	86.950	0.217	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202304122154.cza1_ser7
0.000	9.456	90.339	0.206	0.000	0.000	0.000	0.000	0.000	0.000	0.012	fbmy5635_rel_202305292102.cza1_ser7
0.000	11.672	88.117	0.211	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_20230529_832.cza1_ser7
0.000	14.106	85.683	0.211	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_20230529_843.cza1_ser7
0.000	11.122	88.639	0.239	0.000	0.000	0.000	0.000	0.000	0.000	0.009	fbmy5635_rel_20230529_850.cza1_ser7
0.000	13.633	86.156	0.211	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_221222.cza1_ser7

qr1000.L5

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
87.313	11.780	0.907	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.050	fbmy5635_rel_202104072149.cza1_ser7
69.959	26.621	3.419	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.035	fbmy5635_rel_202203072101.cza1_ser7
75.400	19.106	5.494	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.168	fbmy5635_rel_202205192101.cza1_ser7
73.197	20.649	6.153	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.036	fbmy5635_rel_202208092101.cza1_ser7
75.247	21.243	3.510	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.038	fbmy5635_rel_202210112144.cza1_ser7
77.913	17.175	4.912	0.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.038	fbmy5635_rel_202302162102.cza1_ser7
73.210	19.946	6.844	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.036	fbmy5635_rel_202304122154.cza1_ser7
72.751	21.616	5.633	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.035	fbmy5635_rel_202305292102.cza1_ser7
70.674	21.171	8.154	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.036	fbmy5635_rel_20230529_832.cza1_ser7
72.959	25.105	1.936	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.036	fbmy5635_rel_20230529_843.cza1_ser7
72.881	23.798	3.320	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.035	fbmy5635_rel_20230529_850.cza1_ser7
72.737	25.033	2.229	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.036	fbmy5635_rel_221222.cza1_ser7

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	6.403	93.433	0.161	0.003	0.000	0.000	0.000	0.000	0.000	0.048	fbmy5635_rel_202104072149.cza1_ser7
0.000	10.642	89.147	0.208	0.003	0.000	0.000	0.000	0.000	0.000	0.049	fbmy5635_rel_202203072101.cza1_ser7
0.000	11.719	88.139	0.139	0.003	0.000	0.000	0.000	0.000	0.000	0.047	fbmy5635_rel_202205192101.cza1_ser7
0.000	7.933	91.808	0.253	0.006	0.000	0.000	0.000	0.000	0.000	0.055	fbmy5635_rel_202208092101.cza1_ser7
0.000	4.761	95.089	0.147	0.003	0.000	0.000	0.000	0.000	0.000	0.056	fbmy5635_rel_202210112144.cza1_ser7
0.000	4.747	95.086	0.164	0.003	0.000	0.000	0.000	0.000	0.000	0.037	fbmy5635_rel_202302162102.cza1_ser7
0.000	8.544	91.294	0.158	0.003	0.000	0.000	0.000	0.000	0.000	0.048	fbmy5635_rel_202304122154.cza1_ser7
0.000	10.853	88.978	0.167	0.003	0.000	0.000	0.000	0.000	0.000	0.049	fbmy5635_rel_202305292102.cza1_ser7
0.000	10.853	88.989	0.156	0.003	0.000	0.000	0.000	0.000	0.000	0.038	fbmy5635_rel_20230529_832.cza1_ser7
0.000	9.197	90.653	0.147	0.003	0.000	0.000	0.000	0.000	0.000	0.038	fbmy5635_rel_20230529_843.cza1_ser7
0.000	6.081	93.719	0.197	0.003	0.000	0.000	0.000	0.000	0.000	0.040	fbmy5635_rel_20230529_850.cza1_ser7
0.000	10.378	89.444	0.175	0.003	0.000	0.000	0.000	0.000	0.000	0.049	fbmy5635_rel_221222.cza1_ser7

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	10.153	89.706	0.139	0.003	0.000	0.000	0.000	0.000	0.000	0.048	fbmy5635_rel_202104072149.cza1_ser7
0.000	16.189	83.608	0.200	0.003	0.000	0.000	0.000	0.000	0.000	0.049	fbmy5635_rel_202203072101.cza1_ser7
0.000	9.494	90.353	0.147	0.006	0.000	0.000	0.000	0.000	0.000	0.061	fbmy5635_rel_202205192101.cza1_ser7
0.000	14.289	85.436	0.269	0.006	0.000	0.000	0.000	0.000	0.000	0.056	fbmy5635_rel_202208092101.cza1_ser7
0.000	14.825	85.008	0.161	0.006	0.000	0.000	0.000	0.000	0.000	0.055	fbmy5635_rel_202210112144.cza1_ser7
0.000	5.578	94.261	0.158	0.003	0.000	0.000	0.000	0.000	0.000	0.038	fbmy5635_rel_202302162102.cza1_ser7
0.000	10.011	89.828	0.158	0.003	0.000	0.000	0.000	0.000	0.000	0.048	fbmy5635_rel_202304122154.cza1_ser7
0.000	8.917	90.906	0.172	0.006	0.000	0.000	0.000	0.000	0.000	0.049	fbmy5635_rel_202305292102.cza1_ser7
0.000	9.608	90.222	0.167	0.003	0.000	0.000	0.000	0.000	0.000	0.038	fbmy5635_rel_20230529_832.cza1_ser7
0.000	14.619	85.239	0.139	0.003	0.000	0.000	0.000	0.000	0.000	0.038	fbmy5635_rel_20230529_843.cza1_ser7
0.000	8.558	91.250	0.189	0.003	0.000	0.000	0.000	0.000	0.000	0.039	fbmy5635_rel_20230529_850.cza1_ser7
0.000	9.931	89.883	0.178	0.008	0.000	0.000	0.000	0.000	0.000	0.056	fbmy5635_rel_221222.cza1_ser7

qp1000.L6

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.814	0.186	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.025	fbmy5635_rel_202104072149.cza1_ser7
99.307	0.692	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.012	fbmy5635_rel_202203072101.cza1_ser7
99.438	0.562	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.010	fbmy5635_rel_202205192101.cza1_ser7
99.709	0.291	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.009	fbmy5635_rel_202208092101.cza1_ser7
99.757	0.243	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.006	fbmy5635_rel_202210112144.cza1_ser7
99.716	0.284	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	fbmy5635_rel_202302162102.cza1_ser7
99.760	0.240	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.006	fbmy5635_rel_202304122154.cza1_ser7
99.749	0.251	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	fbmy5635_rel_202305292102.cza1_ser7
99.707	0.293	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	fbmy5635_rel_20230529_832.cza1_ser7
99.688	0.312	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	fbmy5635_rel_20230529_843.cza1_ser7
99.728	0.272	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	fbmy5635_rel_20230529_850.cza1_ser7
99.746	0.254	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.004	fbmy5635_rel_221222.cza1_ser7

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	8.164	91.736	0.097	0.003	0.000	0.000	0.000	0.000	0.000	0.047	fbmy5635_rel_202104072149.cza1_ser7
0.000	10.286	89.622	0.089	0.003	0.000	0.000	0.000	0.000	0.000	0.054	fbmy5635_rel_202203072101.cza1_ser7
0.000	9.089	90.711	0.197	0.003	0.000	0.000	0.000	0.000	0.000	0.047	fbmy5635_rel_202205192101.cza1_ser7
0.000	9.050	90.806	0.142	0.003	0.000	0.000	0.000	0.000	0.000	0.053	fbmy5635_rel_202208092101.cza1_ser7
0.000	9.931	89.833	0.233	0.003	0.000	0.000	0.000	0.000	0.000	0.045	fbmy5635_rel_202210112144.cza1_ser7
0.000	12.008	87.819	0.169	0.003	0.000	0.000	0.000	0.000	0.000	0.047	fbmy5635_rel_202302162102.cza1_ser7
0.000	6.822	92.997	0.178	0.003	0.000	0.000	0.000	0.000	0.000	0.048	fbmy5635_rel_202304122154.cza1_ser7
0.000	11.897	87.936	0.164	0.003	0.000	0.000	0.000	0.000	0.000	0.048	fbmy5635_rel_202305292102.cza1_ser7
0.000	11.792	88.025	0.181	0.003	0.000	0.000	0.000	0.000	0.000	0.052	fbmy5635_rel_20230529_832.cza1_ser7
0.000	7.844	91.964	0.189	0.003	0.000	0.000	0.000	0.000	0.000	0.047	fbmy5635_rel_20230529_843.cza1_ser7
0.000	12.886	86.961	0.150	0.003	0.000	0.000	0.000	0.000	0.000	0.047	fbmy5635_rel_20230529_850.cza1_ser7
0.000	12.467	87.358	0.172	0.003	0.000	0.000	0.000	0.000	0.000	0.037	fbmy5635_rel_221222.cza1_ser7

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	13.494	86.400	0.103	0.003	0.000	0.000	0.000	0.000	0.000	0.047	fbmy5635_rel_202104072149.cza1_ser7
0.000	13.589	86.311	0.097	0.003	0.000	0.000	0.000	0.000	0.000	0.054	fbmy5635_rel_202203072101.cza1_ser7
0.000	11.467	88.353	0.178	0.003	0.000	0.000	0.000	0.000	0.000	0.048	fbmy5635_rel_202205192101.cza1_ser7
0.000	13.481	86.378	0.139	0.003	0.000	0.000	0.000	0.000	0.000	0.053	fbmy5635_rel_202208092101.cza1_ser7
0.000	8.639	91.150	0.208	0.003	0.000	0.000	0.000	0.000	0.000	0.045	fbmy5635_rel_202210112144.cza1_ser7
0.000	11.039	88.769	0.189	0.003	0.000	0.000	0.000	0.000	0.000	0.047	fbmy5635_rel_202302162102.cza1_ser7
0.000	11.422	88.397	0.178	0.003	0.000	0.000	0.000	0.000	0.000	0.048	fbmy5635_rel_202304122154.cza1_ser7
0.000	10.850	88.975	0.172	0.003	0.000	0.000	0.000	0.000	0.000	0.048	fbmy5635_rel_202305292102.cza1_ser7
0.000	15.275	84.556	0.167	0.003	0.000	0.000	0.000	0.000	0.000	0.051	fbmy5635_rel_20230529_832.cza1_ser7
0.000	9.839	89.967	0.189	0.006	0.000	0.000	0.000	0.000	0.000	0.052	fbmy5635_rel_20230529_843.cza1_ser7
0.000	11.069	88.753	0.175	0.003	0.000	0.000	0.000	0.000	0.000	0.047	fbmy5635_rel_20230529_850.cza1_ser7
0.000	11.703	88.128	0.167	0.003	0.000	0.000	0.000	0.000	0.000	0.037	fbmy5635_rel_221222.cza1_ser7