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, 32G RAM and an NVMe device for the database. 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 with a table per client. 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 by InnoDB. Clients and the DBMS share one server.

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_o2nofp.cz12a_c8r32 1851851456323347323419131361119313110111241302011214
my5744_rel_o2nofp.cz12a_c8r32 1675982222233879725510108389291108859346108649255
my8043_rel_o2nofp.cz12a_c8r32 1102943658553493420161900269738996698690426954
my8044_rel_o2nofp.cz12a_c8r32 1119403529423518020284912869869132694390976943
my8406_rel_o2nofp.cz12a_c8r32 1102943750013490420080893168388886679988826800
my8407_rel_o2nofp.cz12a_c8r32 1086963703723475220040887468008884674487686689
my8407_rel_o2nofp.cz12a_dw0_c8r32 1102943947383558720000885868388882677588146814
my9400_rel_o2nofp.cz12a_c8r32 1098903750013463220121902269329024690191016886
my9500_rel_o2nofp.cz12a_c8r32 1086963797483502619881904669508992692689656923

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_o2nofp.cz12a_c8r32 1.001.001.001.001.001.001.001.001.001.00
my5744_rel_o2nofp.cz12a_c8r32 0.911.531.161.090.830.830.830.840.830.83
my8043_rel_o2nofp.cz12a_c8r32 0.602.511.040.860.690.620.690.630.690.62
my8044_rel_o2nofp.cz12a_c8r32 0.602.421.050.870.690.620.700.620.700.62
my8406_rel_o2nofp.cz12a_c8r32 0.602.571.040.860.680.610.680.610.680.61
my8407_rel_o2nofp.cz12a_c8r32 0.592.541.040.860.680.610.680.610.670.60
my8407_rel_o2nofp.cz12a_dw0_c8r32 0.602.711.060.850.670.610.680.610.680.61
my9400_rel_o2nofp.cz12a_c8r32 0.592.571.030.860.690.620.690.620.700.61
my9500_rel_o2nofp.cz12a_c8r32 0.592.611.050.850.690.620.690.620.690.62

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_o2nofp.cz12a_c8r32100100500500999999
my5744_rel_o2nofp.cz12a_c8r3210010050050010001000
my8043_rel_o2nofp.cz12a_c8r321001005005009991000
my8044_rel_o2nofp.cz12a_c8r3210010050050010001000
my8406_rel_o2nofp.cz12a_c8r3210010050050010001000
my8407_rel_o2nofp.cz12a_c8r32100100500500999999
my8407_rel_o2nofp.cz12a_dw0_c8r321001005005009991000
my9400_rel_o2nofp.cz12a_c8r32100100500500999999
my9500_rel_o2nofp.cz12a_c8r3210010050050010001000
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_o2nofp.cz12a_c8r3299.7190.2250.0500.0050.0010.127
my5744_rel_o2nofp.cz12a_c8r3299.7170.0940.1080.0800.0010.130
my8043_rel_o2nofp.cz12a_c8r3299.5060.3010.1060.0850.0020.072
my8044_rel_o2nofp.cz12a_c8r3299.5030.3040.0800.1120.0010.074
my8406_rel_o2nofp.cz12a_c8r3299.4980.3090.1000.0910.0020.073
my8407_rel_o2nofp.cz12a_c8r3299.5010.3060.0860.1060.0020.073
my8407_rel_o2nofp.cz12a_dw0_c8r3299.5010.3060.0860.1050.0020.073
my9400_rel_o2nofp.cz12a_c8r3299.4960.3110.0790.1130.0020.074
my9500_rel_o2nofp.cz12a_c8r3299.4360.3680.0710.1240.0020.088

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
185185	0	1620	6.3	474.8	45.4	0.009	0.035	0.003	0.251	24151	20.2	0.130	9	2.0	32.5	3.5	0.127	185678	163682	my5651_rel_o2nofp.cz12a_c8r32
167598	0	0	0.0	510.9	43.1	0.000	0.000	0.003	0.263	19318	20.1	0.115	10	2.0	32.5	4.0	0.130	167876	149588	my5744_rel_o2nofp.cz12a_c8r32
110294	0	0	0.0	405.0	31.3	0.000	0.000	0.004	0.291	13626	17.2	0.124	12	2.0	32.6	4.2	0.072	110583	102691	my8043_rel_o2nofp.cz12a_c8r32
111940	0	0	0.0	412.3	31.9	0.000	0.000	0.004	0.292	13853	17.2	0.124	12	2.0	32.6	4.3	0.074	112584	103785	my8044_rel_o2nofp.cz12a_c8r32
110294	0	0	0.0	406.6	31.5	0.000	0.000	0.004	0.292	13692	17.2	0.124	12	2.0	34.0	4.3	0.073	111085	102388	my8406_rel_o2nofp.cz12a_c8r32
108696	0	0	0.0	402.0	31.0	0.000	0.000	0.004	0.292	13496	17.3	0.124	13	2.0	34.0	4.2	0.073	109183	100887	my8407_rel_o2nofp.cz12a_c8r32
110294	0	0	0.0	385.2	28.9	0.000	0.000	0.003	0.269	13602	17.2	0.123	12	2.0	33.9	4.2	0.073	110784	102885	my8407_rel_o2nofp.cz12a_dw0_c8r32
109890	0	0	0.0	406.4	31.4	0.000	0.000	0.004	0.293	13646	17.2	0.124	13	2.0	34.0	4.3	0.074	110686	101484	my9400_rel_o2nofp.cz12a_c8r32
108696	0	0	0.0	418.0	31.7	0.000	0.000	0.004	0.299	14430	17.3	0.133	13	2.0	34.0	4.4	0.088	109283	100784	my9500_rel_o2nofp.cz12a_c8r32

Average values from iostat.

r/s	rkB/s	rrqm/s	%rrqm	r_await	rareq-s	w/s	wkB/s	wrqm/s	%wrqm	w_await	wareq-s	d/s	dkB/s	drqm/s	%drqm	d_await	dareq-s	f/s	f_await	aqu-sz	%util	
1620.4	6481.7	0.000	0.000	0.040	4.000	481.4	46933.6	8.026	1.900	0.196	111.9	0.413	9.600	0.000	0.000	0.068	3.757	1.303	1.145	0.150	9.921		my5651_rel_o2nofp.cz12a_c8r32
0.159	0.635	0.000	0.000	2.993	2.235	517.2	44483.9	18.74	3.777	2.141	86.85	0.318	6.047	0.000	0.000	0.097	2.800	4.471	1.286	1.006	6.250		my5744_rel_o2nofp.cz12a_c8r32
0.094	0.377	0.000	0.000	1.717	1.585	408.4	32313.1	20.65	5.184	2.596	80.96	0.102	4.860	0.000	0.000	0.138	11.32	4.487	1.214	0.977	5.325		my8043_rel_o2nofp.cz12a_c8r32
0.096	0.385	0.000	0.000	2.183	1.692	415.7	32873.9	20.88	5.163	2.495	80.91	0.123	3.815	0.000	0.000	0.156	7.192	4.523	1.362	0.969	5.443		my8044_rel_o2nofp.cz12a_c8r32
0.102	0.408	0.000	0.000	2.292	1.660	410.2	32447.8	18.89	4.787	2.641	80.80	0.125	1.857	0.000	0.000	0.119	2.888	4.517	1.208	1.005	5.380		my8406_rel_o2nofp.cz12a_c8r32
0.089	0.356	0.000	0.000	1.278	1.407	405.1	31916.4	18.90	4.829	2.628	80.46	0.081	2.963	0.000	0.000	0.114	7.728	4.485	1.299	0.985	5.379		my8407_rel_o2nofp.cz12a_c8r32
0.075	0.302	0.000	0.000	1.745	1.358	388.2	29788.2	17.98	4.792	2.730	78.39	0.128	2.506	0.000	0.000	0.151	4.340	4.491	1.335	0.978	5.398		my8407_rel_o2nofp.cz12a_dw0_c8r32
0.098	0.392	0.000	0.000	1.755	1.736	409.8	32373.7	19.48	4.856	2.626	80.92	0.143	2.294	0.000	0.000	0.098	2.830	4.491	1.360	0.994	5.531		my9400_rel_o2nofp.cz12a_c8r32
0.111	0.622	0.000	0.000	1.481	2.148	421.2	32674.0	20.58	5.158	2.589	80.33	0.133	1.793	0.000	0.000	0.147	2.522	4.585	1.401	1.010	5.523		my9500_rel_o2nofp.cz12a_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
145632	0	32	0.1	2360.6	158.2	0.000	0.001	0.016	1.113	1939	10.7	0.013	6	4.2	34.7	5.1	0.002	NA	NA	my5651_rel_o2nofp.cz12a_c8r32
222223	0	0	0.0	3539.9	221.6	0.000	0.000	0.016	1.021	9583	12.1	0.043	4	4.6	35.1	5.5	0.001	NA	NA	my5744_rel_o2nofp.cz12a_c8r32
365855	0	2	0.0	11321.4	469.1	0.000	0.000	0.031	1.313	25129	40.4	0.069	9	4.5	35.1	5.0	0.001	NA	NA	my8043_rel_o2nofp.cz12a_c8r32
352942	0	1	0.0	10021.1	448.8	0.000	0.000	0.028	1.302	22641	41.9	0.064	9	4.5	35.1	4.8	0.001	NA	NA	my8044_rel_o2nofp.cz12a_c8r32
375001	0	2	0.0	10363.5	475.2	0.000	0.000	0.028	1.298	23146	41.9	0.062	9	4.5	36.5	5.1	0.002	NA	NA	my8406_rel_o2nofp.cz12a_c8r32
370372	0	1	0.0	11512.3	473.5	0.000	0.000	0.031	1.309	25409	40.9	0.069	9	4.5	36.5	5.0	0.001	NA	NA	my8407_rel_o2nofp.cz12a_c8r32
394738	0	1	0.0	10038.1	468.8	0.000	0.000	0.025	1.216	21876	42.9	0.055	9	4.5	36.5	4.9	0.002	NA	NA	my8407_rel_o2nofp.cz12a_dw0_c8r32
375001	0	1	0.0	12002.3	481.3	0.000	0.000	0.032	1.314	25695	39.9	0.069	9	4.5	36.5	5.1	0.002	NA	NA	my9400_rel_o2nofp.cz12a_c8r32
379748	0	1	0.0	10966.2	484.7	0.000	0.000	0.029	1.307	24664	41.3	0.065	9	4.5	36.5	5.4	0.002	NA	NA	my9500_rel_o2nofp.cz12a_c8r32

Average values from iostat.

r/s	rkB/s	rrqm/s	%rrqm	r_await	rareq-s	w/s	wkB/s	wrqm/s	%wrqm	w_await	wareq-s	d/s	dkB/s	drqm/s	%drqm	d_await	dareq-s	f/s	f_await	aqu-sz	%util	
32.62	130.5	0.000	0.000	0.036	2.800	2120.5	156846	151.9	5.927	0.213	82.41	0.530	6156.9	0.000	0.000	0.021	684.9	51.80	1.102	0.541	28.50		my5651_rel_o2nofp.cz12a_c8r32
0.232	0.928	0.000	0.000	0.048	1.920	3441.9	228121	20.89	0.668	0.080	106.0	0.976	9852.8	0.000	0.000	0.058	957.7	5.000	1.358	0.203	7.647		my5744_rel_o2nofp.cz12a_c8r32
1.507	20.59	0.000	0.000	0.074	12.63	10920.3	498402	45.39	2.246	0.075	73.45	9.947	64990.3	0.000	0.000	0.244	2474.1	10.93	1.419	0.384	23.86		my8043_rel_o2nofp.cz12a_c8r32
0.867	12.80	0.000	0.000	0.054	14.56	9529.0	476104	45.75	2.509	0.083	79.57	10.15	64985.5	0.000	0.000	0.191	1803.5	10.93	1.377	0.355	22.99		my8044_rel_o2nofp.cz12a_c8r32
1.457	27.43	0.000	0.000	0.069	26.63	9837.8	504086	48.81	2.349	0.077	76.82	11.36	69626.9	0.000	0.000	0.275	1882.2	11.60	1.431	0.367	23.85		my8406_rel_o2nofp.cz12a_c8r32
1.293	26.07	0.000	0.000	0.076	25.86	11103.3	501134	45.78	2.211	0.071	73.29	10.46	64889.6	0.000	0.000	0.275	2389.0	10.96	1.436	0.369	23.44		my8407_rel_o2nofp.cz12a_c8r32
1.000	18.11	0.000	0.000	0.084	18.09	9475.8	497001	49.82	2.331	0.080	77.19	10.51	69866.9	0.000	0.000	0.299	2035.0	11.60	1.364	0.467	23.21		my8407_rel_o2nofp.cz12a_dw0_c8r32
1.080	24.80	0.000	0.000	0.119	27.48	11648.0	509901	44.91	2.203	0.071	71.53	10.47	64999.8	0.000	0.000	0.313	1837.1	10.95	1.402	0.381	24.91		my9400_rel_o2nofp.cz12a_c8r32
1.142	18.50	0.000	0.000	0.075	23.34	10519.2	516824	49.45	2.475	0.080	76.85	11.45	69515.8	0.000	0.000	0.375	2191.5	11.54	1.474	0.393	24.16		my9500_rel_o2nofp.cz12a_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_o2nofp.cz12a_c8r3210.76287.3301.7600.148nonzero0.081
my5744_rel_o2nofp.cz12a_c8r3219.70179.7700.4990.0290.0010.086
my8043_rel_o2nofp.cz12a_c8r3299.3620.5690.068nonzerononzero0.294
my8044_rel_o2nofp.cz12a_c8r3299.3760.5560.0670.001nonzero0.318
my8406_rel_o2nofp.cz12a_c8r3299.3750.5540.0700.001nonzero0.299
my8407_rel_o2nofp.cz12a_c8r3299.3550.5780.0660.001nonzero0.321
my8407_rel_o2nofp.cz12a_dw0_c8r3299.5770.3680.055nonzerononzero0.302
my9400_rel_o2nofp.cz12a_c8r3299.3520.5790.0680.001nonzero0.331
my9500_rel_o2nofp.cz12a_c8r3299.3610.5670.072nonzerononzero0.326

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_o2nofp.cz12a_c8r3276.24222.6431.0000.115nonzero0.081
my5744_rel_o2nofp.cz12a_c8r3268.82531.0430.1230.0090.0010.086
my8043_rel_o2nofp.cz12a_c8r3285.30314.5060.1740.017nonzerononzero0.294
my8044_rel_o2nofp.cz12a_c8r3285.47114.3470.1660.016nonzero0.240
my8406_rel_o2nofp.cz12a_c8r3284.98714.8300.1690.014nonzero0.313
my8407_rel_o2nofp.cz12a_c8r3283.08916.7190.1750.017nonzero0.101
my8407_rel_o2nofp.cz12a_dw0_c8r3288.37111.5850.0300.015nonzerononzero0.302
my9400_rel_o2nofp.cz12a_c8r3282.79817.0110.1730.017nonzerononzero0.283
my9500_rel_o2nofp.cz12a_c8r3288.68211.1260.1750.0160.001nonzero0.326

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
33473	0	856	3.3	2507.9	109.3	0.026	0.102	0.075	3.342	34559	40.9	1.032	98	6.2	36.7	7.9	0.081	35546	9199	my5651_rel_o2nofp.cz12a_c8r32
38797	0	0	0.0	2862.5	125.6	0.000	0.000	0.074	3.314	24434	47.5	0.630	98	6.3	36.8	8.3	0.086	40445	11349	my5744_rel_o2nofp.cz12a_c8r32
34934	0	127	2.0	2773.9	115.6	0.004	0.058	0.079	3.389	43853	36.4	1.255	83	6.8	37.8	9.5	0.294	36146	6249	my8043_rel_o2nofp.cz12a_c8r32
35180	0	128	2.0	2795.8	116.5	0.004	0.058	0.079	3.391	43717	36.6	1.243	83	6.9	37.9	9.5	0.318	36296	6549	my8044_rel_o2nofp.cz12a_c8r32
34904	0	127	2.0	2689.6	113.3	0.004	0.058	0.077	3.323	43651	36.3	1.251	83	6.8	43.1	9.4	0.299	36096	6149	my8406_rel_o2nofp.cz12a_c8r32
34752	0	126	2.0	2739.7	114.8	0.004	0.058	0.079	3.381	43403	36.3	1.249	84	6.8	43.1	9.4	0.321	35995	6649	my8407_rel_o2nofp.cz12a_c8r32
35587	0	0	0.0	2513.0	83.7	0.000	0.000	0.071	2.407	43974	36.5	1.236	82	6.8	43.1	9.4	0.302	36647	7949	my8407_rel_o2nofp.cz12a_dw0_c8r32
34632	0	126	2.0	2724.8	114.2	0.004	0.058	0.079	3.376	43391	36.1	1.253	83	6.8	43.1	9.4	0.331	35896	6649	my9400_rel_o2nofp.cz12a_c8r32
35026	0	127	2.0	2712.2	114.5	0.004	0.058	0.077	3.346	43260	36.3	1.235	83	6.8	42.9	9.4	0.326	36146	4749	my9500_rel_o2nofp.cz12a_c8r32

Average values from iostat.

r/s	rkB/s	rrqm/s	%rrqm	r_await	rareq-s	w/s	wkB/s	wrqm/s	%wrqm	w_await	wareq-s	d/s	dkB/s	drqm/s	%drqm	d_await	dareq-s	f/s	f_await	aqu-sz	%util	
858.6	3434.3	0.000	0.000	0.059	3.797	2508.4	111120	29.60	1.176	0.219	45.28	0.141	4.486	0.000	0.000	0.081	4.848	9.098	1.109	0.553	12.41		my5651_rel_o2nofp.cz12a_c8r32
0.062	0.250	0.000	0.000	0.895	1.073	2863.1	128032	38.68	1.367	0.982	44.77	0.160	1.947	0.000	0.000	0.082	1.651	11.75	1.072	2.780	9.151		my5744_rel_o2nofp.cz12a_c8r32
75.63	1209.4	0.000	0.000	3.389	12.37	2782.2	118474	21.02	0.732	0.786	43.49	0.088	6.236	0.000	0.000	0.145	13.84	8.229	1.429	2.322	7.034		my8043_rel_o2nofp.cz12a_c8r32
76.34	1220.8	0.000	0.000	3.432	12.40	2804.4	119396	20.88	0.715	0.779	43.49	0.088	4.131	0.000	0.000	0.135	10.46	8.146	1.358	2.319	6.909		my8044_rel_o2nofp.cz12a_c8r32
75.43	1206.2	0.000	0.000	3.021	12.25	2697.4	116053	21.16	0.743	0.821	43.92	0.089	4.611	0.000	0.000	0.111	8.849	8.188	1.454	2.325	6.954		my8406_rel_o2nofp.cz12a_c8r32
75.48	1207.0	0.000	0.000	3.019	12.25	2747.8	117588	21.04	0.732	0.777	43.72	0.095	4.940	0.000	0.000	0.140	11.40	8.125	1.502	2.252	6.929		my8407_rel_o2nofp.cz12a_c8r32
0.054	0.248	0.000	0.000	1.339	1.166	2517.5	85266.0	21.87	0.817	1.501	34.74	0.114	4.890	0.000	0.000	0.121	8.648	9.210	1.471	3.708	6.716		my8407_rel_o2nofp.cz12a_dw0_c8r32
75.30	1204.2	0.000	0.000	2.908	12.25	2732.8	116987	21.42	0.745	0.829	43.69	0.097	3.002	0.000	0.000	0.137	5.777	8.144	1.542	2.375	7.033		my9400_rel_o2nofp.cz12a_c8r32
81.53	1303.8	0.000	0.000	3.180	12.40	2720.6	117346	20.76	0.744	0.789	44.11	0.107	5.152	0.000	0.000	0.116	8.504	8.188	1.511	2.262	7.093		my9500_rel_o2nofp.cz12a_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_o2nofp.cz12a_c8r3288.48911.3870.0200.1000.0030.047
my5744_rel_o2nofp.cz12a_c8r3293.6136.3350.0430.009nonzerononzero0.081
my8043_rel_o2nofp.cz12a_c8r3282.15217.8170.0230.0080.001nonzero0.101
my8044_rel_o2nofp.cz12a_c8r3282.36617.6020.0230.0080.001nonzero0.101
my8406_rel_o2nofp.cz12a_c8r3282.08317.8880.0220.0070.001nonzero0.100
my8407_rel_o2nofp.cz12a_c8r3282.02817.9400.0230.0080.001nonzero0.101
my8407_rel_o2nofp.cz12a_dw0_c8r3281.99117.9920.0120.0050.001nonzero0.101
my9400_rel_o2nofp.cz12a_c8r3281.96918.0010.0210.0080.001nonzero0.074
my9500_rel_o2nofp.cz12a_c8r3282.21117.7590.0200.0090.001nonzero0.101

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_o2nofp.cz12a_c8r3296.7963.0810.0200.1000.0030.047
my5744_rel_o2nofp.cz12a_c8r3294.4185.5570.0180.006nonzerononzero0.080
my8043_rel_o2nofp.cz12a_c8r3295.8984.0760.0170.0070.001nonzero0.101
my8044_rel_o2nofp.cz12a_c8r3296.1963.7810.0160.0060.001nonzero0.101
my8406_rel_o2nofp.cz12a_c8r3295.8124.1650.0160.0060.001nonzero0.100
my8407_rel_o2nofp.cz12a_c8r3295.7424.2330.0170.0070.001nonzero0.101
my8407_rel_o2nofp.cz12a_dw0_c8r3295.7464.2400.0080.0050.001nonzero0.101
my9400_rel_o2nofp.cz12a_c8r3295.7744.2030.0160.0060.001nonzero0.070
my9500_rel_o2nofp.cz12a_c8r3297.2562.7170.0180.0080.001nonzero0.101

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
23419	0	4150	16.2	1633.3	67.9	0.177	0.709	0.070	2.970	203223	42.9	8.678	147	6.2	36.7	7.9	0.047	23477	22327	my5651_rel_o2nofp.cz12a_c8r32
25510	0	0	0.0	1886.0	78.1	0.000	0.000	0.074	3.136	114152	41.7	4.475	131	6.3	36.8	8.3	0.081	25567	23837	my5744_rel_o2nofp.cz12a_c8r32
20161	0	0	0.0	1678.6	67.5	0.000	0.000	0.083	3.428	105640	35.0	5.240	139	6.8	37.8	9.5	0.101	20208	19017	my8043_rel_o2nofp.cz12a_c8r32
20284	0	0	0.0	1698.8	68.2	0.000	0.000	0.084	3.443	106835	35.3	5.267	139	6.9	37.9	9.5	0.101	20328	19333	my8044_rel_o2nofp.cz12a_c8r32
20080	0	0	0.0	1630.3	66.2	0.000	0.000	0.081	3.375	105905	35.1	5.274	140	6.8	45.0	9.4	0.100	20173	19443	my8406_rel_o2nofp.cz12a_c8r32
20040	0	0	0.0	1694.2	67.9	0.000	0.000	0.085	3.471	105652	35.2	5.272	141	6.8	45.0	9.4	0.101	20103	19128	my8407_rel_o2nofp.cz12a_c8r32
20000	0	0	0.0	1463.4	46.5	0.000	0.000	0.073	2.382	104955	34.8	5.248	139	6.8	45.0	9.4	0.101	20058	19233	my8407_rel_o2nofp.cz12a_dw0_c8r32
20121	0	0	0.0	1616.4	65.9	0.000	0.000	0.080	3.353	105802	35.2	5.258	140	6.8	45.0	9.4	0.074	20153	19408	my9400_rel_o2nofp.cz12a_c8r32
19881	0	0	0.0	1650.6	67.7	0.000	0.000	0.083	3.488	114027	34.8	5.736	140	6.8	44.8	9.4	0.101	19978	18988	my9500_rel_o2nofp.cz12a_c8r32

Average values from iostat.

r/s	rkB/s	rrqm/s	%rrqm	r_await	rareq-s	w/s	wkB/s	wrqm/s	%wrqm	w_await	wareq-s	d/s	dkB/s	drqm/s	%drqm	d_await	dareq-s	f/s	f_await	aqu-sz	%util	
4152.7	16610.8	0.000	0.000	0.018	4.000	1611.9	69006.5	15.02	0.930	0.068	43.45	0.224	5.152	0.000	0.000	0.099	3.334	5.250	1.119	0.179	12.17		my5651_rel_o2nofp.cz12a_c8r32
0.049	0.198	0.000	0.000	0.387	0.623	1880.0	79904.2	19.97	1.050	0.933	42.43	0.257	5.043	0.000	0.000	0.104	3.107	7.257	1.171	1.751	6.266		my5744_rel_o2nofp.cz12a_c8r32
0.051	0.204	0.000	0.000	1.005	0.980	1673.9	69054.7	1.932	0.113	1.174	41.21	0.092	5.553	0.000	0.000	0.118	8.956	5.322	1.431	1.958	3.922		my8043_rel_o2nofp.cz12a_c8r32
0.045	0.181	0.000	0.000	0.742	0.866	1694.0	69739.5	1.849	0.107	1.180	41.10	0.130	5.493	0.000	0.000	0.131	6.043	5.388	1.388	1.998	3.886		my8044_rel_o2nofp.cz12a_c8r32
0.027	0.106	0.000	0.000	0.939	0.531	1625.5	67688.8	1.855	0.112	1.204	41.55	0.145	5.092	0.000	0.000	0.101	5.373	5.231	1.404	1.947	3.869		my8406_rel_o2nofp.cz12a_c8r32
0.043	0.171	0.000	0.000	0.699	0.776	1690.0	69504.0	1.814	0.105	1.194	41.02	0.151	6.849	0.000	0.000	0.109	7.529	5.365	1.506	2.023	3.956		my8407_rel_o2nofp.cz12a_c8r32
0.032	0.129	0.000	0.000	1.040	0.646	1458.7	47635.1	1.608	0.107	1.486	32.59	0.188	4.566	0.000	0.000	0.109	3.108	5.180	1.407	2.152	3.558		my8407_rel_o2nofp.cz12a_dw0_c8r32
0.033	0.131	0.000	0.000	0.816	0.612	1609.4	67337.2	1.849	0.113	1.279	41.77	0.149	1.404	0.000	0.000	0.103	1.502	5.226	1.512	2.054	3.877		my9400_rel_o2nofp.cz12a_c8r32
0.042	0.170	0.000	0.000	0.944	0.768	1646.1	69250.9	1.855	0.110	1.275	41.98	0.180	7.362	0.000	0.000	0.113	6.905	5.366	1.564	2.101	4.011		my9500_rel_o2nofp.cz12a_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_o2nofp.cz12a_c8r3299.9850.0080.0020.005nonzero0.022
my5744_rel_o2nofp.cz12a_c8r3299.9980.002nonzerononzero0.010
my8043_rel_o2nofp.cz12a_c8r3299.9900.010nonzero0.001
my8044_rel_o2nofp.cz12a_c8r3299.9900.010nonzero0.001
my8406_rel_o2nofp.cz12a_c8r3299.9890.011nonzero0.001
my8407_rel_o2nofp.cz12a_c8r3299.9890.011nonzero0.001
my8407_rel_o2nofp.cz12a_dw0_c8r3299.9870.013nonzero0.004
my9400_rel_o2nofp.cz12a_c8r3299.9890.011nonzero0.001
my9500_rel_o2nofp.cz12a_c8r3299.9900.010nonzerononzero0.004

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_o2nofp.cz12a_c8r320.75049.66746.7782.8060.054
my5744_rel_o2nofp.cz12a_c8r327.44492.5280.0280.010
my8043_rel_o2nofp.cz12a_c8r3290.2229.7780.012
my8044_rel_o2nofp.cz12a_c8r3290.2509.7500.012
my8406_rel_o2nofp.cz12a_c8r3290.1949.7780.0280.042
my8407_rel_o2nofp.cz12a_c8r3299.9440.0280.0280.029
my8407_rel_o2nofp.cz12a_dw0_c8r3290.6399.3330.0280.043
my9400_rel_o2nofp.cz12a_c8r3299.9440.0280.0280.032
my9500_rel_o2nofp.cz12a_c8r3291.4448.5280.0280.048

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_o2nofp.cz12a_c8r323.80646.33348.1391.7220.043
my5744_rel_o2nofp.cz12a_c8r3259.25040.7500.002
my8043_rel_o2nofp.cz12a_c8r3243.50046.8069.6940.011
my8044_rel_o2nofp.cz12a_c8r3246.30644.0289.6670.012
my8406_rel_o2nofp.cz12a_c8r3244.33345.8899.7500.0280.045
my8407_rel_o2nofp.cz12a_c8r3252.22247.7220.0280.0280.032
my8407_rel_o2nofp.cz12a_dw0_c8r3244.08346.6119.2780.0280.047
my9400_rel_o2nofp.cz12a_c8r3250.02849.9170.0280.0280.028
my9500_rel_o2nofp.cz12a_c8r3246.13945.3338.5000.0280.044

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
100	13136	4	0.0	736.4	20.3	0.000	0.001	7.372	207.768	75447	11.5	5.743	70	6.2	36.7	7.9	0.022	13150	12862	my5651_rel_o2nofp.cz12a_c8r32
100	10838	0	0.0	156.2	4.2	0.000	0.000	1.564	43.554	62256	12.4	5.744	92	6.3	36.8	8.3	0.010	10847	10735	my5744_rel_o2nofp.cz12a_c8r32
100	9002	0	0.0	172.1	4.8	0.000	0.000	1.721	48.749	52030	12.4	5.780	110	6.8	37.8	9.5	0.001	8991	8927	my8043_rel_o2nofp.cz12a_c8r32
100	9128	0	0.0	199.0	5.5	0.000	0.000	1.990	56.292	52799	12.4	5.784	109	6.9	37.9	9.5	0.001	9135	9039	my8044_rel_o2nofp.cz12a_c8r32
100	8931	0	0.0	170.3	4.7	0.000	0.000	1.705	48.207	51681	12.4	5.786	111	6.8	45.0	9.4	0.001	8943	8863	my8406_rel_o2nofp.cz12a_c8r32
100	8874	0	0.0	162.0	4.5	0.000	0.000	1.620	45.883	51303	13.3	5.781	120	6.8	45.0	9.4	0.001	8879	8783	my8407_rel_o2nofp.cz12a_c8r32
100	8858	0	0.0	172.6	2.8	0.000	0.000	1.726	28.237	51217	13.3	5.782	120	6.8	45.0	9.4	0.004	8863	8767	my8407_rel_o2nofp.cz12a_dw0_c8r32
100	9022	0	0.0	170.0	4.7	0.000	0.000	1.700	48.161	52165	12.4	5.782	110	6.8	45.0	9.4	0.001	9023	8959	my9400_rel_o2nofp.cz12a_c8r32
100	9046	0	0.0	153.3	4.2	0.000	0.000	1.534	43.427	52315	12.4	5.784	110	6.8	44.9	9.4	0.004	9055	8975	my9500_rel_o2nofp.cz12a_c8r32

Average values from iostat.

r/s	rkB/s	rrqm/s	%rrqm	r_await	rareq-s	w/s	wkB/s	wrqm/s	%wrqm	w_await	wareq-s	d/s	dkB/s	drqm/s	%drqm	d_await	dareq-s	f/s	f_await	aqu-sz	%util	
3.782	15.13	0.000	0.000	2.447	4.000	736.8	20765.8	7.311	8.465	0.432	26.41	0.004	0.018	0.000	0.000	0.011	0.089	2.769	1.124	0.053	3.737		my5651_rel_o2nofp.cz12a_c8r32
0.001	0.004	0.000	0.000	0.000	0.011	155.6	4334.3	4.479	5.145	0.363	27.28	0.000	0.000	0.000	0.000	0.000	0.000	1.534	1.362	0.032	2.326		my5744_rel_o2nofp.cz12a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	171.4	4853.7	1.458	1.680	0.280	28.25	0.004	0.767	0.000	0.000	0.014	3.833	1.601	1.847	0.035	1.736		my8043_rel_o2nofp.cz12a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	198.3	5610.4	1.384	1.244	0.212	28.17	0.000	0.000	0.000	0.000	0.000	0.000	1.874	1.599	0.037	1.627		my8044_rel_o2nofp.cz12a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	169.6	4794.7	1.440	1.705	0.267	28.07	0.005	0.020	0.000	0.000	0.011	0.078	1.616	1.916	0.032	1.725		my8406_rel_o2nofp.cz12a_c8r32
0.001	0.002	0.000	0.000	0.000	0.011	161.6	4575.8	1.565	1.953	0.387	28.16	0.002	0.013	0.000	0.000	0.005	0.037	1.520	1.829	0.055	2.693		my8407_rel_o2nofp.cz12a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	172.0	2814.8	1.022	0.903	0.203	16.58	0.005	0.020	0.000	0.000	0.011	0.078	2.157	1.892	0.032	1.825		my8407_rel_o2nofp.cz12a_dw0_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	169.6	4804.9	1.374	1.545	0.485	28.24	0.005	0.036	0.000	0.000	0.015	0.149	1.549	1.916	0.069	3.747		my9400_rel_o2nofp.cz12a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	152.5	4316.3	1.509	2.038	0.379	28.11	0.006	0.040	0.000	0.000	0.019	0.171	1.590	1.985	0.042	1.848		my9500_rel_o2nofp.cz12a_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_o2nofp.cz12a_c8r3299.9820.0130.0020.004nonzero0.028
my5744_rel_o2nofp.cz12a_c8r3299.9910.009nonzero0.001
my8043_rel_o2nofp.cz12a_c8r3299.9660.034nonzero0.001
my8044_rel_o2nofp.cz12a_c8r3299.9640.036nonzero0.001
my8406_rel_o2nofp.cz12a_c8r3299.9500.0500.001
my8407_rel_o2nofp.cz12a_c8r3299.9540.046nonzero0.002
my8407_rel_o2nofp.cz12a_dw0_c8r3299.9540.046nonzero0.002
my9400_rel_o2nofp.cz12a_c8r3299.9580.042nonzero0.001
my9500_rel_o2nofp.cz12a_c8r3299.9610.039nonzero0.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_o2nofp.cz12a_c8r320.11152.75045.4721.6670.057
my5744_rel_o2nofp.cz12a_c8r320.02899.9720.002
my8043_rel_o2nofp.cz12a_c8r3290.1949.8060.011
my8044_rel_o2nofp.cz12a_c8r3299.9440.0560.005
my8406_rel_o2nofp.cz12a_c8r3290.1679.8330.012
my8407_rel_o2nofp.cz12a_c8r3299.9170.0830.013
my8407_rel_o2nofp.cz12a_dw0_c8r3290.4179.5830.011
my9400_rel_o2nofp.cz12a_c8r3291.0008.9720.0280.023
my9500_rel_o2nofp.cz12a_c8r3290.4729.5280.011

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

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel_o2nofp.cz12a_c8r323.19449.25046.1941.3610.056
my5744_rel_o2nofp.cz12a_c8r3250.02849.9720.002
my8043_rel_o2nofp.cz12a_c8r328.94481.3619.6940.011
my8044_rel_o2nofp.cz12a_c8r3228.30671.6670.0280.005
my8406_rel_o2nofp.cz12a_c8r328.80681.3899.8060.012
my8407_rel_o2nofp.cz12a_c8r3221.11178.8610.0280.013
my8407_rel_o2nofp.cz12a_dw0_c8r3220.66769.8069.5280.011
my9400_rel_o2nofp.cz12a_c8r329.77881.2788.9170.0280.022
my9500_rel_o2nofp.cz12a_c8r3211.16779.3339.5000.011

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	11193	4	0.0	747.2	20.6	0.000	0.001	7.472	210.665	64935	12.4	5.801	89	6.2	36.7	7.9	0.028	11199	10974	my5651_rel_o2nofp.cz12a_c8r32
100	9291	0	0.0	37.7	1.0	0.000	0.000	0.377	9.830	53909	11.7	5.802	101	6.3	36.8	8.3	0.001	9295	9215	my5744_rel_o2nofp.cz12a_c8r32
100	6973	0	0.0	31.9	0.9	0.000	0.000	0.319	9.093	40751	12.3	5.844	141	6.8	37.8	9.5	0.001	6975	6927	my8043_rel_o2nofp.cz12a_c8r32
100	6986	0	0.0	33.5	0.9	0.000	0.000	0.335	9.569	40825	12.4	5.844	142	6.9	37.9	9.5	0.001	6991	6927	my8044_rel_o2nofp.cz12a_c8r32
100	6838	0	0.0	46.5	1.3	0.000	0.000	0.465	12.972	40006	12.3	5.851	144	6.8	45.0	9.4	0.001	6847	6799	my8406_rel_o2nofp.cz12a_c8r32
100	6800	0	0.0	35.7	1.0	0.000	0.000	0.357	10.109	39755	12.8	5.847	151	6.8	45.0	9.4	0.002	6799	6719	my8407_rel_o2nofp.cz12a_c8r32
100	6838	0	0.0	31.3	0.6	0.000	0.000	0.313	5.664	39974	13.1	5.846	153	6.8	45.0	9.4	0.002	6831	6751	my8407_rel_o2nofp.cz12a_dw0_c8r32
100	6932	0	0.0	41.0	1.1	0.000	0.000	0.410	11.287	40526	11.9	5.846	137	6.8	45.0	9.4	0.001	6927	6911	my9400_rel_o2nofp.cz12a_c8r32
100	6950	0	0.0	41.5	1.1	0.000	0.000	0.416	11.710	40654	12.4	5.849	143	6.8	44.9	9.4	0.001	6959	6911	my9500_rel_o2nofp.cz12a_c8r32

Average values from iostat.

r/s	rkB/s	rrqm/s	%rrqm	r_await	rareq-s	w/s	wkB/s	wrqm/s	%wrqm	w_await	wareq-s	d/s	dkB/s	drqm/s	%drqm	d_await	dareq-s	f/s	f_await	aqu-sz	%util	
3.724	14.89	0.000	0.000	2.557	4.000	746.5	21045.2	6.534	9.796	0.547	25.96	0.001	0.002	0.000	0.000	0.000	0.011	2.476	1.329	0.053	3.666		my5651_rel_o2nofp.cz12a_c8r32
0.001	0.002	0.000	0.000	0.000	0.011	37.56	978.8	3.936	10.26	0.747	25.78	0.004	0.018	0.000	0.000	0.008	0.089	1.341	1.170	0.027	2.175		my5744_rel_o2nofp.cz12a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	31.89	908.8	1.344	4.070	0.602	28.48	0.000	0.000	0.000	0.000	0.000	0.000	1.609	1.694	0.022	1.575		my8043_rel_o2nofp.cz12a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	33.46	955.1	1.452	4.228	0.677	28.54	0.004	0.250	0.000	0.000	0.011	1.248	1.537	1.435	0.024	3.619		my8044_rel_o2nofp.cz12a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	46.46	1296.0	1.399	3.015	0.452	27.97	0.002	0.007	0.000	0.000	0.006	0.033	1.600	1.895	0.023	1.669		my8406_rel_o2nofp.cz12a_c8r32
0.001	0.002	0.000	0.000	0.000	0.011	35.65	1010.2	1.491	4.096	0.643	28.40	0.000	0.000	0.000	0.000	0.000	0.000	1.537	1.886	0.025	3.999		my8407_rel_o2nofp.cz12a_c8r32
0.001	0.002	0.000	0.000	0.000	0.011	31.14	564.7	1.097	3.628	0.606	18.27	0.039	0.156	0.000	0.000	0.142	0.780	1.963	1.910	0.022	1.642		my8407_rel_o2nofp.cz12a_dw0_c8r32
0.001	0.002	0.000	0.000	0.025	0.011	40.99	1128.8	1.189	2.912	0.538	27.59	0.002	0.013	0.000	0.000	0.008	0.067	2.314	2.139	0.026	1.888		my9400_rel_o2nofp.cz12a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	41.49	1169.4	1.456	3.476	0.538	28.28	0.002	0.018	0.000	0.000	0.006	0.089	1.578	1.893	0.025	1.950		my9500_rel_o2nofp.cz12a_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_o2nofp.cz12a_c8r3299.9790.0140.0030.005nonzero0.022
my5744_rel_o2nofp.cz12a_c8r3299.9970.003nonzerononzero0.004
my8043_rel_o2nofp.cz12a_c8r3299.9870.013nonzero0.002
my8044_rel_o2nofp.cz12a_c8r3299.9880.012nonzero0.002
my8406_rel_o2nofp.cz12a_c8r3299.9840.016nonzero0.002
my8407_rel_o2nofp.cz12a_c8r3299.9860.014nonzero0.002
my8407_rel_o2nofp.cz12a_dw0_c8r3299.9860.014nonzero0.002
my9400_rel_o2nofp.cz12a_c8r3299.9870.013nonzero0.002
my9500_rel_o2nofp.cz12a_c8r3299.9860.014nonzero0.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_o2nofp.cz12a_c8r3211.21771.97815.2061.6000.051
my5744_rel_o2nofp.cz12a_c8r3244.68355.3060.0110.010
my8043_rel_o2nofp.cz12a_c8r3298.0561.9390.0060.022
my8044_rel_o2nofp.cz12a_c8r3298.1111.8890.011
my8406_rel_o2nofp.cz12a_c8r3298.0561.9440.016
my8407_rel_o2nofp.cz12a_c8r3299.9670.0330.013
my8407_rel_o2nofp.cz12a_dw0_c8r3298.1391.8560.0060.022
my9400_rel_o2nofp.cz12a_c8r3298.1721.8220.0060.022
my9500_rel_o2nofp.cz12a_c8r3298.0671.9330.011

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

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
my5651_rel_o2nofp.cz12a_c8r3219.71763.88314.9781.4220.049
my5744_rel_o2nofp.cz12a_c8r3289.35010.6390.0110.010
my8043_rel_o2nofp.cz12a_c8r3287.02811.0221.9440.0060.022
my8044_rel_o2nofp.cz12a_c8r3288.6619.4501.8890.011
my8406_rel_o2nofp.cz12a_c8r3287.10610.9561.9390.015
my8407_rel_o2nofp.cz12a_c8r3285.75014.2330.0170.012
my8407_rel_o2nofp.cz12a_dw0_c8r3286.84411.2941.8560.0060.022
my9400_rel_o2nofp.cz12a_c8r3286.63311.5501.8110.0060.022
my9500_rel_o2nofp.cz12a_c8r3288.6449.4281.9280.011

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
500	13110	17	0.1	2083.7	58.1	0.001	0.005	4.167	118.890	75728	12.0	5.776	73	6.2	36.7	7.9	0.022	13167	12190	my5651_rel_o2nofp.cz12a_c8r32
500	10885	0	0.0	62.9	2.0	0.000	0.000	0.126	4.142	62640	12.4	5.755	91	6.3	36.8	8.3	0.004	10894	10799	my5744_rel_o2nofp.cz12a_c8r32
500	8996	0	0.0	82.1	2.6	0.000	0.000	0.164	5.350	52269	12.4	5.810	110	6.8	37.8	9.5	0.002	8991	8927	my8043_rel_o2nofp.cz12a_c8r32
500	9132	0	0.0	74.9	2.4	0.000	0.000	0.150	4.964	53082	12.8	5.813	112	6.9	37.9	9.5	0.002	9135	9055	my8044_rel_o2nofp.cz12a_c8r32
500	8886	0	0.0	80.8	2.6	0.000	0.000	0.162	5.274	51650	12.4	5.813	112	6.8	45.1	9.4	0.002	8879	8831	my8406_rel_o2nofp.cz12a_c8r32
500	8884	0	0.0	66.6	2.2	0.000	0.000	0.133	4.483	51624	13.3	5.811	120	6.8	45.1	9.4	0.002	8879	8799	my8407_rel_o2nofp.cz12a_c8r32
500	8882	0	0.0	68.1	1.5	0.000	0.000	0.136	3.117	51647	13.3	5.815	120	6.8	45.1	9.4	0.002	8895	8799	my8407_rel_o2nofp.cz12a_dw0_c8r32
500	9024	0	0.0	76.7	2.5	0.000	0.000	0.153	5.020	52441	12.7	5.811	113	6.8	45.1	9.4	0.002	9023	8959	my9400_rel_o2nofp.cz12a_c8r32
500	8992	0	0.0	63.7	2.1	0.000	0.000	0.127	4.323	52240	12.6	5.810	112	6.8	45.0	9.4	0.002	8991	8927	my9500_rel_o2nofp.cz12a_c8r32

Average values from iostat.

r/s	rkB/s	rrqm/s	%rrqm	r_await	rareq-s	w/s	wkB/s	wrqm/s	%wrqm	w_await	wareq-s	d/s	dkB/s	drqm/s	%drqm	d_await	dareq-s	f/s	f_await	aqu-sz	%util	
16.62	66.49	0.000	0.000	0.493	4.000	2085.1	59486.4	7.560	12.41	1.501	39.80	0.007	0.027	0.000	0.000	0.014	0.134	2.826	1.042	0.100	4.801		my5651_rel_o2nofp.cz12a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	63.01	2073.0	3.547	5.692	0.667	33.22	0.000	0.000	0.000	0.000	0.000	0.000	1.290	1.033	0.040	1.796		my5744_rel_o2nofp.cz12a_c8r32
0.001	0.002	0.000	0.000	0.025	0.011	82.28	2679.2	1.000	1.495	0.724	33.69	0.000	0.000	0.000	0.000	0.000	0.000	1.627	1.756	0.051	1.494		my8043_rel_o2nofp.cz12a_c8r32
0.001	0.002	0.000	0.000	0.000	0.011	75.04	2484.1	1.011	1.624	0.943	34.27	0.000	0.000	0.000	0.000	0.000	0.000	1.538	1.769	0.062	1.913		my8044_rel_o2nofp.cz12a_c8r32
0.001	0.004	0.000	0.000	0.025	0.022	80.95	2641.3	1.026	1.371	0.750	33.03	0.011	0.042	0.000	0.000	0.033	0.212	1.595	1.714	0.059	1.630		my8406_rel_o2nofp.cz12a_c8r32
0.001	0.002	0.000	0.000	0.000	0.011	66.76	2245.1	1.009	1.640	0.978	34.23	0.000	0.000	0.000	0.000	0.000	0.000	1.549	1.731	0.062	2.091		my8407_rel_o2nofp.cz12a_c8r32
0.001	0.002	0.000	0.000	0.025	0.011	68.23	1559.8	0.846	1.440	0.759	23.91	0.032	0.129	0.000	0.000	0.120	0.646	2.401	1.783	0.050	1.905		my8407_rel_o2nofp.cz12a_dw0_c8r32
0.001	0.004	0.000	0.000	0.047	0.022	76.83	2512.5	0.981	1.708	0.801	34.31	0.027	0.218	0.000	0.000	0.097	1.092	2.314	1.812	0.052	1.860		my9400_rel_o2nofp.cz12a_c8r32
0.001	0.002	0.000	0.000	0.022	0.011	63.84	2164.3	1.026	1.803	1.019	34.80	0.006	0.049	0.000	0.000	0.022	0.245	1.587	1.812	0.060	1.950		my9500_rel_o2nofp.cz12a_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_o2nofp.cz12a_c8r3299.9670.0290.0010.003nonzero0.024
my5744_rel_o2nofp.cz12a_c8r3299.9920.008nonzero0.004
my8043_rel_o2nofp.cz12a_c8r3299.9540.046nonzero0.002
my8044_rel_o2nofp.cz12a_c8r3299.9520.048nonzero0.002
my8406_rel_o2nofp.cz12a_c8r3299.9430.057nonzero0.002
my8407_rel_o2nofp.cz12a_c8r3299.9450.055nonzero0.002
my8407_rel_o2nofp.cz12a_dw0_c8r3299.9460.054nonzero0.002
my9400_rel_o2nofp.cz12a_c8r3299.9430.057nonzero0.002
my9500_rel_o2nofp.cz12a_c8r3299.9490.051nonzero0.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_o2nofp.cz12a_c8r3210.93372.69414.9391.4280.0060.071
my5744_rel_o2nofp.cz12a_c8r3221.83978.1610.003
my8043_rel_o2nofp.cz12a_c8r3298.0941.9000.0060.020
my8044_rel_o2nofp.cz12a_c8r3298.1331.8610.0060.020
my8406_rel_o2nofp.cz12a_c8r3298.2111.7830.0060.018
my8407_rel_o2nofp.cz12a_c8r3298.2061.7890.0060.022
my8407_rel_o2nofp.cz12a_dw0_c8r3299.9780.0220.009
my9400_rel_o2nofp.cz12a_c8r3298.1781.8220.011
my9500_rel_o2nofp.cz12a_c8r3298.1781.8170.0060.019

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_o2nofp.cz12a_c8r3223.79460.15014.7941.2610.056
my5744_rel_o2nofp.cz12a_c8r3288.57811.4220.002
my8043_rel_o2nofp.cz12a_c8r3282.27815.8171.9000.0060.020
my8044_rel_o2nofp.cz12a_c8r3281.90616.2391.8500.0060.021
my8406_rel_o2nofp.cz12a_c8r3280.53917.6831.7720.0060.018
my8407_rel_o2nofp.cz12a_c8r3262.52835.6891.7830.011
my8407_rel_o2nofp.cz12a_dw0_c8r3269.23330.7560.0110.008
my9400_rel_o2nofp.cz12a_c8r3256.02842.1561.8170.011
my9500_rel_o2nofp.cz12a_c8r3284.03914.1561.8000.0060.018

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
500	11124	16	0.1	2127.6	59.3	0.001	0.006	4.255	121.394	64979	12.6	5.842	91	6.2	36.7	7.9	0.024	11135	10671	my5651_rel_o2nofp.cz12a_c8r32
500	9346	0	0.0	39.6	1.4	0.000	0.000	0.079	2.788	54338	12.5	5.814	107	6.3	36.8	8.3	0.004	9343	9263	my5744_rel_o2nofp.cz12a_c8r32
500	6986	0	0.0	32.9	1.2	0.000	0.000	0.066	2.533	41193	12.4	5.896	142	6.8	37.8	9.5	0.002	6991	6943	my8043_rel_o2nofp.cz12a_c8r32
500	6943	0	0.0	31.8	1.2	0.000	0.000	0.064	2.510	40944	12.8	5.897	147	6.9	37.9	9.5	0.002	6943	6895	my8044_rel_o2nofp.cz12a_c8r32
500	6799	0	0.0	37.9	1.4	0.000	0.000	0.076	2.840	40101	12.6	5.898	148	6.8	45.2	9.4	0.002	6799	6751	my8406_rel_o2nofp.cz12a_c8r32
500	6744	0	0.0	35.2	1.3	0.000	0.000	0.070	2.740	39783	12.9	5.899	153	6.8	45.2	9.4	0.002	6751	6687	my8407_rel_o2nofp.cz12a_c8r32
500	6775	0	0.0	28.5	0.9	0.000	0.000	0.057	1.872	39972	12.7	5.900	150	6.8	45.2	9.4	0.002	6783	6703	my8407_rel_o2nofp.cz12a_dw0_c8r32
500	6901	0	0.0	34.3	1.3	0.000	0.000	0.069	2.620	40715	12.2	5.900	141	6.8	45.2	9.4	0.002	6911	6863	my9400_rel_o2nofp.cz12a_c8r32
500	6926	0	0.0	36.2	1.4	0.000	0.000	0.072	2.806	40835	12.7	5.896	147	6.8	45.1	9.4	0.002	6927	6895	my9500_rel_o2nofp.cz12a_c8r32

Average values from iostat.

r/s	rkB/s	rrqm/s	%rrqm	r_await	rareq-s	w/s	wkB/s	wrqm/s	%wrqm	w_await	wareq-s	d/s	dkB/s	drqm/s	%drqm	d_await	dareq-s	f/s	f_await	aqu-sz	%util	
15.75	63.01	0.000	0.000	0.522	4.000	2108.4	60151.2	7.374	11.17	1.406	38.74	0.000	0.000	0.000	0.000	0.000	0.000	2.765	1.106	0.102	4.816		my5651_rel_o2nofp.cz12a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	39.62	1393.8	3.971	9.288	1.283	35.38	0.000	0.000	0.000	0.000	0.000	0.000	1.479	1.304	0.052	2.265		my5744_rel_o2nofp.cz12a_c8r32
0.001	0.002	0.000	0.000	0.025	0.011	32.87	1265.7	0.959	2.910	1.362	38.67	0.001	0.096	0.000	0.000	0.000	0.479	1.931	1.699	0.047	1.585		my8043_rel_o2nofp.cz12a_c8r32
0.001	0.002	0.000	0.000	0.025	0.011	31.84	1254.2	0.947	2.904	1.672	39.37	0.001	0.062	0.000	0.000	0.006	0.312	1.570	1.605	0.056	2.098		my8044_rel_o2nofp.cz12a_c8r32
0.001	0.002	0.000	0.000	0.025	0.011	37.87	1419.0	1.087	3.019	1.526	38.25	0.033	0.131	0.000	0.000	0.111	0.657	1.592	1.704	0.056	1.634		my8406_rel_o2nofp.cz12a_c8r32
0.001	0.002	0.000	0.000	0.025	0.011	35.16	1369.9	0.981	2.731	1.552	38.94	0.005	0.040	0.000	0.000	0.017	0.201	1.541	1.759	0.057	2.672		my8407_rel_o2nofp.cz12a_c8r32
0.001	0.002	0.000	0.000	0.025	0.011	28.50	934.5	0.889	3.072	3.698	33.12	0.011	0.045	0.000	0.000	0.039	0.223	1.705	1.649	0.110	10.94		my8407_rel_o2nofp.cz12a_dw0_c8r32
0.001	0.004	0.000	0.000	0.050	0.022	34.27	1309.0	1.118	3.172	1.310	38.21	0.020	0.160	0.000	0.000	0.058	0.802	2.167	1.836	0.048	1.773		my9400_rel_o2nofp.cz12a_c8r32
0.001	0.004	0.000	0.000	0.025	0.022	36.24	1403.2	1.067	2.858	1.513	38.70	0.028	0.227	0.000	0.000	0.097	1.136	1.573	1.805	0.057	1.826		my9500_rel_o2nofp.cz12a_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_o2nofp.cz12a_c8r3299.9750.0190.0020.004nonzero0.020
my5744_rel_o2nofp.cz12a_c8r3299.9960.004nonzerononzero0.006
my8043_rel_o2nofp.cz12a_c8r3299.9850.015nonzero0.001
my8044_rel_o2nofp.cz12a_c8r3299.9860.014nonzero0.002
my8406_rel_o2nofp.cz12a_c8r3299.9810.019nonzero0.002
my8407_rel_o2nofp.cz12a_c8r3299.9820.018nonzero0.002
my8407_rel_o2nofp.cz12a_dw0_c8r3299.9820.018nonzero0.002
my9400_rel_o2nofp.cz12a_c8r3299.9860.014nonzero0.002
my9500_rel_o2nofp.cz12a_c8r3299.9840.016nonzero0.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_o2nofp.cz12a_c8r3215.24476.2818.3250.1500.035
my5744_rel_o2nofp.cz12a_c8r3249.24750.7530.002
my8043_rel_o2nofp.cz12a_c8r3299.9780.0220.009
my8044_rel_o2nofp.cz12a_c8r3299.0420.9560.0030.022
my8406_rel_o2nofp.cz12a_c8r3299.0470.9470.0060.037
my8407_rel_o2nofp.cz12a_c8r3299.0360.9580.0060.037
my8407_rel_o2nofp.cz12a_dw0_c8r3298.8971.0970.0030.0030.101
my9400_rel_o2nofp.cz12a_c8r3299.1000.8940.0060.038
my9500_rel_o2nofp.cz12a_c8r3299.0940.9030.0030.048

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_o2nofp.cz12a_c8r3227.40364.6507.8110.1360.031
my5744_rel_o2nofp.cz12a_c8r3292.7617.2390.002
my8043_rel_o2nofp.cz12a_c8r3288.44711.5440.0080.009
my8044_rel_o2nofp.cz12a_c8r3291.8947.1470.9560.0030.021
my8406_rel_o2nofp.cz12a_c8r3291.1757.8890.9330.0030.022
my8407_rel_o2nofp.cz12a_c8r3290.9818.1080.9060.0060.035
my8407_rel_o2nofp.cz12a_dw0_c8r3290.2148.6721.1080.0030.0030.101
my9400_rel_o2nofp.cz12a_c8r3290.3728.7360.8860.0060.040
my9500_rel_o2nofp.cz12a_c8r3292.6116.4920.8940.0030.045

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

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
999	13020	28	0.1	1847.5	52.0	0.002	0.009	1.849	53.273	75625	12.8	5.808	79	6.2	36.7	7.9	0.020	13054	12366	my5651_rel_o2nofp.cz12a_c8r32
1000	10864	0	0.0	89.5	3.2	0.000	0.000	0.090	3.257	62710	13.1	5.773	96	6.3	36.8	8.3	0.006	10863	10767	my5744_rel_o2nofp.cz12a_c8r32
999	9042	0	0.0	100.2	3.6	0.000	0.000	0.100	3.644	53080	13.4	5.870	119	6.8	37.8	9.5	0.001	9055	8943	my8043_rel_o2nofp.cz12a_c8r32
1000	9097	0	0.0	99.4	3.5	0.000	0.000	0.099	3.632	53323	13.4	5.862	118	6.9	37.9	9.5	0.002	9103	9023	my8044_rel_o2nofp.cz12a_c8r32
1000	8882	0	0.0	97.8	3.5	0.000	0.000	0.098	3.581	52114	13.3	5.867	120	6.8	45.4	9.4	0.002	8879	8815	my8406_rel_o2nofp.cz12a_c8r32
999	8768	0	0.0	97.9	3.5	0.000	0.000	0.098	3.601	51473	14.1	5.871	129	6.8	45.4	9.5	0.002	8767	8703	my8407_rel_o2nofp.cz12a_c8r32
999	8814	0	0.0	90.7	2.4	0.000	0.000	0.091	2.435	51749	13.7	5.871	124	6.8	45.4	9.4	0.002	8815	8735	my8407_rel_o2nofp.cz12a_dw0_c8r32
999	9101	0	0.0	101.3	3.6	0.000	0.000	0.101	3.657	53417	13.4	5.870	118	6.8	45.4	9.4	0.002	9103	9039	my9400_rel_o2nofp.cz12a_c8r32
1000	8965	0	0.0	97.1	3.5	0.000	0.000	0.097	3.577	52584	13.8	5.865	123	6.8	45.2	9.4	0.002	8959	8895	my9500_rel_o2nofp.cz12a_c8r32

Average values from iostat.

r/s	rkB/s	rrqm/s	%rrqm	r_await	rareq-s	w/s	wkB/s	wrqm/s	%wrqm	w_await	wareq-s	d/s	dkB/s	drqm/s	%drqm	d_await	dareq-s	f/s	f_await	aqu-sz	%util	
28.19	112.8	0.000	0.000	0.332	4.000	1821.2	52495.0	5.928	11.33	2.657	61.87	0.002	0.007	0.000	0.000	0.003	0.033	2.147	0.978	0.113	4.273		my5651_rel_o2nofp.cz12a_c8r32
0.001	0.002	0.000	0.000	0.000	0.011	89.69	3262.6	4.581	6.547	1.186	39.92	0.003	0.013	0.000	0.000	0.006	0.067	1.662	1.023	0.075	2.301		my5744_rel_o2nofp.cz12a_c8r32
0.002	0.009	0.000	0.000	0.025	0.033	100.4	3648.5	1.170	1.621	1.372	39.70	0.012	2.108	0.000	0.000	0.036	10.54	1.538	1.377	0.102	2.162		my8043_rel_o2nofp.cz12a_c8r32
0.001	0.004	0.000	0.000	0.047	0.022	99.63	3638.1	1.110	1.638	1.441	40.77	0.012	0.655	0.000	0.000	0.036	3.276	1.589	1.454	0.100	1.648		my8044_rel_o2nofp.cz12a_c8r32
0.001	0.004	0.000	0.000	0.047	0.022	97.99	3585.5	1.055	1.301	1.217	38.54	0.005	0.020	0.000	0.000	0.014	0.089	1.594	1.684	0.101	1.708		my8406_rel_o2nofp.cz12a_c8r32
0.002	0.007	0.000	0.000	0.025	0.033	98.06	3604.7	1.063	1.553	1.464	40.77	0.011	0.080	0.000	0.000	0.034	0.371	1.552	1.638	0.102	2.073		my8407_rel_o2nofp.cz12a_c8r32
0.001	0.004	0.000	0.000	0.000	0.022	90.84	2437.1	0.872	1.411	3.221	32.08	0.001	0.004	0.000	0.000	0.001	0.011	2.458	1.794	0.333	4.742		my8407_rel_o2nofp.cz12a_dw0_c8r32
0.001	0.004	0.000	0.000	0.047	0.022	101.5	3660.7	1.088	1.417	1.058	38.63	0.001	0.004	0.000	0.000	0.003	0.011	2.775	1.755	0.090	2.065		my9400_rel_o2nofp.cz12a_c8r32
0.002	0.009	0.000	0.000	0.075	0.045	97.22	3580.9	1.051	1.457	1.371	39.98	0.001	0.004	0.000	0.000	0.003	0.011	1.577	1.648	0.103	1.789		my9500_rel_o2nofp.cz12a_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_o2nofp.cz12a_c8r3299.9580.0390.0010.0020.010
my5744_rel_o2nofp.cz12a_c8r3299.9860.014nonzero0.002
my8043_rel_o2nofp.cz12a_c8r3299.9390.061nonzero0.002
my8044_rel_o2nofp.cz12a_c8r3299.9420.058nonzero0.002
my8406_rel_o2nofp.cz12a_c8r3299.9320.068nonzero0.002
my8407_rel_o2nofp.cz12a_c8r3299.9350.065nonzero0.003
my8407_rel_o2nofp.cz12a_dw0_c8r3299.9310.069nonzero0.002
my9400_rel_o2nofp.cz12a_c8r3299.9310.069nonzero0.002
my9500_rel_o2nofp.cz12a_c8r3299.9360.064nonzero0.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_o2nofp.cz12a_c8r3217.76777.4834.7420.0080.017
my5744_rel_o2nofp.cz12a_c8r3234.36765.6310.0030.004
my8043_rel_o2nofp.cz12a_c8r3299.0500.9500.013
my8044_rel_o2nofp.cz12a_c8r3299.0390.9610.012
my8406_rel_o2nofp.cz12a_c8r3299.0720.9190.0080.040
my8407_rel_o2nofp.cz12a_c8r3299.0310.9610.0080.042
my8407_rel_o2nofp.cz12a_dw0_c8r3299.9690.0280.0030.028
my9400_rel_o2nofp.cz12a_c8r3299.0720.9250.0030.041
my9500_rel_o2nofp.cz12a_c8r3299.0420.9560.0030.040

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_o2nofp.cz12a_c8r3233.46161.8224.7080.0080.016
my5744_rel_o2nofp.cz12a_c8r3292.0507.9500.002
my8043_rel_o2nofp.cz12a_c8r3279.32819.7330.9390.012
my8044_rel_o2nofp.cz12a_c8r3286.80812.2360.9560.012
my8406_rel_o2nofp.cz12a_c8r3286.60612.6580.7280.0080.042
my8407_rel_o2nofp.cz12a_c8r3280.22218.8170.9530.0080.045
my8407_rel_o2nofp.cz12a_dw0_c8r3285.33114.6610.0080.012
my9400_rel_o2nofp.cz12a_c8r3285.17513.9060.9170.0030.038
my9500_rel_o2nofp.cz12a_c8r3289.9289.1190.9500.0030.037

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	11214	29	0.1	11.6	1.1	0.003	0.010	0.012	1.154	65703	12.4	5.859	88	6.2	36.7	7.9	0.010	11230	11087	my5651_rel_o2nofp.cz12a_c8r32
1000	9255	0	0.0	69.5	2.6	0.000	0.000	0.070	2.694	54033	12.7	5.838	110	6.3	36.8	8.3	0.002	9247	9183	my5744_rel_o2nofp.cz12a_c8r32
1000	6954	0	0.0	89.9	3.3	0.000	0.000	0.090	3.368	41504	12.9	5.968	148	6.8	37.8	9.5	0.002	6959	6911	my8043_rel_o2nofp.cz12a_c8r32
1000	6943	0	0.0	91.7	3.3	0.000	0.000	0.092	3.418	41435	13.1	5.968	151	6.9	37.9	9.5	0.002	6943	6895	my8044_rel_o2nofp.cz12a_c8r32
1000	6800	0	0.0	81.5	3.1	0.000	0.000	0.082	3.133	40612	13.4	5.972	158	6.8	45.6	9.4	0.002	6799	6751	my8406_rel_o2nofp.cz12a_c8r32
999	6689	0	0.0	91.6	3.3	0.000	0.000	0.092	3.426	39997	13.4	5.980	160	6.8	45.6	9.5	0.003	6687	6639	my8407_rel_o2nofp.cz12a_c8r32
1000	6814	0	0.0	79.4	2.2	0.000	0.000	0.079	2.276	40687	13.9	5.971	163	6.8	45.6	9.4	0.002	6815	6735	my8407_rel_o2nofp.cz12a_dw0_c8r32
999	6886	0	0.0	95.5	3.4	0.000	0.000	0.096	3.521	41138	12.7	5.975	148	6.8	45.6	9.4	0.002	6895	6831	my9400_rel_o2nofp.cz12a_c8r32
1000	6923	0	0.0	95.5	3.5	0.000	0.000	0.096	3.539	41337	13.2	5.971	153	6.8	45.4	9.4	0.002	6927	6879	my9500_rel_o2nofp.cz12a_c8r32

Average values from iostat.

r/s	rkB/s	rrqm/s	%rrqm	r_await	rareq-s	w/s	wkB/s	wrqm/s	%wrqm	w_await	wareq-s	d/s	dkB/s	drqm/s	%drqm	d_await	dareq-s	f/s	f_await	aqu-sz	%util	
28.59	114.4	0.000	0.000	0.354	4.000	11.58	1153.9	2.108	15.53	5.244	99.34	0.002	0.009	0.000	0.000	0.008	0.045	0.988	1.147	0.070	2.094		my5651_rel_o2nofp.cz12a_c8r32
0.001	0.004	0.000	0.000	0.022	0.022	69.61	2696.9	4.186	7.669	1.573	43.41	0.006	0.022	0.000	0.000	0.014	0.111	1.523	1.049	0.076	2.262		my5744_rel_o2nofp.cz12a_c8r32
0.001	0.004	0.000	0.000	0.025	0.022	89.81	3366.1	1.136	1.931	1.681	42.60	0.001	0.192	0.000	0.000	0.003	0.958	1.547	1.647	0.103	1.964		my8043_rel_o2nofp.cz12a_c8r32
0.002	0.007	0.000	0.000	0.025	0.033	91.87	3423.0	1.100	1.858	1.639	42.42	0.005	0.281	0.000	0.000	0.017	1.404	1.598	1.520	0.101	1.663		my8044_rel_o2nofp.cz12a_c8r32
0.001	0.004	0.000	0.000	0.033	0.022	81.40	3129.4	1.050	1.702	1.549	41.88	0.010	0.076	0.000	0.000	0.031	0.349	1.603	1.575	0.098	1.672		my8406_rel_o2nofp.cz12a_c8r32
0.002	0.009	0.000	0.000	0.095	0.045	91.71	3428.4	1.081	1.744	1.571	41.80	0.020	0.156	0.000	0.000	0.067	0.750	1.566	1.693	0.102	2.185		my8407_rel_o2nofp.cz12a_c8r32
0.002	0.007	0.000	0.000	0.025	0.033	79.48	2278.9	0.873	1.663	2.424	35.64	0.012	0.138	0.000	0.000	0.040	0.654	1.538	1.567	0.142	3.635		my8407_rel_o2nofp.cz12a_dw0_c8r32
0.001	0.004	0.000	0.000	0.028	0.022	95.65	3523.4	1.062	1.584	1.225	40.83	0.010	0.040	0.000	0.000	0.029	0.178	1.986	1.763	0.086	1.679		my9400_rel_o2nofp.cz12a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	95.46	3537.7	1.057	1.584	1.472	40.96	0.010	0.040	0.000	0.000	0.032	0.178	1.593	1.663	0.103	2.119		my9500_rel_o2nofp.cz12a_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
185185	0	1620	6.3	474.8	45.4	0.009	0.035	0.003	0.251	24151	20.2	0.130	9	2.0	32.5	3.5	0.127	185678	163682	my5651_rel_o2nofp.cz12a_c8r32
167598	0	0	0.0	510.9	43.1	0.000	0.000	0.003	0.263	19318	20.1	0.115	10	2.0	32.5	4.0	0.130	167876	149588	my5744_rel_o2nofp.cz12a_c8r32
110294	0	0	0.0	405.0	31.3	0.000	0.000	0.004	0.291	13626	17.2	0.124	12	2.0	32.6	4.2	0.072	110583	102691	my8043_rel_o2nofp.cz12a_c8r32
111940	0	0	0.0	412.3	31.9	0.000	0.000	0.004	0.292	13853	17.2	0.124	12	2.0	32.6	4.3	0.074	112584	103785	my8044_rel_o2nofp.cz12a_c8r32
110294	0	0	0.0	406.6	31.5	0.000	0.000	0.004	0.292	13692	17.2	0.124	12	2.0	34.0	4.3	0.073	111085	102388	my8406_rel_o2nofp.cz12a_c8r32
108696	0	0	0.0	402.0	31.0	0.000	0.000	0.004	0.292	13496	17.3	0.124	13	2.0	34.0	4.2	0.073	109183	100887	my8407_rel_o2nofp.cz12a_c8r32
110294	0	0	0.0	385.2	28.9	0.000	0.000	0.003	0.269	13602	17.2	0.123	12	2.0	33.9	4.2	0.073	110784	102885	my8407_rel_o2nofp.cz12a_dw0_c8r32
109890	0	0	0.0	406.4	31.4	0.000	0.000	0.004	0.293	13646	17.2	0.124	13	2.0	34.0	4.3	0.074	110686	101484	my9400_rel_o2nofp.cz12a_c8r32
108696	0	0	0.0	418.0	31.7	0.000	0.000	0.004	0.299	14430	17.3	0.133	13	2.0	34.0	4.4	0.088	109283	100784	my9500_rel_o2nofp.cz12a_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
145632	0	32	0.1	2360.6	158.2	0.000	0.001	0.016	1.113	1939	10.7	0.013	6	4.2	34.7	5.1	0.002	NA	NA	my5651_rel_o2nofp.cz12a_c8r32
222223	0	0	0.0	3539.9	221.6	0.000	0.000	0.016	1.021	9583	12.1	0.043	4	4.6	35.1	5.5	0.001	NA	NA	my5744_rel_o2nofp.cz12a_c8r32
365855	0	2	0.0	11321.4	469.1	0.000	0.000	0.031	1.313	25129	40.4	0.069	9	4.5	35.1	5.0	0.001	NA	NA	my8043_rel_o2nofp.cz12a_c8r32
352942	0	1	0.0	10021.1	448.8	0.000	0.000	0.028	1.302	22641	41.9	0.064	9	4.5	35.1	4.8	0.001	NA	NA	my8044_rel_o2nofp.cz12a_c8r32
375001	0	2	0.0	10363.5	475.2	0.000	0.000	0.028	1.298	23146	41.9	0.062	9	4.5	36.5	5.1	0.002	NA	NA	my8406_rel_o2nofp.cz12a_c8r32
370372	0	1	0.0	11512.3	473.5	0.000	0.000	0.031	1.309	25409	40.9	0.069	9	4.5	36.5	5.0	0.001	NA	NA	my8407_rel_o2nofp.cz12a_c8r32
394738	0	1	0.0	10038.1	468.8	0.000	0.000	0.025	1.216	21876	42.9	0.055	9	4.5	36.5	4.9	0.002	NA	NA	my8407_rel_o2nofp.cz12a_dw0_c8r32
375001	0	1	0.0	12002.3	481.3	0.000	0.000	0.032	1.314	25695	39.9	0.069	9	4.5	36.5	5.1	0.002	NA	NA	my9400_rel_o2nofp.cz12a_c8r32
379748	0	1	0.0	10966.2	484.7	0.000	0.000	0.029	1.307	24664	41.3	0.065	9	4.5	36.5	5.4	0.002	NA	NA	my9500_rel_o2nofp.cz12a_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
33473	0	856	3.3	2507.9	109.3	0.026	0.102	0.075	3.342	34559	40.9	1.032	98	6.2	36.7	7.9	0.081	35546	9199	my5651_rel_o2nofp.cz12a_c8r32
38797	0	0	0.0	2862.5	125.6	0.000	0.000	0.074	3.314	24434	47.5	0.630	98	6.3	36.8	8.3	0.086	40445	11349	my5744_rel_o2nofp.cz12a_c8r32
34934	0	127	2.0	2773.9	115.6	0.004	0.058	0.079	3.389	43853	36.4	1.255	83	6.8	37.8	9.5	0.294	36146	6249	my8043_rel_o2nofp.cz12a_c8r32
35180	0	128	2.0	2795.8	116.5	0.004	0.058	0.079	3.391	43717	36.6	1.243	83	6.9	37.9	9.5	0.318	36296	6549	my8044_rel_o2nofp.cz12a_c8r32
34904	0	127	2.0	2689.6	113.3	0.004	0.058	0.077	3.323	43651	36.3	1.251	83	6.8	43.1	9.4	0.299	36096	6149	my8406_rel_o2nofp.cz12a_c8r32
34752	0	126	2.0	2739.7	114.8	0.004	0.058	0.079	3.381	43403	36.3	1.249	84	6.8	43.1	9.4	0.321	35995	6649	my8407_rel_o2nofp.cz12a_c8r32
35587	0	0	0.0	2513.0	83.7	0.000	0.000	0.071	2.407	43974	36.5	1.236	82	6.8	43.1	9.4	0.302	36647	7949	my8407_rel_o2nofp.cz12a_dw0_c8r32
34632	0	126	2.0	2724.8	114.2	0.004	0.058	0.079	3.376	43391	36.1	1.253	83	6.8	43.1	9.4	0.331	35896	6649	my9400_rel_o2nofp.cz12a_c8r32
35026	0	127	2.0	2712.2	114.5	0.004	0.058	0.077	3.346	43260	36.3	1.235	83	6.8	42.9	9.4	0.326	36146	4749	my9500_rel_o2nofp.cz12a_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
23419	0	4150	16.2	1633.3	67.9	0.177	0.709	0.070	2.970	203223	42.9	8.678	147	6.2	36.7	7.9	0.047	23477	22327	my5651_rel_o2nofp.cz12a_c8r32
25510	0	0	0.0	1886.0	78.1	0.000	0.000	0.074	3.136	114152	41.7	4.475	131	6.3	36.8	8.3	0.081	25567	23837	my5744_rel_o2nofp.cz12a_c8r32
20161	0	0	0.0	1678.6	67.5	0.000	0.000	0.083	3.428	105640	35.0	5.240	139	6.8	37.8	9.5	0.101	20208	19017	my8043_rel_o2nofp.cz12a_c8r32
20284	0	0	0.0	1698.8	68.2	0.000	0.000	0.084	3.443	106835	35.3	5.267	139	6.9	37.9	9.5	0.101	20328	19333	my8044_rel_o2nofp.cz12a_c8r32
20080	0	0	0.0	1630.3	66.2	0.000	0.000	0.081	3.375	105905	35.1	5.274	140	6.8	45.0	9.4	0.100	20173	19443	my8406_rel_o2nofp.cz12a_c8r32
20040	0	0	0.0	1694.2	67.9	0.000	0.000	0.085	3.471	105652	35.2	5.272	141	6.8	45.0	9.4	0.101	20103	19128	my8407_rel_o2nofp.cz12a_c8r32
20000	0	0	0.0	1463.4	46.5	0.000	0.000	0.073	2.382	104955	34.8	5.248	139	6.8	45.0	9.4	0.101	20058	19233	my8407_rel_o2nofp.cz12a_dw0_c8r32
20121	0	0	0.0	1616.4	65.9	0.000	0.000	0.080	3.353	105802	35.2	5.258	140	6.8	45.0	9.4	0.074	20153	19408	my9400_rel_o2nofp.cz12a_c8r32
19881	0	0	0.0	1650.6	67.7	0.000	0.000	0.083	3.488	114027	34.8	5.736	140	6.8	44.8	9.4	0.101	19978	18988	my9500_rel_o2nofp.cz12a_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	13136	4	0.0	736.4	20.3	0.000	0.001	7.372	207.768	75447	11.5	5.743	70	6.2	36.7	7.9	0.022	13150	12862	my5651_rel_o2nofp.cz12a_c8r32
100	10838	0	0.0	156.2	4.2	0.000	0.000	1.564	43.554	62256	12.4	5.744	92	6.3	36.8	8.3	0.010	10847	10735	my5744_rel_o2nofp.cz12a_c8r32
100	9002	0	0.0	172.1	4.8	0.000	0.000	1.721	48.749	52030	12.4	5.780	110	6.8	37.8	9.5	0.001	8991	8927	my8043_rel_o2nofp.cz12a_c8r32
100	9128	0	0.0	199.0	5.5	0.000	0.000	1.990	56.292	52799	12.4	5.784	109	6.9	37.9	9.5	0.001	9135	9039	my8044_rel_o2nofp.cz12a_c8r32
100	8931	0	0.0	170.3	4.7	0.000	0.000	1.705	48.207	51681	12.4	5.786	111	6.8	45.0	9.4	0.001	8943	8863	my8406_rel_o2nofp.cz12a_c8r32
100	8874	0	0.0	162.0	4.5	0.000	0.000	1.620	45.883	51303	13.3	5.781	120	6.8	45.0	9.4	0.001	8879	8783	my8407_rel_o2nofp.cz12a_c8r32
100	8858	0	0.0	172.6	2.8	0.000	0.000	1.726	28.237	51217	13.3	5.782	120	6.8	45.0	9.4	0.004	8863	8767	my8407_rel_o2nofp.cz12a_dw0_c8r32
100	9022	0	0.0	170.0	4.7	0.000	0.000	1.700	48.161	52165	12.4	5.782	110	6.8	45.0	9.4	0.001	9023	8959	my9400_rel_o2nofp.cz12a_c8r32
100	9046	0	0.0	153.3	4.2	0.000	0.000	1.534	43.427	52315	12.4	5.784	110	6.8	44.9	9.4	0.004	9055	8975	my9500_rel_o2nofp.cz12a_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	11193	4	0.0	747.2	20.6	0.000	0.001	7.472	210.665	64935	12.4	5.801	89	6.2	36.7	7.9	0.028	11199	10974	my5651_rel_o2nofp.cz12a_c8r32
100	9291	0	0.0	37.7	1.0	0.000	0.000	0.377	9.830	53909	11.7	5.802	101	6.3	36.8	8.3	0.001	9295	9215	my5744_rel_o2nofp.cz12a_c8r32
100	6973	0	0.0	31.9	0.9	0.000	0.000	0.319	9.093	40751	12.3	5.844	141	6.8	37.8	9.5	0.001	6975	6927	my8043_rel_o2nofp.cz12a_c8r32
100	6986	0	0.0	33.5	0.9	0.000	0.000	0.335	9.569	40825	12.4	5.844	142	6.9	37.9	9.5	0.001	6991	6927	my8044_rel_o2nofp.cz12a_c8r32
100	6838	0	0.0	46.5	1.3	0.000	0.000	0.465	12.972	40006	12.3	5.851	144	6.8	45.0	9.4	0.001	6847	6799	my8406_rel_o2nofp.cz12a_c8r32
100	6800	0	0.0	35.7	1.0	0.000	0.000	0.357	10.109	39755	12.8	5.847	151	6.8	45.0	9.4	0.002	6799	6719	my8407_rel_o2nofp.cz12a_c8r32
100	6838	0	0.0	31.3	0.6	0.000	0.000	0.313	5.664	39974	13.1	5.846	153	6.8	45.0	9.4	0.002	6831	6751	my8407_rel_o2nofp.cz12a_dw0_c8r32
100	6932	0	0.0	41.0	1.1	0.000	0.000	0.410	11.287	40526	11.9	5.846	137	6.8	45.0	9.4	0.001	6927	6911	my9400_rel_o2nofp.cz12a_c8r32
100	6950	0	0.0	41.5	1.1	0.000	0.000	0.416	11.710	40654	12.4	5.849	143	6.8	44.9	9.4	0.001	6959	6911	my9500_rel_o2nofp.cz12a_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
500	13110	17	0.1	2083.7	58.1	0.001	0.005	4.167	118.890	75728	12.0	5.776	73	6.2	36.7	7.9	0.022	13167	12190	my5651_rel_o2nofp.cz12a_c8r32
500	10885	0	0.0	62.9	2.0	0.000	0.000	0.126	4.142	62640	12.4	5.755	91	6.3	36.8	8.3	0.004	10894	10799	my5744_rel_o2nofp.cz12a_c8r32
500	8996	0	0.0	82.1	2.6	0.000	0.000	0.164	5.350	52269	12.4	5.810	110	6.8	37.8	9.5	0.002	8991	8927	my8043_rel_o2nofp.cz12a_c8r32
500	9132	0	0.0	74.9	2.4	0.000	0.000	0.150	4.964	53082	12.8	5.813	112	6.9	37.9	9.5	0.002	9135	9055	my8044_rel_o2nofp.cz12a_c8r32
500	8886	0	0.0	80.8	2.6	0.000	0.000	0.162	5.274	51650	12.4	5.813	112	6.8	45.1	9.4	0.002	8879	8831	my8406_rel_o2nofp.cz12a_c8r32
500	8884	0	0.0	66.6	2.2	0.000	0.000	0.133	4.483	51624	13.3	5.811	120	6.8	45.1	9.4	0.002	8879	8799	my8407_rel_o2nofp.cz12a_c8r32
500	8882	0	0.0	68.1	1.5	0.000	0.000	0.136	3.117	51647	13.3	5.815	120	6.8	45.1	9.4	0.002	8895	8799	my8407_rel_o2nofp.cz12a_dw0_c8r32
500	9024	0	0.0	76.7	2.5	0.000	0.000	0.153	5.020	52441	12.7	5.811	113	6.8	45.1	9.4	0.002	9023	8959	my9400_rel_o2nofp.cz12a_c8r32
500	8992	0	0.0	63.7	2.1	0.000	0.000	0.127	4.323	52240	12.6	5.810	112	6.8	45.0	9.4	0.002	8991	8927	my9500_rel_o2nofp.cz12a_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
500	11124	16	0.1	2127.6	59.3	0.001	0.006	4.255	121.394	64979	12.6	5.842	91	6.2	36.7	7.9	0.024	11135	10671	my5651_rel_o2nofp.cz12a_c8r32
500	9346	0	0.0	39.6	1.4	0.000	0.000	0.079	2.788	54338	12.5	5.814	107	6.3	36.8	8.3	0.004	9343	9263	my5744_rel_o2nofp.cz12a_c8r32
500	6986	0	0.0	32.9	1.2	0.000	0.000	0.066	2.533	41193	12.4	5.896	142	6.8	37.8	9.5	0.002	6991	6943	my8043_rel_o2nofp.cz12a_c8r32
500	6943	0	0.0	31.8	1.2	0.000	0.000	0.064	2.510	40944	12.8	5.897	147	6.9	37.9	9.5	0.002	6943	6895	my8044_rel_o2nofp.cz12a_c8r32
500	6799	0	0.0	37.9	1.4	0.000	0.000	0.076	2.840	40101	12.6	5.898	148	6.8	45.2	9.4	0.002	6799	6751	my8406_rel_o2nofp.cz12a_c8r32
500	6744	0	0.0	35.2	1.3	0.000	0.000	0.070	2.740	39783	12.9	5.899	153	6.8	45.2	9.4	0.002	6751	6687	my8407_rel_o2nofp.cz12a_c8r32
500	6775	0	0.0	28.5	0.9	0.000	0.000	0.057	1.872	39972	12.7	5.900	150	6.8	45.2	9.4	0.002	6783	6703	my8407_rel_o2nofp.cz12a_dw0_c8r32
500	6901	0	0.0	34.3	1.3	0.000	0.000	0.069	2.620	40715	12.2	5.900	141	6.8	45.2	9.4	0.002	6911	6863	my9400_rel_o2nofp.cz12a_c8r32
500	6926	0	0.0	36.2	1.4	0.000	0.000	0.072	2.806	40835	12.7	5.896	147	6.8	45.1	9.4	0.002	6927	6895	my9500_rel_o2nofp.cz12a_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	13020	28	0.1	1847.5	52.0	0.002	0.009	1.849	53.273	75625	12.8	5.808	79	6.2	36.7	7.9	0.020	13054	12366	my5651_rel_o2nofp.cz12a_c8r32
1000	10864	0	0.0	89.5	3.2	0.000	0.000	0.090	3.257	62710	13.1	5.773	96	6.3	36.8	8.3	0.006	10863	10767	my5744_rel_o2nofp.cz12a_c8r32
999	9042	0	0.0	100.2	3.6	0.000	0.000	0.100	3.644	53080	13.4	5.870	119	6.8	37.8	9.5	0.001	9055	8943	my8043_rel_o2nofp.cz12a_c8r32
1000	9097	0	0.0	99.4	3.5	0.000	0.000	0.099	3.632	53323	13.4	5.862	118	6.9	37.9	9.5	0.002	9103	9023	my8044_rel_o2nofp.cz12a_c8r32
1000	8882	0	0.0	97.8	3.5	0.000	0.000	0.098	3.581	52114	13.3	5.867	120	6.8	45.4	9.4	0.002	8879	8815	my8406_rel_o2nofp.cz12a_c8r32
999	8768	0	0.0	97.9	3.5	0.000	0.000	0.098	3.601	51473	14.1	5.871	129	6.8	45.4	9.5	0.002	8767	8703	my8407_rel_o2nofp.cz12a_c8r32
999	8814	0	0.0	90.7	2.4	0.000	0.000	0.091	2.435	51749	13.7	5.871	124	6.8	45.4	9.4	0.002	8815	8735	my8407_rel_o2nofp.cz12a_dw0_c8r32
999	9101	0	0.0	101.3	3.6	0.000	0.000	0.101	3.657	53417	13.4	5.870	118	6.8	45.4	9.4	0.002	9103	9039	my9400_rel_o2nofp.cz12a_c8r32
1000	8965	0	0.0	97.1	3.5	0.000	0.000	0.097	3.577	52584	13.8	5.865	123	6.8	45.2	9.4	0.002	8959	8895	my9500_rel_o2nofp.cz12a_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	11214	29	0.1	11.6	1.1	0.003	0.010	0.012	1.154	65703	12.4	5.859	88	6.2	36.7	7.9	0.010	11230	11087	my5651_rel_o2nofp.cz12a_c8r32
1000	9255	0	0.0	69.5	2.6	0.000	0.000	0.070	2.694	54033	12.7	5.838	110	6.3	36.8	8.3	0.002	9247	9183	my5744_rel_o2nofp.cz12a_c8r32
1000	6954	0	0.0	89.9	3.3	0.000	0.000	0.090	3.368	41504	12.9	5.968	148	6.8	37.8	9.5	0.002	6959	6911	my8043_rel_o2nofp.cz12a_c8r32
1000	6943	0	0.0	91.7	3.3	0.000	0.000	0.092	3.418	41435	13.1	5.968	151	6.9	37.9	9.5	0.002	6943	6895	my8044_rel_o2nofp.cz12a_c8r32
1000	6800	0	0.0	81.5	3.1	0.000	0.000	0.082	3.133	40612	13.4	5.972	158	6.8	45.6	9.4	0.002	6799	6751	my8406_rel_o2nofp.cz12a_c8r32
999	6689	0	0.0	91.6	3.3	0.000	0.000	0.092	3.426	39997	13.4	5.980	160	6.8	45.6	9.5	0.003	6687	6639	my8407_rel_o2nofp.cz12a_c8r32
1000	6814	0	0.0	79.4	2.2	0.000	0.000	0.079	2.276	40687	13.9	5.971	163	6.8	45.6	9.4	0.002	6815	6735	my8407_rel_o2nofp.cz12a_dw0_c8r32
999	6886	0	0.0	95.5	3.4	0.000	0.000	0.096	3.521	41138	12.7	5.975	148	6.8	45.6	9.4	0.002	6895	6831	my9400_rel_o2nofp.cz12a_c8r32
1000	6923	0	0.0	95.5	3.5	0.000	0.000	0.096	3.539	41337	13.2	5.971	153	6.8	45.4	9.4	0.002	6927	6879	my9500_rel_o2nofp.cz12a_c8r32

l.i0

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	99.719	0.225	0.050	0.005	0.001	0.000	0.000	0.000	0.000	0.127	my5651_rel_o2nofp.cz12a_c8r32
0.000	99.717	0.094	0.108	0.080	0.001	0.000	0.000	0.000	0.000	0.130	my5744_rel_o2nofp.cz12a_c8r32
0.000	99.506	0.301	0.106	0.085	0.002	0.000	0.000	0.000	0.000	0.072	my8043_rel_o2nofp.cz12a_c8r32
0.000	99.503	0.304	0.080	0.112	0.001	0.000	0.000	0.000	0.000	0.074	my8044_rel_o2nofp.cz12a_c8r32
0.000	99.498	0.309	0.100	0.091	0.002	0.000	0.000	0.000	0.000	0.073	my8406_rel_o2nofp.cz12a_c8r32
0.000	99.501	0.306	0.086	0.106	0.002	0.000	0.000	0.000	0.000	0.073	my8407_rel_o2nofp.cz12a_c8r32
0.000	99.501	0.306	0.086	0.105	0.002	0.000	0.000	0.000	0.000	0.073	my8407_rel_o2nofp.cz12a_dw0_c8r32
0.000	99.496	0.311	0.079	0.113	0.002	0.000	0.000	0.000	0.000	0.074	my9400_rel_o2nofp.cz12a_c8r32
0.000	99.436	0.368	0.071	0.124	0.002	0.000	0.000	0.000	0.000	0.088	my9500_rel_o2nofp.cz12a_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.762	87.330	1.760	0.148	nonzero	0.000	0.000	0.000	0.000	0.081	my5651_rel_o2nofp.cz12a_c8r32
0.000	19.701	79.770	0.499	0.029	0.001	0.000	0.000	0.000	0.000	0.086	my5744_rel_o2nofp.cz12a_c8r32
0.000	0.000	99.362	0.569	0.068	nonzero	nonzero	0.000	0.000	0.000	0.294	my8043_rel_o2nofp.cz12a_c8r32
0.000	0.000	99.376	0.556	0.067	0.001	nonzero	0.000	0.000	0.000	0.318	my8044_rel_o2nofp.cz12a_c8r32
0.000	0.000	99.375	0.554	0.070	0.001	nonzero	0.000	0.000	0.000	0.299	my8406_rel_o2nofp.cz12a_c8r32
0.000	0.000	99.355	0.578	0.066	0.001	nonzero	0.000	0.000	0.000	0.321	my8407_rel_o2nofp.cz12a_c8r32
0.000	0.000	99.577	0.368	0.055	nonzero	nonzero	0.000	0.000	0.000	0.302	my8407_rel_o2nofp.cz12a_dw0_c8r32
0.000	0.000	99.352	0.579	0.068	0.001	nonzero	0.000	0.000	0.000	0.331	my9400_rel_o2nofp.cz12a_c8r32
0.000	0.000	99.361	0.567	0.072	nonzero	nonzero	0.000	0.000	0.000	0.326	my9500_rel_o2nofp.cz12a_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	76.242	22.643	1.000	0.115	nonzero	0.000	0.000	0.000	0.000	0.081	my5651_rel_o2nofp.cz12a_c8r32
0.000	68.825	31.043	0.123	0.009	0.001	0.000	0.000	0.000	0.000	0.086	my5744_rel_o2nofp.cz12a_c8r32
0.000	85.303	14.506	0.174	0.017	nonzero	nonzero	0.000	0.000	0.000	0.294	my8043_rel_o2nofp.cz12a_c8r32
0.000	85.471	14.347	0.166	0.016	nonzero	0.000	0.000	0.000	0.000	0.240	my8044_rel_o2nofp.cz12a_c8r32
0.000	84.987	14.830	0.169	0.014	0.000	nonzero	0.000	0.000	0.000	0.313	my8406_rel_o2nofp.cz12a_c8r32
0.000	83.089	16.719	0.175	0.017	nonzero	0.000	0.000	0.000	0.000	0.101	my8407_rel_o2nofp.cz12a_c8r32
0.000	88.371	11.585	0.030	0.015	nonzero	nonzero	0.000	0.000	0.000	0.302	my8407_rel_o2nofp.cz12a_dw0_c8r32
0.000	82.798	17.011	0.173	0.017	nonzero	nonzero	0.000	0.000	0.000	0.283	my9400_rel_o2nofp.cz12a_c8r32
0.000	88.682	11.126	0.175	0.016	0.001	nonzero	0.000	0.000	0.000	0.326	my9500_rel_o2nofp.cz12a_c8r32

l.i2

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
88.489	11.387	0.020	0.100	0.003	0.000	0.000	0.000	0.000	0.000	0.047	my5651_rel_o2nofp.cz12a_c8r32
93.613	6.335	0.043	0.009	nonzero	nonzero	0.000	0.000	0.000	0.000	0.081	my5744_rel_o2nofp.cz12a_c8r32
82.152	17.817	0.023	0.008	0.001	nonzero	0.000	0.000	0.000	0.000	0.101	my8043_rel_o2nofp.cz12a_c8r32
82.366	17.602	0.023	0.008	0.001	nonzero	0.000	0.000	0.000	0.000	0.101	my8044_rel_o2nofp.cz12a_c8r32
82.083	17.888	0.022	0.007	0.001	nonzero	0.000	0.000	0.000	0.000	0.100	my8406_rel_o2nofp.cz12a_c8r32
82.028	17.940	0.023	0.008	0.001	nonzero	0.000	0.000	0.000	0.000	0.101	my8407_rel_o2nofp.cz12a_c8r32
81.991	17.992	0.012	0.005	0.001	nonzero	0.000	0.000	0.000	0.000	0.101	my8407_rel_o2nofp.cz12a_dw0_c8r32
81.969	18.001	0.021	0.008	0.001	nonzero	0.000	0.000	0.000	0.000	0.074	my9400_rel_o2nofp.cz12a_c8r32
82.211	17.759	0.020	0.009	0.001	nonzero	0.000	0.000	0.000	0.000	0.101	my9500_rel_o2nofp.cz12a_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
96.796	3.081	0.020	0.100	0.003	0.000	0.000	0.000	0.000	0.000	0.047	my5651_rel_o2nofp.cz12a_c8r32
94.418	5.557	0.018	0.006	nonzero	nonzero	0.000	0.000	0.000	0.000	0.080	my5744_rel_o2nofp.cz12a_c8r32
95.898	4.076	0.017	0.007	0.001	nonzero	0.000	0.000	0.000	0.000	0.101	my8043_rel_o2nofp.cz12a_c8r32
96.196	3.781	0.016	0.006	0.001	nonzero	0.000	0.000	0.000	0.000	0.101	my8044_rel_o2nofp.cz12a_c8r32
95.812	4.165	0.016	0.006	0.001	nonzero	0.000	0.000	0.000	0.000	0.100	my8406_rel_o2nofp.cz12a_c8r32
95.742	4.233	0.017	0.007	0.001	nonzero	0.000	0.000	0.000	0.000	0.101	my8407_rel_o2nofp.cz12a_c8r32
95.746	4.240	0.008	0.005	0.001	nonzero	0.000	0.000	0.000	0.000	0.101	my8407_rel_o2nofp.cz12a_dw0_c8r32
95.774	4.203	0.016	0.006	0.001	nonzero	0.000	0.000	0.000	0.000	0.070	my9400_rel_o2nofp.cz12a_c8r32
97.256	2.717	0.018	0.008	0.001	nonzero	0.000	0.000	0.000	0.000	0.101	my9500_rel_o2nofp.cz12a_c8r32

qr100.L1

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.985	0.008	0.002	0.005	nonzero	0.000	0.000	0.000	0.000	0.000	0.022	my5651_rel_o2nofp.cz12a_c8r32
99.998	0.002	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.010	my5744_rel_o2nofp.cz12a_c8r32
99.990	0.010	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	my8043_rel_o2nofp.cz12a_c8r32
99.990	0.010	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	my8044_rel_o2nofp.cz12a_c8r32
99.989	0.011	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	my8406_rel_o2nofp.cz12a_c8r32
99.989	0.011	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	my8407_rel_o2nofp.cz12a_c8r32
99.987	0.013	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.004	my8407_rel_o2nofp.cz12a_dw0_c8r32
99.989	0.011	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	my9400_rel_o2nofp.cz12a_c8r32
99.990	0.010	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.004	my9500_rel_o2nofp.cz12a_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.750	49.667	46.778	2.806	0.000	0.000	0.000	0.000	0.000	0.054	my5651_rel_o2nofp.cz12a_c8r32
0.000	7.444	92.528	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.010	my5744_rel_o2nofp.cz12a_c8r32
0.000	0.000	90.222	9.778	0.000	0.000	0.000	0.000	0.000	0.000	0.012	my8043_rel_o2nofp.cz12a_c8r32
0.000	0.000	90.250	9.750	0.000	0.000	0.000	0.000	0.000	0.000	0.012	my8044_rel_o2nofp.cz12a_c8r32
0.000	0.000	90.194	9.778	0.028	0.000	0.000	0.000	0.000	0.000	0.042	my8406_rel_o2nofp.cz12a_c8r32
0.000	0.000	99.944	0.028	0.028	0.000	0.000	0.000	0.000	0.000	0.029	my8407_rel_o2nofp.cz12a_c8r32
0.000	0.000	90.639	9.333	0.028	0.000	0.000	0.000	0.000	0.000	0.043	my8407_rel_o2nofp.cz12a_dw0_c8r32
0.000	0.000	99.944	0.028	0.028	0.000	0.000	0.000	0.000	0.000	0.032	my9400_rel_o2nofp.cz12a_c8r32
0.000	0.000	91.444	8.528	0.028	0.000	0.000	0.000	0.000	0.000	0.048	my9500_rel_o2nofp.cz12a_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	3.806	46.333	48.139	1.722	0.000	0.000	0.000	0.000	0.000	0.043	my5651_rel_o2nofp.cz12a_c8r32
0.000	59.250	40.750	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my5744_rel_o2nofp.cz12a_c8r32
0.000	43.500	46.806	9.694	0.000	0.000	0.000	0.000	0.000	0.000	0.011	my8043_rel_o2nofp.cz12a_c8r32
0.000	46.306	44.028	9.667	0.000	0.000	0.000	0.000	0.000	0.000	0.012	my8044_rel_o2nofp.cz12a_c8r32
0.000	44.333	45.889	9.750	0.028	0.000	0.000	0.000	0.000	0.000	0.045	my8406_rel_o2nofp.cz12a_c8r32
0.000	52.222	47.722	0.028	0.028	0.000	0.000	0.000	0.000	0.000	0.032	my8407_rel_o2nofp.cz12a_c8r32
0.000	44.083	46.611	9.278	0.028	0.000	0.000	0.000	0.000	0.000	0.047	my8407_rel_o2nofp.cz12a_dw0_c8r32
0.000	50.028	49.917	0.028	0.028	0.000	0.000	0.000	0.000	0.000	0.028	my9400_rel_o2nofp.cz12a_c8r32
0.000	46.139	45.333	8.500	0.028	0.000	0.000	0.000	0.000	0.000	0.044	my9500_rel_o2nofp.cz12a_c8r32

qp100.L2

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.982	0.013	0.002	0.004	nonzero	0.000	0.000	0.000	0.000	0.000	0.028	my5651_rel_o2nofp.cz12a_c8r32
99.991	0.009	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	my5744_rel_o2nofp.cz12a_c8r32
99.966	0.034	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	my8043_rel_o2nofp.cz12a_c8r32
99.964	0.036	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	my8044_rel_o2nofp.cz12a_c8r32
99.950	0.050	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	my8406_rel_o2nofp.cz12a_c8r32
99.954	0.046	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8407_rel_o2nofp.cz12a_c8r32
99.954	0.046	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8407_rel_o2nofp.cz12a_dw0_c8r32
99.958	0.042	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	my9400_rel_o2nofp.cz12a_c8r32
99.961	0.039	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	my9500_rel_o2nofp.cz12a_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.111	52.750	45.472	1.667	0.000	0.000	0.000	0.000	0.000	0.057	my5651_rel_o2nofp.cz12a_c8r32
0.000	0.028	99.972	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my5744_rel_o2nofp.cz12a_c8r32
0.000	0.000	90.194	9.806	0.000	0.000	0.000	0.000	0.000	0.000	0.011	my8043_rel_o2nofp.cz12a_c8r32
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.005	my8044_rel_o2nofp.cz12a_c8r32
0.000	0.000	90.167	9.833	0.000	0.000	0.000	0.000	0.000	0.000	0.012	my8406_rel_o2nofp.cz12a_c8r32
0.000	0.000	99.917	0.083	0.000	0.000	0.000	0.000	0.000	0.000	0.013	my8407_rel_o2nofp.cz12a_c8r32
0.000	0.000	90.417	9.583	0.000	0.000	0.000	0.000	0.000	0.000	0.011	my8407_rel_o2nofp.cz12a_dw0_c8r32
0.000	0.000	91.000	8.972	0.028	0.000	0.000	0.000	0.000	0.000	0.023	my9400_rel_o2nofp.cz12a_c8r32
0.000	0.000	90.472	9.528	0.000	0.000	0.000	0.000	0.000	0.000	0.011	my9500_rel_o2nofp.cz12a_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	3.194	49.250	46.194	1.361	0.000	0.000	0.000	0.000	0.000	0.056	my5651_rel_o2nofp.cz12a_c8r32
0.000	50.028	49.972	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my5744_rel_o2nofp.cz12a_c8r32
0.000	8.944	81.361	9.694	0.000	0.000	0.000	0.000	0.000	0.000	0.011	my8043_rel_o2nofp.cz12a_c8r32
0.000	28.306	71.667	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.005	my8044_rel_o2nofp.cz12a_c8r32
0.000	8.806	81.389	9.806	0.000	0.000	0.000	0.000	0.000	0.000	0.012	my8406_rel_o2nofp.cz12a_c8r32
0.000	21.111	78.861	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.013	my8407_rel_o2nofp.cz12a_c8r32
0.000	20.667	69.806	9.528	0.000	0.000	0.000	0.000	0.000	0.000	0.011	my8407_rel_o2nofp.cz12a_dw0_c8r32
0.000	9.778	81.278	8.917	0.028	0.000	0.000	0.000	0.000	0.000	0.022	my9400_rel_o2nofp.cz12a_c8r32
0.000	11.167	79.333	9.500	0.000	0.000	0.000	0.000	0.000	0.000	0.011	my9500_rel_o2nofp.cz12a_c8r32

qr500.L3

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.979	0.014	0.003	0.005	nonzero	0.000	0.000	0.000	0.000	0.000	0.022	my5651_rel_o2nofp.cz12a_c8r32
99.997	0.003	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.004	my5744_rel_o2nofp.cz12a_c8r32
99.987	0.013	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8043_rel_o2nofp.cz12a_c8r32
99.988	0.012	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8044_rel_o2nofp.cz12a_c8r32
99.984	0.016	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8406_rel_o2nofp.cz12a_c8r32
99.986	0.014	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8407_rel_o2nofp.cz12a_c8r32
99.986	0.014	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8407_rel_o2nofp.cz12a_dw0_c8r32
99.987	0.013	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my9400_rel_o2nofp.cz12a_c8r32
99.986	0.014	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my9500_rel_o2nofp.cz12a_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	11.217	71.978	15.206	1.600	0.000	0.000	0.000	0.000	0.000	0.051	my5651_rel_o2nofp.cz12a_c8r32
0.000	44.683	55.306	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.010	my5744_rel_o2nofp.cz12a_c8r32
0.000	0.000	98.056	1.939	0.006	0.000	0.000	0.000	0.000	0.000	0.022	my8043_rel_o2nofp.cz12a_c8r32
0.000	0.000	98.111	1.889	0.000	0.000	0.000	0.000	0.000	0.000	0.011	my8044_rel_o2nofp.cz12a_c8r32
0.000	0.000	98.056	1.944	0.000	0.000	0.000	0.000	0.000	0.000	0.016	my8406_rel_o2nofp.cz12a_c8r32
0.000	0.000	99.967	0.033	0.000	0.000	0.000	0.000	0.000	0.000	0.013	my8407_rel_o2nofp.cz12a_c8r32
0.000	0.000	98.139	1.856	0.006	0.000	0.000	0.000	0.000	0.000	0.022	my8407_rel_o2nofp.cz12a_dw0_c8r32
0.000	0.000	98.172	1.822	0.006	0.000	0.000	0.000	0.000	0.000	0.022	my9400_rel_o2nofp.cz12a_c8r32
0.000	0.000	98.067	1.933	0.000	0.000	0.000	0.000	0.000	0.000	0.011	my9500_rel_o2nofp.cz12a_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	19.717	63.883	14.978	1.422	0.000	0.000	0.000	0.000	0.000	0.049	my5651_rel_o2nofp.cz12a_c8r32
0.000	89.350	10.639	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.010	my5744_rel_o2nofp.cz12a_c8r32
0.000	87.028	11.022	1.944	0.006	0.000	0.000	0.000	0.000	0.000	0.022	my8043_rel_o2nofp.cz12a_c8r32
0.000	88.661	9.450	1.889	0.000	0.000	0.000	0.000	0.000	0.000	0.011	my8044_rel_o2nofp.cz12a_c8r32
0.000	87.106	10.956	1.939	0.000	0.000	0.000	0.000	0.000	0.000	0.015	my8406_rel_o2nofp.cz12a_c8r32
0.000	85.750	14.233	0.017	0.000	0.000	0.000	0.000	0.000	0.000	0.012	my8407_rel_o2nofp.cz12a_c8r32
0.000	86.844	11.294	1.856	0.006	0.000	0.000	0.000	0.000	0.000	0.022	my8407_rel_o2nofp.cz12a_dw0_c8r32
0.000	86.633	11.550	1.811	0.006	0.000	0.000	0.000	0.000	0.000	0.022	my9400_rel_o2nofp.cz12a_c8r32
0.000	88.644	9.428	1.928	0.000	0.000	0.000	0.000	0.000	0.000	0.011	my9500_rel_o2nofp.cz12a_c8r32

qp500.L4

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.967	0.029	0.001	0.003	nonzero	0.000	0.000	0.000	0.000	0.000	0.024	my5651_rel_o2nofp.cz12a_c8r32
99.992	0.008	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.004	my5744_rel_o2nofp.cz12a_c8r32
99.954	0.046	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8043_rel_o2nofp.cz12a_c8r32
99.952	0.048	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8044_rel_o2nofp.cz12a_c8r32
99.943	0.057	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8406_rel_o2nofp.cz12a_c8r32
99.945	0.055	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8407_rel_o2nofp.cz12a_c8r32
99.946	0.054	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8407_rel_o2nofp.cz12a_dw0_c8r32
99.943	0.057	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my9400_rel_o2nofp.cz12a_c8r32
99.949	0.051	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my9500_rel_o2nofp.cz12a_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	10.933	72.694	14.939	1.428	0.006	0.000	0.000	0.000	0.000	0.071	my5651_rel_o2nofp.cz12a_c8r32
0.000	21.839	78.161	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	my5744_rel_o2nofp.cz12a_c8r32
0.000	0.000	98.094	1.900	0.006	0.000	0.000	0.000	0.000	0.000	0.020	my8043_rel_o2nofp.cz12a_c8r32
0.000	0.000	98.133	1.861	0.006	0.000	0.000	0.000	0.000	0.000	0.020	my8044_rel_o2nofp.cz12a_c8r32
0.000	0.000	98.211	1.783	0.006	0.000	0.000	0.000	0.000	0.000	0.018	my8406_rel_o2nofp.cz12a_c8r32
0.000	0.000	98.206	1.789	0.006	0.000	0.000	0.000	0.000	0.000	0.022	my8407_rel_o2nofp.cz12a_c8r32
0.000	0.000	99.978	0.022	0.000	0.000	0.000	0.000	0.000	0.000	0.009	my8407_rel_o2nofp.cz12a_dw0_c8r32
0.000	0.000	98.178	1.822	0.000	0.000	0.000	0.000	0.000	0.000	0.011	my9400_rel_o2nofp.cz12a_c8r32
0.000	0.000	98.178	1.817	0.006	0.000	0.000	0.000	0.000	0.000	0.019	my9500_rel_o2nofp.cz12a_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	23.794	60.150	14.794	1.261	0.000	0.000	0.000	0.000	0.000	0.056	my5651_rel_o2nofp.cz12a_c8r32
0.000	88.578	11.422	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my5744_rel_o2nofp.cz12a_c8r32
0.000	82.278	15.817	1.900	0.006	0.000	0.000	0.000	0.000	0.000	0.020	my8043_rel_o2nofp.cz12a_c8r32
0.000	81.906	16.239	1.850	0.006	0.000	0.000	0.000	0.000	0.000	0.021	my8044_rel_o2nofp.cz12a_c8r32
0.000	80.539	17.683	1.772	0.006	0.000	0.000	0.000	0.000	0.000	0.018	my8406_rel_o2nofp.cz12a_c8r32
0.000	62.528	35.689	1.783	0.000	0.000	0.000	0.000	0.000	0.000	0.011	my8407_rel_o2nofp.cz12a_c8r32
0.000	69.233	30.756	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.008	my8407_rel_o2nofp.cz12a_dw0_c8r32
0.000	56.028	42.156	1.817	0.000	0.000	0.000	0.000	0.000	0.000	0.011	my9400_rel_o2nofp.cz12a_c8r32
0.000	84.039	14.156	1.800	0.006	0.000	0.000	0.000	0.000	0.000	0.018	my9500_rel_o2nofp.cz12a_c8r32

qr1000.L5

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.975	0.019	0.002	0.004	nonzero	0.000	0.000	0.000	0.000	0.000	0.020	my5651_rel_o2nofp.cz12a_c8r32
99.996	0.004	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.006	my5744_rel_o2nofp.cz12a_c8r32
99.985	0.015	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	my8043_rel_o2nofp.cz12a_c8r32
99.986	0.014	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8044_rel_o2nofp.cz12a_c8r32
99.981	0.019	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8406_rel_o2nofp.cz12a_c8r32
99.982	0.018	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8407_rel_o2nofp.cz12a_c8r32
99.982	0.018	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8407_rel_o2nofp.cz12a_dw0_c8r32
99.986	0.014	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my9400_rel_o2nofp.cz12a_c8r32
99.984	0.016	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my9500_rel_o2nofp.cz12a_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	15.244	76.281	8.325	0.150	0.000	0.000	0.000	0.000	0.000	0.035	my5651_rel_o2nofp.cz12a_c8r32
0.000	49.247	50.753	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my5744_rel_o2nofp.cz12a_c8r32
0.000	0.000	99.978	0.022	0.000	0.000	0.000	0.000	0.000	0.000	0.009	my8043_rel_o2nofp.cz12a_c8r32
0.000	0.000	99.042	0.956	0.003	0.000	0.000	0.000	0.000	0.000	0.022	my8044_rel_o2nofp.cz12a_c8r32
0.000	0.000	99.047	0.947	0.006	0.000	0.000	0.000	0.000	0.000	0.037	my8406_rel_o2nofp.cz12a_c8r32
0.000	0.000	99.036	0.958	0.006	0.000	0.000	0.000	0.000	0.000	0.037	my8407_rel_o2nofp.cz12a_c8r32
0.000	0.000	98.897	1.097	0.003	0.003	0.000	0.000	0.000	0.000	0.101	my8407_rel_o2nofp.cz12a_dw0_c8r32
0.000	0.000	99.100	0.894	0.006	0.000	0.000	0.000	0.000	0.000	0.038	my9400_rel_o2nofp.cz12a_c8r32
0.000	0.000	99.094	0.903	0.003	0.000	0.000	0.000	0.000	0.000	0.048	my9500_rel_o2nofp.cz12a_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	27.403	64.650	7.811	0.136	0.000	0.000	0.000	0.000	0.000	0.031	my5651_rel_o2nofp.cz12a_c8r32
0.000	92.761	7.239	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my5744_rel_o2nofp.cz12a_c8r32
0.000	88.447	11.544	0.008	0.000	0.000	0.000	0.000	0.000	0.000	0.009	my8043_rel_o2nofp.cz12a_c8r32
0.000	91.894	7.147	0.956	0.003	0.000	0.000	0.000	0.000	0.000	0.021	my8044_rel_o2nofp.cz12a_c8r32
0.000	91.175	7.889	0.933	0.003	0.000	0.000	0.000	0.000	0.000	0.022	my8406_rel_o2nofp.cz12a_c8r32
0.000	90.981	8.108	0.906	0.006	0.000	0.000	0.000	0.000	0.000	0.035	my8407_rel_o2nofp.cz12a_c8r32
0.000	90.214	8.672	1.108	0.003	0.003	0.000	0.000	0.000	0.000	0.101	my8407_rel_o2nofp.cz12a_dw0_c8r32
0.000	90.372	8.736	0.886	0.006	0.000	0.000	0.000	0.000	0.000	0.040	my9400_rel_o2nofp.cz12a_c8r32
0.000	92.611	6.492	0.894	0.003	0.000	0.000	0.000	0.000	0.000	0.045	my9500_rel_o2nofp.cz12a_c8r32

qp1000.L6

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.958	0.039	0.001	0.002	0.000	0.000	0.000	0.000	0.000	0.000	0.010	my5651_rel_o2nofp.cz12a_c8r32
99.986	0.014	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my5744_rel_o2nofp.cz12a_c8r32
99.939	0.061	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8043_rel_o2nofp.cz12a_c8r32
99.942	0.058	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8044_rel_o2nofp.cz12a_c8r32
99.932	0.068	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8406_rel_o2nofp.cz12a_c8r32
99.935	0.065	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	my8407_rel_o2nofp.cz12a_c8r32
99.931	0.069	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my8407_rel_o2nofp.cz12a_dw0_c8r32
99.931	0.069	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my9400_rel_o2nofp.cz12a_c8r32
99.936	0.064	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my9500_rel_o2nofp.cz12a_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	17.767	77.483	4.742	0.008	0.000	0.000	0.000	0.000	0.000	0.017	my5651_rel_o2nofp.cz12a_c8r32
0.000	34.367	65.631	0.003	0.000	0.000	0.000	0.000	0.000	0.000	0.004	my5744_rel_o2nofp.cz12a_c8r32
0.000	0.000	99.050	0.950	0.000	0.000	0.000	0.000	0.000	0.000	0.013	my8043_rel_o2nofp.cz12a_c8r32
0.000	0.000	99.039	0.961	0.000	0.000	0.000	0.000	0.000	0.000	0.012	my8044_rel_o2nofp.cz12a_c8r32
0.000	0.000	99.072	0.919	0.008	0.000	0.000	0.000	0.000	0.000	0.040	my8406_rel_o2nofp.cz12a_c8r32
0.000	0.000	99.031	0.961	0.008	0.000	0.000	0.000	0.000	0.000	0.042	my8407_rel_o2nofp.cz12a_c8r32
0.000	0.000	99.969	0.028	0.003	0.000	0.000	0.000	0.000	0.000	0.028	my8407_rel_o2nofp.cz12a_dw0_c8r32
0.000	0.000	99.072	0.925	0.003	0.000	0.000	0.000	0.000	0.000	0.041	my9400_rel_o2nofp.cz12a_c8r32
0.000	0.000	99.042	0.956	0.003	0.000	0.000	0.000	0.000	0.000	0.040	my9500_rel_o2nofp.cz12a_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	33.461	61.822	4.708	0.008	0.000	0.000	0.000	0.000	0.000	0.016	my5651_rel_o2nofp.cz12a_c8r32
0.000	92.050	7.950	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	my5744_rel_o2nofp.cz12a_c8r32
0.000	79.328	19.733	0.939	0.000	0.000	0.000	0.000	0.000	0.000	0.012	my8043_rel_o2nofp.cz12a_c8r32
0.000	86.808	12.236	0.956	0.000	0.000	0.000	0.000	0.000	0.000	0.012	my8044_rel_o2nofp.cz12a_c8r32
0.000	86.606	12.658	0.728	0.008	0.000	0.000	0.000	0.000	0.000	0.042	my8406_rel_o2nofp.cz12a_c8r32
0.000	80.222	18.817	0.953	0.008	0.000	0.000	0.000	0.000	0.000	0.045	my8407_rel_o2nofp.cz12a_c8r32
0.000	85.331	14.661	0.008	0.000	0.000	0.000	0.000	0.000	0.000	0.012	my8407_rel_o2nofp.cz12a_dw0_c8r32
0.000	85.175	13.906	0.917	0.003	0.000	0.000	0.000	0.000	0.000	0.038	my9400_rel_o2nofp.cz12a_c8r32
0.000	89.928	9.119	0.950	0.003	0.000	0.000	0.000	0.000	0.000	0.037	my9500_rel_o2nofp.cz12a_c8r32