Introduction

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

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

The tested DBMS are:

my5651_rel.cz11a_c8r32 - MySQL 5.6.51 with the cz11a_c8r32 config
my5744_rel.cz11a_c8r32 - MySQL 5.7.44 with the cz11a_c8r32 config
my8028_rel.cz11a_c8r32 - MySQL 8.0.28 with the cz11a_c8r32 config
my8032_rel.cz11a_c8r32 - MySQL 8.0.32 with the cz11a_c8r32 config
my8036_rel.cz11a_c8r32 - MySQL 8.0.36 with the cz11a_c8r32 config
my8037_rel.cz11a_c8r32 - MySQL 8.0.37 with the cz11a_c8r32 config
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32 - MyRocks 5.6.35 with the cza1_c8r32 config compiled at git sha 4f3a57a1 on 240606 using RocksDB 8.7.0
fbmy8028_rel_240606_c6c83b18.cza1_c8r32 - MyRocks 8.0.28 with the cza1_c8r32 config compiled at git sha c6c83b18 on 240606 using RocksDB 8.7.0
fbmy8032_rel_240606_59f03d5a.cza1_c8r32 - MyRocks 8.0.36 with the cza1_c8r32 config compiled at git sha 59f03d5a on 240606 using RocksDB 9.3.1

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
my5651_rel.cz11a_c8r32	172414	143541	32949	21739	10749	8804	10647	8778	10843	8833
my5744_rel.cz11a_c8r32	153061	223881	34843	21882	8954	7627	9040	7575	8975	7553
my8028_rel.cz11a_c8r32	119048	300001	35971	20000	7731	6547	7729	6567	7764	6505
my8032_rel.cz11a_c8r32	104895	277779	31898	18248	7235	6051	7207	6018	7176	6024
my8036_rel.cz11a_c8r32	103093	260870	32128	18248	8177	6080	8159	6105	8110	6108
my8037_rel.cz11a_c8r32	105263	280375	32284	18349	8056	6133	8084	6058	8075	6075
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	145631	156250	45045	17575	3204	5682	2902	5691	3740	5637
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	102389	136364	39331	15873	4477	5059	3258	5074	3401	5085
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	96463	133929	41408	15504	2586	4961	2913	4925	3111	4960

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
my5651_rel.cz11a_c8r32	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00
my5744_rel.cz11a_c8r32	0.89	1.56	1.06	1.01	0.83	0.87	0.85	0.86	0.83	0.86
my8028_rel.cz11a_c8r32	0.69	2.09	1.09	0.92	0.72	0.74	0.73	0.75	0.72	0.74
my8032_rel.cz11a_c8r32	0.61	1.94	0.97	0.84	0.67	0.69	0.68	0.69	0.66	0.68
my8036_rel.cz11a_c8r32	0.60	1.82	0.98	0.84	0.76	0.69	0.77	0.70	0.75	0.69
my8037_rel.cz11a_c8r32	0.61	1.95	0.98	0.84	0.75	0.70	0.76	0.69	0.74	0.69
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	0.84	1.09	1.37	0.81	0.30	0.65	0.27	0.65	0.34	0.64
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	0.59	0.95	1.19	0.73	0.42	0.57	0.31	0.58	0.31	0.58
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	0.56	0.93	1.26	0.71	0.24	0.56	0.27	0.56	0.29	0.56

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
my5651_rel.cz11a_c8r32	100	100	499	499	999	999
my5744_rel.cz11a_c8r32	100	100	499	499	999	999
my8028_rel.cz11a_c8r32	100	100	499	499	999	999
my8032_rel.cz11a_c8r32	100	100	499	499	999	999
my8036_rel.cz11a_c8r32	100	100	499	499	999	999
my8037_rel.cz11a_c8r32	100	100	499	499	999	999
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	100	100	499	499	999	999
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	100	100	499	499	999	999
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	100	100	499	499	999	999
target	100	100	500	500	1000	1000

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	max
my5651_rel.cz11a_c8r32	99.264	0.673	0.048	0.014	0.001	0.152
my5744_rel.cz11a_c8r32	99.535	0.198	0.137	0.130	0.001	0.090
my8028_rel.cz11a_c8r32	99.285	0.344	0.239	0.131	0.002	0.091
my8032_rel.cz11a_c8r32	98.608	0.995	0.263	0.133	0.002	0.082
my8036_rel.cz11a_c8r32	96.662	2.937	0.263	0.137	0.002	0.082
my8037_rel.cz11a_c8r32	98.545	1.059	0.255	0.139	0.002	0.082
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	99.808	0.120	0.069		0.003	0.115
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	95.754	4.045	0.145	0.052	0.004	0.147
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	78.877	20.915	0.148	0.056	0.004	0.106

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
172414	0	0	0.0	2.1	0.0	0.000	0.000	0.000	0.000	19696	20.8	0.114	10	2.0	32.5	3.3	0.152	176105	110068	my5651_rel.cz11a_c8r32
153061	0	0	0.0	1.8	0.0	0.000	0.000	0.000	0.000	15336	20.6	0.100	11	2.0	32.5	3.8	0.090	154033	140650	my5744_rel.cz11a_c8r32
119048	0	0	0.0	1.6	0.0	0.000	0.000	0.000	0.000	12868	18.7	0.108	13	2.0	32.6	4.0	0.091	120071	103986	my8028_rel.cz11a_c8r32
104895	0	0	0.0	1.6	0.0	0.000	0.000	0.000	0.000	11765	17.8	0.112	14	2.0	32.6	4.1	0.082	106384	93698	my8032_rel.cz11a_c8r32
103093	0	0	0.0	1.9	0.0	0.000	0.000	0.000	0.000	11557	17.8	0.112	14	2.0	32.6	4.0	0.082	103886	87911	my8036_rel.cz11a_c8r32
105263	0	0	0.0	1.4	0.0	0.000	0.000	0.000	0.000	11762	17.9	0.112	14	2.0	32.6	4.1	0.082	106084	94099	my8037_rel.cz11a_c8r32
145631	0	1	0.0	1.0	0.0	0.000	0.000	0.000	0.000	15051	21.9	0.103	12	1.0	2.5	0.3	0.115	61038	0	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
102389	0	2	0.2	1.3	0.0	0.000	0.002	0.000	0.000	11144	19.0	0.109	15	0.9	2.7	0.6	0.147	102887	86308	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
96463	0	0	0.0	2.0	0.0	0.000	0.000	0.000	0.000	10672	18.8	0.111	16	0.9	2.7	0.6	0.106	96442	83210	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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
143541	0	0	0.0	1.6	0.0	0.000	0.000	0.000	0.000	4319	9.7	0.030	5	4.2	34.7	5.2	0.001	NA	NA	my5651_rel.cz11a_c8r32
223881	0	0	0.0	1.4	0.0	0.000	0.000	0.000	0.000	12782	12.1	0.057	4	4.6	35.1	5.5	0.001	NA	NA	my5744_rel.cz11a_c8r32
300001	0	0	0.0	1.2	0.0	0.000	0.000	0.000	0.000	22256	39.5	0.074	11	4.5	35.1	6.1	0.001	NA	NA	my8028_rel.cz11a_c8r32
277779	0	0	0.0	1.2	0.0	0.000	0.000	0.000	0.000	18397	39.1	0.066	11	4.5	35.1	5.3	0.002	NA	NA	my8032_rel.cz11a_c8r32
260870	0	0	0.0	1.6	0.0	0.000	0.000	0.000	0.000	17205	39.7	0.066	12	4.5	35.1	4.8	0.002	NA	NA	my8036_rel.cz11a_c8r32
280375	0	0	0.0	1.8	0.0	0.000	0.000	0.000	0.000	19419	38.8	0.069	11	4.5	35.1	5.5	0.002	NA	NA	my8037_rel.cz11a_c8r32
156250	0	0	0.0	1.1	0.0	0.000	0.000	0.000	0.000	173	12.2	0.001	6	2.0	3.6	2.3	0.001	NA	NA	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
136364	0	0	0.0	1.0	0.0	0.000	0.000	0.000	0.000	316	11.6	0.002	7	2.0	3.8	2.7	0.002	NA	NA	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
133929	0	0	0.0	1.6	0.0	0.000	0.000	0.000	0.000	515	11.6	0.004	7	2.0	3.8	2.6	0.009	NA	NA	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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
my5651_rel.cz11a_c8r32	10.339	87.672	1.813	0.175	0.001		0.081
my5744_rel.cz11a_c8r32	3.927	94.388	1.644	0.041	0.001		0.093
my8028_rel.cz11a_c8r32	nonzero	98.636	1.294	0.069	0.001		0.094
my8032_rel.cz11a_c8r32		98.280	1.623	0.095	0.001		0.102
my8036_rel.cz11a_c8r32		98.317	1.593	0.089	0.001		0.102
my8037_rel.cz11a_c8r32		98.339	1.575	0.085	0.001	nonzero	0.278
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	86.919	12.983	0.093	0.001	0.004		0.125
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	27.809	71.973	0.165	0.051	0.003		0.147
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	15.724	84.054	0.171	0.047	0.004		0.119

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
my5651_rel.cz11a_c8r32	77.275	21.465	1.121	0.138	0.001		0.080
my5744_rel.cz11a_c8r32	66.862	31.856	1.267	0.015	0.001		0.093
my8028_rel.cz11a_c8r32	93.557	5.391	1.035	0.016	0.001		0.078
my8032_rel.cz11a_c8r32	51.503	47.191	1.277	0.029	0.001		0.108
my8036_rel.cz11a_c8r32	64.976	33.737	1.264	0.022	0.001		0.101
my8037_rel.cz11a_c8r32	65.264	33.476	1.234	0.026	0.001	nonzero	0.284
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	85.878	14.015	0.097	0.007	0.003		0.125
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	32.708	67.065	0.163	0.061	0.003		0.133
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	21.754	78.017	0.168	0.057	0.004		0.126

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
32949	0	0	0.0	1.8	0.0	0.000	0.000	0.000	0.000	36108	40.0	1.096	97	6.2	36.7	7.8	0.081	35012	8990	my5651_rel.cz11a_c8r32
34843	0	0	0.0	1.2	0.0	0.000	0.000	0.000	0.000	25133	45.0	0.721	103	6.3	36.8	8.3	0.093	36261	10439	my5744_rel.cz11a_c8r32
35971	0	0	0.0	1.6	0.0	0.000	0.000	0.000	0.000	45838	35.1	1.274	78	6.7	37.4	9.0	0.094	37708	7941	my8028_rel.cz11a_c8r32
31898	0	0	0.0	1.6	0.0	0.000	0.000	0.000	0.000	45595	35.7	1.429	90	6.6	37.5	9.1	0.102	33614	7299	my8032_rel.cz11a_c8r32
32128	0	0	0.0	1.9	0.0	0.000	0.000	0.000	0.000	45161	35.0	1.406	87	6.6	37.4	9.0	0.102	33896	6643	my8036_rel.cz11a_c8r32
32284	0	0	0.0	1.4	0.0	0.000	0.000	0.000	0.000	45847	35.3	1.420	87	6.6	37.5	9.1	0.278	34013	6642	my8037_rel.cz11a_c8r32
45045	0	1	0.0	1.2	0.0	0.000	0.000	0.000	0.000	20136	42.8	0.447	76	2.3	3.0	7.1	0.125	45749	29130	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
39331	0	0	0.0	1.8	0.0	0.000	0.000	0.000	0.000	18123	41.6	0.461	85	2.5	3.3	7.0	0.147	40605	22225	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
41408	0	0	0.0	1.9	0.0	0.000	0.000	0.000	0.000	19367	44.2	0.468	85	2.3	3.1	7.6	0.119	41505	35312	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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
my5651_rel.cz11a_c8r32	86.693	13.177	0.014	0.112	0.004	nonzero	0.067
my5744_rel.cz11a_c8r32	88.626	11.193	0.054	0.126	0.001	nonzero	0.113
my8028_rel.cz11a_c8r32	84.660	15.226	0.003	0.111	nonzero	nonzero	0.099
my8032_rel.cz11a_c8r32	75.291	24.577	0.004	0.127	0.001	nonzero	0.101
my8036_rel.cz11a_c8r32	75.338	24.528	0.004	0.129	0.001		0.059
my8037_rel.cz11a_c8r32	76.605	23.258	0.004	0.131	0.001	nonzero	0.101
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	98.746	1.222	0.006	0.025	nonzero	0.001	0.079
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	69.098	30.847	0.007	0.040	0.007	0.001	0.109
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	47.310	52.633	0.006	0.043	0.007	nonzero	0.078

dbms	256us	1ms	4ms	16ms	64ms	256ms	max
my5651_rel.cz11a_c8r32	96.933	2.937	0.015	0.112	0.004	nonzero	0.068
my5744_rel.cz11a_c8r32	92.118	7.750	0.009	0.122	0.001	nonzero	0.113
my8028_rel.cz11a_c8r32	95.358	4.535	0.001	0.105	nonzero	nonzero	0.106
my8032_rel.cz11a_c8r32	86.679	13.199	0.001	0.119	0.001	nonzero	0.101
my8036_rel.cz11a_c8r32	87.530	12.345	0.001	0.122	0.001		0.060
my8037_rel.cz11a_c8r32	89.495	10.379	0.001	0.124	0.001	nonzero	0.101
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	95.187	4.781	0.006	0.026	nonzero	0.001	0.079
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	25.125	74.817	0.008	0.042	0.008	nonzero	0.089
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	0.831	99.109	0.008	0.045	0.007	nonzero	0.079

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
21739	0	0	0.0	2.0	0.0	0.000	0.000	0.000	0.001	177487	39.7	8.164	146	6.2	36.7	7.8	0.067	21802	20623	my5651_rel.cz11a_c8r32
21882	0	0	0.0	1.7	0.0	0.000	0.000	0.000	0.001	86924	38.8	3.972	142	6.3	36.8	8.3	0.113	21976	20619	my5744_rel.cz11a_c8r32
20000	0	0	0.0	1.1	0.0	0.000	0.000	0.000	0.000	92176	33.4	4.609	134	6.7	37.4	9.0	0.099	20091	18810	my8028_rel.cz11a_c8r32
18248	0	0	0.0	0.9	0.0	0.000	0.000	0.000	0.000	86263	33.2	4.727	146	6.6	37.5	9.2	0.101	18267	17156	my8032_rel.cz11a_c8r32
18248	0	0	0.0	1.1	0.0	0.000	0.000	0.000	0.000	86169	33.2	4.722	146	6.6	37.4	9.0	0.059	18295	17466	my8036_rel.cz11a_c8r32
18349	0	0	0.0	1.0	0.0	0.000	0.000	0.000	0.000	87349	33.3	4.761	145	6.6	37.5	9.1	0.101	18406	17081	my8037_rel.cz11a_c8r32
17575	0	0	0.0	1.8	0.0	0.000	0.000	0.000	0.001	76727	40.7	4.366	185	2.1	2.3	9.7	0.079	18076	7547	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
15873	0	0	0.0	1.6	0.0	0.000	0.000	0.000	0.001	66510	40.9	4.190	206	2.3	2.7	10.0	0.109	16198	5876	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
15504	0	0	0.0	1.9	0.0	0.000	0.000	0.000	0.001	64822	40.6	4.181	210	2.1	2.5	10.4	0.078	15598	13795	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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	max
my5651_rel.cz11a_c8r32	99.968	0.028	0.002	0.003	nonzero	0.020
my5744_rel.cz11a_c8r32	99.981	0.019	nonzero	nonzero		0.010
my8028_rel.cz11a_c8r32	99.946	0.054	nonzero			0.001
my8032_rel.cz11a_c8r32	99.924	0.076	nonzero			0.002
my8036_rel.cz11a_c8r32	99.961	0.039	nonzero	nonzero		0.012
my8037_rel.cz11a_c8r32	99.966	0.034	nonzero			0.002
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	80.751	14.310	4.939	nonzero	nonzero	0.036
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	80.279	19.721	0.001			0.002
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	66.570	23.063	10.366		nonzero	0.034

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

dbms	1ms	4ms	16ms	64ms	max
my5651_rel.cz11a_c8r32	0.500	49.194	47.250	3.056	0.033
my5744_rel.cz11a_c8r32	0.694	98.833	0.472		0.015
my8028_rel.cz11a_c8r32		99.861	0.139		0.013
my8032_rel.cz11a_c8r32		99.944	0.056		0.012
my8036_rel.cz11a_c8r32		99.583	0.417		0.014
my8037_rel.cz11a_c8r32		99.722	0.278		0.013
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	38.722	60.917	0.361		0.013
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	7.944	91.500	0.500	0.056	0.017
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	2.972	96.667	0.333	0.028	0.023

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
my5651_rel.cz11a_c8r32	3.361	46.167	48.556	1.917	0.034
my5744_rel.cz11a_c8r32	51.333	48.250	0.417		0.013
my8028_rel.cz11a_c8r32	52.222	47.611	0.167		0.010
my8032_rel.cz11a_c8r32	31.250	68.667	0.083		0.008
my8036_rel.cz11a_c8r32	37.389	62.139	0.472		0.014
my8037_rel.cz11a_c8r32	46.806	52.917	0.278		0.008
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	47.583	52.056	0.361		0.013
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	30.917	68.556	0.472	0.056	0.016
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	18.000	81.667	0.306	0.028	0.022

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
100	10749	0	0.0	1.8	0.0	0.000	0.000	0.018	0.118	41738	11.6	3.883	86	6.2	36.7	7.8	0.020	10744	10536	my5651_rel.cz11a_c8r32
100	8954	0	0.0	1.8	0.0	0.000	0.000	0.018	0.118	34866	11.7	3.894	105	6.3	36.8	8.3	0.010	8950	8870	my5744_rel.cz11a_c8r32
100	7731	0	0.0	1.5	0.0	0.000	0.000	0.015	0.091	30347	11.9	3.926	123	6.7	37.4	9.0	0.001	7735	7672	my8028_rel.cz11a_c8r32
100	7235	0	0.0	1.5	0.0	0.000	0.000	0.015	0.092	28664	12.0	3.962	133	6.6	37.5	9.2	0.002	7240	7179	my8032_rel.cz11a_c8r32
100	8177	0	0.0	1.9	0.0	0.000	0.000	0.019	0.125	32205	11.7	3.938	114	6.6	37.4	9.1	0.012	8183	8103	my8036_rel.cz11a_c8r32
100	8056	0	0.0	1.0	0.0	0.000	0.000	0.010	0.067	31716	11.7	3.937	116	6.6	37.5	9.1	0.002	8055	7991	my8037_rel.cz11a_c8r32
100	3204	0	0.0	1.0	0.0	0.000	0.000	0.010	0.073	12375	12.2	3.862	305	2.1	2.2	10.4	0.036	3596	2317	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
100	4477	0	0.0	1.1	0.0	0.000	0.000	0.011	0.081	17358	12.3	3.877	220	2.1	2.3	10.5	0.002	4475	4203	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
100	2586	0	0.0	1.6	0.0	0.000	0.000	0.016	0.104	10336	12.4	3.997	384	2.1	2.4	11.0	0.034	2589	2397	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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	max
my5651_rel.cz11a_c8r32	99.950	0.046	0.001	0.002	0.009
my5744_rel.cz11a_c8r32	99.923	0.077	nonzero		0.002
my8028_rel.cz11a_c8r32	99.840	0.160	nonzero		0.002
my8032_rel.cz11a_c8r32	99.827	0.173	nonzero		0.002
my8036_rel.cz11a_c8r32	99.777	0.223	nonzero		0.002
my8037_rel.cz11a_c8r32	99.831	0.169	nonzero		0.001
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	99.706	0.294	nonzero		0.002
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	99.623	0.377	nonzero		0.004
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	99.573	0.426	nonzero		0.002

dbms	1ms	4ms	16ms	64ms	max
my5651_rel.cz11a_c8r32		55.000	44.611	0.389	0.022
my5744_rel.cz11a_c8r32		99.639	0.361		0.013
my8028_rel.cz11a_c8r32		99.833	0.167		0.014
my8032_rel.cz11a_c8r32		99.861	0.111	0.028	0.023
my8036_rel.cz11a_c8r32		99.722	0.278		0.011
my8037_rel.cz11a_c8r32		99.556	0.444		0.014
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	27.972	71.417	0.611		0.014
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	1.306	98.361	0.278	0.056	0.022
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	1.056	98.667	0.222	0.056	0.022

dbms	1ms	4ms	16ms	64ms	max
my5651_rel.cz11a_c8r32	1.611	53.417	44.722	0.250	0.022
my5744_rel.cz11a_c8r32	37.194	62.472	0.333		0.013
my8028_rel.cz11a_c8r32	33.722	66.139	0.139		0.012
my8032_rel.cz11a_c8r32	0.056	99.778	0.139	0.028	0.023
my8036_rel.cz11a_c8r32	5.667	94.028	0.306		0.007
my8037_rel.cz11a_c8r32	3.611	95.917	0.472		0.007
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	43.278	56.139	0.583		0.013
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	12.861	86.833	0.278	0.028	0.022
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	10.194	89.583	0.194	0.028	0.022

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
100	8804	0	0.0	1.9	0.0	0.000	0.000	0.019	0.118	35334	12.3	4.013	112	6.2	36.7	7.8	0.009	8838	8327	my5651_rel.cz11a_c8r32
100	7627	0	0.0	1.8	0.0	0.000	0.000	0.018	0.115	30771	12.2	4.035	128	6.3	36.8	8.3	0.002	7639	7304	my5744_rel.cz11a_c8r32
100	6547	0	0.0	1.5	0.0	0.000	0.000	0.015	0.096	26505	12.6	4.048	154	6.7	37.4	9.0	0.002	6553	6380	my8028_rel.cz11a_c8r32
100	6051	0	0.0	1.6	0.0	0.000	0.000	0.016	0.098	24691	12.9	4.081	171	6.6	37.5	9.2	0.002	6057	5945	my8032_rel.cz11a_c8r32
100	6080	0	0.0	1.4	0.0	0.000	0.000	0.014	0.098	24798	12.6	4.078	166	6.6	37.5	9.1	0.002	6089	5897	my8036_rel.cz11a_c8r32
100	6133	0	0.0	1.8	0.0	0.000	0.001	0.018	0.122	25015	12.7	4.079	166	6.6	37.5	9.1	0.001	6137	5945	my8037_rel.cz11a_c8r32
100	5682	0	0.0	1.1	0.0	0.000	0.000	0.011	0.082	22869	12.6	4.025	177	2.1	2.2	12.1	0.002	5705	5354	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
100	5059	0	0.0	1.2	0.0	0.000	0.000	0.012	0.102	20457	12.6	4.044	199	2.2	2.4	12.2	0.004	5067	4795	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
100	4961	0	0.0	1.7	0.0	0.000	0.000	0.017	0.115	20233	12.8	4.078	206	2.1	2.4	12.7	0.002	4971	4715	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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	max
my5651_rel.cz11a_c8r32	99.964	0.033	0.001	0.002		0.009
my5744_rel.cz11a_c8r32	99.974	0.026	nonzero	nonzero		0.005
my8028_rel.cz11a_c8r32	99.936	0.064	nonzero	nonzero		0.006
my8032_rel.cz11a_c8r32	99.910	0.090	nonzero			0.002
my8036_rel.cz11a_c8r32	99.958	0.041	nonzero			0.002
my8037_rel.cz11a_c8r32	99.960	0.040	nonzero			0.002
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	67.208	24.004	8.787	nonzero	nonzero	0.033
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	66.520	31.012	2.468		nonzero	0.028
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	68.518	24.512	6.970	nonzero	nonzero	0.032

dbms	1ms	4ms	16ms	64ms	max
my5651_rel.cz11a_c8r32	13.989	76.783	9.139	0.089	0.022
my5744_rel.cz11a_c8r32	7.589	92.139	0.272		0.012
my8028_rel.cz11a_c8r32	0.017	99.844	0.139		0.015
my8032_rel.cz11a_c8r32		99.872	0.122	0.006	0.023
my8036_rel.cz11a_c8r32		99.817	0.183		0.014
my8037_rel.cz11a_c8r32		99.850	0.150		0.014
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	83.806	16.000	0.189	0.006	0.017
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	18.083	81.739	0.094	0.083	0.022
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	9.739	90.072	0.100	0.089	0.024

dbms	1ms	4ms	16ms	64ms	max
my5651_rel.cz11a_c8r32	23.772	67.028	9.156	0.044	0.022
my5744_rel.cz11a_c8r32	88.289	11.506	0.206		0.012
my8028_rel.cz11a_c8r32	89.339	10.606	0.056		0.008
my8032_rel.cz11a_c8r32	55.050	44.878	0.067	0.006	0.023
my8036_rel.cz11a_c8r32	81.017	18.822	0.161		0.007
my8037_rel.cz11a_c8r32	78.561	21.333	0.106		0.008
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	84.361	15.450	0.183	0.006	0.017
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	31.383	68.433	0.100	0.083	0.023
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	19.650	80.178	0.089	0.083	0.024

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
499	10647	0	0.0	1.9	0.0	0.000	0.000	0.004	0.025	41130	12.2	3.863	92	6.2	36.7	7.8	0.009	10660	10516	my5651_rel.cz11a_c8r32
499	9040	0	0.0	1.1	0.0	0.000	0.000	0.002	0.017	35004	12.2	3.872	108	6.3	36.8	8.3	0.005	9046	8966	my5744_rel.cz11a_c8r32
499	7729	0	0.0	1.6	0.0	0.000	0.000	0.003	0.020	30348	12.4	3.927	128	6.7	37.4	9.0	0.006	7735	7687	my8028_rel.cz11a_c8r32
499	7207	0	0.0	0.9	0.0	0.000	0.000	0.002	0.013	28513	12.4	3.957	138	6.6	37.5	9.2	0.002	7208	7160	my8032_rel.cz11a_c8r32
499	8159	0	0.0	1.3	0.0	0.000	0.003	0.003	0.019	32106	12.3	3.935	121	6.6	37.5	9.1	0.002	8167	8087	my8036_rel.cz11a_c8r32
499	8084	0	0.0	1.4	0.0	0.000	0.000	0.003	0.019	31829	12.3	3.937	122	6.6	37.5	9.1	0.002	8087	8039	my8037_rel.cz11a_c8r32
499	2902	0	0.0	1.0	0.0	0.000	0.000	0.002	0.015	11425	12.7	3.936	350	2.1	2.4	13.9	0.033	2893	2397	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
499	3258	0	0.0	1.8	0.0	0.000	0.000	0.004	0.024	12912	12.9	3.964	317	2.1	2.6	13.8	0.028	3230	2717	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
499	2913	0	0.0	1.0	0.0	0.000	0.000	0.002	0.016	11807	13.0	4.053	357	2.1	2.6	14.4	0.032	2893	2541	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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	max
my5651_rel.cz11a_c8r32	99.921	0.076	0.001	0.001	0.010
my5744_rel.cz11a_c8r32	99.885	0.115	nonzero	nonzero	0.005
my8028_rel.cz11a_c8r32	99.803	0.197	nonzero	nonzero	0.011
my8032_rel.cz11a_c8r32	99.796	0.204	nonzero		0.002
my8036_rel.cz11a_c8r32	99.762	0.238	nonzero		0.002
my8037_rel.cz11a_c8r32	99.795	0.205	nonzero		0.002
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	99.720	0.280	nonzero		0.002
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	99.535	0.465	nonzero		0.003
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	99.566	0.434	nonzero		0.001

dbms	1ms	4ms	16ms	64ms	max
my5651_rel.cz11a_c8r32	12.794	77.939	9.194	0.072	0.023
my5744_rel.cz11a_c8r32	0.561	99.194	0.244		0.013
my8028_rel.cz11a_c8r32		99.883	0.117		0.014
my8032_rel.cz11a_c8r32		99.833	0.161	0.006	0.017
my8036_rel.cz11a_c8r32		99.933	0.050	0.017	0.023
my8037_rel.cz11a_c8r32		99.822	0.172	0.006	0.028
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	78.300	21.500	0.200		0.014
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	10.794	88.994	0.133	0.078	0.022
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	7.417	92.372	0.128	0.083	0.022

dbms	1ms	4ms	16ms	64ms	max
my5651_rel.cz11a_c8r32	22.833	67.978	9.128	0.061	0.022
my5744_rel.cz11a_c8r32	79.628	20.150	0.222		0.013
my8028_rel.cz11a_c8r32	85.489	14.428	0.083		0.014
my8032_rel.cz11a_c8r32	29.822	70.033	0.144		0.010
my8036_rel.cz11a_c8r32	46.589	53.344	0.056	0.011	0.023
my8037_rel.cz11a_c8r32	44.000	55.894	0.100	0.006	0.028
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	78.506	21.306	0.189		0.014
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	21.761	78.028	0.133	0.078	0.022
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	14.511	85.278	0.133	0.078	0.023

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
499	8778	0	0.0	1.2	0.0	0.000	0.000	0.002	0.017	35531	12.4	4.048	113	6.2	36.7	7.8	0.010	8806	8279	my5651_rel.cz11a_c8r32
499	7575	0	0.0	1.9	0.0	0.000	0.000	0.004	0.024	30629	12.9	4.043	136	6.3	36.8	8.3	0.005	7592	7128	my5744_rel.cz11a_c8r32
499	6567	1	0.1	2.4	0.2	0.000	0.015	0.005	0.323	26852	12.9	4.089	157	6.7	37.4	9.0	0.011	6572	6361	my8028_rel.cz11a_c8r32
499	6018	0	0.0	1.3	0.0	0.000	0.000	0.003	0.017	24867	12.8	4.132	170	6.6	37.5	9.2	0.002	6025	5868	my8032_rel.cz11a_c8r32
499	6105	0	0.0	1.6	0.0	0.000	0.000	0.003	0.023	25188	12.6	4.126	165	6.6	37.5	9.1	0.002	6105	5930	my8036_rel.cz11a_c8r32
499	6058	0	0.0	1.5	0.0	0.000	0.000	0.003	0.020	25008	12.8	4.128	169	6.6	37.5	9.1	0.002	6059	5898	my8037_rel.cz11a_c8r32
499	5691	1	0.0	1.6	0.0	0.000	0.002	0.003	0.021	23106	13.0	4.060	183	2.1	2.6	15.3	0.002	5706	5434	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
499	5074	0	0.0	1.9	0.0	0.000	0.000	0.004	0.029	20743	13.2	4.088	208	2.1	2.8	15.1	0.003	5084	4827	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
499	4925	0	0.0	1.0	0.0	0.000	0.000	0.002	0.016	20291	13.2	4.120	214	2.1	2.8	15.9	0.001	4938	4683	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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	max
my5651_rel.cz11a_c8r32	99.959	0.037	0.001	0.002		0.014
my5744_rel.cz11a_c8r32	99.965	0.035	nonzero			0.004
my8028_rel.cz11a_c8r32	99.929	0.071	nonzero			0.002
my8032_rel.cz11a_c8r32	99.889	0.111	nonzero			0.002
my8036_rel.cz11a_c8r32	99.950	0.049	nonzero			0.002
my8037_rel.cz11a_c8r32	99.949	0.051	nonzero			0.002
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	71.006	28.132	0.862	nonzero	nonzero	0.044
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	67.546	32.441	0.013		nonzero	0.031
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	69.841	25.652	4.507	nonzero	nonzero	0.043

dbms	1ms	4ms	16ms	64ms	256ms	max
my5651_rel.cz11a_c8r32	17.550	76.542	5.836	0.072		0.025
my5744_rel.cz11a_c8r32	11.481	88.283	0.231	0.006		0.019
my8028_rel.cz11a_c8r32	0.036	99.769	0.194			0.015
my8032_rel.cz11a_c8r32		99.856	0.142	0.003		0.023
my8036_rel.cz11a_c8r32		99.758	0.239	0.003		0.023
my8037_rel.cz11a_c8r32		99.881	0.117	0.003		0.019
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	90.361	9.494	0.142	0.003		0.062
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	24.744	75.053	0.111	0.089	0.003	0.067
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	13.656	86.089	0.175	0.081		0.051

dbms	1ms	4ms	16ms	64ms	256ms	max
my5651_rel.cz11a_c8r32	32.400	61.889	5.661	0.050		0.026
my5744_rel.cz11a_c8r32	92.669	7.139	0.192			0.014
my8028_rel.cz11a_c8r32	93.206	6.653	0.142			0.014
my8032_rel.cz11a_c8r32	59.206	40.675	0.117	0.003		0.022
my8036_rel.cz11a_c8r32	84.367	15.472	0.158	0.003		0.023
my8037_rel.cz11a_c8r32	84.203	15.703	0.092	0.003		0.019
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	89.992	9.861	0.144	0.003		0.062
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	32.022	67.778	0.111	0.089		0.048
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	19.294	80.458	0.169	0.075	0.003	0.073

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
999	10843	0	0.0	1.1	0.0	0.000	0.000	0.001	0.008	43349	12.6	3.998	93	6.2	36.7	7.8	0.014	10852	10633	my5651_rel.cz11a_c8r32
999	8975	0	0.0	1.2	0.0	0.000	0.000	0.001	0.010	34989	12.7	3.898	113	6.3	36.8	8.3	0.004	8982	8906	my5744_rel.cz11a_c8r32
999	7764	0	0.0	1.0	0.0	0.000	0.000	0.001	0.007	30893	12.4	3.979	128	6.7	37.4	9.0	0.002	7767	7706	my8028_rel.cz11a_c8r32
999	7176	0	0.0	1.7	0.0	0.000	0.004	0.002	0.011	29005	12.9	4.042	144	6.6	37.5	9.2	0.002	7176	7128	my8032_rel.cz11a_c8r32
999	8110	0	0.0	1.2	0.0	0.000	0.000	0.001	0.009	32515	12.9	4.009	127	6.6	37.5	9.1	0.002	8110	8039	my8036_rel.cz11a_c8r32
999	8075	0	0.0	1.0	0.0	0.000	0.000	0.001	0.007	32390	12.7	4.011	126	6.6	37.5	9.1	0.002	8071	8023	my8037_rel.cz11a_c8r32
999	3740	0	0.0	1.8	0.0	0.000	0.000	0.002	0.012	14913	13.4	3.987	287	2.1	3.0	17.9	0.044	3486	2621	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
999	3401	0	0.0	1.0	0.0	0.000	0.000	0.001	0.008	13765	13.7	4.047	322	2.1	3.2	18.3	0.031	3212	2477	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
999	3111	0	0.0	1.6	0.0	0.000	0.000	0.002	0.012	12862	13.6	4.135	350	2.1	3.2	19.0	0.043	3053	2414	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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	max
my5651_rel.cz11a_c8r32	99.855	0.140	0.003	0.002	0.010
my5744_rel.cz11a_c8r32	99.856	0.144	nonzero		0.002
my8028_rel.cz11a_c8r32	99.748	0.252	nonzero		0.002
my8032_rel.cz11a_c8r32	99.711	0.289	nonzero		0.002
my8036_rel.cz11a_c8r32	99.660	0.340	nonzero		0.001
my8037_rel.cz11a_c8r32	99.620	0.380	nonzero		0.002
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	99.655	0.345	nonzero		0.002
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	99.417	0.582	nonzero		0.002
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	99.427	0.573	nonzero		0.003

dbms	1ms	4ms	16ms	64ms	256ms	1s	max
my5651_rel.cz11a_c8r32	17.981	77.272	4.711	0.036			0.022
my5744_rel.cz11a_c8r32	4.814	95.014	0.172				0.016
my8028_rel.cz11a_c8r32	0.003	99.900	0.097				0.015
my8032_rel.cz11a_c8r32		99.764	0.233	0.003			0.026
my8036_rel.cz11a_c8r32		99.753	0.244	0.003			0.018
my8037_rel.cz11a_c8r32		99.758	0.233	0.006		0.003	0.272
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	87.639	12.194	0.164	0.003			0.048
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	20.431	79.386	0.097	0.083	0.003		0.066
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	11.244	88.492	0.178	0.086			0.049

dbms	1ms	4ms	16ms	64ms	1s	max
my5651_rel.cz11a_c8r32	32.139	63.150	4.686	0.025		0.022
my5744_rel.cz11a_c8r32	89.797	10.069	0.131	0.003		0.017
my8028_rel.cz11a_c8r32	90.683	9.239	0.078			0.013
my8032_rel.cz11a_c8r32	45.061	54.775	0.161	0.003		0.026
my8036_rel.cz11a_c8r32	59.783	40.064	0.150	0.003		0.018
my8037_rel.cz11a_c8r32	58.772	41.089	0.136		0.003	0.290
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32	88.042	11.794	0.161	0.003		0.048
fbmy8028_rel_240606_c6c83b18.cza1_c8r32	26.283	73.531	0.097	0.089		0.051
fbmy8032_rel_240606_59f03d5a.cza1_c8r32	16.042	83.700	0.169	0.089		0.041

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
999	8833	0	0.0	1.5	0.0	0.000	0.000	0.001	0.010	36152	13.3	4.093	120	6.2	36.7	7.8	0.010	8854	8263	my5651_rel.cz11a_c8r32
999	7553	1	0.0	1.5	0.0	0.000	0.000	0.002	0.010	30879	13.1	4.088	139	6.3	36.8	8.3	0.002	7575	7227	my5744_rel.cz11a_c8r32
999	6505	0	0.0	1.3	0.0	0.000	0.000	0.001	0.009	27140	13.5	4.172	166	6.7	37.4	9.0	0.002	6521	6284	my8028_rel.cz11a_c8r32
999	6024	0	0.0	1.0	0.0	0.000	0.000	0.001	0.007	25628	13.7	4.254	182	6.6	37.5	9.2	0.002	6028	5849	my8032_rel.cz11a_c8r32
999	6108	0	0.0	1.7	0.0	0.000	0.000	0.002	0.012	25909	13.6	4.242	178	6.6	37.5	9.1	0.001	6121	5929	my8036_rel.cz11a_c8r32
999	6075	0	0.0	1.0	0.0	0.000	0.000	0.001	0.007	25790	13.6	4.245	179	6.6	37.6	9.1	0.002	6089	5913	my8037_rel.cz11a_c8r32
999	5637	0	0.0	1.4	0.0	0.000	0.000	0.001	0.010	23214	13.7	4.118	194	2.1	3.4	20.3	0.002	5658	5322	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
999	5085	0	0.0	1.5	0.0	0.000	0.000	0.002	0.011	21099	13.9	4.149	219	2.1	3.6	20.9	0.002	5100	4811	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
999	4960	0	0.0	1.5	0.0	0.000	0.000	0.002	0.010	20746	14.1	4.182	227	2.2	3.6	21.0	0.003	4973	4715	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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
172414	0	0	0.0	2.1	0.0	0.000	0.000	0.000	0.000	19696	20.8	0.114	10	2.0	32.5	3.3	0.152	176105	110068	my5651_rel.cz11a_c8r32
153061	0	0	0.0	1.8	0.0	0.000	0.000	0.000	0.000	15336	20.6	0.100	11	2.0	32.5	3.8	0.090	154033	140650	my5744_rel.cz11a_c8r32
119048	0	0	0.0	1.6	0.0	0.000	0.000	0.000	0.000	12868	18.7	0.108	13	2.0	32.6	4.0	0.091	120071	103986	my8028_rel.cz11a_c8r32
104895	0	0	0.0	1.6	0.0	0.000	0.000	0.000	0.000	11765	17.8	0.112	14	2.0	32.6	4.1	0.082	106384	93698	my8032_rel.cz11a_c8r32
103093	0	0	0.0	1.9	0.0	0.000	0.000	0.000	0.000	11557	17.8	0.112	14	2.0	32.6	4.0	0.082	103886	87911	my8036_rel.cz11a_c8r32
105263	0	0	0.0	1.4	0.0	0.000	0.000	0.000	0.000	11762	17.9	0.112	14	2.0	32.6	4.1	0.082	106084	94099	my8037_rel.cz11a_c8r32
145631	0	1	0.0	1.0	0.0	0.000	0.000	0.000	0.000	15051	21.9	0.103	12	1.0	2.5	0.3	0.115	61038	0	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
102389	0	2	0.2	1.3	0.0	0.000	0.002	0.000	0.000	11144	19.0	0.109	15	0.9	2.7	0.6	0.147	102887	86308	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
96463	0	0	0.0	2.0	0.0	0.000	0.000	0.000	0.000	10672	18.8	0.111	16	0.9	2.7	0.6	0.106	96442	83210	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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
143541	0	0	0.0	1.6	0.0	0.000	0.000	0.000	0.000	4319	9.7	0.030	5	4.2	34.7	5.2	0.001	NA	NA	my5651_rel.cz11a_c8r32
223881	0	0	0.0	1.4	0.0	0.000	0.000	0.000	0.000	12782	12.1	0.057	4	4.6	35.1	5.5	0.001	NA	NA	my5744_rel.cz11a_c8r32
300001	0	0	0.0	1.2	0.0	0.000	0.000	0.000	0.000	22256	39.5	0.074	11	4.5	35.1	6.1	0.001	NA	NA	my8028_rel.cz11a_c8r32
277779	0	0	0.0	1.2	0.0	0.000	0.000	0.000	0.000	18397	39.1	0.066	11	4.5	35.1	5.3	0.002	NA	NA	my8032_rel.cz11a_c8r32
260870	0	0	0.0	1.6	0.0	0.000	0.000	0.000	0.000	17205	39.7	0.066	12	4.5	35.1	4.8	0.002	NA	NA	my8036_rel.cz11a_c8r32
280375	0	0	0.0	1.8	0.0	0.000	0.000	0.000	0.000	19419	38.8	0.069	11	4.5	35.1	5.5	0.002	NA	NA	my8037_rel.cz11a_c8r32
156250	0	0	0.0	1.1	0.0	0.000	0.000	0.000	0.000	173	12.2	0.001	6	2.0	3.6	2.3	0.001	NA	NA	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
136364	0	0	0.0	1.0	0.0	0.000	0.000	0.000	0.000	316	11.6	0.002	7	2.0	3.8	2.7	0.002	NA	NA	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
133929	0	0	0.0	1.6	0.0	0.000	0.000	0.000	0.000	515	11.6	0.004	7	2.0	3.8	2.6	0.009	NA	NA	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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
32949	0	0	0.0	1.8	0.0	0.000	0.000	0.000	0.000	36108	40.0	1.096	97	6.2	36.7	7.8	0.081	35012	8990	my5651_rel.cz11a_c8r32
34843	0	0	0.0	1.2	0.0	0.000	0.000	0.000	0.000	25133	45.0	0.721	103	6.3	36.8	8.3	0.093	36261	10439	my5744_rel.cz11a_c8r32
35971	0	0	0.0	1.6	0.0	0.000	0.000	0.000	0.000	45838	35.1	1.274	78	6.7	37.4	9.0	0.094	37708	7941	my8028_rel.cz11a_c8r32
31898	0	0	0.0	1.6	0.0	0.000	0.000	0.000	0.000	45595	35.7	1.429	90	6.6	37.5	9.1	0.102	33614	7299	my8032_rel.cz11a_c8r32
32128	0	0	0.0	1.9	0.0	0.000	0.000	0.000	0.000	45161	35.0	1.406	87	6.6	37.4	9.0	0.102	33896	6643	my8036_rel.cz11a_c8r32
32284	0	0	0.0	1.4	0.0	0.000	0.000	0.000	0.000	45847	35.3	1.420	87	6.6	37.5	9.1	0.278	34013	6642	my8037_rel.cz11a_c8r32
45045	0	1	0.0	1.2	0.0	0.000	0.000	0.000	0.000	20136	42.8	0.447	76	2.3	3.0	7.1	0.125	45749	29130	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
39331	0	0	0.0	1.8	0.0	0.000	0.000	0.000	0.000	18123	41.6	0.461	85	2.5	3.3	7.0	0.147	40605	22225	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
41408	0	0	0.0	1.9	0.0	0.000	0.000	0.000	0.000	19367	44.2	0.468	85	2.3	3.1	7.6	0.119	41505	35312	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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
21739	0	0	0.0	2.0	0.0	0.000	0.000	0.000	0.001	177487	39.7	8.164	146	6.2	36.7	7.8	0.067	21802	20623	my5651_rel.cz11a_c8r32
21882	0	0	0.0	1.7	0.0	0.000	0.000	0.000	0.001	86924	38.8	3.972	142	6.3	36.8	8.3	0.113	21976	20619	my5744_rel.cz11a_c8r32
20000	0	0	0.0	1.1	0.0	0.000	0.000	0.000	0.000	92176	33.4	4.609	134	6.7	37.4	9.0	0.099	20091	18810	my8028_rel.cz11a_c8r32
18248	0	0	0.0	0.9	0.0	0.000	0.000	0.000	0.000	86263	33.2	4.727	146	6.6	37.5	9.2	0.101	18267	17156	my8032_rel.cz11a_c8r32
18248	0	0	0.0	1.1	0.0	0.000	0.000	0.000	0.000	86169	33.2	4.722	146	6.6	37.4	9.0	0.059	18295	17466	my8036_rel.cz11a_c8r32
18349	0	0	0.0	1.0	0.0	0.000	0.000	0.000	0.000	87349	33.3	4.761	145	6.6	37.5	9.1	0.101	18406	17081	my8037_rel.cz11a_c8r32
17575	0	0	0.0	1.8	0.0	0.000	0.000	0.000	0.001	76727	40.7	4.366	185	2.1	2.3	9.7	0.079	18076	7547	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
15873	0	0	0.0	1.6	0.0	0.000	0.000	0.000	0.001	66510	40.9	4.190	206	2.3	2.7	10.0	0.109	16198	5876	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
15504	0	0	0.0	1.9	0.0	0.000	0.000	0.000	0.001	64822	40.6	4.181	210	2.1	2.5	10.4	0.078	15598	13795	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

qr100.L1

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

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
100	10749	0	0.0	1.8	0.0	0.000	0.000	0.018	0.118	41738	11.6	3.883	86	6.2	36.7	7.8	0.020	10744	10536	my5651_rel.cz11a_c8r32
100	8954	0	0.0	1.8	0.0	0.000	0.000	0.018	0.118	34866	11.7	3.894	105	6.3	36.8	8.3	0.010	8950	8870	my5744_rel.cz11a_c8r32
100	7731	0	0.0	1.5	0.0	0.000	0.000	0.015	0.091	30347	11.9	3.926	123	6.7	37.4	9.0	0.001	7735	7672	my8028_rel.cz11a_c8r32
100	7235	0	0.0	1.5	0.0	0.000	0.000	0.015	0.092	28664	12.0	3.962	133	6.6	37.5	9.2	0.002	7240	7179	my8032_rel.cz11a_c8r32
100	8177	0	0.0	1.9	0.0	0.000	0.000	0.019	0.125	32205	11.7	3.938	114	6.6	37.4	9.1	0.012	8183	8103	my8036_rel.cz11a_c8r32
100	8056	0	0.0	1.0	0.0	0.000	0.000	0.010	0.067	31716	11.7	3.937	116	6.6	37.5	9.1	0.002	8055	7991	my8037_rel.cz11a_c8r32
100	3204	0	0.0	1.0	0.0	0.000	0.000	0.010	0.073	12375	12.2	3.862	305	2.1	2.2	10.4	0.036	3596	2317	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
100	4477	0	0.0	1.1	0.0	0.000	0.000	0.011	0.081	17358	12.3	3.877	220	2.1	2.3	10.5	0.002	4475	4203	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
100	2586	0	0.0	1.6	0.0	0.000	0.000	0.016	0.104	10336	12.4	3.997	384	2.1	2.4	11.0	0.034	2589	2397	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

qp100.L2

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

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
100	8804	0	0.0	1.9	0.0	0.000	0.000	0.019	0.118	35334	12.3	4.013	112	6.2	36.7	7.8	0.009	8838	8327	my5651_rel.cz11a_c8r32
100	7627	0	0.0	1.8	0.0	0.000	0.000	0.018	0.115	30771	12.2	4.035	128	6.3	36.8	8.3	0.002	7639	7304	my5744_rel.cz11a_c8r32
100	6547	0	0.0	1.5	0.0	0.000	0.000	0.015	0.096	26505	12.6	4.048	154	6.7	37.4	9.0	0.002	6553	6380	my8028_rel.cz11a_c8r32
100	6051	0	0.0	1.6	0.0	0.000	0.000	0.016	0.098	24691	12.9	4.081	171	6.6	37.5	9.2	0.002	6057	5945	my8032_rel.cz11a_c8r32
100	6080	0	0.0	1.4	0.0	0.000	0.000	0.014	0.098	24798	12.6	4.078	166	6.6	37.5	9.1	0.002	6089	5897	my8036_rel.cz11a_c8r32
100	6133	0	0.0	1.8	0.0	0.000	0.001	0.018	0.122	25015	12.7	4.079	166	6.6	37.5	9.1	0.001	6137	5945	my8037_rel.cz11a_c8r32
100	5682	0	0.0	1.1	0.0	0.000	0.000	0.011	0.082	22869	12.6	4.025	177	2.1	2.2	12.1	0.002	5705	5354	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
100	5059	0	0.0	1.2	0.0	0.000	0.000	0.012	0.102	20457	12.6	4.044	199	2.2	2.4	12.2	0.004	5067	4795	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
100	4961	0	0.0	1.7	0.0	0.000	0.000	0.017	0.115	20233	12.8	4.078	206	2.1	2.4	12.7	0.002	4971	4715	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

qr500.L3

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

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
499	10647	0	0.0	1.9	0.0	0.000	0.000	0.004	0.025	41130	12.2	3.863	92	6.2	36.7	7.8	0.009	10660	10516	my5651_rel.cz11a_c8r32
499	9040	0	0.0	1.1	0.0	0.000	0.000	0.002	0.017	35004	12.2	3.872	108	6.3	36.8	8.3	0.005	9046	8966	my5744_rel.cz11a_c8r32
499	7729	0	0.0	1.6	0.0	0.000	0.000	0.003	0.020	30348	12.4	3.927	128	6.7	37.4	9.0	0.006	7735	7687	my8028_rel.cz11a_c8r32
499	7207	0	0.0	0.9	0.0	0.000	0.000	0.002	0.013	28513	12.4	3.957	138	6.6	37.5	9.2	0.002	7208	7160	my8032_rel.cz11a_c8r32
499	8159	0	0.0	1.3	0.0	0.000	0.003	0.003	0.019	32106	12.3	3.935	121	6.6	37.5	9.1	0.002	8167	8087	my8036_rel.cz11a_c8r32
499	8084	0	0.0	1.4	0.0	0.000	0.000	0.003	0.019	31829	12.3	3.937	122	6.6	37.5	9.1	0.002	8087	8039	my8037_rel.cz11a_c8r32
499	2902	0	0.0	1.0	0.0	0.000	0.000	0.002	0.015	11425	12.7	3.936	350	2.1	2.4	13.9	0.033	2893	2397	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
499	3258	0	0.0	1.8	0.0	0.000	0.000	0.004	0.024	12912	12.9	3.964	317	2.1	2.6	13.8	0.028	3230	2717	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
499	2913	0	0.0	1.0	0.0	0.000	0.000	0.002	0.016	11807	13.0	4.053	357	2.1	2.6	14.4	0.032	2893	2541	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

qp500.L4

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

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
499	8778	0	0.0	1.2	0.0	0.000	0.000	0.002	0.017	35531	12.4	4.048	113	6.2	36.7	7.8	0.010	8806	8279	my5651_rel.cz11a_c8r32
499	7575	0	0.0	1.9	0.0	0.000	0.000	0.004	0.024	30629	12.9	4.043	136	6.3	36.8	8.3	0.005	7592	7128	my5744_rel.cz11a_c8r32
499	6567	1	0.1	2.4	0.2	0.000	0.015	0.005	0.323	26852	12.9	4.089	157	6.7	37.4	9.0	0.011	6572	6361	my8028_rel.cz11a_c8r32
499	6018	0	0.0	1.3	0.0	0.000	0.000	0.003	0.017	24867	12.8	4.132	170	6.6	37.5	9.2	0.002	6025	5868	my8032_rel.cz11a_c8r32
499	6105	0	0.0	1.6	0.0	0.000	0.000	0.003	0.023	25188	12.6	4.126	165	6.6	37.5	9.1	0.002	6105	5930	my8036_rel.cz11a_c8r32
499	6058	0	0.0	1.5	0.0	0.000	0.000	0.003	0.020	25008	12.8	4.128	169	6.6	37.5	9.1	0.002	6059	5898	my8037_rel.cz11a_c8r32
499	5691	1	0.0	1.6	0.0	0.000	0.002	0.003	0.021	23106	13.0	4.060	183	2.1	2.6	15.3	0.002	5706	5434	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
499	5074	0	0.0	1.9	0.0	0.000	0.000	0.004	0.029	20743	13.2	4.088	208	2.1	2.8	15.1	0.003	5084	4827	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
499	4925	0	0.0	1.0	0.0	0.000	0.000	0.002	0.016	20291	13.2	4.120	214	2.1	2.8	15.9	0.001	4938	4683	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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
999	10843	0	0.0	1.1	0.0	0.000	0.000	0.001	0.008	43349	12.6	3.998	93	6.2	36.7	7.8	0.014	10852	10633	my5651_rel.cz11a_c8r32
999	8975	0	0.0	1.2	0.0	0.000	0.000	0.001	0.010	34989	12.7	3.898	113	6.3	36.8	8.3	0.004	8982	8906	my5744_rel.cz11a_c8r32
999	7764	0	0.0	1.0	0.0	0.000	0.000	0.001	0.007	30893	12.4	3.979	128	6.7	37.4	9.0	0.002	7767	7706	my8028_rel.cz11a_c8r32
999	7176	0	0.0	1.7	0.0	0.000	0.004	0.002	0.011	29005	12.9	4.042	144	6.6	37.5	9.2	0.002	7176	7128	my8032_rel.cz11a_c8r32
999	8110	0	0.0	1.2	0.0	0.000	0.000	0.001	0.009	32515	12.9	4.009	127	6.6	37.5	9.1	0.002	8110	8039	my8036_rel.cz11a_c8r32
999	8075	0	0.0	1.0	0.0	0.000	0.000	0.001	0.007	32390	12.7	4.011	126	6.6	37.5	9.1	0.002	8071	8023	my8037_rel.cz11a_c8r32
999	3740	0	0.0	1.8	0.0	0.000	0.000	0.002	0.012	14913	13.4	3.987	287	2.1	3.0	17.9	0.044	3486	2621	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
999	3401	0	0.0	1.0	0.0	0.000	0.000	0.001	0.008	13765	13.7	4.047	322	2.1	3.2	18.3	0.031	3212	2477	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
999	3111	0	0.0	1.6	0.0	0.000	0.000	0.002	0.012	12862	13.6	4.135	350	2.1	3.2	19.0	0.043	3053	2414	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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
999	8833	0	0.0	1.5	0.0	0.000	0.000	0.001	0.010	36152	13.3	4.093	120	6.2	36.7	7.8	0.010	8854	8263	my5651_rel.cz11a_c8r32
999	7553	1	0.0	1.5	0.0	0.000	0.000	0.002	0.010	30879	13.1	4.088	139	6.3	36.8	8.3	0.002	7575	7227	my5744_rel.cz11a_c8r32
999	6505	0	0.0	1.3	0.0	0.000	0.000	0.001	0.009	27140	13.5	4.172	166	6.7	37.4	9.0	0.002	6521	6284	my8028_rel.cz11a_c8r32
999	6024	0	0.0	1.0	0.0	0.000	0.000	0.001	0.007	25628	13.7	4.254	182	6.6	37.5	9.2	0.002	6028	5849	my8032_rel.cz11a_c8r32
999	6108	0	0.0	1.7	0.0	0.000	0.000	0.002	0.012	25909	13.6	4.242	178	6.6	37.5	9.1	0.001	6121	5929	my8036_rel.cz11a_c8r32
999	6075	0	0.0	1.0	0.0	0.000	0.000	0.001	0.007	25790	13.6	4.245	179	6.6	37.6	9.1	0.002	6089	5913	my8037_rel.cz11a_c8r32
999	5637	0	0.0	1.4	0.0	0.000	0.000	0.001	0.010	23214	13.7	4.118	194	2.1	3.4	20.3	0.002	5658	5322	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
999	5085	0	0.0	1.5	0.0	0.000	0.000	0.002	0.011	21099	13.9	4.149	219	2.1	3.6	20.9	0.002	5100	4811	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
999	4960	0	0.0	1.5	0.0	0.000	0.000	0.002	0.010	20746	14.1	4.182	227	2.2	3.6	21.0	0.003	4973	4715	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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	99.264	0.673	0.048	0.014	0.001	0.000	0.000	0.000	0.000	0.152	my5651_rel.cz11a_c8r32
0.000	99.535	0.198	0.137	0.130	0.001	0.000	0.000	0.000	0.000	0.090	my5744_rel.cz11a_c8r32
0.000	99.285	0.344	0.239	0.131	0.002	0.000	0.000	0.000	0.000	0.091	my8028_rel.cz11a_c8r32
0.000	98.608	0.995	0.263	0.133	0.002	0.000	0.000	0.000	0.000	0.082	my8032_rel.cz11a_c8r32
0.000	96.662	2.937	0.263	0.137	0.002	0.000	0.000	0.000	0.000	0.082	my8036_rel.cz11a_c8r32
0.000	98.545	1.059	0.255	0.139	0.002	0.000	0.000	0.000	0.000	0.082	my8037_rel.cz11a_c8r32
0.000	99.808	0.120	0.069	0.000	0.003	0.000	0.000	0.000	0.000	0.115	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
0.000	95.754	4.045	0.145	0.052	0.004	0.000	0.000	0.000	0.000	0.147	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
0.000	78.877	20.915	0.148	0.056	0.004	0.000	0.000	0.000	0.000	0.106	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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	10.339	87.672	1.813	0.175	0.001	0.000	0.000	0.000	0.000	0.081	my5651_rel.cz11a_c8r32
0.000	3.927	94.388	1.644	0.041	0.001	0.000	0.000	0.000	0.000	0.093	my5744_rel.cz11a_c8r32
0.000	nonzero	98.636	1.294	0.069	0.001	0.000	0.000	0.000	0.000	0.094	my8028_rel.cz11a_c8r32
0.000	0.000	98.280	1.623	0.095	0.001	0.000	0.000	0.000	0.000	0.102	my8032_rel.cz11a_c8r32
0.000	0.000	98.317	1.593	0.089	0.001	0.000	0.000	0.000	0.000	0.102	my8036_rel.cz11a_c8r32
0.000	0.000	98.339	1.575	0.085	0.001	nonzero	0.000	0.000	0.000	0.278	my8037_rel.cz11a_c8r32
0.000	86.919	12.983	0.093	0.001	0.004	0.000	0.000	0.000	0.000	0.125	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
0.000	27.809	71.973	0.165	0.051	0.003	0.000	0.000	0.000	0.000	0.147	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
0.000	15.724	84.054	0.171	0.047	0.004	0.000	0.000	0.000	0.000	0.119	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	77.275	21.465	1.121	0.138	0.001	0.000	0.000	0.000	0.000	0.080	my5651_rel.cz11a_c8r32
0.000	66.862	31.856	1.267	0.015	0.001	0.000	0.000	0.000	0.000	0.093	my5744_rel.cz11a_c8r32
0.000	93.557	5.391	1.035	0.016	0.001	0.000	0.000	0.000	0.000	0.078	my8028_rel.cz11a_c8r32
0.000	51.503	47.191	1.277	0.029	0.001	0.000	0.000	0.000	0.000	0.108	my8032_rel.cz11a_c8r32
0.000	64.976	33.737	1.264	0.022	0.001	0.000	0.000	0.000	0.000	0.101	my8036_rel.cz11a_c8r32
0.000	65.264	33.476	1.234	0.026	0.001	nonzero	0.000	0.000	0.000	0.284	my8037_rel.cz11a_c8r32
0.000	85.878	14.015	0.097	0.007	0.003	0.000	0.000	0.000	0.000	0.125	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
0.000	32.708	67.065	0.163	0.061	0.003	0.000	0.000	0.000	0.000	0.133	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
0.000	21.754	78.017	0.168	0.057	0.004	0.000	0.000	0.000	0.000	0.126	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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
86.693	13.177	0.014	0.112	0.004	nonzero	0.000	0.000	0.000	0.000	0.067	my5651_rel.cz11a_c8r32
88.626	11.193	0.054	0.126	0.001	nonzero	0.000	0.000	0.000	0.000	0.113	my5744_rel.cz11a_c8r32
84.660	15.226	0.003	0.111	nonzero	nonzero	0.000	0.000	0.000	0.000	0.099	my8028_rel.cz11a_c8r32
75.291	24.577	0.004	0.127	0.001	nonzero	0.000	0.000	0.000	0.000	0.101	my8032_rel.cz11a_c8r32
75.338	24.528	0.004	0.129	0.001	0.000	0.000	0.000	0.000	0.000	0.059	my8036_rel.cz11a_c8r32
76.605	23.258	0.004	0.131	0.001	nonzero	0.000	0.000	0.000	0.000	0.101	my8037_rel.cz11a_c8r32
98.746	1.222	0.006	0.025	nonzero	0.001	0.000	0.000	0.000	0.000	0.079	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
69.098	30.847	0.007	0.040	0.007	0.001	0.000	0.000	0.000	0.000	0.109	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
47.310	52.633	0.006	0.043	0.007	nonzero	0.000	0.000	0.000	0.000	0.078	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
96.933	2.937	0.015	0.112	0.004	nonzero	0.000	0.000	0.000	0.000	0.068	my5651_rel.cz11a_c8r32
92.118	7.750	0.009	0.122	0.001	nonzero	0.000	0.000	0.000	0.000	0.113	my5744_rel.cz11a_c8r32
95.358	4.535	0.001	0.105	nonzero	nonzero	0.000	0.000	0.000	0.000	0.106	my8028_rel.cz11a_c8r32
86.679	13.199	0.001	0.119	0.001	nonzero	0.000	0.000	0.000	0.000	0.101	my8032_rel.cz11a_c8r32
87.530	12.345	0.001	0.122	0.001	0.000	0.000	0.000	0.000	0.000	0.060	my8036_rel.cz11a_c8r32
89.495	10.379	0.001	0.124	0.001	nonzero	0.000	0.000	0.000	0.000	0.101	my8037_rel.cz11a_c8r32
95.187	4.781	0.006	0.026	nonzero	0.001	0.000	0.000	0.000	0.000	0.079	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
25.125	74.817	0.008	0.042	0.008	nonzero	0.000	0.000	0.000	0.000	0.089	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
0.831	99.109	0.008	0.045	0.007	nonzero	0.000	0.000	0.000	0.000	0.079	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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
99.968	0.028	0.002	0.003	nonzero	0.000	0.000	0.000	0.000	0.000	0.020	my5651_rel.cz11a_c8r32
99.981	0.019	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.010	my5744_rel.cz11a_c8r32
99.946	0.054	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	my8028_rel.cz11a_c8r32
99.924	0.076	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8032_rel.cz11a_c8r32
99.961	0.039	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.012	my8036_rel.cz11a_c8r32
99.966	0.034	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8037_rel.cz11a_c8r32
80.751	14.310	4.939	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.036	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
80.279	19.721	0.001	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
66.570	23.063	10.366	0.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.034	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.500	49.194	47.250	3.056	0.000	0.000	0.000	0.000	0.000	0.033	my5651_rel.cz11a_c8r32
0.000	0.694	98.833	0.472	0.000	0.000	0.000	0.000	0.000	0.000	0.015	my5744_rel.cz11a_c8r32
0.000	0.000	99.861	0.139	0.000	0.000	0.000	0.000	0.000	0.000	0.013	my8028_rel.cz11a_c8r32
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.012	my8032_rel.cz11a_c8r32
0.000	0.000	99.583	0.417	0.000	0.000	0.000	0.000	0.000	0.000	0.014	my8036_rel.cz11a_c8r32
0.000	0.000	99.722	0.278	0.000	0.000	0.000	0.000	0.000	0.000	0.013	my8037_rel.cz11a_c8r32
0.000	38.722	60.917	0.361	0.000	0.000	0.000	0.000	0.000	0.000	0.013	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
0.000	7.944	91.500	0.500	0.056	0.000	0.000	0.000	0.000	0.000	0.017	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
0.000	2.972	96.667	0.333	0.028	0.000	0.000	0.000	0.000	0.000	0.023	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	3.361	46.167	48.556	1.917	0.000	0.000	0.000	0.000	0.000	0.034	my5651_rel.cz11a_c8r32
0.000	51.333	48.250	0.417	0.000	0.000	0.000	0.000	0.000	0.000	0.013	my5744_rel.cz11a_c8r32
0.000	52.222	47.611	0.167	0.000	0.000	0.000	0.000	0.000	0.000	0.010	my8028_rel.cz11a_c8r32
0.000	31.250	68.667	0.083	0.000	0.000	0.000	0.000	0.000	0.000	0.008	my8032_rel.cz11a_c8r32
0.000	37.389	62.139	0.472	0.000	0.000	0.000	0.000	0.000	0.000	0.014	my8036_rel.cz11a_c8r32
0.000	46.806	52.917	0.278	0.000	0.000	0.000	0.000	0.000	0.000	0.008	my8037_rel.cz11a_c8r32
0.000	47.583	52.056	0.361	0.000	0.000	0.000	0.000	0.000	0.000	0.013	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
0.000	30.917	68.556	0.472	0.056	0.000	0.000	0.000	0.000	0.000	0.016	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
0.000	18.000	81.667	0.306	0.028	0.000	0.000	0.000	0.000	0.000	0.022	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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
99.950	0.046	0.001	0.002	0.000	0.000	0.000	0.000	0.000	0.000	0.009	my5651_rel.cz11a_c8r32
99.923	0.077	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my5744_rel.cz11a_c8r32
99.840	0.160	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8028_rel.cz11a_c8r32
99.827	0.173	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8032_rel.cz11a_c8r32
99.777	0.223	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8036_rel.cz11a_c8r32
99.831	0.169	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	my8037_rel.cz11a_c8r32
99.706	0.294	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
99.623	0.377	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.004	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
99.573	0.426	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	55.000	44.611	0.389	0.000	0.000	0.000	0.000	0.000	0.022	my5651_rel.cz11a_c8r32
0.000	0.000	99.639	0.361	0.000	0.000	0.000	0.000	0.000	0.000	0.013	my5744_rel.cz11a_c8r32
0.000	0.000	99.833	0.167	0.000	0.000	0.000	0.000	0.000	0.000	0.014	my8028_rel.cz11a_c8r32
0.000	0.000	99.861	0.111	0.028	0.000	0.000	0.000	0.000	0.000	0.023	my8032_rel.cz11a_c8r32
0.000	0.000	99.722	0.278	0.000	0.000	0.000	0.000	0.000	0.000	0.011	my8036_rel.cz11a_c8r32
0.000	0.000	99.556	0.444	0.000	0.000	0.000	0.000	0.000	0.000	0.014	my8037_rel.cz11a_c8r32
0.000	27.972	71.417	0.611	0.000	0.000	0.000	0.000	0.000	0.000	0.014	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
0.000	1.306	98.361	0.278	0.056	0.000	0.000	0.000	0.000	0.000	0.022	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
0.000	1.056	98.667	0.222	0.056	0.000	0.000	0.000	0.000	0.000	0.022	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	1.611	53.417	44.722	0.250	0.000	0.000	0.000	0.000	0.000	0.022	my5651_rel.cz11a_c8r32
0.000	37.194	62.472	0.333	0.000	0.000	0.000	0.000	0.000	0.000	0.013	my5744_rel.cz11a_c8r32
0.000	33.722	66.139	0.139	0.000	0.000	0.000	0.000	0.000	0.000	0.012	my8028_rel.cz11a_c8r32
0.000	0.056	99.778	0.139	0.028	0.000	0.000	0.000	0.000	0.000	0.023	my8032_rel.cz11a_c8r32
0.000	5.667	94.028	0.306	0.000	0.000	0.000	0.000	0.000	0.000	0.007	my8036_rel.cz11a_c8r32
0.000	3.611	95.917	0.472	0.000	0.000	0.000	0.000	0.000	0.000	0.007	my8037_rel.cz11a_c8r32
0.000	43.278	56.139	0.583	0.000	0.000	0.000	0.000	0.000	0.000	0.013	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
0.000	12.861	86.833	0.278	0.028	0.000	0.000	0.000	0.000	0.000	0.022	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
0.000	10.194	89.583	0.194	0.028	0.000	0.000	0.000	0.000	0.000	0.022	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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
99.964	0.033	0.001	0.002	0.000	0.000	0.000	0.000	0.000	0.000	0.009	my5651_rel.cz11a_c8r32
99.974	0.026	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.005	my5744_rel.cz11a_c8r32
99.936	0.064	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.006	my8028_rel.cz11a_c8r32
99.910	0.090	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8032_rel.cz11a_c8r32
99.958	0.041	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8036_rel.cz11a_c8r32
99.960	0.040	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8037_rel.cz11a_c8r32
67.208	24.004	8.787	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.033	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
66.520	31.012	2.468	0.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.028	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
68.518	24.512	6.970	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.032	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	13.989	76.783	9.139	0.089	0.000	0.000	0.000	0.000	0.000	0.022	my5651_rel.cz11a_c8r32
0.000	7.589	92.139	0.272	0.000	0.000	0.000	0.000	0.000	0.000	0.012	my5744_rel.cz11a_c8r32
0.000	0.017	99.844	0.139	0.000	0.000	0.000	0.000	0.000	0.000	0.015	my8028_rel.cz11a_c8r32
0.000	0.000	99.872	0.122	0.006	0.000	0.000	0.000	0.000	0.000	0.023	my8032_rel.cz11a_c8r32
0.000	0.000	99.817	0.183	0.000	0.000	0.000	0.000	0.000	0.000	0.014	my8036_rel.cz11a_c8r32
0.000	0.000	99.850	0.150	0.000	0.000	0.000	0.000	0.000	0.000	0.014	my8037_rel.cz11a_c8r32
0.000	83.806	16.000	0.189	0.006	0.000	0.000	0.000	0.000	0.000	0.017	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
0.000	18.083	81.739	0.094	0.083	0.000	0.000	0.000	0.000	0.000	0.022	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
0.000	9.739	90.072	0.100	0.089	0.000	0.000	0.000	0.000	0.000	0.024	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	23.772	67.028	9.156	0.044	0.000	0.000	0.000	0.000	0.000	0.022	my5651_rel.cz11a_c8r32
0.000	88.289	11.506	0.206	0.000	0.000	0.000	0.000	0.000	0.000	0.012	my5744_rel.cz11a_c8r32
0.000	89.339	10.606	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.008	my8028_rel.cz11a_c8r32
0.000	55.050	44.878	0.067	0.006	0.000	0.000	0.000	0.000	0.000	0.023	my8032_rel.cz11a_c8r32
0.000	81.017	18.822	0.161	0.000	0.000	0.000	0.000	0.000	0.000	0.007	my8036_rel.cz11a_c8r32
0.000	78.561	21.333	0.106	0.000	0.000	0.000	0.000	0.000	0.000	0.008	my8037_rel.cz11a_c8r32
0.000	84.361	15.450	0.183	0.006	0.000	0.000	0.000	0.000	0.000	0.017	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
0.000	31.383	68.433	0.100	0.083	0.000	0.000	0.000	0.000	0.000	0.023	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
0.000	19.650	80.178	0.089	0.083	0.000	0.000	0.000	0.000	0.000	0.024	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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
99.921	0.076	0.001	0.001	0.000	0.000	0.000	0.000	0.000	0.000	0.010	my5651_rel.cz11a_c8r32
99.885	0.115	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.005	my5744_rel.cz11a_c8r32
99.803	0.197	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.011	my8028_rel.cz11a_c8r32
99.796	0.204	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8032_rel.cz11a_c8r32
99.762	0.238	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8036_rel.cz11a_c8r32
99.795	0.205	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8037_rel.cz11a_c8r32
99.720	0.280	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
99.535	0.465	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
99.566	0.434	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	12.794	77.939	9.194	0.072	0.000	0.000	0.000	0.000	0.000	0.023	my5651_rel.cz11a_c8r32
0.000	0.561	99.194	0.244	0.000	0.000	0.000	0.000	0.000	0.000	0.013	my5744_rel.cz11a_c8r32
0.000	0.000	99.883	0.117	0.000	0.000	0.000	0.000	0.000	0.000	0.014	my8028_rel.cz11a_c8r32
0.000	0.000	99.833	0.161	0.006	0.000	0.000	0.000	0.000	0.000	0.017	my8032_rel.cz11a_c8r32
0.000	0.000	99.933	0.050	0.017	0.000	0.000	0.000	0.000	0.000	0.023	my8036_rel.cz11a_c8r32
0.000	0.000	99.822	0.172	0.006	0.000	0.000	0.000	0.000	0.000	0.028	my8037_rel.cz11a_c8r32
0.000	78.300	21.500	0.200	0.000	0.000	0.000	0.000	0.000	0.000	0.014	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
0.000	10.794	88.994	0.133	0.078	0.000	0.000	0.000	0.000	0.000	0.022	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
0.000	7.417	92.372	0.128	0.083	0.000	0.000	0.000	0.000	0.000	0.022	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	22.833	67.978	9.128	0.061	0.000	0.000	0.000	0.000	0.000	0.022	my5651_rel.cz11a_c8r32
0.000	79.628	20.150	0.222	0.000	0.000	0.000	0.000	0.000	0.000	0.013	my5744_rel.cz11a_c8r32
0.000	85.489	14.428	0.083	0.000	0.000	0.000	0.000	0.000	0.000	0.014	my8028_rel.cz11a_c8r32
0.000	29.822	70.033	0.144	0.000	0.000	0.000	0.000	0.000	0.000	0.010	my8032_rel.cz11a_c8r32
0.000	46.589	53.344	0.056	0.011	0.000	0.000	0.000	0.000	0.000	0.023	my8036_rel.cz11a_c8r32
0.000	44.000	55.894	0.100	0.006	0.000	0.000	0.000	0.000	0.000	0.028	my8037_rel.cz11a_c8r32
0.000	78.506	21.306	0.189	0.000	0.000	0.000	0.000	0.000	0.000	0.014	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
0.000	21.761	78.028	0.133	0.078	0.000	0.000	0.000	0.000	0.000	0.022	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
0.000	14.511	85.278	0.133	0.078	0.000	0.000	0.000	0.000	0.000	0.023	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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
99.959	0.037	0.001	0.002	0.000	0.000	0.000	0.000	0.000	0.000	0.014	my5651_rel.cz11a_c8r32
99.965	0.035	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.004	my5744_rel.cz11a_c8r32
99.929	0.071	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8028_rel.cz11a_c8r32
99.889	0.111	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8032_rel.cz11a_c8r32
99.950	0.049	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8036_rel.cz11a_c8r32
99.949	0.051	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8037_rel.cz11a_c8r32
71.006	28.132	0.862	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.044	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
67.546	32.441	0.013	0.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.031	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
69.841	25.652	4.507	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.043	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	17.550	76.542	5.836	0.072	0.000	0.000	0.000	0.000	0.000	0.025	my5651_rel.cz11a_c8r32
0.000	11.481	88.283	0.231	0.006	0.000	0.000	0.000	0.000	0.000	0.019	my5744_rel.cz11a_c8r32
0.000	0.036	99.769	0.194	0.000	0.000	0.000	0.000	0.000	0.000	0.015	my8028_rel.cz11a_c8r32
0.000	0.000	99.856	0.142	0.003	0.000	0.000	0.000	0.000	0.000	0.023	my8032_rel.cz11a_c8r32
0.000	0.000	99.758	0.239	0.003	0.000	0.000	0.000	0.000	0.000	0.023	my8036_rel.cz11a_c8r32
0.000	0.000	99.881	0.117	0.003	0.000	0.000	0.000	0.000	0.000	0.019	my8037_rel.cz11a_c8r32
0.000	90.361	9.494	0.142	0.003	0.000	0.000	0.000	0.000	0.000	0.062	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
0.000	24.744	75.053	0.111	0.089	0.003	0.000	0.000	0.000	0.000	0.067	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
0.000	13.656	86.089	0.175	0.081	0.000	0.000	0.000	0.000	0.000	0.051	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	32.400	61.889	5.661	0.050	0.000	0.000	0.000	0.000	0.000	0.026	my5651_rel.cz11a_c8r32
0.000	92.669	7.139	0.192	0.000	0.000	0.000	0.000	0.000	0.000	0.014	my5744_rel.cz11a_c8r32
0.000	93.206	6.653	0.142	0.000	0.000	0.000	0.000	0.000	0.000	0.014	my8028_rel.cz11a_c8r32
0.000	59.206	40.675	0.117	0.003	0.000	0.000	0.000	0.000	0.000	0.022	my8032_rel.cz11a_c8r32
0.000	84.367	15.472	0.158	0.003	0.000	0.000	0.000	0.000	0.000	0.023	my8036_rel.cz11a_c8r32
0.000	84.203	15.703	0.092	0.003	0.000	0.000	0.000	0.000	0.000	0.019	my8037_rel.cz11a_c8r32
0.000	89.992	9.861	0.144	0.003	0.000	0.000	0.000	0.000	0.000	0.062	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
0.000	32.022	67.778	0.111	0.089	0.000	0.000	0.000	0.000	0.000	0.048	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
0.000	19.294	80.458	0.169	0.075	0.003	0.000	0.000	0.000	0.000	0.073	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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
99.855	0.140	0.003	0.002	0.000	0.000	0.000	0.000	0.000	0.000	0.010	my5651_rel.cz11a_c8r32
99.856	0.144	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my5744_rel.cz11a_c8r32
99.748	0.252	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8028_rel.cz11a_c8r32
99.711	0.289	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8032_rel.cz11a_c8r32
99.660	0.340	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	my8036_rel.cz11a_c8r32
99.620	0.380	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8037_rel.cz11a_c8r32
99.655	0.345	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
99.417	0.582	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
99.427	0.573	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	17.981	77.272	4.711	0.036	0.000	0.000	0.000	0.000	0.000	0.022	my5651_rel.cz11a_c8r32
0.000	4.814	95.014	0.172	0.000	0.000	0.000	0.000	0.000	0.000	0.016	my5744_rel.cz11a_c8r32
0.000	0.003	99.900	0.097	0.000	0.000	0.000	0.000	0.000	0.000	0.015	my8028_rel.cz11a_c8r32
0.000	0.000	99.764	0.233	0.003	0.000	0.000	0.000	0.000	0.000	0.026	my8032_rel.cz11a_c8r32
0.000	0.000	99.753	0.244	0.003	0.000	0.000	0.000	0.000	0.000	0.018	my8036_rel.cz11a_c8r32
0.000	0.000	99.758	0.233	0.006	0.000	0.003	0.000	0.000	0.000	0.272	my8037_rel.cz11a_c8r32
0.000	87.639	12.194	0.164	0.003	0.000	0.000	0.000	0.000	0.000	0.048	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
0.000	20.431	79.386	0.097	0.083	0.003	0.000	0.000	0.000	0.000	0.066	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
0.000	11.244	88.492	0.178	0.086	0.000	0.000	0.000	0.000	0.000	0.049	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	32.139	63.150	4.686	0.025	0.000	0.000	0.000	0.000	0.000	0.022	my5651_rel.cz11a_c8r32
0.000	89.797	10.069	0.131	0.003	0.000	0.000	0.000	0.000	0.000	0.017	my5744_rel.cz11a_c8r32
0.000	90.683	9.239	0.078	0.000	0.000	0.000	0.000	0.000	0.000	0.013	my8028_rel.cz11a_c8r32
0.000	45.061	54.775	0.161	0.003	0.000	0.000	0.000	0.000	0.000	0.026	my8032_rel.cz11a_c8r32
0.000	59.783	40.064	0.150	0.003	0.000	0.000	0.000	0.000	0.000	0.018	my8036_rel.cz11a_c8r32
0.000	58.772	41.089	0.136	0.000	0.000	0.003	0.000	0.000	0.000	0.290	my8037_rel.cz11a_c8r32
0.000	88.042	11.794	0.161	0.003	0.000	0.000	0.000	0.000	0.000	0.048	fbmy5635_rel_240606_4f3a57a1.cza1_c8r32
0.000	26.283	73.531	0.097	0.089	0.000	0.000	0.000	0.000	0.000	0.051	fbmy8028_rel_240606_c6c83b18.cza1_c8r32
0.000	16.042	83.700	0.169	0.089	0.000	0.000	0.000	0.000	0.000	0.041	fbmy8032_rel_240606_59f03d5a.cza1_c8r32

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