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, Ubuntu 22.04 and XFS using SW RAID 0 over 4 local SSDs. The benchmark was run with 8 clients and there were 1, 2 or 3 connections per client. It uses 8 tables with a client per table. It loads 20M rows per table without secondary indexes, creates 3 secondary indexes per table, then inserts 50m+50m rows per table with a delete per insert to avoid growing the table. It then does 6 read+write tests for 1200s each that do queries as fast as possible with 100,100,500,500,1000,1000 inserts/s and the same for deletes/s per client concurrent with the queries. The database is cached in memory. Clients and the DBMS share one server. The per-database configs are in the per-database subdirectories here.

The tested DBMS are:

fbmy5635_rel_202104072149.cza1_gcp_c2s30 - MyRocks 5.6.35 compiled from code as of 2021-04-07 at git hash f896415f with RocksDB 6.19.0, cza1_gcp_c2s30 config
fbmy5635_rel_202203072101.cza1_gcp_c2s30 - MyRocks 5.6.35 compiled from code as of 2022-03-07 at git hash e7d976ee with RocksDB 6.28.2, cza1_gcp_c2s30 config
fbmy5635_rel_202205192101.cza1_gcp_c2s30 - MyRocks 5.6.35 compiled from code as of 2022-05-19 at git hash d503bd77 with RocksDB 7.2.2, cza1_gcp_c2s30 config
fbmy5635_rel_202208092101.cza1_gcp_c2s30 - MyRocks 5.6.35 compiled from code as of 2022-08-09 at git hash 877a0e58 with RocksDB 7.3.1, cza1_gcp_c2s30 config
fbmy5635_rel_202210112144.cza1_gcp_c2s30 - MyRocks 5.6.35 compiled from code as of 2022-10-11 at git hash c691c716 with RocksDB 7.3.1, cza1_gcp_c2s30 config
fbmy5635_rel_202302162102.cza1_gcp_c2s30 - MyRocks 5.6.35 compiled from code as of 2023-02-16 at git hash 21a2b0aa with RocksDB 7.10.0, cza1_gcp_c2s30 config
fbmy5635_rel_202304122154.cza1_gcp_c2s30 - MyRocks 5.6.35 compiled from code as of 2023-04-12 at git hash 205c31dd with RocksDB 7.10.2, cza1_gcp_c2s30 config
fbmy5635_rel_202305292102.cza1_gcp_c2s30 - MyRocks 5.6.35 compiled from code as of 2023-05-29 at git hash b739eac1 with RocksDB 8.2.1, cza1_gcp_c2s30 config
fbmy5635_rel_20230529_832.cza1_gcp_c2s30 - MyRocks 5.6.35 compiled from code as of 2023-05-29 at git hash b739eac1 with RocksDB 8.3.2, cza1_gcp_c2s30 config
fbmy5635_rel_20230529_843.cza1_gcp_c2s30 - MyRocks 5.6.35 compiled from code as of 2023-05-29 at git hash b739eac1 with RocksDB 8.4.3, cza1_gcp_c2s30 config
fbmy5635_rel_20230529_850.cza1_gcp_c2s30 - MyRocks 5.6.35 compiled from code as of 2023-05-29 at git hash b739eac1 with RocksDB 8.5.0, cza1_gcp_c2s30 config
fbmy5635_rel_221222.cza1_gcp_c2s30 - MyRocks 5.6.35 compiled on Dec 22, 2023 at git hash 4f3a57a1, RocksDB 8.7.0 at git hash 29005f0b, cza1_gcp_c2s30 config

Summary
l.i0: load without secondary indexes
l.x: create secondary indexes
l.i1: continue load after secondary indexes created with 50 inserts per transaction
l.i2: continue load after secondary indexes created with 5 inserts per transaction
qr100.L1: range queries with 100 insert/s per client
qp100.L2: point queries with 100 insert/s per client
qr500.L3: range queries with 500 insert/s per client
qp500.L4: point queries with 500 insert/s per client
qr1000.L5: range queries with 1000 insert/s per client
qp1000.L6: point queries with 1000 insert/s per client

Summary

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

dbms	l.i0	l.x	l.i1	l.i2	qr100	qp100	qr500	qp500	qr1000	qp1000
fbmy5635_rel_202104072149.cza1_gcp_c2s30	613027	824743	92727	40984	26131	31821	22371	28655	22958	27352
fbmy5635_rel_202203072101.cza1_gcp_c2s30	610687	833334	90729	40630	27589	31119	22833	28150	21545	26903
fbmy5635_rel_202205192101.cza1_gcp_c2s30	592592	833334	89736	40120	25012	30841	21651	28269	21353	26799
fbmy5635_rel_202208092101.cza1_gcp_c2s30	599251	837697	89236	39742	28022	30969	23124	28013	22083	26884
fbmy5635_rel_202210112144.cza1_gcp_c2s30	592592	829016	89360	40241	24682	30692	21024	28021	21472	26578
fbmy5635_rel_202302162102.cza1_gcp_c2s30	634921	808081	90909	42105	26615	32294	23746	30703	21957	28549
fbmy5635_rel_202304122154.cza1_gcp_c2s30	622568	804021	89963	41237	22538	31568	23515	30058	21351	27974
fbmy5635_rel_202305292102.cza1_gcp_c2s30	625000	812183	90090	41089	25205	31438	22802	29792	20747	27848
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	620155	800000	90319	41131	25656	31680	22364	29966	21072	27990
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	617761	804021	89812	40984	23029	31014	22616	29429	21702	27535
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	627451	804021	90293	41322	21616	31151	19782	29704	21741	27677
fbmy5635_rel_221222.cza1_gcp_c2s30	622568	800000	90370	41216	23293	31148	22313	29668	20198	27849

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.

dbms	l.i0	l.x	l.i1	l.i2	qr100	qp100	qr500	qp500	qr1000	qp1000
fbmy5635_rel_202104072149.cza1_gcp_c2s30	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00
fbmy5635_rel_202203072101.cza1_gcp_c2s30	1.00	1.01	0.98	0.99	1.06	0.98	1.02	0.98	0.94	0.98
fbmy5635_rel_202205192101.cza1_gcp_c2s30	0.97	1.01	0.97	0.98	0.96	0.97	0.97	0.99	0.93	0.98
fbmy5635_rel_202208092101.cza1_gcp_c2s30	0.98	1.02	0.96	0.97	1.07	0.97	1.03	0.98	0.96	0.98
fbmy5635_rel_202210112144.cza1_gcp_c2s30	0.97	1.01	0.96	0.98	0.94	0.96	0.94	0.98	0.94	0.97
fbmy5635_rel_202302162102.cza1_gcp_c2s30	1.04	0.98	0.98	1.03	1.02	1.01	1.06	1.07	0.96	1.04
fbmy5635_rel_202304122154.cza1_gcp_c2s30	1.02	0.97	0.97	1.01	0.86	0.99	1.05	1.05	0.93	1.02
fbmy5635_rel_202305292102.cza1_gcp_c2s30	1.02	0.98	0.97	1.00	0.96	0.99	1.02	1.04	0.90	1.02
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	1.01	0.97	0.97	1.00	0.98	1.00	1.00	1.05	0.92	1.02
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	1.01	0.97	0.97	1.00	0.88	0.97	1.01	1.03	0.95	1.01
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	1.02	0.97	0.97	1.01	0.83	0.98	0.88	1.04	0.95	1.01
fbmy5635_rel_221222.cza1_gcp_c2s30	1.02	0.97	0.97	1.01	0.89	0.98	1.00	1.04	0.88	1.02

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.

dbms	qr100.L1	qp100.L2	qr500.L3	qp500.L4	qr1000.L5	qp1000.L6
fbmy5635_rel_202104072149.cza1_gcp_c2s30	794	793	3967	3970	7947	7947
fbmy5635_rel_202203072101.cza1_gcp_c2s30	794	794	3970	3967	7940	7940
fbmy5635_rel_202205192101.cza1_gcp_c2s30	794	793	3970	3970	7947	7947
fbmy5635_rel_202208092101.cza1_gcp_c2s30	794	793	3967	3970	7947	7940
fbmy5635_rel_202210112144.cza1_gcp_c2s30	794	793	3970	3970	7947	7947
fbmy5635_rel_202302162102.cza1_gcp_c2s30	794	794	3970	3967	7940	7940
fbmy5635_rel_202304122154.cza1_gcp_c2s30	794	794	3970	3970	7940	7940
fbmy5635_rel_202305292102.cza1_gcp_c2s30	793	794	3970	3970	7947	7947
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	793	794	3970	3970	7947	7947
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	794	794	3970	3967	7940	7947
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	794	794	3967	3967	7947	7947
fbmy5635_rel_221222.cza1_gcp_c2s30	794	793	3970	3970	7947	7947
target	800	800	4000	4000	8000	8000

l.i0

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

Average throughput:

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.

dbms	1ms	4ms	16ms	64ms	256ms	1s	max
fbmy5635_rel_202104072149.cza1_gcp_c2s30	28.113	71.859	0.013	0.002	0.010	0.003	0.335
fbmy5635_rel_202203072101.cza1_gcp_c2s30	24.871	75.101	0.013	0.001	0.009	0.004	0.355
fbmy5635_rel_202205192101.cza1_gcp_c2s30	18.807	81.161	0.016	0.002	0.008	0.006	0.383
fbmy5635_rel_202208092101.cza1_gcp_c2s30	21.732	78.236	0.015	0.002	0.009	0.005	0.391
fbmy5635_rel_202210112144.cza1_gcp_c2s30	18.633	81.332	0.019	0.001	0.011	0.003	0.344
fbmy5635_rel_202302162102.cza1_gcp_c2s30	44.735	55.237	0.013	0.001	0.009	0.005	0.324
fbmy5635_rel_202304122154.cza1_gcp_c2s30	40.788	59.180	0.017	0.001	0.009	0.004	0.397
fbmy5635_rel_202305292102.cza1_gcp_c2s30	33.378	66.593	0.014	0.001	0.010	0.004	0.294
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	38.958	61.014	0.014	0.001	0.009	0.005	0.357
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	32.557	67.412	0.017	nonzero	0.007	0.006	0.343
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	34.954	65.007	0.022	0.003	0.012	0.002	0.310
fbmy5635_rel_221222.cza1_gcp_c2s30	37.038	62.935	0.012	0.001	0.008	0.006	0.391

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
613027	0	0	0.0	625.7	174.0	0.000	0.000	0.001	0.291	72221	73.7	0.118	18	4.9	6.5	1.4	0.335	83310	51063	fbmy5635_rel_202104072149.cza1_gcp_c2s30
610687	0	0	0.0	617.1	178.0	0.000	0.000	0.001	0.298	73282	74.1	0.120	18	5.0	6.5	1.4	0.355	80808	52259	fbmy5635_rel_202203072101.cza1_gcp_c2s30
592592	0	0	0.0	596.9	170.1	0.000	0.000	0.001	0.294	72057	74.0	0.122	19	5.0	6.5	1.5	0.383	79813	51943	fbmy5635_rel_202205192101.cza1_gcp_c2s30
599251	0	0	0.0	604.7	172.6	0.000	0.000	0.001	0.295	72185	73.5	0.120	18	4.8	6.3	1.6	0.391	80213	49845	fbmy5635_rel_202208092101.cza1_gcp_c2s30
592592	0	0	0.0	612.2	176.3	0.000	0.000	0.001	0.305	71035	73.5	0.120	19	4.9	6.4	1.6	0.344	80113	52561	fbmy5635_rel_202210112144.cza1_gcp_c2s30
634921	0	0	0.0	521.1	144.6	0.000	0.000	0.001	0.233	72640	72.8	0.114	17	4.7	6.1	1.2	0.324	85707	49962	fbmy5635_rel_202302162102.cza1_gcp_c2s30
622568	0	0	0.0	524.1	145.7	0.000	0.000	0.001	0.240	71744	72.2	0.115	17	4.7	6.2	1.3	0.397	86000	50644	fbmy5635_rel_202304122154.cza1_gcp_c2s30
625000	0	0	0.0	517.5	143.5	0.000	0.000	0.001	0.235	71507	73.1	0.114	18	4.7	6.1	1.2	0.294	84136	59036	fbmy5635_rel_202305292102.cza1_gcp_c2s30
620155	0	0	0.0	516.1	142.4	0.000	0.000	0.001	0.235	71452	72.4	0.115	18	4.7	6.2	1.3	0.357	84740	56838	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
617761	0	0	0.0	515.4	141.4	0.000	0.000	0.001	0.234	70909	73.4	0.115	18	4.7	6.1	1.2	0.343	84608	50545	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
627451	0	0	0.0	522.2	144.2	0.000	0.000	0.001	0.235	71602	73.0	0.114	17	4.6	6.1	1.2	0.310	83342	52243	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
622568	0	0	0.0	519.1	142.7	0.000	0.000	0.001	0.235	71944	72.4	0.116	17	4.7	6.2	1.3	0.391	85036	55140	fbmy5635_rel_221222.cza1_gcp_c2s30

l.x

l.x: create secondary indexes.

Average throughput:

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
824743	0	1	0.1	339.1	121.2	0.000	0.000	0.000	0.151	1294	51.0	0.002	9	10.5	12.1	13.7	0.002	NA	NA	fbmy5635_rel_202104072149.cza1_gcp_c2s30
833334	0	1	0.1	340.1	118.1	0.000	0.000	0.000	0.145	1208	50.0	0.001	9	10.5	12.0	13.0	0.002	NA	NA	fbmy5635_rel_202203072101.cza1_gcp_c2s30
833334	0	1	0.1	338.2	118.1	0.000	0.000	0.000	0.145	1208	50.1	0.001	9	10.5	12.0	13.3	0.002	NA	NA	fbmy5635_rel_202205192101.cza1_gcp_c2s30
837697	0	1	0.1	343.0	119.0	0.000	0.000	0.000	0.145	1162	50.3	0.001	9	10.5	12.0	12.7	0.002	NA	NA	fbmy5635_rel_202208092101.cza1_gcp_c2s30
829016	0	1	0.1	348.4	119.4	0.000	0.000	0.000	0.148	1301	50.5	0.002	9	10.5	12.0	13.5	0.002	NA	NA	fbmy5635_rel_202210112144.cza1_gcp_c2s30
808081	0	1	0.1	308.9	110.7	0.000	0.000	0.000	0.140	1064	49.9	0.001	9	10.5	12.0	11.0	0.002	NA	NA	fbmy5635_rel_202302162102.cza1_gcp_c2s30
804021	0	1	0.1	309.6	108.3	0.000	0.000	0.000	0.138	1095	50.0	0.001	9	10.5	12.0	11.0	0.002	NA	NA	fbmy5635_rel_202304122154.cza1_gcp_c2s30
812183	0	1	0.1	311.1	109.9	0.000	0.000	0.000	0.139	1141	49.8	0.001	9	10.5	12.0	11.1	0.002	NA	NA	fbmy5635_rel_202305292102.cza1_gcp_c2s30
800000	0	1	0.1	303.1	107.5	0.000	0.000	0.000	0.138	1064	49.4	0.001	9	10.5	12.0	11.0	0.002	NA	NA	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
804021	0	1	0.1	307.1	109.3	0.000	0.000	0.000	0.139	1022	50.0	0.001	9	10.5	12.0	11.0	0.002	NA	NA	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
804021	0	1	0.1	310.1	108.6	0.000	0.000	0.000	0.138	1116	50.1	0.001	9	10.4	11.9	11.0	0.002	NA	NA	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
800000	0	1	0.1	304.2	108.2	0.000	0.000	0.000	0.139	1341	49.2	0.002	9	10.5	12.0	11.0	0.002	NA	NA	fbmy5635_rel_221222.cza1_gcp_c2s30

l.i1

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

Average throughput:

dbms	1ms	4ms	16ms	64ms	256ms	1s	max
fbmy5635_rel_202104072149.cza1_gcp_c2s30	0.047	42.354	57.478	0.105	0.008	0.007	0.469
fbmy5635_rel_202203072101.cza1_gcp_c2s30	0.036	36.017	63.826	0.106	0.008	0.008	0.451
fbmy5635_rel_202205192101.cza1_gcp_c2s30	0.037	34.076	65.761	0.111	0.010	0.006	0.449
fbmy5635_rel_202208092101.cza1_gcp_c2s30	0.065	33.569	66.238	0.113	0.009	0.006	0.417
fbmy5635_rel_202210112144.cza1_gcp_c2s30	0.026	33.444	66.404	0.112	0.008	0.007	0.483
fbmy5635_rel_202302162102.cza1_gcp_c2s30	0.034	38.058	61.786	0.107	0.009	0.006	0.386
fbmy5635_rel_202304122154.cza1_gcp_c2s30	0.032	35.547	64.294	0.112	0.011	0.004	0.458
fbmy5635_rel_202305292102.cza1_gcp_c2s30	0.050	35.604	64.223	0.108	0.012	0.004	0.392
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	0.050	37.398	62.432	0.106	0.010	0.005	0.403
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	0.030	36.589	63.258	0.108	0.009	0.007	0.397
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	0.041	36.833	63.006	0.105	0.009	0.006	0.440
fbmy5635_rel_221222.cza1_gcp_c2s30	0.044	36.867	62.973	0.100	0.010	0.006	0.443

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.

dbms	1ms	4ms	16ms	64ms	256ms	1s	max
fbmy5635_rel_202104072149.cza1_gcp_c2s30	0.044	39.825	60.006	0.109	0.008	0.008	0.469
fbmy5635_rel_202203072101.cza1_gcp_c2s30	0.038	37.439	62.402	0.106	0.008	0.008	0.453
fbmy5635_rel_202205192101.cza1_gcp_c2s30	0.037	35.568	64.270	0.110	0.009	0.006	0.450
fbmy5635_rel_202208092101.cza1_gcp_c2s30	0.063	34.199	65.609	0.113	0.009	0.006	0.418
fbmy5635_rel_202210112144.cza1_gcp_c2s30	0.026	35.087	64.762	0.110	0.008	0.007	0.484
fbmy5635_rel_202302162102.cza1_gcp_c2s30	0.033	38.531	61.314	0.107	0.009	0.006	0.386
fbmy5635_rel_202304122154.cza1_gcp_c2s30	0.033	37.505	62.336	0.111	0.011	0.004	0.457
fbmy5635_rel_202305292102.cza1_gcp_c2s30	0.052	38.221	61.603	0.109	0.011	0.004	0.395
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	0.052	37.086	62.738	0.108	0.010	0.005	0.404
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	0.029	36.581	63.266	0.108	0.009	0.007	0.395
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	0.042	38.138	61.699	0.106	0.009	0.006	0.441
fbmy5635_rel_221222.cza1_gcp_c2s30	0.044	37.774	62.068	0.099	0.010	0.005	0.445

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
92727	0	4	1.6	709.9	203.3	0.000	0.018	0.008	2.245	65523	61.0	0.707	99	17.5	18.1	55.3	0.469	11737	8341	fbmy5635_rel_202104072149.cza1_gcp_c2s30
90729	0	4	1.6	689.7	207.4	0.000	0.018	0.008	2.341	65295	60.0	0.720	99	18.1	18.5	54.2	0.451	11487	8042	fbmy5635_rel_202203072101.cza1_gcp_c2s30
89736	0	4	1.6	678.8	203.1	0.000	0.018	0.008	2.318	63679	60.6	0.710	101	16.3	16.6	54.5	0.449	11338	8091	fbmy5635_rel_202205192101.cza1_gcp_c2s30
89236	0	4	1.6	675.4	201.0	0.000	0.018	0.008	2.306	63194	60.0	0.708	101	16.4	16.9	53.7	0.417	11288	8291	fbmy5635_rel_202208092101.cza1_gcp_c2s30
89360	0	4	1.6	681.0	202.9	0.000	0.018	0.008	2.326	63199	60.3	0.707	101	15.6	16.0	54.5	0.483	11288	8045	fbmy5635_rel_202210112144.cza1_gcp_c2s30
90909	0	4	1.6	553.5	162.3	0.000	0.018	0.006	1.828	60947	59.0	0.670	97	16.5	16.9	50.0	0.386	11641	8394	fbmy5635_rel_202302162102.cza1_gcp_c2s30
89963	0	4	1.6	557.5	163.4	0.000	0.018	0.006	1.860	60608	59.3	0.674	99	13.6	14.0	50.2	0.458	11488	8591	fbmy5635_rel_202304122154.cza1_gcp_c2s30
90090	0	4	1.6	545.7	159.0	0.000	0.018	0.006	1.807	60047	59.7	0.667	99	12.0	12.5	50.0	0.392	11492	8391	fbmy5635_rel_202305292102.cza1_gcp_c2s30
90319	0	4	1.6	551.4	161.5	0.000	0.018	0.006	1.831	60227	60.2	0.667	100	12.3	12.6	50.0	0.403	11537	8144	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
89812	0	4	1.6	544.2	159.9	0.000	0.018	0.006	1.824	59322	61.2	0.661	102	16.9	17.3	49.7	0.397	11438	8294	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
90293	0	359	1.6	564.6	163.8	0.004	0.018	0.006	1.857	60461	60.5	0.670	101	12.2	12.6	50.3	0.440	11537	8340	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
90370	0	4	0.4	553.0	161.6	0.000	0.004	0.006	1.831	60246	59.6	0.667	99	12.2	12.6	50.3	0.443	11587	8444	fbmy5635_rel_221222.cza1_gcp_c2s30

l.i2

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

Average throughput:

dbms	256us	1ms	4ms	16ms	64ms	256ms	max
fbmy5635_rel_202104072149.cza1_gcp_c2s30	0.147	83.393	16.393	0.061	0.006	nonzero	0.109
fbmy5635_rel_202203072101.cza1_gcp_c2s30	0.094	82.143	17.694	0.064	0.006	nonzero	0.209
fbmy5635_rel_202205192101.cza1_gcp_c2s30	0.165	80.633	19.134	0.063	0.005	nonzero	0.218
fbmy5635_rel_202208092101.cza1_gcp_c2s30	0.147	79.376	20.405	0.066	0.007	nonzero	0.150
fbmy5635_rel_202210112144.cza1_gcp_c2s30	0.106	81.188	18.636	0.064	0.006	nonzero	0.121
fbmy5635_rel_202302162102.cza1_gcp_c2s30	0.099	86.464	13.396	0.036	0.005	nonzero	0.079
fbmy5635_rel_202304122154.cza1_gcp_c2s30	0.175	84.180	15.604	0.035	0.005	nonzero	0.083
fbmy5635_rel_202305292102.cza1_gcp_c2s30	0.138	83.893	15.927	0.036	0.006	nonzero	0.067
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	0.148	83.644	16.166	0.037	0.005	nonzero	0.097
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	0.091	83.385	16.483	0.037	0.004	nonzero	0.152
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	0.147	84.839	14.975	0.034	0.005		0.056
fbmy5635_rel_221222.cza1_gcp_c2s30	0.068	84.539	15.354	0.035	0.005		0.050

dbms	256us	1ms	4ms	16ms	64ms	256ms	max
fbmy5635_rel_202104072149.cza1_gcp_c2s30	nonzero	67.273	32.654	0.067	0.006	nonzero	0.114
fbmy5635_rel_202203072101.cza1_gcp_c2s30		64.386	35.537	0.070	0.007	nonzero	0.209
fbmy5635_rel_202205192101.cza1_gcp_c2s30		61.824	38.103	0.068	0.005	nonzero	0.218
fbmy5635_rel_202208092101.cza1_gcp_c2s30		60.059	39.862	0.072	0.007	nonzero	0.150
fbmy5635_rel_202210112144.cza1_gcp_c2s30	nonzero	62.645	37.278	0.070	0.006	nonzero	0.121
fbmy5635_rel_202302162102.cza1_gcp_c2s30	0.005	69.429	30.521	0.040	0.005	nonzero	0.079
fbmy5635_rel_202304122154.cza1_gcp_c2s30	nonzero	65.762	34.194	0.039	0.006	nonzero	0.083
fbmy5635_rel_202305292102.cza1_gcp_c2s30	nonzero	65.458	34.495	0.040	0.007	nonzero	0.067
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	0.004	65.333	34.617	0.041	0.006	nonzero	0.096
fbmy5635_rel_20230529_843.cza1_gcp_c2s30		64.983	34.971	0.041	0.005	nonzero	0.152
fbmy5635_rel_20230529_850.cza1_gcp_c2s30		66.585	33.371	0.038	0.005		0.056
fbmy5635_rel_221222.cza1_gcp_c2s30	0.002	65.324	34.630	0.038	0.006		0.050

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
40984	0	0	0.0	462.7	107.9	0.000	0.000	0.011	2.697	234921	67.8	5.732	248	12.3	12.3	66.8	0.109	5329	3502	fbmy5635_rel_202104072149.cza1_gcp_c2s30
40630	0	0	0.0	447.4	103.5	0.000	0.000	0.011	2.609	235776	67.2	5.803	248	12.2	12.3	65.7	0.209	5229	3466	fbmy5635_rel_202203072101.cza1_gcp_c2s30
40120	0	0	0.0	436.9	101.5	0.000	0.000	0.011	2.592	233501	67.2	5.820	251	15.2	15.3	66.3	0.218	5174	3411	fbmy5635_rel_202205192101.cza1_gcp_c2s30
39742	0	0	0.0	445.6	104.4	0.000	0.000	0.011	2.691	230827	67.1	5.808	253	12.3	12.3	65.5	0.150	5139	3406	fbmy5635_rel_202208092101.cza1_gcp_c2s30
40241	0	0	0.0	441.8	102.8	0.000	0.000	0.011	2.616	234843	67.3	5.836	251	14.5	14.5	66.0	0.121	5209	3433	fbmy5635_rel_202210112144.cza1_gcp_c2s30
42105	0	0	0.0	316.3	69.3	0.000	0.000	0.008	1.685	251643	64.3	5.977	229	11.9	11.9	61.4	0.079	5409	3336	fbmy5635_rel_202302162102.cza1_gcp_c2s30
41237	0	0	0.0	305.5	67.4	0.000	0.000	0.007	1.673	248498	64.2	6.026	234	12.2	12.3	61.6	0.083	5349	3217	fbmy5635_rel_202304122154.cza1_gcp_c2s30
41089	0	0	0.0	306.3	67.7	0.000	0.000	0.007	1.687	246725	64.6	6.005	236	11.8	11.9	61.2	0.067	5329	3236	fbmy5635_rel_202305292102.cza1_gcp_c2s30
41131	0	0	0.0	308.3	67.4	0.000	0.000	0.007	1.678	246003	64.7	5.981	236	12.2	12.3	61.1	0.097	5344	3241	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
40984	0	0	0.0	308.2	66.0	0.000	0.000	0.008	1.650	243926	65.3	5.952	239	14.1	14.1	61.4	0.152	5314	3177	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
41322	0	0	0.0	308.9	67.4	0.000	0.000	0.007	1.671	248486	64.5	6.013	234	12.0	12.1	61.5	0.056	5339	3181	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
41216	0	0	0.0	302.9	66.7	0.000	0.000	0.007	1.657	249372	64.3	6.050	234	11.8	11.9	61.3	0.050	5281	3218	fbmy5635_rel_221222.cza1_gcp_c2s30

qr100.L1

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

Average throughput:

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.

dbms	256us	1ms	4ms	16ms	64ms	256ms	max
fbmy5635_rel_202104072149.cza1_gcp_c2s30	71.473	26.946	1.581	nonzero	nonzero	nonzero	0.131
fbmy5635_rel_202203072101.cza1_gcp_c2s30	71.966	27.774	0.260	nonzero	nonzero	nonzero	0.130
fbmy5635_rel_202205192101.cza1_gcp_c2s30	69.422	29.224	1.353	nonzero	nonzero	nonzero	0.133
fbmy5635_rel_202208092101.cza1_gcp_c2s30	74.587	23.168	2.245	nonzero	nonzero	nonzero	0.134
fbmy5635_rel_202210112144.cza1_gcp_c2s30	66.995	31.032	1.973	nonzero	nonzero	nonzero	0.131
fbmy5635_rel_202302162102.cza1_gcp_c2s30	70.127	29.050	0.823	nonzero	nonzero		0.055
fbmy5635_rel_202304122154.cza1_gcp_c2s30	65.763	29.923	4.313	nonzero	nonzero		0.047
fbmy5635_rel_202305292102.cza1_gcp_c2s30	68.062	27.824	4.114	nonzero	nonzero		0.055
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	74.301	24.676	1.023	nonzero	nonzero		0.050
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	65.731	30.039	4.230	nonzero	nonzero		0.052
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	66.752	30.003	3.245	nonzero	nonzero		0.047
fbmy5635_rel_221222.cza1_gcp_c2s30	66.840	29.441	3.719	nonzero	nonzero		0.055

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.

dbms	1ms	4ms	16ms	64ms	max
fbmy5635_rel_202104072149.cza1_gcp_c2s30	5.359	90.380	4.260		0.013
fbmy5635_rel_202203072101.cza1_gcp_c2s30	3.109	88.130	8.755	0.005	0.018
fbmy5635_rel_202205192101.cza1_gcp_c2s30	2.469	91.661	5.854	0.016	0.017
fbmy5635_rel_202208092101.cza1_gcp_c2s30	2.625	91.901	5.469	0.005	0.017
fbmy5635_rel_202210112144.cza1_gcp_c2s30	1.724	84.203	14.073		0.013
fbmy5635_rel_202302162102.cza1_gcp_c2s30	5.656	93.953	0.391		0.013
fbmy5635_rel_202304122154.cza1_gcp_c2s30	4.432	93.120	2.448		0.010
fbmy5635_rel_202305292102.cza1_gcp_c2s30	1.427	83.870	14.703		0.013
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	1.656	89.500	8.844		0.013
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	3.833	92.427	3.724	0.016	0.018
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	5.135	94.474	0.391		0.006
fbmy5635_rel_221222.cza1_gcp_c2s30	2.474	93.229	4.276	0.021	0.042

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.

dbms	1ms	4ms	16ms	64ms	max
fbmy5635_rel_202104072149.cza1_gcp_c2s30	5.104	90.417	4.479		0.009
fbmy5635_rel_202203072101.cza1_gcp_c2s30	4.427	86.969	8.604		0.009
fbmy5635_rel_202205192101.cza1_gcp_c2s30	4.052	90.604	5.323	0.021	0.022
fbmy5635_rel_202208092101.cza1_gcp_c2s30	4.089	90.443	5.469		0.007
fbmy5635_rel_202210112144.cza1_gcp_c2s30	2.536	83.672	13.792		0.013
fbmy5635_rel_202302162102.cza1_gcp_c2s30	5.870	93.693	0.438		0.006
fbmy5635_rel_202304122154.cza1_gcp_c2s30	4.953	92.521	2.526		0.008
fbmy5635_rel_202305292102.cza1_gcp_c2s30	2.901	82.271	14.828		0.013
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	2.172	88.562	9.255	0.010	0.016
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	4.240	91.724	4.026	0.010	0.017
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	6.417	93.167	0.417		0.006
fbmy5635_rel_221222.cza1_gcp_c2s30	2.708	93.016	4.255	0.021	0.042

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
794	26131	0	0.0	38.2	10.6	0.000	0.000	0.048	13.724	101979	53.6	3.903	308	12.6	12.8	68.2	0.131	2845	2637	fbmy5635_rel_202104072149.cza1_gcp_c2s30
794	27589	0	0.0	33.2	8.6	0.000	0.000	0.042	11.052	107703	53.5	3.904	291	12.4	12.6	67.0	0.130	3564	3292	fbmy5635_rel_202203072101.cza1_gcp_c2s30
794	25012	0	0.0	32.9	7.9	0.000	0.000	0.041	10.219	97576	53.3	3.901	320	12.4	12.6	67.5	0.133	3276	3021	fbmy5635_rel_202205192101.cza1_gcp_c2s30
794	28022	0	0.0	35.4	8.4	0.000	0.000	0.045	10.800	109246	53.6	3.899	287	12.1	12.3	66.6	0.134	4573	4219	fbmy5635_rel_202208092101.cza1_gcp_c2s30
794	24682	0	0.0	35.9	8.7	0.000	0.000	0.045	11.165	96436	53.3	3.907	324	11.7	11.9	67.4	0.131	3228	3020	fbmy5635_rel_202210112144.cza1_gcp_c2s30
794	26615	0	0.0	15.2	3.1	0.000	0.000	0.019	3.935	103355	52.9	3.883	298	11.4	11.6	62.8	0.055	2813	2573	fbmy5635_rel_202302162102.cza1_gcp_c2s30
794	22538	0	0.0	14.3	3.0	0.000	0.000	0.018	3.898	87596	52.7	3.887	351	11.5	11.7	63.0	0.047	3484	3228	fbmy5635_rel_202304122154.cza1_gcp_c2s30
793	25205	0	0.0	13.4	2.5	0.000	0.000	0.017	3.282	97913	52.7	3.885	314	11.4	11.7	62.7	0.055	3933	3614	fbmy5635_rel_202305292102.cza1_gcp_c2s30
793	25656	0	0.0	12.6	2.6	0.000	0.000	0.016	3.393	99699	52.7	3.886	308	11.4	11.6	62.4	0.050	3388	3117	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
794	23029	0	0.0	13.2	2.6	0.000	0.000	0.017	3.340	89484	52.7	3.886	343	11.4	11.6	62.7	0.052	2718	2493	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
794	21616	0	0.0	13.3	2.8	0.000	0.000	0.017	3.579	84043	52.5	3.888	364	11.4	11.6	62.9	0.047	2493	2285	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
794	23293	0	0.0	14.0	3.0	0.000	0.000	0.018	3.888	90555	52.8	3.888	340	11.4	11.6	62.7	0.055	3101	2814	fbmy5635_rel_221222.cza1_gcp_c2s30

qp100.L2

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

Average throughput:

dbms	256us	1ms	4ms	16ms	64ms	max
fbmy5635_rel_202104072149.cza1_gcp_c2s30	86.289	13.710	0.001	nonzero	nonzero	0.018
fbmy5635_rel_202203072101.cza1_gcp_c2s30	79.954	20.045	0.001	0.001	nonzero	0.018
fbmy5635_rel_202205192101.cza1_gcp_c2s30	77.391	22.608	0.001	nonzero	nonzero	0.019
fbmy5635_rel_202208092101.cza1_gcp_c2s30	78.789	21.210	0.001	0.001	nonzero	0.019
fbmy5635_rel_202210112144.cza1_gcp_c2s30	75.621	24.377	0.001	nonzero	nonzero	0.019
fbmy5635_rel_202302162102.cza1_gcp_c2s30	88.929	11.069	0.001	0.001	nonzero	0.030
fbmy5635_rel_202304122154.cza1_gcp_c2s30	85.176	14.822	0.001	0.001	nonzero	0.019
fbmy5635_rel_202305292102.cza1_gcp_c2s30	83.474	16.524	0.001	0.001	nonzero	0.024
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	85.499	14.499	0.001	nonzero	0.001	0.035
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	79.256	20.742	0.001	nonzero	0.001	0.020
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	81.142	18.856	0.001	nonzero	0.001	0.032
fbmy5635_rel_221222.cza1_gcp_c2s30	81.240	18.758	0.001	nonzero	0.001	0.033

dbms	1ms	4ms	16ms	64ms	max
fbmy5635_rel_202104072149.cza1_gcp_c2s30	2.292	82.479	15.224	0.005	0.017
fbmy5635_rel_202203072101.cza1_gcp_c2s30	3.375	96.151	0.458	0.016	0.018
fbmy5635_rel_202205192101.cza1_gcp_c2s30	3.042	96.078	0.786	0.094	0.024
fbmy5635_rel_202208092101.cza1_gcp_c2s30	1.318	96.370	2.240	0.073	0.026
fbmy5635_rel_202210112144.cza1_gcp_c2s30	0.391	61.172	38.401	0.036	0.019
fbmy5635_rel_202302162102.cza1_gcp_c2s30	0.865	89.906	9.224	0.005	0.017
fbmy5635_rel_202304122154.cza1_gcp_c2s30	1.349	89.333	9.312	0.005	0.017
fbmy5635_rel_202305292102.cza1_gcp_c2s30	1.891	91.469	6.641		0.011
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	0.833	71.812	27.354		0.014
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	0.839	82.542	16.620		0.009
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	1.297	86.828	11.849	0.026	0.018
fbmy5635_rel_221222.cza1_gcp_c2s30	1.396	84.245	14.359		0.014

dbms	1ms	4ms	16ms	64ms	256ms	max
fbmy5635_rel_202104072149.cza1_gcp_c2s30	2.490	82.229	15.255	0.021	0.005	0.114
fbmy5635_rel_202203072101.cza1_gcp_c2s30	4.974	94.542	0.469	0.016		0.018
fbmy5635_rel_202205192101.cza1_gcp_c2s30	4.870	94.188	0.844	0.094	0.005	0.139
fbmy5635_rel_202208092101.cza1_gcp_c2s30	2.099	95.542	2.281	0.078		0.025
fbmy5635_rel_202210112144.cza1_gcp_c2s30	0.714	61.745	37.510	0.031		0.020
fbmy5635_rel_202302162102.cza1_gcp_c2s30	2.062	89.328	8.609			0.014
fbmy5635_rel_202304122154.cza1_gcp_c2s30	2.594	89.422	7.984			0.008
fbmy5635_rel_202305292102.cza1_gcp_c2s30	4.328	89.396	6.276			0.009
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	1.266	71.901	26.828	0.005		0.016
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	1.281	83.073	15.646			0.011
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	2.750	86.156	11.073	0.021		0.018
fbmy5635_rel_221222.cza1_gcp_c2s30	2.573	82.979	14.448			0.014

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
793	31821	0	0.0	35.8	10.7	0.000	0.000	0.045	13.777	136096	54.1	4.277	255	11.4	11.8	81.4	0.018	4028	3372	fbmy5635_rel_202104072149.cza1_gcp_c2s30
794	31119	0	0.0	35.6	11.1	0.000	0.000	0.045	14.296	133229	54.2	4.281	261	11.4	11.8	81.4	0.018	3949	3196	fbmy5635_rel_202203072101.cza1_gcp_c2s30
793	30841	0	0.0	35.5	11.0	0.000	0.000	0.045	14.248	132138	54.2	4.285	264	12.5	13.0	80.9	0.019	3900	3212	fbmy5635_rel_202205192101.cza1_gcp_c2s30
793	30969	0	0.0	40.0	11.6	0.000	0.000	0.050	14.933	133127	54.3	4.299	263	11.4	11.8	81.3	0.019	3916	3228	fbmy5635_rel_202208092101.cza1_gcp_c2s30
793	30692	0	0.0	39.4	11.4	0.000	0.000	0.050	14.761	132125	54.2	4.305	265	12.2	12.7	81.2	0.019	3884	3085	fbmy5635_rel_202210112144.cza1_gcp_c2s30
794	32294	0	0.0	13.0	3.2	0.000	0.000	0.016	4.074	134316	53.2	4.159	247	11.4	11.9	73.3	0.030	4091	3484	fbmy5635_rel_202302162102.cza1_gcp_c2s30
794	31568	0	0.0	11.6	2.7	0.000	0.000	0.015	3.491	130905	53.2	4.147	253	11.5	11.9	74.4	0.019	4012	3276	fbmy5635_rel_202304122154.cza1_gcp_c2s30
794	31438	0	0.0	13.2	3.3	0.000	0.000	0.017	4.220	130740	53.3	4.159	254	11.5	11.9	73.5	0.024	4012	3438	fbmy5635_rel_202305292102.cza1_gcp_c2s30
794	31680	0	0.0	12.5	3.0	0.000	0.000	0.016	3.863	132481	53.2	4.182	252	11.4	11.8	73.0	0.035	4012	3452	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
794	31014	0	0.0	13.1	3.2	0.000	0.000	0.016	4.171	129672	53.3	4.181	258	11.6	12.0	73.2	0.020	3916	3340	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
794	31151	0	0.0	12.2	3.0	0.000	0.000	0.015	3.825	130391	53.2	4.186	256	11.4	11.8	73.3	0.032	3948	3534	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
793	31148	0	0.0	12.8	3.1	0.000	0.000	0.016	3.970	130140	53.3	4.178	257	11.4	11.8	73.1	0.033	3948	3468	fbmy5635_rel_221222.cza1_gcp_c2s30

qr500.L3

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

Average throughput:

dbms	256us	1ms	4ms	16ms	64ms	256ms	max
fbmy5635_rel_202104072149.cza1_gcp_c2s30	64.742	32.427	2.830	nonzero	nonzero	nonzero	0.133
fbmy5635_rel_202203072101.cza1_gcp_c2s30	63.974	33.409	2.616	nonzero	nonzero	nonzero	0.133
fbmy5635_rel_202205192101.cza1_gcp_c2s30	64.296	32.593	3.110	nonzero	nonzero	nonzero	0.114
fbmy5635_rel_202208092101.cza1_gcp_c2s30	63.702	33.654	2.643	nonzero	nonzero	nonzero	0.135
fbmy5635_rel_202210112144.cza1_gcp_c2s30	64.479	32.000	3.520	nonzero	nonzero	nonzero	0.123
fbmy5635_rel_202302162102.cza1_gcp_c2s30	66.027	31.449	2.524	0.001	nonzero	nonzero	0.075
fbmy5635_rel_202304122154.cza1_gcp_c2s30	65.418	32.133	2.449	0.001	nonzero		0.026
fbmy5635_rel_202305292102.cza1_gcp_c2s30	65.251	31.920	2.828	0.001	nonzero	nonzero	0.066
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	65.402	32.460	2.137	0.001	nonzero	nonzero	0.074
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	65.750	30.242	4.008	0.001	nonzero	nonzero	0.071
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	65.827	28.720	5.452	0.001	nonzero		0.060
fbmy5635_rel_221222.cza1_gcp_c2s30	64.927	31.473	3.599	0.001	nonzero	nonzero	0.070

dbms	1ms	4ms	16ms	64ms	max
fbmy5635_rel_202104072149.cza1_gcp_c2s30	2.618	57.758	39.551	0.073	0.022
fbmy5635_rel_202203072101.cza1_gcp_c2s30	1.927	52.789	45.238	0.047	0.024
fbmy5635_rel_202205192101.cza1_gcp_c2s30	1.182	52.126	46.640	0.052	0.023
fbmy5635_rel_202208092101.cza1_gcp_c2s30	0.741	47.740	51.447	0.073	0.025
fbmy5635_rel_202210112144.cza1_gcp_c2s30	1.266	52.264	46.427	0.044	0.024
fbmy5635_rel_202302162102.cza1_gcp_c2s30	2.618	52.150	45.197	0.035	0.020
fbmy5635_rel_202304122154.cza1_gcp_c2s30	1.380	52.194	46.402	0.024	0.021
fbmy5635_rel_202305292102.cza1_gcp_c2s30	2.110	54.319	43.526	0.045	0.026
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	0.678	48.846	50.446	0.030	0.021
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	2.704	57.936	39.329	0.030	0.022
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	2.908	58.251	38.783	0.057	0.020
fbmy5635_rel_221222.cza1_gcp_c2s30	2.191	58.028	39.740	0.042	0.021

dbms	1ms	4ms	16ms	64ms	256ms	max
fbmy5635_rel_202104072149.cza1_gcp_c2s30	2.735	57.768	39.434	0.062		0.021
fbmy5635_rel_202203072101.cza1_gcp_c2s30	2.330	53.211	44.407	0.051		0.026
fbmy5635_rel_202205192101.cza1_gcp_c2s30	1.565	52.357	46.021	0.056	0.001	0.082
fbmy5635_rel_202208092101.cza1_gcp_c2s30	0.965	48.470	50.506	0.059		0.028
fbmy5635_rel_202210112144.cza1_gcp_c2s30	2.273	52.658	45.024	0.045		0.022
fbmy5635_rel_202302162102.cza1_gcp_c2s30	2.573	52.278	45.121	0.028		0.028
fbmy5635_rel_202304122154.cza1_gcp_c2s30	1.692	52.649	45.635	0.024		0.023
fbmy5635_rel_202305292102.cza1_gcp_c2s30	2.404	54.977	42.582	0.036		0.027
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	0.833	49.055	50.080	0.031		0.022
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	2.995	57.913	39.068	0.025		0.020
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	3.358	58.791	37.797	0.054		0.021
fbmy5635_rel_221222.cza1_gcp_c2s30	2.323	58.329	39.307	0.041		0.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
3967	22371	0	0.0	136.3	44.4	0.000	0.000	0.034	11.459	89211	59.4	3.988	398	11.5	12.9	81.3	0.133	3133	2430	fbmy5635_rel_202104072149.cza1_gcp_c2s30
3970	22833	0	0.0	138.9	44.0	0.000	0.000	0.035	11.339	90952	59.4	3.983	390	11.7	13.2	81.2	0.133	3133	2685	fbmy5635_rel_202203072101.cza1_gcp_c2s30
3970	21651	0	0.0	131.4	43.8	0.000	0.000	0.033	11.309	86220	59.5	3.982	412	11.8	13.3	80.7	0.114	2670	2301	fbmy5635_rel_202205192101.cza1_gcp_c2s30
3967	23124	0	0.0	135.7	44.9	0.000	0.000	0.034	11.588	91948	59.6	3.976	387	11.5	13.0	81.2	0.135	3436	2973	fbmy5635_rel_202208092101.cza1_gcp_c2s30
3970	21024	0	0.0	138.3	43.3	0.000	0.000	0.035	11.172	84013	59.3	3.996	423	12.6	14.0	81.4	0.123	2894	2493	fbmy5635_rel_202210112144.cza1_gcp_c2s30
3970	23746	0	0.0	55.2	17.9	0.000	0.000	0.014	4.627	93142	56.2	3.922	355	11.4	12.8	78.2	0.075	3037	2254	fbmy5635_rel_202302162102.cza1_gcp_c2s30
3970	23515	0	0.0	36.7	10.2	0.000	0.000	0.009	2.632	91923	55.1	3.909	351	11.5	13.0	78.0	0.026	3101	2622	fbmy5635_rel_202304122154.cza1_gcp_c2s30
3970	22802	0	0.0	59.1	19.6	0.000	0.000	0.015	5.059	89416	56.4	3.921	371	11.4	12.9	78.6	0.066	3069	2589	fbmy5635_rel_202305292102.cza1_gcp_c2s30
3970	22364	0	0.0	55.4	17.8	0.000	0.000	0.014	4.590	87819	56.2	3.927	377	11.4	12.9	78.2	0.074	2749	2349	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
3970	22616	0	0.0	54.7	17.8	0.000	0.000	0.014	4.598	88734	56.3	3.923	373	11.4	12.9	78.4	0.071	3677	2334	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
3967	19782	0	0.0	55.5	17.2	0.000	0.000	0.014	4.428	77969	56.0	3.941	425	11.5	12.9	78.5	0.060	3149	2142	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
3970	22313	0	0.0	54.4	17.3	0.000	0.000	0.014	4.471	87683	56.0	3.930	376	11.5	12.9	78.7	0.070	2605	2190	fbmy5635_rel_221222.cza1_gcp_c2s30

qp500.L4

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

Average throughput:

dbms	256us	1ms	4ms	16ms	64ms	max
fbmy5635_rel_202104072149.cza1_gcp_c2s30	47.934	52.039	0.025	0.001	0.001	0.040
fbmy5635_rel_202203072101.cza1_gcp_c2s30	38.319	61.652	0.027	0.001	0.001	0.049
fbmy5635_rel_202205192101.cza1_gcp_c2s30	39.220	60.755	0.022	0.001	0.002	0.040
fbmy5635_rel_202208092101.cza1_gcp_c2s30	36.130	63.840	0.028	0.001	0.002	0.050
fbmy5635_rel_202210112144.cza1_gcp_c2s30	35.596	64.373	0.028	0.001	0.002	0.064
fbmy5635_rel_202302162102.cza1_gcp_c2s30	74.117	25.871	0.011	nonzero	nonzero	0.025
fbmy5635_rel_202304122154.cza1_gcp_c2s30	66.917	33.072	0.011	nonzero		0.015
fbmy5635_rel_202305292102.cza1_gcp_c2s30	63.037	36.950	0.013	nonzero	nonzero	0.026
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	65.261	34.726	0.013	nonzero		0.012
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	57.261	42.724	0.014	nonzero	nonzero	0.024
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	61.957	38.029	0.014	nonzero		0.015
fbmy5635_rel_221222.cza1_gcp_c2s30	61.325	38.661	0.014	nonzero	nonzero	0.027

dbms	1ms	4ms	16ms	64ms	256ms	max
fbmy5635_rel_202104072149.cza1_gcp_c2s30	0.964	57.503	41.242	0.283	0.008	0.091
fbmy5635_rel_202203072101.cza1_gcp_c2s30	0.314	43.705	55.668	0.306	0.007	0.080
fbmy5635_rel_202205192101.cza1_gcp_c2s30	0.299	48.924	50.485	0.292		0.025
fbmy5635_rel_202208092101.cza1_gcp_c2s30	0.147	40.763	58.513	0.578		0.048
fbmy5635_rel_202210112144.cza1_gcp_c2s30	0.253	48.830	50.634	0.282		0.046
fbmy5635_rel_202302162102.cza1_gcp_c2s30	0.578	50.408	48.950	0.064		0.026
fbmy5635_rel_202304122154.cza1_gcp_c2s30	0.689	47.246	51.953	0.112		0.041
fbmy5635_rel_202305292102.cza1_gcp_c2s30	0.634	48.036	51.258	0.071		0.025
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	0.647	51.594	47.696	0.064		0.021
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	0.535	44.654	54.712	0.098		0.036
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	0.545	47.367	52.007	0.081		0.025
fbmy5635_rel_221222.cza1_gcp_c2s30	0.449	43.562	55.925	0.064		0.024

dbms	1ms	4ms	16ms	64ms	256ms	max
fbmy5635_rel_202104072149.cza1_gcp_c2s30	1.269	57.716	40.728	0.277	0.010	0.101
fbmy5635_rel_202203072101.cza1_gcp_c2s30	0.487	44.585	54.605	0.314	0.008	0.079
fbmy5635_rel_202205192101.cza1_gcp_c2s30	0.579	49.728	49.416	0.276	0.001	0.065
fbmy5635_rel_202208092101.cza1_gcp_c2s30	0.302	41.427	57.733	0.535	0.002	0.115
fbmy5635_rel_202210112144.cza1_gcp_c2s30	0.505	49.779	49.426	0.287	0.002	0.122
fbmy5635_rel_202302162102.cza1_gcp_c2s30	0.758	51.126	48.041	0.075		0.027
fbmy5635_rel_202304122154.cza1_gcp_c2s30	0.992	48.268	50.632	0.107	0.001	0.068
fbmy5635_rel_202305292102.cza1_gcp_c2s30	1.001	49.367	49.553	0.079		0.025
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	0.941	52.575	46.420	0.065		0.022
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	0.751	45.579	53.579	0.091		0.039
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	0.931	48.432	50.566	0.071		0.025
fbmy5635_rel_221222.cza1_gcp_c2s30	0.694	44.695	54.538	0.074		0.025

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
3970	28655	0	0.0	152.0	39.3	0.000	0.000	0.038	10.148	133364	59.9	4.654	314	13.1	13.7	86.4	0.040	3644	2733	fbmy5635_rel_202104072149.cza1_gcp_c2s30
3967	28150	0	0.0	155.9	39.2	0.000	0.000	0.039	10.122	129271	60.0	4.592	320	11.7	12.3	86.6	0.049	3580	2606	fbmy5635_rel_202203072101.cza1_gcp_c2s30
3970	28269	0	0.0	146.6	37.6	0.000	0.000	0.037	9.694	127499	60.0	4.510	318	12.8	13.3	85.9	0.040	3596	2717	fbmy5635_rel_202205192101.cza1_gcp_c2s30
3970	28013	0	0.0	150.2	40.2	0.000	0.000	0.038	10.380	128568	60.0	4.590	321	11.6	12.2	85.0	0.050	3548	2654	fbmy5635_rel_202208092101.cza1_gcp_c2s30
3970	28021	0	0.0	153.4	38.2	0.000	0.000	0.039	9.852	128354	60.0	4.581	321	11.7	12.2	86.9	0.064	3548	2637	fbmy5635_rel_202210112144.cza1_gcp_c2s30
3967	30703	0	0.0	59.7	17.3	0.000	0.000	0.015	4.474	132154	56.8	4.304	277	11.5	12.1	80.2	0.025	3933	3404	fbmy5635_rel_202302162102.cza1_gcp_c2s30
3970	30058	0	0.0	54.9	13.7	0.000	0.000	0.014	3.538	128258	56.4	4.267	281	11.6	12.1	80.0	0.015	3853	3404	fbmy5635_rel_202304122154.cza1_gcp_c2s30
3970	29792	0	0.0	61.5	18.0	0.000	0.000	0.015	4.654	127991	56.9	4.296	286	12.0	12.6	80.5	0.026	3820	3388	fbmy5635_rel_202305292102.cza1_gcp_c2s30
3970	29966	0	0.0	62.4	17.8	0.000	0.000	0.016	4.600	130046	57.0	4.340	285	12.4	13.0	80.1	0.012	3820	3484	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
3967	29429	0	0.0	60.8	17.9	0.000	0.000	0.015	4.610	127679	57.0	4.339	291	12.4	12.9	80.1	0.024	3789	3436	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
3967	29704	0	0.0	61.0	17.5	0.000	0.000	0.015	4.514	128059	56.8	4.311	287	11.5	12.0	80.2	0.015	3773	3276	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
3970	29668	0	0.0	62.0	17.9	0.000	0.000	0.016	4.619	127702	56.8	4.304	287	11.6	12.1	80.1	0.027	3804	3356	fbmy5635_rel_221222.cza1_gcp_c2s30

qr1000.L5

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

Average throughput:

dbms	256us	1ms	4ms	16ms	64ms	256ms	max
fbmy5635_rel_202104072149.cza1_gcp_c2s30	61.692	35.774	2.533	0.001	nonzero	nonzero	0.129
fbmy5635_rel_202203072101.cza1_gcp_c2s30	60.735	34.691	4.573	0.001	nonzero	nonzero	0.133
fbmy5635_rel_202205192101.cza1_gcp_c2s30	60.049	35.755	4.195	0.001	nonzero	nonzero	0.136
fbmy5635_rel_202208092101.cza1_gcp_c2s30	59.756	37.968	2.275	0.001	nonzero	nonzero	0.135
fbmy5635_rel_202210112144.cza1_gcp_c2s30	59.677	36.896	3.425	0.001	nonzero	nonzero	0.119
fbmy5635_rel_202302162102.cza1_gcp_c2s30	63.554	30.476	5.969	0.001	nonzero	nonzero	0.081
fbmy5635_rel_202304122154.cza1_gcp_c2s30	61.450	34.041	4.507	0.001	nonzero	nonzero	0.075
fbmy5635_rel_202305292102.cza1_gcp_c2s30	61.080	31.919	6.999	0.001	nonzero	nonzero	0.076
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	60.892	34.436	4.670	0.001	nonzero	nonzero	0.078
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	60.706	35.202	4.090	0.001	nonzero	nonzero	0.078
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	61.632	33.902	4.465	0.001	nonzero	nonzero	0.083
fbmy5635_rel_221222.cza1_gcp_c2s30	60.789	31.946	7.263	0.002	nonzero	nonzero	0.075

dbms	1ms	4ms	16ms	64ms	max
fbmy5635_rel_202104072149.cza1_gcp_c2s30	1.233	41.579	57.089	0.099	0.032
fbmy5635_rel_202203072101.cza1_gcp_c2s30	0.663	42.891	56.304	0.142	0.034
fbmy5635_rel_202205192101.cza1_gcp_c2s30	0.449	40.472	58.870	0.208	0.035
fbmy5635_rel_202208092101.cza1_gcp_c2s30	0.389	38.742	60.695	0.175	0.024
fbmy5635_rel_202210112144.cza1_gcp_c2s30	0.405	41.673	57.652	0.269	0.034
fbmy5635_rel_202302162102.cza1_gcp_c2s30	1.230	42.084	56.608	0.078	0.034
fbmy5635_rel_202304122154.cza1_gcp_c2s30	0.950	41.653	57.316	0.082	0.026
fbmy5635_rel_202305292102.cza1_gcp_c2s30	0.938	40.104	58.893	0.065	0.025
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	0.818	42.033	57.091	0.058	0.031
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	1.030	44.033	54.849	0.088	0.026
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	0.965	41.735	57.173	0.127	0.028
fbmy5635_rel_221222.cza1_gcp_c2s30	1.091	44.479	54.348	0.082	0.030

dbms	1ms	4ms	16ms	64ms	256ms	max
fbmy5635_rel_202104072149.cza1_gcp_c2s30	1.304	41.880	56.715	0.101	0.001	0.102
fbmy5635_rel_202203072101.cza1_gcp_c2s30	0.862	43.565	55.433	0.140	0.001	0.095
fbmy5635_rel_202205192101.cza1_gcp_c2s30	0.642	41.190	57.957	0.210	0.002	0.091
fbmy5635_rel_202208092101.cza1_gcp_c2s30	0.668	39.483	59.666	0.182	0.002	0.097
fbmy5635_rel_202210112144.cza1_gcp_c2s30	0.615	42.492	56.625	0.267	0.001	0.128
fbmy5635_rel_202302162102.cza1_gcp_c2s30	1.360	42.607	55.961	0.071		0.061
fbmy5635_rel_202304122154.cza1_gcp_c2s30	1.082	42.356	56.481	0.081		0.028
fbmy5635_rel_202305292102.cza1_gcp_c2s30	1.213	40.779	57.938	0.070		0.027
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	0.953	42.256	56.722	0.068	0.001	0.072
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	1.075	44.658	54.174	0.091	0.001	0.073
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	1.216	42.455	56.198	0.131		0.028
fbmy5635_rel_221222.cza1_gcp_c2s30	1.169	45.075	53.674	0.082	0.001	0.068

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
7947	22958	0	0.0	168.0	35.6	0.000	0.000	0.021	4.584	92179	61.4	4.015	401	12.9	13.6	84.6	0.129	2717	2302	fbmy5635_rel_202104072149.cza1_gcp_c2s30
7940	21545	0	0.0	166.2	38.1	0.000	0.000	0.021	4.918	86872	61.4	4.032	427	11.8	12.5	83.4	0.133	2349	1935	fbmy5635_rel_202203072101.cza1_gcp_c2s30
7947	21353	0	0.0	162.0	38.5	0.000	0.000	0.020	4.964	86144	61.4	4.034	431	11.6	12.2	82.7	0.136	3038	2237	fbmy5635_rel_202205192101.cza1_gcp_c2s30
7947	22083	0	0.0	161.5	38.6	0.000	0.000	0.020	4.979	88637	61.4	4.014	417	11.8	12.5	82.8	0.135	2845	2125	fbmy5635_rel_202208092101.cza1_gcp_c2s30
7947	21472	0	0.0	169.1	38.7	0.000	0.000	0.021	4.984	86703	61.4	4.038	429	12.3	13.0	83.5	0.119	2429	1982	fbmy5635_rel_202210112144.cza1_gcp_c2s30
7940	21957	0	0.0	118.1	32.5	0.000	0.000	0.015	4.192	87319	60.5	3.977	413	12.1	12.8	80.7	0.081	3101	2605	fbmy5635_rel_202302162102.cza1_gcp_c2s30
7940	21351	0	0.0	122.1	33.1	0.000	0.000	0.015	4.265	84912	60.6	3.977	426	12.2	12.8	80.7	0.075	2925	2238	fbmy5635_rel_202304122154.cza1_gcp_c2s30
7947	20747	0	0.0	122.0	33.6	0.000	0.000	0.015	4.325	82542	60.8	3.978	440	12.1	12.8	80.8	0.076	2942	2254	fbmy5635_rel_202305292102.cza1_gcp_c2s30
7947	21072	0	0.0	124.6	34.7	0.000	0.000	0.016	4.466	83786	61.1	3.976	435	12.1	12.7	81.0	0.078	3037	2317	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
7940	21702	0	0.0	118.9	33.0	0.000	0.000	0.015	4.259	86116	61.1	3.968	422	12.1	12.7	80.5	0.078	3053	2238	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
7947	21741	0	0.0	116.2	33.1	0.000	0.000	0.015	4.264	86399	60.5	3.974	417	12.1	12.8	81.1	0.083	2605	2174	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
7947	20198	0	0.0	120.3	33.6	0.000	0.000	0.015	4.335	80559	60.5	3.989	449	12.1	12.8	80.7	0.075	2830	2286	fbmy5635_rel_221222.cza1_gcp_c2s30

qp1000.L6

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

Average throughput:

dbms	256us	1ms	4ms	16ms	64ms	max
fbmy5635_rel_202104072149.cza1_gcp_c2s30	29.579	70.322	0.096	0.002	nonzero	0.025
fbmy5635_rel_202203072101.cza1_gcp_c2s30	21.877	78.016	0.104	0.003	nonzero	0.037
fbmy5635_rel_202205192101.cza1_gcp_c2s30	19.742	80.152	0.103	0.003	nonzero	0.050
fbmy5635_rel_202208092101.cza1_gcp_c2s30	21.800	78.136	0.062	0.001	nonzero	0.025
fbmy5635_rel_202210112144.cza1_gcp_c2s30	17.833	82.050	0.114	0.003	nonzero	0.026
fbmy5635_rel_202302162102.cza1_gcp_c2s30	48.889	51.057	0.052	0.001	0.001	0.042
fbmy5635_rel_202304122154.cza1_gcp_c2s30	39.094	60.855	0.049	0.001	0.001	0.040
fbmy5635_rel_202305292102.cza1_gcp_c2s30	36.892	63.055	0.051	0.001	0.002	0.041
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	39.947	59.999	0.051	0.001	0.002	0.043
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	30.142	69.808	0.048	0.001	0.001	0.042
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	33.883	66.063	0.051	0.001	0.002	0.042
fbmy5635_rel_221222.cza1_gcp_c2s30	36.933	63.014	0.051	0.001	0.002	0.042

dbms	1ms	4ms	16ms	64ms	max
fbmy5635_rel_202104072149.cza1_gcp_c2s30	0.538	46.343	52.699	0.420	0.037
fbmy5635_rel_202203072101.cza1_gcp_c2s30	0.261	43.196	56.145	0.398	0.038
fbmy5635_rel_202205192101.cza1_gcp_c2s30	0.156	39.347	60.018	0.479	0.043
fbmy5635_rel_202208092101.cza1_gcp_c2s30	0.332	73.802	25.783	0.083	0.049
fbmy5635_rel_202210112144.cza1_gcp_c2s30	0.105	44.586	54.962	0.347	0.041
fbmy5635_rel_202302162102.cza1_gcp_c2s30	0.469	39.526	59.901	0.104	0.043
fbmy5635_rel_202304122154.cza1_gcp_c2s30	0.408	41.986	57.571	0.035	0.038
fbmy5635_rel_202305292102.cza1_gcp_c2s30	0.264	40.731	58.944	0.062	0.045
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	0.320	41.716	57.872	0.092	0.040
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	0.320	43.453	56.170	0.058	0.041
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	0.361	43.169	56.397	0.072	0.041
fbmy5635_rel_221222.cza1_gcp_c2s30	0.452	41.249	58.217	0.081	0.040

dbms	1ms	4ms	16ms	64ms	256ms	max
fbmy5635_rel_202104072149.cza1_gcp_c2s30	0.576	47.043	51.958	0.422	0.001	0.158
fbmy5635_rel_202203072101.cza1_gcp_c2s30	0.430	44.342	54.833	0.393	0.002	0.123
fbmy5635_rel_202205192101.cza1_gcp_c2s30	0.332	40.447	58.762	0.456	0.002	0.111
fbmy5635_rel_202208092101.cza1_gcp_c2s30	0.645	74.535	24.735	0.084	0.001	0.119
fbmy5635_rel_202210112144.cza1_gcp_c2s30	0.246	46.045	53.367	0.339	0.004	0.152
fbmy5635_rel_202302162102.cza1_gcp_c2s30	0.752	40.122	59.032	0.093	0.001	0.077
fbmy5635_rel_202304122154.cza1_gcp_c2s30	0.847	43.260	55.847	0.045		0.041
fbmy5635_rel_202305292102.cza1_gcp_c2s30	0.652	42.130	57.158	0.060	0.001	0.076
fbmy5635_rel_20230529_832.cza1_gcp_c2s30	0.540	42.573	56.784	0.102	0.001	0.073
fbmy5635_rel_20230529_843.cza1_gcp_c2s30	0.609	44.609	54.719	0.062	0.001	0.068
fbmy5635_rel_20230529_850.cza1_gcp_c2s30	0.601	44.285	55.037	0.077	0.001	0.067
fbmy5635_rel_221222.cza1_gcp_c2s30	0.683	42.282	56.954	0.081		0.044

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
7947	27352	0	0.0	160.9	38.9	0.000	0.000	0.020	5.009	134869	61.3	4.931	336	11.9	12.7	83.3	0.025	3420	2733	fbmy5635_rel_202104072149.cza1_gcp_c2s30
7940	26903	0	0.0	163.7	41.3	0.000	0.000	0.021	5.324	130398	61.3	4.847	342	12.7	13.5	83.4	0.037	3372	2653	fbmy5635_rel_202203072101.cza1_gcp_c2s30
7947	26799	0	0.0	157.8	41.4	0.000	0.000	0.020	5.332	129951	61.5	4.849	344	11.6	12.4	83.4	0.050	3358	2637	fbmy5635_rel_202205192101.cza1_gcp_c2s30
7940	26884	0	0.0	167.2	39.9	0.000	0.000	0.021	5.140	129560	61.5	4.819	343	11.7	12.5	83.3	0.025	3372	2653	fbmy5635_rel_202208092101.cza1_gcp_c2s30
7947	26578	0	0.0	164.6	39.9	0.000	0.000	0.021	5.135	129249	61.4	4.863	347	12.2	13.0	83.2	0.026	3356	2573	fbmy5635_rel_202210112144.cza1_gcp_c2s30
7940	28549	0	0.0	120.6	33.4	0.000	0.000	0.015	4.305	128650	61.0	4.506	321	12.1	12.9	82.0	0.042	3628	3069	fbmy5635_rel_202302162102.cza1_gcp_c2s30
7940	27974	0	0.0	118.7	32.8	0.000	0.000	0.015	4.230	125231	60.8	4.477	326	12.2	13.0	81.7	0.040	3547	3069	fbmy5635_rel_202304122154.cza1_gcp_c2s30
7947	27848	0	0.0	122.6	33.7	0.000	0.000	0.015	4.340	124129	61.2	4.457	330	12.2	13.0	82.0	0.041	3534	3037	fbmy5635_rel_202305292102.cza1_gcp_c2s30
7947	27990	0	0.0	121.9	33.0	0.000	0.000	0.015	4.252	125306	61.2	4.477	328	12.2	13.0	82.5	0.043	3532	3022	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
7947	27535	0	0.0	116.9	31.7	0.000	0.000	0.015	4.085	123102	61.2	4.471	333	12.2	12.9	81.7	0.042	3499	3034	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
7947	27677	0	0.0	123.1	33.5	0.000	0.000	0.015	4.315	124261	61.0	4.490	331	12.2	13.0	82.2	0.042	3485	2925	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
7947	27849	0	0.0	117.0	32.8	0.000	0.000	0.015	4.230	123892	60.7	4.449	327	12.3	13.1	81.9	0.042	3533	3021	fbmy5635_rel_221222.cza1_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
613027	0	0	0.0	625.7	174.0	0.000	0.000	0.001	0.291	72221	73.7	0.118	18	4.9	6.5	1.4	0.335	83310	51063	fbmy5635_rel_202104072149.cza1_gcp_c2s30
610687	0	0	0.0	617.1	178.0	0.000	0.000	0.001	0.298	73282	74.1	0.120	18	5.0	6.5	1.4	0.355	80808	52259	fbmy5635_rel_202203072101.cza1_gcp_c2s30
592592	0	0	0.0	596.9	170.1	0.000	0.000	0.001	0.294	72057	74.0	0.122	19	5.0	6.5	1.5	0.383	79813	51943	fbmy5635_rel_202205192101.cza1_gcp_c2s30
599251	0	0	0.0	604.7	172.6	0.000	0.000	0.001	0.295	72185	73.5	0.120	18	4.8	6.3	1.6	0.391	80213	49845	fbmy5635_rel_202208092101.cza1_gcp_c2s30
592592	0	0	0.0	612.2	176.3	0.000	0.000	0.001	0.305	71035	73.5	0.120	19	4.9	6.4	1.6	0.344	80113	52561	fbmy5635_rel_202210112144.cza1_gcp_c2s30
634921	0	0	0.0	521.1	144.6	0.000	0.000	0.001	0.233	72640	72.8	0.114	17	4.7	6.1	1.2	0.324	85707	49962	fbmy5635_rel_202302162102.cza1_gcp_c2s30
622568	0	0	0.0	524.1	145.7	0.000	0.000	0.001	0.240	71744	72.2	0.115	17	4.7	6.2	1.3	0.397	86000	50644	fbmy5635_rel_202304122154.cza1_gcp_c2s30
625000	0	0	0.0	517.5	143.5	0.000	0.000	0.001	0.235	71507	73.1	0.114	18	4.7	6.1	1.2	0.294	84136	59036	fbmy5635_rel_202305292102.cza1_gcp_c2s30
620155	0	0	0.0	516.1	142.4	0.000	0.000	0.001	0.235	71452	72.4	0.115	18	4.7	6.2	1.3	0.357	84740	56838	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
617761	0	0	0.0	515.4	141.4	0.000	0.000	0.001	0.234	70909	73.4	0.115	18	4.7	6.1	1.2	0.343	84608	50545	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
627451	0	0	0.0	522.2	144.2	0.000	0.000	0.001	0.235	71602	73.0	0.114	17	4.6	6.1	1.2	0.310	83342	52243	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
622568	0	0	0.0	519.1	142.7	0.000	0.000	0.001	0.235	71944	72.4	0.116	17	4.7	6.2	1.3	0.391	85036	55140	fbmy5635_rel_221222.cza1_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
824743	0	1	0.1	339.1	121.2	0.000	0.000	0.000	0.151	1294	51.0	0.002	9	10.5	12.1	13.7	0.002	NA	NA	fbmy5635_rel_202104072149.cza1_gcp_c2s30
833334	0	1	0.1	340.1	118.1	0.000	0.000	0.000	0.145	1208	50.0	0.001	9	10.5	12.0	13.0	0.002	NA	NA	fbmy5635_rel_202203072101.cza1_gcp_c2s30
833334	0	1	0.1	338.2	118.1	0.000	0.000	0.000	0.145	1208	50.1	0.001	9	10.5	12.0	13.3	0.002	NA	NA	fbmy5635_rel_202205192101.cza1_gcp_c2s30
837697	0	1	0.1	343.0	119.0	0.000	0.000	0.000	0.145	1162	50.3	0.001	9	10.5	12.0	12.7	0.002	NA	NA	fbmy5635_rel_202208092101.cza1_gcp_c2s30
829016	0	1	0.1	348.4	119.4	0.000	0.000	0.000	0.148	1301	50.5	0.002	9	10.5	12.0	13.5	0.002	NA	NA	fbmy5635_rel_202210112144.cza1_gcp_c2s30
808081	0	1	0.1	308.9	110.7	0.000	0.000	0.000	0.140	1064	49.9	0.001	9	10.5	12.0	11.0	0.002	NA	NA	fbmy5635_rel_202302162102.cza1_gcp_c2s30
804021	0	1	0.1	309.6	108.3	0.000	0.000	0.000	0.138	1095	50.0	0.001	9	10.5	12.0	11.0	0.002	NA	NA	fbmy5635_rel_202304122154.cza1_gcp_c2s30
812183	0	1	0.1	311.1	109.9	0.000	0.000	0.000	0.139	1141	49.8	0.001	9	10.5	12.0	11.1	0.002	NA	NA	fbmy5635_rel_202305292102.cza1_gcp_c2s30
800000	0	1	0.1	303.1	107.5	0.000	0.000	0.000	0.138	1064	49.4	0.001	9	10.5	12.0	11.0	0.002	NA	NA	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
804021	0	1	0.1	307.1	109.3	0.000	0.000	0.000	0.139	1022	50.0	0.001	9	10.5	12.0	11.0	0.002	NA	NA	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
804021	0	1	0.1	310.1	108.6	0.000	0.000	0.000	0.138	1116	50.1	0.001	9	10.4	11.9	11.0	0.002	NA	NA	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
800000	0	1	0.1	304.2	108.2	0.000	0.000	0.000	0.139	1341	49.2	0.002	9	10.5	12.0	11.0	0.002	NA	NA	fbmy5635_rel_221222.cza1_gcp_c2s30

l.i1

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

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
92727	0	4	1.6	709.9	203.3	0.000	0.018	0.008	2.245	65523	61.0	0.707	99	17.5	18.1	55.3	0.469	11737	8341	fbmy5635_rel_202104072149.cza1_gcp_c2s30
90729	0	4	1.6	689.7	207.4	0.000	0.018	0.008	2.341	65295	60.0	0.720	99	18.1	18.5	54.2	0.451	11487	8042	fbmy5635_rel_202203072101.cza1_gcp_c2s30
89736	0	4	1.6	678.8	203.1	0.000	0.018	0.008	2.318	63679	60.6	0.710	101	16.3	16.6	54.5	0.449	11338	8091	fbmy5635_rel_202205192101.cza1_gcp_c2s30
89236	0	4	1.6	675.4	201.0	0.000	0.018	0.008	2.306	63194	60.0	0.708	101	16.4	16.9	53.7	0.417	11288	8291	fbmy5635_rel_202208092101.cza1_gcp_c2s30
89360	0	4	1.6	681.0	202.9	0.000	0.018	0.008	2.326	63199	60.3	0.707	101	15.6	16.0	54.5	0.483	11288	8045	fbmy5635_rel_202210112144.cza1_gcp_c2s30
90909	0	4	1.6	553.5	162.3	0.000	0.018	0.006	1.828	60947	59.0	0.670	97	16.5	16.9	50.0	0.386	11641	8394	fbmy5635_rel_202302162102.cza1_gcp_c2s30
89963	0	4	1.6	557.5	163.4	0.000	0.018	0.006	1.860	60608	59.3	0.674	99	13.6	14.0	50.2	0.458	11488	8591	fbmy5635_rel_202304122154.cza1_gcp_c2s30
90090	0	4	1.6	545.7	159.0	0.000	0.018	0.006	1.807	60047	59.7	0.667	99	12.0	12.5	50.0	0.392	11492	8391	fbmy5635_rel_202305292102.cza1_gcp_c2s30
90319	0	4	1.6	551.4	161.5	0.000	0.018	0.006	1.831	60227	60.2	0.667	100	12.3	12.6	50.0	0.403	11537	8144	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
89812	0	4	1.6	544.2	159.9	0.000	0.018	0.006	1.824	59322	61.2	0.661	102	16.9	17.3	49.7	0.397	11438	8294	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
90293	0	359	1.6	564.6	163.8	0.004	0.018	0.006	1.857	60461	60.5	0.670	101	12.2	12.6	50.3	0.440	11537	8340	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
90370	0	4	0.4	553.0	161.6	0.000	0.004	0.006	1.831	60246	59.6	0.667	99	12.2	12.6	50.3	0.443	11587	8444	fbmy5635_rel_221222.cza1_gcp_c2s30

l.i2

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

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
40984	0	0	0.0	462.7	107.9	0.000	0.000	0.011	2.697	234921	67.8	5.732	248	12.3	12.3	66.8	0.109	5329	3502	fbmy5635_rel_202104072149.cza1_gcp_c2s30
40630	0	0	0.0	447.4	103.5	0.000	0.000	0.011	2.609	235776	67.2	5.803	248	12.2	12.3	65.7	0.209	5229	3466	fbmy5635_rel_202203072101.cza1_gcp_c2s30
40120	0	0	0.0	436.9	101.5	0.000	0.000	0.011	2.592	233501	67.2	5.820	251	15.2	15.3	66.3	0.218	5174	3411	fbmy5635_rel_202205192101.cza1_gcp_c2s30
39742	0	0	0.0	445.6	104.4	0.000	0.000	0.011	2.691	230827	67.1	5.808	253	12.3	12.3	65.5	0.150	5139	3406	fbmy5635_rel_202208092101.cza1_gcp_c2s30
40241	0	0	0.0	441.8	102.8	0.000	0.000	0.011	2.616	234843	67.3	5.836	251	14.5	14.5	66.0	0.121	5209	3433	fbmy5635_rel_202210112144.cza1_gcp_c2s30
42105	0	0	0.0	316.3	69.3	0.000	0.000	0.008	1.685	251643	64.3	5.977	229	11.9	11.9	61.4	0.079	5409	3336	fbmy5635_rel_202302162102.cza1_gcp_c2s30
41237	0	0	0.0	305.5	67.4	0.000	0.000	0.007	1.673	248498	64.2	6.026	234	12.2	12.3	61.6	0.083	5349	3217	fbmy5635_rel_202304122154.cza1_gcp_c2s30
41089	0	0	0.0	306.3	67.7	0.000	0.000	0.007	1.687	246725	64.6	6.005	236	11.8	11.9	61.2	0.067	5329	3236	fbmy5635_rel_202305292102.cza1_gcp_c2s30
41131	0	0	0.0	308.3	67.4	0.000	0.000	0.007	1.678	246003	64.7	5.981	236	12.2	12.3	61.1	0.097	5344	3241	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
40984	0	0	0.0	308.2	66.0	0.000	0.000	0.008	1.650	243926	65.3	5.952	239	14.1	14.1	61.4	0.152	5314	3177	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
41322	0	0	0.0	308.9	67.4	0.000	0.000	0.007	1.671	248486	64.5	6.013	234	12.0	12.1	61.5	0.056	5339	3181	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
41216	0	0	0.0	302.9	66.7	0.000	0.000	0.007	1.657	249372	64.3	6.050	234	11.8	11.9	61.3	0.050	5281	3218	fbmy5635_rel_221222.cza1_gcp_c2s30

qr100.L1

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

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
794	26131	0	0.0	38.2	10.6	0.000	0.000	0.048	13.724	101979	53.6	3.903	308	12.6	12.8	68.2	0.131	2845	2637	fbmy5635_rel_202104072149.cza1_gcp_c2s30
794	27589	0	0.0	33.2	8.6	0.000	0.000	0.042	11.052	107703	53.5	3.904	291	12.4	12.6	67.0	0.130	3564	3292	fbmy5635_rel_202203072101.cza1_gcp_c2s30
794	25012	0	0.0	32.9	7.9	0.000	0.000	0.041	10.219	97576	53.3	3.901	320	12.4	12.6	67.5	0.133	3276	3021	fbmy5635_rel_202205192101.cza1_gcp_c2s30
794	28022	0	0.0	35.4	8.4	0.000	0.000	0.045	10.800	109246	53.6	3.899	287	12.1	12.3	66.6	0.134	4573	4219	fbmy5635_rel_202208092101.cza1_gcp_c2s30
794	24682	0	0.0	35.9	8.7	0.000	0.000	0.045	11.165	96436	53.3	3.907	324	11.7	11.9	67.4	0.131	3228	3020	fbmy5635_rel_202210112144.cza1_gcp_c2s30
794	26615	0	0.0	15.2	3.1	0.000	0.000	0.019	3.935	103355	52.9	3.883	298	11.4	11.6	62.8	0.055	2813	2573	fbmy5635_rel_202302162102.cza1_gcp_c2s30
794	22538	0	0.0	14.3	3.0	0.000	0.000	0.018	3.898	87596	52.7	3.887	351	11.5	11.7	63.0	0.047	3484	3228	fbmy5635_rel_202304122154.cza1_gcp_c2s30
793	25205	0	0.0	13.4	2.5	0.000	0.000	0.017	3.282	97913	52.7	3.885	314	11.4	11.7	62.7	0.055	3933	3614	fbmy5635_rel_202305292102.cza1_gcp_c2s30
793	25656	0	0.0	12.6	2.6	0.000	0.000	0.016	3.393	99699	52.7	3.886	308	11.4	11.6	62.4	0.050	3388	3117	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
794	23029	0	0.0	13.2	2.6	0.000	0.000	0.017	3.340	89484	52.7	3.886	343	11.4	11.6	62.7	0.052	2718	2493	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
794	21616	0	0.0	13.3	2.8	0.000	0.000	0.017	3.579	84043	52.5	3.888	364	11.4	11.6	62.9	0.047	2493	2285	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
794	23293	0	0.0	14.0	3.0	0.000	0.000	0.018	3.888	90555	52.8	3.888	340	11.4	11.6	62.7	0.055	3101	2814	fbmy5635_rel_221222.cza1_gcp_c2s30

qp100.L2

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

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
793	31821	0	0.0	35.8	10.7	0.000	0.000	0.045	13.777	136096	54.1	4.277	255	11.4	11.8	81.4	0.018	4028	3372	fbmy5635_rel_202104072149.cza1_gcp_c2s30
794	31119	0	0.0	35.6	11.1	0.000	0.000	0.045	14.296	133229	54.2	4.281	261	11.4	11.8	81.4	0.018	3949	3196	fbmy5635_rel_202203072101.cza1_gcp_c2s30
793	30841	0	0.0	35.5	11.0	0.000	0.000	0.045	14.248	132138	54.2	4.285	264	12.5	13.0	80.9	0.019	3900	3212	fbmy5635_rel_202205192101.cza1_gcp_c2s30
793	30969	0	0.0	40.0	11.6	0.000	0.000	0.050	14.933	133127	54.3	4.299	263	11.4	11.8	81.3	0.019	3916	3228	fbmy5635_rel_202208092101.cza1_gcp_c2s30
793	30692	0	0.0	39.4	11.4	0.000	0.000	0.050	14.761	132125	54.2	4.305	265	12.2	12.7	81.2	0.019	3884	3085	fbmy5635_rel_202210112144.cza1_gcp_c2s30
794	32294	0	0.0	13.0	3.2	0.000	0.000	0.016	4.074	134316	53.2	4.159	247	11.4	11.9	73.3	0.030	4091	3484	fbmy5635_rel_202302162102.cza1_gcp_c2s30
794	31568	0	0.0	11.6	2.7	0.000	0.000	0.015	3.491	130905	53.2	4.147	253	11.5	11.9	74.4	0.019	4012	3276	fbmy5635_rel_202304122154.cza1_gcp_c2s30
794	31438	0	0.0	13.2	3.3	0.000	0.000	0.017	4.220	130740	53.3	4.159	254	11.5	11.9	73.5	0.024	4012	3438	fbmy5635_rel_202305292102.cza1_gcp_c2s30
794	31680	0	0.0	12.5	3.0	0.000	0.000	0.016	3.863	132481	53.2	4.182	252	11.4	11.8	73.0	0.035	4012	3452	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
794	31014	0	0.0	13.1	3.2	0.000	0.000	0.016	4.171	129672	53.3	4.181	258	11.6	12.0	73.2	0.020	3916	3340	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
794	31151	0	0.0	12.2	3.0	0.000	0.000	0.015	3.825	130391	53.2	4.186	256	11.4	11.8	73.3	0.032	3948	3534	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
793	31148	0	0.0	12.8	3.1	0.000	0.000	0.016	3.970	130140	53.3	4.178	257	11.4	11.8	73.1	0.033	3948	3468	fbmy5635_rel_221222.cza1_gcp_c2s30

qr500.L3

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

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
3967	22371	0	0.0	136.3	44.4	0.000	0.000	0.034	11.459	89211	59.4	3.988	398	11.5	12.9	81.3	0.133	3133	2430	fbmy5635_rel_202104072149.cza1_gcp_c2s30
3970	22833	0	0.0	138.9	44.0	0.000	0.000	0.035	11.339	90952	59.4	3.983	390	11.7	13.2	81.2	0.133	3133	2685	fbmy5635_rel_202203072101.cza1_gcp_c2s30
3970	21651	0	0.0	131.4	43.8	0.000	0.000	0.033	11.309	86220	59.5	3.982	412	11.8	13.3	80.7	0.114	2670	2301	fbmy5635_rel_202205192101.cza1_gcp_c2s30
3967	23124	0	0.0	135.7	44.9	0.000	0.000	0.034	11.588	91948	59.6	3.976	387	11.5	13.0	81.2	0.135	3436	2973	fbmy5635_rel_202208092101.cza1_gcp_c2s30
3970	21024	0	0.0	138.3	43.3	0.000	0.000	0.035	11.172	84013	59.3	3.996	423	12.6	14.0	81.4	0.123	2894	2493	fbmy5635_rel_202210112144.cza1_gcp_c2s30
3970	23746	0	0.0	55.2	17.9	0.000	0.000	0.014	4.627	93142	56.2	3.922	355	11.4	12.8	78.2	0.075	3037	2254	fbmy5635_rel_202302162102.cza1_gcp_c2s30
3970	23515	0	0.0	36.7	10.2	0.000	0.000	0.009	2.632	91923	55.1	3.909	351	11.5	13.0	78.0	0.026	3101	2622	fbmy5635_rel_202304122154.cza1_gcp_c2s30
3970	22802	0	0.0	59.1	19.6	0.000	0.000	0.015	5.059	89416	56.4	3.921	371	11.4	12.9	78.6	0.066	3069	2589	fbmy5635_rel_202305292102.cza1_gcp_c2s30
3970	22364	0	0.0	55.4	17.8	0.000	0.000	0.014	4.590	87819	56.2	3.927	377	11.4	12.9	78.2	0.074	2749	2349	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
3970	22616	0	0.0	54.7	17.8	0.000	0.000	0.014	4.598	88734	56.3	3.923	373	11.4	12.9	78.4	0.071	3677	2334	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
3967	19782	0	0.0	55.5	17.2	0.000	0.000	0.014	4.428	77969	56.0	3.941	425	11.5	12.9	78.5	0.060	3149	2142	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
3970	22313	0	0.0	54.4	17.3	0.000	0.000	0.014	4.471	87683	56.0	3.930	376	11.5	12.9	78.7	0.070	2605	2190	fbmy5635_rel_221222.cza1_gcp_c2s30

qp500.L4

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

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
3970	28655	0	0.0	152.0	39.3	0.000	0.000	0.038	10.148	133364	59.9	4.654	314	13.1	13.7	86.4	0.040	3644	2733	fbmy5635_rel_202104072149.cza1_gcp_c2s30
3967	28150	0	0.0	155.9	39.2	0.000	0.000	0.039	10.122	129271	60.0	4.592	320	11.7	12.3	86.6	0.049	3580	2606	fbmy5635_rel_202203072101.cza1_gcp_c2s30
3970	28269	0	0.0	146.6	37.6	0.000	0.000	0.037	9.694	127499	60.0	4.510	318	12.8	13.3	85.9	0.040	3596	2717	fbmy5635_rel_202205192101.cza1_gcp_c2s30
3970	28013	0	0.0	150.2	40.2	0.000	0.000	0.038	10.380	128568	60.0	4.590	321	11.6	12.2	85.0	0.050	3548	2654	fbmy5635_rel_202208092101.cza1_gcp_c2s30
3970	28021	0	0.0	153.4	38.2	0.000	0.000	0.039	9.852	128354	60.0	4.581	321	11.7	12.2	86.9	0.064	3548	2637	fbmy5635_rel_202210112144.cza1_gcp_c2s30
3967	30703	0	0.0	59.7	17.3	0.000	0.000	0.015	4.474	132154	56.8	4.304	277	11.5	12.1	80.2	0.025	3933	3404	fbmy5635_rel_202302162102.cza1_gcp_c2s30
3970	30058	0	0.0	54.9	13.7	0.000	0.000	0.014	3.538	128258	56.4	4.267	281	11.6	12.1	80.0	0.015	3853	3404	fbmy5635_rel_202304122154.cza1_gcp_c2s30
3970	29792	0	0.0	61.5	18.0	0.000	0.000	0.015	4.654	127991	56.9	4.296	286	12.0	12.6	80.5	0.026	3820	3388	fbmy5635_rel_202305292102.cza1_gcp_c2s30
3970	29966	0	0.0	62.4	17.8	0.000	0.000	0.016	4.600	130046	57.0	4.340	285	12.4	13.0	80.1	0.012	3820	3484	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
3967	29429	0	0.0	60.8	17.9	0.000	0.000	0.015	4.610	127679	57.0	4.339	291	12.4	12.9	80.1	0.024	3789	3436	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
3967	29704	0	0.0	61.0	17.5	0.000	0.000	0.015	4.514	128059	56.8	4.311	287	11.5	12.0	80.2	0.015	3773	3276	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
3970	29668	0	0.0	62.0	17.9	0.000	0.000	0.016	4.619	127702	56.8	4.304	287	11.6	12.1	80.1	0.027	3804	3356	fbmy5635_rel_221222.cza1_gcp_c2s30

qr1000.L5

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

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
7947	22958	0	0.0	168.0	35.6	0.000	0.000	0.021	4.584	92179	61.4	4.015	401	12.9	13.6	84.6	0.129	2717	2302	fbmy5635_rel_202104072149.cza1_gcp_c2s30
7940	21545	0	0.0	166.2	38.1	0.000	0.000	0.021	4.918	86872	61.4	4.032	427	11.8	12.5	83.4	0.133	2349	1935	fbmy5635_rel_202203072101.cza1_gcp_c2s30
7947	21353	0	0.0	162.0	38.5	0.000	0.000	0.020	4.964	86144	61.4	4.034	431	11.6	12.2	82.7	0.136	3038	2237	fbmy5635_rel_202205192101.cza1_gcp_c2s30
7947	22083	0	0.0	161.5	38.6	0.000	0.000	0.020	4.979	88637	61.4	4.014	417	11.8	12.5	82.8	0.135	2845	2125	fbmy5635_rel_202208092101.cza1_gcp_c2s30
7947	21472	0	0.0	169.1	38.7	0.000	0.000	0.021	4.984	86703	61.4	4.038	429	12.3	13.0	83.5	0.119	2429	1982	fbmy5635_rel_202210112144.cza1_gcp_c2s30
7940	21957	0	0.0	118.1	32.5	0.000	0.000	0.015	4.192	87319	60.5	3.977	413	12.1	12.8	80.7	0.081	3101	2605	fbmy5635_rel_202302162102.cza1_gcp_c2s30
7940	21351	0	0.0	122.1	33.1	0.000	0.000	0.015	4.265	84912	60.6	3.977	426	12.2	12.8	80.7	0.075	2925	2238	fbmy5635_rel_202304122154.cza1_gcp_c2s30
7947	20747	0	0.0	122.0	33.6	0.000	0.000	0.015	4.325	82542	60.8	3.978	440	12.1	12.8	80.8	0.076	2942	2254	fbmy5635_rel_202305292102.cza1_gcp_c2s30
7947	21072	0	0.0	124.6	34.7	0.000	0.000	0.016	4.466	83786	61.1	3.976	435	12.1	12.7	81.0	0.078	3037	2317	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
7940	21702	0	0.0	118.9	33.0	0.000	0.000	0.015	4.259	86116	61.1	3.968	422	12.1	12.7	80.5	0.078	3053	2238	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
7947	21741	0	0.0	116.2	33.1	0.000	0.000	0.015	4.264	86399	60.5	3.974	417	12.1	12.8	81.1	0.083	2605	2174	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
7947	20198	0	0.0	120.3	33.6	0.000	0.000	0.015	4.335	80559	60.5	3.989	449	12.1	12.8	80.7	0.075	2830	2286	fbmy5635_rel_221222.cza1_gcp_c2s30

qp1000.L6

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

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
7947	27352	0	0.0	160.9	38.9	0.000	0.000	0.020	5.009	134869	61.3	4.931	336	11.9	12.7	83.3	0.025	3420	2733	fbmy5635_rel_202104072149.cza1_gcp_c2s30
7940	26903	0	0.0	163.7	41.3	0.000	0.000	0.021	5.324	130398	61.3	4.847	342	12.7	13.5	83.4	0.037	3372	2653	fbmy5635_rel_202203072101.cza1_gcp_c2s30
7947	26799	0	0.0	157.8	41.4	0.000	0.000	0.020	5.332	129951	61.5	4.849	344	11.6	12.4	83.4	0.050	3358	2637	fbmy5635_rel_202205192101.cza1_gcp_c2s30
7940	26884	0	0.0	167.2	39.9	0.000	0.000	0.021	5.140	129560	61.5	4.819	343	11.7	12.5	83.3	0.025	3372	2653	fbmy5635_rel_202208092101.cza1_gcp_c2s30
7947	26578	0	0.0	164.6	39.9	0.000	0.000	0.021	5.135	129249	61.4	4.863	347	12.2	13.0	83.2	0.026	3356	2573	fbmy5635_rel_202210112144.cza1_gcp_c2s30
7940	28549	0	0.0	120.6	33.4	0.000	0.000	0.015	4.305	128650	61.0	4.506	321	12.1	12.9	82.0	0.042	3628	3069	fbmy5635_rel_202302162102.cza1_gcp_c2s30
7940	27974	0	0.0	118.7	32.8	0.000	0.000	0.015	4.230	125231	60.8	4.477	326	12.2	13.0	81.7	0.040	3547	3069	fbmy5635_rel_202304122154.cza1_gcp_c2s30
7947	27848	0	0.0	122.6	33.7	0.000	0.000	0.015	4.340	124129	61.2	4.457	330	12.2	13.0	82.0	0.041	3534	3037	fbmy5635_rel_202305292102.cza1_gcp_c2s30
7947	27990	0	0.0	121.9	33.0	0.000	0.000	0.015	4.252	125306	61.2	4.477	328	12.2	13.0	82.5	0.043	3532	3022	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
7947	27535	0	0.0	116.9	31.7	0.000	0.000	0.015	4.085	123102	61.2	4.471	333	12.2	12.9	81.7	0.042	3499	3034	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
7947	27677	0	0.0	123.1	33.5	0.000	0.000	0.015	4.315	124261	61.0	4.490	331	12.2	13.0	82.2	0.042	3485	2925	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
7947	27849	0	0.0	117.0	32.8	0.000	0.000	0.015	4.230	123892	60.7	4.449	327	12.3	13.1	81.9	0.042	3533	3021	fbmy5635_rel_221222.cza1_gcp_c2s30

l.i0

l.i0: load without secondary indexes
Legend for results is here.
Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	28.113	71.859	0.013	0.002	0.010	0.003	0.000	0.000	0.000	0.335	fbmy5635_rel_202104072149.cza1_gcp_c2s30
0.000	24.871	75.101	0.013	0.001	0.009	0.004	0.000	0.000	0.000	0.355	fbmy5635_rel_202203072101.cza1_gcp_c2s30
0.000	18.807	81.161	0.016	0.002	0.008	0.006	0.000	0.000	0.000	0.383	fbmy5635_rel_202205192101.cza1_gcp_c2s30
0.000	21.732	78.236	0.015	0.002	0.009	0.005	0.000	0.000	0.000	0.391	fbmy5635_rel_202208092101.cza1_gcp_c2s30
0.000	18.633	81.332	0.019	0.001	0.011	0.003	0.000	0.000	0.000	0.344	fbmy5635_rel_202210112144.cza1_gcp_c2s30
0.000	44.735	55.237	0.013	0.001	0.009	0.005	0.000	0.000	0.000	0.324	fbmy5635_rel_202302162102.cza1_gcp_c2s30
0.000	40.788	59.180	0.017	0.001	0.009	0.004	0.000	0.000	0.000	0.397	fbmy5635_rel_202304122154.cza1_gcp_c2s30
0.000	33.378	66.593	0.014	0.001	0.010	0.004	0.000	0.000	0.000	0.294	fbmy5635_rel_202305292102.cza1_gcp_c2s30
0.000	38.958	61.014	0.014	0.001	0.009	0.005	0.000	0.000	0.000	0.357	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
0.000	32.557	67.412	0.017	nonzero	0.007	0.006	0.000	0.000	0.000	0.343	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
0.000	34.954	65.007	0.022	0.003	0.012	0.002	0.000	0.000	0.000	0.310	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
0.000	37.038	62.935	0.012	0.001	0.008	0.006	0.000	0.000	0.000	0.391	fbmy5635_rel_221222.cza1_gcp_c2s30

l.x

l.x: create secondary indexes
Legend for results is here.
Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).

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

l.i1

l.i1: continue load after secondary indexes created with 50 inserts per transaction
Legend for results is here.
Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.047	42.354	57.478	0.105	0.008	0.007	0.000	0.000	0.000	0.469	fbmy5635_rel_202104072149.cza1_gcp_c2s30
0.000	0.036	36.017	63.826	0.106	0.008	0.008	0.000	0.000	0.000	0.451	fbmy5635_rel_202203072101.cza1_gcp_c2s30
0.000	0.037	34.076	65.761	0.111	0.010	0.006	0.000	0.000	0.000	0.449	fbmy5635_rel_202205192101.cza1_gcp_c2s30
0.000	0.065	33.569	66.238	0.113	0.009	0.006	0.000	0.000	0.000	0.417	fbmy5635_rel_202208092101.cza1_gcp_c2s30
0.000	0.026	33.444	66.404	0.112	0.008	0.007	0.000	0.000	0.000	0.483	fbmy5635_rel_202210112144.cza1_gcp_c2s30
0.000	0.034	38.058	61.786	0.107	0.009	0.006	0.000	0.000	0.000	0.386	fbmy5635_rel_202302162102.cza1_gcp_c2s30
0.000	0.032	35.547	64.294	0.112	0.011	0.004	0.000	0.000	0.000	0.458	fbmy5635_rel_202304122154.cza1_gcp_c2s30
0.000	0.050	35.604	64.223	0.108	0.012	0.004	0.000	0.000	0.000	0.392	fbmy5635_rel_202305292102.cza1_gcp_c2s30
0.000	0.050	37.398	62.432	0.106	0.010	0.005	0.000	0.000	0.000	0.403	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
0.000	0.030	36.589	63.258	0.108	0.009	0.007	0.000	0.000	0.000	0.397	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
0.000	0.041	36.833	63.006	0.105	0.009	0.006	0.000	0.000	0.000	0.440	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
0.000	0.044	36.867	62.973	0.100	0.010	0.006	0.000	0.000	0.000	0.443	fbmy5635_rel_221222.cza1_gcp_c2s30

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.044	39.825	60.006	0.109	0.008	0.008	0.000	0.000	0.000	0.469	fbmy5635_rel_202104072149.cza1_gcp_c2s30
0.000	0.038	37.439	62.402	0.106	0.008	0.008	0.000	0.000	0.000	0.453	fbmy5635_rel_202203072101.cza1_gcp_c2s30
0.000	0.037	35.568	64.270	0.110	0.009	0.006	0.000	0.000	0.000	0.450	fbmy5635_rel_202205192101.cza1_gcp_c2s30
0.000	0.063	34.199	65.609	0.113	0.009	0.006	0.000	0.000	0.000	0.418	fbmy5635_rel_202208092101.cza1_gcp_c2s30
0.000	0.026	35.087	64.762	0.110	0.008	0.007	0.000	0.000	0.000	0.484	fbmy5635_rel_202210112144.cza1_gcp_c2s30
0.000	0.033	38.531	61.314	0.107	0.009	0.006	0.000	0.000	0.000	0.386	fbmy5635_rel_202302162102.cza1_gcp_c2s30
0.000	0.033	37.505	62.336	0.111	0.011	0.004	0.000	0.000	0.000	0.457	fbmy5635_rel_202304122154.cza1_gcp_c2s30
0.000	0.052	38.221	61.603	0.109	0.011	0.004	0.000	0.000	0.000	0.395	fbmy5635_rel_202305292102.cza1_gcp_c2s30
0.000	0.052	37.086	62.738	0.108	0.010	0.005	0.000	0.000	0.000	0.404	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
0.000	0.029	36.581	63.266	0.108	0.009	0.007	0.000	0.000	0.000	0.395	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
0.000	0.042	38.138	61.699	0.106	0.009	0.006	0.000	0.000	0.000	0.441	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
0.000	0.044	37.774	62.068	0.099	0.010	0.005	0.000	0.000	0.000	0.445	fbmy5635_rel_221222.cza1_gcp_c2s30

l.i2

l.i2: continue load after secondary indexes created with 5 inserts per transaction
Legend for results is here.
Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.147	83.393	16.393	0.061	0.006	nonzero	0.000	0.000	0.000	0.000	0.109	fbmy5635_rel_202104072149.cza1_gcp_c2s30
0.094	82.143	17.694	0.064	0.006	nonzero	0.000	0.000	0.000	0.000	0.209	fbmy5635_rel_202203072101.cza1_gcp_c2s30
0.165	80.633	19.134	0.063	0.005	nonzero	0.000	0.000	0.000	0.000	0.218	fbmy5635_rel_202205192101.cza1_gcp_c2s30
0.147	79.376	20.405	0.066	0.007	nonzero	0.000	0.000	0.000	0.000	0.150	fbmy5635_rel_202208092101.cza1_gcp_c2s30
0.106	81.188	18.636	0.064	0.006	nonzero	0.000	0.000	0.000	0.000	0.121	fbmy5635_rel_202210112144.cza1_gcp_c2s30
0.099	86.464	13.396	0.036	0.005	nonzero	0.000	0.000	0.000	0.000	0.079	fbmy5635_rel_202302162102.cza1_gcp_c2s30
0.175	84.180	15.604	0.035	0.005	nonzero	0.000	0.000	0.000	0.000	0.083	fbmy5635_rel_202304122154.cza1_gcp_c2s30
0.138	83.893	15.927	0.036	0.006	nonzero	0.000	0.000	0.000	0.000	0.067	fbmy5635_rel_202305292102.cza1_gcp_c2s30
0.148	83.644	16.166	0.037	0.005	nonzero	0.000	0.000	0.000	0.000	0.097	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
0.091	83.385	16.483	0.037	0.004	nonzero	0.000	0.000	0.000	0.000	0.152	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
0.147	84.839	14.975	0.034	0.005	0.000	0.000	0.000	0.000	0.000	0.056	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
0.068	84.539	15.354	0.035	0.005	0.000	0.000	0.000	0.000	0.000	0.050	fbmy5635_rel_221222.cza1_gcp_c2s30

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
nonzero	67.273	32.654	0.067	0.006	nonzero	0.000	0.000	0.000	0.000	0.114	fbmy5635_rel_202104072149.cza1_gcp_c2s30
0.000	64.386	35.537	0.070	0.007	nonzero	0.000	0.000	0.000	0.000	0.209	fbmy5635_rel_202203072101.cza1_gcp_c2s30
0.000	61.824	38.103	0.068	0.005	nonzero	0.000	0.000	0.000	0.000	0.218	fbmy5635_rel_202205192101.cza1_gcp_c2s30
0.000	60.059	39.862	0.072	0.007	nonzero	0.000	0.000	0.000	0.000	0.150	fbmy5635_rel_202208092101.cza1_gcp_c2s30
nonzero	62.645	37.278	0.070	0.006	nonzero	0.000	0.000	0.000	0.000	0.121	fbmy5635_rel_202210112144.cza1_gcp_c2s30
0.005	69.429	30.521	0.040	0.005	nonzero	0.000	0.000	0.000	0.000	0.079	fbmy5635_rel_202302162102.cza1_gcp_c2s30
nonzero	65.762	34.194	0.039	0.006	nonzero	0.000	0.000	0.000	0.000	0.083	fbmy5635_rel_202304122154.cza1_gcp_c2s30
nonzero	65.458	34.495	0.040	0.007	nonzero	0.000	0.000	0.000	0.000	0.067	fbmy5635_rel_202305292102.cza1_gcp_c2s30
0.004	65.333	34.617	0.041	0.006	nonzero	0.000	0.000	0.000	0.000	0.096	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
0.000	64.983	34.971	0.041	0.005	nonzero	0.000	0.000	0.000	0.000	0.152	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
0.000	66.585	33.371	0.038	0.005	0.000	0.000	0.000	0.000	0.000	0.056	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
0.002	65.324	34.630	0.038	0.006	0.000	0.000	0.000	0.000	0.000	0.050	fbmy5635_rel_221222.cza1_gcp_c2s30

qr100.L1

qr100.L1: range queries with 100 insert/s per client
Legend for results is here.
Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
71.473	26.946	1.581	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.131	fbmy5635_rel_202104072149.cza1_gcp_c2s30
71.966	27.774	0.260	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.130	fbmy5635_rel_202203072101.cza1_gcp_c2s30
69.422	29.224	1.353	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.133	fbmy5635_rel_202205192101.cza1_gcp_c2s30
74.587	23.168	2.245	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.134	fbmy5635_rel_202208092101.cza1_gcp_c2s30
66.995	31.032	1.973	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.131	fbmy5635_rel_202210112144.cza1_gcp_c2s30
70.127	29.050	0.823	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.055	fbmy5635_rel_202302162102.cza1_gcp_c2s30
65.763	29.923	4.313	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.047	fbmy5635_rel_202304122154.cza1_gcp_c2s30
68.062	27.824	4.114	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.055	fbmy5635_rel_202305292102.cza1_gcp_c2s30
74.301	24.676	1.023	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.050	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
65.731	30.039	4.230	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.052	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
66.752	30.003	3.245	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.047	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
66.840	29.441	3.719	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.055	fbmy5635_rel_221222.cza1_gcp_c2s30

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	5.359	90.380	4.260	0.000	0.000	0.000	0.000	0.000	0.000	0.013	fbmy5635_rel_202104072149.cza1_gcp_c2s30
0.000	3.109	88.130	8.755	0.005	0.000	0.000	0.000	0.000	0.000	0.018	fbmy5635_rel_202203072101.cza1_gcp_c2s30
0.000	2.469	91.661	5.854	0.016	0.000	0.000	0.000	0.000	0.000	0.017	fbmy5635_rel_202205192101.cza1_gcp_c2s30
0.000	2.625	91.901	5.469	0.005	0.000	0.000	0.000	0.000	0.000	0.017	fbmy5635_rel_202208092101.cza1_gcp_c2s30
0.000	1.724	84.203	14.073	0.000	0.000	0.000	0.000	0.000	0.000	0.013	fbmy5635_rel_202210112144.cza1_gcp_c2s30
0.000	5.656	93.953	0.391	0.000	0.000	0.000	0.000	0.000	0.000	0.013	fbmy5635_rel_202302162102.cza1_gcp_c2s30
0.000	4.432	93.120	2.448	0.000	0.000	0.000	0.000	0.000	0.000	0.010	fbmy5635_rel_202304122154.cza1_gcp_c2s30
0.000	1.427	83.870	14.703	0.000	0.000	0.000	0.000	0.000	0.000	0.013	fbmy5635_rel_202305292102.cza1_gcp_c2s30
0.000	1.656	89.500	8.844	0.000	0.000	0.000	0.000	0.000	0.000	0.013	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
0.000	3.833	92.427	3.724	0.016	0.000	0.000	0.000	0.000	0.000	0.018	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
0.000	5.135	94.474	0.391	0.000	0.000	0.000	0.000	0.000	0.000	0.006	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
0.000	2.474	93.229	4.276	0.021	0.000	0.000	0.000	0.000	0.000	0.042	fbmy5635_rel_221222.cza1_gcp_c2s30

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	5.104	90.417	4.479	0.000	0.000	0.000	0.000	0.000	0.000	0.009	fbmy5635_rel_202104072149.cza1_gcp_c2s30
0.000	4.427	86.969	8.604	0.000	0.000	0.000	0.000	0.000	0.000	0.009	fbmy5635_rel_202203072101.cza1_gcp_c2s30
0.000	4.052	90.604	5.323	0.021	0.000	0.000	0.000	0.000	0.000	0.022	fbmy5635_rel_202205192101.cza1_gcp_c2s30
0.000	4.089	90.443	5.469	0.000	0.000	0.000	0.000	0.000	0.000	0.007	fbmy5635_rel_202208092101.cza1_gcp_c2s30
0.000	2.536	83.672	13.792	0.000	0.000	0.000	0.000	0.000	0.000	0.013	fbmy5635_rel_202210112144.cza1_gcp_c2s30
0.000	5.870	93.693	0.438	0.000	0.000	0.000	0.000	0.000	0.000	0.006	fbmy5635_rel_202302162102.cza1_gcp_c2s30
0.000	4.953	92.521	2.526	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202304122154.cza1_gcp_c2s30
0.000	2.901	82.271	14.828	0.000	0.000	0.000	0.000	0.000	0.000	0.013	fbmy5635_rel_202305292102.cza1_gcp_c2s30
0.000	2.172	88.562	9.255	0.010	0.000	0.000	0.000	0.000	0.000	0.016	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
0.000	4.240	91.724	4.026	0.010	0.000	0.000	0.000	0.000	0.000	0.017	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
0.000	6.417	93.167	0.417	0.000	0.000	0.000	0.000	0.000	0.000	0.006	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
0.000	2.708	93.016	4.255	0.021	0.000	0.000	0.000	0.000	0.000	0.042	fbmy5635_rel_221222.cza1_gcp_c2s30

qp100.L2

qp100.L2: point queries with 100 insert/s per client
Legend for results is here.
Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
86.289	13.710	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.018	fbmy5635_rel_202104072149.cza1_gcp_c2s30
79.954	20.045	0.001	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.018	fbmy5635_rel_202203072101.cza1_gcp_c2s30
77.391	22.608	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.019	fbmy5635_rel_202205192101.cza1_gcp_c2s30
78.789	21.210	0.001	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.019	fbmy5635_rel_202208092101.cza1_gcp_c2s30
75.621	24.377	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.019	fbmy5635_rel_202210112144.cza1_gcp_c2s30
88.929	11.069	0.001	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.030	fbmy5635_rel_202302162102.cza1_gcp_c2s30
85.176	14.822	0.001	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.019	fbmy5635_rel_202304122154.cza1_gcp_c2s30
83.474	16.524	0.001	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.024	fbmy5635_rel_202305292102.cza1_gcp_c2s30
85.499	14.499	0.001	nonzero	0.001	0.000	0.000	0.000	0.000	0.000	0.035	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
79.256	20.742	0.001	nonzero	0.001	0.000	0.000	0.000	0.000	0.000	0.020	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
81.142	18.856	0.001	nonzero	0.001	0.000	0.000	0.000	0.000	0.000	0.032	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
81.240	18.758	0.001	nonzero	0.001	0.000	0.000	0.000	0.000	0.000	0.033	fbmy5635_rel_221222.cza1_gcp_c2s30

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	2.292	82.479	15.224	0.005	0.000	0.000	0.000	0.000	0.000	0.017	fbmy5635_rel_202104072149.cza1_gcp_c2s30
0.000	3.375	96.151	0.458	0.016	0.000	0.000	0.000	0.000	0.000	0.018	fbmy5635_rel_202203072101.cza1_gcp_c2s30
0.000	3.042	96.078	0.786	0.094	0.000	0.000	0.000	0.000	0.000	0.024	fbmy5635_rel_202205192101.cza1_gcp_c2s30
0.000	1.318	96.370	2.240	0.073	0.000	0.000	0.000	0.000	0.000	0.026	fbmy5635_rel_202208092101.cza1_gcp_c2s30
0.000	0.391	61.172	38.401	0.036	0.000	0.000	0.000	0.000	0.000	0.019	fbmy5635_rel_202210112144.cza1_gcp_c2s30
0.000	0.865	89.906	9.224	0.005	0.000	0.000	0.000	0.000	0.000	0.017	fbmy5635_rel_202302162102.cza1_gcp_c2s30
0.000	1.349	89.333	9.312	0.005	0.000	0.000	0.000	0.000	0.000	0.017	fbmy5635_rel_202304122154.cza1_gcp_c2s30
0.000	1.891	91.469	6.641	0.000	0.000	0.000	0.000	0.000	0.000	0.011	fbmy5635_rel_202305292102.cza1_gcp_c2s30
0.000	0.833	71.812	27.354	0.000	0.000	0.000	0.000	0.000	0.000	0.014	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
0.000	0.839	82.542	16.620	0.000	0.000	0.000	0.000	0.000	0.000	0.009	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
0.000	1.297	86.828	11.849	0.026	0.000	0.000	0.000	0.000	0.000	0.018	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
0.000	1.396	84.245	14.359	0.000	0.000	0.000	0.000	0.000	0.000	0.014	fbmy5635_rel_221222.cza1_gcp_c2s30

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	2.490	82.229	15.255	0.021	0.005	0.000	0.000	0.000	0.000	0.114	fbmy5635_rel_202104072149.cza1_gcp_c2s30
0.000	4.974	94.542	0.469	0.016	0.000	0.000	0.000	0.000	0.000	0.018	fbmy5635_rel_202203072101.cza1_gcp_c2s30
0.000	4.870	94.188	0.844	0.094	0.005	0.000	0.000	0.000	0.000	0.139	fbmy5635_rel_202205192101.cza1_gcp_c2s30
0.000	2.099	95.542	2.281	0.078	0.000	0.000	0.000	0.000	0.000	0.025	fbmy5635_rel_202208092101.cza1_gcp_c2s30
0.000	0.714	61.745	37.510	0.031	0.000	0.000	0.000	0.000	0.000	0.020	fbmy5635_rel_202210112144.cza1_gcp_c2s30
0.000	2.062	89.328	8.609	0.000	0.000	0.000	0.000	0.000	0.000	0.014	fbmy5635_rel_202302162102.cza1_gcp_c2s30
0.000	2.594	89.422	7.984	0.000	0.000	0.000	0.000	0.000	0.000	0.008	fbmy5635_rel_202304122154.cza1_gcp_c2s30
0.000	4.328	89.396	6.276	0.000	0.000	0.000	0.000	0.000	0.000	0.009	fbmy5635_rel_202305292102.cza1_gcp_c2s30
0.000	1.266	71.901	26.828	0.005	0.000	0.000	0.000	0.000	0.000	0.016	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
0.000	1.281	83.073	15.646	0.000	0.000	0.000	0.000	0.000	0.000	0.011	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
0.000	2.750	86.156	11.073	0.021	0.000	0.000	0.000	0.000	0.000	0.018	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
0.000	2.573	82.979	14.448	0.000	0.000	0.000	0.000	0.000	0.000	0.014	fbmy5635_rel_221222.cza1_gcp_c2s30

qr500.L3

qr500.L3: range queries with 500 insert/s per client
Legend for results is here.
Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
64.742	32.427	2.830	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.133	fbmy5635_rel_202104072149.cza1_gcp_c2s30
63.974	33.409	2.616	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.133	fbmy5635_rel_202203072101.cza1_gcp_c2s30
64.296	32.593	3.110	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.114	fbmy5635_rel_202205192101.cza1_gcp_c2s30
63.702	33.654	2.643	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.135	fbmy5635_rel_202208092101.cza1_gcp_c2s30
64.479	32.000	3.520	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.123	fbmy5635_rel_202210112144.cza1_gcp_c2s30
66.027	31.449	2.524	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.075	fbmy5635_rel_202302162102.cza1_gcp_c2s30
65.418	32.133	2.449	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.026	fbmy5635_rel_202304122154.cza1_gcp_c2s30
65.251	31.920	2.828	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.066	fbmy5635_rel_202305292102.cza1_gcp_c2s30
65.402	32.460	2.137	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.074	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
65.750	30.242	4.008	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.071	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
65.827	28.720	5.452	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.060	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
64.927	31.473	3.599	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.070	fbmy5635_rel_221222.cza1_gcp_c2s30

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	2.618	57.758	39.551	0.073	0.000	0.000	0.000	0.000	0.000	0.022	fbmy5635_rel_202104072149.cza1_gcp_c2s30
0.000	1.927	52.789	45.238	0.047	0.000	0.000	0.000	0.000	0.000	0.024	fbmy5635_rel_202203072101.cza1_gcp_c2s30
0.000	1.182	52.126	46.640	0.052	0.000	0.000	0.000	0.000	0.000	0.023	fbmy5635_rel_202205192101.cza1_gcp_c2s30
0.000	0.741	47.740	51.447	0.073	0.000	0.000	0.000	0.000	0.000	0.025	fbmy5635_rel_202208092101.cza1_gcp_c2s30
0.000	1.266	52.264	46.427	0.044	0.000	0.000	0.000	0.000	0.000	0.024	fbmy5635_rel_202210112144.cza1_gcp_c2s30
0.000	2.618	52.150	45.197	0.035	0.000	0.000	0.000	0.000	0.000	0.020	fbmy5635_rel_202302162102.cza1_gcp_c2s30
0.000	1.380	52.194	46.402	0.024	0.000	0.000	0.000	0.000	0.000	0.021	fbmy5635_rel_202304122154.cza1_gcp_c2s30
0.000	2.110	54.319	43.526	0.045	0.000	0.000	0.000	0.000	0.000	0.026	fbmy5635_rel_202305292102.cza1_gcp_c2s30
0.000	0.678	48.846	50.446	0.030	0.000	0.000	0.000	0.000	0.000	0.021	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
0.000	2.704	57.936	39.329	0.030	0.000	0.000	0.000	0.000	0.000	0.022	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
0.000	2.908	58.251	38.783	0.057	0.000	0.000	0.000	0.000	0.000	0.020	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
0.000	2.191	58.028	39.740	0.042	0.000	0.000	0.000	0.000	0.000	0.021	fbmy5635_rel_221222.cza1_gcp_c2s30

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	2.735	57.768	39.434	0.062	0.000	0.000	0.000	0.000	0.000	0.021	fbmy5635_rel_202104072149.cza1_gcp_c2s30
0.000	2.330	53.211	44.407	0.051	0.000	0.000	0.000	0.000	0.000	0.026	fbmy5635_rel_202203072101.cza1_gcp_c2s30
0.000	1.565	52.357	46.021	0.056	0.001	0.000	0.000	0.000	0.000	0.082	fbmy5635_rel_202205192101.cza1_gcp_c2s30
0.000	0.965	48.470	50.506	0.059	0.000	0.000	0.000	0.000	0.000	0.028	fbmy5635_rel_202208092101.cza1_gcp_c2s30
0.000	2.273	52.658	45.024	0.045	0.000	0.000	0.000	0.000	0.000	0.022	fbmy5635_rel_202210112144.cza1_gcp_c2s30
0.000	2.573	52.278	45.121	0.028	0.000	0.000	0.000	0.000	0.000	0.028	fbmy5635_rel_202302162102.cza1_gcp_c2s30
0.000	1.692	52.649	45.635	0.024	0.000	0.000	0.000	0.000	0.000	0.023	fbmy5635_rel_202304122154.cza1_gcp_c2s30
0.000	2.404	54.977	42.582	0.036	0.000	0.000	0.000	0.000	0.000	0.027	fbmy5635_rel_202305292102.cza1_gcp_c2s30
0.000	0.833	49.055	50.080	0.031	0.000	0.000	0.000	0.000	0.000	0.022	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
0.000	2.995	57.913	39.068	0.025	0.000	0.000	0.000	0.000	0.000	0.020	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
0.000	3.358	58.791	37.797	0.054	0.000	0.000	0.000	0.000	0.000	0.021	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
0.000	2.323	58.329	39.307	0.041	0.000	0.000	0.000	0.000	0.000	0.020	fbmy5635_rel_221222.cza1_gcp_c2s30

qp500.L4

qp500.L4: point queries with 500 insert/s per client
Legend for results is here.
Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
47.934	52.039	0.025	0.001	0.001	0.000	0.000	0.000	0.000	0.000	0.040	fbmy5635_rel_202104072149.cza1_gcp_c2s30
38.319	61.652	0.027	0.001	0.001	0.000	0.000	0.000	0.000	0.000	0.049	fbmy5635_rel_202203072101.cza1_gcp_c2s30
39.220	60.755	0.022	0.001	0.002	0.000	0.000	0.000	0.000	0.000	0.040	fbmy5635_rel_202205192101.cza1_gcp_c2s30
36.130	63.840	0.028	0.001	0.002	0.000	0.000	0.000	0.000	0.000	0.050	fbmy5635_rel_202208092101.cza1_gcp_c2s30
35.596	64.373	0.028	0.001	0.002	0.000	0.000	0.000	0.000	0.000	0.064	fbmy5635_rel_202210112144.cza1_gcp_c2s30
74.117	25.871	0.011	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.025	fbmy5635_rel_202302162102.cza1_gcp_c2s30
66.917	33.072	0.011	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.015	fbmy5635_rel_202304122154.cza1_gcp_c2s30
63.037	36.950	0.013	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.026	fbmy5635_rel_202305292102.cza1_gcp_c2s30
65.261	34.726	0.013	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.012	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
57.261	42.724	0.014	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.024	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
61.957	38.029	0.014	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.015	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
61.325	38.661	0.014	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.027	fbmy5635_rel_221222.cza1_gcp_c2s30

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.964	57.503	41.242	0.283	0.008	0.000	0.000	0.000	0.000	0.091	fbmy5635_rel_202104072149.cza1_gcp_c2s30
0.000	0.314	43.705	55.668	0.306	0.007	0.000	0.000	0.000	0.000	0.080	fbmy5635_rel_202203072101.cza1_gcp_c2s30
0.000	0.299	48.924	50.485	0.292	0.000	0.000	0.000	0.000	0.000	0.025	fbmy5635_rel_202205192101.cza1_gcp_c2s30
0.000	0.147	40.763	58.513	0.578	0.000	0.000	0.000	0.000	0.000	0.048	fbmy5635_rel_202208092101.cza1_gcp_c2s30
0.000	0.253	48.830	50.634	0.282	0.000	0.000	0.000	0.000	0.000	0.046	fbmy5635_rel_202210112144.cza1_gcp_c2s30
0.000	0.578	50.408	48.950	0.064	0.000	0.000	0.000	0.000	0.000	0.026	fbmy5635_rel_202302162102.cza1_gcp_c2s30
0.000	0.689	47.246	51.953	0.112	0.000	0.000	0.000	0.000	0.000	0.041	fbmy5635_rel_202304122154.cza1_gcp_c2s30
0.000	0.634	48.036	51.258	0.071	0.000	0.000	0.000	0.000	0.000	0.025	fbmy5635_rel_202305292102.cza1_gcp_c2s30
0.000	0.647	51.594	47.696	0.064	0.000	0.000	0.000	0.000	0.000	0.021	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
0.000	0.535	44.654	54.712	0.098	0.000	0.000	0.000	0.000	0.000	0.036	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
0.000	0.545	47.367	52.007	0.081	0.000	0.000	0.000	0.000	0.000	0.025	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
0.000	0.449	43.562	55.925	0.064	0.000	0.000	0.000	0.000	0.000	0.024	fbmy5635_rel_221222.cza1_gcp_c2s30

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	1.269	57.716	40.728	0.277	0.010	0.000	0.000	0.000	0.000	0.101	fbmy5635_rel_202104072149.cza1_gcp_c2s30
0.000	0.487	44.585	54.605	0.314	0.008	0.000	0.000	0.000	0.000	0.079	fbmy5635_rel_202203072101.cza1_gcp_c2s30
0.000	0.579	49.728	49.416	0.276	0.001	0.000	0.000	0.000	0.000	0.065	fbmy5635_rel_202205192101.cza1_gcp_c2s30
0.000	0.302	41.427	57.733	0.535	0.002	0.000	0.000	0.000	0.000	0.115	fbmy5635_rel_202208092101.cza1_gcp_c2s30
0.000	0.505	49.779	49.426	0.287	0.002	0.000	0.000	0.000	0.000	0.122	fbmy5635_rel_202210112144.cza1_gcp_c2s30
0.000	0.758	51.126	48.041	0.075	0.000	0.000	0.000	0.000	0.000	0.027	fbmy5635_rel_202302162102.cza1_gcp_c2s30
0.000	0.992	48.268	50.632	0.107	0.001	0.000	0.000	0.000	0.000	0.068	fbmy5635_rel_202304122154.cza1_gcp_c2s30
0.000	1.001	49.367	49.553	0.079	0.000	0.000	0.000	0.000	0.000	0.025	fbmy5635_rel_202305292102.cza1_gcp_c2s30
0.000	0.941	52.575	46.420	0.065	0.000	0.000	0.000	0.000	0.000	0.022	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
0.000	0.751	45.579	53.579	0.091	0.000	0.000	0.000	0.000	0.000	0.039	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
0.000	0.931	48.432	50.566	0.071	0.000	0.000	0.000	0.000	0.000	0.025	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
0.000	0.694	44.695	54.538	0.074	0.000	0.000	0.000	0.000	0.000	0.025	fbmy5635_rel_221222.cza1_gcp_c2s30

qr1000.L5

qr1000.L5: range queries with 1000 insert/s per client
Legend for results is here.
Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
61.692	35.774	2.533	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.129	fbmy5635_rel_202104072149.cza1_gcp_c2s30
60.735	34.691	4.573	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.133	fbmy5635_rel_202203072101.cza1_gcp_c2s30
60.049	35.755	4.195	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.136	fbmy5635_rel_202205192101.cza1_gcp_c2s30
59.756	37.968	2.275	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.135	fbmy5635_rel_202208092101.cza1_gcp_c2s30
59.677	36.896	3.425	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.119	fbmy5635_rel_202210112144.cza1_gcp_c2s30
63.554	30.476	5.969	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.081	fbmy5635_rel_202302162102.cza1_gcp_c2s30
61.450	34.041	4.507	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.075	fbmy5635_rel_202304122154.cza1_gcp_c2s30
61.080	31.919	6.999	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.076	fbmy5635_rel_202305292102.cza1_gcp_c2s30
60.892	34.436	4.670	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.078	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
60.706	35.202	4.090	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.078	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
61.632	33.902	4.465	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.083	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
60.789	31.946	7.263	0.002	nonzero	nonzero	0.000	0.000	0.000	0.000	0.075	fbmy5635_rel_221222.cza1_gcp_c2s30

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	1.233	41.579	57.089	0.099	0.000	0.000	0.000	0.000	0.000	0.032	fbmy5635_rel_202104072149.cza1_gcp_c2s30
0.000	0.663	42.891	56.304	0.142	0.000	0.000	0.000	0.000	0.000	0.034	fbmy5635_rel_202203072101.cza1_gcp_c2s30
0.000	0.449	40.472	58.870	0.208	0.000	0.000	0.000	0.000	0.000	0.035	fbmy5635_rel_202205192101.cza1_gcp_c2s30
0.000	0.389	38.742	60.695	0.175	0.000	0.000	0.000	0.000	0.000	0.024	fbmy5635_rel_202208092101.cza1_gcp_c2s30
0.000	0.405	41.673	57.652	0.269	0.000	0.000	0.000	0.000	0.000	0.034	fbmy5635_rel_202210112144.cza1_gcp_c2s30
0.000	1.230	42.084	56.608	0.078	0.000	0.000	0.000	0.000	0.000	0.034	fbmy5635_rel_202302162102.cza1_gcp_c2s30
0.000	0.950	41.653	57.316	0.082	0.000	0.000	0.000	0.000	0.000	0.026	fbmy5635_rel_202304122154.cza1_gcp_c2s30
0.000	0.938	40.104	58.893	0.065	0.000	0.000	0.000	0.000	0.000	0.025	fbmy5635_rel_202305292102.cza1_gcp_c2s30
0.000	0.818	42.033	57.091	0.058	0.000	0.000	0.000	0.000	0.000	0.031	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
0.000	1.030	44.033	54.849	0.088	0.000	0.000	0.000	0.000	0.000	0.026	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
0.000	0.965	41.735	57.173	0.127	0.000	0.000	0.000	0.000	0.000	0.028	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
0.000	1.091	44.479	54.348	0.082	0.000	0.000	0.000	0.000	0.000	0.030	fbmy5635_rel_221222.cza1_gcp_c2s30

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	1.304	41.880	56.715	0.101	0.001	0.000	0.000	0.000	0.000	0.102	fbmy5635_rel_202104072149.cza1_gcp_c2s30
0.000	0.862	43.565	55.433	0.140	0.001	0.000	0.000	0.000	0.000	0.095	fbmy5635_rel_202203072101.cza1_gcp_c2s30
0.000	0.642	41.190	57.957	0.210	0.002	0.000	0.000	0.000	0.000	0.091	fbmy5635_rel_202205192101.cza1_gcp_c2s30
0.000	0.668	39.483	59.666	0.182	0.002	0.000	0.000	0.000	0.000	0.097	fbmy5635_rel_202208092101.cza1_gcp_c2s30
0.000	0.615	42.492	56.625	0.267	0.001	0.000	0.000	0.000	0.000	0.128	fbmy5635_rel_202210112144.cza1_gcp_c2s30
0.000	1.360	42.607	55.961	0.071	0.000	0.000	0.000	0.000	0.000	0.061	fbmy5635_rel_202302162102.cza1_gcp_c2s30
0.000	1.082	42.356	56.481	0.081	0.000	0.000	0.000	0.000	0.000	0.028	fbmy5635_rel_202304122154.cza1_gcp_c2s30
0.000	1.213	40.779	57.938	0.070	0.000	0.000	0.000	0.000	0.000	0.027	fbmy5635_rel_202305292102.cza1_gcp_c2s30
0.000	0.953	42.256	56.722	0.068	0.001	0.000	0.000	0.000	0.000	0.072	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
0.000	1.075	44.658	54.174	0.091	0.001	0.000	0.000	0.000	0.000	0.073	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
0.000	1.216	42.455	56.198	0.131	0.000	0.000	0.000	0.000	0.000	0.028	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
0.000	1.169	45.075	53.674	0.082	0.001	0.000	0.000	0.000	0.000	0.068	fbmy5635_rel_221222.cza1_gcp_c2s30

qp1000.L6

qp1000.L6: point queries with 1000 insert/s per client
Legend for results is here.
Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
29.579	70.322	0.096	0.002	nonzero	0.000	0.000	0.000	0.000	0.000	0.025	fbmy5635_rel_202104072149.cza1_gcp_c2s30
21.877	78.016	0.104	0.003	nonzero	0.000	0.000	0.000	0.000	0.000	0.037	fbmy5635_rel_202203072101.cza1_gcp_c2s30
19.742	80.152	0.103	0.003	nonzero	0.000	0.000	0.000	0.000	0.000	0.050	fbmy5635_rel_202205192101.cza1_gcp_c2s30
21.800	78.136	0.062	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.025	fbmy5635_rel_202208092101.cza1_gcp_c2s30
17.833	82.050	0.114	0.003	nonzero	0.000	0.000	0.000	0.000	0.000	0.026	fbmy5635_rel_202210112144.cza1_gcp_c2s30
48.889	51.057	0.052	0.001	0.001	0.000	0.000	0.000	0.000	0.000	0.042	fbmy5635_rel_202302162102.cza1_gcp_c2s30
39.094	60.855	0.049	0.001	0.001	0.000	0.000	0.000	0.000	0.000	0.040	fbmy5635_rel_202304122154.cza1_gcp_c2s30
36.892	63.055	0.051	0.001	0.002	0.000	0.000	0.000	0.000	0.000	0.041	fbmy5635_rel_202305292102.cza1_gcp_c2s30
39.947	59.999	0.051	0.001	0.002	0.000	0.000	0.000	0.000	0.000	0.043	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
30.142	69.808	0.048	0.001	0.001	0.000	0.000	0.000	0.000	0.000	0.042	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
33.883	66.063	0.051	0.001	0.002	0.000	0.000	0.000	0.000	0.000	0.042	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
36.933	63.014	0.051	0.001	0.002	0.000	0.000	0.000	0.000	0.000	0.042	fbmy5635_rel_221222.cza1_gcp_c2s30

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.538	46.343	52.699	0.420	0.000	0.000	0.000	0.000	0.000	0.037	fbmy5635_rel_202104072149.cza1_gcp_c2s30
0.000	0.261	43.196	56.145	0.398	0.000	0.000	0.000	0.000	0.000	0.038	fbmy5635_rel_202203072101.cza1_gcp_c2s30
0.000	0.156	39.347	60.018	0.479	0.000	0.000	0.000	0.000	0.000	0.043	fbmy5635_rel_202205192101.cza1_gcp_c2s30
0.000	0.332	73.802	25.783	0.083	0.000	0.000	0.000	0.000	0.000	0.049	fbmy5635_rel_202208092101.cza1_gcp_c2s30
0.000	0.105	44.586	54.962	0.347	0.000	0.000	0.000	0.000	0.000	0.041	fbmy5635_rel_202210112144.cza1_gcp_c2s30
0.000	0.469	39.526	59.901	0.104	0.000	0.000	0.000	0.000	0.000	0.043	fbmy5635_rel_202302162102.cza1_gcp_c2s30
0.000	0.408	41.986	57.571	0.035	0.000	0.000	0.000	0.000	0.000	0.038	fbmy5635_rel_202304122154.cza1_gcp_c2s30
0.000	0.264	40.731	58.944	0.062	0.000	0.000	0.000	0.000	0.000	0.045	fbmy5635_rel_202305292102.cza1_gcp_c2s30
0.000	0.320	41.716	57.872	0.092	0.000	0.000	0.000	0.000	0.000	0.040	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
0.000	0.320	43.453	56.170	0.058	0.000	0.000	0.000	0.000	0.000	0.041	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
0.000	0.361	43.169	56.397	0.072	0.000	0.000	0.000	0.000	0.000	0.041	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
0.000	0.452	41.249	58.217	0.081	0.000	0.000	0.000	0.000	0.000	0.040	fbmy5635_rel_221222.cza1_gcp_c2s30

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.576	47.043	51.958	0.422	0.001	0.000	0.000	0.000	0.000	0.158	fbmy5635_rel_202104072149.cza1_gcp_c2s30
0.000	0.430	44.342	54.833	0.393	0.002	0.000	0.000	0.000	0.000	0.123	fbmy5635_rel_202203072101.cza1_gcp_c2s30
0.000	0.332	40.447	58.762	0.456	0.002	0.000	0.000	0.000	0.000	0.111	fbmy5635_rel_202205192101.cza1_gcp_c2s30
0.000	0.645	74.535	24.735	0.084	0.001	0.000	0.000	0.000	0.000	0.119	fbmy5635_rel_202208092101.cza1_gcp_c2s30
0.000	0.246	46.045	53.367	0.339	0.004	0.000	0.000	0.000	0.000	0.152	fbmy5635_rel_202210112144.cza1_gcp_c2s30
0.000	0.752	40.122	59.032	0.093	0.001	0.000	0.000	0.000	0.000	0.077	fbmy5635_rel_202302162102.cza1_gcp_c2s30
0.000	0.847	43.260	55.847	0.045	0.000	0.000	0.000	0.000	0.000	0.041	fbmy5635_rel_202304122154.cza1_gcp_c2s30
0.000	0.652	42.130	57.158	0.060	0.001	0.000	0.000	0.000	0.000	0.076	fbmy5635_rel_202305292102.cza1_gcp_c2s30
0.000	0.540	42.573	56.784	0.102	0.001	0.000	0.000	0.000	0.000	0.073	fbmy5635_rel_20230529_832.cza1_gcp_c2s30
0.000	0.609	44.609	54.719	0.062	0.001	0.000	0.000	0.000	0.000	0.068	fbmy5635_rel_20230529_843.cza1_gcp_c2s30
0.000	0.601	44.285	55.037	0.077	0.001	0.000	0.000	0.000	0.000	0.067	fbmy5635_rel_20230529_850.cza1_gcp_c2s30
0.000	0.683	42.282	56.954	0.081	0.000	0.000	0.000	0.000	0.000	0.044	fbmy5635_rel_221222.cza1_gcp_c2s30

Introduction

Contents

Summary

l.i0

l.x

l.i1

l.i2

qr100.L1

qp100.L2

qr500.L3

qp500.L4

qr1000.L5

qp1000.L6

l.i0

l.x

l.i1

l.i2

qr100.L1

qp100.L2

qr500.L3

qp500.L4

qr1000.L5

qp1000.L6

l.i0

l.x

l.i1

l.i2

qr100.L1

qp100.L2

qr500.L3

qp500.L4

qr1000.L5

qp1000.L6