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:


Contents


Summary

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

dbmsl.i0l.xl.i1l.i2qr100qp100qr500qp500qr1000qp1000
my5651_rel.cz11a_c8r32 1724141435413294921739107498804106478778108438833
my5744_rel.cz11a_c8r32 1530612238813484321882895476279040757589757553
my8028_rel.cz11a_c8r32 1190483000013597120000773165477729656777646505
my8032_rel.cz11a_c8r32 1048952777793189818248723560517207601871766024
my8036_rel.cz11a_c8r32 1030932608703212818248817760808159610581106108
my8037_rel.cz11a_c8r32 1052632803753228418349805661338084605880756075
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32 1456311562504504517575320456822902569137405637
fbmy8028_rel_240606_c6c83b18.cza1_c8r32 1023891363643933115873447750593258507434015085
fbmy8032_rel_240606_59f03d5a.cza1_c8r32 964631339294140815504258649612913492531114960

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

dbmsl.i0l.xl.i1l.i2qr100qp100qr500qp500qr1000qp1000
my5651_rel.cz11a_c8r32 1.001.001.001.001.001.001.001.001.001.00
my5744_rel.cz11a_c8r32 0.891.561.061.010.830.870.850.860.830.86
my8028_rel.cz11a_c8r32 0.692.091.090.920.720.740.730.750.720.74
my8032_rel.cz11a_c8r32 0.611.940.970.840.670.690.680.690.660.68
my8036_rel.cz11a_c8r32 0.601.820.980.840.760.690.770.700.750.69
my8037_rel.cz11a_c8r32 0.611.950.980.840.750.700.760.690.740.69
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32 0.841.091.370.810.300.650.270.650.340.64
fbmy8028_rel_240606_c6c83b18.cza1_c8r32 0.590.951.190.730.420.570.310.580.310.58
fbmy8032_rel_240606_59f03d5a.cza1_c8r32 0.560.931.260.710.240.560.270.560.290.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.

dbmsqr100.L1qp100.L2qr500.L3qp500.L4qr1000.L5qp1000.L6
my5651_rel.cz11a_c8r32100100499499999999
my5744_rel.cz11a_c8r32100100499499999999
my8028_rel.cz11a_c8r32100100499499999999
my8032_rel.cz11a_c8r32100100499499999999
my8036_rel.cz11a_c8r32100100499499999999
my8037_rel.cz11a_c8r32100100499499999999
fbmy5635_rel_240606_4f3a57a1.cza1_c8r32100100499499999999
fbmy8028_rel_240606_c6c83b18.cza1_c8r32100100499499999999
fbmy8032_rel_240606_59f03d5a.cza1_c8r32100100499499999999
target10010050050010001000

l.i0

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

Average throughput:

Image

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

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel.cz11a_c8r3299.2640.6730.0480.0140.0010.152
my5744_rel.cz11a_c8r3299.5350.1980.1370.1300.0010.090
my8028_rel.cz11a_c8r3299.2850.3440.2390.1310.0020.091
my8032_rel.cz11a_c8r3298.6080.9950.2630.1330.0020.082
my8036_rel.cz11a_c8r3296.6622.9370.2630.1370.0020.082
my8037_rel.cz11a_c8r3298.5451.0590.2550.1390.0020.082
fbmy5635_rel_240606_4f3a57a1.cza1_c8r3299.8080.1200.0690.0030.115
fbmy8028_rel_240606_c6c83b18.cza1_c8r3295.7544.0450.1450.0520.0040.147
fbmy8032_rel_240606_59f03d5a.cza1_c8r3278.87720.9150.1480.0560.0040.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:

Image

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
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:

Image

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

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel.cz11a_c8r3210.33987.6721.8130.1750.0010.081
my5744_rel.cz11a_c8r323.92794.3881.6440.0410.0010.093
my8028_rel.cz11a_c8r32nonzero98.6361.2940.0690.0010.094
my8032_rel.cz11a_c8r3298.2801.6230.0950.0010.102
my8036_rel.cz11a_c8r3298.3171.5930.0890.0010.102
my8037_rel.cz11a_c8r3298.3391.5750.0850.001nonzero0.278
fbmy5635_rel_240606_4f3a57a1.cza1_c8r3286.91912.9830.0930.0010.0040.125
fbmy8028_rel_240606_c6c83b18.cza1_c8r3227.80971.9730.1650.0510.0030.147
fbmy8032_rel_240606_59f03d5a.cza1_c8r3215.72484.0540.1710.0470.0040.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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel.cz11a_c8r3277.27521.4651.1210.1380.0010.080
my5744_rel.cz11a_c8r3266.86231.8561.2670.0150.0010.093
my8028_rel.cz11a_c8r3293.5575.3911.0350.0160.0010.078
my8032_rel.cz11a_c8r3251.50347.1911.2770.0290.0010.108
my8036_rel.cz11a_c8r3264.97633.7371.2640.0220.0010.101
my8037_rel.cz11a_c8r3265.26433.4761.2340.0260.001nonzero0.284
fbmy5635_rel_240606_4f3a57a1.cza1_c8r3285.87814.0150.0970.0070.0030.125
fbmy8028_rel_240606_c6c83b18.cza1_c8r3232.70867.0650.1630.0610.0030.133
fbmy8032_rel_240606_59f03d5a.cza1_c8r3221.75478.0170.1680.0570.0040.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:

Image

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

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel.cz11a_c8r3286.69313.1770.0140.1120.004nonzero0.067
my5744_rel.cz11a_c8r3288.62611.1930.0540.1260.001nonzero0.113
my8028_rel.cz11a_c8r3284.66015.2260.0030.111nonzerononzero0.099
my8032_rel.cz11a_c8r3275.29124.5770.0040.1270.001nonzero0.101
my8036_rel.cz11a_c8r3275.33824.5280.0040.1290.0010.059
my8037_rel.cz11a_c8r3276.60523.2580.0040.1310.001nonzero0.101
fbmy5635_rel_240606_4f3a57a1.cza1_c8r3298.7461.2220.0060.025nonzero0.0010.079
fbmy8028_rel_240606_c6c83b18.cza1_c8r3269.09830.8470.0070.0400.0070.0010.109
fbmy8032_rel_240606_59f03d5a.cza1_c8r3247.31052.6330.0060.0430.007nonzero0.078

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

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel.cz11a_c8r3296.9332.9370.0150.1120.004nonzero0.068
my5744_rel.cz11a_c8r3292.1187.7500.0090.1220.001nonzero0.113
my8028_rel.cz11a_c8r3295.3584.5350.0010.105nonzerononzero0.106
my8032_rel.cz11a_c8r3286.67913.1990.0010.1190.001nonzero0.101
my8036_rel.cz11a_c8r3287.53012.3450.0010.1220.0010.060
my8037_rel.cz11a_c8r3289.49510.3790.0010.1240.001nonzero0.101
fbmy5635_rel_240606_4f3a57a1.cza1_c8r3295.1874.7810.0060.026nonzero0.0010.079
fbmy8028_rel_240606_c6c83b18.cza1_c8r3225.12574.8170.0080.0420.008nonzero0.089
fbmy8032_rel_240606_59f03d5a.cza1_c8r320.83199.1090.0080.0450.007nonzero0.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:

Image

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

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel.cz11a_c8r3299.9680.0280.0020.003nonzero0.020
my5744_rel.cz11a_c8r3299.9810.019nonzerononzero0.010
my8028_rel.cz11a_c8r3299.9460.054nonzero0.001
my8032_rel.cz11a_c8r3299.9240.076nonzero0.002
my8036_rel.cz11a_c8r3299.9610.039nonzerononzero0.012
my8037_rel.cz11a_c8r3299.9660.034nonzero0.002
fbmy5635_rel_240606_4f3a57a1.cza1_c8r3280.75114.3104.939nonzerononzero0.036
fbmy8028_rel_240606_c6c83b18.cza1_c8r3280.27919.7210.0010.002
fbmy8032_rel_240606_59f03d5a.cza1_c8r3266.57023.06310.366nonzero0.034

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

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel.cz11a_c8r320.50049.19447.2503.0560.033
my5744_rel.cz11a_c8r320.69498.8330.4720.015
my8028_rel.cz11a_c8r3299.8610.1390.013
my8032_rel.cz11a_c8r3299.9440.0560.012
my8036_rel.cz11a_c8r3299.5830.4170.014
my8037_rel.cz11a_c8r3299.7220.2780.013
fbmy5635_rel_240606_4f3a57a1.cza1_c8r3238.72260.9170.3610.013
fbmy8028_rel_240606_c6c83b18.cza1_c8r327.94491.5000.5000.0560.017
fbmy8032_rel_240606_59f03d5a.cza1_c8r322.97296.6670.3330.0280.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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel.cz11a_c8r323.36146.16748.5561.9170.034
my5744_rel.cz11a_c8r3251.33348.2500.4170.013
my8028_rel.cz11a_c8r3252.22247.6110.1670.010
my8032_rel.cz11a_c8r3231.25068.6670.0830.008
my8036_rel.cz11a_c8r3237.38962.1390.4720.014
my8037_rel.cz11a_c8r3246.80652.9170.2780.008
fbmy5635_rel_240606_4f3a57a1.cza1_c8r3247.58352.0560.3610.013
fbmy8028_rel_240606_c6c83b18.cza1_c8r3230.91768.5560.4720.0560.016
fbmy8032_rel_240606_59f03d5a.cza1_c8r3218.00081.6670.3060.0280.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:

Image

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

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel.cz11a_c8r3299.9500.0460.0010.0020.009
my5744_rel.cz11a_c8r3299.9230.077nonzero0.002
my8028_rel.cz11a_c8r3299.8400.160nonzero0.002
my8032_rel.cz11a_c8r3299.8270.173nonzero0.002
my8036_rel.cz11a_c8r3299.7770.223nonzero0.002
my8037_rel.cz11a_c8r3299.8310.169nonzero0.001
fbmy5635_rel_240606_4f3a57a1.cza1_c8r3299.7060.294nonzero0.002
fbmy8028_rel_240606_c6c83b18.cza1_c8r3299.6230.377nonzero0.004
fbmy8032_rel_240606_59f03d5a.cza1_c8r3299.5730.426nonzero0.002

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

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel.cz11a_c8r3255.00044.6110.3890.022
my5744_rel.cz11a_c8r3299.6390.3610.013
my8028_rel.cz11a_c8r3299.8330.1670.014
my8032_rel.cz11a_c8r3299.8610.1110.0280.023
my8036_rel.cz11a_c8r3299.7220.2780.011
my8037_rel.cz11a_c8r3299.5560.4440.014
fbmy5635_rel_240606_4f3a57a1.cza1_c8r3227.97271.4170.6110.014
fbmy8028_rel_240606_c6c83b18.cza1_c8r321.30698.3610.2780.0560.022
fbmy8032_rel_240606_59f03d5a.cza1_c8r321.05698.6670.2220.0560.022

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

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel.cz11a_c8r321.61153.41744.7220.2500.022
my5744_rel.cz11a_c8r3237.19462.4720.3330.013
my8028_rel.cz11a_c8r3233.72266.1390.1390.012
my8032_rel.cz11a_c8r320.05699.7780.1390.0280.023
my8036_rel.cz11a_c8r325.66794.0280.3060.007
my8037_rel.cz11a_c8r323.61195.9170.4720.007
fbmy5635_rel_240606_4f3a57a1.cza1_c8r3243.27856.1390.5830.013
fbmy8028_rel_240606_c6c83b18.cza1_c8r3212.86186.8330.2780.0280.022
fbmy8032_rel_240606_59f03d5a.cza1_c8r3210.19489.5830.1940.0280.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:

Image

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

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel.cz11a_c8r3299.9640.0330.0010.0020.009
my5744_rel.cz11a_c8r3299.9740.026nonzerononzero0.005
my8028_rel.cz11a_c8r3299.9360.064nonzerononzero0.006
my8032_rel.cz11a_c8r3299.9100.090nonzero0.002
my8036_rel.cz11a_c8r3299.9580.041nonzero0.002
my8037_rel.cz11a_c8r3299.9600.040nonzero0.002
fbmy5635_rel_240606_4f3a57a1.cza1_c8r3267.20824.0048.787nonzerononzero0.033
fbmy8028_rel_240606_c6c83b18.cza1_c8r3266.52031.0122.468nonzero0.028
fbmy8032_rel_240606_59f03d5a.cza1_c8r3268.51824.5126.970nonzerononzero0.032

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

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel.cz11a_c8r3213.98976.7839.1390.0890.022
my5744_rel.cz11a_c8r327.58992.1390.2720.012
my8028_rel.cz11a_c8r320.01799.8440.1390.015
my8032_rel.cz11a_c8r3299.8720.1220.0060.023
my8036_rel.cz11a_c8r3299.8170.1830.014
my8037_rel.cz11a_c8r3299.8500.1500.014
fbmy5635_rel_240606_4f3a57a1.cza1_c8r3283.80616.0000.1890.0060.017
fbmy8028_rel_240606_c6c83b18.cza1_c8r3218.08381.7390.0940.0830.022
fbmy8032_rel_240606_59f03d5a.cza1_c8r329.73990.0720.1000.0890.024

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

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel.cz11a_c8r3223.77267.0289.1560.0440.022
my5744_rel.cz11a_c8r3288.28911.5060.2060.012
my8028_rel.cz11a_c8r3289.33910.6060.0560.008
my8032_rel.cz11a_c8r3255.05044.8780.0670.0060.023
my8036_rel.cz11a_c8r3281.01718.8220.1610.007
my8037_rel.cz11a_c8r3278.56121.3330.1060.008
fbmy5635_rel_240606_4f3a57a1.cza1_c8r3284.36115.4500.1830.0060.017
fbmy8028_rel_240606_c6c83b18.cza1_c8r3231.38368.4330.1000.0830.023
fbmy8032_rel_240606_59f03d5a.cza1_c8r3219.65080.1780.0890.0830.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:

Image

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

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel.cz11a_c8r3299.9210.0760.0010.0010.010
my5744_rel.cz11a_c8r3299.8850.115nonzerononzero0.005
my8028_rel.cz11a_c8r3299.8030.197nonzerononzero0.011
my8032_rel.cz11a_c8r3299.7960.204nonzero0.002
my8036_rel.cz11a_c8r3299.7620.238nonzero0.002
my8037_rel.cz11a_c8r3299.7950.205nonzero0.002
fbmy5635_rel_240606_4f3a57a1.cza1_c8r3299.7200.280nonzero0.002
fbmy8028_rel_240606_c6c83b18.cza1_c8r3299.5350.465nonzero0.003
fbmy8032_rel_240606_59f03d5a.cza1_c8r3299.5660.434nonzero0.001

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

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel.cz11a_c8r3212.79477.9399.1940.0720.023
my5744_rel.cz11a_c8r320.56199.1940.2440.013
my8028_rel.cz11a_c8r3299.8830.1170.014
my8032_rel.cz11a_c8r3299.8330.1610.0060.017
my8036_rel.cz11a_c8r3299.9330.0500.0170.023
my8037_rel.cz11a_c8r3299.8220.1720.0060.028
fbmy5635_rel_240606_4f3a57a1.cza1_c8r3278.30021.5000.2000.014
fbmy8028_rel_240606_c6c83b18.cza1_c8r3210.79488.9940.1330.0780.022
fbmy8032_rel_240606_59f03d5a.cza1_c8r327.41792.3720.1280.0830.022

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

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel.cz11a_c8r3222.83367.9789.1280.0610.022
my5744_rel.cz11a_c8r3279.62820.1500.2220.013
my8028_rel.cz11a_c8r3285.48914.4280.0830.014
my8032_rel.cz11a_c8r3229.82270.0330.1440.010
my8036_rel.cz11a_c8r3246.58953.3440.0560.0110.023
my8037_rel.cz11a_c8r3244.00055.8940.1000.0060.028
fbmy5635_rel_240606_4f3a57a1.cza1_c8r3278.50621.3060.1890.014
fbmy8028_rel_240606_c6c83b18.cza1_c8r3221.76178.0280.1330.0780.022
fbmy8032_rel_240606_59f03d5a.cza1_c8r3214.51185.2780.1330.0780.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:

Image

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

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel.cz11a_c8r3299.9590.0370.0010.0020.014
my5744_rel.cz11a_c8r3299.9650.035nonzero0.004
my8028_rel.cz11a_c8r3299.9290.071nonzero0.002
my8032_rel.cz11a_c8r3299.8890.111nonzero0.002
my8036_rel.cz11a_c8r3299.9500.049nonzero0.002
my8037_rel.cz11a_c8r3299.9490.051nonzero0.002
fbmy5635_rel_240606_4f3a57a1.cza1_c8r3271.00628.1320.862nonzerononzero0.044
fbmy8028_rel_240606_c6c83b18.cza1_c8r3267.54632.4410.013nonzero0.031
fbmy8032_rel_240606_59f03d5a.cza1_c8r3269.84125.6524.507nonzerononzero0.043

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

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel.cz11a_c8r3217.55076.5425.8360.0720.025
my5744_rel.cz11a_c8r3211.48188.2830.2310.0060.019
my8028_rel.cz11a_c8r320.03699.7690.1940.015
my8032_rel.cz11a_c8r3299.8560.1420.0030.023
my8036_rel.cz11a_c8r3299.7580.2390.0030.023
my8037_rel.cz11a_c8r3299.8810.1170.0030.019
fbmy5635_rel_240606_4f3a57a1.cza1_c8r3290.3619.4940.1420.0030.062
fbmy8028_rel_240606_c6c83b18.cza1_c8r3224.74475.0530.1110.0890.0030.067
fbmy8032_rel_240606_59f03d5a.cza1_c8r3213.65686.0890.1750.0810.051

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

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel.cz11a_c8r3232.40061.8895.6610.0500.026
my5744_rel.cz11a_c8r3292.6697.1390.1920.014
my8028_rel.cz11a_c8r3293.2066.6530.1420.014
my8032_rel.cz11a_c8r3259.20640.6750.1170.0030.022
my8036_rel.cz11a_c8r3284.36715.4720.1580.0030.023
my8037_rel.cz11a_c8r3284.20315.7030.0920.0030.019
fbmy5635_rel_240606_4f3a57a1.cza1_c8r3289.9929.8610.1440.0030.062
fbmy8028_rel_240606_c6c83b18.cza1_c8r3232.02267.7780.1110.0890.048
fbmy8032_rel_240606_59f03d5a.cza1_c8r3219.29480.4580.1690.0750.0030.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:

Image

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

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel.cz11a_c8r3299.8550.1400.0030.0020.010
my5744_rel.cz11a_c8r3299.8560.144nonzero0.002
my8028_rel.cz11a_c8r3299.7480.252nonzero0.002
my8032_rel.cz11a_c8r3299.7110.289nonzero0.002
my8036_rel.cz11a_c8r3299.6600.340nonzero0.001
my8037_rel.cz11a_c8r3299.6200.380nonzero0.002
fbmy5635_rel_240606_4f3a57a1.cza1_c8r3299.6550.345nonzero0.002
fbmy8028_rel_240606_c6c83b18.cza1_c8r3299.4170.582nonzero0.002
fbmy8032_rel_240606_59f03d5a.cza1_c8r3299.4270.573nonzero0.003

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

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel.cz11a_c8r3217.98177.2724.7110.0360.022
my5744_rel.cz11a_c8r324.81495.0140.1720.016
my8028_rel.cz11a_c8r320.00399.9000.0970.015
my8032_rel.cz11a_c8r3299.7640.2330.0030.026
my8036_rel.cz11a_c8r3299.7530.2440.0030.018
my8037_rel.cz11a_c8r3299.7580.2330.0060.0030.272
fbmy5635_rel_240606_4f3a57a1.cza1_c8r3287.63912.1940.1640.0030.048
fbmy8028_rel_240606_c6c83b18.cza1_c8r3220.43179.3860.0970.0830.0030.066
fbmy8032_rel_240606_59f03d5a.cza1_c8r3211.24488.4920.1780.0860.049

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

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel.cz11a_c8r3232.13963.1504.6860.0250.022
my5744_rel.cz11a_c8r3289.79710.0690.1310.0030.017
my8028_rel.cz11a_c8r3290.6839.2390.0780.013
my8032_rel.cz11a_c8r3245.06154.7750.1610.0030.026
my8036_rel.cz11a_c8r3259.78340.0640.1500.0030.018
my8037_rel.cz11a_c8r3258.77241.0890.1360.0030.290
fbmy5635_rel_240606_4f3a57a1.cza1_c8r3288.04211.7940.1610.0030.048
fbmy8028_rel_240606_c6c83b18.cza1_c8r3226.28373.5310.0970.0890.051
fbmy8032_rel_240606_59f03d5a.cza1_c8r3216.04283.7000.1690.0890.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

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

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


l.i1

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	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

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

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

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

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

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

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

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