Introduction

This is a report for the insert benchmark with 3200M docs and 8 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 is a c2-standard-30 from GCP with 15 cores, hyperthreads disabled, 120G RAM, XFS + SW RAID 0 on 4 NVMe devices (1.5TB). The benchmark was run with 8 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). There are 8 tables, client per table. It loads 400M rows per table without secondary indexes, creates secondary indexes, then inserts 10M rows per table with a delete per insert to avoid growing the table. It then does 3 read+write tests for 1800s each that do queries as fast as possible with 100, 500 and then 1000 inserts/second/client concurrent with the queries and 1000 deletes/second to avoid growing the table. The database is larger than memory.

The tested DBMS are:


Contents


Summary

The numbers are inserts/s for l.i0 and l.i1, indexed docs (or rows) /s for l.x and queries/s for q*.2. 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.i1q100.1q500.1q1000.1
3200m.my8033_rel_lto.cy10a_gcp_c2s30 70953462722518022453150844810
3200m.my8033_rel_lto.cy10a1_gcp_c2s30 69474656489016508471053265039
3200m.my8033_rel_lto.cy10a2_gcp_c2s30 70021962734817403451950574836
3200m.my8033_rel_lto.cy10a3_gcp_c2s30 69914861351617486446150384787
3200m.my8033_rel_lto.cy10a4_gcp_c2s30 69039956270410008204027502478
3200m.my8033_rel_lto.cy10a5_gcp_c2s30 7039165978145995478437002519
3200m.my8033_rel_lto.cy10a6_gcp_c2s30 70160063318217460415946254221
3200m.my8033_rel_lto.cy10a7_gcp_c2s30 69884260516318442454950664817
3200m.my8033_rel_lto.cy10a8_gcp_c2s30 70006662624318850457751004877
3200m.my8033_rel_lto.cy10a9_gcp_c2s30 69686460061918792465751964936
3200m.my8033_rel_lto.cy10a10_gcp_c2s30 70593461117313282387640143650
3200m.my8033_rel_lto.cy10a11_gcp_c2s30 69519960129613498426349034528

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.

dbmsl.i0l.xl.i1q100.1q500.1q1000.1
3200m.my8033_rel_lto.cy10a_gcp_c2s30 1.001.001.001.001.001.00
3200m.my8033_rel_lto.cy10a1_gcp_c2s30 0.980.900.921.041.051.05
3200m.my8033_rel_lto.cy10a2_gcp_c2s30 0.991.000.971.000.991.01
3200m.my8033_rel_lto.cy10a3_gcp_c2s30 0.990.980.970.980.991.00
3200m.my8033_rel_lto.cy10a4_gcp_c2s30 0.970.900.560.450.540.52
3200m.my8033_rel_lto.cy10a5_gcp_c2s30 0.990.950.331.060.730.52
3200m.my8033_rel_lto.cy10a6_gcp_c2s30 0.991.010.970.920.910.88
3200m.my8033_rel_lto.cy10a7_gcp_c2s30 0.980.961.021.001.001.00
3200m.my8033_rel_lto.cy10a8_gcp_c2s30 0.991.001.051.011.001.01
3200m.my8033_rel_lto.cy10a9_gcp_c2s30 0.980.961.041.031.021.03
3200m.my8033_rel_lto.cy10a10_gcp_c2s30 0.990.970.740.860.790.76
3200m.my8033_rel_lto.cy10a11_gcp_c2s30 0.980.960.750.940.960.94

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.

dbmsq100.1q500.1q1000.1
my8033_rel_lto.cy10a_gcp_c2s3079139717938
my8033_rel_lto.cy10a1_gcp_c2s3079039607916
my8033_rel_lto.cy10a2_gcp_c2s3079139717938
my8033_rel_lto.cy10a3_gcp_c2s3079039717938
my8033_rel_lto.cy10a4_gcp_c2s3078039437860
my8033_rel_lto.cy10a5_gcp_c2s3078939697028
my8033_rel_lto.cy10a6_gcp_c2s3079039717938
my8033_rel_lto.cy10a7_gcp_c2s3079139717938
my8033_rel_lto.cy10a8_gcp_c2s3079139717943
my8033_rel_lto.cy10a9_gcp_c2s3079239717938
my8033_rel_lto.cy10a10_gcp_c2s3079239747943
my8033_rel_lto.cy10a11_gcp_c2s3079239717943
target80040008000

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
my8033_rel_lto.cy10a_gcp_c2s3010.48389.4240.0620.0170.0140.0010.311
my8033_rel_lto.cy10a1_gcp_c2s307.26292.6450.0590.0190.015nonzero0.287
my8033_rel_lto.cy10a2_gcp_c2s305.39094.5120.0650.0190.0140.0010.310
my8033_rel_lto.cy10a3_gcp_c2s305.30594.5990.0620.0180.0140.0010.312
my8033_rel_lto.cy10a4_gcp_c2s306.25093.5010.2170.0180.0150.245
my8033_rel_lto.cy10a5_gcp_c2s307.16692.7390.0610.0180.014nonzero0.300
my8033_rel_lto.cy10a6_gcp_c2s305.72094.1840.0630.0180.0140.0010.299
my8033_rel_lto.cy10a7_gcp_c2s306.00893.8970.0630.0180.0140.0010.299
my8033_rel_lto.cy10a8_gcp_c2s305.68094.2220.0650.0180.0140.0010.300
my8033_rel_lto.cy10a9_gcp_c2s304.55995.3480.0600.0180.0140.0010.302
my8033_rel_lto.cy10a10_gcp_c2s309.50990.3770.0820.0170.0140.0010.311
my8033_rel_lto.cy10a11_gcp_c2s304.63995.2400.0710.0350.0140.0010.296

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
709534	0	0	0.0	3673.1	202.5	0.000	0.000	0.005	0.292	180663	76.9	0.255	16	209.7	338.3	86.9	0.311	91301	69824	3200m.my8033_rel_lto.cy10a_gcp_c2s30
694746	0	0	0.0	3604.1	198.6	0.000	0.000	0.005	0.293	165564	77.0	0.238	17	209.7	338.3	86.9	0.287	88803	69925	3200m.my8033_rel_lto.cy10a1_gcp_c2s30
700219	0	0	0.0	3681.4	201.0	0.000	0.000	0.005	0.294	170799	76.8	0.244	16	209.7	338.3	86.9	0.310	90001	69746	3200m.my8033_rel_lto.cy10a2_gcp_c2s30
699148	0	0	0.0	3680.6	201.1	0.000	0.000	0.005	0.295	162641	76.7	0.233	16	209.7	338.3	86.9	0.312	90003	69524	3200m.my8033_rel_lto.cy10a3_gcp_c2s30
690399	0	0	0.0	1543.5	187.8	0.000	0.000	0.002	0.279	170999	76.9	0.248	17	209.7	338.3	86.9	0.245	88348	70455	3200m.my8033_rel_lto.cy10a4_gcp_c2s30
703916	0	0	0.0	3647.0	200.7	0.000	0.000	0.005	0.292	177965	76.9	0.253	16	209.7	338.3	86.9	0.300	90202	70423	3200m.my8033_rel_lto.cy10a5_gcp_c2s30
701600	0	0	0.0	3635.8	200.7	0.000	0.000	0.005	0.293	170046	76.9	0.242	16	209.7	338.3	86.9	0.299	89702	69125	3200m.my8033_rel_lto.cy10a6_gcp_c2s30
698842	0	0	0.0	3627.7	199.9	0.000	0.000	0.005	0.293	165302	76.7	0.237	16	209.7	338.3	86.7	0.299	89981	69349	3200m.my8033_rel_lto.cy10a7_gcp_c2s30
700066	0	0	0.0	3630.1	200.0	0.000	0.000	0.005	0.293	167180	76.8	0.239	16	209.7	338.3	86.5	0.300	89602	69349	3200m.my8033_rel_lto.cy10a8_gcp_c2s30
696864	0	0	0.0	3617.8	199.5	0.000	0.000	0.005	0.293	161357	76.7	0.232	17	209.7	338.3	86.0	0.302	89402	69024	3200m.my8033_rel_lto.cy10a9_gcp_c2s30
705934	0	0	0.0	3654.1	201.3	0.000	0.000	0.005	0.292	177876	76.9	0.252	16	209.7	338.3	86.9	0.311	90103	68825	3200m.my8033_rel_lto.cy10a10_gcp_c2s30
695199	0	0	0.0	3784.6	205.1	0.000	0.000	0.005	0.302	159430	76.5	0.229	17	209.7	226.3	86.9	0.296	89203	69048	3200m.my8033_rel_lto.cy10a11_gcp_c2s30

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
627225	0	7639	675.9	13252.9	808.9	0.012	1.104	0.021	1.321	58138	57.4	0.093	14	468.9	597.5	86.9	0.005	NA	NA	3200m.my8033_rel_lto.cy10a_gcp_c2s30
564890	0	6858	581.3	11886.1	732.0	0.012	1.054	0.021	1.327	50826	55.9	0.090	15	468.9	597.5	86.9	0.005	NA	NA	3200m.my8033_rel_lto.cy10a1_gcp_c2s30
627348	0	7576	645.0	13069.0	807.7	0.012	1.053	0.021	1.318	48505	59.1	0.077	14	468.9	597.5	86.9	0.006	NA	NA	3200m.my8033_rel_lto.cy10a2_gcp_c2s30
613516	0	7469	644.3	12795.3	787.5	0.012	1.075	0.021	1.314	45594	56.1	0.074	14	468.9	597.5	86.9	0.004	NA	NA	3200m.my8033_rel_lto.cy10a3_gcp_c2s30
562704	0	5284	594.3	11219.9	716.6	0.009	1.081	0.020	1.304	92667	55.0	0.165	15	468.9	597.5	86.9	0.006	NA	NA	3200m.my8033_rel_lto.cy10a4_gcp_c2s30
597814	0	7205	619.3	12546.9	781.9	0.012	1.061	0.021	1.339	46647	56.6	0.078	14	468.9	597.5	86.9	0.004	NA	NA	3200m.my8033_rel_lto.cy10a5_gcp_c2s30
633182	0	7723	689.9	13357.5	818.8	0.012	1.116	0.021	1.324	53308	55.8	0.084	13	468.9	597.5	86.9	0.003	NA	NA	3200m.my8033_rel_lto.cy10a6_gcp_c2s30
605163	0	7382	646.6	12772.3	776.1	0.012	1.094	0.021	1.313	54989	55.4	0.091	14	468.9	597.5	86.9	0.004	NA	NA	3200m.my8033_rel_lto.cy10a7_gcp_c2s30
626243	0	7630	679.8	13306.0	806.0	0.012	1.112	0.021	1.318	56268	55.8	0.090	13	468.9	597.5	86.9	0.005	NA	NA	3200m.my8033_rel_lto.cy10a8_gcp_c2s30
600619	0	7321	640.1	12640.0	777.6	0.012	1.091	0.021	1.326	53463	55.3	0.089	14	468.9	597.5	86.9	0.003	NA	NA	3200m.my8033_rel_lto.cy10a9_gcp_c2s30
611173	0	7439	656.3	12573.3	787.0	0.012	1.100	0.021	1.319	52481	55.3	0.086	14	468.9	597.5	86.9	0.004	NA	NA	3200m.my8033_rel_lto.cy10a10_gcp_c2s30
601296	0	7288	639.5	12514.4	775.0	0.012	1.089	0.021	1.320	49263	55.3	0.082	14	468.9	485.5	86.9	0.006	NA	NA	3200m.my8033_rel_lto.cy10a11_gcp_c2s30

l.i1

l.i1: continue load after secondary indexes created. 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
my8033_rel_lto.cy10a_gcp_c2s300.77168.50822.1678.5530.0020.282
my8033_rel_lto.cy10a1_gcp_c2s301.17065.50123.6219.7020.0070.314
my8033_rel_lto.cy10a2_gcp_c2s301.03467.41022.6008.9400.0160.367
my8033_rel_lto.cy10a3_gcp_c2s300.66767.57522.8698.8690.0200.369
my8033_rel_lto.cy10a4_gcp_c2s300.62755.52128.22013.0982.5340.578
my8033_rel_lto.cy10a5_gcp_c2s3057.71442.285nonzero0.283
my8033_rel_lto.cy10a6_gcp_c2s300.38666.81324.1238.6770.0010.287
my8033_rel_lto.cy10a7_gcp_c2s301.12969.02521.4958.3480.0030.306
my8033_rel_lto.cy10a8_gcp_c2s301.25969.91420.5968.2280.0030.327
my8033_rel_lto.cy10a9_gcp_c2s301.25869.84120.5918.3050.0050.303
my8033_rel_lto.cy10a10_gcp_c2s300.02139.39249.50511.0450.0360.369
my8033_rel_lto.cy10a11_gcp_c2s300.15066.72425.2936.9190.4830.4312.167

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
my8033_rel_lto.cy10a_gcp_c2s3021.33874.6913.7270.2440.256
my8033_rel_lto.cy10a1_gcp_c2s3022.69172.6754.3240.3030.0070.300
my8033_rel_lto.cy10a2_gcp_c2s3021.59874.1763.9750.2370.0140.379
my8033_rel_lto.cy10a3_gcp_c2s3020.62074.9694.1490.2460.0160.375
my8033_rel_lto.cy10a4_gcp_c2s3018.17571.9809.7560.0880.149
my8033_rel_lto.cy10a5_gcp_c2s30nonzero85.60414.3960.142
my8033_rel_lto.cy10a6_gcp_c2s3019.84075.1744.7120.2730.250
my8033_rel_lto.cy10a7_gcp_c2s3021.23074.8543.6840.232nonzero0.261
my8033_rel_lto.cy10a8_gcp_c2s3021.63874.6553.4870.221nonzero0.266
my8033_rel_lto.cy10a9_gcp_c2s3021.72974.5353.5010.235nonzero0.256
my8033_rel_lto.cy10a10_gcp_c2s3021.27874.6213.7720.3290.203
my8033_rel_lto.cy10a11_gcp_c2s3018.58074.6496.3870.1530.1360.0951.719

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
18022	0	16749	261.7	33558.3	771.5	0.929	14.870	1.862	43.834	181557	42.0	10.074	350	651.3	816.1	86.9	0.282	1398	300	3200m.my8033_rel_lto.cy10a_gcp_c2s30
16508	0	14974	234.0	30618.4	710.6	0.907	14.512	1.855	44.080	192971	39.3	11.689	357	651.5	816.7	86.9	0.314	1099	300	3200m.my8033_rel_lto.cy10a1_gcp_c2s30
17403	0	16638	260.0	35142.2	791.2	0.956	15.297	2.019	46.558	182094	41.3	10.464	356	651.4	813.6	86.9	0.367	1249	300	3200m.my8033_rel_lto.cy10a2_gcp_c2s30
17486	0	16622	259.7	35129.1	792.3	0.951	15.209	2.009	46.399	182927	41.4	10.461	355	651.5	813.8	86.9	0.369	1349	300	3200m.my8033_rel_lto.cy10a3_gcp_c2s30
10008	0	8677	241.2	18330.1	428.9	0.867	24.675	1.832	43.882	272121	28.8	27.192	432	651.5	819.8	86.9	0.578	400	150	3200m.my8033_rel_lto.cy10a4_gcp_c2s30
5995	0	26091	407.7	48986.9	936.0	4.352	69.632	8.171	159.868	182593	17.9	30.456	448	650.7	784.4	86.9	0.283	799	350	3200m.my8033_rel_lto.cy10a5_gcp_c2s30
17460	0	16323	255.0	33827.1	776.7	0.935	14.958	1.937	45.551	181597	42.6	10.401	366	651.3	816.5	86.9	0.287	1498	300	3200m.my8033_rel_lto.cy10a6_gcp_c2s30
18442	0	16975	265.2	32925.4	765.9	0.920	14.728	1.785	42.528	182140	42.1	9.877	342	651.3	816.3	86.9	0.306	1398	300	3200m.my8033_rel_lto.cy10a7_gcp_c2s30
18850	0	17233	269.3	32610.2	761.8	0.914	14.627	1.730	41.384	182990	42.0	9.708	334	651.3	816.7	86.9	0.327	1399	300	3200m.my8033_rel_lto.cy10a8_gcp_c2s30
18792	0	17253	269.6	32349.3	755.4	0.918	14.689	1.721	41.159	182313	42.0	9.701	335	651.3	816.7	86.9	0.303	1398	300	3200m.my8033_rel_lto.cy10a9_gcp_c2s30
13282	0	23399	365.6	41511.1	976.1	1.762	28.187	3.125	75.250	219740	43.8	16.544	495	646.1	802.1	86.9	0.369	1349	350	3200m.my8033_rel_lto.cy10a10_gcp_c2s30
13498	0	12583	196.6	28760.8	693.4	0.932	14.916	2.131	52.602	150265	33.7	11.133	375	651.4	705.6	86.9	2.167	849	0	3200m.my8033_rel_lto.cy10a11_gcp_c2s30

q100.1

q100.1: 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
my8033_rel_lto.cy10a_gcp_c2s3037.8864.51550.4537.0710.0750.0010.145
my8033_rel_lto.cy10a1_gcp_c2s3037.5975.13751.1426.0470.0710.006nonzero0.379
my8033_rel_lto.cy10a2_gcp_c2s3037.4594.96550.7166.7580.1010.0010.176
my8033_rel_lto.cy10a3_gcp_c2s3036.9985.25550.6127.0280.1060.0020.172
my8033_rel_lto.cy10a4_gcp_c2s3034.0407.71528.86325.1474.1120.1240.230
my8033_rel_lto.cy10a5_gcp_c2s3037.2375.49952.5484.7150.0010.058
my8033_rel_lto.cy10a6_gcp_c2s3037.4934.78747.56310.0630.0930.0010.193
my8033_rel_lto.cy10a7_gcp_c2s3037.4184.91350.8136.7820.073nonzero0.135
my8033_rel_lto.cy10a8_gcp_c2s3037.5034.80351.0676.5590.0670.0010.144
my8033_rel_lto.cy10a9_gcp_c2s3037.0925.16451.9045.7760.0630.0010.160
my8033_rel_lto.cy10a10_gcp_c2s3029.05910.55849.41810.9100.054nonzero0.074
my8033_rel_lto.cy10a11_gcp_c2s3037.0225.14148.6179.1030.1160.0010.135

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
my8033_rel_lto.cy10a_gcp_c2s3023.83073.5172.4620.1910.184
my8033_rel_lto.cy10a1_gcp_c2s3021.83076.0141.8960.2600.217
my8033_rel_lto.cy10a2_gcp_c2s3024.23371.8093.5590.3920.0070.314
my8033_rel_lto.cy10a3_gcp_c2s3024.01771.3583.9790.6390.0070.310
my8033_rel_lto.cy10a4_gcp_c2s302.61161.03533.2013.1530.225
my8033_rel_lto.cy10a5_gcp_c2s3099.8540.1460.085
my8033_rel_lto.cy10a6_gcp_c2s3018.53178.2642.9720.2330.161
my8033_rel_lto.cy10a7_gcp_c2s3022.27475.0592.4200.2470.211
my8033_rel_lto.cy10a8_gcp_c2s3020.95876.6042.1220.3160.245
my8033_rel_lto.cy10a9_gcp_c2s3020.83376.7502.1220.2950.215
my8033_rel_lto.cy10a10_gcp_c2s300.21289.50310.1490.1350.120
my8033_rel_lto.cy10a11_gcp_c2s3016.97978.5073.9510.5560.0070.260

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
my8033_rel_lto.cy10a_gcp_c2s3032.31665.3162.1980.1700.185
my8033_rel_lto.cy10a1_gcp_c2s3028.73669.2081.8120.2430.217
my8033_rel_lto.cy10a2_gcp_c2s3032.18464.2153.2400.3540.0070.313
my8033_rel_lto.cy10a3_gcp_c2s3031.18164.4793.7530.5800.0070.306
my8033_rel_lto.cy10a4_gcp_c2s303.55961.01432.5102.9170.240
my8033_rel_lto.cy10a5_gcp_c2s3099.8780.1220.087
my8033_rel_lto.cy10a6_gcp_c2s3026.89270.2992.6110.1980.154
my8033_rel_lto.cy10a7_gcp_c2s3030.17467.2432.3470.2360.212
my8033_rel_lto.cy10a8_gcp_c2s3029.58068.1461.9760.2990.248
my8033_rel_lto.cy10a9_gcp_c2s3029.27168.4552.0100.2640.213
my8033_rel_lto.cy10a10_gcp_c2s3012.45885.4062.0210.1150.117
my8033_rel_lto.cy10a11_gcp_c2s3024.85871.1353.4900.5140.0030.259

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
791	4531	33074	516.8	26522.5	585.9	7.299	116.788	33.543	758.829	172319	25.9	38.029	857	651.3	816.1	86.9	0.145	592	208	3200m.my8033_rel_lto.cy10a_gcp_c2s30
790	4710	32562	508.8	24146.8	549.6	6.913	110.612	30.569	712.461	186410	25.7	39.577	818	651.5	816.7	86.9	0.379	623	224	3200m.my8033_rel_lto.cy10a1_gcp_c2s30
791	4519	33246	519.5	26668.1	587.6	7.357	117.712	33.727	760.921	174092	26.6	38.524	883	651.4	813.6	86.9	0.176	607	192	3200m.my8033_rel_lto.cy10a2_gcp_c2s30
790	4461	33374	521.5	26731.1	599.4	7.481	119.699	33.824	776.696	175773	27.0	39.402	908	651.5	813.9	86.9	0.172	591	192	3200m.my8033_rel_lto.cy10a3_gcp_c2s30
780	2040	12949	838.2	13196.8	304.8	6.348	420.825	16.910	399.954	223375	22.5	109.514	1655	651.5	819.8	86.9	0.230	272	48	3200m.my8033_rel_lto.cy10a4_gcp_c2s30
789	4784	37491	585.8	26903.4	580.9	7.837	125.387	34.081	753.595	175237	21.5	36.630	674	650.7	784.5	86.9	0.058	607	256	3200m.my8033_rel_lto.cy10a5_gcp_c2s30
790	4159	30362	474.4	28865.2	622.6	7.301	116.809	36.524	806.720	170834	25.1	41.078	905	651.3	816.5	86.9	0.193	544	208	3200m.my8033_rel_lto.cy10a6_gcp_c2s30
791	4549	33164	518.2	26187.4	585.0	7.291	116.656	33.119	757.651	172665	26.2	37.959	864	651.3	816.3	86.9	0.135	607	240	3200m.my8033_rel_lto.cy10a7_gcp_c2s30
791	4577	33418	522.2	26252.9	587.7	7.302	116.825	33.181	760.652	173475	26.4	37.903	865	651.3	816.7	86.9	0.144	607	256	3200m.my8033_rel_lto.cy10a8_gcp_c2s30
792	4657	34199	534.4	25831.1	594.6	7.343	117.488	32.615	768.744	176899	26.9	37.983	866	651.3	816.7	86.9	0.160	608	256	3200m.my8033_rel_lto.cy10a9_gcp_c2s30
792	3876	39416	615.9	38585.7	856.0	10.170	162.724	48.689	1106.014	218242	32.5	56.312	1258	646.1	802.1	86.9	0.074	511	256	3200m.my8033_rel_lto.cy10a10_gcp_c2s30
792	4263	31460	491.6	28513.7	620.6	7.379	118.067	36.020	802.813	172836	26.2	40.540	922	651.4	705.7	86.9	0.135	575	208	3200m.my8033_rel_lto.cy10a11_gcp_c2s30

q500.1

q500.1: 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
my8033_rel_lto.cy10a_gcp_c2s3038.0245.00153.7793.1940.0020.063
my8033_rel_lto.cy10a1_gcp_c2s3037.6345.79554.4422.0870.0400.001nonzerononzero1.714
my8033_rel_lto.cy10a2_gcp_c2s3037.7665.44253.3913.3980.0040.058
my8033_rel_lto.cy10a3_gcp_c2s3037.3695.70353.5813.3430.0040.059
my8033_rel_lto.cy10a4_gcp_c2s3035.5708.30133.81720.3231.9740.0150.196
my8033_rel_lto.cy10a5_gcp_c2s3034.9985.55744.85914.5780.008nonzero0.087
my8033_rel_lto.cy10a6_gcp_c2s3037.8165.15351.1025.9270.0020.061
my8033_rel_lto.cy10a7_gcp_c2s3037.2625.65054.0833.0030.0020.057
my8033_rel_lto.cy10a8_gcp_c2s3037.5205.36854.2702.8410.0020.054
my8033_rel_lto.cy10a9_gcp_c2s3036.9975.86454.7552.3820.0020.052
my8033_rel_lto.cy10a10_gcp_c2s3028.19711.45251.4878.8380.026nonzero0.076
my8033_rel_lto.cy10a11_gcp_c2s3037.5205.43552.9514.0910.003nonzero0.064

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
my8033_rel_lto.cy10a_gcp_c2s3049.16950.5170.3140.052
my8033_rel_lto.cy10a1_gcp_c2s3051.23248.1390.6080.0200.0010.299
my8033_rel_lto.cy10a2_gcp_c2s3052.02147.5600.4190.048
my8033_rel_lto.cy10a3_gcp_c2s3052.82846.7280.4440.059
my8033_rel_lto.cy10a4_gcp_c2s3014.75674.88610.1380.2200.191
my8033_rel_lto.cy10a5_gcp_c2s3099.6970.3030.090
my8033_rel_lto.cy10a6_gcp_c2s3046.35853.2870.3550.056
my8033_rel_lto.cy10a7_gcp_c2s3045.35354.2990.3490.063
my8033_rel_lto.cy10a8_gcp_c2s3047.56052.1610.2790.045
my8033_rel_lto.cy10a9_gcp_c2s3047.29452.3670.3400.057
my8033_rel_lto.cy10a10_gcp_c2s300.05577.15522.7900.0010.066
my8033_rel_lto.cy10a11_gcp_c2s3044.61954.9810.4010.047

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
my8033_rel_lto.cy10a_gcp_c2s3065.38534.3530.2610.046
my8033_rel_lto.cy10a1_gcp_c2s3061.35738.0760.5460.0210.209
my8033_rel_lto.cy10a2_gcp_c2s3065.77233.8650.3630.049
my8033_rel_lto.cy10a3_gcp_c2s3065.66633.9490.3850.049
my8033_rel_lto.cy10a4_gcp_c2s3019.84471.0228.8920.2420.194
my8033_rel_lto.cy10a5_gcp_c2s3099.7830.2170.088
my8033_rel_lto.cy10a6_gcp_c2s3062.70836.9740.3190.042
my8033_rel_lto.cy10a7_gcp_c2s3061.62238.0910.2870.061
my8033_rel_lto.cy10a8_gcp_c2s3064.65235.1130.2350.041
my8033_rel_lto.cy10a9_gcp_c2s3063.57236.1670.2610.048
my8033_rel_lto.cy10a10_gcp_c2s3046.25353.3720.3740.058
my8033_rel_lto.cy10a11_gcp_c2s3061.26938.4010.3290.045

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
3971	5084	35749	558.6	25944.5	578.0	7.032	112.509	6.533	149.035	177339	27.3	34.882	805	651.3	816.2	86.9	0.063	623	543	3200m.my8033_rel_lto.cy10a_gcp_c2s30
3960	5326	35267	551.1	22814.3	534.7	6.621	105.940	5.761	138.260	192268	27.7	36.097	780	651.5	816.9	86.9	1.714	671	575	3200m.my8033_rel_lto.cy10a1_gcp_c2s30
3971	5057	35706	557.9	26426.4	585.3	7.060	112.963	6.654	150.910	178254	27.5	35.246	816	651.4	813.7	86.9	0.058	639	559	3200m.my8033_rel_lto.cy10a2_gcp_c2s30
3971	5038	35852	560.2	26029.2	592.5	7.116	113.853	6.554	152.785	179562	27.9	35.639	831	651.5	814.1	86.9	0.059	623	543	3200m.my8033_rel_lto.cy10a3_gcp_c2s30
3943	2750	15579	955.1	12566.7	287.7	5.666	355.685	3.187	74.723	231199	24.3	84.085	1326	651.7	820.4	86.9	0.196	336	208	3200m.my8033_rel_lto.cy10a4_gcp_c2s30
3969	3700	39048	610.1	38095.9	737.3	10.555	168.873	9.598	190.211	193064	23.0	52.185	933	650.7	784.8	86.9	0.087	463	416	3200m.my8033_rel_lto.cy10a5_gcp_c2s30
3971	4625	32204	503.2	29495.5	633.5	6.964	111.417	7.427	163.348	175029	25.8	37.847	837	651.3	816.7	86.9	0.061	575	511	3200m.my8033_rel_lto.cy10a6_gcp_c2s30
3971	5066	35937	561.5	25932.2	582.0	7.094	113.499	6.530	150.068	178243	27.7	35.183	820	651.3	816.4	86.9	0.057	624	559	3200m.my8033_rel_lto.cy10a7_gcp_c2s30
3971	5100	36159	565.0	25997.1	584.5	7.090	113.434	6.546	150.720	179031	27.6	35.102	812	651.3	816.9	86.9	0.054	639	559	3200m.my8033_rel_lto.cy10a8_gcp_c2s30
3971	5196	36915	576.8	25432.5	593.2	7.104	113.664	6.404	152.966	182828	28.4	35.184	820	651.3	816.8	86.9	0.052	655	559	3200m.my8033_rel_lto.cy10a9_gcp_c2s30
3974	4014	40866	638.5	40680.8	887.7	10.181	162.901	10.238	228.756	227185	34.1	56.601	1274	646.1	801.4	86.9	0.076	496	432	3200m.my8033_rel_lto.cy10a10_gcp_c2s30
3971	4903	34432	538.0	28202.7	616.7	7.023	112.372	7.102	159.024	178037	27.3	36.315	835	651.4	705.8	86.9	0.064	607	527	3200m.my8033_rel_lto.cy10a11_gcp_c2s30

q1000.1

q1000.1: 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
my8033_rel_lto.cy10a_gcp_c2s3036.5815.74553.2244.4470.0020.061
my8033_rel_lto.cy10a1_gcp_c2s3036.5616.20954.0443.1460.0390.001nonzerononzero1.888
my8033_rel_lto.cy10a2_gcp_c2s3036.9175.69752.8464.5380.0020.063
my8033_rel_lto.cy10a3_gcp_c2s3036.3596.11452.8864.6390.0020.059
my8033_rel_lto.cy10a4_gcp_c2s3032.31010.51831.92022.5552.6840.0130.212
my8033_rel_lto.cy10a5_gcp_c2s3030.3446.66427.43935.4960.0490.0080.110
my8033_rel_lto.cy10a6_gcp_c2s3036.9025.37148.7768.9480.003nonzero0.075
my8033_rel_lto.cy10a7_gcp_c2s3036.2066.09553.4964.2010.003nonzero0.072
my8033_rel_lto.cy10a8_gcp_c2s3036.6365.70353.6963.9620.003nonzero0.065
my8033_rel_lto.cy10a9_gcp_c2s3035.6306.65154.1203.5960.0030.061
my8033_rel_lto.cy10a10_gcp_c2s3026.16912.76448.13512.8510.081nonzero0.077
my8033_rel_lto.cy10a11_gcp_c2s3036.1526.14451.1216.5790.004nonzero0.067

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
my8033_rel_lto.cy10a_gcp_c2s3045.61554.1610.2240.055
my8033_rel_lto.cy10a1_gcp_c2s3053.44346.1080.4390.010nonzero0.465
my8033_rel_lto.cy10a2_gcp_c2s3053.23046.6480.1230.042
my8033_rel_lto.cy10a3_gcp_c2s3055.42544.4710.1030.044
my8033_rel_lto.cy10a4_gcp_c2s3012.24975.07512.4720.2030.203
my8033_rel_lto.cy10a5_gcp_c2s3080.45119.5490.118
my8033_rel_lto.cy10a6_gcp_c2s3044.59055.1870.2230.042
my8033_rel_lto.cy10a7_gcp_c2s3047.52452.2730.2030.050
my8033_rel_lto.cy10a8_gcp_c2s3048.55251.2710.1770.051
my8033_rel_lto.cy10a9_gcp_c2s3044.52855.2330.2380.051
my8033_rel_lto.cy10a10_gcp_c2s300.16080.21519.6210.0050.123
my8033_rel_lto.cy10a11_gcp_c2s3041.57258.1350.2930.057

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
my8033_rel_lto.cy10a_gcp_c2s3062.16737.6180.2150.045
my8033_rel_lto.cy10a1_gcp_c2s3064.63034.9700.3910.009nonzero0.410
my8033_rel_lto.cy10a2_gcp_c2s3067.29132.5860.1240.040
my8033_rel_lto.cy10a3_gcp_c2s3069.11730.7680.1150.034
my8033_rel_lto.cy10a4_gcp_c2s3016.12572.21111.4590.2050.169
my8033_rel_lto.cy10a5_gcp_c2s3082.11717.8830.120
my8033_rel_lto.cy10a6_gcp_c2s3060.01539.7450.2400.035
my8033_rel_lto.cy10a7_gcp_c2s3064.67435.1390.1870.052
my8033_rel_lto.cy10a8_gcp_c2s3065.96333.8670.1700.054
my8033_rel_lto.cy10a9_gcp_c2s3061.80737.9880.2060.051
my8033_rel_lto.cy10a10_gcp_c2s3040.57358.9580.4660.0020.091
my8033_rel_lto.cy10a11_gcp_c2s3058.20941.5140.2770.045

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
7938	4810	33524	523.8	28302.1	613.2	6.969	111.509	3.565	79.094	179327	30.9	37.280	964	651.3	817.1	86.9	0.061	592	527	3200m.my8033_rel_lto.cy10a_gcp_c2s30
7916	5039	32897	514.0	25464.2	573.5	6.528	104.449	3.217	74.187	194001	31.1	38.498	926	651.5	817.8	86.9	1.888	624	543	3200m.my8033_rel_lto.cy10a1_gcp_c2s30
7938	4836	33370	521.4	28517.5	617.1	6.900	110.403	3.592	79.602	179889	30.7	37.197	952	651.4	814.6	86.9	0.063	607	527	3200m.my8033_rel_lto.cy10a2_gcp_c2s30
7938	4787	33526	523.8	28436.9	627.2	7.003	112.054	3.582	80.908	181157	30.9	37.843	968	651.5	815.0	86.9	0.059	592	527	3200m.my8033_rel_lto.cy10a3_gcp_c2s30
7860	2478	13881	871.2	13242.4	303.2	5.602	360.043	1.685	39.498	240997	28.2	97.263	1707	652.5	822.3	86.9	0.212	304	176	3200m.my8033_rel_lto.cy10a4_gcp_c2s30
7028	2519	39661	619.7	53140.5	967.0	15.746	251.937	7.561	140.899	217506	24.7	86.353	1471	651.6	786.7	86.9	0.110	320	272	3200m.my8033_rel_lto.cy10a5_gcp_c2s30
7938	4221	28678	448.1	32798.2	682.8	6.795	108.713	4.132	88.081	176558	28.6	41.831	1016	651.3	816.6	86.9	0.075	527	448	3200m.my8033_rel_lto.cy10a6_gcp_c2s30
7938	4817	33709	526.7	28248.1	616.0	6.998	111.974	3.558	79.464	180061	31.2	37.383	972	651.3	817.3	86.9	0.072	607	528	3200m.my8033_rel_lto.cy10a7_gcp_c2s30
7943	4877	33925	530.1	28085.2	615.7	6.957	111.305	3.536	79.374	181111	31.1	37.138	957	651.3	816.7	86.9	0.065	607	527	3200m.my8033_rel_lto.cy10a8_gcp_c2s30
7938	4936	34618	540.9	27772.9	626.2	7.013	112.212	3.499	80.771	184327	32.0	37.343	972	651.3	817.7	86.9	0.061	623	527	3200m.my8033_rel_lto.cy10a9_gcp_c2s30
7943	3650	37502	586.0	43650.7	939.7	10.274	164.376	5.496	121.145	229621	37.8	62.905	1553	646.1	802.5	86.9	0.077	463	400	3200m.my8033_rel_lto.cy10a10_gcp_c2s30
7943	4528	31171	487.0	31192.6	661.0	6.885	110.154	3.927	85.218	178503	30.3	39.425	1004	651.4	706.7	86.9	0.067	560	495	3200m.my8033_rel_lto.cy10a11_gcp_c2s30

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
709534	0	0	0.0	3673.1	202.5	0.000	0.000	0.005	0.292	180663	76.9	0.255	16	209.7	338.3	86.9	0.311	91301	69824	3200m.my8033_rel_lto.cy10a_gcp_c2s30
694746	0	0	0.0	3604.1	198.6	0.000	0.000	0.005	0.293	165564	77.0	0.238	17	209.7	338.3	86.9	0.287	88803	69925	3200m.my8033_rel_lto.cy10a1_gcp_c2s30
700219	0	0	0.0	3681.4	201.0	0.000	0.000	0.005	0.294	170799	76.8	0.244	16	209.7	338.3	86.9	0.310	90001	69746	3200m.my8033_rel_lto.cy10a2_gcp_c2s30
699148	0	0	0.0	3680.6	201.1	0.000	0.000	0.005	0.295	162641	76.7	0.233	16	209.7	338.3	86.9	0.312	90003	69524	3200m.my8033_rel_lto.cy10a3_gcp_c2s30
690399	0	0	0.0	1543.5	187.8	0.000	0.000	0.002	0.279	170999	76.9	0.248	17	209.7	338.3	86.9	0.245	88348	70455	3200m.my8033_rel_lto.cy10a4_gcp_c2s30
703916	0	0	0.0	3647.0	200.7	0.000	0.000	0.005	0.292	177965	76.9	0.253	16	209.7	338.3	86.9	0.300	90202	70423	3200m.my8033_rel_lto.cy10a5_gcp_c2s30
701600	0	0	0.0	3635.8	200.7	0.000	0.000	0.005	0.293	170046	76.9	0.242	16	209.7	338.3	86.9	0.299	89702	69125	3200m.my8033_rel_lto.cy10a6_gcp_c2s30
698842	0	0	0.0	3627.7	199.9	0.000	0.000	0.005	0.293	165302	76.7	0.237	16	209.7	338.3	86.7	0.299	89981	69349	3200m.my8033_rel_lto.cy10a7_gcp_c2s30
700066	0	0	0.0	3630.1	200.0	0.000	0.000	0.005	0.293	167180	76.8	0.239	16	209.7	338.3	86.5	0.300	89602	69349	3200m.my8033_rel_lto.cy10a8_gcp_c2s30
696864	0	0	0.0	3617.8	199.5	0.000	0.000	0.005	0.293	161357	76.7	0.232	17	209.7	338.3	86.0	0.302	89402	69024	3200m.my8033_rel_lto.cy10a9_gcp_c2s30
705934	0	0	0.0	3654.1	201.3	0.000	0.000	0.005	0.292	177876	76.9	0.252	16	209.7	338.3	86.9	0.311	90103	68825	3200m.my8033_rel_lto.cy10a10_gcp_c2s30
695199	0	0	0.0	3784.6	205.1	0.000	0.000	0.005	0.302	159430	76.5	0.229	17	209.7	226.3	86.9	0.296	89203	69048	3200m.my8033_rel_lto.cy10a11_gcp_c2s30

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
627225	0	7639	675.9	13252.9	808.9	0.012	1.104	0.021	1.321	58138	57.4	0.093	14	468.9	597.5	86.9	0.005	NA	NA	3200m.my8033_rel_lto.cy10a_gcp_c2s30
564890	0	6858	581.3	11886.1	732.0	0.012	1.054	0.021	1.327	50826	55.9	0.090	15	468.9	597.5	86.9	0.005	NA	NA	3200m.my8033_rel_lto.cy10a1_gcp_c2s30
627348	0	7576	645.0	13069.0	807.7	0.012	1.053	0.021	1.318	48505	59.1	0.077	14	468.9	597.5	86.9	0.006	NA	NA	3200m.my8033_rel_lto.cy10a2_gcp_c2s30
613516	0	7469	644.3	12795.3	787.5	0.012	1.075	0.021	1.314	45594	56.1	0.074	14	468.9	597.5	86.9	0.004	NA	NA	3200m.my8033_rel_lto.cy10a3_gcp_c2s30
562704	0	5284	594.3	11219.9	716.6	0.009	1.081	0.020	1.304	92667	55.0	0.165	15	468.9	597.5	86.9	0.006	NA	NA	3200m.my8033_rel_lto.cy10a4_gcp_c2s30
597814	0	7205	619.3	12546.9	781.9	0.012	1.061	0.021	1.339	46647	56.6	0.078	14	468.9	597.5	86.9	0.004	NA	NA	3200m.my8033_rel_lto.cy10a5_gcp_c2s30
633182	0	7723	689.9	13357.5	818.8	0.012	1.116	0.021	1.324	53308	55.8	0.084	13	468.9	597.5	86.9	0.003	NA	NA	3200m.my8033_rel_lto.cy10a6_gcp_c2s30
605163	0	7382	646.6	12772.3	776.1	0.012	1.094	0.021	1.313	54989	55.4	0.091	14	468.9	597.5	86.9	0.004	NA	NA	3200m.my8033_rel_lto.cy10a7_gcp_c2s30
626243	0	7630	679.8	13306.0	806.0	0.012	1.112	0.021	1.318	56268	55.8	0.090	13	468.9	597.5	86.9	0.005	NA	NA	3200m.my8033_rel_lto.cy10a8_gcp_c2s30
600619	0	7321	640.1	12640.0	777.6	0.012	1.091	0.021	1.326	53463	55.3	0.089	14	468.9	597.5	86.9	0.003	NA	NA	3200m.my8033_rel_lto.cy10a9_gcp_c2s30
611173	0	7439	656.3	12573.3	787.0	0.012	1.100	0.021	1.319	52481	55.3	0.086	14	468.9	597.5	86.9	0.004	NA	NA	3200m.my8033_rel_lto.cy10a10_gcp_c2s30
601296	0	7288	639.5	12514.4	775.0	0.012	1.089	0.021	1.320	49263	55.3	0.082	14	468.9	485.5	86.9	0.006	NA	NA	3200m.my8033_rel_lto.cy10a11_gcp_c2s30

l.i1

l.i1: continue load after secondary indexes created

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
18022	0	16749	261.7	33558.3	771.5	0.929	14.870	1.862	43.834	181557	42.0	10.074	350	651.3	816.1	86.9	0.282	1398	300	3200m.my8033_rel_lto.cy10a_gcp_c2s30
16508	0	14974	234.0	30618.4	710.6	0.907	14.512	1.855	44.080	192971	39.3	11.689	357	651.5	816.7	86.9	0.314	1099	300	3200m.my8033_rel_lto.cy10a1_gcp_c2s30
17403	0	16638	260.0	35142.2	791.2	0.956	15.297	2.019	46.558	182094	41.3	10.464	356	651.4	813.6	86.9	0.367	1249	300	3200m.my8033_rel_lto.cy10a2_gcp_c2s30
17486	0	16622	259.7	35129.1	792.3	0.951	15.209	2.009	46.399	182927	41.4	10.461	355	651.5	813.8	86.9	0.369	1349	300	3200m.my8033_rel_lto.cy10a3_gcp_c2s30
10008	0	8677	241.2	18330.1	428.9	0.867	24.675	1.832	43.882	272121	28.8	27.192	432	651.5	819.8	86.9	0.578	400	150	3200m.my8033_rel_lto.cy10a4_gcp_c2s30
5995	0	26091	407.7	48986.9	936.0	4.352	69.632	8.171	159.868	182593	17.9	30.456	448	650.7	784.4	86.9	0.283	799	350	3200m.my8033_rel_lto.cy10a5_gcp_c2s30
17460	0	16323	255.0	33827.1	776.7	0.935	14.958	1.937	45.551	181597	42.6	10.401	366	651.3	816.5	86.9	0.287	1498	300	3200m.my8033_rel_lto.cy10a6_gcp_c2s30
18442	0	16975	265.2	32925.4	765.9	0.920	14.728	1.785	42.528	182140	42.1	9.877	342	651.3	816.3	86.9	0.306	1398	300	3200m.my8033_rel_lto.cy10a7_gcp_c2s30
18850	0	17233	269.3	32610.2	761.8	0.914	14.627	1.730	41.384	182990	42.0	9.708	334	651.3	816.7	86.9	0.327	1399	300	3200m.my8033_rel_lto.cy10a8_gcp_c2s30
18792	0	17253	269.6	32349.3	755.4	0.918	14.689	1.721	41.159	182313	42.0	9.701	335	651.3	816.7	86.9	0.303	1398	300	3200m.my8033_rel_lto.cy10a9_gcp_c2s30
13282	0	23399	365.6	41511.1	976.1	1.762	28.187	3.125	75.250	219740	43.8	16.544	495	646.1	802.1	86.9	0.369	1349	350	3200m.my8033_rel_lto.cy10a10_gcp_c2s30
13498	0	12583	196.6	28760.8	693.4	0.932	14.916	2.131	52.602	150265	33.7	11.133	375	651.4	705.6	86.9	2.167	849	0	3200m.my8033_rel_lto.cy10a11_gcp_c2s30

q100.1

q100.1: 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
791	4531	33074	516.8	26522.5	585.9	7.299	116.788	33.543	758.829	172319	25.9	38.029	857	651.3	816.1	86.9	0.145	592	208	3200m.my8033_rel_lto.cy10a_gcp_c2s30
790	4710	32562	508.8	24146.8	549.6	6.913	110.612	30.569	712.461	186410	25.7	39.577	818	651.5	816.7	86.9	0.379	623	224	3200m.my8033_rel_lto.cy10a1_gcp_c2s30
791	4519	33246	519.5	26668.1	587.6	7.357	117.712	33.727	760.921	174092	26.6	38.524	883	651.4	813.6	86.9	0.176	607	192	3200m.my8033_rel_lto.cy10a2_gcp_c2s30
790	4461	33374	521.5	26731.1	599.4	7.481	119.699	33.824	776.696	175773	27.0	39.402	908	651.5	813.9	86.9	0.172	591	192	3200m.my8033_rel_lto.cy10a3_gcp_c2s30
780	2040	12949	838.2	13196.8	304.8	6.348	420.825	16.910	399.954	223375	22.5	109.514	1655	651.5	819.8	86.9	0.230	272	48	3200m.my8033_rel_lto.cy10a4_gcp_c2s30
789	4784	37491	585.8	26903.4	580.9	7.837	125.387	34.081	753.595	175237	21.5	36.630	674	650.7	784.5	86.9	0.058	607	256	3200m.my8033_rel_lto.cy10a5_gcp_c2s30
790	4159	30362	474.4	28865.2	622.6	7.301	116.809	36.524	806.720	170834	25.1	41.078	905	651.3	816.5	86.9	0.193	544	208	3200m.my8033_rel_lto.cy10a6_gcp_c2s30
791	4549	33164	518.2	26187.4	585.0	7.291	116.656	33.119	757.651	172665	26.2	37.959	864	651.3	816.3	86.9	0.135	607	240	3200m.my8033_rel_lto.cy10a7_gcp_c2s30
791	4577	33418	522.2	26252.9	587.7	7.302	116.825	33.181	760.652	173475	26.4	37.903	865	651.3	816.7	86.9	0.144	607	256	3200m.my8033_rel_lto.cy10a8_gcp_c2s30
792	4657	34199	534.4	25831.1	594.6	7.343	117.488	32.615	768.744	176899	26.9	37.983	866	651.3	816.7	86.9	0.160	608	256	3200m.my8033_rel_lto.cy10a9_gcp_c2s30
792	3876	39416	615.9	38585.7	856.0	10.170	162.724	48.689	1106.014	218242	32.5	56.312	1258	646.1	802.1	86.9	0.074	511	256	3200m.my8033_rel_lto.cy10a10_gcp_c2s30
792	4263	31460	491.6	28513.7	620.6	7.379	118.067	36.020	802.813	172836	26.2	40.540	922	651.4	705.7	86.9	0.135	575	208	3200m.my8033_rel_lto.cy10a11_gcp_c2s30

q500.1

q500.1: 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
3971	5084	35749	558.6	25944.5	578.0	7.032	112.509	6.533	149.035	177339	27.3	34.882	805	651.3	816.2	86.9	0.063	623	543	3200m.my8033_rel_lto.cy10a_gcp_c2s30
3960	5326	35267	551.1	22814.3	534.7	6.621	105.940	5.761	138.260	192268	27.7	36.097	780	651.5	816.9	86.9	1.714	671	575	3200m.my8033_rel_lto.cy10a1_gcp_c2s30
3971	5057	35706	557.9	26426.4	585.3	7.060	112.963	6.654	150.910	178254	27.5	35.246	816	651.4	813.7	86.9	0.058	639	559	3200m.my8033_rel_lto.cy10a2_gcp_c2s30
3971	5038	35852	560.2	26029.2	592.5	7.116	113.853	6.554	152.785	179562	27.9	35.639	831	651.5	814.1	86.9	0.059	623	543	3200m.my8033_rel_lto.cy10a3_gcp_c2s30
3943	2750	15579	955.1	12566.7	287.7	5.666	355.685	3.187	74.723	231199	24.3	84.085	1326	651.7	820.4	86.9	0.196	336	208	3200m.my8033_rel_lto.cy10a4_gcp_c2s30
3969	3700	39048	610.1	38095.9	737.3	10.555	168.873	9.598	190.211	193064	23.0	52.185	933	650.7	784.8	86.9	0.087	463	416	3200m.my8033_rel_lto.cy10a5_gcp_c2s30
3971	4625	32204	503.2	29495.5	633.5	6.964	111.417	7.427	163.348	175029	25.8	37.847	837	651.3	816.7	86.9	0.061	575	511	3200m.my8033_rel_lto.cy10a6_gcp_c2s30
3971	5066	35937	561.5	25932.2	582.0	7.094	113.499	6.530	150.068	178243	27.7	35.183	820	651.3	816.4	86.9	0.057	624	559	3200m.my8033_rel_lto.cy10a7_gcp_c2s30
3971	5100	36159	565.0	25997.1	584.5	7.090	113.434	6.546	150.720	179031	27.6	35.102	812	651.3	816.9	86.9	0.054	639	559	3200m.my8033_rel_lto.cy10a8_gcp_c2s30
3971	5196	36915	576.8	25432.5	593.2	7.104	113.664	6.404	152.966	182828	28.4	35.184	820	651.3	816.8	86.9	0.052	655	559	3200m.my8033_rel_lto.cy10a9_gcp_c2s30
3974	4014	40866	638.5	40680.8	887.7	10.181	162.901	10.238	228.756	227185	34.1	56.601	1274	646.1	801.4	86.9	0.076	496	432	3200m.my8033_rel_lto.cy10a10_gcp_c2s30
3971	4903	34432	538.0	28202.7	616.7	7.023	112.372	7.102	159.024	178037	27.3	36.315	835	651.4	705.8	86.9	0.064	607	527	3200m.my8033_rel_lto.cy10a11_gcp_c2s30

q1000.1

q1000.1: 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
7938	4810	33524	523.8	28302.1	613.2	6.969	111.509	3.565	79.094	179327	30.9	37.280	964	651.3	817.1	86.9	0.061	592	527	3200m.my8033_rel_lto.cy10a_gcp_c2s30
7916	5039	32897	514.0	25464.2	573.5	6.528	104.449	3.217	74.187	194001	31.1	38.498	926	651.5	817.8	86.9	1.888	624	543	3200m.my8033_rel_lto.cy10a1_gcp_c2s30
7938	4836	33370	521.4	28517.5	617.1	6.900	110.403	3.592	79.602	179889	30.7	37.197	952	651.4	814.6	86.9	0.063	607	527	3200m.my8033_rel_lto.cy10a2_gcp_c2s30
7938	4787	33526	523.8	28436.9	627.2	7.003	112.054	3.582	80.908	181157	30.9	37.843	968	651.5	815.0	86.9	0.059	592	527	3200m.my8033_rel_lto.cy10a3_gcp_c2s30
7860	2478	13881	871.2	13242.4	303.2	5.602	360.043	1.685	39.498	240997	28.2	97.263	1707	652.5	822.3	86.9	0.212	304	176	3200m.my8033_rel_lto.cy10a4_gcp_c2s30
7028	2519	39661	619.7	53140.5	967.0	15.746	251.937	7.561	140.899	217506	24.7	86.353	1471	651.6	786.7	86.9	0.110	320	272	3200m.my8033_rel_lto.cy10a5_gcp_c2s30
7938	4221	28678	448.1	32798.2	682.8	6.795	108.713	4.132	88.081	176558	28.6	41.831	1016	651.3	816.6	86.9	0.075	527	448	3200m.my8033_rel_lto.cy10a6_gcp_c2s30
7938	4817	33709	526.7	28248.1	616.0	6.998	111.974	3.558	79.464	180061	31.2	37.383	972	651.3	817.3	86.9	0.072	607	528	3200m.my8033_rel_lto.cy10a7_gcp_c2s30
7943	4877	33925	530.1	28085.2	615.7	6.957	111.305	3.536	79.374	181111	31.1	37.138	957	651.3	816.7	86.9	0.065	607	527	3200m.my8033_rel_lto.cy10a8_gcp_c2s30
7938	4936	34618	540.9	27772.9	626.2	7.013	112.212	3.499	80.771	184327	32.0	37.343	972	651.3	817.7	86.9	0.061	623	527	3200m.my8033_rel_lto.cy10a9_gcp_c2s30
7943	3650	37502	586.0	43650.7	939.7	10.274	164.376	5.496	121.145	229621	37.8	62.905	1553	646.1	802.5	86.9	0.077	463	400	3200m.my8033_rel_lto.cy10a10_gcp_c2s30
7943	4528	31171	487.0	31192.6	661.0	6.885	110.154	3.927	85.218	178503	30.3	39.425	1004	651.4	706.7	86.9	0.067	560	495	3200m.my8033_rel_lto.cy10a11_gcp_c2s30

l.i0

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	10.483	89.424	0.062	0.017	0.014	0.001	0.000	0.000	0.000	0.311	my8033_rel_lto.cy10a_gcp_c2s30
0.000	7.262	92.645	0.059	0.019	0.015	nonzero	0.000	0.000	0.000	0.287	my8033_rel_lto.cy10a1_gcp_c2s30
0.000	5.390	94.512	0.065	0.019	0.014	0.001	0.000	0.000	0.000	0.310	my8033_rel_lto.cy10a2_gcp_c2s30
0.000	5.305	94.599	0.062	0.018	0.014	0.001	0.000	0.000	0.000	0.312	my8033_rel_lto.cy10a3_gcp_c2s30
0.000	6.250	93.501	0.217	0.018	0.015	0.000	0.000	0.000	0.000	0.245	my8033_rel_lto.cy10a4_gcp_c2s30
0.000	7.166	92.739	0.061	0.018	0.014	nonzero	0.000	0.000	0.000	0.300	my8033_rel_lto.cy10a5_gcp_c2s30
0.000	5.720	94.184	0.063	0.018	0.014	0.001	0.000	0.000	0.000	0.299	my8033_rel_lto.cy10a6_gcp_c2s30
0.000	6.008	93.897	0.063	0.018	0.014	0.001	0.000	0.000	0.000	0.299	my8033_rel_lto.cy10a7_gcp_c2s30
0.000	5.680	94.222	0.065	0.018	0.014	0.001	0.000	0.000	0.000	0.300	my8033_rel_lto.cy10a8_gcp_c2s30
0.000	4.559	95.348	0.060	0.018	0.014	0.001	0.000	0.000	0.000	0.302	my8033_rel_lto.cy10a9_gcp_c2s30
0.000	9.509	90.377	0.082	0.017	0.014	0.001	0.000	0.000	0.000	0.311	my8033_rel_lto.cy10a10_gcp_c2s30
0.000	4.639	95.240	0.071	0.035	0.014	0.001	0.000	0.000	0.000	0.296	my8033_rel_lto.cy10a11_gcp_c2s30

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	0.000	0.771	68.508	22.167	8.553	0.002	0.000	0.000	0.000	0.282	my8033_rel_lto.cy10a_gcp_c2s30
0.000	0.000	1.170	65.501	23.621	9.702	0.007	0.000	0.000	0.000	0.314	my8033_rel_lto.cy10a1_gcp_c2s30
0.000	0.000	1.034	67.410	22.600	8.940	0.016	0.000	0.000	0.000	0.367	my8033_rel_lto.cy10a2_gcp_c2s30
0.000	0.000	0.667	67.575	22.869	8.869	0.020	0.000	0.000	0.000	0.369	my8033_rel_lto.cy10a3_gcp_c2s30
0.000	0.000	0.627	55.521	28.220	13.098	2.534	0.000	0.000	0.000	0.578	my8033_rel_lto.cy10a4_gcp_c2s30
0.000	0.000	0.000	0.000	57.714	42.285	nonzero	0.000	0.000	0.000	0.283	my8033_rel_lto.cy10a5_gcp_c2s30
0.000	0.000	0.386	66.813	24.123	8.677	0.001	0.000	0.000	0.000	0.287	my8033_rel_lto.cy10a6_gcp_c2s30
0.000	0.000	1.129	69.025	21.495	8.348	0.003	0.000	0.000	0.000	0.306	my8033_rel_lto.cy10a7_gcp_c2s30
0.000	0.000	1.259	69.914	20.596	8.228	0.003	0.000	0.000	0.000	0.327	my8033_rel_lto.cy10a8_gcp_c2s30
0.000	0.000	1.258	69.841	20.591	8.305	0.005	0.000	0.000	0.000	0.303	my8033_rel_lto.cy10a9_gcp_c2s30
0.000	0.000	0.021	39.392	49.505	11.045	0.036	0.000	0.000	0.000	0.369	my8033_rel_lto.cy10a10_gcp_c2s30
0.000	0.000	0.150	66.724	25.293	6.919	0.483	0.431	0.000	0.000	2.167	my8033_rel_lto.cy10a11_gcp_c2s30

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	21.338	74.691	3.727	0.244	0.000	0.000	0.000	0.000	0.256	my8033_rel_lto.cy10a_gcp_c2s30
0.000	0.000	22.691	72.675	4.324	0.303	0.007	0.000	0.000	0.000	0.300	my8033_rel_lto.cy10a1_gcp_c2s30
0.000	0.000	21.598	74.176	3.975	0.237	0.014	0.000	0.000	0.000	0.379	my8033_rel_lto.cy10a2_gcp_c2s30
0.000	0.000	20.620	74.969	4.149	0.246	0.016	0.000	0.000	0.000	0.375	my8033_rel_lto.cy10a3_gcp_c2s30
0.000	0.000	18.175	71.980	9.756	0.088	0.000	0.000	0.000	0.000	0.149	my8033_rel_lto.cy10a4_gcp_c2s30
0.000	0.000	0.000	nonzero	85.604	14.396	0.000	0.000	0.000	0.000	0.142	my8033_rel_lto.cy10a5_gcp_c2s30
0.000	0.000	19.840	75.174	4.712	0.273	0.000	0.000	0.000	0.000	0.250	my8033_rel_lto.cy10a6_gcp_c2s30
0.000	0.000	21.230	74.854	3.684	0.232	nonzero	0.000	0.000	0.000	0.261	my8033_rel_lto.cy10a7_gcp_c2s30
0.000	0.000	21.638	74.655	3.487	0.221	nonzero	0.000	0.000	0.000	0.266	my8033_rel_lto.cy10a8_gcp_c2s30
0.000	0.000	21.729	74.535	3.501	0.235	nonzero	0.000	0.000	0.000	0.256	my8033_rel_lto.cy10a9_gcp_c2s30
0.000	0.000	21.278	74.621	3.772	0.329	0.000	0.000	0.000	0.000	0.203	my8033_rel_lto.cy10a10_gcp_c2s30
0.000	0.000	18.580	74.649	6.387	0.153	0.136	0.095	0.000	0.000	1.719	my8033_rel_lto.cy10a11_gcp_c2s30

q100.1

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
37.886	4.515	50.453	7.071	0.075	0.001	0.000	0.000	0.000	0.000	0.145	my8033_rel_lto.cy10a_gcp_c2s30
37.597	5.137	51.142	6.047	0.071	0.006	nonzero	0.000	0.000	0.000	0.379	my8033_rel_lto.cy10a1_gcp_c2s30
37.459	4.965	50.716	6.758	0.101	0.001	0.000	0.000	0.000	0.000	0.176	my8033_rel_lto.cy10a2_gcp_c2s30
36.998	5.255	50.612	7.028	0.106	0.002	0.000	0.000	0.000	0.000	0.172	my8033_rel_lto.cy10a3_gcp_c2s30
34.040	7.715	28.863	25.147	4.112	0.124	0.000	0.000	0.000	0.000	0.230	my8033_rel_lto.cy10a4_gcp_c2s30
37.237	5.499	52.548	4.715	0.001	0.000	0.000	0.000	0.000	0.000	0.058	my8033_rel_lto.cy10a5_gcp_c2s30
37.493	4.787	47.563	10.063	0.093	0.001	0.000	0.000	0.000	0.000	0.193	my8033_rel_lto.cy10a6_gcp_c2s30
37.418	4.913	50.813	6.782	0.073	nonzero	0.000	0.000	0.000	0.000	0.135	my8033_rel_lto.cy10a7_gcp_c2s30
37.503	4.803	51.067	6.559	0.067	0.001	0.000	0.000	0.000	0.000	0.144	my8033_rel_lto.cy10a8_gcp_c2s30
37.092	5.164	51.904	5.776	0.063	0.001	0.000	0.000	0.000	0.000	0.160	my8033_rel_lto.cy10a9_gcp_c2s30
29.059	10.558	49.418	10.910	0.054	nonzero	0.000	0.000	0.000	0.000	0.074	my8033_rel_lto.cy10a10_gcp_c2s30
37.022	5.141	48.617	9.103	0.116	0.001	0.000	0.000	0.000	0.000	0.135	my8033_rel_lto.cy10a11_gcp_c2s30

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	23.830	73.517	2.462	0.191	0.000	0.000	0.000	0.000	0.184	my8033_rel_lto.cy10a_gcp_c2s30
0.000	0.000	21.830	76.014	1.896	0.260	0.000	0.000	0.000	0.000	0.217	my8033_rel_lto.cy10a1_gcp_c2s30
0.000	0.000	24.233	71.809	3.559	0.392	0.007	0.000	0.000	0.000	0.314	my8033_rel_lto.cy10a2_gcp_c2s30
0.000	0.000	24.017	71.358	3.979	0.639	0.007	0.000	0.000	0.000	0.310	my8033_rel_lto.cy10a3_gcp_c2s30
0.000	0.000	2.611	61.035	33.201	3.153	0.000	0.000	0.000	0.000	0.225	my8033_rel_lto.cy10a4_gcp_c2s30
0.000	0.000	0.000	0.000	99.854	0.146	0.000	0.000	0.000	0.000	0.085	my8033_rel_lto.cy10a5_gcp_c2s30
0.000	0.000	18.531	78.264	2.972	0.233	0.000	0.000	0.000	0.000	0.161	my8033_rel_lto.cy10a6_gcp_c2s30
0.000	0.000	22.274	75.059	2.420	0.247	0.000	0.000	0.000	0.000	0.211	my8033_rel_lto.cy10a7_gcp_c2s30
0.000	0.000	20.958	76.604	2.122	0.316	0.000	0.000	0.000	0.000	0.245	my8033_rel_lto.cy10a8_gcp_c2s30
0.000	0.000	20.833	76.750	2.122	0.295	0.000	0.000	0.000	0.000	0.215	my8033_rel_lto.cy10a9_gcp_c2s30
0.000	0.000	0.212	89.503	10.149	0.135	0.000	0.000	0.000	0.000	0.120	my8033_rel_lto.cy10a10_gcp_c2s30
0.000	0.000	16.979	78.507	3.951	0.556	0.007	0.000	0.000	0.000	0.260	my8033_rel_lto.cy10a11_gcp_c2s30

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	32.316	65.316	2.198	0.170	0.000	0.000	0.000	0.000	0.185	my8033_rel_lto.cy10a_gcp_c2s30
0.000	0.000	28.736	69.208	1.812	0.243	0.000	0.000	0.000	0.000	0.217	my8033_rel_lto.cy10a1_gcp_c2s30
0.000	0.000	32.184	64.215	3.240	0.354	0.007	0.000	0.000	0.000	0.313	my8033_rel_lto.cy10a2_gcp_c2s30
0.000	0.000	31.181	64.479	3.753	0.580	0.007	0.000	0.000	0.000	0.306	my8033_rel_lto.cy10a3_gcp_c2s30
0.000	0.000	3.559	61.014	32.510	2.917	0.000	0.000	0.000	0.000	0.240	my8033_rel_lto.cy10a4_gcp_c2s30
0.000	0.000	0.000	0.000	99.878	0.122	0.000	0.000	0.000	0.000	0.087	my8033_rel_lto.cy10a5_gcp_c2s30
0.000	0.000	26.892	70.299	2.611	0.198	0.000	0.000	0.000	0.000	0.154	my8033_rel_lto.cy10a6_gcp_c2s30
0.000	0.000	30.174	67.243	2.347	0.236	0.000	0.000	0.000	0.000	0.212	my8033_rel_lto.cy10a7_gcp_c2s30
0.000	0.000	29.580	68.146	1.976	0.299	0.000	0.000	0.000	0.000	0.248	my8033_rel_lto.cy10a8_gcp_c2s30
0.000	0.000	29.271	68.455	2.010	0.264	0.000	0.000	0.000	0.000	0.213	my8033_rel_lto.cy10a9_gcp_c2s30
0.000	0.000	12.458	85.406	2.021	0.115	0.000	0.000	0.000	0.000	0.117	my8033_rel_lto.cy10a10_gcp_c2s30
0.000	0.000	24.858	71.135	3.490	0.514	0.003	0.000	0.000	0.000	0.259	my8033_rel_lto.cy10a11_gcp_c2s30

q500.1

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
38.024	5.001	53.779	3.194	0.002	0.000	0.000	0.000	0.000	0.000	0.063	my8033_rel_lto.cy10a_gcp_c2s30
37.634	5.795	54.442	2.087	0.040	0.001	nonzero	nonzero	0.000	0.000	1.714	my8033_rel_lto.cy10a1_gcp_c2s30
37.766	5.442	53.391	3.398	0.004	0.000	0.000	0.000	0.000	0.000	0.058	my8033_rel_lto.cy10a2_gcp_c2s30
37.369	5.703	53.581	3.343	0.004	0.000	0.000	0.000	0.000	0.000	0.059	my8033_rel_lto.cy10a3_gcp_c2s30
35.570	8.301	33.817	20.323	1.974	0.015	0.000	0.000	0.000	0.000	0.196	my8033_rel_lto.cy10a4_gcp_c2s30
34.998	5.557	44.859	14.578	0.008	nonzero	0.000	0.000	0.000	0.000	0.087	my8033_rel_lto.cy10a5_gcp_c2s30
37.816	5.153	51.102	5.927	0.002	0.000	0.000	0.000	0.000	0.000	0.061	my8033_rel_lto.cy10a6_gcp_c2s30
37.262	5.650	54.083	3.003	0.002	0.000	0.000	0.000	0.000	0.000	0.057	my8033_rel_lto.cy10a7_gcp_c2s30
37.520	5.368	54.270	2.841	0.002	0.000	0.000	0.000	0.000	0.000	0.054	my8033_rel_lto.cy10a8_gcp_c2s30
36.997	5.864	54.755	2.382	0.002	0.000	0.000	0.000	0.000	0.000	0.052	my8033_rel_lto.cy10a9_gcp_c2s30
28.197	11.452	51.487	8.838	0.026	nonzero	0.000	0.000	0.000	0.000	0.076	my8033_rel_lto.cy10a10_gcp_c2s30
37.520	5.435	52.951	4.091	0.003	nonzero	0.000	0.000	0.000	0.000	0.064	my8033_rel_lto.cy10a11_gcp_c2s30

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	49.169	50.517	0.314	0.000	0.000	0.000	0.000	0.000	0.052	my8033_rel_lto.cy10a_gcp_c2s30
0.000	0.000	51.232	48.139	0.608	0.020	0.001	0.000	0.000	0.000	0.299	my8033_rel_lto.cy10a1_gcp_c2s30
0.000	0.000	52.021	47.560	0.419	0.000	0.000	0.000	0.000	0.000	0.048	my8033_rel_lto.cy10a2_gcp_c2s30
0.000	0.000	52.828	46.728	0.444	0.000	0.000	0.000	0.000	0.000	0.059	my8033_rel_lto.cy10a3_gcp_c2s30
0.000	0.000	14.756	74.886	10.138	0.220	0.000	0.000	0.000	0.000	0.191	my8033_rel_lto.cy10a4_gcp_c2s30
0.000	0.000	0.000	0.000	99.697	0.303	0.000	0.000	0.000	0.000	0.090	my8033_rel_lto.cy10a5_gcp_c2s30
0.000	0.000	46.358	53.287	0.355	0.000	0.000	0.000	0.000	0.000	0.056	my8033_rel_lto.cy10a6_gcp_c2s30
0.000	0.000	45.353	54.299	0.349	0.000	0.000	0.000	0.000	0.000	0.063	my8033_rel_lto.cy10a7_gcp_c2s30
0.000	0.000	47.560	52.161	0.279	0.000	0.000	0.000	0.000	0.000	0.045	my8033_rel_lto.cy10a8_gcp_c2s30
0.000	0.000	47.294	52.367	0.340	0.000	0.000	0.000	0.000	0.000	0.057	my8033_rel_lto.cy10a9_gcp_c2s30
0.000	0.000	0.055	77.155	22.790	0.001	0.000	0.000	0.000	0.000	0.066	my8033_rel_lto.cy10a10_gcp_c2s30
0.000	0.000	44.619	54.981	0.401	0.000	0.000	0.000	0.000	0.000	0.047	my8033_rel_lto.cy10a11_gcp_c2s30

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	65.385	34.353	0.261	0.000	0.000	0.000	0.000	0.000	0.046	my8033_rel_lto.cy10a_gcp_c2s30
0.000	0.000	61.357	38.076	0.546	0.021	0.000	0.000	0.000	0.000	0.209	my8033_rel_lto.cy10a1_gcp_c2s30
0.000	0.000	65.772	33.865	0.363	0.000	0.000	0.000	0.000	0.000	0.049	my8033_rel_lto.cy10a2_gcp_c2s30
0.000	0.000	65.666	33.949	0.385	0.000	0.000	0.000	0.000	0.000	0.049	my8033_rel_lto.cy10a3_gcp_c2s30
0.000	0.000	19.844	71.022	8.892	0.242	0.000	0.000	0.000	0.000	0.194	my8033_rel_lto.cy10a4_gcp_c2s30
0.000	0.000	0.000	0.000	99.783	0.217	0.000	0.000	0.000	0.000	0.088	my8033_rel_lto.cy10a5_gcp_c2s30
0.000	0.000	62.708	36.974	0.319	0.000	0.000	0.000	0.000	0.000	0.042	my8033_rel_lto.cy10a6_gcp_c2s30
0.000	0.000	61.622	38.091	0.287	0.000	0.000	0.000	0.000	0.000	0.061	my8033_rel_lto.cy10a7_gcp_c2s30
0.000	0.000	64.652	35.113	0.235	0.000	0.000	0.000	0.000	0.000	0.041	my8033_rel_lto.cy10a8_gcp_c2s30
0.000	0.000	63.572	36.167	0.261	0.000	0.000	0.000	0.000	0.000	0.048	my8033_rel_lto.cy10a9_gcp_c2s30
0.000	0.000	46.253	53.372	0.374	0.000	0.000	0.000	0.000	0.000	0.058	my8033_rel_lto.cy10a10_gcp_c2s30
0.000	0.000	61.269	38.401	0.329	0.000	0.000	0.000	0.000	0.000	0.045	my8033_rel_lto.cy10a11_gcp_c2s30

q1000.1

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
36.581	5.745	53.224	4.447	0.002	0.000	0.000	0.000	0.000	0.000	0.061	my8033_rel_lto.cy10a_gcp_c2s30
36.561	6.209	54.044	3.146	0.039	0.001	nonzero	nonzero	0.000	0.000	1.888	my8033_rel_lto.cy10a1_gcp_c2s30
36.917	5.697	52.846	4.538	0.002	0.000	0.000	0.000	0.000	0.000	0.063	my8033_rel_lto.cy10a2_gcp_c2s30
36.359	6.114	52.886	4.639	0.002	0.000	0.000	0.000	0.000	0.000	0.059	my8033_rel_lto.cy10a3_gcp_c2s30
32.310	10.518	31.920	22.555	2.684	0.013	0.000	0.000	0.000	0.000	0.212	my8033_rel_lto.cy10a4_gcp_c2s30
30.344	6.664	27.439	35.496	0.049	0.008	0.000	0.000	0.000	0.000	0.110	my8033_rel_lto.cy10a5_gcp_c2s30
36.902	5.371	48.776	8.948	0.003	nonzero	0.000	0.000	0.000	0.000	0.075	my8033_rel_lto.cy10a6_gcp_c2s30
36.206	6.095	53.496	4.201	0.003	nonzero	0.000	0.000	0.000	0.000	0.072	my8033_rel_lto.cy10a7_gcp_c2s30
36.636	5.703	53.696	3.962	0.003	nonzero	0.000	0.000	0.000	0.000	0.065	my8033_rel_lto.cy10a8_gcp_c2s30
35.630	6.651	54.120	3.596	0.003	0.000	0.000	0.000	0.000	0.000	0.061	my8033_rel_lto.cy10a9_gcp_c2s30
26.169	12.764	48.135	12.851	0.081	nonzero	0.000	0.000	0.000	0.000	0.077	my8033_rel_lto.cy10a10_gcp_c2s30
36.152	6.144	51.121	6.579	0.004	nonzero	0.000	0.000	0.000	0.000	0.067	my8033_rel_lto.cy10a11_gcp_c2s30

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	45.615	54.161	0.224	0.000	0.000	0.000	0.000	0.000	0.055	my8033_rel_lto.cy10a_gcp_c2s30
0.000	0.000	53.443	46.108	0.439	0.010	nonzero	0.000	0.000	0.000	0.465	my8033_rel_lto.cy10a1_gcp_c2s30
0.000	0.000	53.230	46.648	0.123	0.000	0.000	0.000	0.000	0.000	0.042	my8033_rel_lto.cy10a2_gcp_c2s30
0.000	0.000	55.425	44.471	0.103	0.000	0.000	0.000	0.000	0.000	0.044	my8033_rel_lto.cy10a3_gcp_c2s30
0.000	0.000	12.249	75.075	12.472	0.203	0.000	0.000	0.000	0.000	0.203	my8033_rel_lto.cy10a4_gcp_c2s30
0.000	0.000	0.000	0.000	80.451	19.549	0.000	0.000	0.000	0.000	0.118	my8033_rel_lto.cy10a5_gcp_c2s30
0.000	0.000	44.590	55.187	0.223	0.000	0.000	0.000	0.000	0.000	0.042	my8033_rel_lto.cy10a6_gcp_c2s30
0.000	0.000	47.524	52.273	0.203	0.000	0.000	0.000	0.000	0.000	0.050	my8033_rel_lto.cy10a7_gcp_c2s30
0.000	0.000	48.552	51.271	0.177	0.000	0.000	0.000	0.000	0.000	0.051	my8033_rel_lto.cy10a8_gcp_c2s30
0.000	0.000	44.528	55.233	0.238	0.000	0.000	0.000	0.000	0.000	0.051	my8033_rel_lto.cy10a9_gcp_c2s30
0.000	0.000	0.160	80.215	19.621	0.005	0.000	0.000	0.000	0.000	0.123	my8033_rel_lto.cy10a10_gcp_c2s30
0.000	0.000	41.572	58.135	0.293	0.000	0.000	0.000	0.000	0.000	0.057	my8033_rel_lto.cy10a11_gcp_c2s30

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	62.167	37.618	0.215	0.000	0.000	0.000	0.000	0.000	0.045	my8033_rel_lto.cy10a_gcp_c2s30
0.000	0.000	64.630	34.970	0.391	0.009	nonzero	0.000	0.000	0.000	0.410	my8033_rel_lto.cy10a1_gcp_c2s30
0.000	0.000	67.291	32.586	0.124	0.000	0.000	0.000	0.000	0.000	0.040	my8033_rel_lto.cy10a2_gcp_c2s30
0.000	0.000	69.117	30.768	0.115	0.000	0.000	0.000	0.000	0.000	0.034	my8033_rel_lto.cy10a3_gcp_c2s30
0.000	0.000	16.125	72.211	11.459	0.205	0.000	0.000	0.000	0.000	0.169	my8033_rel_lto.cy10a4_gcp_c2s30
0.000	0.000	0.000	0.000	82.117	17.883	0.000	0.000	0.000	0.000	0.120	my8033_rel_lto.cy10a5_gcp_c2s30
0.000	0.000	60.015	39.745	0.240	0.000	0.000	0.000	0.000	0.000	0.035	my8033_rel_lto.cy10a6_gcp_c2s30
0.000	0.000	64.674	35.139	0.187	0.000	0.000	0.000	0.000	0.000	0.052	my8033_rel_lto.cy10a7_gcp_c2s30
0.000	0.000	65.963	33.867	0.170	0.000	0.000	0.000	0.000	0.000	0.054	my8033_rel_lto.cy10a8_gcp_c2s30
0.000	0.000	61.807	37.988	0.206	0.000	0.000	0.000	0.000	0.000	0.051	my8033_rel_lto.cy10a9_gcp_c2s30
0.000	0.000	40.573	58.958	0.466	0.002	0.000	0.000	0.000	0.000	0.091	my8033_rel_lto.cy10a10_gcp_c2s30
0.000	0.000	58.209	41.514	0.277	0.000	0.000	0.000	0.000	0.000	0.045	my8033_rel_lto.cy10a11_gcp_c2s30