Introduction

This is a report for the insert benchmark with 160M 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 20M rows per table without secondary indexes, creates secondary indexes, then inserts 200M rows with a delete per insert to avoid growing the table. It then does 3 read+write tests for 3600s 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 cached by MyRocks and the only IO is for writes.

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
fbmy5635_rel_202104072149.cy9c_gcp_c2s30 59259279651794096390333800736741
fbmy5635_rel_202203072101.cy9c_gcp_c2s30 57554080050092054382563712235778
fbmy5635_rel_202205192101.cy9c_gcp_c2s30 56537180050090441378483687435704
fbmy5635_rel_202208092101.cy9c_gcp_c2s30 57142879257489736374483656435466
fbmy5635_rel_202210112144.cy9c_gcp_c2s30 55944080452390222372693627635178
fbmy5635_rel_202302162102.cy9c_gcp_c2s30 58608076971290054368803575434258
fbmy5635_rel_202304122154.cy9c_gcp_c2s30 57761776971288638368393579434330
fbmy5635_rel_202305292102.cy9c_gcp_c2s30 57971076238189221364613551334036
fbmy5635_rel_20230529_832.cy9c_gcp_c2s30 57971073778888874362683525733689
fbmy5635_rel_20230529_843.cy9c_gcp_c2s30 57142872443487522355863436732978
fbmy5635_rel_20230529_850.cy9c_gcp_c2s30 57142872443489410353303424632899

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.i1q100.1q500.1q1000.1
fbmy5635_rel_202104072149.cy9c_gcp_c2s30 1.001.001.001.001.001.00
fbmy5635_rel_202203072101.cy9c_gcp_c2s30 0.971.010.980.980.980.97
fbmy5635_rel_202205192101.cy9c_gcp_c2s30 0.951.010.960.970.970.97
fbmy5635_rel_202208092101.cy9c_gcp_c2s30 0.961.000.950.960.960.97
fbmy5635_rel_202210112144.cy9c_gcp_c2s30 0.941.010.960.950.950.96
fbmy5635_rel_202302162102.cy9c_gcp_c2s30 0.990.970.960.940.940.93
fbmy5635_rel_202304122154.cy9c_gcp_c2s30 0.970.970.940.940.940.93
fbmy5635_rel_202305292102.cy9c_gcp_c2s30 0.980.960.950.930.930.93
fbmy5635_rel_20230529_832.cy9c_gcp_c2s30 0.980.930.940.930.930.92
fbmy5635_rel_20230529_843.cy9c_gcp_c2s30 0.960.910.930.910.900.90
fbmy5635_rel_20230529_850.cy9c_gcp_c2s30 0.960.910.950.910.900.90

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
fbmy5635_rel_202104072149.cy9c_gcp_c2s3079739877973
fbmy5635_rel_202203072101.cy9c_gcp_c2s3079739877973
fbmy5635_rel_202205192101.cy9c_gcp_c2s3079739877976
fbmy5635_rel_202208092101.cy9c_gcp_c2s3079739877973
fbmy5635_rel_202210112144.cy9c_gcp_c2s3079739877973
fbmy5635_rel_202302162102.cy9c_gcp_c2s3079739887976
fbmy5635_rel_202304122154.cy9c_gcp_c2s3079739877973
fbmy5635_rel_202305292102.cy9c_gcp_c2s3079739877978
fbmy5635_rel_20230529_832.cy9c_gcp_c2s3079739877973
fbmy5635_rel_20230529_843.cy9c_gcp_c2s3079739877976
fbmy5635_rel_20230529_850.cy9c_gcp_c2s3079739887973
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
fbmy5635_rel_202104072149.cy9c_gcp_c2s3020.79679.1770.0110.0030.0140.0010.273
fbmy5635_rel_202203072101.cy9c_gcp_c2s3019.40880.5640.0130.0010.0130.0010.296
fbmy5635_rel_202205192101.cy9c_gcp_c2s3017.31282.6570.0150.0020.0130.0010.295
fbmy5635_rel_202208092101.cy9c_gcp_c2s3018.91781.0480.0200.0020.0140.239
fbmy5635_rel_202210112144.cy9c_gcp_c2s3017.31182.6600.0130.0020.0130.0010.287
fbmy5635_rel_202302162102.cy9c_gcp_c2s3021.27878.6940.0130.0010.0140.254
fbmy5635_rel_202304122154.cy9c_gcp_c2s3020.13779.8410.0070.0020.0120.0010.280
fbmy5635_rel_202305292102.cy9c_gcp_c2s3020.51079.4660.0090.0020.0140.239
fbmy5635_rel_20230529_832.cy9c_gcp_c2s3021.05678.9200.011nonzero0.0130.0010.263
fbmy5635_rel_20230529_843.cy9c_gcp_c2s3020.93179.0460.0080.0010.0140.249
fbmy5635_rel_20230529_850.cy9c_gcp_c2s3020.38779.5870.012nonzero0.0140.248

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
592592	0	0	0.0	575.5	176.5	0.000	0.000	0.001	0.305	79542	71.0	0.134	18	5.5	7.1	NA	0.273	78642	55860	160m.fbmy5635_rel_202104072149.cy9c_gcp_c2s30
575540	0	0	0.0	559.8	169.7	0.000	0.000	0.001	0.302	82087	71.1	0.143	19	5.5	7.0	NA	0.296	75818	51344	160m.fbmy5635_rel_202203072101.cy9c_gcp_c2s30
565371	0	0	0.0	556.0	166.7	0.000	0.000	0.001	0.302	81789	70.8	0.145	19	5.3	6.8	NA	0.295	75219	51844	160m.fbmy5635_rel_202205192101.cy9c_gcp_c2s30
571428	0	0	0.0	557.3	167.4	0.000	0.000	0.001	0.300	79294	70.5	0.139	19	5.5	7.0	NA	0.239	75445	55660	160m.fbmy5635_rel_202208092101.cy9c_gcp_c2s30
559440	0	0	0.0	556.2	162.3	0.000	0.000	0.001	0.297	78575	70.3	0.140	19	6.1	7.6	NA	0.287	74244	50944	160m.fbmy5635_rel_202210112144.cy9c_gcp_c2s30
586080	0	0	0.0	507.1	144.4	0.000	0.000	0.001	0.252	79793	71.8	0.136	18	5.2	6.7	NA	0.254	77116	57237	160m.fbmy5635_rel_202302162102.cy9c_gcp_c2s30
577617	0	0	0.0	493.4	147.1	0.000	0.000	0.001	0.261	78406	71.1	0.136	18	5.2	6.7	NA	0.280	75319	58041	160m.fbmy5635_rel_202304122154.cy9c_gcp_c2s30
579710	0	0	0.0	480.2	143.2	0.000	0.000	0.001	0.253	77381	71.2	0.133	18	5.3	6.8	NA	0.239	75018	57059	160m.fbmy5635_rel_202305292102.cy9c_gcp_c2s30
579710	0	0	0.0	477.8	149.1	0.000	0.000	0.001	0.263	80550	70.8	0.139	18	5.2	6.7	NA	0.263	77311	57537	160m.fbmy5635_rel_20230529_832.cy9c_gcp_c2s30
571428	0	0	0.0	473.0	137.0	0.000	0.000	0.001	0.246	75341	70.6	0.132	19	5.0	6.5	NA	0.249	75218	54540	160m.fbmy5635_rel_20230529_843.cy9c_gcp_c2s30
571428	0	0	0.0	479.9	145.2	0.000	0.000	0.001	0.260	76333	71.2	0.134	19	5.2	6.7	NA	0.248	73121	55739	160m.fbmy5635_rel_20230529_850.cy9c_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
796517	0	1	0.1	320.6	112.3	0.000	0.000	0.000	0.144	1295	50.8	0.002	10	10.9	12.5	NA	0.002	NA	NA	160m.fbmy5635_rel_202104072149.cy9c_gcp_c2s30
800500	0	1	0.1	335.6	119.1	0.000	0.000	0.000	0.152	1361	50.6	0.002	9	10.8	12.3	NA	0.002	NA	NA	160m.fbmy5635_rel_202203072101.cy9c_gcp_c2s30
800500	0	1	0.1	321.2	114.4	0.000	0.000	0.000	0.146	1173	50.7	0.001	10	10.9	12.4	NA	0.002	NA	NA	160m.fbmy5635_rel_202205192101.cy9c_gcp_c2s30
792574	0	1	0.1	329.2	114.7	0.000	0.000	0.000	0.148	1262	50.6	0.002	10	10.8	12.3	NA	0.002	NA	NA	160m.fbmy5635_rel_202208092101.cy9c_gcp_c2s30
804523	0	1	0.1	327.7	111.4	0.000	0.000	0.000	0.142	1470	50.0	0.002	9	10.9	12.4	NA	0.002	NA	NA	160m.fbmy5635_rel_202210112144.cy9c_gcp_c2s30
769712	0	1	0.1	284.0	103.7	0.000	0.000	0.000	0.138	1315	50.2	0.002	10	10.9	12.4	NA	0.002	NA	NA	160m.fbmy5635_rel_202302162102.cy9c_gcp_c2s30
769712	0	1	0.1	287.5	101.8	0.000	0.000	0.000	0.135	1168	50.3	0.002	10	10.8	12.3	NA	0.002	NA	NA	160m.fbmy5635_rel_202304122154.cy9c_gcp_c2s30
762381	0	1	0.1	280.8	101.2	0.000	0.000	0.000	0.136	1209	48.7	0.002	10	10.8	12.3	NA	0.002	NA	NA	160m.fbmy5635_rel_202305292102.cy9c_gcp_c2s30
737788	0	1	0.1	270.1	96.8	0.000	0.000	0.000	0.134	1035	49.5	0.001	10	10.8	12.3	NA	0.002	NA	NA	160m.fbmy5635_rel_20230529_832.cy9c_gcp_c2s30
724434	0	1	0.1	266.1	95.9	0.000	0.000	0.000	0.136	937	49.0	0.001	10	10.8	12.3	NA	0.003	NA	NA	160m.fbmy5635_rel_20230529_843.cy9c_gcp_c2s30
724434	0	1	0.1	273.5	95.1	0.000	0.000	0.000	0.134	961	48.9	0.001	10	10.8	12.3	NA	0.002	NA	NA	160m.fbmy5635_rel_20230529_850.cy9c_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
fbmy5635_rel_202104072149.cy9c_gcp_c2s300.01342.51257.3890.0720.0130.0020.458
fbmy5635_rel_202203072101.cy9c_gcp_c2s300.00737.58562.3180.0760.0130.0010.399
fbmy5635_rel_202205192101.cy9c_gcp_c2s300.00634.16465.7400.0740.0140.0010.401
fbmy5635_rel_202208092101.cy9c_gcp_c2s300.00633.58766.3180.0750.0130.0010.407
fbmy5635_rel_202210112144.cy9c_gcp_c2s300.00634.50465.4010.0740.0130.0010.407
fbmy5635_rel_202302162102.cy9c_gcp_c2s300.00642.37657.4590.1450.0130.0010.599
fbmy5635_rel_202304122154.cy9c_gcp_c2s300.01339.19160.5930.1870.0150.0010.520
fbmy5635_rel_202305292102.cy9c_gcp_c2s300.00541.45858.3580.1590.0180.0010.673
fbmy5635_rel_20230529_832.cy9c_gcp_c2s300.01341.74158.0950.1380.0120.0010.511
fbmy5635_rel_20230529_843.cy9c_gcp_c2s300.00541.22058.5150.2470.0130.0010.592
fbmy5635_rel_20230529_850.cy9c_gcp_c2s300.00641.20458.6720.1050.0130.0010.415

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.cy9c_gcp_c2s300.01138.85061.0480.0750.0140.0020.459
fbmy5635_rel_202203072101.cy9c_gcp_c2s300.00736.05463.8460.0790.0140.0010.397
fbmy5635_rel_202205192101.cy9c_gcp_c2s300.00634.17065.7320.0760.0140.0010.399
fbmy5635_rel_202208092101.cy9c_gcp_c2s300.00632.54067.3630.0770.0140.0010.409
fbmy5635_rel_202210112144.cy9c_gcp_c2s300.00633.64766.2550.0760.0140.0010.406
fbmy5635_rel_202302162102.cy9c_gcp_c2s300.00637.32562.4420.2040.0220.0010.727
fbmy5635_rel_202304122154.cy9c_gcp_c2s300.01835.28264.4390.2370.0220.0010.542
fbmy5635_rel_202305292102.cy9c_gcp_c2s300.00536.72563.0370.2060.0250.0020.865
fbmy5635_rel_20230529_832.cy9c_gcp_c2s300.00636.62863.1350.2080.0220.0010.944
fbmy5635_rel_20230529_843.cy9c_gcp_c2s300.00536.00263.6610.3090.0210.0020.717
fbmy5635_rel_20230529_850.cy9c_gcp_c2s300.00536.37563.4450.1550.0190.0010.656

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
94096	0	1	0.3	610.7	129.4	0.000	0.004	0.006	1.408	75458	56.7	0.802	90	13.8	13.8	NA	0.458	11837	8890	160m.fbmy5635_rel_202104072149.cy9c_gcp_c2s30
92054	0	1	0.3	596.6	131.2	0.000	0.004	0.006	1.459	79575	56.9	0.864	93	15.3	15.4	NA	0.399	11592	8739	160m.fbmy5635_rel_202203072101.cy9c_gcp_c2s30
90441	0	1	0.3	583.5	128.7	0.000	0.004	0.006	1.457	77340	56.5	0.855	94	13.8	13.9	NA	0.401	11393	8790	160m.fbmy5635_rel_202205192101.cy9c_gcp_c2s30
89736	0	1	0.3	584.9	127.1	0.000	0.004	0.007	1.450	74132	56.2	0.826	94	15.3	15.4	NA	0.407	11338	8544	160m.fbmy5635_rel_202208092101.cy9c_gcp_c2s30
90222	0	1	0.3	582.2	128.4	0.000	0.004	0.006	1.457	74111	56.7	0.821	94	14.0	14.1	NA	0.407	11388	8541	160m.fbmy5635_rel_202210112144.cy9c_gcp_c2s30
90054	0	204	1.5	463.5	113.1	0.002	0.017	0.005	1.286	85221	60.8	0.946	101	22.8	22.9	NA	0.599	11441	6145	160m.fbmy5635_rel_202302162102.cy9c_gcp_c2s30
88638	0	166	1.2	453.9	111.8	0.002	0.014	0.005	1.291	82939	59.2	0.936	100	14.9	15.0	NA	0.520	11293	5244	160m.fbmy5635_rel_202304122154.cy9c_gcp_c2s30
89221	0	166	1.3	456.9	114.9	0.002	0.015	0.005	1.319	83404	61.6	0.935	104	15.4	15.5	NA	0.673	11338	5194	160m.fbmy5635_rel_202305292102.cy9c_gcp_c2s30
88874	0	244	1.6	453.3	115.2	0.003	0.018	0.005	1.327	84376	61.5	0.949	104	20.1	20.3	NA	0.511	11288	6193	160m.fbmy5635_rel_20230529_832.cy9c_gcp_c2s30
87522	0	181	1.8	445.1	114.7	0.002	0.021	0.005	1.342	83935	62.5	0.959	107	20.1	20.3	NA	0.592	11288	4096	160m.fbmy5635_rel_20230529_843.cy9c_gcp_c2s30
89410	0	309	1.5	457.6	111.3	0.003	0.017	0.005	1.275	81699	61.6	0.914	103	18.8	19.0	NA	0.415	11342	7092	160m.fbmy5635_rel_20230529_850.cy9c_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
fbmy5635_rel_202104072149.cy9c_gcp_c2s3098.9121.0860.001nonzerononzero0.028
fbmy5635_rel_202203072101.cy9c_gcp_c2s3098.6881.3100.001nonzerononzero0.037
fbmy5635_rel_202205192101.cy9c_gcp_c2s3098.4071.5920.001nonzerononzero0.047
fbmy5635_rel_202208092101.cy9c_gcp_c2s3098.2981.7010.001nonzerononzero0.020
fbmy5635_rel_202210112144.cy9c_gcp_c2s3098.2151.7840.001nonzerononzero0.024
fbmy5635_rel_202302162102.cy9c_gcp_c2s3096.7473.2520.001nonzerononzero0.028
fbmy5635_rel_202304122154.cy9c_gcp_c2s3097.1142.8850.001nonzerononzero0.024
fbmy5635_rel_202305292102.cy9c_gcp_c2s3096.8973.1020.001nonzerononzero0.037
fbmy5635_rel_20230529_832.cy9c_gcp_c2s3095.7064.2930.001nonzerononzero0.021
fbmy5635_rel_20230529_843.cy9c_gcp_c2s3095.2724.7270.001nonzerononzero0.026
fbmy5635_rel_20230529_850.cy9c_gcp_c2s3094.8765.1230.001nonzerononzero0.020

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.cy9c_gcp_c2s308.64491.3140.0420.010
fbmy5635_rel_202203072101.cy9c_gcp_c2s303.32896.6490.0230.014
fbmy5635_rel_202205192101.cy9c_gcp_c2s301.31698.6530.0300.0020.016
fbmy5635_rel_202208092101.cy9c_gcp_c2s300.66799.2570.0760.014
fbmy5635_rel_202210112144.cy9c_gcp_c2s300.98199.0030.0160.011
fbmy5635_rel_202302162102.cy9c_gcp_c2s3010.50289.4620.0350.0020.019
fbmy5635_rel_202304122154.cy9c_gcp_c2s3015.30984.6610.0300.013
fbmy5635_rel_202305292102.cy9c_gcp_c2s309.23490.7520.0120.0020.018
fbmy5635_rel_20230529_832.cy9c_gcp_c2s3015.88984.0800.0310.015
fbmy5635_rel_20230529_843.cy9c_gcp_c2s3012.59087.3630.0420.0050.042
fbmy5635_rel_20230529_850.cy9c_gcp_c2s309.04290.9380.0210.011

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.cy9c_gcp_c2s305.85494.0780.0680.012
fbmy5635_rel_202203072101.cy9c_gcp_c2s302.26497.6880.0490.014
fbmy5635_rel_202205192101.cy9c_gcp_c2s302.71097.2470.0420.0020.017
fbmy5635_rel_202208092101.cy9c_gcp_c2s301.50798.3870.1060.014
fbmy5635_rel_202210112144.cy9c_gcp_c2s301.05798.9250.0170.010
fbmy5635_rel_202302162102.cy9c_gcp_c2s305.31994.6340.0420.0050.042
fbmy5635_rel_202304122154.cy9c_gcp_c2s306.38493.5360.0780.0020.048
fbmy5635_rel_202305292102.cy9c_gcp_c2s305.01494.9170.0690.015
fbmy5635_rel_20230529_832.cy9c_gcp_c2s304.87295.0450.0820.0020.027
fbmy5635_rel_20230529_843.cy9c_gcp_c2s303.70096.2120.0850.0030.022
fbmy5635_rel_20230529_850.cy9c_gcp_c2s305.26794.6530.0760.0030.020

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
797	39033	0	0.0	14.9	1.5	0.000	0.000	0.019	1.935	151815	53.5	3.889	206	12.0	12.7	NA	0.028	4813	4509	160m.fbmy5635_rel_202104072149.cy9c_gcp_c2s30
797	38256	0	0.0	15.1	1.6	0.000	0.000	0.019	2.059	148980	53.6	3.894	210	12.1	12.8	NA	0.037	4749	4395	160m.fbmy5635_rel_202203072101.cy9c_gcp_c2s30
797	37848	0	0.0	15.8	1.7	0.000	0.000	0.020	2.168	147287	53.5	3.892	212	12.2	12.9	NA	0.047	4731	4347	160m.fbmy5635_rel_202205192101.cy9c_gcp_c2s30
797	37448	0	0.0	17.0	1.7	0.000	0.000	0.021	2.145	146135	53.5	3.902	214	12.2	12.9	NA	0.020	4699	4365	160m.fbmy5635_rel_202208092101.cy9c_gcp_c2s30
797	37269	0	0.0	18.5	1.8	0.000	0.000	0.023	2.271	145435	53.5	3.902	215	12.1	12.9	NA	0.024	4651	4315	160m.fbmy5635_rel_202210112144.cy9c_gcp_c2s30
797	36880	0	0.0	17.6	2.3	0.000	0.001	0.022	2.986	143060	53.7	3.879	218	12.2	12.9	NA	0.028	4587	3468	160m.fbmy5635_rel_202302162102.cy9c_gcp_c2s30
797	36839	2	0.0	14.0	1.7	0.000	0.001	0.018	2.200	143109	53.4	3.885	217	12.2	12.9	NA	0.024	4637	3836	160m.fbmy5635_rel_202304122154.cy9c_gcp_c2s30
797	36461	0	0.0	14.4	1.8	0.000	0.001	0.018	2.318	141568	53.4	3.883	220	12.3	13.0	NA	0.037	4651	3564	160m.fbmy5635_rel_202305292102.cy9c_gcp_c2s30
797	36268	3	0.1	17.1	2.3	0.000	0.002	0.021	2.982	142138	53.7	3.919	222	12.2	12.9	NA	0.021	4587	3101	160m.fbmy5635_rel_20230529_832.cy9c_gcp_c2s30
797	35586	2	0.0	17.0	2.3	0.000	0.001	0.021	3.006	138938	53.7	3.904	226	12.1	12.9	NA	0.026	4427	3549	160m.fbmy5635_rel_20230529_843.cy9c_gcp_c2s30
797	35330	2	0.0	13.8	1.7	0.000	0.001	0.017	2.198	138207	53.4	3.912	227	12.1	12.9	NA	0.020	4429	3532	160m.fbmy5635_rel_20230529_850.cy9c_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
fbmy5635_rel_202104072149.cy9c_gcp_c2s3097.8482.1490.003nonzerononzero0.025
fbmy5635_rel_202203072101.cy9c_gcp_c2s3097.1452.8520.003nonzero0.015
fbmy5635_rel_202205192101.cy9c_gcp_c2s3097.0332.9640.003nonzerononzero0.037
fbmy5635_rel_202208092101.cy9c_gcp_c2s3096.8563.1410.003nonzerononzero0.024
fbmy5635_rel_202210112144.cy9c_gcp_c2s3096.3023.6940.004nonzerononzero0.024
fbmy5635_rel_202302162102.cy9c_gcp_c2s3094.3265.6690.005nonzerononzero0.022
fbmy5635_rel_202304122154.cy9c_gcp_c2s3094.3695.6260.004nonzerononzero0.026
fbmy5635_rel_202305292102.cy9c_gcp_c2s3094.2235.7730.004nonzerononzero0.020
fbmy5635_rel_20230529_832.cy9c_gcp_c2s3093.2846.7120.004nonzerononzero0.025
fbmy5635_rel_20230529_843.cy9c_gcp_c2s3090.8929.1040.004nonzerononzero0.025
fbmy5635_rel_20230529_850.cy9c_gcp_c2s3090.3199.6750.006nonzerononzero0.024

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.cy9c_gcp_c2s3031.95868.0230.0180.001nonzero0.066
fbmy5635_rel_202203072101.cy9c_gcp_c2s309.16090.8090.0290.0010.0010.086
fbmy5635_rel_202205192101.cy9c_gcp_c2s305.91694.0470.037nonzero0.089
fbmy5635_rel_202208092101.cy9c_gcp_c2s306.28293.6890.0280.001nonzero0.066
fbmy5635_rel_202210112144.cy9c_gcp_c2s303.59496.3740.031nonzero0.017
fbmy5635_rel_202302162102.cy9c_gcp_c2s309.90589.5640.5280.0030.020
fbmy5635_rel_202304122154.cy9c_gcp_c2s3012.45687.3700.174nonzero0.018
fbmy5635_rel_202305292102.cy9c_gcp_c2s3013.18586.7500.0650.0010.019
fbmy5635_rel_20230529_832.cy9c_gcp_c2s3016.18383.7910.025nonzero0.017
fbmy5635_rel_20230529_843.cy9c_gcp_c2s3014.08385.8970.0190.0010.019
fbmy5635_rel_20230529_850.cy9c_gcp_c2s305.59090.8453.5580.0060.0010.071

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.cy9c_gcp_c2s3027.98071.9790.0380.003nonzero0.066
fbmy5635_rel_202203072101.cy9c_gcp_c2s3010.32889.6300.0380.0030.0010.086
fbmy5635_rel_202205192101.cy9c_gcp_c2s3010.50989.4420.0470.0020.0010.095
fbmy5635_rel_202208092101.cy9c_gcp_c2s309.24790.6980.0520.002nonzero0.066
fbmy5635_rel_202210112144.cy9c_gcp_c2s304.83695.1150.0450.0030.045
fbmy5635_rel_202302162102.cy9c_gcp_c2s3014.27585.1980.5230.0040.029
fbmy5635_rel_202304122154.cy9c_gcp_c2s3016.44683.3880.1650.0020.029
fbmy5635_rel_202305292102.cy9c_gcp_c2s3017.04982.8910.0580.0020.029
fbmy5635_rel_20230529_832.cy9c_gcp_c2s3016.58283.3660.0470.0050.043
fbmy5635_rel_20230529_843.cy9c_gcp_c2s3013.08086.9020.0170.0010.023
fbmy5635_rel_20230529_850.cy9c_gcp_c2s309.25587.5503.1870.0060.0010.071

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
3987	38007	0	0.0	39.1	6.2	0.000	0.000	0.010	1.586	149296	55.2	3.928	218	12.1	13.8	NA	0.025	4795	4443	160m.fbmy5635_rel_202104072149.cy9c_gcp_c2s30
3987	37122	0	0.0	39.2	6.4	0.000	0.000	0.010	1.633	145970	55.4	3.932	224	12.1	13.9	NA	0.015	4653	4347	160m.fbmy5635_rel_202203072101.cy9c_gcp_c2s30
3987	36874	0	0.0	37.6	6.1	0.000	0.000	0.009	1.576	145016	55.3	3.933	225	12.1	13.9	NA	0.037	4635	4301	160m.fbmy5635_rel_202205192101.cy9c_gcp_c2s30
3987	36564	0	0.0	41.0	6.4	0.000	0.000	0.010	1.633	143900	55.4	3.936	227	12.1	13.9	NA	0.024	4603	4283	160m.fbmy5635_rel_202208092101.cy9c_gcp_c2s30
3987	36276	0	0.0	40.1	6.0	0.000	0.000	0.010	1.535	142837	55.3	3.937	229	12.1	13.9	NA	0.024	4555	4219	160m.fbmy5635_rel_202210112144.cy9c_gcp_c2s30
3988	35754	1	0.0	31.7	5.1	0.000	0.001	0.008	1.312	140099	55.3	3.918	232	12.2	14.0	NA	0.022	4491	4077	160m.fbmy5635_rel_202302162102.cy9c_gcp_c2s30
3987	35794	11	0.1	32.2	5.1	0.000	0.002	0.008	1.302	140339	55.2	3.921	231	12.2	14.0	NA	0.026	4493	4093	160m.fbmy5635_rel_202304122154.cy9c_gcp_c2s30
3987	35513	0	0.0	31.7	5.0	0.000	0.000	0.008	1.284	139151	55.2	3.918	233	12.3	14.1	NA	0.020	4461	4060	160m.fbmy5635_rel_202305292102.cy9c_gcp_c2s30
3987	35257	9	0.1	32.4	5.0	0.000	0.003	0.008	1.295	139485	55.2	3.956	235	12.2	14.0	NA	0.025	4443	4028	160m.fbmy5635_rel_20230529_832.cy9c_gcp_c2s30
3987	34367	6	0.1	31.7	5.1	0.000	0.002	0.008	1.317	135938	55.2	3.955	241	12.4	14.2	NA	0.025	4315	3916	160m.fbmy5635_rel_20230529_843.cy9c_gcp_c2s30
3988	34246	8	0.0	32.5	4.9	0.000	0.001	0.008	1.262	135337	55.2	3.952	242	12.3	14.2	NA	0.024	4299	3916	160m.fbmy5635_rel_20230529_850.cy9c_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
fbmy5635_rel_202104072149.cy9c_gcp_c2s3094.1155.8780.006nonzerononzero0.044
fbmy5635_rel_202203072101.cy9c_gcp_c2s3093.0056.9880.006nonzerononzero0.040
fbmy5635_rel_202205192101.cy9c_gcp_c2s3092.7847.2090.006nonzerononzero0.034
fbmy5635_rel_202208092101.cy9c_gcp_c2s3092.6537.3400.006nonzerononzero0.038
fbmy5635_rel_202210112144.cy9c_gcp_c2s3091.8738.1200.007nonzerononzero0.034
fbmy5635_rel_202302162102.cy9c_gcp_c2s3087.25512.7360.009nonzerononzero0.034
fbmy5635_rel_202304122154.cy9c_gcp_c2s3087.71712.2740.008nonzerononzero0.035
fbmy5635_rel_202305292102.cy9c_gcp_c2s3086.51013.4810.009nonzerononzero0.036
fbmy5635_rel_20230529_832.cy9c_gcp_c2s3084.94415.0490.007nonzerononzero0.045
fbmy5635_rel_20230529_843.cy9c_gcp_c2s3081.55918.4340.007nonzerononzero0.045
fbmy5635_rel_20230529_850.cy9c_gcp_c2s3081.13818.8540.008nonzerononzero0.046

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.cy9c_gcp_c2s3021.41178.5300.0570.0020.025
fbmy5635_rel_202203072101.cy9c_gcp_c2s309.28790.6610.0510.0010.031
fbmy5635_rel_202205192101.cy9c_gcp_c2s304.91195.0490.0390.0010.032
fbmy5635_rel_202208092101.cy9c_gcp_c2s305.70394.2590.0370.0010.033
fbmy5635_rel_202210112144.cy9c_gcp_c2s302.81297.1390.0480.0010.022
fbmy5635_rel_202302162102.cy9c_gcp_c2s308.75190.0061.2390.0030.018
fbmy5635_rel_202304122154.cy9c_gcp_c2s309.43490.2640.2990.0030.034
fbmy5635_rel_202305292102.cy9c_gcp_c2s307.40091.5741.0200.0070.032
fbmy5635_rel_20230529_832.cy9c_gcp_c2s3010.54489.4180.0380.0010.042
fbmy5635_rel_20230529_843.cy9c_gcp_c2s308.42691.5170.0550.0020.038
fbmy5635_rel_20230529_850.cy9c_gcp_c2s306.80593.0580.1330.0030.044

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.cy9c_gcp_c2s3020.71879.1820.0910.0090.044
fbmy5635_rel_202203072101.cy9c_gcp_c2s3010.39289.5130.0890.0060.039
fbmy5635_rel_202205192101.cy9c_gcp_c2s307.34092.5940.0610.0050.042
fbmy5635_rel_202208092101.cy9c_gcp_c2s307.61992.2820.0950.0040.044
fbmy5635_rel_202210112144.cy9c_gcp_c2s304.52695.3700.0990.0050.040
fbmy5635_rel_202302162102.cy9c_gcp_c2s3013.12485.6941.1750.0080.034
fbmy5635_rel_202304122154.cy9c_gcp_c2s3014.16485.5180.3110.0070.035
fbmy5635_rel_202305292102.cy9c_gcp_c2s3010.40988.6050.9770.0090.036
fbmy5635_rel_20230529_832.cy9c_gcp_c2s3015.69584.1860.1120.0070.042
fbmy5635_rel_20230529_843.cy9c_gcp_c2s3011.26988.6000.1240.0070.045
fbmy5635_rel_20230529_850.cy9c_gcp_c2s3010.12589.6790.1890.0070.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
7973	36741	0	0.0	73.6	13.3	0.000	0.000	0.009	1.703	145828	57.8	3.969	236	12.2	14.1	NA	0.044	4603	4269	160m.fbmy5635_rel_202104072149.cy9c_gcp_c2s30
7973	35778	0	0.0	72.6	13.1	0.000	0.000	0.009	1.686	142305	57.9	3.978	243	12.4	14.4	NA	0.040	4507	4187	160m.fbmy5635_rel_202203072101.cy9c_gcp_c2s30
7976	35704	0	0.0	72.4	13.0	0.000	0.000	0.009	1.667	142009	58.0	3.977	244	12.3	14.3	NA	0.034	4491	4171	160m.fbmy5635_rel_202205192101.cy9c_gcp_c2s30
7973	35466	0	0.0	74.2	13.0	0.000	0.000	0.009	1.669	141266	57.9	3.983	245	12.2	14.2	NA	0.038	4445	4139	160m.fbmy5635_rel_202208092101.cy9c_gcp_c2s30
7973	35178	0	0.0	74.9	13.2	0.000	0.000	0.009	1.698	140011	58.0	3.980	247	12.2	14.1	NA	0.034	4427	4108	160m.fbmy5635_rel_202210112144.cy9c_gcp_c2s30
7976	34258	0	0.0	61.6	10.7	0.000	0.000	0.008	1.375	135317	57.9	3.950	254	12.4	14.4	NA	0.034	4301	3900	160m.fbmy5635_rel_202302162102.cy9c_gcp_c2s30
7973	34330	10	0.1	61.4	11.0	0.000	0.003	0.008	1.413	135982	57.9	3.961	253	12.5	14.5	NA	0.035	4315	3900	160m.fbmy5635_rel_202304122154.cy9c_gcp_c2s30
7978	34036	0	0.0	62.1	11.0	0.000	0.000	0.008	1.406	134436	58.1	3.950	256	12.7	12.7	NA	0.036	4283	3868	160m.fbmy5635_rel_202305292102.cy9c_gcp_c2s30
7973	33689	20	0.2	61.6	10.6	0.001	0.006	0.008	1.365	134872	58.0	4.003	258	12.7	14.7	NA	0.045	4251	3868	160m.fbmy5635_rel_20230529_832.cy9c_gcp_c2s30
7976	32978	12	0.1	61.6	10.9	0.000	0.003	0.008	1.400	131892	58.1	3.999	264	12.5	14.5	NA	0.045	4155	3756	160m.fbmy5635_rel_20230529_843.cy9c_gcp_c2s30
7973	32899	0	0.0	62.2	10.7	0.000	0.000	0.008	1.377	131182	58.0	3.987	264	12.4	12.5	NA	0.046	4123	3740	160m.fbmy5635_rel_20230529_850.cy9c_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
592592	0	0	0.0	575.5	176.5	0.000	0.000	0.001	0.305	79542	71.0	0.134	18	5.5	7.1	NA	0.273	78642	55860	160m.fbmy5635_rel_202104072149.cy9c_gcp_c2s30
575540	0	0	0.0	559.8	169.7	0.000	0.000	0.001	0.302	82087	71.1	0.143	19	5.5	7.0	NA	0.296	75818	51344	160m.fbmy5635_rel_202203072101.cy9c_gcp_c2s30
565371	0	0	0.0	556.0	166.7	0.000	0.000	0.001	0.302	81789	70.8	0.145	19	5.3	6.8	NA	0.295	75219	51844	160m.fbmy5635_rel_202205192101.cy9c_gcp_c2s30
571428	0	0	0.0	557.3	167.4	0.000	0.000	0.001	0.300	79294	70.5	0.139	19	5.5	7.0	NA	0.239	75445	55660	160m.fbmy5635_rel_202208092101.cy9c_gcp_c2s30
559440	0	0	0.0	556.2	162.3	0.000	0.000	0.001	0.297	78575	70.3	0.140	19	6.1	7.6	NA	0.287	74244	50944	160m.fbmy5635_rel_202210112144.cy9c_gcp_c2s30
586080	0	0	0.0	507.1	144.4	0.000	0.000	0.001	0.252	79793	71.8	0.136	18	5.2	6.7	NA	0.254	77116	57237	160m.fbmy5635_rel_202302162102.cy9c_gcp_c2s30
577617	0	0	0.0	493.4	147.1	0.000	0.000	0.001	0.261	78406	71.1	0.136	18	5.2	6.7	NA	0.280	75319	58041	160m.fbmy5635_rel_202304122154.cy9c_gcp_c2s30
579710	0	0	0.0	480.2	143.2	0.000	0.000	0.001	0.253	77381	71.2	0.133	18	5.3	6.8	NA	0.239	75018	57059	160m.fbmy5635_rel_202305292102.cy9c_gcp_c2s30
579710	0	0	0.0	477.8	149.1	0.000	0.000	0.001	0.263	80550	70.8	0.139	18	5.2	6.7	NA	0.263	77311	57537	160m.fbmy5635_rel_20230529_832.cy9c_gcp_c2s30
571428	0	0	0.0	473.0	137.0	0.000	0.000	0.001	0.246	75341	70.6	0.132	19	5.0	6.5	NA	0.249	75218	54540	160m.fbmy5635_rel_20230529_843.cy9c_gcp_c2s30
571428	0	0	0.0	479.9	145.2	0.000	0.000	0.001	0.260	76333	71.2	0.134	19	5.2	6.7	NA	0.248	73121	55739	160m.fbmy5635_rel_20230529_850.cy9c_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
796517	0	1	0.1	320.6	112.3	0.000	0.000	0.000	0.144	1295	50.8	0.002	10	10.9	12.5	NA	0.002	NA	NA	160m.fbmy5635_rel_202104072149.cy9c_gcp_c2s30
800500	0	1	0.1	335.6	119.1	0.000	0.000	0.000	0.152	1361	50.6	0.002	9	10.8	12.3	NA	0.002	NA	NA	160m.fbmy5635_rel_202203072101.cy9c_gcp_c2s30
800500	0	1	0.1	321.2	114.4	0.000	0.000	0.000	0.146	1173	50.7	0.001	10	10.9	12.4	NA	0.002	NA	NA	160m.fbmy5635_rel_202205192101.cy9c_gcp_c2s30
792574	0	1	0.1	329.2	114.7	0.000	0.000	0.000	0.148	1262	50.6	0.002	10	10.8	12.3	NA	0.002	NA	NA	160m.fbmy5635_rel_202208092101.cy9c_gcp_c2s30
804523	0	1	0.1	327.7	111.4	0.000	0.000	0.000	0.142	1470	50.0	0.002	9	10.9	12.4	NA	0.002	NA	NA	160m.fbmy5635_rel_202210112144.cy9c_gcp_c2s30
769712	0	1	0.1	284.0	103.7	0.000	0.000	0.000	0.138	1315	50.2	0.002	10	10.9	12.4	NA	0.002	NA	NA	160m.fbmy5635_rel_202302162102.cy9c_gcp_c2s30
769712	0	1	0.1	287.5	101.8	0.000	0.000	0.000	0.135	1168	50.3	0.002	10	10.8	12.3	NA	0.002	NA	NA	160m.fbmy5635_rel_202304122154.cy9c_gcp_c2s30
762381	0	1	0.1	280.8	101.2	0.000	0.000	0.000	0.136	1209	48.7	0.002	10	10.8	12.3	NA	0.002	NA	NA	160m.fbmy5635_rel_202305292102.cy9c_gcp_c2s30
737788	0	1	0.1	270.1	96.8	0.000	0.000	0.000	0.134	1035	49.5	0.001	10	10.8	12.3	NA	0.002	NA	NA	160m.fbmy5635_rel_20230529_832.cy9c_gcp_c2s30
724434	0	1	0.1	266.1	95.9	0.000	0.000	0.000	0.136	937	49.0	0.001	10	10.8	12.3	NA	0.003	NA	NA	160m.fbmy5635_rel_20230529_843.cy9c_gcp_c2s30
724434	0	1	0.1	273.5	95.1	0.000	0.000	0.000	0.134	961	48.9	0.001	10	10.8	12.3	NA	0.002	NA	NA	160m.fbmy5635_rel_20230529_850.cy9c_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
94096	0	1	0.3	610.7	129.4	0.000	0.004	0.006	1.408	75458	56.7	0.802	90	13.8	13.8	NA	0.458	11837	8890	160m.fbmy5635_rel_202104072149.cy9c_gcp_c2s30
92054	0	1	0.3	596.6	131.2	0.000	0.004	0.006	1.459	79575	56.9	0.864	93	15.3	15.4	NA	0.399	11592	8739	160m.fbmy5635_rel_202203072101.cy9c_gcp_c2s30
90441	0	1	0.3	583.5	128.7	0.000	0.004	0.006	1.457	77340	56.5	0.855	94	13.8	13.9	NA	0.401	11393	8790	160m.fbmy5635_rel_202205192101.cy9c_gcp_c2s30
89736	0	1	0.3	584.9	127.1	0.000	0.004	0.007	1.450	74132	56.2	0.826	94	15.3	15.4	NA	0.407	11338	8544	160m.fbmy5635_rel_202208092101.cy9c_gcp_c2s30
90222	0	1	0.3	582.2	128.4	0.000	0.004	0.006	1.457	74111	56.7	0.821	94	14.0	14.1	NA	0.407	11388	8541	160m.fbmy5635_rel_202210112144.cy9c_gcp_c2s30
90054	0	204	1.5	463.5	113.1	0.002	0.017	0.005	1.286	85221	60.8	0.946	101	22.8	22.9	NA	0.599	11441	6145	160m.fbmy5635_rel_202302162102.cy9c_gcp_c2s30
88638	0	166	1.2	453.9	111.8	0.002	0.014	0.005	1.291	82939	59.2	0.936	100	14.9	15.0	NA	0.520	11293	5244	160m.fbmy5635_rel_202304122154.cy9c_gcp_c2s30
89221	0	166	1.3	456.9	114.9	0.002	0.015	0.005	1.319	83404	61.6	0.935	104	15.4	15.5	NA	0.673	11338	5194	160m.fbmy5635_rel_202305292102.cy9c_gcp_c2s30
88874	0	244	1.6	453.3	115.2	0.003	0.018	0.005	1.327	84376	61.5	0.949	104	20.1	20.3	NA	0.511	11288	6193	160m.fbmy5635_rel_20230529_832.cy9c_gcp_c2s30
87522	0	181	1.8	445.1	114.7	0.002	0.021	0.005	1.342	83935	62.5	0.959	107	20.1	20.3	NA	0.592	11288	4096	160m.fbmy5635_rel_20230529_843.cy9c_gcp_c2s30
89410	0	309	1.5	457.6	111.3	0.003	0.017	0.005	1.275	81699	61.6	0.914	103	18.8	19.0	NA	0.415	11342	7092	160m.fbmy5635_rel_20230529_850.cy9c_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
797	39033	0	0.0	14.9	1.5	0.000	0.000	0.019	1.935	151815	53.5	3.889	206	12.0	12.7	NA	0.028	4813	4509	160m.fbmy5635_rel_202104072149.cy9c_gcp_c2s30
797	38256	0	0.0	15.1	1.6	0.000	0.000	0.019	2.059	148980	53.6	3.894	210	12.1	12.8	NA	0.037	4749	4395	160m.fbmy5635_rel_202203072101.cy9c_gcp_c2s30
797	37848	0	0.0	15.8	1.7	0.000	0.000	0.020	2.168	147287	53.5	3.892	212	12.2	12.9	NA	0.047	4731	4347	160m.fbmy5635_rel_202205192101.cy9c_gcp_c2s30
797	37448	0	0.0	17.0	1.7	0.000	0.000	0.021	2.145	146135	53.5	3.902	214	12.2	12.9	NA	0.020	4699	4365	160m.fbmy5635_rel_202208092101.cy9c_gcp_c2s30
797	37269	0	0.0	18.5	1.8	0.000	0.000	0.023	2.271	145435	53.5	3.902	215	12.1	12.9	NA	0.024	4651	4315	160m.fbmy5635_rel_202210112144.cy9c_gcp_c2s30
797	36880	0	0.0	17.6	2.3	0.000	0.001	0.022	2.986	143060	53.7	3.879	218	12.2	12.9	NA	0.028	4587	3468	160m.fbmy5635_rel_202302162102.cy9c_gcp_c2s30
797	36839	2	0.0	14.0	1.7	0.000	0.001	0.018	2.200	143109	53.4	3.885	217	12.2	12.9	NA	0.024	4637	3836	160m.fbmy5635_rel_202304122154.cy9c_gcp_c2s30
797	36461	0	0.0	14.4	1.8	0.000	0.001	0.018	2.318	141568	53.4	3.883	220	12.3	13.0	NA	0.037	4651	3564	160m.fbmy5635_rel_202305292102.cy9c_gcp_c2s30
797	36268	3	0.1	17.1	2.3	0.000	0.002	0.021	2.982	142138	53.7	3.919	222	12.2	12.9	NA	0.021	4587	3101	160m.fbmy5635_rel_20230529_832.cy9c_gcp_c2s30
797	35586	2	0.0	17.0	2.3	0.000	0.001	0.021	3.006	138938	53.7	3.904	226	12.1	12.9	NA	0.026	4427	3549	160m.fbmy5635_rel_20230529_843.cy9c_gcp_c2s30
797	35330	2	0.0	13.8	1.7	0.000	0.001	0.017	2.198	138207	53.4	3.912	227	12.1	12.9	NA	0.020	4429	3532	160m.fbmy5635_rel_20230529_850.cy9c_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
3987	38007	0	0.0	39.1	6.2	0.000	0.000	0.010	1.586	149296	55.2	3.928	218	12.1	13.8	NA	0.025	4795	4443	160m.fbmy5635_rel_202104072149.cy9c_gcp_c2s30
3987	37122	0	0.0	39.2	6.4	0.000	0.000	0.010	1.633	145970	55.4	3.932	224	12.1	13.9	NA	0.015	4653	4347	160m.fbmy5635_rel_202203072101.cy9c_gcp_c2s30
3987	36874	0	0.0	37.6	6.1	0.000	0.000	0.009	1.576	145016	55.3	3.933	225	12.1	13.9	NA	0.037	4635	4301	160m.fbmy5635_rel_202205192101.cy9c_gcp_c2s30
3987	36564	0	0.0	41.0	6.4	0.000	0.000	0.010	1.633	143900	55.4	3.936	227	12.1	13.9	NA	0.024	4603	4283	160m.fbmy5635_rel_202208092101.cy9c_gcp_c2s30
3987	36276	0	0.0	40.1	6.0	0.000	0.000	0.010	1.535	142837	55.3	3.937	229	12.1	13.9	NA	0.024	4555	4219	160m.fbmy5635_rel_202210112144.cy9c_gcp_c2s30
3988	35754	1	0.0	31.7	5.1	0.000	0.001	0.008	1.312	140099	55.3	3.918	232	12.2	14.0	NA	0.022	4491	4077	160m.fbmy5635_rel_202302162102.cy9c_gcp_c2s30
3987	35794	11	0.1	32.2	5.1	0.000	0.002	0.008	1.302	140339	55.2	3.921	231	12.2	14.0	NA	0.026	4493	4093	160m.fbmy5635_rel_202304122154.cy9c_gcp_c2s30
3987	35513	0	0.0	31.7	5.0	0.000	0.000	0.008	1.284	139151	55.2	3.918	233	12.3	14.1	NA	0.020	4461	4060	160m.fbmy5635_rel_202305292102.cy9c_gcp_c2s30
3987	35257	9	0.1	32.4	5.0	0.000	0.003	0.008	1.295	139485	55.2	3.956	235	12.2	14.0	NA	0.025	4443	4028	160m.fbmy5635_rel_20230529_832.cy9c_gcp_c2s30
3987	34367	6	0.1	31.7	5.1	0.000	0.002	0.008	1.317	135938	55.2	3.955	241	12.4	14.2	NA	0.025	4315	3916	160m.fbmy5635_rel_20230529_843.cy9c_gcp_c2s30
3988	34246	8	0.0	32.5	4.9	0.000	0.001	0.008	1.262	135337	55.2	3.952	242	12.3	14.2	NA	0.024	4299	3916	160m.fbmy5635_rel_20230529_850.cy9c_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
7973	36741	0	0.0	73.6	13.3	0.000	0.000	0.009	1.703	145828	57.8	3.969	236	12.2	14.1	NA	0.044	4603	4269	160m.fbmy5635_rel_202104072149.cy9c_gcp_c2s30
7973	35778	0	0.0	72.6	13.1	0.000	0.000	0.009	1.686	142305	57.9	3.978	243	12.4	14.4	NA	0.040	4507	4187	160m.fbmy5635_rel_202203072101.cy9c_gcp_c2s30
7976	35704	0	0.0	72.4	13.0	0.000	0.000	0.009	1.667	142009	58.0	3.977	244	12.3	14.3	NA	0.034	4491	4171	160m.fbmy5635_rel_202205192101.cy9c_gcp_c2s30
7973	35466	0	0.0	74.2	13.0	0.000	0.000	0.009	1.669	141266	57.9	3.983	245	12.2	14.2	NA	0.038	4445	4139	160m.fbmy5635_rel_202208092101.cy9c_gcp_c2s30
7973	35178	0	0.0	74.9	13.2	0.000	0.000	0.009	1.698	140011	58.0	3.980	247	12.2	14.1	NA	0.034	4427	4108	160m.fbmy5635_rel_202210112144.cy9c_gcp_c2s30
7976	34258	0	0.0	61.6	10.7	0.000	0.000	0.008	1.375	135317	57.9	3.950	254	12.4	14.4	NA	0.034	4301	3900	160m.fbmy5635_rel_202302162102.cy9c_gcp_c2s30
7973	34330	10	0.1	61.4	11.0	0.000	0.003	0.008	1.413	135982	57.9	3.961	253	12.5	14.5	NA	0.035	4315	3900	160m.fbmy5635_rel_202304122154.cy9c_gcp_c2s30
7978	34036	0	0.0	62.1	11.0	0.000	0.000	0.008	1.406	134436	58.1	3.950	256	12.7	12.7	NA	0.036	4283	3868	160m.fbmy5635_rel_202305292102.cy9c_gcp_c2s30
7973	33689	20	0.2	61.6	10.6	0.001	0.006	0.008	1.365	134872	58.0	4.003	258	12.7	14.7	NA	0.045	4251	3868	160m.fbmy5635_rel_20230529_832.cy9c_gcp_c2s30
7976	32978	12	0.1	61.6	10.9	0.000	0.003	0.008	1.400	131892	58.1	3.999	264	12.5	14.5	NA	0.045	4155	3756	160m.fbmy5635_rel_20230529_843.cy9c_gcp_c2s30
7973	32899	0	0.0	62.2	10.7	0.000	0.000	0.008	1.377	131182	58.0	3.987	264	12.4	12.5	NA	0.046	4123	3740	160m.fbmy5635_rel_20230529_850.cy9c_gcp_c2s30

l.i0

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	20.796	79.177	0.011	0.003	0.014	0.001	0.000	0.000	0.000	0.273	fbmy5635_rel_202104072149.cy9c_gcp_c2s30
0.000	19.408	80.564	0.013	0.001	0.013	0.001	0.000	0.000	0.000	0.296	fbmy5635_rel_202203072101.cy9c_gcp_c2s30
0.000	17.312	82.657	0.015	0.002	0.013	0.001	0.000	0.000	0.000	0.295	fbmy5635_rel_202205192101.cy9c_gcp_c2s30
0.000	18.917	81.048	0.020	0.002	0.014	0.000	0.000	0.000	0.000	0.239	fbmy5635_rel_202208092101.cy9c_gcp_c2s30
0.000	17.311	82.660	0.013	0.002	0.013	0.001	0.000	0.000	0.000	0.287	fbmy5635_rel_202210112144.cy9c_gcp_c2s30
0.000	21.278	78.694	0.013	0.001	0.014	0.000	0.000	0.000	0.000	0.254	fbmy5635_rel_202302162102.cy9c_gcp_c2s30
0.000	20.137	79.841	0.007	0.002	0.012	0.001	0.000	0.000	0.000	0.280	fbmy5635_rel_202304122154.cy9c_gcp_c2s30
0.000	20.510	79.466	0.009	0.002	0.014	0.000	0.000	0.000	0.000	0.239	fbmy5635_rel_202305292102.cy9c_gcp_c2s30
0.000	21.056	78.920	0.011	nonzero	0.013	0.001	0.000	0.000	0.000	0.263	fbmy5635_rel_20230529_832.cy9c_gcp_c2s30
0.000	20.931	79.046	0.008	0.001	0.014	0.000	0.000	0.000	0.000	0.249	fbmy5635_rel_20230529_843.cy9c_gcp_c2s30
0.000	20.387	79.587	0.012	nonzero	0.014	0.000	0.000	0.000	0.000	0.248	fbmy5635_rel_20230529_850.cy9c_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.013	42.512	57.389	0.072	0.013	0.002	0.000	0.000	0.000	0.458	fbmy5635_rel_202104072149.cy9c_gcp_c2s30
0.000	0.007	37.585	62.318	0.076	0.013	0.001	0.000	0.000	0.000	0.399	fbmy5635_rel_202203072101.cy9c_gcp_c2s30
0.000	0.006	34.164	65.740	0.074	0.014	0.001	0.000	0.000	0.000	0.401	fbmy5635_rel_202205192101.cy9c_gcp_c2s30
0.000	0.006	33.587	66.318	0.075	0.013	0.001	0.000	0.000	0.000	0.407	fbmy5635_rel_202208092101.cy9c_gcp_c2s30
0.000	0.006	34.504	65.401	0.074	0.013	0.001	0.000	0.000	0.000	0.407	fbmy5635_rel_202210112144.cy9c_gcp_c2s30
0.000	0.006	42.376	57.459	0.145	0.013	0.001	0.000	0.000	0.000	0.599	fbmy5635_rel_202302162102.cy9c_gcp_c2s30
0.000	0.013	39.191	60.593	0.187	0.015	0.001	0.000	0.000	0.000	0.520	fbmy5635_rel_202304122154.cy9c_gcp_c2s30
0.000	0.005	41.458	58.358	0.159	0.018	0.001	0.000	0.000	0.000	0.673	fbmy5635_rel_202305292102.cy9c_gcp_c2s30
0.000	0.013	41.741	58.095	0.138	0.012	0.001	0.000	0.000	0.000	0.511	fbmy5635_rel_20230529_832.cy9c_gcp_c2s30
0.000	0.005	41.220	58.515	0.247	0.013	0.001	0.000	0.000	0.000	0.592	fbmy5635_rel_20230529_843.cy9c_gcp_c2s30
0.000	0.006	41.204	58.672	0.105	0.013	0.001	0.000	0.000	0.000	0.415	fbmy5635_rel_20230529_850.cy9c_gcp_c2s30

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.011	38.850	61.048	0.075	0.014	0.002	0.000	0.000	0.000	0.459	fbmy5635_rel_202104072149.cy9c_gcp_c2s30
0.000	0.007	36.054	63.846	0.079	0.014	0.001	0.000	0.000	0.000	0.397	fbmy5635_rel_202203072101.cy9c_gcp_c2s30
0.000	0.006	34.170	65.732	0.076	0.014	0.001	0.000	0.000	0.000	0.399	fbmy5635_rel_202205192101.cy9c_gcp_c2s30
0.000	0.006	32.540	67.363	0.077	0.014	0.001	0.000	0.000	0.000	0.409	fbmy5635_rel_202208092101.cy9c_gcp_c2s30
0.000	0.006	33.647	66.255	0.076	0.014	0.001	0.000	0.000	0.000	0.406	fbmy5635_rel_202210112144.cy9c_gcp_c2s30
0.000	0.006	37.325	62.442	0.204	0.022	0.001	0.000	0.000	0.000	0.727	fbmy5635_rel_202302162102.cy9c_gcp_c2s30
0.000	0.018	35.282	64.439	0.237	0.022	0.001	0.000	0.000	0.000	0.542	fbmy5635_rel_202304122154.cy9c_gcp_c2s30
0.000	0.005	36.725	63.037	0.206	0.025	0.002	0.000	0.000	0.000	0.865	fbmy5635_rel_202305292102.cy9c_gcp_c2s30
0.000	0.006	36.628	63.135	0.208	0.022	0.001	0.000	0.000	0.000	0.944	fbmy5635_rel_20230529_832.cy9c_gcp_c2s30
0.000	0.005	36.002	63.661	0.309	0.021	0.002	0.000	0.000	0.000	0.717	fbmy5635_rel_20230529_843.cy9c_gcp_c2s30
0.000	0.005	36.375	63.445	0.155	0.019	0.001	0.000	0.000	0.000	0.656	fbmy5635_rel_20230529_850.cy9c_gcp_c2s30

q100.1

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
98.912	1.086	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.028	fbmy5635_rel_202104072149.cy9c_gcp_c2s30
98.688	1.310	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.037	fbmy5635_rel_202203072101.cy9c_gcp_c2s30
98.407	1.592	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.047	fbmy5635_rel_202205192101.cy9c_gcp_c2s30
98.298	1.701	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.020	fbmy5635_rel_202208092101.cy9c_gcp_c2s30
98.215	1.784	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.024	fbmy5635_rel_202210112144.cy9c_gcp_c2s30
96.747	3.252	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.028	fbmy5635_rel_202302162102.cy9c_gcp_c2s30
97.114	2.885	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.024	fbmy5635_rel_202304122154.cy9c_gcp_c2s30
96.897	3.102	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.037	fbmy5635_rel_202305292102.cy9c_gcp_c2s30
95.706	4.293	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.021	fbmy5635_rel_20230529_832.cy9c_gcp_c2s30
95.272	4.727	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.026	fbmy5635_rel_20230529_843.cy9c_gcp_c2s30
94.876	5.123	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.020	fbmy5635_rel_20230529_850.cy9c_gcp_c2s30

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	8.644	91.314	0.042	0.000	0.000	0.000	0.000	0.000	0.000	0.010	fbmy5635_rel_202104072149.cy9c_gcp_c2s30
0.000	3.328	96.649	0.023	0.000	0.000	0.000	0.000	0.000	0.000	0.014	fbmy5635_rel_202203072101.cy9c_gcp_c2s30
0.000	1.316	98.653	0.030	0.002	0.000	0.000	0.000	0.000	0.000	0.016	fbmy5635_rel_202205192101.cy9c_gcp_c2s30
0.000	0.667	99.257	0.076	0.000	0.000	0.000	0.000	0.000	0.000	0.014	fbmy5635_rel_202208092101.cy9c_gcp_c2s30
0.000	0.981	99.003	0.016	0.000	0.000	0.000	0.000	0.000	0.000	0.011	fbmy5635_rel_202210112144.cy9c_gcp_c2s30
0.000	10.502	89.462	0.035	0.002	0.000	0.000	0.000	0.000	0.000	0.019	fbmy5635_rel_202302162102.cy9c_gcp_c2s30
0.000	15.309	84.661	0.030	0.000	0.000	0.000	0.000	0.000	0.000	0.013	fbmy5635_rel_202304122154.cy9c_gcp_c2s30
0.000	9.234	90.752	0.012	0.002	0.000	0.000	0.000	0.000	0.000	0.018	fbmy5635_rel_202305292102.cy9c_gcp_c2s30
0.000	15.889	84.080	0.031	0.000	0.000	0.000	0.000	0.000	0.000	0.015	fbmy5635_rel_20230529_832.cy9c_gcp_c2s30
0.000	12.590	87.363	0.042	0.005	0.000	0.000	0.000	0.000	0.000	0.042	fbmy5635_rel_20230529_843.cy9c_gcp_c2s30
0.000	9.042	90.938	0.021	0.000	0.000	0.000	0.000	0.000	0.000	0.011	fbmy5635_rel_20230529_850.cy9c_gcp_c2s30

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	5.854	94.078	0.068	0.000	0.000	0.000	0.000	0.000	0.000	0.012	fbmy5635_rel_202104072149.cy9c_gcp_c2s30
0.000	2.264	97.688	0.049	0.000	0.000	0.000	0.000	0.000	0.000	0.014	fbmy5635_rel_202203072101.cy9c_gcp_c2s30
0.000	2.710	97.247	0.042	0.002	0.000	0.000	0.000	0.000	0.000	0.017	fbmy5635_rel_202205192101.cy9c_gcp_c2s30
0.000	1.507	98.387	0.106	0.000	0.000	0.000	0.000	0.000	0.000	0.014	fbmy5635_rel_202208092101.cy9c_gcp_c2s30
0.000	1.057	98.925	0.017	0.000	0.000	0.000	0.000	0.000	0.000	0.010	fbmy5635_rel_202210112144.cy9c_gcp_c2s30
0.000	5.319	94.634	0.042	0.005	0.000	0.000	0.000	0.000	0.000	0.042	fbmy5635_rel_202302162102.cy9c_gcp_c2s30
0.000	6.384	93.536	0.078	0.002	0.000	0.000	0.000	0.000	0.000	0.048	fbmy5635_rel_202304122154.cy9c_gcp_c2s30
0.000	5.014	94.917	0.069	0.000	0.000	0.000	0.000	0.000	0.000	0.015	fbmy5635_rel_202305292102.cy9c_gcp_c2s30
0.000	4.872	95.045	0.082	0.002	0.000	0.000	0.000	0.000	0.000	0.027	fbmy5635_rel_20230529_832.cy9c_gcp_c2s30
0.000	3.700	96.212	0.085	0.003	0.000	0.000	0.000	0.000	0.000	0.022	fbmy5635_rel_20230529_843.cy9c_gcp_c2s30
0.000	5.267	94.653	0.076	0.003	0.000	0.000	0.000	0.000	0.000	0.020	fbmy5635_rel_20230529_850.cy9c_gcp_c2s30

q500.1

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
97.848	2.149	0.003	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.025	fbmy5635_rel_202104072149.cy9c_gcp_c2s30
97.145	2.852	0.003	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.015	fbmy5635_rel_202203072101.cy9c_gcp_c2s30
97.033	2.964	0.003	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.037	fbmy5635_rel_202205192101.cy9c_gcp_c2s30
96.856	3.141	0.003	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.024	fbmy5635_rel_202208092101.cy9c_gcp_c2s30
96.302	3.694	0.004	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.024	fbmy5635_rel_202210112144.cy9c_gcp_c2s30
94.326	5.669	0.005	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.022	fbmy5635_rel_202302162102.cy9c_gcp_c2s30
94.369	5.626	0.004	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.026	fbmy5635_rel_202304122154.cy9c_gcp_c2s30
94.223	5.773	0.004	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.020	fbmy5635_rel_202305292102.cy9c_gcp_c2s30
93.284	6.712	0.004	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.025	fbmy5635_rel_20230529_832.cy9c_gcp_c2s30
90.892	9.104	0.004	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.025	fbmy5635_rel_20230529_843.cy9c_gcp_c2s30
90.319	9.675	0.006	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.024	fbmy5635_rel_20230529_850.cy9c_gcp_c2s30

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	31.958	68.023	0.018	0.001	nonzero	0.000	0.000	0.000	0.000	0.066	fbmy5635_rel_202104072149.cy9c_gcp_c2s30
0.000	9.160	90.809	0.029	0.001	0.001	0.000	0.000	0.000	0.000	0.086	fbmy5635_rel_202203072101.cy9c_gcp_c2s30
0.000	5.916	94.047	0.037	0.000	nonzero	0.000	0.000	0.000	0.000	0.089	fbmy5635_rel_202205192101.cy9c_gcp_c2s30
0.000	6.282	93.689	0.028	0.001	nonzero	0.000	0.000	0.000	0.000	0.066	fbmy5635_rel_202208092101.cy9c_gcp_c2s30
0.000	3.594	96.374	0.031	nonzero	0.000	0.000	0.000	0.000	0.000	0.017	fbmy5635_rel_202210112144.cy9c_gcp_c2s30
0.000	9.905	89.564	0.528	0.003	0.000	0.000	0.000	0.000	0.000	0.020	fbmy5635_rel_202302162102.cy9c_gcp_c2s30
0.000	12.456	87.370	0.174	nonzero	0.000	0.000	0.000	0.000	0.000	0.018	fbmy5635_rel_202304122154.cy9c_gcp_c2s30
0.000	13.185	86.750	0.065	0.001	0.000	0.000	0.000	0.000	0.000	0.019	fbmy5635_rel_202305292102.cy9c_gcp_c2s30
0.000	16.183	83.791	0.025	nonzero	0.000	0.000	0.000	0.000	0.000	0.017	fbmy5635_rel_20230529_832.cy9c_gcp_c2s30
0.000	14.083	85.897	0.019	0.001	0.000	0.000	0.000	0.000	0.000	0.019	fbmy5635_rel_20230529_843.cy9c_gcp_c2s30
0.000	5.590	90.845	3.558	0.006	0.001	0.000	0.000	0.000	0.000	0.071	fbmy5635_rel_20230529_850.cy9c_gcp_c2s30

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	27.980	71.979	0.038	0.003	nonzero	0.000	0.000	0.000	0.000	0.066	fbmy5635_rel_202104072149.cy9c_gcp_c2s30
0.000	10.328	89.630	0.038	0.003	0.001	0.000	0.000	0.000	0.000	0.086	fbmy5635_rel_202203072101.cy9c_gcp_c2s30
0.000	10.509	89.442	0.047	0.002	0.001	0.000	0.000	0.000	0.000	0.095	fbmy5635_rel_202205192101.cy9c_gcp_c2s30
0.000	9.247	90.698	0.052	0.002	nonzero	0.000	0.000	0.000	0.000	0.066	fbmy5635_rel_202208092101.cy9c_gcp_c2s30
0.000	4.836	95.115	0.045	0.003	0.000	0.000	0.000	0.000	0.000	0.045	fbmy5635_rel_202210112144.cy9c_gcp_c2s30
0.000	14.275	85.198	0.523	0.004	0.000	0.000	0.000	0.000	0.000	0.029	fbmy5635_rel_202302162102.cy9c_gcp_c2s30
0.000	16.446	83.388	0.165	0.002	0.000	0.000	0.000	0.000	0.000	0.029	fbmy5635_rel_202304122154.cy9c_gcp_c2s30
0.000	17.049	82.891	0.058	0.002	0.000	0.000	0.000	0.000	0.000	0.029	fbmy5635_rel_202305292102.cy9c_gcp_c2s30
0.000	16.582	83.366	0.047	0.005	0.000	0.000	0.000	0.000	0.000	0.043	fbmy5635_rel_20230529_832.cy9c_gcp_c2s30
0.000	13.080	86.902	0.017	0.001	0.000	0.000	0.000	0.000	0.000	0.023	fbmy5635_rel_20230529_843.cy9c_gcp_c2s30
0.000	9.255	87.550	3.187	0.006	0.001	0.000	0.000	0.000	0.000	0.071	fbmy5635_rel_20230529_850.cy9c_gcp_c2s30

q1000.1

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
94.115	5.878	0.006	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.044	fbmy5635_rel_202104072149.cy9c_gcp_c2s30
93.005	6.988	0.006	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.040	fbmy5635_rel_202203072101.cy9c_gcp_c2s30
92.784	7.209	0.006	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.034	fbmy5635_rel_202205192101.cy9c_gcp_c2s30
92.653	7.340	0.006	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.038	fbmy5635_rel_202208092101.cy9c_gcp_c2s30
91.873	8.120	0.007	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.034	fbmy5635_rel_202210112144.cy9c_gcp_c2s30
87.255	12.736	0.009	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.034	fbmy5635_rel_202302162102.cy9c_gcp_c2s30
87.717	12.274	0.008	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.035	fbmy5635_rel_202304122154.cy9c_gcp_c2s30
86.510	13.481	0.009	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.036	fbmy5635_rel_202305292102.cy9c_gcp_c2s30
84.944	15.049	0.007	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.045	fbmy5635_rel_20230529_832.cy9c_gcp_c2s30
81.559	18.434	0.007	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.045	fbmy5635_rel_20230529_843.cy9c_gcp_c2s30
81.138	18.854	0.008	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.046	fbmy5635_rel_20230529_850.cy9c_gcp_c2s30

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	21.411	78.530	0.057	0.002	0.000	0.000	0.000	0.000	0.000	0.025	fbmy5635_rel_202104072149.cy9c_gcp_c2s30
0.000	9.287	90.661	0.051	0.001	0.000	0.000	0.000	0.000	0.000	0.031	fbmy5635_rel_202203072101.cy9c_gcp_c2s30
0.000	4.911	95.049	0.039	0.001	0.000	0.000	0.000	0.000	0.000	0.032	fbmy5635_rel_202205192101.cy9c_gcp_c2s30
0.000	5.703	94.259	0.037	0.001	0.000	0.000	0.000	0.000	0.000	0.033	fbmy5635_rel_202208092101.cy9c_gcp_c2s30
0.000	2.812	97.139	0.048	0.001	0.000	0.000	0.000	0.000	0.000	0.022	fbmy5635_rel_202210112144.cy9c_gcp_c2s30
0.000	8.751	90.006	1.239	0.003	0.000	0.000	0.000	0.000	0.000	0.018	fbmy5635_rel_202302162102.cy9c_gcp_c2s30
0.000	9.434	90.264	0.299	0.003	0.000	0.000	0.000	0.000	0.000	0.034	fbmy5635_rel_202304122154.cy9c_gcp_c2s30
0.000	7.400	91.574	1.020	0.007	0.000	0.000	0.000	0.000	0.000	0.032	fbmy5635_rel_202305292102.cy9c_gcp_c2s30
0.000	10.544	89.418	0.038	0.001	0.000	0.000	0.000	0.000	0.000	0.042	fbmy5635_rel_20230529_832.cy9c_gcp_c2s30
0.000	8.426	91.517	0.055	0.002	0.000	0.000	0.000	0.000	0.000	0.038	fbmy5635_rel_20230529_843.cy9c_gcp_c2s30
0.000	6.805	93.058	0.133	0.003	0.000	0.000	0.000	0.000	0.000	0.044	fbmy5635_rel_20230529_850.cy9c_gcp_c2s30

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	20.718	79.182	0.091	0.009	0.000	0.000	0.000	0.000	0.000	0.044	fbmy5635_rel_202104072149.cy9c_gcp_c2s30
0.000	10.392	89.513	0.089	0.006	0.000	0.000	0.000	0.000	0.000	0.039	fbmy5635_rel_202203072101.cy9c_gcp_c2s30
0.000	7.340	92.594	0.061	0.005	0.000	0.000	0.000	0.000	0.000	0.042	fbmy5635_rel_202205192101.cy9c_gcp_c2s30
0.000	7.619	92.282	0.095	0.004	0.000	0.000	0.000	0.000	0.000	0.044	fbmy5635_rel_202208092101.cy9c_gcp_c2s30
0.000	4.526	95.370	0.099	0.005	0.000	0.000	0.000	0.000	0.000	0.040	fbmy5635_rel_202210112144.cy9c_gcp_c2s30
0.000	13.124	85.694	1.175	0.008	0.000	0.000	0.000	0.000	0.000	0.034	fbmy5635_rel_202302162102.cy9c_gcp_c2s30
0.000	14.164	85.518	0.311	0.007	0.000	0.000	0.000	0.000	0.000	0.035	fbmy5635_rel_202304122154.cy9c_gcp_c2s30
0.000	10.409	88.605	0.977	0.009	0.000	0.000	0.000	0.000	0.000	0.036	fbmy5635_rel_202305292102.cy9c_gcp_c2s30
0.000	15.695	84.186	0.112	0.007	0.000	0.000	0.000	0.000	0.000	0.042	fbmy5635_rel_20230529_832.cy9c_gcp_c2s30
0.000	11.269	88.600	0.124	0.007	0.000	0.000	0.000	0.000	0.000	0.045	fbmy5635_rel_20230529_843.cy9c_gcp_c2s30
0.000	10.125	89.679	0.189	0.007	0.000	0.000	0.000	0.000	0.000	0.045	fbmy5635_rel_20230529_850.cy9c_gcp_c2s30