Overview

This document contains the results of testing RMB connection caching implementation. Ticket: PERF-815

PERF-815 - Getting issue details... STATUS

Summary

Compares results of Base Line test(DB_MAXPOOLSIZE=20), Test №1(mod-inventory-storage=40) and Test №2(mod-inventory-storage=40 plus mod-circulation-storage=40) show that shared pool feature leads to performance degradation.
The CI/CO response time for Test №3 and Test №3 RERUN (mod-invetory-storage=2500, mod-circulation-storage=500) is lower, and it has a higher number of database connections compared to the previous test run. These results indicate an improvement in performance attributed to the MAXSHAREDPOOLSIZE parameter.
Almost all tests involving data import are experiencing errors due to database connection timeouts. More details about errors in the Discussion section.
During the comparison test between DB_MAXSHAREDPOOLSIZE = 70 and DB_MAXSHAREDPOOLSIZE = 40, we observed a significant decrease in response time, and importantly, all 15 data imports were successful.
When comparing tests with data import for 30 tenants, the test with DB_MAXSHAREDPOOLSIZE=280 stands out. It demonstrates the stable response time and, crucially, successful data import for all 30 tenants.
All tests have Check-In errors for tenant 8, looks like a problem with data preparation for 8 tenant.
For test №7, 8 and 10 we observe different count of tenants used for data import, but was set 61.

Test Runs

Test №	Date (UA time zone)	Test Conditions	Results
Baseline Test	2/29/2024, 12:47:18 PM	DB_MAXPOOLSIZE=20 for list of modules CICO=8 users, Data Import=25K for ONE tenant	Completed
1	03.08.2024 13:34:08	mod-inventory-storage DB_MAXSHAREDPOOLSIZE=40 (per task, 2 tasks = 80 connections total) other modules DB_MAXPOOLSIZE=20 CICO=8 users, Data Import=25K for ONE tenant	Completed
2	03.08.2024 15:23:46	mod-inventory-storage DB_MAXSHAREDPOOLSIZE=40 (per task, 2 tasks = 80 connections total) mod-circulation-storage DB_MAXSHAREDPOOLSIZE=40 others modules DB_MAXPOOLSIZE=20 CICO=8 users, Data Import=25K for ONE tenant	Completed
3	3/9/2024, 4:35:33 PM (UA) 3/9/2024, 1:35:33 PM (UTC)	mod-inventory-storage DB_MAXSHAREDPOOLSIZE=2500 mod-circulation-storage DB_MAXSHAREDPOOLSIZE=500 others modules DB_MAXPOOLSIZE=20 CICO=305 users for 61 tenants	Completed
3 RERUN	4/2/2024, 4:30:01 PM	mod-inventory-storage DB_MAXSHAREDPOOLSIZE=2500 mod-circulation-storage DB_MAXSHAREDPOOLSIZE=500 others modules DB_MAXPOOLSIZE=20 CICO=305 users for 61 tenants	Completed
4	3/11/2024, 5:50:25 PM	mod-inventory-storage DB_MAXSHAREDPOOLSIZE=2500 mod-circulation-storage DB_MAXSHAREDPOOLSIZE=500 Others modules DB_MAXPOOLSIZE=20 CICO=305 users for 61 tenants, Data Import=10K for 15 tenants	Completed
5	3/12/2024, 12:03:05 PM	DB_MAXSHAREDPOOLSIZE=40 CICO=305 users for 61 tenants, Data Import=10K for 15 tenants	Failed Data Import
6	3/12/2024, 14:03:50	DB_MAXSHAREDPOOLSIZE=70 CICO=305 users for 61 tenants, Data Import=10K for 15 tenants	Completed
7	3/12/2024, 20:23:01	DB_MAXSHAREDPOOLSIZE=140 CICO=305 users for 61 tenants(56), Data Import=10K for 30 tenants	Completed
8	3/13/2024, 7:46:49 PM	DB_MAXSHAREDPOOLSIZE=210 CICO=305 users for 61 tenants(48), Data Import=10K for 30 tenants	Completed
9	3/14/2024, 12:47:15 PM	DB_MAXSHAREDPOOLSIZE=210 for mod-invetory-storage DB_MAXSHAREDPOOLSIZE=70 for others CICO=305 users for 61 tenants, Data Import=10K for 30 tenants	Completed
10	3/15/2024, 11:42:14 AM	DB_MAXSHAREDPOOLSIZE=210 for mod-invetory-storage DB_MAXSHAREDPOOLSIZE=140 for others CICO=305 users for 61 tenants(41), Data Import=10K for 30 tenants	Completed
11	3/15/2024, 3:19:02 PM	DB_MAXSHAREDPOOLSIZE=280 CICO=305 users for 61 tenants, Data Import=10K for 30 tenants	Completed

Test Results

Baseline Test

DB_MAXPOOLSIZE=20 parameter for list of modules.

Requests	Total per tenant	50th pct	75th pct	95th pct	99th pct	Average	CICO Error
CICO_TC_Check-In	219	0.526	0.65	0.755	0.886	0.573	0
CICO_TC_Check-Out	195	0.999	1.217	1.451	1.566	1.093	0

Full Check-In/Check-Out result table

Requests	Total	OK	KO	% KO	Req/s	Min	50th pct	75th pct	95th pct	99th pct	Max	Average	Latency
CICO_TC_Check-Out Controller_mob01	195	195	0	0	0.11	0.888	0.999	1.217	1.451	1.566	1.66	1.093	1.343
CICO_TC_Check-In Controller_mob01	219	219	0	0	0.122	0.457	0.526	0.65	0.755	0.886	1.142	0.573	0.692

Test №1

DB_MAXSHAREDPOOLSIZE=40 for mod-inventory-storage and DB_MAXPOOLSIZE=20 parameter for others modules

Requests	Total per tenant	50th pct	75th pct	95th pct	99th pct	Average	CICO Error
CICO_TC_Check-In	207	0.543	0.616	0.79	0.95	0.595	0
CICO_TC_Check-Out	207	1.036	1.204	1.484	1.611	1.121	0

Full Check-In/Check-Out result table

Requests	Total	OK	KO	% KO	Req/s	Min	50th pct	75th pct	95th pct	99th pct	Max	Average	Latency
CICO_TC_Check-In Controller_mob04	207	207	0	0	0.116	0.466	0.543	0.616	0.79	0.95	2.549	0.595	0.717
CICO_TC_Check-Out Controller_mob04	202	202	0	0	0.113	0.914	1.036	1.204	1.484	1.611	2.28	1.121	1.386

Test №2

DB_MAXSHAREDPOOLSIZE=40 for mod-inventory-storage and mod-circulation-storage plus DB_MAXPOOLSIZE=20 parameter for others modules

Requests	Total per tenant	50th pct	75th pct	95th pct	99th pct	Average	CICO Error
CICO_TC_Check-In	201	0.557	0.716	1.62	3.863	0.786	0
CICO_TC_Check-Out	205	1.047	1.326	2.738	8.324	1.461	0

Full Check-In/Check-Out result table

Requests	Total	OK	KO	% KO	Req/s	Min	50th pct	75th pct	95th pct	99th pct	Max	Average	Latency
CICO_TC_Check-In Controller_mob06	201	201	0	0	0.115	0.456	0.557	0.716	1.62	3.863	14.514	0.786	1.554
CICO_TC_Check-Out Controller_mob06	205	205	0	0	0.114	0.935	1.047	1.326	2.738	8.324	15.516	1.461	2.639

Test №3

DB_MAXSHAREDPOOLSIZE=2500 for mod-invetory-storage, DB_MAXSHAREDPOOLSIZE=140 for mod-circulation-storage and for others modules DB_MAXPOOLSIZE=20 (without Data Import).

Requests	Total per tenant	50th pct	75th pct	95th pct	99th pct	Average	CICO Error
CICO_TC_Check-In	118	0.568	0.615	0.864	3.736	0.694	0
CICO_TC_Check-Out	119	1.075	1.174	2.987	6.151	1.348	0

Full Check-In/Check-Out result table

Requests	Total	OK	KO	% KO	Req/s	Min	50th pct	75th pct	95th pct	99th pct	Max	Average	Latency
CICO_TC_Check-In Controller_fs00001137	125	125	0	0	0.074	0.496	0.831	0.962	1.395	2.51	5.904	0.921	1.323
CICO_TC_Check-In Controller_mob01	112	112	0	0	0.064	0.482	0.568	0.597	0.725	1.136	6.567	0.641	0.647
CICO_TC_Check-In Controller_mob010	111	111	0	0	0.063	0.473	0.564	0.6	0.878	5.103	5.955	0.746	0.806
CICO_TC_Check-In Controller_mob011	122	122	0	0	0.07	0.477	0.571	0.641	0.875	3.595	3.757	0.668	0.802
CICO_TC_Check-In Controller_mob012	113	113	0	0	0.068	0.466	0.563	0.611	0.852	4.745	6.061	0.716	0.785
CICO_TC_Check-In Controller_mob013	108	108	0	0	0.062	0.473	0.561	0.601	0.97	4.387	8.897	0.765	0.899
CICO_TC_Check-In Controller_mob014	108	108	0	0	0.063	0.489	0.571	0.611	1.031	3.784	5.397	0.689	0.766
CICO_TC_Check-In Controller_mob015	109	109	0	0	0.064	0.466	0.564	0.62	1.049	6.009	9.754	0.796	0.971
CICO_TC_Check-In Controller_mob016	111	111	0	0	0.063	0.473	0.563	0.61	0.809	4.105	8.655	0.745	0.745
CICO_TC_Check-In Controller_mob017	122	122	0	0	0.071	0.415	0.468	0.51	0.881	4.478	7.787	0.667	0.811
CICO_TC_Check-In Controller_mob018	119	119	0	0	0.069	0.49	0.561	0.612	0.804	5.665	8.938	0.723	0.729
CICO_TC_Check-In Controller_mob019	103	103	0	0	0.058	0.492	0.57	0.619	0.768	2.903	9.381	0.703	0.697
CICO_TC_Check-In Controller_mob02	122	122	0	0	0.071	0.486	0.575	0.628	0.947	6.241	8.528	0.748	0.856
CICO_TC_Check-In Controller_mob020	115	115	0	0	0.068	0.476	0.569	0.616	0.874	3.922	5.33	0.714	0.763
CICO_TC_Check-In Controller_mob021	125	125	0	0	0.07	0.474	0.563	0.603	1.078	4.937	9.798	0.733	1.025
CICO_TC_Check-In Controller_mob022	117	117	0	0	0.067	0.485	0.571	0.602	0.886	5.149	9.272	0.755	0.809
CICO_TC_Check-In Controller_mob023	134	134	0	0	0.077	0.483	0.561	0.605	0.777	3.896	9.635	0.676	0.708
CICO_TC_Check-In Controller_mob024	133	133	0	0	0.075	0.48	0.566	0.605	0.676	3.134	3.761	0.619	0.601
CICO_TC_Check-In Controller_mob025	131	131	0	0	0.077	0.481	0.561	0.605	0.867	4.928	9.46	0.792	0.787
CICO_TC_Check-In Controller_mob026	111	111	0	0	0.063	0.49	0.568	0.612	0.795	1.816	4.749	0.641	0.68
CICO_TC_Check-In Controller_mob027	123	123	0	0	0.069	0.471	0.559	0.598	0.854	3.039	3.515	0.645	0.769
CICO_TC_Check-In Controller_mob028	122	122	0	0	0.069	0.491	0.567	0.611	0.828	2.467	4.838	0.645	0.762
CICO_TC_Check-In Controller_mob029	125	125	0	0	0.071	0.499	0.572	0.602	0.761	3.423	9.32	0.692	0.691
CICO_TC_Check-In Controller_mob03	122	122	0	0	0.072	0.485	0.565	0.634	0.926	6.547	9.082	0.757	0.824
CICO_TC_Check-In Controller_mob030	118	118	0	0	0.071	0.483	0.572	0.617	0.891	4.924	9.077	0.72	0.825
CICO_TC_Check-In Controller_mob031	114	114	0	0	0.067	0.47	0.569	0.609	0.698	0.837	0.885	0.578	0.62
CICO_TC_Check-In Controller_mob032	125	125	0	0	0.071	0.502	0.571	0.608	0.833	3.869	9.7	0.747	0.768
CICO_TC_Check-In Controller_mob033	108	108	0	0	0.061	0.473	0.568	0.62	0.846	3.107	9.166	0.712	0.77
CICO_TC_Check-In Controller_mob034	127	127	0	0	0.074	0.466	0.565	0.594	1.05	3.846	8.713	0.703	0.98
CICO_TC_Check-In Controller_mob035	119	119	0	0	0.067	0.483	0.562	0.599	0.763	2.668	4.495	0.632	0.696
CICO_TC_Check-In Controller_mob036	125	125	0	0	0.072	0.481	0.554	0.595	0.86	4.701	8.947	0.713	0.793
CICO_TC_Check-In Controller_mob037	102	102	0	0	0.06	0.483	0.571	0.623	0.937	2.82	3.256	0.656	0.873
CICO_TC_Check-In Controller_mob038	114	114	0	0	0.066	0.484	0.56	0.6	0.815	1.038	8.861	0.659	0.653
CICO_TC_Check-In Controller_mob039	115	115	0	0	0.066	0.482	0.558	0.609	0.732	2.6	8.989	0.7	0.671
CICO_TC_Check-In Controller_mob04	109	109	0	0	0.061	0.485	0.568	0.617	0.759	3.567	5.42	0.662	0.689
CICO_TC_Check-In Controller_mob040	123	123	0	0	0.072	0.486	0.561	0.603	0.786	3.396	8.996	0.679	0.709
CICO_TC_Check-In Controller_mob041	113	113	0	0	0.064	0.489	0.563	0.597	0.754	3.744	4.888	0.671	0.694
CICO_TC_Check-In Controller_mob042	120	120	0	0	0.068	0.488	0.564	0.6	0.783	2.839	4.494	0.641	0.687
CICO_TC_Check-In Controller_mob043	107	107	0	0	0.062	0.487	0.569	0.615	1.111	4.858	8.229	0.755	1.04
CICO_TC_Check-In Controller_mob044	125	125	0	0	0.071	0.485	0.566	0.61	0.792	3.794	8.144	0.686	0.721
CICO_TC_Check-In Controller_mob045	115	115	0	0	0.066	0.483	0.564	0.614	0.798	4.857	10.206	0.757	0.735
CICO_TC_Check-In Controller_mob046	120	120	0	0	0.069	0.471	0.56	0.609	0.812	3.622	4.886	0.672	0.735
CICO_TC_Check-In Controller_mob047	114	114	0	0	0.065	0.474	0.567	0.619	0.698	1.219	2.346	0.606	0.628
CICO_TC_Check-In Controller_mob048	113	113	0	0	0.066	0.49	0.574	0.623	0.874	4.412	5.812	0.695	0.806
CICO_TC_Check-In Controller_mob049	114	114	0	0	0.065	0.464	0.561	0.626	0.827	4.554	4.91	0.705	0.759
CICO_TC_Check-In Controller_mob05	124	124	0	0	0.071	0.487	0.571	0.62	0.935	3.974	5.907	0.692	0.838
CICO_TC_Check-In Controller_mob050	114	114	0	0	0.067	0.475	0.575	0.619	0.778	3.873	4.27	0.659	0.697
CICO_TC_Check-In Controller_mob051	132	132	0	0	0.078	0.486	0.555	0.607	0.811	4.746	8.19	0.691	0.745
CICO_TC_Check-In Controller_mob052	126	126	0	0	0.072	0.475	0.563	0.624	0.977	4.096	8.296	0.698	0.903
CICO_TC_Check-In Controller_mob053	119	119	0	0	0.068	0.473	0.559	0.605	0.864	2.658	4.457	0.664	0.794
CICO_TC_Check-In Controller_mob054	120	120	0	0	0.07	0.471	0.561	0.611	0.997	3.625	5.14	0.679	0.722
CICO_TC_Check-In Controller_mob055	123	123	0	0	0.071	0.488	0.568	0.612	0.817	1.295	5.675	0.638	0.734
CICO_TC_Check-In Controller_mob056	130	130	0	0	0.074	0.47	0.56	0.613	0.882	4.242	7.045	0.688	0.808
CICO_TC_Check-In Controller_mob057	122	122	0	0	0.07	0.488	0.56	0.603	0.726	3.022	6.578	0.652	0.654
CICO_TC_Check-In Controller_mob058	118	118	0	0	0.069	0.481	0.559	0.612	0.904	4.217	7.095	0.696	0.822
CICO_TC_Check-In Controller_mob059	125	125	0	0	0.073	0.475	0.563	0.622	1.067	3.018	7.089	0.684	1
CICO_TC_Check-In Controller_mob06	124	124	0	0	0.069	0.477	0.567	0.598	0.876	3.341	4.506	0.643	0.762
CICO_TC_Check-In Controller_mob060	106	106	0	0	0.06	0.486	0.566	0.604	0.761	2.892	4.03	0.639	0.687
CICO_TC_Check-In Controller_mob07	122	122	0	0	0.068	0.472	0.561	0.598	0.884	5.578	10.33	0.724	0.8
CICO_TC_Check-In Controller_mob08	120	0	120	100	0	0.477	0.545	0.602	0.847	4.098	5.754	0.651	0.727
CICO_TC_Check-In Controller_mob09	119	119	0	0	0.071	0.48	0.574	0.621	0.863	4.017	5.802	0.681	0.793
CICO_TC_Check-Out Controller_fs00001137	111	111	0	0	0.063	0.957	1.664	1.912	3.419	6.5	11.092	1.911	3.27
CICO_TC_Check-Out Controller_mob01	126	126	0	0	0.074	0.922	1.091	1.15	4.623	7.37	8.489	1.419	4.518
CICO_TC_Check-Out Controller_mob010	127	127	0	0	0.074	0.888	1.067	1.164	2.826	7.063	10.79	1.317	2.724
CICO_TC_Check-Out Controller_mob011	115	115	0	0	0.064	0.918	1.067	1.179	1.862	5.884	6.219	1.311	1.752
CICO_TC_Check-Out Controller_mob012	125	125	0	0	0.07	0.925	1.051	1.145	3.431	4.67	6.906	1.322	3.337
CICO_TC_Check-Out Controller_mob013	129	129	0	0	0.072	0.933	1.065	1.133	4.185	7.536	10.717	1.379	4.097
CICO_TC_Check-Out Controller_mob014	129	129	0	0	0.072	0.945	1.066	1.139	4.155	6.401	6.883	1.322	4.053
CICO_TC_Check-Out Controller_mob015	129	129	0	0	0.072	0.896	1.063	1.147	3.047	7.123	8.096	1.333	2.946
CICO_TC_Check-Out Controller_mob016	126	126	0	0	0.072	0.914	1.067	1.169	3.933	6.036	10.539	1.38	3.847
CICO_TC_Check-Out Controller_mob017	117	117	0	0	0.065	0.803	0.931	1.024	1.819	6.084	10.502	1.204	1.705
CICO_TC_Check-Out Controller_mob018	118	118	0	0	0.066	0.938	1.062	1.146	1.821	5.382	9.885	1.278	1.721
CICO_TC_Check-Out Controller_mob019	135	135	0	0	0.077	0.924	1.057	1.146	2.31	5.444	10.784	1.285	2.201
CICO_TC_Check-Out Controller_mob02	115	115	0	0	0.066	0.917	1.086	1.165	4.211	5.829	10.573	1.448	4.101
CICO_TC_Check-Out Controller_mob020	122	122	0	0	0.069	0.921	1.08	1.192	4.032	7.325	11.279	1.434	3.934
CICO_TC_Check-Out Controller_mob021	113	113	0	0	0.065	0.921	1.058	1.186	2.741	6.901	10.735	1.381	2.639
CICO_TC_Check-Out Controller_mob022	120	120	0	0	0.071	0.908	1.06	1.145	2.79	7.796	10.565	1.345	2.691
CICO_TC_Check-Out Controller_mob023	105	105	0	0	0.059	0.928	1.068	1.174	1.782	3.408	4.037	1.19	1.673
CICO_TC_Check-Out Controller_mob024	106	106	0	0	0.062	0.938	1.061	1.156	1.604	3.529	5.009	1.184	1.51
CICO_TC_Check-Out Controller_mob025	108	108	0	0	0.061	0.926	1.08	1.163	2.644	4.885	5.818	1.283	2.537
CICO_TC_Check-Out Controller_mob026	127	127	0	0	0.073	0.952	1.063	1.146	3.761	4.494	4.896	1.304	3.665
CICO_TC_Check-Out Controller_mob027	116	116	0	0	0.067	0.929	1.073	1.161	3.737	4.826	5.333	1.326	3.649
CICO_TC_Check-Out Controller_mob028	117	117	0	0	0.067	0.931	1.067	1.214	1.695	5.638	9.992	1.317	1.598
CICO_TC_Check-Out Controller_mob029	113	113	0	0	0.065	0.944	1.084	1.183	3.116	7.288	10.823	1.376	3.022
CICO_TC_Check-Out Controller_mob03	116	116	0	0	0.065	0.912	1.073	1.174	1.906	6.381	6.97	1.293	1.788
CICO_TC_Check-Out Controller_mob030	119	119	0	0	0.067	0.914	1.059	1.156	2.974	8.204	10.013	1.347	2.827
CICO_TC_Check-Out Controller_mob031	123	123	0	0	0.07	0.922	1.056	1.119	3.302	4.492	4.974	1.242	3.205
CICO_TC_Check-Out Controller_mob032	113	113	0	0	0.065	0.91	1.056	1.148	1.732	8.568	10.335	1.369	1.619
CICO_TC_Check-Out Controller_mob033	130	130	0	0	0.076	0.928	1.048	1.104	1.687	5.09	6.389	1.204	1.594
CICO_TC_Check-Out Controller_mob034	110	110	0	0	0.062	0.889	1.062	1.169	2.887	5.151	8.606	1.311	2.799
CICO_TC_Check-Out Controller_mob035	119	119	0	0	0.069	0.93	1.076	1.153	3.42	6.052	9.558	1.411	3.32
CICO_TC_Check-Out Controller_mob036	113	113	0	0	0.064	0.921	1.065	1.149	3.121	6.906	10.924	1.405	3.02
CICO_TC_Check-Out Controller_mob037	135	135	0	0	0.076	0.916	1.05	1.165	3.066	5.676	5.695	1.289	2.974
CICO_TC_Check-Out Controller_mob038	124	124	0	0	0.071	0.885	1.079	1.162	3.745	6.006	7.831	1.411	3.647
CICO_TC_Check-Out Controller_mob039	122	122	0	0	0.071	0.91	1.052	1.194	4.166	5.892	7.893	1.394	4.072
CICO_TC_Check-Out Controller_mob04	129	129	0	0	0.076	0.918	1.052	1.135	3.63	7.991	8.737	1.38	3.532
CICO_TC_Check-Out Controller_mob040	116	116	0	0	0.066	0.94	1.091	1.178	3.222	7.734	10.272	1.45	3.134
CICO_TC_Check-Out Controller_mob041	125	125	0	0	0.072	0.921	1.065	1.176	3.021	4.705	6.57	1.287	2.926
CICO_TC_Check-Out Controller_mob042	117	117	0	0	0.069	0.921	1.062	1.189	3.91	7.968	10.206	1.467	3.809
CICO_TC_Check-Out Controller_mob043	130	130	0	0	0.075	0.929	1.04	1.154	1.545	5.435	7.215	1.23	1.438
CICO_TC_Check-Out Controller_mob044	113	113	0	0	0.067	0.935	1.082	1.161	2.599	4.839	7.135	1.287	2.49
CICO_TC_Check-Out Controller_mob045	122	122	0	0	0.071	0.913	1.051	1.123	3.256	4.908	9.826	1.289	3.15
CICO_TC_Check-Out Controller_mob046	117	117	0	0	0.07	0.944	1.069	1.208	3.28	7.407	8.567	1.424	3.181
CICO_TC_Check-Out Controller_mob047	123	123	0	0	0.071	0.905	1.063	1.196	2.59	5	5.533	1.286	2.475
CICO_TC_Check-Out Controller_mob048	125	125	0	0	0.071	0.95	1.061	1.165	1.94	7.816	10.301	1.321	1.829
CICO_TC_Check-Out Controller_mob049	122	122	0	0	0.072	0.905	1.079	1.131	2.981	5.465	7.664	1.347	2.87
CICO_TC_Check-Out Controller_mob05	114	114	0	0	0.064	0.922	1.074	1.151	1.879	4.469	6.606	1.273	1.76
CICO_TC_Check-Out Controller_mob050	125	125	0	0	0.072	0.943	1.075	1.182	3.518	7.469	10.693	1.456	3.39
CICO_TC_Check-Out Controller_mob051	105	105	0	0	0.06	0.943	1.072	1.131	1.469	4.802	4.804	1.195	1.374
CICO_TC_Check-Out Controller_mob052	112	112	0	0	0.065	0.902	1.052	1.14	1.435	2.731	3.91	1.149	1.325
CICO_TC_Check-Out Controller_mob053	119	119	0	0	0.07	0.941	1.072	1.174	3.165	5.364	9.303	1.327	3.062
CICO_TC_Check-Out Controller_mob054	118	118	0	0	0.067	0.923	1.075	1.17	4.397	10.142	10.171	1.521	4.308
CICO_TC_Check-Out Controller_mob055	114	114	0	0	0.067	0.931	1.079	1.246	4.393	6.747	9.513	1.476	4.286
CICO_TC_Check-Out Controller_mob056	108	108	0	0	0.064	0.922	1.047	1.156	2.062	5.475	7.582	1.275	1.956
CICO_TC_Check-Out Controller_mob057	116	116	0	0	0.068	0.935	1.083	1.184	4.183	5.327	7.533	1.376	4.086
CICO_TC_Check-Out Controller_mob058	119	119	0	0	0.068	0.917	1.079	1.185	3.288	6.982	7.996	1.347	3.194
CICO_TC_Check-Out Controller_mob059	112	112	0	0	0.064	0.905	1.067	1.178	1.806	7.395	8.552	1.335	1.715
CICO_TC_Check-Out Controller_mob06	114	114	0	0	0.066	0.929	1.085	1.185	4.876	7.068	11.287	1.555	4.784
CICO_TC_Check-Out Controller_mob060	132	132	0	0	0.077	0.931	1.079	1.175	3.392	6.887	9.514	1.367	3.291
CICO_TC_Check-Out Controller_mob07	117	117	0	0	0.068	0.928	1.062	1.143	2.836	6.444	11.76	1.371	2.735
CICO_TC_Check-Out Controller_mob08	118	118	0	0	0.066	0.911	1.063	1.134	3.054	5.586	8.291	1.309	2.949
CICO_TC_Check-Out Controller_mob09	120	120	0	0	0.067	0.925	1.067	1.205	2.912	7.215	10.782	1.382	2.792

Test №3 RERUN

DB_MAXSHAREDPOOLSIZE=2500 for mod-invetory-storage, DB_MAXSHAREDPOOLSIZE=140 for mod-circulation-storage and for others modules DB_MAXPOOLSIZE=20 (without Data Import).

Requests	Total per tenant	50th pct	75th pct	95th pct	99th pct	Average	CICO Error
CICO_TC_Check-In	120	0.563	0.605	0.921	4.494	0.719	0
CICO_TC_Check-Out	118	1.055	1.137	2.946	6.732	1.341	1

Full Check-In/Check-Out result table

Requests	Total	OK	KO	% KO	Req/s	Min	50th pct	75th pct	95th pct	99th pct	Max	Average	Latency
CICO_TC_Check-In Controller_fs00001137	116	116	0	0	0.067	0.541	0.816	1.009	2.791	5.712	10.721	1.105	2.724
CICO_TC_Check-In Controller_mob01	113	113	0	0	0.065	0.483	0.551	0.585	0.765	0.868	1.523	0.578	0.69
CICO_TC_Check-In Controller_mob010	122	122	0	0	0.068	0.489	0.56	0.61	1.013	5.398	10.291	0.766	0.951
CICO_TC_Check-In Controller_mob011	123	123	0	0	0.071	0.489	0.562	0.611	0.989	4.894	9.865	0.774	0.924
CICO_TC_Check-In Controller_mob012	123	123	0	0	0.069	0.491	0.565	0.596	0.766	5.299	6.011	0.695	0.706
CICO_TC_Check-In Controller_mob013	111	111	0	0	0.062	0.491	0.562	0.596	0.822	3.056	5.632	0.665	0.762
CICO_TC_Check-In Controller_mob014	127	127	0	0	0.071	0.494	0.571	0.604	1.837	5.729	8.88	0.79	1.772
CICO_TC_Check-In Controller_mob015	139	139	0	0	0.081	0.479	0.557	0.603	0.863	5.983	8.689	0.719	0.771
CICO_TC_Check-In Controller_mob016	113	113	0	0	0.065	0.483	0.567	0.613	0.747	1.933	2.562	0.615	0.682
CICO_TC_Check-In Controller_mob017	121	121	0	0	0.071	0.478	0.56	0.602	0.812	4.134	9.639	0.699	0.755
CICO_TC_Check-In Controller_mob018	116	116	0	0	0.069	0.493	0.561	0.594	0.829	4.59	5.887	0.682	0.752
CICO_TC_Check-In Controller_mob019	125	125	0	0	0.072	0.477	0.561	0.594	0.903	3.049	6.808	0.689	0.84
CICO_TC_Check-In Controller_mob02	122	122	0	0	0.07	0.488	0.559	0.602	0.994	4.302	4.87	0.695	0.841
CICO_TC_Check-In Controller_mob020	132	132	0	0	0.076	0.462	0.55	0.587	0.862	7.527	8.361	0.749	0.805
CICO_TC_Check-In Controller_mob021	129	129	0	0	0.072	0.484	0.556	0.592	0.715	3.165	11.934	0.711	0.651
CICO_TC_Check-In Controller_mob022	111	111	0	0	0.064	0.485	0.565	0.602	0.713	1.043	2.229	0.596	0.635
CICO_TC_Check-In Controller_mob023	115	115	0	0	0.068	0.476	0.556	0.592	0.915	2.483	5.608	0.654	0.855
CICO_TC_Check-In Controller_mob024	114	114	0	0	0.065	0.487	0.549	0.594	0.944	5.588	7.352	0.748	0.874
CICO_TC_Check-In Controller_mob025	115	115	0	0	0.065	0.478	0.567	0.606	0.857	5.36	7.627	0.711	0.787
CICO_TC_Check-In Controller_mob026	127	127	0	0	0.076	0.484	0.553	0.595	0.932	5.155	8.015	0.725	0.821
CICO_TC_Check-In Controller_mob027	108	108	0	0	0.062	0.49	0.568	0.605	0.907	5.413	5.814	0.702	0.845
CICO_TC_Check-In Controller_mob028	111	111	0	0	0.064	0.491	0.565	0.599	0.971	5.77	7.923	0.756	0.91
CICO_TC_Check-In Controller_mob029	137	137	0	0	0.077	0.474	0.559	0.597	0.852	7.007	9.945	0.753	0.788
CICO_TC_Check-In Controller_mob03	120	120	0	0	0.07	0.488	0.552	0.587	0.85	4.429	10.258	0.743	0.792
CICO_TC_Check-In Controller_mob030	115	115	0	0	0.065	0.485	0.567	0.618	1.16	5.087	12.202	0.798	1.094
CICO_TC_Check-In Controller_mob031	127	127	0	0	0.074	0.488	0.552	0.597	0.933	1.859	5.665	0.641	0.843
CICO_TC_Check-In Controller_mob032	117	117	0	0	0.066	0.489	0.562	0.613	0.919	6.644	10.157	0.748	0.856
CICO_TC_Check-In Controller_mob033	113	113	0	0	0.065	0.478	0.563	0.599	0.845	2.145	6.106	0.648	0.779
CICO_TC_Check-In Controller_mob034	112	112	0	0	0.063	0.465	0.554	0.591	1.109	6.804	11.134	0.816	1.037
CICO_TC_Check-In Controller_mob035	111	111	0	0	0.064	0.474	0.557	0.602	0.766	3.941	10.86	0.724	0.713
CICO_TC_Check-In Controller_mob036	123	123	0	0	0.071	0.477	0.561	0.595	0.979	6.364	7.414	0.753	0.905
CICO_TC_Check-In Controller_mob037	124	124	0	0	0.07	0.477	0.553	0.592	0.999	5.241	6.292	0.714	0.921
CICO_TC_Check-In Controller_mob038	121	121	0	0	0.071	0.471	0.564	0.597	0.796	2.953	5.653	0.66	0.725
CICO_TC_Check-In Controller_mob039	114	114	0	0	0.064	0.47	0.564	0.62	0.885	7.179	10.445	0.781	0.707
CICO_TC_Check-In Controller_mob04	115	115	0	0	0.067	0.509	0.567	0.601	0.731	3.432	3.926	0.658	0.665
CICO_TC_Check-In Controller_mob040	122	122	0	0	0.069	0.477	0.554	0.587	0.788	4.036	5.65	0.664	0.722
CICO_TC_Check-In Controller_mob041	113	113	0	0	0.066	0.483	0.564	0.609	0.907	4.889	7.668	0.741	0.824
CICO_TC_Check-In Controller_mob042	122	122	0	0	0.069	0.491	0.565	0.608	0.808	5.155	11.006	0.782	0.742
CICO_TC_Check-In Controller_mob043	121	121	0	0	0.072	0.493	0.557	0.597	0.801	5.295	7.098	0.713	0.741
CICO_TC_Check-In Controller_mob044	116	116	0	0	0.067	0.501	0.569	0.614	0.829	4.874	10.502	0.756	0.766
CICO_TC_Check-In Controller_mob045	119	119	0	0	0.069	0.469	0.556	0.599	0.921	6.383	10.514	0.832	0.857
CICO_TC_Check-In Controller_mob046	110	110	0	0	0.062	0.48	0.567	0.597	0.76	5.046	10.457	0.74	0.692
CICO_TC_Check-In Controller_mob047	110	110	0	0	0.069	0.486	0.548	0.592	0.894	5.149	10.738	0.784	0.821
CICO_TC_Check-In Controller_mob048	123	123	0	0	0.07	0.485	0.555	0.587	1.023	5.593	10.67	0.779	0.955
CICO_TC_Check-In Controller_mob049	118	118	0	0	0.067	0.48	0.554	0.592	0.758	4.358	10.521	0.687	0.694
CICO_TC_Check-In Controller_mob05	131	131	0	0	0.075	0.479	0.555	0.593	0.689	4.354	10.027	0.719	0.623
CICO_TC_Check-In Controller_mob050	127	127	0	0	0.075	0.487	0.552	0.589	0.796	4.97	5.075	0.712	0.739
CICO_TC_Check-In Controller_mob051	126	126	0	0	0.073	0.483	0.562	0.598	1.535	5.576	11.329	0.838	1.471
CICO_TC_Check-In Controller_mob052	128	128	0	0	0.073	0.486	0.554	0.598	0.77	4.18	5.227	0.644	0.712
CICO_TC_Check-In Controller_mob053	123	123	0	0	0.072	0.481	0.549	0.586	0.785	1.33	2.973	0.596	0.725
CICO_TC_Check-In Controller_mob054	116	116	0	0	0.066	0.479	0.566	0.608	0.776	4.615	10.766	0.723	0.685
CICO_TC_Check-In Controller_mob055	139	139	0	0	0.08	0.492	0.553	0.602	0.866	5.179	10.44	0.765	0.81
CICO_TC_Check-In Controller_mob056	123	123	0	0	0.072	0.475	0.56	0.595	0.801	3.997	10.637	0.739	0.734
CICO_TC_Check-In Controller_mob057	126	126	0	0	0.072	0.485	0.554	0.583	0.862	4.884	4.952	0.669	0.799
CICO_TC_Check-In Controller_mob058	115	115	0	0	0.066	0.479	0.56	0.596	0.836	4.849	10.424	0.744	0.763
CICO_TC_Check-In Controller_mob059	122	122	0	0	0.071	0.482	0.553	0.619	1.117	4.455	6.354	0.74	1.056
CICO_TC_Check-In Controller_mob06	117	117	0	0	0.068	0.494	0.565	0.593	0.848	1.605	3.195	0.614	0.781
CICO_TC_Check-In Controller_mob060	103	103	0	0	0.062	0.483	0.555	0.599	0.815	2.835	3.952	0.642	0.71
CICO_TC_Check-In Controller_mob07	135	135	0	0	0.076	0.477	0.562	0.597	0.838	3.714	10.023	0.701	0.721
CICO_TC_Check-In Controller_mob08	129	0	129	100	0	0.481	0.539	0.574	0.793	3.756	4.253	0.628	0.722
CICO_TC_Check-In Controller_mob09	111	111	0	0	0.065	0.495	0.568	0.607	0.786	3.501	5.317	0.674	0.639
CICO_TC_Check-Out Controller_fs00001137	121	85	36	29.752	0.071	0.704	1.442	1.686	2.746	4.593	8.318	1.618	2.643
CICO_TC_Check-Out Controller_mob01	126	126	0	0	0.072	0.913	1.03	1.125	3.396	7.194	7.877	1.322	3.305
CICO_TC_Check-Out Controller_mob010	118	118	0	0	0.068	0.92	1.071	1.144	4.881	8.316	8.931	1.553	4.794
CICO_TC_Check-Out Controller_mob011	116	116	0	0	0.065	0.906	1.063	1.155	1.759	5.033	6.17	1.275	1.644
CICO_TC_Check-Out Controller_mob012	115	115	0	0	0.067	0.924	1.061	1.119	4.233	8.669	9.802	1.431	4.134
CICO_TC_Check-Out Controller_mob013	129	129	0	0	0.074	0.902	1.048	1.119	3.845	8.642	9.662	1.366	3.752
CICO_TC_Check-Out Controller_mob014	111	111	0	0	0.064	0.93	1.063	1.133	1.588	4.875	8.127	1.251	1.496
CICO_TC_Check-Out Controller_mob015	99	99	0	0	0.056	0.916	1.072	1.133	3.857	6.812	7.82	1.39	3.768
CICO_TC_Check-Out Controller_mob016	126	126	0	0	0.07	0.9	1.051	1.12	2.455	8.882	9.039	1.373	2.359
CICO_TC_Check-Out Controller_mob017	119	119	0	0	0.067	0.901	1.053	1.129	3.362	9.624	10.145	1.413	3.262
CICO_TC_Check-Out Controller_mob018	121	121	0	0	0.068	0.899	1.049	1.143	4.362	8.98	9.169	1.42	4.267
CICO_TC_Check-Out Controller_mob019	114	114	0	0	0.064	0.93	1.051	1.128	3.014	5.097	10.318	1.329	2.929
CICO_TC_Check-Out Controller_mob02	117	117	0	0	0.07	0.911	1.035	1.18	4.651	9.196	9.498	1.416	4.558
CICO_TC_Check-Out Controller_mob020	105	105	0	0	0.059	0.921	1.052	1.134	2.209	5.674	6.59	1.269	1.949
CICO_TC_Check-Out Controller_mob021	110	110	0	0	0.063	0.905	1.054	1.152	2.348	5.39	11.402	1.323	2.256
CICO_TC_Check-Out Controller_mob022	128	128	0	0	0.072	0.934	1.038	1.13	2.948	6.371	12.689	1.352	2.86
CICO_TC_Check-Out Controller_mob023	122	122	0	0	0.069	0.903	1.048	1.096	1.962	6.562	8.167	1.237	1.867
CICO_TC_Check-Out Controller_mob024	124	124	0	0	0.07	0.933	1.044	1.103	2.389	5.844	8.138	1.277	2.289
CICO_TC_Check-Out Controller_mob025	124	124	0	0	0.075	0.89	1.031	1.1	2.88	7.414	9.116	1.314	2.787
CICO_TC_Check-Out Controller_mob026	110	110	0	0	0.063	0.911	1.069	1.154	4.224	5.524	9.462	1.416	4.137
CICO_TC_Check-Out Controller_mob027	129	129	0	0	0.073	0.911	1.044	1.142	4.597	9.519	11.944	1.436	4.504
CICO_TC_Check-Out Controller_mob028	127	127	0	0	0.071	0.903	1.036	1.105	2.163	5.94	9.675	1.297	2.058
CICO_TC_Check-Out Controller_mob029	101	101	0	0	0.063	0.936	1.076	1.184	2.552	5.855	13.275	1.364	2.445
CICO_TC_Check-Out Controller_mob03	118	118	0	0	0.068	0.91	1.041	1.147	4.811	7.052	8.795	1.44	4.732
CICO_TC_Check-Out Controller_mob030	123	123	0	0	0.072	0.917	1.038	1.12	1.774	7.573	12.567	1.318	1.679
CICO_TC_Check-Out Controller_mob031	111	111	0	0	0.063	0.914	1.05	1.115	1.401	6.865	8.979	1.243	1.293
CICO_TC_Check-Out Controller_mob032	122	122	0	0	0.071	0.909	1.034	1.11	1.638	6.033	12.039	1.24	1.544
CICO_TC_Check-Out Controller_mob033	124	124	0	0	0.071	0.923	1.038	1.115	2.143	8.264	8.374	1.304	2.049
CICO_TC_Check-Out Controller_mob034	128	128	0	0	0.076	0.893	1.032	1.108	3.03	7.644	11.93	1.345	2.927
CICO_TC_Check-Out Controller_mob035	126	126	0	0	0.073	0.875	1.054	1.141	4.601	11.871	13.31	1.565	4.5
CICO_TC_Check-Out Controller_mob036	116	116	0	0	0.067	0.931	1.048	1.108	3.93	6.74	7.594	1.357	3.845
CICO_TC_Check-Out Controller_mob037	114	114	0	0	0.066	0.924	1.034	1.097	1.613	6.031	10.314	1.243	1.505
CICO_TC_Check-Out Controller_mob038	117	117	0	0	0.066	0.892	1.043	1.12	1.968	7.079	11.949	1.353	1.878
CICO_TC_Check-Out Controller_mob039	126	126	0	0	0.074	0.934	1.036	1.1	1.932	6.946	11.735	1.293	1.84
CICO_TC_Check-Out Controller_mob04	123	123	0	0	0.068	0.919	1.07	1.139	3.128	4.769	6.998	1.313	3.031
CICO_TC_Check-Out Controller_mob040	116	116	0	0	0.067	0.91	1.042	1.127	3.379	6.364	6.685	1.334	3.291
CICO_TC_Check-Out Controller_mob041	124	124	0	0	0.07	0.886	1.054	1.146	4.452	7.853	8.142	1.384	4.345
CICO_TC_Check-Out Controller_mob042	116	116	0	0	0.068	0.91	1.06	1.152	3.818	7.578	11.736	1.42	3.717
CICO_TC_Check-Out Controller_mob043	116	116	0	0	0.067	0.901	1.036	1.122	2.463	5.319	6.341	1.297	2.359
CICO_TC_Check-Out Controller_mob044	121	121	0	0	0.069	0.896	1.045	1.13	1.817	6.316	7.916	1.25	1.733
CICO_TC_Check-Out Controller_mob045	118	118	0	0	0.067	0.915	1.042	1.101	1.858	5.54	5.558	1.253	1.754
CICO_TC_Check-Out Controller_mob046	129	129	0	0	0.076	0.887	1.038	1.129	4.147	6.754	10.952	1.398	4.054
CICO_TC_Check-Out Controller_mob047	128	128	0	0	0.073	0.908	1.04	1.099	1.514	4.355	6.491	1.165	1.423
CICO_TC_Check-Out Controller_mob048	115	115	0	0	0.066	0.926	1.046	1.13	3.501	7.069	7.866	1.35	3.412
CICO_TC_Check-Out Controller_mob049	120	120	0	0	0.07	0.909	1.038	1.116	1.838	5.377	5.556	1.266	1.734
CICO_TC_Check-Out Controller_mob05	107	107	0	0	0.06	0.922	1.038	1.126	3.329	6.443	8.87	1.347	3.226
CICO_TC_Check-Out Controller_mob050	111	111	0	0	0.063	0.907	1.033	1.115	1.762	5.599	6.583	1.254	1.661
CICO_TC_Check-Out Controller_mob051	113	113	0	0	0.064	0.931	1.049	1.113	1.509	5.111	7.643	1.24	1.419
CICO_TC_Check-Out Controller_mob052	111	111	0	0	0.064	0.902	1.063	1.139	1.578	8.725	11.892	1.408	1.464
CICO_TC_Check-Out Controller_mob053	115	115	0	0	0.066	0.906	1.054	1.123	1.88	5.346	6.049	1.232	1.778
CICO_TC_Check-Out Controller_mob054	123	123	0	0	0.074	0.914	1.038	1.121	1.707	4.966	5.3	1.178	1.609
CICO_TC_Check-Out Controller_mob055	100	100	0	0	0.057	0.924	1.078	1.151	1.869	5.109	9.959	1.288	1.772
CICO_TC_Check-Out Controller_mob056	116	116	0	0	0.066	0.9	1.049	1.135	1.585	5.635	8.322	1.256	1.494
CICO_TC_Check-Out Controller_mob057	112	112	0	0	0.066	0.911	1.049	1.132	2.893	4.991	9.35	1.337	2.788
CICO_TC_Check-Out Controller_mob058	123	123	0	0	0.071	0.918	1.037	1.122	3.579	5.016	8.627	1.288	3.475
CICO_TC_Check-Out Controller_mob059	116	116	0	0	0.066	0.883	1.052	1.124	4.142	5.847	9.716	1.365	4.049
CICO_TC_Check-Out Controller_mob06	123	123	0	0	0.071	0.909	1.043	1.124	2.82	5.267	6.75	1.279	2.73
CICO_TC_Check-Out Controller_mob060	135	135	0	0	0.077	0.908	1.051	1.123	4.375	5.695	8.366	1.398	4.267
CICO_TC_Check-Out Controller_mob07	103	103	0	0	0.062	0.913	1.05	1.145	4.402	9.579	10.051	1.448	4.313
CICO_TC_Check-Out Controller_mob08	110	110	0	0	0.064	0.942	1.063	1.127	4.993	7.515	8.885	1.492	4.9
CICO_TC_Check-Out Controller_mob09	127	127	0	0	0.071	0.931	1.047	1.128	4.101	10.392	10.516	1.423	4.004

Test №4

DB_MAXSHAREDPOOLSIZE=2500 for mod-invetory-storage, DB_MAXSHAREDPOOLSIZE=140 for mod-circulation-storage and for others modules DB_MAXPOOLSIZE=20 (with Data Import).

Requests	Total per tenant	50th pct	75th pct	95th pct	99th pct	Average	CICO Error	DI Duration	DI Error
CICO_TC_Check-In	118	0.928	1.023	2.477	9.018	1.270	0	0:59:56	PARSING	ERROR
CICO_TC_Check-Out	118	1.731	1.889	6.803	11.698	2.357	0	0:59:56	0	1

Full Check-In/Check-Out result table

Requests	Total	OK	KO	% KO	Req/s	Min	50th pct	75th pct	95th pct	99th pct	Max	Average	Latency
CICO_TC_Check-In Controller_fs00001137	120	120	0	0	0.067	0.743	1.184	1.39	1.961	9.081	14.935	1.503	1.876
CICO_TC_Check-In Controller_mob01	118	118	0	0	0.066	0.687	0.928	1.018	3.538	11.88	15.149	1.365	3.44
CICO_TC_Check-In Controller_mob010	123	123	0	0	0.072	0.69	0.924	1.032	4.521	9.198	13.281	1.34	4.418
CICO_TC_Check-In Controller_mob011	133	133	0	0	0.075	0.686	0.937	1.003	1.457	9.044	16.233	1.224	1.346
CICO_TC_Check-In Controller_mob012	120	120	0	0	0.069	0.656	0.922	1.018	2.462	13.306	13.31	1.33	2.388
CICO_TC_Check-In Controller_mob013	107	107	0	0	0.061	0.732	0.905	1.014	2.674	8.142	12.822	1.267	2.591
CICO_TC_Check-In Controller_mob014	122	122	0	0	0.07	0.696	0.906	1.001	1.523	5.119	12.378	1.145	1.42
CICO_TC_Check-In Controller_mob015	143	143	0	0	0.08	0.673	0.895	1	1.486	8.998	13.501	1.126	1.401
CICO_TC_Check-In Controller_mob016	121	121	0	0	0.07	0.668	0.916	1.015	1.542	7.094	11.814	1.209	1.454
CICO_TC_Check-In Controller_mob017	130	130	0	0	0.075	0.709	0.92	1.024	1.464	6.578	6.803	1.123	1.376
CICO_TC_Check-In Controller_mob018	114	114	0	0	0.069	0.713	0.91	1.019	1.394	7.209	12.561	1.163	1.288
CICO_TC_Check-In Controller_mob019	120	120	0	0	0.069	0.692	0.927	1.035	4.831	11.656	15.724	1.426	4.72
CICO_TC_Check-In Controller_mob02	104	104	0	0	0.062	0.707	0.943	1.04	1.756	8.61	9.84	1.205	1.681
CICO_TC_Check-In Controller_mob020	118	118	0	0	0.066	0.664	0.924	0.996	3.035	11.406	17.738	1.402	2.944
CICO_TC_Check-In Controller_mob021	122	122	0	0	0.069	0.658	0.933	1.015	4.969	11.184	14.666	1.469	4.851
CICO_TC_Check-In Controller_mob022	124	124	0	0	0.072	0.706	0.928	1.023	3.905	9.584	16.081	1.392	3.803
CICO_TC_Check-In Controller_mob023	124	124	0	0	0.073	0.736	0.938	1.041	3.104	8.926	16.255	1.31	3.013
CICO_TC_Check-In Controller_mob024	112	112	0	0	0.065	0.722	0.902	1.007	3.314	9.801	12.214	1.331	3.221
CICO_TC_Check-In Controller_mob025	113	113	0	0	0.064	0.686	0.912	1.013	1.216	7.741	11.471	1.148	1.128
CICO_TC_Check-In Controller_mob026	128	128	0	0	0.074	0.739	0.913	1.025	1.737	9.831	16.329	1.245	1.665
CICO_TC_Check-In Controller_mob027	113	113	0	0	0.066	0.763	0.945	1.039	4.922	11.312	14.536	1.454	4.609
CICO_TC_Check-In Controller_mob028	108	108	0	0	0.061	0.668	0.938	1.033	5.729	11.097	14.527	1.38	5.629
CICO_TC_Check-In Controller_mob029	131	131	0	0	0.076	0.652	0.913	0.999	1.285	9.276	14.678	1.231	1.18
CICO_TC_Check-In Controller_mob03	120	120	0	0	0.067	0.688	0.91	1.015	2.781	13.117	14.708	1.321	2.677
CICO_TC_Check-In Controller_mob030	114	114	0	0	0.067	0.706	0.932	1.023	1.33	10.751	16.944	1.295	1.223
CICO_TC_Check-In Controller_mob031	110	110	0	0	0.063	0.688	0.922	0.98	1.275	5.931	10.854	1.105	1.138
CICO_TC_Check-In Controller_mob032	118	118	0	0	0.068	0.71	0.914	0.99	1.812	8.592	8.991	1.265	1.724
CICO_TC_Check-In Controller_mob033	121	121	0	0	0.069	0.676	0.917	1.016	2.29	7.129	9.027	1.215	2.193
CICO_TC_Check-In Controller_mob034	119	119	0	0	0.068	0.73	0.918	1	1.84	8.934	9.185	1.178	1.746
CICO_TC_Check-In Controller_mob035	113	113	0	0	0.065	0.709	0.91	1.029	3.32	9.129	16.516	1.394	3.252
CICO_TC_Check-In Controller_mob036	113	113	0	0	0.065	0.724	0.938	1.002	1.337	9.911	15.619	1.321	1.227
CICO_TC_Check-In Controller_mob037	113	113	0	0	0.068	0.693	0.926	0.989	2.323	7.842	15.513	1.236	2.202
CICO_TC_Check-In Controller_mob038	111	111	0	0	0.063	0.732	0.932	1.029	1.924	10.387	15.911	1.298	1.842
CICO_TC_Check-In Controller_mob039	121	121	0	0	0.07	0.694	0.907	0.991	1.342	5.279	7.605	1.055	1.249
CICO_TC_Check-In Controller_mob04	112	112	0	0	0.062	0.698	0.909	0.999	2.307	13.365	14.561	1.3	2.209
CICO_TC_Check-In Controller_mob040	124	124	0	0	0.071	0.679	0.929	1.006	4.1	10.614	16.904	1.378	3.967
CICO_TC_Check-In Controller_mob041	126	126	0	0	0.073	0.693	0.925	1.031	1.738	8.949	16.062	1.236	1.66
CICO_TC_Check-In Controller_mob042	118	118	0	0	0.068	0.704	0.916	1.015	2.613	8.801	9.107	1.244	2.513
CICO_TC_Check-In Controller_mob043	129	129	0	0	0.076	0.703	0.947	1.03	4.032	9.284	10.465	1.316	3.917
CICO_TC_Check-In Controller_mob044	115	115	0	0	0.066	0.693	0.939	1.039	3.514	9.407	14.897	1.403	3.417
CICO_TC_Check-In Controller_mob045	123	123	0	0	0.072	0.685	0.923	1.045	2.088	9.592	15.569	1.34	1.981
CICO_TC_Check-In Controller_mob046	118	118	0	0	0.067	0.696	0.933	1.005	1.69	8.946	16.409	1.208	1.605
CICO_TC_Check-In Controller_mob047	113	113	0	0	0.068	0.674	0.927	1.016	1.396	9.454	16.052	1.243	1.282
CICO_TC_Check-In Controller_mob048	116	116	0	0	0.067	0.713	0.952	1.088	3.217	10.897	15.687	1.373	3.12
CICO_TC_Check-In Controller_mob049	121	121	0	0	0.07	0.692	0.926	1.044	1.48	6.934	15.954	1.2	1.394
CICO_TC_Check-In Controller_mob05	114	114	0	0	0.064	0.713	0.93	1.024	1.3	2.331	3.654	0.991	1.132
CICO_TC_Check-In Controller_mob050	116	116	0	0	0.068	0.682	0.936	1.016	1.387	10.171	10.646	1.264	1.264
CICO_TC_Check-In Controller_mob051	101	101	0	0	0.059	0.745	0.945	1.037	3.883	10.443	14.681	1.404	3.796
CICO_TC_Check-In Controller_mob052	121	121	0	0	0.069	0.667	0.917	1.001	1.736	6.026	9.639	1.13	1.66
CICO_TC_Check-In Controller_mob053	115	115	0	0	0.066	0.718	0.94	1.039	3.817	9.803	15.294	1.398	3.724
CICO_TC_Check-In Controller_mob054	123	123	0	0	0.07	0.656	0.924	1.005	1.429	5.199	15.911	1.152	1.344
CICO_TC_Check-In Controller_mob055	119	119	0	0	0.068	0.659	0.919	0.994	1.876	8.264	14.93	1.22	1.801
CICO_TC_Check-In Controller_mob056	123	123	0	0	0.07	0.667	0.918	0.997	1.471	6.186	12.868	1.123	1.364
CICO_TC_Check-In Controller_mob057	114	114	0	0	0.066	0.755	0.922	0.983	3.487	9.777	10.243	1.3	3.371
CICO_TC_Check-In Controller_mob058	109	109	0	0	0.062	0.679	0.953	1.052	5.092	10.451	14.65	1.481	5.001
CICO_TC_Check-In Controller_mob059	105	105	0	0	0.061	0.663	0.925	1.029	2.817	6.211	12.231	1.222	2.736
CICO_TC_Check-In Controller_mob06	129	129	0	0	0.075	0.71	0.923	1.02	1.547	9.591	13.208	1.262	1.453
CICO_TC_Check-In Controller_mob060	118	118	0	0	0.069	0.744	0.912	1.002	2.879	14.706	15.301	1.347	2.799
CICO_TC_Check-In Controller_mob07	115	115	0	0	0.068	0.679	0.891	0.978	1.518	9.123	13.693	1.236	1.423
CICO_TC_Check-In Controller_mob08	119	0	119	100	0	0.735	0.909	1.016	1.918	4.882	13.419	1.143	1.818
CICO_TC_Check-In Controller_mob09	119	119	0	0	0.069	0.66	0.917	1.014	1.342	7.637	9.213	1.104	1.257
CICO_TC_Check-Out Controller_fs00001137	117	117	0	0	0.068	1.622	2.202	2.732	8.714	13.442	16.981	3.094	8.548
CICO_TC_Check-Out Controller_mob01	119	119	0	0	0.068	1.351	1.708	1.864	3.122	8.1	9.562	2.023	2.987
CICO_TC_Check-Out Controller_mob010	113	113	0	0	0.063	1.364	1.702	1.87	6.195	7.539	7.556	2.114	6.053
CICO_TC_Check-Out Controller_mob011	104	104	0	0	0.06	1.342	1.727	1.897	6.032	9.748	10.238	2.189	5.898
CICO_TC_Check-Out Controller_mob012	117	117	0	0	0.066	1.378	1.722	1.878	7.84	15.286	19	2.546	7.698
CICO_TC_Check-Out Controller_mob013	130	130	0	0	0.073	1.376	1.718	1.907	8.497	11.754	15.282	2.468	8.372
CICO_TC_Check-Out Controller_mob014	114	114	0	0	0.066	1.375	1.772	1.893	5.276	12.145	18.136	2.252	5.134
CICO_TC_Check-Out Controller_mob015	94	94	0	0	0.056	1.371	1.694	1.858	5.736	12.462	14.179	2.256	5.565
CICO_TC_Check-Out Controller_mob016	116	116	0	0	0.066	1.357	1.721	1.918	6.548	12.905	18.667	2.397	6.397
CICO_TC_Check-Out Controller_mob017	106	106	0	0	0.06	1.378	1.74	1.886	8.07	12.981	17.084	2.456	7.943
CICO_TC_Check-Out Controller_mob018	123	123	0	0	0.069	1.358	1.71	1.863	8.25	14.495	17.952	2.539	8.125
CICO_TC_Check-Out Controller_mob019	116	116	0	0	0.065	1.39	1.715	1.843	4.266	6.71	7.633	2.019	4.102
CICO_TC_Check-Out Controller_mob02	132	132	0	0	0.073	1.369	1.732	1.898	6.551	16.089	16.136	2.414	6.4
CICO_TC_Check-Out Controller_mob020	120	120	0	0	0.07	1.389	1.742	1.878	6.436	11.507	18.347	2.266	6.289
CICO_TC_Check-Out Controller_mob021	114	114	0	0	0.066	1.358	1.73	1.846	4.643	11.793	14.501	2.122	4.499
CICO_TC_Check-Out Controller_mob022	113	113	0	0	0.064	1.348	1.734	1.879	7.21	13.122	18.406	2.47	7.079
CICO_TC_Check-Out Controller_mob023	111	111	0	0	0.063	1.349	1.698	1.854	7.08	12.998	17.849	2.383	6.929
CICO_TC_Check-Out Controller_mob024	124	124	0	0	0.07	1.339	1.7	1.826	7.112	11.744	17.524	2.336	6.936
CICO_TC_Check-Out Controller_mob025	123	123	0	0	0.071	1.462	1.73	1.887	9.944	13.182	18.218	2.603	9.792
CICO_TC_Check-Out Controller_mob026	109	109	0	0	0.062	1.398	1.714	1.855	7.627	12.799	18.323	2.46	7.503
CICO_TC_Check-Out Controller_mob027	122	122	0	0	0.069	1.329	1.706	1.854	7.874	9.693	12.393	2.309	7.714
CICO_TC_Check-Out Controller_mob028	129	129	0	0	0.074	1.343	1.712	1.849	5.134	8.035	13.934	2.063	5.02
CICO_TC_Check-Out Controller_mob029	105	105	0	0	0.06	1.324	1.691	1.859	5.175	11.1	18.686	2.255	4.997
CICO_TC_Check-Out Controller_mob03	117	117	0	0	0.067	1.32	1.758	1.867	8.162	13.05	16.665	2.454	8.025
CICO_TC_Check-Out Controller_mob030	122	122	0	0	0.069	1.464	1.715	1.862	6.096	10.763	11.82	2.243	5.944
CICO_TC_Check-Out Controller_mob031	127	127	0	0	0.072	1.347	1.709	1.848	8.082	11.011	12.518	2.351	7.943
CICO_TC_Check-Out Controller_mob032	119	119	0	0	0.068	1.37	1.75	1.886	5.592	13.115	17.948	2.3	5.449
CICO_TC_Check-Out Controller_mob033	115	115	0	0	0.067	1.432	1.758	1.88	7.444	11.378	11.44	2.453	7.308
CICO_TC_Check-Out Controller_mob034	117	117	0	0	0.07	1.351	1.727	1.872	7.51	11.486	18.035	2.446	7.347
CICO_TC_Check-Out Controller_mob035	123	123	0	0	0.07	1.35	1.743	1.89	7.662	13.813	18.126	2.576	7.549
CICO_TC_Check-Out Controller_mob036	123	123	0	0	0.07	1.366	1.676	1.886	6.184	7.29	12.91	2.122	6.052
CICO_TC_Check-Out Controller_mob037	124	124	0	0	0.07	1.385	1.739	1.933	7.189	13.073	17.203	2.521	7.069
CICO_TC_Check-Out Controller_mob038	125	125	0	0	0.072	1.358	1.755	1.939	7.541	12.299	17.637	2.546	7.42
CICO_TC_Check-Out Controller_mob039	115	115	0	0	0.065	1.39	1.717	1.842	3.988	7.597	10.481	2.069	3.812
CICO_TC_Check-Out Controller_mob04	125	125	0	0	0.071	1.406	1.73	1.844	7.798	10.079	15.994	2.229	7.686
CICO_TC_Check-Out Controller_mob040	112	112	0	0	0.066	1.352	1.716	1.914	7.349	8.378	18.714	2.372	7.242
CICO_TC_Check-Out Controller_mob041	108	108	0	0	0.064	1.313	1.748	1.889	7.808	12.084	12.272	2.479	7.63
CICO_TC_Check-Out Controller_mob042	118	118	0	0	0.067	1.34	1.71	1.861	8.712	12.685	17.681	2.538	8.547
CICO_TC_Check-Out Controller_mob043	106	106	0	0	0.061	1.319	1.714	1.87	6.934	8.775	10.459	2.166	6.737
CICO_TC_Check-Out Controller_mob044	120	120	0	0	0.07	1.378	1.712	1.87	6.068	12.352	17.029	2.285	5.917
CICO_TC_Check-Out Controller_mob045	112	112	0	0	0.066	1.424	1.712	1.868	6.944	10.513	18.202	2.416	6.818
CICO_TC_Check-Out Controller_mob046	119	119	0	0	0.069	1.387	1.71	1.856	7.425	14.179	18.848	2.536	7.298
CICO_TC_Check-Out Controller_mob047	122	122	0	0	0.07	1.297	1.754	1.858	7.04	11.261	16.258	2.316	6.917
CICO_TC_Check-Out Controller_mob048	119	119	0	0	0.069	1.4	1.72	1.894	7.065	9.209	16.036	2.321	6.934
CICO_TC_Check-Out Controller_mob049	114	114	0	0	0.068	1.368	1.703	1.909	4.727	9.741	12.155	2.164	4.563
CICO_TC_Check-Out Controller_mob05	122	122	0	0	0.071	1.415	1.714	1.876	6.813	11.769	12.254	2.334	6.652
CICO_TC_Check-Out Controller_mob050	121	121	0	0	0.069	1.299	1.718	1.918	8.928	12.044	14.659	2.451	8.761
CICO_TC_Check-Out Controller_mob051	134	134	0	0	0.079	1.321	1.692	1.824	5.368	11.319	17.759	2.217	5.218
CICO_TC_Check-Out Controller_mob052	115	115	0	0	0.069	1.411	1.734	1.885	9.655	13.209	16.206	2.521	9.521
CICO_TC_Check-Out Controller_mob053	119	119	0	0	0.07	1.398	1.714	1.83	7.767	12.554	15.576	2.508	7.652
CICO_TC_Check-Out Controller_mob054	113	113	0	0	0.067	1.419	1.761	1.928	6.744	12.831	16.143	2.558	6.619
CICO_TC_Check-Out Controller_mob055	117	117	0	0	0.068	1.34	1.716	1.885	6.478	16.74	19.28	2.401	6.335
CICO_TC_Check-Out Controller_mob056	114	114	0	0	0.067	1.358	1.762	1.912	7.127	10.982	14.78	2.416	7.005
CICO_TC_Check-Out Controller_mob057	122	122	0	0	0.07	1.376	1.734	1.833	7.22	11.055	14.287	2.372	7.067
CICO_TC_Check-Out Controller_mob058	127	127	0	0	0.074	1.408	1.714	1.855	7.3	17.02	19.617	2.409	7.16
CICO_TC_Check-Out Controller_mob059	130	130	0	0	0.076	1.348	1.726	1.879	7.207	12.001	15.834	2.282	7.083
CICO_TC_Check-Out Controller_mob06	106	106	0	0	0.06	1.341	1.722	1.902	3.748	9.99	13.301	2.127	3.629
CICO_TC_Check-Out Controller_mob060	117	117	0	0	0.068	1.365	1.735	1.902	7.011	10.572	16.427	2.253	6.82
CICO_TC_Check-Out Controller_mob07	121	121	0	0	0.068	1.356	1.684	1.806	6.428	12.438	19.151	2.338	6.28
CICO_TC_Check-Out Controller_mob08	116	116	0	0	0.066	1.377	1.744	1.885	3.695	12.364	14.387	2.171	3.535
CICO_TC_Check-Out Controller_mob09	118	118	0	0	0.066	1.352	1.744	1.907	6.855	12.947	20.04	2.476	6.721

Full Data Import result table

tenant	file_name	started_date	completed_date	duration	status
fs00001137	10k_bib_Create.mrc	2024-03-11 15:56:21.038+00	2024-03-11 16:07:18.936+00	10:57.9	COMMITTED
mob01	10k_bib_Create.mrc	2024-03-11 15:58:20.216+00	2024-03-11 16:21:25.812+00	23:05.6	COMMITTED
mob02	10k_bib_Create.mrc	2024-03-11 16:00:20.365+00	2024-03-11 16:33:27.396+00	33:07.0	COMMITTED
mob03	10k_bib_Create.mrc	2024-03-11 16:02:20.314+00	2024-03-11 16:41:55.318+00	39:35.0	COMMITTED
mob04	10k_bib_Create.mrc	2024-03-11 16:04:20.208+00	2024-03-11 16:44:43.416+00	40:23.2	COMMITTED
mob05	10k_bib_Create.mrc	2024-03-11 16:06:20.22+00	2024-03-11 16:48:12.452+00	41:52.2	COMMITTED
mob06	10k_bib_Create.mrc	2024-03-11 16:08:20.252+00	2024-03-11 16:50:47.65+00	42:27.4	COMMITTED
mob07	10k_bib_Create.mrc	2024-03-11 16:10:20.226+00	2024-03-11 16:52:53.752+00	42:33.5	COMMITTED
mob08	10k_bib_Create.mrc	2024-03-11 16:12:20.295+00	2024-03-11 16:54:44.733+00	42:24.4	COMMITTED
mob09	10k_bib_Create.mrc	2024-03-11 16:14:20.49+00	2024-03-11 16:55:20.462+00	41:00.0	COMMITTED
mob010	10k_bib_Create.mrc	2024-03-11 16:16:20.233+00	2024-03-11 16:55:38.767+00	39:18.5	ERROR
mob011	10k_bib_Create.mrc	2024-03-11 16:18:20.228+00	2024-03-11 16:56:02.419+00	37:42.2	COMMITTED
mob012	10k_bib_Create.mrc	2024-03-11 16:20:20.25+00	2024-03-11 16:56:07.724+00	35:47.5	COMMITTED
mob013	10k_bib_Create.mrc	2024-03-11 16:22:20.324+00	2024-03-11 16:56:14.656+00	33:54.3	COMMITTED
mob014	10k_bib_Create.mrc	2024-03-11 16:24:20.212+00	2024-03-11 16:56:17.712+00	31:57.5	COMMITTED

Test №5

DB_MAXSHAREDPOOLSIZE=40 parameter for list of modules.

Requests	Total per tenant	50th pct	75th pct	95th pct	99th pct	Average	CICO Error	DI Duration	DI Error
CICO_TC_Check-In	83	15.873	25.204	33.571	38.346	16.192	0	-	PARSING	ERROR
CICO_TC_Check-Out	84	19.457	27.921	36.492	40.956	18.911	1	-	7	7

Full Check-In/Check-Out result table

Requests	Total	OK	KO	% KO	Req/s	Min	50th pct	75th pct	95th pct	99th pct	Max	Average	Latency
CICO_TC_Check-In Controller_fs00001137	87	87	0	0	0.05	0.935	14.696	22.552	32.812	37.907	39.279	14.681	32.75
CICO_TC_Check-In Controller_mob01	79	79	0	0	0.046	0.936	13.211	21.418	31.075	32.806	34.3	14.182	31.008
CICO_TC_Check-In Controller_mob010	68	68	0	0	0.039	0.663	17.753	26.488	35.158	38.833	43.706	17.26	35.092
CICO_TC_Check-In Controller_mob011	83	83	0	0	0.049	0.824	15.148	26.662	35.232	37.794	41.362	16.25	35.169
CICO_TC_Check-In Controller_mob012	79	79	0	0	0.045	0.967	15.768	25.178	31.922	38.784	42.306	16.005	31.852
CICO_TC_Check-In Controller_mob013	83	83	0	0	0.048	0.921	16.373	25.822	35.424	38.561	39.648	17.066	35.353
CICO_TC_Check-In Controller_mob014	78	78	0	0	0.044	0.927	17.104	25.794	33.388	38.096	44.858	16.822	33.321
CICO_TC_Check-In Controller_mob015	83	83	0	0	0.047	0.717	16.547	27.134	34.844	42.763	44.227	17.072	34.782
CICO_TC_Check-In Controller_mob016	84	84	0	0	0.048	0.724	17.307	26.838	32.719	37.99	38.138	17.273	32.652
CICO_TC_Check-In Controller_mob017	95	95	0	0	0.054	0.933	12.491	25.715	32.96	42.101	44.919	15.353	32.872
CICO_TC_Check-In Controller_mob018	85	85	0	0	0.048	0.844	14.878	25.272	33.246	41.034	45.602	16.234	33.178
CICO_TC_Check-In Controller_mob019	84	84	0	0	0.047	0.905	16.494	24.275	35.253	39.528	40.706	16.366	35.197
CICO_TC_Check-In Controller_mob02	76	76	0	0	0.043	0.801	13.817	24.851	30.319	37.391	45.085	14.639	30.259
CICO_TC_Check-In Controller_mob020	95	95	0	0	0.054	0.688	16.909	26.224	36.184	42.046	49.299	17.182	36.118
CICO_TC_Check-In Controller_mob021	75	75	0	0	0.044	0.829	16.994	26.338	32.97	36.482	42.386	16.558	32.896
CICO_TC_Check-In Controller_mob022	87	87	0	0	0.05	0.796	13.608	22.636	33.304	38.691	39.009	14.787	33.24
CICO_TC_Check-In Controller_mob023	87	87	0	0	0.05	0.88	13.36	25.087	31.955	38.466	39.146	15.068	31.889
CICO_TC_Check-In Controller_mob024	85	85	0	0	0.048	0.9	15.708	26.447	35.102	39.947	41.168	16.929	35.037
CICO_TC_Check-In Controller_mob025	77	77	0	0	0.046	0.834	17.481	24.795	34.393	40.056	42.972	17.452	34.325
CICO_TC_Check-In Controller_mob026	83	83	0	0	0.047	0.955	13.861	25.768	31.889	34.929	40.438	15.318	31.815
CICO_TC_Check-In Controller_mob027	79	79	0	0	0.045	0.951	17.279	26.992	35.451	43.446	44.289	16.342	35.397
CICO_TC_Check-In Controller_mob028	89	89	0	0	0.052	0.841	17.078	25.09	32.621	38.815	44.432	16.683	32.55
CICO_TC_Check-In Controller_mob029	77	77	0	0	0.044	0.962	15.098	25.365	37.572	39.999	41.975	16.127	37.491
CICO_TC_Check-In Controller_mob03	77	77	0	0	0.044	0.941	13.941	23.403	31.078	35.085	38.739	15.394	31.013
CICO_TC_Check-In Controller_mob030	84	84	0	0	0.048	0.95	17.646	26.694	34.558	39.942	40.095	17.078	34.498
CICO_TC_Check-In Controller_mob031	82	82	0	0	0.049	0.95	17.462	24.948	34.358	36.589	38.31	17.009	34.288
CICO_TC_Check-In Controller_mob032	79	79	0	0	0.047	0.737	15.752	23.937	30.438	35.322	38.325	15.86	30.38
CICO_TC_Check-In Controller_mob033	81	81	0	0	0.048	0.911	15.135	23.706	31.66	33.959	36.662	14.767	31.596
CICO_TC_Check-In Controller_mob034	75	75	0	0	0.044	0.692	14.808	25.81	33.448	36.79	43.467	16.044	33.385
CICO_TC_Check-In Controller_mob035	83	83	0	0	0.047	0.939	13.78	24.816	30.859	36.649	37.587	15.127	30.797
CICO_TC_Check-In Controller_mob036	83	83	0	0	0.047	0.887	16.905	25.675	33.211	39.218	42.33	16.964	33.144
CICO_TC_Check-In Controller_mob037	87	87	0	0	0.049	0.835	17	25.037	31.106	37.013	39.848	16.204	31.033
CICO_TC_Check-In Controller_mob038	86	86	0	0	0.051	0.689	12.9	26.229	31.584	39.073	43.601	15.124	31.525
CICO_TC_Check-In Controller_mob039	89	89	0	0	0.052	0.867	16.414	26.196	34.543	39.689	40.449	16.779	34.479
CICO_TC_Check-In Controller_mob04	74	74	0	0	0.042	0.884	13.726	24.466	33.546	34.041	36.276	15.398	33.484
CICO_TC_Check-In Controller_mob040	87	87	0	0	0.051	1.006	17.842	26.444	35.875	39.331	39.473	17.06	35.805
CICO_TC_Check-In Controller_mob041	81	81	0	0	0.048	0.854	15.868	23.139	36.724	42.606	42.863	16.452	36.656
CICO_TC_Check-In Controller_mob042	93	93	0	0	0.053	0.881	14.767	22.336	31.54	43.433	44.609	14.776	31.479
CICO_TC_Check-In Controller_mob043	88	88	0	0	0.05	0.832	19.347	26.035	36.295	39.413	43.684	18.128	36.233
CICO_TC_Check-In Controller_mob044	82	82	0	0	0.048	0.968	14.793	24.685	31.807	37.289	40.732	15.712	31.745
CICO_TC_Check-In Controller_mob045	76	76	0	0	0.046	0.808	16.415	25.893	34.167	38.264	44.218	17.012	34.094
CICO_TC_Check-In Controller_mob046	70	70	0	0	0.04	0.809	15.486	28.196	32.149	35.246	35.738	16.404	32.066
CICO_TC_Check-In Controller_mob047	71	71	0	0	0.042	0.841	15.632	23.748	30.081	34.466	36.849	15.095	30.006
CICO_TC_Check-In Controller_mob048	84	84	0	0	0.048	0.712	13.703	24.849	34.969	38.873	39.657	14.995	34.904
CICO_TC_Check-In Controller_mob049	85	85	0	0	0.05	0.703	15.947	24.76	34.742	38.187	39.012	15.501	34.677
CICO_TC_Check-In Controller_mob05	77	77	0	0	0.043	0.668	16.404	24.693	32.144	38.1	44.216	16.459	32.077
CICO_TC_Check-In Controller_mob050	87	87	0	0	0.051	0.777	16.923	25.281	31.28	37.243	38.676	15.984	31.218
CICO_TC_Check-In Controller_mob051	87	87	0	0	0.051	0.756	18.788	26.605	36.535	39.026	44.256	17.917	36.474
CICO_TC_Check-In Controller_mob052	81	81	0	0	0.047	0.904	17.458	25.471	34.612	37.877	39.734	16.184	34.545
CICO_TC_Check-In Controller_mob053	85	85	0	0	0.05	1.136	16.2	26.621	37.178	43.021	43.189	17.579	37.112
CICO_TC_Check-In Controller_mob054	86	86	0	0	0.05	0.779	16.533	24.584	36.64	39.335	44.108	16.659	36.575
CICO_TC_Check-In Controller_mob055	90	90	0	0	0.052	0.692	14.113	24.918	37.519	42.119	46.497	15.609	37.437
CICO_TC_Check-In Controller_mob056	76	76	0	0	0.045	0.787	17.52	26.069	32.324	37.607	37.996	17.025	32.26
CICO_TC_Check-In Controller_mob057	79	79	0	0	0.046	0.848	14.775	24.161	32.926	37.96	38.383	14.997	32.865
CICO_TC_Check-In Controller_mob058	82	82	0	0	0.047	1.062	15.74	22.751	31.003	36.471	37.965	15.404	30.939
CICO_TC_Check-In Controller_mob059	77	77	0	0	0.044	0.891	17.68	26.701	31.366	33.77	37.221	17.358	31.293
CICO_TC_Check-In Controller_mob06	85	85	0	0	0.052	0.737	15.7	23.32	33.639	38.945	44.97	16.267	33.562
CICO_TC_Check-In Controller_mob060	79	79	0	0	0.045	0.968	15.321	25.247	33.469	36.451	37.688	16.064	33.409
CICO_TC_Check-In Controller_mob07	87	87	0	0	0.051	0.917	18.989	26.221	36.345	38.419	41.465	17.516	36.283
CICO_TC_Check-In Controller_mob08	88	0	88	100	0	0.763	14.765	25.218	33.452	37.906	38.667	15.894	33.386
CICO_TC_Check-In Controller_mob09	102	102	0	0	0.057	0.72	17.084	25.845	32.886	37.915	38.738	16.29	32.822
CICO_TC_Check-Out Controller_fs00001137	79	78	1	1.266	0.044	2.322	20.48	29.014	37.026	39.881	51.073	19.952	36.904
CICO_TC_Check-Out Controller_mob01	88	88	0	0	0.049	1.727	19.008	25.951	34.872	40.011	41.461	18.29	34.783
CICO_TC_Check-Out Controller_mob010	99	99	0	0	0.056	1.583	18.257	27.331	36.087	41.678	43.981	18.363	36
CICO_TC_Check-Out Controller_mob011	83	83	0	0	0.046	1.632	19.129	28.354	38.627	39.627	42.748	18.382	38.513
CICO_TC_Check-Out Controller_mob012	87	87	0	0	0.052	2.282	18.74	28.713	37.595	41.642	43.312	18.855	37.496
CICO_TC_Check-Out Controller_mob013	83	83	0	0	0.047	1.875	16.427	23.942	34.341	38.905	41.131	16.871	34.246
CICO_TC_Check-Out Controller_mob014	89	89	0	0	0.051	1.835	19.584	28.221	39.875	42.256	46.521	18.891	39.74
CICO_TC_Check-Out Controller_mob015	83	83	0	0	0.049	1.955	18.186	26.62	36.893	39.693	41.051	18.123	36.777
CICO_TC_Check-Out Controller_mob016	82	82	0	0	0.046	1.828	18.75	29.014	38.468	40.952	40.969	18.747	38.336
CICO_TC_Check-Out Controller_mob017	71	71	0	0	0.04	2.496	22.065	28.051	37.386	42.35	43.843	20.995	37.302
CICO_TC_Check-Out Controller_mob018	82	82	0	0	0.048	1.728	19.672	27.143	34.356	39.425	40.631	18.879	34.253
CICO_TC_Check-Out Controller_mob019	83	83	0	0	0.048	1.804	20.479	28.709	34.215	35.7	44.526	19.292	34.129
CICO_TC_Check-Out Controller_mob02	92	92	0	0	0.051	1.732	18.933	27.073	31.81	35.942	42.771	18.368	31.706
CICO_TC_Check-Out Controller_mob020	71	71	0	0	0.041	1.928	20.388	27.084	34.534	39.988	46.456	18.491	34.434
CICO_TC_Check-Out Controller_mob021	92	92	0	0	0.052	1.907	20.346	29.719	40.536	47.503	48.775	19.707	40.434
CICO_TC_Check-Out Controller_mob022	79	79	0	0	0.044	2.268	22.561	27.673	38.789	41.936	44.062	20.274	38.674
CICO_TC_Check-Out Controller_mob023	79	79	0	0	0.048	1.89	18.694	26.364	36.687	40.929	42.472	18.789	36.588
CICO_TC_Check-Out Controller_mob024	81	81	0	0	0.048	1.767	17.976	26.166	38.199	39.629	43.592	18.453	38.093
CICO_TC_Check-Out Controller_mob025	89	89	0	0	0.05	1.676	18.677	27.99	34.509	39.005	44.801	17.983	34.4
CICO_TC_Check-Out Controller_mob026	84	84	0	0	0.048	1.742	20.892	29.485	38.802	42.83	45.284	20.303	38.687
CICO_TC_Check-Out Controller_mob027	87	87	0	0	0.051	1.695	19.453	28.017	38.991	45.9	47.893	19.509	38.88
CICO_TC_Check-Out Controller_mob028	77	77	0	0	0.044	1.74	17.227	26.295	36.67	40.745	46.198	17.952	36.558
CICO_TC_Check-Out Controller_mob029	90	90	0	0	0.051	1.937	18.523	27.349	35.64	37.896	40.08	18.311	35.54
CICO_TC_Check-Out Controller_mob03	90	90	0	0	0.05	1.498	18.174	24.637	33.677	43.325	45.576	17.141	33.562
CICO_TC_Check-Out Controller_mob030	82	82	0	0	0.047	1.632	19.817	26.658	34.438	39.422	42.998	18.321	34.333
CICO_TC_Check-Out Controller_mob031	85	85	0	0	0.048	1.659	18.279	27.104	39.354	47.29	50.033	18.938	39.245
CICO_TC_Check-Out Controller_mob032	88	88	0	0	0.05	1.537	19.312	28.5	36.052	46.914	48.966	19.064	35.945
CICO_TC_Check-Out Controller_mob033	85	85	0	0	0.049	1.712	19.909	29.367	36.651	41.666	45.881	19.702	36.549
CICO_TC_Check-Out Controller_mob034	91	91	0	0	0.051	1.688	19.158	28.483	36.636	49.274	49.291	18.92	36.367
CICO_TC_Check-Out Controller_mob035	83	83	0	0	0.048	1.939	21.249	28.303	35.555	39.779	48.625	19.786	35.46
CICO_TC_Check-Out Controller_mob036	83	83	0	0	0.048	1.649	18.61	26.485	35.987	38.033	40.587	17.862	35.886
CICO_TC_Check-Out Controller_mob037	80	80	0	0	0.047	1.746	19.519	28.634	38.699	43.044	43.225	19.162	38.583
CICO_TC_Check-Out Controller_mob038	81	81	0	0	0.046	1.754	21.97	29.766	35.677	43.433	45.541	20.788	35.578
CICO_TC_Check-Out Controller_mob039	77	77	0	0	0.044	1.711	18.647	28.376	35.871	40.701	41.773	18.855	35.762
CICO_TC_Check-Out Controller_mob04	93	93	0	0	0.052	1.638	16.938	27.714	35.499	39.589	43.16	17.908	35.391
CICO_TC_Check-Out Controller_mob040	78	78	0	0	0.046	2.056	19.83	28.774	34.688	41.155	45.971	19.407	34.578
CICO_TC_Check-Out Controller_mob041	85	85	0	0	0.048	1.391	21.934	29.109	34.208	40.175	41.207	19.223	34.114
CICO_TC_Check-Out Controller_mob042	73	73	0	0	0.044	1.925	22.537	30.224	33.692	35.912	39.127	20.697	33.598
CICO_TC_Check-Out Controller_mob043	78	78	0	0	0.047	1.776	15.282	24.998	35.372	41.138	42.386	17.065	35.272
CICO_TC_Check-Out Controller_mob044	83	83	0	0	0.047	2.093	19.43	27.646	35.22	39.085	46.176	18.584	35.117
CICO_TC_Check-Out Controller_mob045	89	89	0	0	0.051	1.836	19.958	27.284	38.243	46.379	46.837	18.661	38.123
CICO_TC_Check-Out Controller_mob046	96	96	0	0	0.057	1.546	19.169	26.952	37.184	43.082	43.587	18.636	37.095
CICO_TC_Check-Out Controller_mob047	94	94	0	0	0.054	1.48	20.497	30.866	40.36	44.917	47.268	20.192	40.257
CICO_TC_Check-Out Controller_mob048	82	82	0	0	0.047	1.487	20.366	28.972	34.666	36.63	37.924	19.524	34.577
CICO_TC_Check-Out Controller_mob049	80	80	0	0	0.046	1.907	19.752	27.439	38.633	40.338	44.035	19.767	38.525
CICO_TC_Check-Out Controller_mob05	89	89	0	0	0.052	1.367	18.008	25.885	33.739	37.899	38.071	16.793	33.633
CICO_TC_Check-Out Controller_mob050	79	79	0	0	0.047	1.858	19.927	29.378	37.943	41.998	54.656	19.651	37.824
CICO_TC_Check-Out Controller_mob051	78	78	0	0	0.045	1.822	18.165	26.57	37.315	39.488	42.386	17.808	37.213
CICO_TC_Check-Out Controller_mob052	85	85	0	0	0.048	2.126	19.453	28.169	38.088	39.225	40.981	19.185	37.979
CICO_TC_Check-Out Controller_mob053	80	80	0	0	0.046	1.635	18.805	28.437	35.365	38.979	39.117	18.317	35.267
CICO_TC_Check-Out Controller_mob054	81	81	0	0	0.047	1.928	21.352	27.842	37.217	39.114	40.163	19.524	37.109
CICO_TC_Check-Out Controller_mob055	75	75	0	0	0.043	2.052	22.232	29.821	38.45	40.963	47.376	20.967	38.329
CICO_TC_Check-Out Controller_mob056	91	91	0	0	0.052	1.689	18.916	29.2	34.944	40.237	42.098	18.786	34.844
CICO_TC_Check-Out Controller_mob057	86	86	0	0	0.05	1.682	19.54	29.494	36.092	38.136	39.714	19.7	35.979
CICO_TC_Check-Out Controller_mob058	85	85	0	0	0.05	1.469	22.628	29.748	38.277	41.421	45.734	20.419	38.166
CICO_TC_Check-Out Controller_mob059	89	89	0	0	0.053	2.121	19.888	27.452	36.24	39.701	40.083	18.694	36.138
CICO_TC_Check-Out Controller_mob06	81	81	0	0	0.045	1.659	18.842	29.733	37.566	40.21	43.78	18.185	37.475
CICO_TC_Check-Out Controller_mob060	87	87	0	0	0.051	1.773	20.323	27.575	38.041	42.834	45.685	19.708	37.938
CICO_TC_Check-Out Controller_mob07	80	80	0	0	0.045	1.563	16.596	24.565	34.482	40.805	43.331	16.394	34.371
CICO_TC_Check-Out Controller_mob08	78	78	0	0	0.044	1.359	16.777	28.874	34.708	39.376	41.46	17.977	34.613
CICO_TC_Check-Out Controller_mob09	65	65	0	0	0.039	1.495	20.639	29.863	36.25	42.234	45.96	19.476	36.155

Full Data Import result table

tenant	file_name	started_date	completed_date	duration	status
fs00001137	10k_bib_Create.mrc	2024-03-12 10:09:14.995+00	2024-03-12 10:20:51.611+00	11:36.6	COMMITTED
mob01	10k_bib_Create.mrc	2024-03-12 10:11:13.95+00			PARSING_IN_PROGRESS
mob02	10k_bib_Create.mrc	2024-03-12 10:13:14.126+00			PARSING_IN_PROGRESS
mob03	10k_bib_Create.mrc	2024-03-12 10:15:13.931+00	2024-03-12 10:39:35.038+00	24:21.1	ERROR
mob04	10k_bib_Create.mrc	2024-03-12 10:17:13.941+00			PARSING_IN_PROGRESS
mob05	10k_bib_Create.mrc	2024-03-12 10:19:13.97+00			PARSING_IN_PROGRESS
mob06	10k_bib_Create.mrc	2024-03-12 10:21:13.897+00			PARSING_IN_PROGRESS
mob07	10k_bib_Create.mrc	2024-03-12 10:23:13.941+00			PARSING_IN_PROGRESS
mob08	10k_bib_Create.mrc	2024-03-12 10:25:13.911+00	2024-03-12 10:26:49.938+00	01:36.0	ERROR
mob09	10k_bib_Create.mrc	2024-03-12 10:27:13.93+00	2024-03-12 11:38:32.369+00	11:18.4	ERROR
mob010	10k_bib_Create.mrc	2024-03-12 10:29:13.929+00	2024-03-12 10:35:22.774+00	06:08.8	ERROR
mob011	10k_bib_Create.mrc	2024-03-12 10:31:13.836+00	2024-03-12 10:36:22.929+00	05:09.1	ERROR
mob012	10k_bib_Create.mrc	2024-03-12 10:33:14.027+00			FILE_UPLOADED
mob013	10k_bib_Create.mrc	2024-03-12 10:35:13.933+00			PARSING_IN_PROGRESS
mob014	10k_bib_Create.mrc	2024-03-12 10:37:13.931+00			NEW

Test №6

DB_MAXSHAREDPOOLSIZE=70 parameter for list of modules.

Requests	Total per tenant	50th pct	75th pct	95th pct	99th pct	Average	CICO Error	DI Duration	DI Error
CICO_TC_Check-In	98	1.960	2.790	48.943	75.054	7.956	0	0:57:59	PARSING	ERROR
CICO_TC_Check-Out	94	4.058	12.300	63.330	78.014	14.255	2	0:57:59	0	0

Full Check-In/Check-Out result table

Requests	Total	OK	KO	% KO	Req/s	Min	50th pct	75th pct	95th pct	99th pct	Max	Average	Latency
CICO_TC_Check-In Controller_fs00001137	82	82	0	0	0.048	1.062	2.432	3.193	50.624	80.473	82.2	9.277	50.542
CICO_TC_Check-In Controller_mob01	86	86	0	0	0.048	0.999	1.733	2.64	66.597	78.186	87.845	8.716	66.508
CICO_TC_Check-In Controller_mob010	91	91	0	0	0.054	0.969	1.978	3.073	45.157	81.035	88.688	8.109	44.949
CICO_TC_Check-In Controller_mob011	85	85	0	0	0.048	0.846	1.963	2.919	53.6	79.481	82.452	8.846	53.522
CICO_TC_Check-In Controller_mob012	97	97	0	0	0.054	0.861	2.048	2.748	43.062	76.482	77.636	6.933	42.951
CICO_TC_Check-In Controller_mob013	103	103	0	0	0.059	0.985	1.88	2.666	45.354	79.091	80.352	7.825	45.273
CICO_TC_Check-In Controller_mob014	100	100	0	0	0.057	0.813	1.934	2.52	45.995	77.686	88.565	7.165	45.896
CICO_TC_Check-In Controller_mob015	111	111	0	0	0.069	1.054	1.859	2.587	48.686	73.156	74.528	7.063	48.568
CICO_TC_Check-In Controller_mob016	97	97	0	0	0.058	1.057	1.974	3.179	54.996	82.563	87.92	9.542	54.917
CICO_TC_Check-In Controller_mob017	98	98	0	0	0.055	0.938	1.929	2.849	47.287	75.872	81.146	8.618	47.164
CICO_TC_Check-In Controller_mob018	80	80	0	0	0.045	0.818	2.209	3.089	39.353	73.071	76.829	8.055	39.27
CICO_TC_Check-In Controller_mob019	104	104	0	0	0.06	0.867	1.995	2.909	44.23	75.031	77.552	6.892	44.108
CICO_TC_Check-In Controller_mob02	92	92	0	0	0.051	0.922	1.823	2.665	46.998	77.839	87.358	9.399	46.935
CICO_TC_Check-In Controller_mob020	97	97	0	0	0.056	0.916	1.945	2.492	39.056	77.472	78.234	6.351	38.969
CICO_TC_Check-In Controller_mob021	104	104	0	0	0.058	0.934	1.909	2.658	47.445	73.784	75.941	7.696	47.368
CICO_TC_Check-In Controller_mob022	96	96	0	0	0.054	0.814	1.905	2.605	33.781	72.165	82.193	5.778	33.659
CICO_TC_Check-In Controller_mob023	96	96	0	0	0.056	0.748	1.913	2.689	41.306	49.589	69.604	5.593	41.228
CICO_TC_Check-In Controller_mob024	91	91	0	0	0.051	0.965	2.008	2.723	50.884	76.843	79.902	7.678	50.774
CICO_TC_Check-In Controller_mob025	87	87	0	0	0.053	0.897	2.071	2.946	41.696	76.226	78.253	7.525	41.573
CICO_TC_Check-In Controller_mob026	107	107	0	0	0.064	0.847	1.953	2.605	40.331	73.383	77.815	7.473	40.223
CICO_TC_Check-In Controller_mob027	102	102	0	0	0.058	1.04	1.992	2.821	36.967	73.306	75.541	7.055	36.843
CICO_TC_Check-In Controller_mob028	94	94	0	0	0.054	0.962	2.055	3.169	68.699	79.877	88.314	10.309	68.628
CICO_TC_Check-In Controller_mob029	101	101	0	0	0.059	0.856	1.922	3.124	51.462	79.2	81.569	8.275	51.367
CICO_TC_Check-In Controller_mob03	101	101	0	0	0.058	0.838	1.833	2.445	49.117	78.859	81.166	7.988	49.036
CICO_TC_Check-In Controller_mob030	80	80	0	0	0.046	0.915	1.77	2.707	37.932	52.857	63.437	6.05	37.826
CICO_TC_Check-In Controller_mob031	105	105	0	0	0.063	0.91	2.219	2.969	50.834	73.663	77.2	8.185	50.747
CICO_TC_Check-In Controller_mob032	100	100	0	0	0.057	0.84	1.866	2.861	40.229	71.531	80.027	7.273	40.118
CICO_TC_Check-In Controller_mob033	83	83	0	0	0.049	0.915	1.896	2.606	39.404	77.901	85.498	7.794	39.317
CICO_TC_Check-In Controller_mob034	91	91	0	0	0.054	1.113	2.112	2.95	44.104	74.916	76.663	8.211	44.002
CICO_TC_Check-In Controller_mob035	111	111	0	0	0.064	0.909	2.002	2.68	47.148	78.952	79.396	7.471	47.067
CICO_TC_Check-In Controller_mob036	113	113	0	0	0.064	0.855	1.868	2.551	30.942	56.603	71.022	5.556	30.855
CICO_TC_Check-In Controller_mob037	104	104	0	0	0.059	0.994	1.835	2.714	53.808	81.976	83.453	8.354	53.72
CICO_TC_Check-In Controller_mob038	95	95	0	0	0.054	0.905	1.87	2.5	60.349	72.442	77.893	7.116	60.262
CICO_TC_Check-In Controller_mob039	98	98	0	0	0.057	0.95	1.891	2.687	48.988	76.977	79.807	8.313	48.88
CICO_TC_Check-In Controller_mob04	93	93	0	0	0.053	0.902	1.77	2.318	44.146	78.878	82.554	7.575	44.075
CICO_TC_Check-In Controller_mob040	90	90	0	0	0.053	0.962	2.071	2.779	48.623	79.625	82.303	7.429	48.343
CICO_TC_Check-In Controller_mob041	106	106	0	0	0.061	0.827	2.021	2.868	40.606	70.34	78.707	7.069	40.507
CICO_TC_Check-In Controller_mob042	103	103	0	0	0.06	0.808	1.914	2.727	39.307	76.261	78.36	7.274	39.172
CICO_TC_Check-In Controller_mob043	101	101	0	0	0.057	0.826	1.978	2.912	63.468	74.55	74.874	8.977	63.372
CICO_TC_Check-In Controller_mob044	94	94	0	0	0.054	0.961	2.074	2.689	48.497	72.853	83.375	6.777	48.413
CICO_TC_Check-In Controller_mob045	105	105	0	0	0.062	0.865	1.883	2.797	42.602	75.776	77.265	6.801	42.524
CICO_TC_Check-In Controller_mob046	96	96	0	0	0.055	0.833	1.931	2.624	46.926	78.868	85.691	7.443	46.769
CICO_TC_Check-In Controller_mob047	107	107	0	0	0.063	0.918	1.906	3.085	64.804	81.162	81.816	9.296	64.727
CICO_TC_Check-In Controller_mob048	90	90	0	0	0.053	0.897	1.971	2.547	61.232	77.21	82.424	8.842	61.14
CICO_TC_Check-In Controller_mob049	114	114	0	0	0.066	0.836	2.203	3.089	56.948	71.149	77.858	9.62	56.864
CICO_TC_Check-In Controller_mob05	101	101	0	0	0.057	0.847	1.861	2.841	52.945	79.956	91.611	8.179	52.813
CICO_TC_Check-In Controller_mob050	91	91	0	0	0.055	0.958	1.974	2.781	63.738	74.626	78.852	8.775	63.626
CICO_TC_Check-In Controller_mob051	89	89	0	0	0.054	0.943	1.915	2.665	50.116	74.753	78.782	8.546	50.052
CICO_TC_Check-In Controller_mob052	95	95	0	0	0.054	0.877	1.92	3.014	54.38	82.534	84.322	8.65	54.085
CICO_TC_Check-In Controller_mob053	105	105	0	0	0.061	0.837	1.827	2.958	46.19	78.038	81.393	7.456	46.114
CICO_TC_Check-In Controller_mob054	96	96	0	0	0.056	0.857	1.982	2.72	53.452	74.869	79.184	8.864	53.332
CICO_TC_Check-In Controller_mob055	99	99	0	0	0.06	0.957	1.977	2.884	44.092	68.917	71.197	7.412	43.972
CICO_TC_Check-In Controller_mob056	100	100	0	0	0.057	0.934	1.935	2.771	43.917	78.385	88.016	7.646	43.779
CICO_TC_Check-In Controller_mob057	87	87	0	0	0.05	0.968	2.148	3.124	64.183	77.591	81.083	10.43	64.106
CICO_TC_Check-In Controller_mob058	106	106	0	0	0.064	0.922	1.928	2.951	61.552	74.97	75.123	9.333	61.48
CICO_TC_Check-In Controller_mob059	99	99	0	0	0.057	0.864	1.981	3.109	63.086	79.616	80.341	9.428	63.004
CICO_TC_Check-In Controller_mob06	97	97	0	0	0.055	0.857	1.938	2.58	38.958	65.618	75.746	7.382	38.722
CICO_TC_Check-In Controller_mob060	115	115	0	0	0.068	0.977	1.985	3.023	55.867	77.018	77.577	9.74	55.804
CICO_TC_Check-In Controller_mob07	99	99	0	0	0.056	0.887	1.832	2.502	40.834	60.987	69.959	6.738	40.704
CICO_TC_Check-In Controller_mob08	90	0	90	100	0	0.712	2.035	2.78	50.435	79.235	80.346	8.772	50.335
CICO_TC_Check-In Controller_mob09	98	98	0	0	0.056	1.089	1.986	2.512	58.184	76.045	77.599	8.388	58.09
CICO_TC_Check-Out Controller_fs00001137	110	108	2	1.818	0.061	2.012	4.364	6.329	68.633	74.953	85.361	12.378	68.202
CICO_TC_Check-Out Controller_mob01	106	106	0	0	0.06	1.585	3.543	11.977	63.43	83.725	88.304	14.095	63.152
CICO_TC_Check-Out Controller_mob010	102	102	0	0	0.057	1.622	3.9	7.826	64.255	78.042	84.221	12.873	64.072
CICO_TC_Check-Out Controller_mob011	106	106	0	0	0.061	1.634	3.823	10.457	67.536	76.603	83.408	12.976	67.39
CICO_TC_Check-Out Controller_mob012	95	95	0	0	0.055	1.617	4.001	19.138	65.173	84.855	86.213	15.633	64.946
CICO_TC_Check-Out Controller_mob013	88	88	0	0	0.05	1.918	4.418	7.822	69.321	81.506	89.639	14.433	68.747
CICO_TC_Check-Out Controller_mob014	91	91	0	0	0.053	1.988	4.292	17.507	55.173	68.494	76.372	14.484	54.908
CICO_TC_Check-Out Controller_mob015	80	80	0	0	0.045	1.597	3.7	6.048	68.101	81.009	82.217	13.409	67.876
CICO_TC_Check-Out Controller_mob016	95	95	0	0	0.054	1.556	3.828	5.789	42.834	80.229	83.888	11.301	42.607
CICO_TC_Check-Out Controller_mob017	94	94	0	0	0.054	1.911	3.962	9.296	66.502	79.839	91.539	15.52	66.106
CICO_TC_Check-Out Controller_mob018	112	112	0	0	0.065	1.648	3.908	11.08	67.914	79.87	84.961	15.69	67.711
CICO_TC_Check-Out Controller_mob019	88	88	0	0	0.05	1.815	4.489	20.36	67.036	77.026	80.317	15.174	66.91
CICO_TC_Check-Out Controller_mob02	100	100	0	0	0.057	1.531	3.517	6.908	67.003	79.588	79.797	12.643	66.779
CICO_TC_Check-Out Controller_mob020	95	95	0	0	0.053	1.697	4.228	21.405	68.131	80.759	89.678	15.974	68.032
CICO_TC_Check-Out Controller_mob021	88	88	0	0	0.057	2.179	4.327	5.468	69.446	79.272	93.63	13.568	69.248
CICO_TC_Check-Out Controller_mob022	95	95	0	0	0.056	1.758	4.175	27.319	64.542	77.649	83.5	16.443	64.374
CICO_TC_Check-Out Controller_mob023	95	95	0	0	0.054	2.041	4.049	21.037	70.89	83.859	85.255	16.229	70.647
CICO_TC_Check-Out Controller_mob024	100	100	0	0	0.059	1.659	4.389	10.474	58.301	74.852	83.183	13.764	58.197
CICO_TC_Check-Out Controller_mob025	104	104	0	0	0.06	1.587	4.303	7.783	74.455	81.837	82.877	14.964	74.306
CICO_TC_Check-Out Controller_mob026	84	84	0	0	0.048	1.794	3.945	7.7	66.81	78.672	82.616	14.635	66.71
CICO_TC_Check-Out Controller_mob027	89	89	0	0	0.051	1.852	3.803	5.567	70.128	81.223	82.642	14.247	69.708
CICO_TC_Check-Out Controller_mob028	97	97	0	0	0.055	1.916	4.063	6.803	60.314	84.583	88.585	13.555	59.909
CICO_TC_Check-Out Controller_mob029	91	91	0	0	0.052	1.932	3.984	7.625	66.635	84.281	87.425	13.697	66.483
CICO_TC_Check-Out Controller_mob03	92	92	0	0	0.052	1.862	3.959	20.473	56.129	73.564	83.571	14.258	55.792
CICO_TC_Check-Out Controller_mob030	112	112	0	0	0.063	1.83	3.998	23.645	67.469	82.462	83.231	15.151	67.088
CICO_TC_Check-Out Controller_mob031	85	85	0	0	0.048	1.666	3.943	6.271	54.178	76.888	88.907	12.444	54.049
CICO_TC_Check-Out Controller_mob032	92	92	0	0	0.053	1.896	4.279	15.639	66.116	78.626	82.062	15.57	65.977
CICO_TC_Check-Out Controller_mob033	109	109	0	0	0.062	1.705	4.117	8.058	59.569	73.197	75.285	13.767	59.343
CICO_TC_Check-Out Controller_mob034	100	100	0	0	0.057	1.772	4.118	9.879	59.652	77.426	80.234	13.888	59.377
CICO_TC_Check-Out Controller_mob035	80	80	0	0	0.046	1.981	4.028	13.292	57.576	75.217	85.501	14.177	57.443
CICO_TC_Check-Out Controller_mob036	79	79	0	0	0.046	1.886	4.28	30.538	67.247	78.055	79.634	17.847	67.013
CICO_TC_Check-Out Controller_mob037	87	87	0	0	0.052	1.994	4.201	22.241	60.397	78.833	85.534	15.626	60.288
CICO_TC_Check-Out Controller_mob038	97	97	0	0	0.056	1.838	4.03	22.912	50.472	74.154	76.98	14.335	50.295
CICO_TC_Check-Out Controller_mob039	92	92	0	0	0.052	1.689	4.013	8.718	59.637	73.811	86.288	13.538	59.334
CICO_TC_Check-Out Controller_mob04	98	98	0	0	0.055	1.931	3.748	20.123	62.699	81.81	85.186	13.749	62.582
CICO_TC_Check-Out Controller_mob040	101	101	0	0	0.058	1.606	4.223	14.268	61.81	83.431	87.894	15.115	61.715
CICO_TC_Check-Out Controller_mob041	85	85	0	0	0.049	1.672	4.023	18.827	69.32	72.157	87.196	16.265	69.212
CICO_TC_Check-Out Controller_mob042	89	89	0	0	0.051	1.748	3.814	9.624	67.523	75.802	78.55	13.648	67.128
CICO_TC_Check-Out Controller_mob043	91	91	0	0	0.053	1.6	3.902	6.239	69.546	79.973	86.908	13.441	69.345
CICO_TC_Check-Out Controller_mob044	97	97	0	0	0.056	1.642	4.105	11.062	60.597	74.073	75.834	13.273	60.306
CICO_TC_Check-Out Controller_mob045	86	86	0	0	0.049	1.672	4.017	6.371	57.082	69.386	92.117	12.492	56.965
CICO_TC_Check-Out Controller_mob046	96	96	0	0	0.056	1.709	4.427	18.751	66.015	79.433	82.158	15.807	65.894
CICO_TC_Check-Out Controller_mob047	85	85	0	0	0.048	1.623	4.046	9.095	60.775	72.399	73.404	13.96	60.54
CICO_TC_Check-Out Controller_mob048	101	101	0	0	0.058	1.688	4.294	12.122	64.975	77.637	90.033	14.226	64.87
CICO_TC_Check-Out Controller_mob049	77	77	0	0	0.044	1.789	4.006	6.117	61.074	75.484	85.046	14.072	60.859
CICO_TC_Check-Out Controller_mob05	89	89	0	0	0.053	1.831	3.484	5.174	60.422	73.907	81.487	11.435	60.117
CICO_TC_Check-Out Controller_mob050	99	99	0	0	0.057	1.499	4.075	9.809	63.544	82.775	85.185	13.947	63.185
CICO_TC_Check-Out Controller_mob051	102	102	0	0	0.058	1.877	4.163	11.359	69.552	77.663	84.494	15.545	69.452
CICO_TC_Check-Out Controller_mob052	97	97	0	0	0.057	1.727	4.138	7.241	59.318	78.345	82.054	14.507	59.227
CICO_TC_Check-Out Controller_mob053	86	86	0	0	0.049	1.618	4.283	25.326	69.289	76.539	81.977	16.026	68.761
CICO_TC_Check-Out Controller_mob054	95	95	0	0	0.054	1.776	4.073	5.604	52.264	73.068	77.77	12.084	52.026
CICO_TC_Check-Out Controller_mob055	92	92	0	0	0.053	1.722	4.108	7.457	68.807	76.675	85.247	14.762	68.695
CICO_TC_Check-Out Controller_mob056	90	90	0	0	0.053	2.029	4.335	23.673	64.833	72.559	81.353	15.219	64.588
CICO_TC_Check-Out Controller_mob057	104	104	0	0	0.061	1.679	3.985	5.86	62.761	81.17	83.764	13.758	62.517
CICO_TC_Check-Out Controller_mob058	84	84	0	0	0.048	1.702	4.098	5.883	58.078	76.877	79.719	12.512	57.707
CICO_TC_Check-Out Controller_mob059	93	93	0	0	0.053	1.933	3.992	7.263	69.836	81.755	81.819	14.569	69.077
CICO_TC_Check-Out Controller_mob06	95	95	0	0	0.053	1.672	4.12	9.559	64.257	74.816	86.113	14.522	63.942
CICO_TC_Check-Out Controller_mob060	75	75	0	0	0.043	1.924	3.816	7.349	59.04	75.482	80.592	13.689	58.546
CICO_TC_Check-Out Controller_mob07	93	93	0	0	0.054	1.606	4.262	24.83	64.179	78.092	80.741	16.021	64.063
CICO_TC_Check-Out Controller_mob08	101	101	0	0	0.058	1.507	3.906	7.186	58.149	82.408	84.986	12.873	58.033
CICO_TC_Check-Out Controller_mob09	93	93	0	0	0.053	1.542	4.112	10.74	56.353	80.189	87.855	13.724	55.709

Full Data Import result table

tenant	file_name	started_date	completed_date	duration	status
fs00001137	10k_bib_Create.mrc	2024-03-12 12:09:47.259+00	2024-03-12 12:19:22.126+00	09:34.9	COMMITTED
mob01	10k_bib_Create.mrc	2024-03-12 12:11:46.396+00	2024-03-12 12:33:36.591+00	21:50.2	COMMITTED
mob02	10k_bib_Create.mrc	2024-03-12 12:13:46.278+00	2024-03-12 12:49:23.914+00	35:37.6	COMMITTED
mob03	10k_bib_Create.mrc	2024-03-12 12:15:46.327+00	2024-03-12 12:53:49.698+00	38:03.4	COMMITTED
mob04	10k_bib_Create.mrc	2024-03-12 12:17:46.295+00	2024-03-12 12:57:48.574+00	40:02.3	COMMITTED
mob05	10k_bib_Create.mrc	2024-03-12 12:19:46.281+00	2024-03-12 13:00:58.156+00	41:11.9	COMMITTED
mob06	10k_bib_Create.mrc	2024-03-12 12:21:46.257+00	2024-03-12 13:03:20.963+00	41:34.7	COMMITTED
mob07	10k_bib_Create.mrc	2024-03-12 12:23:46.282+00	2024-03-12 13:04:57.852+00	41:11.6	COMMITTED
mob08	10k_bib_Create.mrc	2024-03-12 12:25:46.588+00	2024-03-12 13:06:09.282+00	40:22.7	COMMITTED
mob09	10k_bib_Create.mrc	2024-03-12 12:27:46.365+00	2024-03-12 13:06:46.282+00	38:59.9	COMMITTED
mob010	10k_bib_Create.mrc	2024-03-12 12:29:46.253+00	2024-03-12 13:07:21.401+00	37:35.1	COMMITTED
mob011	10k_bib_Create.mrc	2024-03-12 12:31:46.563+00	2024-03-12 13:07:30.684+00	35:44.1	COMMITTED
mob012	10k_bib_Create.mrc	2024-03-12 12:33:46.387+00	2024-03-12 13:07:37.637+00	33:51.2	COMMITTED
mob013	10k_bib_Create.mrc	2024-03-12 12:35:46.255+00	2024-03-12 13:07:43.666+00	31:57.4	COMMITTED
mob014	10k_bib_Create.mrc	2024-03-12 12:37:46.312+00	2024-03-12 13:07:46.654+00	30:00.3	COMMITTED

Test №7

DB_MAXSHAREDPOOLSIZE=140 parameter for list of modules.

Requests	Total per tenant	50th pct	75th pct	95th pct	99th pct	Average	CICO Error	DI Duration	DI Error
CICO_TC_Check-In	128	1.218	1.426	5.235	15.570	1.866	0	1:44:56	PARSING	ERROR
CICO_TC_Check-Out	124	2.251	2.627	12.493	20.318	3.551	0	1:44:56	9	8

Full Check-In/Check-Out result table

Total	OK	KO	% KO	Req/s	Min	50th pct	75th pct	95th pct	99th pct	Max	Average	Latency
124	124	0	0	0.07	0.661	1.229	1.469	9.657	19.285	26.413	2.324	9.384
124	124	0	0	0.07	0.666	1.224	1.431	9.417	23.386	31.748	2.267	9.236
122	122	0	0	0.068	0.776	1.216	1.403	9.126	19.771	20.475	2.16	9.042
123	123	0	0	0.071	0.699	1.242	1.486	7.154	16.663	33.269	2.061	7.08
120	120	0	0	0.069	0.686	1.216	1.442	4.924	12.871	19.068	1.765	4.792
117	117	0	0	0.066	0.65	1.256	1.471	4.059	14.63	24.498	1.886	3.99
113	113	0	0	0.064	0.729	1.239	1.395	9.455	17.489	17.949	2.149	9.379
124	124	0	0	0.073	0.605	1.268	1.489	7.74	14.954	32.17	2.165	7.586
102	102	0	0	0.058	0.694	1.169	1.371	3.967	15.608	18.114	1.796	3.883
117	117	0	0	0.068	0.672	1.269	1.524	7.906	18.814	31.226	2.217	7.815
125	125	0	0	0.074	0.706	1.194	1.437	3.499	13.193	14.31	1.609	3.391
120	120	0	0	0.07	0.735	1.306	1.487	6.13	17.316	18.012	1.955	5.998
125	125	0	0	0.072	0.693	1.215	1.457	7.588	19.73	21.34	2.062	7.473
125	125	0	0	0.071	0.755	1.265	1.442	6.147	15.066	24.213	1.899	6.044
113	113	0	0	0.064	0.745	1.256	1.492	10.489	16.41	25.444	2.321	10.339
135	135	0	0	0.077	0.733	1.249	1.502	6.203	20.159	20.689	2.054	6.118
116	116	0	0	0.065	0.692	1.248	1.441	3.584	12.902	15.757	1.742	3.472
116	116	0	0	0.068	0.659	1.254	1.403	3.387	20.001	23.095	1.88	3.203
126	126	0	0	0.072	0.656	1.214	1.455	7.113	15.582	19.805	1.884	6.754
112	112	0	0	0.064	0.73	1.25	1.479	2.576	16.352	30.931	1.871	2.476
128	128	0	0	0.073	0.744	1.181	1.37	4.609	15.572	31.669	1.842	4.542
119	119	0	0	0.07	0.749	1.234	1.458	5.591	19.325	26.345	2.056	5.429
125	125	0	0	0.071	0.731	1.213	1.422	5.398	14.128	17.895	1.83	5.263
118	118	0	0	0.069	0.708	1.228	1.456	5.238	18.247	19.402	1.955	5.151
111	111	0	0	0.065	0.706	1.23	1.48	4.753	16.453	30.98	1.934	4.514
107	107	0	0	0.06	0.727	1.187	1.386	2.855	13.877	14.8	1.559	2.733
115	115	0	0	0.068	0.658	1.212	1.419	2.735	12.485	21.686	1.731	2.515
123	123	0	0	0.071	0.738	1.227	1.478	2.282	13.403	16.207	1.687	2.189
117	117	0	0	0.067	0.627	1.281	1.501	9.61	21.871	22.727	2.216	9.496
126	126	0	0	0.071	0.717	1.254	1.474	3.818	16.316	25.664	1.911	3.711
117	117	0	0	0.067	0.736	1.234	1.455	5.046	17.398	20.664	1.964	4.935
119	119	0	0	0.067	0.682	1.188	1.391	4.209	11.34	12.975	1.578	4.115
123	123	0	0	0.072	0.75	1.29	1.515	5.907	20.165	29.482	2.151	5.838
115	115	0	0	0.065	0.727	1.213	1.445	2.473	13.561	15.464	1.61	2.202
108	108	0	0	0.062	0.692	1.253	1.52	5.807	11.997	17.211	1.749	5.672
112	112	0	0	0.065	0.68	1.212	1.421	6.996	12.067	13.105	1.806	6.905
111	111	0	0	0.064	0.67	1.213	1.367	6.897	15.682	21.612	1.946	6.749
117	117	0	0	0.07	0.693	1.177	1.373	3.222	16.231	24.26	1.803	3.146
124	124	0	0	0.071	0.671	1.226	1.418	4.014	14.166	30.227	1.82	3.862
111	111	0	0	0.063	0.747	1.189	1.331	4.863	13.041	16.615	1.766	4.623
113	113	0	0	0.068	0.632	1.222	1.392	1.882	14.817	16.579	1.642	1.777
120	120	0	0	0.068	0.734	1.217	1.436	7.01	17.026	23.545	2.01	6.885
114	114	0	0	0.068	0.612	1.223	1.389	1.862	15.544	17.436	1.611	1.604
119	119	0	0	0.068	0.717	1.169	1.385	2.416	8.431	17.256	1.585	2.318
224	224	0	0	0.131	0.651	1.147	1.333	5.351	13.585	16.724	1.684	5.206
118	118	0	0	0.071	0.69	1.184	1.443	6.841	16.377	20.653	1.913	6.719
225	225	0	0	0.13	0.643	1.111	1.322	2.974	12.033	15.341	1.452	2.82
118	118	0	0	0.068	0.667	1.2	1.378	1.775	8.308	9.358	1.368	1.654
249	249	0	0	0.139	0.634	1.148	1.333	7.178	16.754	24.04	1.859	7.074
102	102	0	0	0.059	0.647	1.202	1.367	3.551	14.876	19.811	1.699	3.397
253	253	0	0	0.143	0.673	1.124	1.327	2.935	11.83	20.785	1.592	2.841
108	108	0	0	0.063	0.701	1.246	1.428	5.335	15.738	20.536	1.95	5.255
241	241	0	0	0.137	0.654	1.13	1.313	4.745	16.187	20.966	1.657	4.644
119	119	0	0	0.071	0.629	1.186	1.43	5.725	20.26	24.06	2.065	5.558
113	0	113	100	0	0.736	1.226	1.414	2.291	13.071	13.521	1.714	2.169
114	114	0	0	0.065	0.692	1.248	1.418	4.866	9.562	18.414	1.688	4.598
110	110	0	0	0.064	1.444	2.252	2.607	14.936	23.264	31.468	3.6	14.739
107	107	0	0	0.064	1.448	2.217	2.579	14.82	24.978	32.653	3.827	14.638
111	111	0	0	0.064	1.428	2.219	2.559	12.397	23.074	27.293	3.859	12.263
109	109	0	0	0.062	1.5	2.276	2.728	13.756	22.313	30.794	3.864	13.526
113	113	0	0	0.063	1.392	2.27	2.608	12.769	29.498	31.03	4.066	12.496
115	115	0	0	0.068	1.407	2.211	2.665	12.747	16.986	23.201	3.571	12.301
118	118	0	0	0.068	1.344	2.223	2.626	14.883	21.735	29.39	3.809	14.573
108	108	0	0	0.062	1.455	2.28	2.504	13.503	17.645	28.174	3.477	13.19
129	129	0	0	0.075	1.415	2.267	2.805	15.5	20.095	20.991	3.85	15.334
116	116	0	0	0.067	1.437	2.311	2.574	9.828	15.288	20.358	3.39	9.659
108	108	0	0	0.061	1.58	2.381	2.994	13.607	24.466	29.191	4.096	13.163
111	111	0	0	0.064	1.486	2.225	2.703	12.389	20.159	31.5	3.579	12.236
107	107	0	0	0.06	1.447	2.281	2.804	14.518	30.271	31.745	4.096	14.324
106	106	0	0	0.063	1.491	2.368	2.673	13.076	27.145	32.18	3.677	12.853
119	119	0	0	0.068	1.361	2.258	2.676	13.535	18.065	21.007	3.47	13.381
96	96	0	0	0.057	1.491	2.377	2.672	14.298	22.701	31.942	3.902	14.173
116	116	0	0	0.068	1.419	2.287	2.684	13.141	19.313	30.326	3.812	12.885
115	115	0	0	0.066	1.466	2.314	2.627	11.849	16.013	16.949	3.221	11.566
108	108	0	0	0.061	1.451	2.275	2.698	14.338	18.915	20.394	3.464	14.178
119	119	0	0	0.069	1.486	2.274	2.691	12.992	19.363	32.684	3.778	12.702
104	104	0	0	0.061	1.469	2.238	2.47	15.658	21.063	27.452	3.687	15.403
113	113	0	0	0.064	1.552	2.332	2.653	9.563	13.549	16.513	3.105	9.425
107	107	0	0	0.064	1.573	2.272	2.59	15.481	19.99	32.137	3.715	15.336
114	114	0	0	0.064	1.408	2.283	2.697	7.716	13.703	14.899	3.009	7.581
120	120	0	0	0.068	1.314	2.255	2.51	13.502	28.689	31.492	3.739	13.236
125	125	0	0	0.073	1.526	2.196	2.55	11.805	19.042	21.913	3.348	11.678
116	116	0	0	0.067	1.444	2.32	2.853	10.091	15.857	20.377	3.464	9.869
110	110	0	0	0.062	1.4	2.329	2.583	12.063	17.51	31.943	3.487	11.928
113	113	0	0	0.066	1.426	2.233	2.611	10.752	20.05	24.492	3.39	10.568
107	107	0	0	0.063	1.449	2.238	2.725	16.715	17.596	33.243	3.736	16.541
114	114	0	0	0.065	1.471	2.179	2.568	12.706	19.746	24.174	3.568	12.162
113	113	0	0	0.065	1.476	2.257	2.775	10.137	26.525	31.03	3.589	10.012
109	109	0	0	0.063	1.326	2.367	2.725	8.045	21.094	24.443	3.187	7.883
118	118	0	0	0.068	1.23	2.285	2.691	12.537	19.44	31.771	3.75	12.427
124	124	0	0	0.072	1.392	2.227	2.556	9.482	20.2	31.204	3.28	9.139
121	121	0	0	0.068	1.487	2.226	2.532	7.609	16.169	21.283	3.04	7.417
122	122	0	0	0.07	1.337	2.189	2.603	14.037	15.801	24.815	3.24	13.882
116	116	0	0	0.065	1.478	2.305	2.568	11.941	17.019	28.292	3.585	11.667
109	109	0	0	0.063	1.434	2.272	2.623	10.164	16.837	19.054	3.11	10.023
121	121	0	0	0.071	1.363	2.268	2.644	14.176	19.404	31.836	3.556	13.962
119	119	0	0	0.068	1.504	2.165	2.442	12.89	22.397	24.518	3.382	12.574
111	111	0	0	0.064	1.402	2.317	2.656	13.519	18.818	33.017	3.623	13.25
116	116	0	0	0.067	1.528	2.171	2.408	8.793	17.483	21.513	3.099	8.544
113	113	0	0	0.068	1.522	2.273	2.549	9.023	24.457	25.617	3.512	8.798
239	239	0	0	0.135	1.357	2.071	2.425	10.784	20.659	28.253	3.19	10.466
115	115	0	0	0.067	1.398	2.188	2.536	11.529	17.038	18.738	3.31	11.358
238	238	0	0	0.134	1.313	2.159	2.64	14.432	20.847	31.008	3.589	14.27
113	113	0	0	0.069	1.398	2.258	3.011	15.229	19.729	30.599	4.157	15.101
217	217	0	0	0.125	1.31	2.116	2.427	11.389	16.99	19.513	3.112	11
129	129	0	0	0.076	1.3	2.225	2.517	9.817	18.142	31.385	3.306	9.673
210	210	0	0	0.121	1.342	2.114	2.446	11.747	16.531	28.892	3.306	11.521
124	124	0	0	0.072	1.347	2.255	2.508	13.663	19.656	30.91	3.462	13.53
221	221	0	0	0.127	1.21	2.107	2.35	11.415	17.302	30.703	3.241	11.284
111	111	0	0	0.064	1.397	2.285	2.637	11.594	20.174	28.8	3.58	11.436
120	120	0	0	0.069	1.483	2.217	2.815	17.284	29.918	31.526	4.11	17.155
117	117	0	0	0.069	1.508	2.271	2.749	13.42	27.116	34.185	3.888	13.271

Full Data Import result table

tenant	file_name	started_date	completed_date	duration	status
fs00001137	10k_bib_Create.mrc	2024-03-12 18:29:30.957+00			PARSING_IN_PROGRESS
mob08	10k_bib_Create.mrc	2024-03-12 18:29:47.138+00			PARSING_IN_PROGRESS
mob01	10k_bib_Create.mrc	2024-03-12 18:31:30.217+00	2024-03-12 20:00:26.731+00	28:56.5	COMMITTED
mob012	10k_bib_Create.mrc	2024-03-12 18:31:47.046+00			PARSING_IN_PROGRESS
mob02	10k_bib_Create.mrc	2024-03-12 18:33:30.531+00			PARSING_IN_PROGRESS
mob014	10k_bib_Create.mrc	2024-03-12 18:33:47.01+00	2024-03-12 19:59:12.717+00	25:25.7	COMMITTED
mob03	10k_bib_Create.mrc	2024-03-12 18:35:30.261+00			PARSING_IN_PROGRESS
mob016	10k_bib_Create.mrc	2024-03-12 18:35:47.398+00			PARSING_IN_PROGRESS
mob04	10k_bib_Create.mrc	2024-03-12 18:37:30.349+00	2024-03-12 20:08:58.23+00	31:27.9	COMMITTED
mob018	10k_bib_Create.mrc	2024-03-12 18:37:46.953+00	2024-03-12 20:10:07.45+00	32:20.5	COMMITTED
mob05	10k_bib_Create.mrc	2024-03-12 18:39:30.257+00	2024-03-12 18:43:27.248+00	03:57.0	ERROR
mob020	10k_bib_Create.mrc	2024-03-12 18:39:47.195+00	2024-03-12 19:39:12.202+00	59:25.0	ERROR
mob06	10k_bib_Create.mrc	2024-03-12 18:41:30.417+00			PARSING_IN_PROGRESS
mob022	10k_bib_Create.mrc	2024-03-12 18:41:46.965+00	2024-03-12 19:35:23.03+00	53:36.1	ERROR
mob07	10k_bib_Create.mrc	2024-03-12 18:43:30.294+00	2024-03-12 20:11:42.865+00	28:12.6	ERROR
mob024	10k_bib_Create.mrc	2024-03-12 18:43:47.108+00	2024-03-12 19:58:46.958+00	14:59.8	ERROR
mob09	10k_bib_Create.mrc	2024-03-12 18:45:30.381+00	2024-03-12 20:13:09.569+00	27:39.2	ERROR
mob026	10k_bib_Create.mrc	2024-03-12 18:45:47.055+00	2024-03-12 20:14:17.65+00	28:30.6	COMMITTED
mob010	10k_bib_Create.mrc	2024-03-12 18:47:30.362+00			PARSING_IN_PROGRESS
mob028	10k_bib_Create.mrc	2024-03-12 18:47:46.92+00	2024-03-12 20:13:30.698+00	25:43.8	COMMITTED
mob011	10k_bib_Create.mrc	2024-03-12 18:49:30.287+00	2024-03-12 20:13:51.088+00	24:20.8	COMMITTED
mob030	10k_bib_Create.mrc	2024-03-12 18:49:46.929+00	2024-03-12 19:41:24.952+00	51:38.0	ERROR
mob013	10k_bib_Create.mrc	2024-03-12 18:51:30.279+00	2024-03-12 20:13:49.265+00	22:19.0	COMMITTED
mob032	10k_bib_Create.mrc	2024-03-12 18:51:47.087+00	2024-03-12 20:13:44.873+00	21:57.8	COMMITTED
mob015	10k_bib_Create.mrc	2024-03-12 18:53:30.319+00	2024-03-12 20:14:29.614+00	20:59.3	COMMITTED
mob034	10k_bib_Create.mrc	2024-03-12 18:53:46.894+00	2024-03-12 20:14:30.311+00	20:43.4	COMMITTED
mob017	10k_bib_Create.mrc	2024-03-12 18:55:30.268+00	2024-03-12 20:14:02.733+00	18:32.5	COMMITTED
mob036	10k_bib_Create.mrc	2024-03-12 18:55:46.984+00	2024-03-12 20:14:28.876+00	18:41.9	ERROR
mob019	10k_bib_Create.mrc	2024-03-12 18:57:30.422+00			PARSING_IN_PROGRESS
mob038	10k_bib_Create.mrc	2024-03-12 18:57:47.75+00	2024-03-12 20:14:26.943+00	16:39.2	COMMITTED

Test №8

DB_MAXSHAREDPOOLSIZE=210 parameter for list of modules.

Requests	Total per tenant	50th pct	75th pct	95th pct	99th pct	Average	CICO Error	DI Duration	DI Error
CICO_TC_Check-In	146	1.251	1.444	10.652	26.565	2.568	40	2:07:05	PARSING	ERROR
CICO_TC_Check-Out	143	2.302	2.795	18.382	32.563	4.760	7	2:07:05	2	3

Full Check-In/Check-Out result table

Requests	Total	OK	KO	% KO	Req/s	Min	50th pct	75th pct	95th pct	99th pct	Max	Average	Latency
CICO_TC_Check-In Controller_mob01	108	107	1	0.926	0.061	0.842	1.306	1.45	14.313	24.466	29.918	2.438	14.222
CICO_TC_Check-In Controller_mob011	111	111	0	0	0.065	0.836	1.301	1.445	11.735	21.629	27.314	2.609	11.583
CICO_TC_Check-In Controller_mob013	113	113	0	0	0.064	0.894	1.31	1.502	11.506	26.03	27.5	2.452	11.381
CICO_TC_Check-In Controller_mob015	121	121	0	0	0.068	0.857	1.27	1.547	13.34	30.398	40.382	2.978	13.197
CICO_TC_Check-In Controller_mob017	123	123	0	0	0.071	0.888	1.285	1.447	9.318	19.031	35.671	2.294	9.242
CICO_TC_Check-In Controller_mob019	112	112	0	0	0.063	0.88	1.218	1.383	5.181	25.327	36.116	2.271	5.055
CICO_TC_Check-In Controller_mob021	112	111	1	0.893	0.065	0.76	1.259	1.415	2.346	24.792	36.957	2.214	2.208
CICO_TC_Check-In Controller_mob023	102	102	0	0	0.061	0.885	1.22	1.342	1.714	17.651	30.358	1.937	1.638
CICO_TC_Check-In Controller_mob024	125	124	1	0.8	0.071	0.896	1.292	1.491	15.615	38.23	42.647	3.188	15.526
CICO_TC_Check-In Controller_mob025	98	98	0	0	0.055	0.863	1.234	1.441	6.142	18.624	35.284	2.245	6.027
CICO_TC_Check-In Controller_mob027	111	111	0	0	0.063	0.959	1.292	1.436	12.138	24.74	39.782	2.548	12.031
CICO_TC_Check-In Controller_mob028	115	113	2	1.739	0.067	0.87	1.281	1.502	9.142	25.511	32.646	2.605	9.07
CICO_TC_Check-In Controller_mob029	121	120	1	0.826	0.069	0.901	1.265	1.472	10.131	29.445	30.063	2.685	9.999
CICO_TC_Check-In Controller_mob03	117	116	1	0.855	0.067	0.854	1.226	1.409	8.549	24.108	25.873	2.218	8.431
CICO_TC_Check-In Controller_mob030	124	123	1	0.806	0.073	0.902	1.288	1.529	13.022	27.075	38.847	2.908	12.904
CICO_TC_Check-In Controller_mob031	110	109	1	0.909	0.063	0.929	1.272	1.48	15.002	24.746	28.897	2.835	14.88
CICO_TC_Check-In Controller_mob032	115	113	2	1.739	0.066	0.843	1.256	1.506	15.272	25.715	33.451	3.003	15.199
CICO_TC_Check-In Controller_mob033	114	114	0	0	0.065	0.869	1.206	1.392	4.528	19.249	25.907	1.929	4.433
CICO_TC_Check-In Controller_mob034	117	115	2	1.709	0.067	0.879	1.261	1.531	12.823	32.672	37.325	2.824	12.738
CICO_TC_Check-In Controller_mob035	112	111	1	0.893	0.065	0.782	1.276	1.469	15.312	28.857	35.185	3.165	15.23
CICO_TC_Check-In Controller_mob036	244	242	2	0.82	0.136	0.835	1.204	1.398	14.516	29.997	33.243	2.625	14.432
CICO_TC_Check-In Controller_mob037	120	119	1	0.833	0.07	0.937	1.27	1.473	10.548	22.429	25.388	2.306	10.441
CICO_TC_Check-In Controller_mob038	214	213	1	0.467	0.119	0.846	1.202	1.351	11.683	25.298	29.38	2.495	11.602
CICO_TC_Check-In Controller_mob039	122	122	0	0	0.073	0.854	1.258	1.439	5.373	18.702	25.393	2.073	5.238
CICO_TC_Check-In Controller_mob040	238	236	2	0.84	0.133	0.807	1.175	1.353	9.996	24.984	38.73	2.279	9.837
CICO_TC_Check-In Controller_mob041	111	110	1	0.901	0.065	0.863	1.305	1.498	10.682	26.865	29.3	2.766	10.594
CICO_TC_Check-In Controller_mob042	221	220	1	0.452	0.126	0.776	1.188	1.391	14.109	24.547	39.482	2.478	14.027
CICO_TC_Check-In Controller_mob043	107	107	0	0	0.062	0.902	1.294	1.492	15.412	25.08	29.934	2.807	15.31
CICO_TC_Check-In Controller_mob044	231	229	2	0.866	0.132	0.73	1.206	1.368	11.593	28.15	38.307	2.649	11.514
CICO_TC_Check-In Controller_mob045	110	110	0	0	0.063	0.826	1.302	1.474	14.099	30.243	39.557	2.768	14.037
CICO_TC_Check-In Controller_mob046	234	233	1	0.427	0.135	0.78	1.208	1.397	9.388	25.382	39.964	2.414	9.284
CICO_TC_Check-In Controller_mob047	111	111	0	0	0.063	0.828	1.27	1.502	5.408	28.57	34.709	2.331	5.294
CICO_TC_Check-In Controller_mob048	231	230	1	0.433	0.131	0.851	1.183	1.366	7.579	24.956	39.625	2.292	7.48
CICO_TC_Check-In Controller_mob049	115	114	1	0.87	0.066	0.927	1.299	1.424	5.063	18.287	26.453	2.108	4.97
CICO_TC_Check-In Controller_mob05	112	112	0	0	0.063	0.842	1.329	1.446	6.55	36.397	40.843	2.657	6.449
CICO_TC_Check-In Controller_mob050	230	228	2	0.87	0.128	0.809	1.155	1.344	12.264	31.676	37.908	2.611	12.168
CICO_TC_Check-In Controller_mob051	113	111	2	1.77	0.064	0.908	1.283	1.535	12.409	25.145	39.98	2.923	12.317
CICO_TC_Check-In Controller_mob052	227	226	1	0.441	0.127	0.827	1.192	1.32	10.545	38.669	41.088	2.585	10.433
CICO_TC_Check-In Controller_mob053	118	117	1	0.847	0.07	0.902	1.248	1.491	7.393	21.486	25.202	2.342	7.234
CICO_TC_Check-In Controller_mob054	240	240	0	0	0.137	0.819	1.19	1.365	9.688	27.279	39.097	2.354	9.594
CICO_TC_Check-In Controller_mob055	102	102	0	0	0.058	0.849	1.331	1.557	17.188	32.881	34.579	3.5	17.075
CICO_TC_Check-In Controller_mob056	238	237	1	0.42	0.133	0.83	1.176	1.394	11.935	25.796	26.564	2.418	11.855
CICO_TC_Check-In Controller_mob057	127	126	1	0.787	0.074	0.892	1.287	1.567	12.918	33.412	40.047	2.886	12.837
CICO_TC_Check-In Controller_mob058	238	235	3	1.261	0.133	0.804	1.167	1.313	13.842	31.523	37.623	2.598	13.76
CICO_TC_Check-In Controller_mob059	114	113	1	0.877	0.067	0.882	1.221	1.448	8.36	28.572	34.085	2.506	8.229
CICO_TC_Check-In Controller_mob060	233	233	0	0	0.131	0.784	1.197	1.414	14.089	27.534	39.382	2.826	14.002
CICO_TC_Check-In Controller_mob07	116	116	0	0	0.067	0.862	1.316	1.506	7.544	21.257	36.049	2.466	7.435
CICO_TC_Check-In Controller_mob09	115	114	1	0.87	0.065	0.911	1.291	1.479	13.991	31.694	37.273	2.834	13.902
CICO_TC_Check-Out Controller_mob01	120	120	0	0	0.07	1.593	2.439	3.995	18.993	38.345	42.393	5.653	18.852
CICO_TC_Check-Out Controller_mob011	116	116	0	0	0.066	1.832	2.377	2.769	19.478	28.879	32.994	4.838	19.339
CICO_TC_Check-Out Controller_mob013	114	114	0	0	0.066	1.808	2.421	3.141	21.472	32.047	35.026	5.412	21.29
CICO_TC_Check-Out Controller_mob015	106	106	0	0	0.063	1.717	2.382	2.785	16.621	38.719	49.961	5.049	16.474
CICO_TC_Check-Out Controller_mob017	104	104	0	0	0.059	1.71	2.443	4.569	21.76	29.599	35.269	5.375	21.653
CICO_TC_Check-Out Controller_mob019	115	115	0	0	0.066	1.567	2.361	2.785	18.337	30.686	33.744	4.905	18.156
CICO_TC_Check-Out Controller_mob021	115	115	0	0	0.065	1.662	2.37	2.771	18.851	27.744	36.154	4.829	18.668
CICO_TC_Check-Out Controller_mob023	124	124	0	0	0.07	1.651	2.373	2.861	18.476	33.739	38.107	4.778	18.374
CICO_TC_Check-Out Controller_mob024	103	103	0	0	0.057	1.781	2.341	2.983	16.867	34.488	38.555	5.097	16.741
CICO_TC_Check-Out Controller_mob025	130	130	0	0	0.077	1.679	2.308	2.672	17.42	32.301	38.565	4.437	17.284
CICO_TC_Check-Out Controller_mob027	116	116	0	0	0.068	1.615	2.345	2.751	20.447	36.362	43.593	5.037	20.287
CICO_TC_Check-Out Controller_mob028	114	114	0	0	0.064	1.775	2.317	2.829	16.437	33.925	34.775	4.728	16.267
CICO_TC_Check-Out Controller_mob029	105	104	1	0.952	0.061	1.776	2.364	2.737	22.834	34.576	36.185	5.091	22.687
CICO_TC_Check-Out Controller_mob03	111	111	0	0	0.063	1.67	2.373	2.719	17.322	34.593	36.845	5.275	17.207
CICO_TC_Check-Out Controller_mob030	104	104	0	0	0.058	1.743	2.463	2.897	15.239	23.262	23.909	4.415	15.103
CICO_TC_Check-Out Controller_mob031	116	115	1	0.862	0.068	1.792	2.326	2.61	18.171	33.656	34.647	4.345	18.021
CICO_TC_Check-Out Controller_mob032	113	113	0	0	0.063	1.628	2.328	2.737	17.102	41.184	42.34	4.87	16.999
CICO_TC_Check-Out Controller_mob033	113	113	0	0	0.065	1.707	2.316	2.753	20.141	27.154	33.283	4.818	20.004
CICO_TC_Check-Out Controller_mob034	110	110	0	0	0.062	1.615	2.356	2.818	15.611	32.629	42.053	4.169	15.501
CICO_TC_Check-Out Controller_mob035	115	114	1	0.87	0.066	1.797	2.296	2.59	17.017	31.496	34.957	4.528	16.903
CICO_TC_Check-Out Controller_mob036	210	210	0	0	0.119	1.635	2.212	2.474	17.223	33.305	41.164	4.283	17.07
CICO_TC_Check-Out Controller_mob037	107	107	0	0	0.061	1.699	2.352	2.896	20.209	32.847	34.675	5.071	20.087
CICO_TC_Check-Out Controller_mob038	242	242	0	0	0.14	1.603	2.155	2.416	14.323	33.78	37.564	4.261	14.223
CICO_TC_Check-Out Controller_mob039	106	106	0	0	0.061	1.669	2.349	2.681	21.294	26.244	28.695	4.449	21.173
CICO_TC_Check-Out Controller_mob040	217	217	0	0	0.125	1.636	2.212	2.65	17.859	34.496	37.378	4.722	17.745
CICO_TC_Check-Out Controller_mob041	117	117	0	0	0.067	1.54	2.282	2.664	16.605	27.26	29.992	4.462	16.457
CICO_TC_Check-Out Controller_mob042	232	232	0	0	0.13	1.62	2.208	2.656	20.693	32.989	35.494	4.739	20.564
CICO_TC_Check-Out Controller_mob043	119	119	0	0	0.068	1.718	2.269	2.623	20.403	30.026	34.625	4.681	20.215
CICO_TC_Check-Out Controller_mob044	222	222	0	0	0.124	1.553	2.197	2.581	16.481	33.325	37.195	4.398	16.342
CICO_TC_Check-Out Controller_mob045	117	117	0	0	0.071	1.739	2.355	2.809	21.233	36.442	44.189	5.538	21.078
CICO_TC_Check-Out Controller_mob046	221	221	0	0	0.124	1.597	2.131	2.521	17.465	36.472	42.152	4.605	17.302
CICO_TC_Check-Out Controller_mob047	116	116	0	0	0.07	1.696	2.341	2.779	18.806	33.12	34.235	4.978	18.696
CICO_TC_Check-Out Controller_mob048	225	225	0	0	0.126	1.571	2.212	2.758	18.16	32.344	33.328	4.71	18.05
CICO_TC_Check-Out Controller_mob049	112	112	0	0	0.064	1.59	2.366	3.915	18.52	26.989	34.289	5.294	18.385
CICO_TC_Check-Out Controller_mob05	117	117	0	0	0.07	1.777	2.423	2.856	17.792	30.359	31.972	4.596	17.641
CICO_TC_Check-Out Controller_mob050	224	223	1	0.446	0.131	1.575	2.124	2.451	17.424	35.143	42.764	4.159	17.253
CICO_TC_Check-Out Controller_mob051	114	114	0	0	0.066	1.774	2.311	2.658	16.535	28.792	42.849	4.503	16.411
CICO_TC_Check-Out Controller_mob052	227	226	1	0.441	0.131	1.685	2.155	2.469	17.776	26.015	36.286	4.469	17.607
CICO_TC_Check-Out Controller_mob053	109	108	1	0.917	0.062	1.538	2.332	2.97	21.56	37.238	48.643	5.642	21.42
CICO_TC_Check-Out Controller_mob054	215	215	0	0	0.121	1.616	2.215	2.67	16.666	35.175	38.158	4.451	16.522
CICO_TC_Check-Out Controller_mob055	125	124	1	0.8	0.073	1.519	2.273	2.859	22.71	40.258	42.121	5.562	22.575
CICO_TC_Check-Out Controller_mob056	218	218	0	0	0.126	1.547	2.179	2.473	17.95	32.773	34.101	4.538	17.83
CICO_TC_Check-Out Controller_mob057	99	99	0	0	0.057	1.689	2.313	2.593	16.943	34.136	35.853	4.137	16.814
CICO_TC_Check-Out Controller_mob058	216	216	0	0	0.124	1.682	2.135	2.498	17.903	33.878	37.537	4.611	17.758
CICO_TC_Check-Out Controller_mob059	111	111	0	0	0.065	1.664	2.287	2.537	17.639	26.988	27.437	4.176	17.524
CICO_TC_Check-Out Controller_mob060	220	220	0	0	0.126	1.553	2.156	2.575	16.865	27.046	44.952	4.264	16.748
CICO_TC_Check-Out Controller_mob07	113	113	0	0	0.064	1.89	2.341	2.78	17.811	34.883	38.588	4.63	17.687
CICO_TC_Check-Out Controller_mob09	111	110	1	0.901	0.066	1.81	2.317	2.588	18.903	35.295	37.878	4.913	18.692

Full Data Import result table

tenant	file_name	started_date	completed_date	duration	status
fs00001137	10k_bib_Create.mrc	2024-03-13 17:53:06.169+00	2024-03-13 19:25:17.349+00	32:11.2	COMMITTED
mob024	10k_bib_Create.mrc	2024-03-13 17:53:41.965+00	2024-03-13 19:46:02.299+00	52:20.3	COMMITTED
mob01	10k_bib_Create.mrc	2024-03-13 17:55:05.7+00	2024-03-13 19:52:43.748+00	57:38.0	COMMITTED
mob028	10k_bib_Create.mrc	2024-03-13 17:55:41.811+00	2024-03-13 19:46:06.566+00	50:24.8	COMMITTED
mob02	10k_bib_Create.mrc	2024-03-13 17:57:05.701+00	2024-03-13 19:55:24.617+00	58:18.9	COMMITTED
mob030	10k_bib_Create.mrc	2024-03-13 17:57:41.935+00	2024-03-13 19:48:22.924+00	50:41.0	COMMITTED
mob03	10k_bib_Create.mrc	2024-03-13 17:59:05.207+00	2024-03-13 19:56:27.568+00	57:22.4	COMMITTED
mob032	10k_bib_Create.mrc	2024-03-13 17:59:41.856+00	2024-03-13 19:54:29.564+00	54:47.7	COMMITTED
mob04	10k_bib_Create.mrc	2024-03-13 18:01:05.406+00	2024-03-13 18:16:57.685+00	15:52.3	ERROR
mob034	10k_bib_Create.mrc	2024-03-13 18:01:41.754+00	2024-03-13 19:59:06.644+00	57:24.9	COMMITTED
mob05	10k_bib_Create.mrc	2024-03-13 18:03:05.319+00	2024-03-13 19:58:33.715+00	55:28.4	COMMITTED
mob036	10k_bib_Create.mrc	2024-03-13 18:03:41.787+00			PARSING_IN_PROGRESS
mob06	10k_bib_Create.mrc	2024-03-13 18:05:05.28+00	2024-03-13 19:53:49.771+00	48:44.5	COMMITTED
mob038	10k_bib_Create.mrc	2024-03-13 18:05:41.742+00	2024-03-13 19:59:13.742+00	1:53:32	COMMITTED
mob07	10k_bib_Create.mrc	2024-03-13 18:07:04.985+00	2024-03-13 19:59:53.324+00	52:48.3	COMMITTED
mob040	10k_bib_Create.mrc	2024-03-13 18:07:41.747+00	2024-03-13 19:59:46.375+00	52:04.6	COMMITTED
mob08	10k_bib_Create.mrc	2024-03-13 18:09:05.487+00	2024-03-13 20:00:09.34+00	51:03.9	COMMITTED
mob042	10k_bib_Create.mrc	2024-03-13 18:09:41.788+00	2024-03-13 19:58:28.944+00	48:47.2	ERROR
mob09	10k_bib_Create.mrc	2024-03-13 18:11:04.97+00	2024-03-13 20:00:19.943+00	49:15.0	COMMITTED
mob044	10k_bib_Create.mrc	2024-03-13 18:11:41.786+00	2024-03-13 19:59:41.842+00	48:00.1	COMMITTED
mob010	10k_bib_Create.mrc	2024-03-13 18:13:05.518+00	2024-03-13 19:59:46.676+00	46:41.2	COMMITTED
mob046	10k_bib_Create.mrc	2024-03-13 18:13:41.719+00	2024-03-13 20:00:07.012+00	46:25.3	ERROR
mob011	10k_bib_Create.mrc	2024-03-13 18:15:04.959+00			PARSING_IN_PROGRESS
mob048	10k_bib_Create.mrc	2024-03-13 18:15:46.582+00	2024-03-13 20:00:12.714+00	44:26.1	COMMITTED
mob012	10k_bib_Create.mrc	2024-03-13 18:17:05.341+00	2024-03-13 20:00:13.901+00	43:08.6	COMMITTED
mob050	10k_bib_Create.mrc	2024-03-13 18:17:43.146+00	2024-03-13 20:00:05.371+00	42:22.2	COMMITTED
mob013	10k_bib_Create.mrc	2024-03-13 18:19:05.006+00	2024-03-13 20:00:03.235+00	40:58.2	COMMITTED
mob052	10k_bib_Create.mrc	2024-03-13 18:19:53.569+00	2024-03-13 20:00:17.81+00	40:24.2	COMMITTED
mob014	10k_bib_Create.mrc	2024-03-13 18:21:05.348+00	2024-03-13 20:00:19.725+00	39:14.4	COMMITTED
mob054	10k_bib_Create.mrc	2024-03-13 18:21:41.689+00	2024-03-13 20:00:11.693+00	38:30.0	COMMITTED

Test №9

DB_MAXSHAREDPOOLSIZE=210 for mod-invetory-storage plus DB_MAXSHAREDPOOLSIZE=70 parameter for others modules

Requests	Total per tenant	50th pct	75th pct	95th pct	99th pct	Average	CICO Error	DI Duration	DI Error
CICO_TC_Check-In	94	1.15	1.35	48.75	82.41	7.33	0	1:46:43	PARSING	ERROR
CICO_TC_Check-Out	94	2.18	12.34	66.22	103.74	14.43	1	1:46:43	4	4

Full Check-In/Check-Out result table

Requests	Total	OK	KO	% KO	Req/s	Min	50th pct	75th pct	95th pct	99th pct	Max	Average	Latency
CICO_TC_Check-In Controller_fs00001137	91	91	0	0	0.052	0.866	1.483	1.822	43.553	80.528	97.128	6.398	43.451
CICO_TC_Check-In Controller_mob01	99	99	0	0	0.057	0.774	1.135	1.347	49.584	77.934	98.945	6.159	49.481
CICO_TC_Check-In Controller_mob010	88	88	0	0	0.051	0.758	1.161	1.327	43.459	69.67	102.523	6.478	43.392
CICO_TC_Check-In Controller_mob011	90	90	0	0	0.05	0.832	1.165	1.416	51.735	76.271	110.225	7.175	51.644
CICO_TC_Check-In Controller_mob012	90	90	0	0	0.057	0.763	1.169	1.355	47.079	56.168	63.626	5.707	46.981
CICO_TC_Check-In Controller_mob013	91	91	0	0	0.053	0.835	1.193	1.459	50.447	109.062	113.585	9.399	50.342
CICO_TC_Check-In Controller_mob014	91	91	0	0	0.053	0.784	1.175	1.345	51.093	70.351	100.63	7.571	50.996
CICO_TC_Check-In Controller_mob015	98	98	0	0	0.055	0.743	1.126	1.351	56.576	104.794	107.844	8.789	56.464
CICO_TC_Check-In Controller_mob016	93	93	0	0	0.053	0.877	1.137	1.363	54.463	72.039	96.926	8.875	54.353
CICO_TC_Check-In Controller_mob017	96	96	0	0	0.054	0.845	1.135	1.449	49.952	100.681	109.314	7.716	49.858
CICO_TC_Check-In Controller_mob018	94	94	0	0	0.053	0.856	1.136	1.29	49.309	76.711	101.143	7.07	49.234
CICO_TC_Check-In Controller_mob019	98	98	0	0	0.055	0.791	1.176	1.331	50.039	102.326	109.247	6.909	49.947
CICO_TC_Check-In Controller_mob02	88	88	0	0	0.049	0.743	1.19	1.541	56.141	65.09	114.061	9.397	55.974
CICO_TC_Check-In Controller_mob020	98	98	0	0	0.056	0.855	1.147	1.356	46.009	57.753	92.57	7.264	45.938
CICO_TC_Check-In Controller_mob021	99	99	0	0	0.06	0.779	1.151	1.273	31.458	64.914	68.905	4.71	31.374
CICO_TC_Check-In Controller_mob022	80	80	0	0	0.045	0.806	1.175	1.345	40.553	106.055	114.907	7.517	40.449
CICO_TC_Check-In Controller_mob023	86	86	0	0	0.05	0.75	1.147	1.308	60.152	74.814	102.713	7.445	60.059
CICO_TC_Check-In Controller_mob024	102	102	0	0	0.058	0.752	1.115	1.302	58.405	77.764	101.88	8.269	58.33
CICO_TC_Check-In Controller_mob025	102	102	0	0	0.058	0.791	1.133	1.401	60.345	94.124	104.129	9.916	60.255
CICO_TC_Check-In Controller_mob026	87	87	0	0	0.052	0.816	1.146	1.305	44.05	70.201	105.574	5.917	43.972
CICO_TC_Check-In Controller_mob027	97	97	0	0	0.058	0.786	1.139	1.276	51.407	67.794	108.914	7.135	51.334
CICO_TC_Check-In Controller_mob028	92	92	0	0	0.052	0.75	1.156	1.354	47.651	104.758	110.514	7.86	47.56
CICO_TC_Check-In Controller_mob029	101	101	0	0	0.064	0.792	1.112	1.265	34.416	57.4	77.789	5.134	34.336
CICO_TC_Check-In Controller_mob03	99	99	0	0	0.055	0.832	1.139	1.325	50.446	75.364	103.96	6.961	50.349
CICO_TC_Check-In Controller_mob030	93	93	0	0	0.058	0.815	1.169	1.289	29.228	58.625	64.855	4.803	29.139
CICO_TC_Check-In Controller_mob031	84	84	0	0	0.052	0.798	1.115	1.306	33.229	63.515	75.619	5.205	33.131
CICO_TC_Check-In Controller_mob032	86	86	0	0	0.05	0.784	1.143	1.354	40.477	105.459	109.787	7.251	40.403
CICO_TC_Check-In Controller_mob033	95	95	0	0	0.054	0.763	1.164	1.39	56.936	102.884	104.937	7.838	56.848
CICO_TC_Check-In Controller_mob034	103	103	0	0	0.06	0.846	1.181	1.467	41.357	71.89	101.154	7.212	41.284
CICO_TC_Check-In Controller_mob035	97	97	0	0	0.056	0.751	1.135	1.297	49.307	72.178	101.844	7.014	49.174
CICO_TC_Check-In Controller_mob036	109	109	0	0	0.062	0.8	1.14	1.381	33.426	101.246	109.13	5.442	33.351
CICO_TC_Check-In Controller_mob037	83	83	0	0	0.048	0.848	1.103	1.21	47.141	108.457	117.113	6.403	47.008
CICO_TC_Check-In Controller_mob038	98	98	0	0	0.056	0.752	1.129	1.313	43.389	98.488	111.705	7.157	43.286
CICO_TC_Check-In Controller_mob039	81	81	0	0	0.046	0.804	1.136	1.415	53.931	58.675	117.954	8.559	53.84
CICO_TC_Check-In Controller_mob04	101	101	0	0	0.059	0.781	1.185	1.398	38.477	54.931	108.747	6.611	38.397
CICO_TC_Check-In Controller_mob040	89	89	0	0	0.052	0.804	1.129	1.339	59.011	101.067	109.718	8.688	58.884
CICO_TC_Check-In Controller_mob041	92	92	0	0	0.054	0.821	1.138	1.361	56.278	82.948	91.682	8.581	56.177
CICO_TC_Check-In Controller_mob042	91	91	0	0	0.053	0.812	1.168	1.333	43.895	60.412	96.218	7.002	43.806
CICO_TC_Check-In Controller_mob043	88	88	0	0	0.052	0.815	1.103	1.352	56.648	96.393	118.336	8.399	56.546
CICO_TC_Check-In Controller_mob044	100	100	0	0	0.057	0.803	1.082	1.244	44.611	95.473	99.405	6.587	44.522
CICO_TC_Check-In Controller_mob045	95	95	0	0	0.054	0.834	1.112	1.276	59.815	101.146	119.316	8.011	59.717
CICO_TC_Check-In Controller_mob046	99	99	0	0	0.057	0.807	1.117	1.256	63.638	93.283	95.213	8.73	63.508
CICO_TC_Check-In Controller_mob047	100	100	0	0	0.058	0.803	1.121	1.269	52.369	67.161	109.405	7.492	52.272
CICO_TC_Check-In Controller_mob048	102	102	0	0	0.058	0.739	1.086	1.199	60.717	102.274	109.761	7.34	60.608
CICO_TC_Check-In Controller_mob049	93	93	0	0	0.053	0.89	1.118	1.263	41.02	76.911	89.362	7.095	40.923
CICO_TC_Check-In Controller_mob05	99	99	0	0	0.055	0.739	1.199	1.417	46.224	79.49	107.372	6.889	46.142
CICO_TC_Check-In Controller_mob050	84	84	0	0	0.048	0.824	1.149	1.381	60.604	86.997	114.845	8.696	60.521
CICO_TC_Check-In Controller_mob051	94	94	0	0	0.054	0.814	1.123	1.331	49.458	103.423	111.774	7.436	49.355
CICO_TC_Check-In Controller_mob052	94	94	0	0	0.054	0.832	1.107	1.283	39.637	60.963	103.93	5.929	39.561
CICO_TC_Check-In Controller_mob053	80	80	0	0	0.046	0.812	1.113	1.357	62.663	103.182	112.129	8.5	62.566
CICO_TC_Check-In Controller_mob054	98	98	0	0	0.056	0.793	1.111	1.34	54.804	79.036	101.896	7.949	54.705
CICO_TC_Check-In Controller_mob055	96	96	0	0	0.055	0.815	1.123	1.306	60.716	107.126	109.857	7.854	60.597
CICO_TC_Check-In Controller_mob056	89	89	0	0	0.052	0.784	1.125	1.329	52.774	80.223	113.273	8.837	52.679
CICO_TC_Check-In Controller_mob057	107	107	0	0	0.064	0.821	1.16	1.447	53.057	64.648	97.692	7.683	52.965
CICO_TC_Check-In Controller_mob058	99	99	0	0	0.062	0.77	1.141	1.273	38.519	59.375	69.978	5.719	38.446
CICO_TC_Check-In Controller_mob059	93	93	0	0	0.053	0.728	1.123	1.348	34.19	55.942	110.482	5.552	34.119
CICO_TC_Check-In Controller_mob06	101	101	0	0	0.06	0.745	1.156	1.356	48.953	101.423	117.005	6.956	48.845
CICO_TC_Check-In Controller_mob060	81	81	0	0	0.047	0.834	1.106	1.247	36.724	65.486	110.203	6.689	36.649
CICO_TC_Check-In Controller_mob07	93	93	0	0	0.052	0.768	1.154	1.33	63.73	103.606	110.974	9.523	63.647
CICO_TC_Check-In Controller_mob08	97	0	97	100	0	0.802	1.158	1.434	63.299	96.695	108.29	10.376	63.168
CICO_TC_Check-In Controller_mob09	97	97	0	0	0.059	0.876	1.186	1.31	25.468	93.611	95.031	5.171	25.372
CICO_TC_Check-Out Controller_fs00001137	97	96	1	1.031	0.054	1.91	3.115	19.454	62.482	107.238	129.18	16.286	62.312
CICO_TC_Check-Out Controller_mob01	88	88	0	0	0.049	1.575	2.22	9.112	66.903	112.9	113.681	15.191	66.756
CICO_TC_Check-Out Controller_mob010	101	101	0	0	0.056	1.633	2.272	28.844	82.398	113.273	117.208	17.594	82.264
CICO_TC_Check-Out Controller_mob011	98	98	0	0	0.058	1.469	2.17	3.437	63.115	111.783	120.177	14.463	62.988
CICO_TC_Check-Out Controller_mob012	99	99	0	0	0.055	1.55	2.345	29.075	94.577	118.838	121.927	19.869	94.48
CICO_TC_Check-Out Controller_mob013	98	98	0	0	0.055	1.567	2.282	3.806	62.381	120.062	120.301	13.179	62.277
CICO_TC_Check-Out Controller_mob014	98	98	0	0	0.055	1.631	2.341	26.856	59.455	110.692	120.399	15.726	59.32
CICO_TC_Check-Out Controller_mob015	91	91	0	0	0.052	1.469	2.103	3.547	61.847	82.478	105.566	13.291	61.718
CICO_TC_Check-Out Controller_mob016	96	96	0	0	0.057	1.471	2.179	12.01	70.989	107.177	108.181	14.128	70.84
CICO_TC_Check-Out Controller_mob017	93	93	0	0	0.053	1.508	2.174	3.992	58.948	106.773	118.841	12.708	58.826
CICO_TC_Check-Out Controller_mob018	94	94	0	0	0.055	1.565	2.169	20.897	64.484	111.967	118.5	14.935	64.352
CICO_TC_Check-Out Controller_mob019	89	89	0	0	0.052	1.552	2.227	18.678	66.375	69.423	110.999	14.611	66.223
CICO_TC_Check-Out Controller_mob02	99	99	0	0	0.057	1.55	2.125	2.449	57.217	105.035	105.416	9.94	57.097
CICO_TC_Check-Out Controller_mob020	91	91	0	0	0.053	1.551	2.269	8.062	68.931	111.684	111.908	15.703	68.796
CICO_TC_Check-Out Controller_mob021	90	90	0	0	0.053	1.51	2.18	20.804	74.462	109.741	111.076	16.2	74.296
CICO_TC_Check-Out Controller_mob022	107	107	0	0	0.062	1.528	2.138	16.638	61.888	111.389	113.356	13.906	61.58
CICO_TC_Check-Out Controller_mob023	103	103	0	0	0.058	1.566	2.19	17.897	72.122	120.188	124.708	15.803	71.971
CICO_TC_Check-Out Controller_mob024	86	86	0	0	0.052	1.65	2.164	3.071	56.693	104.241	116.64	12.077	56.587
CICO_TC_Check-Out Controller_mob025	86	86	0	0	0.053	1.445	2.115	2.634	54.445	65.676	67.183	10.543	54.311
CICO_TC_Check-Out Controller_mob026	102	102	0	0	0.057	1.56	2.207	22.523	62.595	99.531	111.466	15.066	62.428
CICO_TC_Check-Out Controller_mob027	90	90	0	0	0.051	1.429	2.196	18.01	70.816	110.202	122.748	15.106	70.617
CICO_TC_Check-Out Controller_mob028	96	96	0	0	0.059	1.628	2.164	5.415	59.787	101.978	117.512	13.49	59.656
CICO_TC_Check-Out Controller_mob029	85	85	0	0	0.048	1.579	2.156	19.195	61.306	109.913	112.557	14.016	61.163
CICO_TC_Check-Out Controller_mob03	90	90	0	0	0.052	1.546	2.135	12.861	76.509	105.133	113.07	15.688	76.335
CICO_TC_Check-Out Controller_mob030	95	95	0	0	0.054	1.489	2.133	24.586	61.109	105.032	111.024	16.319	60.964
CICO_TC_Check-Out Controller_mob031	104	104	0	0	0.059	1.485	2.218	15.074	70.76	107.299	119.224	15.354	70.616
CICO_TC_Check-Out Controller_mob032	102	102	0	0	0.058	1.493	2.163	17.187	65.396	100.064	114.668	14.847	65.279
CICO_TC_Check-Out Controller_mob033	93	93	0	0	0.054	1.458	2.203	7.654	78.714	110.925	117.448	15.944	78.557
CICO_TC_Check-Out Controller_mob034	86	86	0	0	0.049	1.535	2.176	5.629	69.891	109.887	112.148	15.81	69.756
CICO_TC_Check-Out Controller_mob035	91	91	0	0	0.054	1.468	2.18	14.852	60.723	97.86	111.996	15.032	60.582
CICO_TC_Check-Out Controller_mob036	79	79	0	0	0.046	1.577	2.194	23.753	65.989	91.353	111.255	16.184	65.817
CICO_TC_Check-Out Controller_mob037	105	105	0	0	0.06	1.6	2.074	4.743	57.03	95.702	115.948	12.252	56.9
CICO_TC_Check-Out Controller_mob038	90	90	0	0	0.052	1.641	2.112	5.363	64.469	103.831	109.368	14.178	64.361
CICO_TC_Check-Out Controller_mob039	106	106	0	0	0.061	1.575	2.099	5.829	63.643	116.734	128.332	13.881	63.474
CICO_TC_Check-Out Controller_mob04	88	88	0	0	0.049	1.625	2.184	18.845	88.38	116.048	120.448	17.428	88.284
CICO_TC_Check-Out Controller_mob040	99	99	0	0	0.056	1.44	2.054	15.684	62.709	109.327	117.732	14.649	62.564
CICO_TC_Check-Out Controller_mob041	96	96	0	0	0.054	1.622	2.067	2.493	60.951	112.361	126.657	12.503	60.756
CICO_TC_Check-Out Controller_mob042	97	97	0	0	0.055	1.568	2.083	3.341	66.74	120.423	127.637	13.934	66.596
CICO_TC_Check-Out Controller_mob043	99	99	0	0	0.057	1.473	2.132	4.37	58.736	78.073	118.637	12.45	58.615
CICO_TC_Check-Out Controller_mob044	88	88	0	0	0.051	1.526	2.24	30.442	74.548	106.438	111.706	18.231	74.407
CICO_TC_Check-Out Controller_mob045	92	92	0	0	0.054	1.578	2.096	3.11	55.65	69.816	120.449	12.144	55.485
CICO_TC_Check-Out Controller_mob046	88	88	0	0	0.052	1.651	2.062	3.021	62.243	109.871	126.096	11.409	62.108
CICO_TC_Check-Out Controller_mob047	88	88	0	0	0.05	1.54	2.132	13.023	89.28	112.255	121.006	17.021	89.186
CICO_TC_Check-Out Controller_mob048	85	85	0	0	0.049	1.546	2.329	24.855	72.921	103.104	121.154	17.411	72.795
CICO_TC_Check-Out Controller_mob049	95	95	0	0	0.055	1.493	2.135	5.096	62.771	110.253	120.784	13.562	62.644
CICO_TC_Check-Out Controller_mob05	90	90	0	0	0.052	1.579	2.196	6.375	63.691	112.223	118.313	13.602	63.538
CICO_TC_Check-Out Controller_mob050	104	104	0	0	0.06	1.584	2.066	4.233	61.197	106.328	119.114	12.498	61.044
CICO_TC_Check-Out Controller_mob051	94	94	0	0	0.054	1.524	2.131	11.445	70.597	113.292	120.346	16.104	70.438
CICO_TC_Check-Out Controller_mob052	94	94	0	0	0.054	1.483	2.163	15.471	56.128	98.264	111.528	13.691	56.011
CICO_TC_Check-Out Controller_mob053	108	108	0	0	0.063	1.57	2.115	15.628	72.028	112.735	125.677	15.137	71.87
CICO_TC_Check-Out Controller_mob054	90	90	0	0	0.053	1.688	2.12	26.467	98.939	115.827	120.628	17.587	98.847
CICO_TC_Check-Out Controller_mob055	92	92	0	0	0.056	1.541	2.118	3.331	55.447	66.581	69.153	10.233	55.34
CICO_TC_Check-Out Controller_mob056	98	98	0	0	0.056	1.646	2.119	7.736	63.133	110.413	111.274	14.081	62.994
CICO_TC_Check-Out Controller_mob057	81	81	0	0	0.046	1.607	2.206	20.77	74.639	112.942	116.993	15.736	74.486
CICO_TC_Check-Out Controller_mob058	88	88	0	0	0.05	1.503	2.075	3.906	58.52	101.125	115.672	12.823	58.398
CICO_TC_Check-Out Controller_mob059	95	95	0	0	0.059	1.628	2.175	5.18	59.65	92.229	103.56	12.971	59.497
CICO_TC_Check-Out Controller_mob06	87	87	0	0	0.048	1.727	2.208	4.107	54.245	67.528	94.892	10.648	54.139
CICO_TC_Check-Out Controller_mob060	107	107	0	0	0.061	1.564	2.119	18.468	65.085	94.068	108.953	14.46	64.918
CICO_TC_Check-Out Controller_mob07	96	96	0	0	0.057	1.468	2.199	3.759	61.401	113.5	124.495	12.077	61.249
CICO_TC_Check-Out Controller_mob08	92	92	0	0	0.052	1.65	2.283	4.223	59.479	102.332	105.279	12.877	59.354
CICO_TC_Check-Out Controller_mob09	92	92	0	0	0.051	1.484	2.236	23.717	61.924	94.587	107.995	15.803	61.756

Full Data Import result table

tenant	file_name	started_date	completed_date	duration	status
fs00001137	10k_bib_Create.mrc	2024-03-14 10:53:28.205+00	2024-03-14 11:02:14.227+00	08:46.0	COMMITTED
mob01	10k_bib_Create.mrc	2024-03-14 10:55:27.423+00	2024-03-14 11:21:27.403+00	26:00.0	COMMITTED
mob02	10k_bib_Create.mrc	2024-03-14 10:57:27.371+00	2024-03-14 11:38:10.974+00	40:43.6	COMMITTED
mob03	10k_bib_Create.mrc	2024-03-14 10:59:27.158+00			PARSING_IN_PROGRESS
mob04	10k_bib_Create.mrc	2024-03-14 11:01:27.285+00	2024-03-14 11:50:44.487+00	49:17.2	COMMITTED
mob05	10k_bib_Create.mrc	2024-03-14 11:03:27.203+00	2024-03-14 11:56:39.085+00	53:11.9	COMMITTED
fs00001137	10k_bib_Create.mrc	2024-03-14 11:04:01.491+00	2024-03-14 12:03:05.429+00	59:03.9	COMMITTED
mob06	10k_bib_Create.mrc	2024-03-14 11:05:27.241+00	2024-03-14 12:02:16.407+00	56:49.2	ERROR
mob01	10k_bib_Create.mrc	2024-03-14 11:06:00.776+00	2024-03-14 12:11:34.747+00	05:34.0	COMMITTED
mob07	10k_bib_Create.mrc	2024-03-14 11:07:27.209+00	2024-03-14 12:04:56.209+00	0:57:29	ERROR
mob02	10k_bib_Create.mrc	2024-03-14 11:08:00.802+00	2024-03-14 12:23:19.626+00	15:18.8	ERROR
mob08	10k_bib_Create.mrc	2024-03-14 11:09:27.456+00			PARSING_IN_PROGRESS
mob03	10k_bib_Create.mrc	2024-03-14 11:10:00.759+00	2024-03-14 12:29:10.938+00	19:10.2	COMMITTED
mob09	10k_bib_Create.mrc	2024-03-14 11:11:27.268+00	2024-03-14 12:08:31.318+00	57:04.0	COMMITTED
mob04	10k_bib_Create.mrc	2024-03-14 11:12:00.763+00	2024-03-14 12:33:08.591+00	21:07.8	COMMITTED
mob010	10k_bib_Create.mrc	2024-03-14 11:13:27.333+00			PARSING_IN_PROGRESS
mob05	10k_bib_Create.mrc	2024-03-14 11:14:00.713+00	2024-03-14 12:36:38.459+00	22:37.7	COMMITTED
mob011	10k_bib_Create.mrc	2024-03-14 11:15:27.371+00	2024-03-14 12:12:05.86+00	56:38.5	COMMITTED
mob06	10k_bib_Create.mrc	2024-03-14 11:16:00.736+00	2024-03-14 12:39:05.198+00	23:04.5	COMMITTED
mob012	10k_bib_Create.mrc	2024-03-14 11:17:27.438+00	2024-03-14 12:13:35.069+00	56:07.6	COMMITTED
mob07	10k_bib_Create.mrc	2024-03-14 11:18:00.731+00	2024-03-14 12:39:21.499+00	21:20.8	COMMITTED
mob013	10k_bib_Create.mrc	2024-03-14 11:19:27.368+00			PARSING_IN_PROGRESS
mob08	10k_bib_Create.mrc	2024-03-14 11:20:00.76+00	2024-03-14 12:34:51.074+00	14:50.3	COMMITTED
mob014	10k_bib_Create.mrc	2024-03-14 11:21:27.215+00	2024-03-14 12:15:40.416+00	54:13.2	ERROR
mob09	10k_bib_Create.mrc	2024-03-14 11:22:00.902+00	2024-03-14 12:39:50.84+00	17:49.9	COMMITTED
mob010	10k_bib_Create.mrc	2024-03-14 11:24:00.683+00	2024-03-14 12:39:58.045+00	15:57.4	COMMITTED
mob011	10k_bib_Create.mrc	2024-03-14 11:26:00.691+00	2024-03-14 12:40:03.188+00	14:02.5	COMMITTED
mob012	10k_bib_Create.mrc	2024-03-14 11:28:00.728+00	2024-03-14 12:40:08.796+00	12:08.1	COMMITTED
mob013	10k_bib_Create.mrc	2024-03-14 11:30:00.788+00	2024-03-14 12:36:15.527+00	06:14.7	COMMITTED
mob014	10k_bib_Create.mrc	2024-03-14 11:32:00.812+00	2024-03-14 12:40:11.43+00	08:10.6	COMMITTED

Test №10

DB_MAXSHAREDPOOLSIZE=210 for mod-invetory-storage plus DB_MAXSHAREDPOOLSIZE=140 parameter for others modules.

For this test we

Requests	Total per tenant	50th pct	75th pct	95th pct	99th pct	Average	CICO Error	DI Duration	DI Error
CICO_TC_Check-In	174	1.26	1.47	4.69	12.12	1.76	0	1:51:41	PARSING	ERROR
CICO_TC_Check-Out	175	2.20	2.55	8.67	14.58	3.06	0	1:51:41	1	2

Full Check-In/Check-Out result table

Requests	Total	OK	KO	% KO	Req/s	Min	50th pct	75th pct	95th pct	99th pct	Max	Average	Latency
CICO_TC_Check-Out Controller_mob08	241	241	0	0	0.134	1.616	2.204	2.497	8.832	14.04	18.063	2.952	8.683
CICO_TC_Check-Out Controller_mob07	133	133	0	0	0.077	1.569	2.231	2.668	9.388	19.231	19.778	3.404	9.281
CICO_TC_Check-Out Controller_mob06	241	241	0	0	0.134	1.472	2.126	2.459	9.895	16.458	19.101	3.228	9.733
CICO_TC_Check-Out Controller_mob059	114	114	0	0	0.068	1.786	2.244	2.634	8.908	13.632	18.44	3.083	8.776
CICO_TC_Check-Out Controller_mob057	109	109	0	0	0.063	1.632	2.269	2.601	6.767	13.439	14.457	2.971	6.662
CICO_TC_Check-Out Controller_mob055	119	119	0	0	0.07	1.67	2.205	2.425	8.145	15.925	18.23	3.063	8.036
CICO_TC_Check-Out Controller_mob053	107	107	0	0	0.061	1.667	2.23	2.648	9.795	12.564	13.667	3.162	9.646
CICO_TC_Check-Out Controller_mob051	126	126	0	0	0.071	1.567	2.212	2.481	7.086	12.544	18.887	2.831	6.947
CICO_TC_Check-Out Controller_mob050	119	119	0	0	0.068	1.593	2.274	2.563	8.691	14.023	15.766	3.036	8.496
CICO_TC_Check-Out Controller_mob05	105	105	0	0	0.058	1.644	2.395	2.768	10.559	17.117	32.092	3.601	10.38
CICO_TC_Check-Out Controller_mob048	234	234	0	0	0.136	1.446	2.061	2.301	7.566	14.085	19.583	2.769	7.397
CICO_TC_Check-Out Controller_mob046	221	221	0	0	0.125	1.363	2.087	2.451	7.43	11.282	15.631	2.767	7.296
CICO_TC_Check-Out Controller_mob044	225	225	0	0	0.128	1.445	2.14	2.527	9.09	13.892	19.451	3.058	8.969
CICO_TC_Check-Out Controller_mob042	252	252	0	0	0.142	1.436	2.078	2.415	7.924	12.383	19.397	2.898	7.803
CICO_TC_Check-Out Controller_mob040	226	226	0	0	0.13	1.574	2.111	2.421	7.98	10.97	19.444	2.81	7.795
CICO_TC_Check-Out Controller_mob04	236	236	0	0	0.136	1.551	2.124	2.442	6.831	12.794	15.985	2.724	6.707
CICO_TC_Check-Out Controller_mob038	225	225	0	0	0.13	1.577	2.073	2.429	8.436	15.316	17.849	2.915	8.304
CICO_TC_Check-Out Controller_mob036	232	232	0	0	0.131	1.567	2.111	2.394	7.863	13.895	14.996	2.817	7.721
CICO_TC_Check-Out Controller_mob034	243	243	0	0	0.139	1.469	2.051	2.395	7.143	16.088	17.702	2.711	7.048
CICO_TC_Check-Out Controller_mob032	225	225	0	0	0.126	1.554	2.097	2.354	7.504	10.963	14.083	2.704	7.387
CICO_TC_Check-Out Controller_mob030	232	232	0	0	0.133	1.502	2.121	2.433	7.332	11.662	13.933	2.783	7.161
CICO_TC_Check-Out Controller_mob03	123	123	0	0	0.068	1.715	2.285	2.726	8.057	14.665	16.205	3.075	7.901
CICO_TC_Check-Out Controller_mob028	253	253	0	0	0.142	1.477	2.083	2.369	7.066	11.112	16.921	2.739	6.932
CICO_TC_Check-Out Controller_mob026	241	241	0	0	0.135	1.531	2.085	2.44	8.37	12.29	14.089	2.772	8.254
CICO_TC_Check-Out Controller_mob025	120	120	0	0	0.07	1.519	2.22	2.664	7.286	12.178	20.525	3.042	7.169
CICO_TC_Check-Out Controller_mob024	105	105	0	0	0.06	1.596	2.266	2.546	5.502	14.599	17.697	2.794	5.402
CICO_TC_Check-Out Controller_mob022	254	254	0	0	0.15	1.518	2.056	2.329	6.44	10.459	14.823	2.662	6.33
CICO_TC_Check-Out Controller_mob020	237	237	0	0	0.133	1.439	2.077	2.347	7.057	11.958	16.951	2.734	6.941
CICO_TC_Check-Out Controller_mob02	250	250	0	0	0.139	1.608	2.176	2.59	8.482	15.565	23.155	2.999	8.373
CICO_TC_Check-Out Controller_mob019	108	108	0	0	0.066	1.647	2.252	2.633	9.129	16.634	20.346	3.199	9.01
CICO_TC_Check-Out Controller_mob018	109	109	0	0	0.064	1.591	2.183	2.636	10.223	12.355	18.588	3.171	10.125
CICO_TC_Check-Out Controller_mob017	126	126	0	0	0.072	1.59	2.247	2.61	9.636	14.569	18.481	3.261	9.494
CICO_TC_Check-Out Controller_mob016	111	111	0	0	0.066	1.666	2.182	2.624	9.43	15.95	18.127	3.294	9.279
CICO_TC_Check-Out Controller_mob015	116	116	0	0	0.069	1.656	2.224	2.589	10.588	16.039	17.162	3.335	10.47
CICO_TC_Check-Out Controller_mob014	118	118	0	0	0.07	1.495	2.299	2.684	11.678	21.18	21.78	3.607	11.538
CICO_TC_Check-Out Controller_mob013	124	124	0	0	0.074	1.678	2.328	2.766	12.827	17.882	22.479	3.558	12.708
CICO_TC_Check-Out Controller_mob012	117	117	0	0	0.067	1.643	2.341	2.644	12.622	18.409	20.735	3.676	12.495
CICO_TC_Check-Out Controller_mob011	127	127	0	0	0.071	1.67	2.345	2.811	9.401	17.798	24.911	3.285	9.241
CICO_TC_Check-Out Controller_mob010	229	229	0	0	0.128	1.59	2.145	2.5	9.291	16.278	20.679	3.073	9.154
CICO_TC_Check-Out Controller_mob01	100	100	0	0	0.057	1.669	2.321	2.735	10.033	13.425	14.638	3.287	9.916
CICO_TC_Check-Out Controller_fs00001137	247	247	0	0	0.141	1.58	2.636	3.032	9.328	21.968	22.786	3.545	9.197
CICO_TC_Check-In Controller_mob08	229	0	229	100	0	0.778	1.274	1.453	2.26	8.395	16.114	1.609	2.194
CICO_TC_Check-In Controller_mob07	102	102	0	0	0.057	0.913	1.333	1.511	4.552	13.922	17.398	1.904	4.463
CICO_TC_Check-In Controller_mob06	228	228	0	0	0.132	0.837	1.272	1.508	5.336	15.78	18.481	1.863	5.245
CICO_TC_Check-In Controller_mob059	120	120	0	0	0.069	0.83	1.302	1.531	8.978	17.687	18.124	2.093	8.873
CICO_TC_Check-In Controller_mob057	125	125	0	0	0.071	0.884	1.345	1.512	5.138	12.878	14.94	1.814	5.012
CICO_TC_Check-In Controller_mob055	116	116	0	0	0.066	0.832	1.28	1.483	7.169	14.221	20.173	2.03	7.089
CICO_TC_Check-In Controller_mob053	128	128	0	0	0.074	0.725	1.272	1.519	5.393	10.646	15.017	1.73	5.321
CICO_TC_Check-In Controller_mob051	108	108	0	0	0.062	0.831	1.25	1.476	2.386	6.879	10.489	1.521	2.311
CICO_TC_Check-In Controller_mob050	115	115	0	0	0.067	0.832	1.239	1.456	2.323	6.568	7.638	1.463	2.216
CICO_TC_Check-In Controller_mob05	130	130	0	0	0.076	0.849	1.313	1.605	5.817	12.658	14.798	1.876	5.659
CICO_TC_Check-In Controller_mob048	233	233	0	0	0.132	0.773	1.161	1.355	4.315	10.429	17.345	1.608	4.248
CICO_TC_Check-In Controller_mob046	248	248	0	0	0.143	0.804	1.147	1.382	4.875	10.044	17.364	1.627	4.795
CICO_TC_Check-In Controller_mob044	241	241	0	0	0.138	0.703	1.154	1.322	4.114	15.731	18.135	1.643	4.015
CICO_TC_Check-In Controller_mob042	215	215	0	0	0.128	0.687	1.175	1.398	2.576	9.973	13.919	1.565	2.489
CICO_TC_Check-In Controller_mob040	244	244	0	0	0.137	0.786	1.215	1.408	4.025	15.074	17.94	1.696	3.894
CICO_TC_Check-In Controller_mob04	234	234	0	0	0.13	0.762	1.208	1.369	2.09	8.065	10.712	1.455	2.016
CICO_TC_Check-In Controller_mob038	244	244	0	0	0.138	0.752	1.165	1.352	4.34	14.505	17.425	1.623	4.278
CICO_TC_Check-In Controller_mob036	237	237	0	0	0.136	0.778	1.181	1.354	2.148	12.396	15.347	1.578	2.052
CICO_TC_Check-In Controller_mob034	226	226	0	0	0.127	0.792	1.177	1.379	4.62	9.447	20.743	1.64	4.549
CICO_TC_Check-In Controller_mob032	243	243	0	0	0.139	0.81	1.152	1.336	4.269	10.374	17.486	1.586	4.167
CICO_TC_Check-In Controller_mob030	236	236	0	0	0.133	0.73	1.159	1.336	5.022	8.966	16.484	1.577	4.947
CICO_TC_Check-In Controller_mob03	112	112	0	0	0.065	0.841	1.291	1.586	2.137	9.485	12.1	1.622	2.059
CICO_TC_Check-In Controller_mob028	216	216	0	0	0.126	0.803	1.188	1.377	2.357	9.296	10.493	1.462	2.256
CICO_TC_Check-In Controller_mob026	228	228	0	0	0.132	0.781	1.151	1.375	2.358	8.161	10.974	1.449	2.281
CICO_TC_Check-In Controller_mob025	114	114	0	0	0.064	0.894	1.317	1.592	4.849	8.596	13.845	1.812	4.768
CICO_TC_Check-In Controller_mob024	129	129	0	0	0.076	0.812	1.318	1.618	4.316	8.222	13.356	1.772	4.204
CICO_TC_Check-In Controller_mob022	215	215	0	0	0.121	0.742	1.209	1.349	3.064	9.991	16.925	1.577	2.968
CICO_TC_Check-In Controller_mob020	232	232	0	0	0.133	0.813	1.198	1.396	3.494	9.097	10.845	1.575	3.408
CICO_TC_Check-In Controller_mob02	219	219	0	0	0.125	0.821	1.243	1.428	5.575	10.88	21.134	1.735	5.483
CICO_TC_Check-In Controller_mob019	126	126	0	0	0.071	0.794	1.25	1.437	4.272	13.831	14.014	1.781	4.195
CICO_TC_Check-In Controller_mob018	126	126	0	0	0.072	0.856	1.244	1.517	4.606	10.373	19.541	1.745	4.51
CICO_TC_Check-In Controller_mob017	109	109	0	0	0.061	0.899	1.252	1.451	3.835	11.405	15.85	1.715	3.706
CICO_TC_Check-In Controller_mob016	123	123	0	0	0.07	0.833	1.261	1.51	7.255	12.451	13.713	1.889	7.138
CICO_TC_Check-In Controller_mob015	117	117	0	0	0.066	0.815	1.341	1.521	3.632	12.154	16.626	1.768	3.553
CICO_TC_Check-In Controller_mob014	116	116	0	0	0.066	0.863	1.329	1.507	5.983	16.141	23.933	2.003	5.914
CICO_TC_Check-In Controller_mob013	111	111	0	0	0.062	0.888	1.388	1.55	4.9	16.286	16.662	1.972	4.734
CICO_TC_Check-In Controller_mob012	116	116	0	0	0.071	0.874	1.272	1.512	8.331	18.154	18.268	2.126	8.266
CICO_TC_Check-In Controller_mob011	107	107	0	0	0.063	0.891	1.449	1.69	12.513	17.623	26.753	2.531	12.435
CICO_TC_Check-In Controller_mob010	240	240	0	0	0.139	0.828	1.292	1.512	6.431	15.506	21.001	1.986	6.355
CICO_TC_Check-In Controller_mob01	135	135	0	0	0.08	0.84	1.305	1.496	4.339	18.69	21.512	1.951	4.255
CICO_TC_Check-In Controller_fs00001137	223	223	0	0	0.124	1.003	1.604	1.904	6.477	15.9	18.155	2.202	6.393

Full Data Import result table

tenant	file_name	started_date	completed_date	duration	status
fs00001137	10k_bib_Create.mrc	2024-03-15 09:48:14.136+00			PARSING_IN_PROGRESS
mob09	10k_bib_Create.mrc	2024-03-15 09:48:19.94+00	2024-03-15 11:15:37.028+00	27:17.1	COMMITTED
mob01	10k_bib_Create.mrc	2024-03-15 09:50:12.897+00	2024-03-15 11:25:39.475+00	35:26.6	COMMITTED
mob012	10k_bib_Create.mrc	2024-03-15 09:50:18.445+00	2024-03-15 11:17:16.497+00	26:58.1	COMMITTED
mob02	10k_bib_Create.mrc	2024-03-15 09:52:13.029+00	2024-03-15 11:29:43.874+00	37:30.8	COMMITTED
mob014	10k_bib_Create.mrc	2024-03-15 09:52:20.202+00	2024-03-15 11:33:21.403+00	41:01.2	COMMITTED
mob03	10k_bib_Create.mrc	2024-03-15 09:54:12.799+00	2024-03-15 11:35:44.009+00	41:31.2	COMMITTED
mob016	10k_bib_Create.mrc	2024-03-15 09:54:19.969+00	2024-03-15 11:31:46.623+00	37:26.7	COMMITTED
mob04	10k_bib_Create.mrc	2024-03-15 09:56:12.801+00	2024-03-15 11:38:27.266+00	42:14.5	COMMITTED
mob018	10k_bib_Create.mrc	2024-03-15 09:56:18.562+00	2024-03-15 11:34:27.767+00	38:09.2	COMMITTED
mob05	10k_bib_Create.mrc	2024-03-15 09:58:12.638+00	2024-03-15 11:37:06.634+00	38:54.0	COMMITTED
mob021	10k_bib_Create.mrc	2024-03-15 09:58:20.286+00	2024-03-15 11:29:34.553+00	31:14.3	COMMITTED
mob06	10k_bib_Create.mrc	2024-03-15 10:00:12.978+00	2024-03-15 11:31:03.131+00	30:50.2	COMMITTED
mob023	10k_bib_Create.mrc	2024-03-15 10:00:19.596+00	2024-03-15 11:38:57.377+00	38:37.8	COMMITTED
mob07	10k_bib_Create.mrc	2024-03-15 10:02:12.613+00	2024-03-15 11:34:45.687+00	32:33.1	ERROR
mob024	10k_bib_Create.mrc	2024-03-15 10:02:19.299+00	2024-03-15 11:39:41.046+00	37:21.7	COMMITTED
mob08	10k_bib_Create.mrc	2024-03-15 10:04:12.798+00	2024-03-15 11:39:28.367+00	35:15.6	COMMITTED
mob027	10k_bib_Create.mrc	2024-03-15 10:04:20.372+00	2024-03-15 11:34:55.666+00	30:35.3	COMMITTED
mob010	10k_bib_Create.mrc	2024-03-15 10:06:12.892+00	2024-03-15 11:39:30.523+00	33:17.6	COMMITTED
mob029	10k_bib_Create.mrc	2024-03-15 10:06:18.852+00	2024-03-15 11:39:57.627+00	33:38.8	COMMITTED
mob011	10k_bib_Create.mrc	2024-03-15 10:08:13.089+00	2024-03-15 11:39:37.894+00	31:24.8	ERROR
mob031	10k_bib_Create.mrc	2024-03-15 10:08:18.855+00	2024-03-15 11:38:04.502+00	29:45.6	COMMITTED
mob013	10k_bib_Create.mrc	2024-03-15 10:10:12.811+00	2024-03-15 11:39:52.39+00	29:39.6	COMMITTED
mob033	10k_bib_Create.mrc	2024-03-15 10:10:20.114+00	2024-03-15 11:39:08.923+00	28:48.8	COMMITTED
mob015	10k_bib_Create.mrc	2024-03-15 10:12:12.617+00	2024-03-15 11:39:54.161+00	27:41.5	COMMITTED
mob035	10k_bib_Create.mrc	2024-03-15 10:12:19.737+00	2024-03-15 11:39:56.797+00	27:37.1	COMMITTED
mob017	10k_bib_Create.mrc	2024-03-15 10:14:12.646+00	2024-03-15 11:39:51.011+00	25:38.4	COMMITTED
mob037	10k_bib_Create.mrc	2024-03-15 10:14:19.815+00	2024-03-15 11:39:56.405+00	25:36.6	COMMITTED
mob019	10k_bib_Create.mrc	2024-03-15 10:16:13.508+00	2024-03-15 11:39:54.503+00	23:41.0	COMMITTED
mob039	10k_bib_Create.mrc	2024-03-15 10:16:19.156+00	2024-03-15 11:39:55.907+00	23:36.8	COMMITTED

Test №11

DB_MAXSHAREDPOOLSIZE=280 parameter for all 10 modules

Requests

Total per tenant

50th pct

75th pct

95th pct

99th pct

Average

CICO Error

(POST)

DI Duration

DI Error

CICO_TC_Check-In

114

1.12

1.29

9.69

23.65

2.28

3

01:49:14

PARSING

ERROR

CICO_TC_Check-Out

113

2.03

2.39

19.39

28.50

4.28

10

0

Full Check-In/Check-Out result table

Requests	Total	OK	KO	% KO	Req/s	Min	50th pct	75th pct	95th pct	99th pct	Max	Average	Latency
CICO_TC_Check-In Controller_fs00001137	120	120	0	0	0.069	0.873	1.448	1.732	12.754	25.598	26.185	2.776	12.665
CICO_TC_Check-In Controller_mob01	119	119	0	0	0.069	0.819	1.17	1.335	9.86	27.468	28.472	2.401	9.787
CICO_TC_Check-In Controller_mob010	116	116	0	0	0.07	0.782	1.112	1.302	13.011	17.909	22.511	2.256	12.902
CICO_TC_Check-In Controller_mob011	112	112	0	0	0.064	0.665	1.129	1.325	12.882	17.005	24.258	2.199	12.807
CICO_TC_Check-In Controller_mob012	119	119	0	0	0.07	0.738	1.087	1.259	3.824	24.539	27.951	2.018	3.756
CICO_TC_Check-In Controller_mob013	103	103	0	0	0.059	0.79	1.152	1.238	4.932	15.324	17.085	1.803	4.838
CICO_TC_Check-In Controller_mob014	117	117	0	0	0.067	0.775	1.2	1.372	12.95	23.078	24.787	2.468	12.857
CICO_TC_Check-In Controller_mob015	114	114	0	0	0.065	0.797	1.115	1.295	10.794	16.581	22.996	2.297	10.723
CICO_TC_Check-In Controller_mob016	110	110	0	0	0.066	0.755	1.135	1.296	13.36	24.814	26.833	2.665	13.272
CICO_TC_Check-In Controller_mob017	114	114	0	0	0.067	0.773	1.116	1.246	4.071	21.096	24.457	1.864	4.01
CICO_TC_Check-In Controller_mob018	108	108	0	0	0.064	0.725	1.097	1.232	6.222	24.031	27.198	2.157	5.934
CICO_TC_Check-In Controller_mob019	116	116	0	0	0.066	0.696	1.134	1.29	13.748	27.546	29.21	2.633	13.667
CICO_TC_Check-In Controller_mob02	114	114	0	0	0.063	0.76	1.149	1.342	6.426	25.713	28.407	2.354	6.345
CICO_TC_Check-In Controller_mob020	100	100	0	0	0.056	0.785	1.16	1.345	13.293	20.222	24.95	2.436	13.196
CICO_TC_Check-In Controller_mob021	113	113	0	0	0.065	0.698	1.124	1.279	9.103	23.595	27.112	2.092	9.026
CICO_TC_Check-In Controller_mob022	114	114	0	0	0.068	0.802	1.105	1.26	13.22	27.833	28.856	2.661	13.122
CICO_TC_Check-In Controller_mob023	114	114	0	0	0.067	0.708	1.069	1.24	8.382	23.28	26.004	2.126	8.301
CICO_TC_Check-In Controller_mob024	129	129	0	0	0.073	0.777	1.08	1.223	2.945	9.301	22.174	1.5	2.863
CICO_TC_Check-In Controller_mob025	117	117	0	0	0.066	0.778	1.077	1.262	6.956	21.096	29.382	2.018	6.863
CICO_TC_Check-In Controller_mob026	101	101	0	0	0.059	0.789	1.09	1.291	14.105	28.315	29.374	2.736	14.018
CICO_TC_Check-In Controller_mob027	118	118	0	0	0.067	0.749	1.095	1.328	13.985	26.632	27.556	2.57	13.855
CICO_TC_Check-In Controller_mob028	125	125	0	0	0.072	0.723	1.084	1.266	9.027	20.001	23.033	1.995	8.943
CICO_TC_Check-In Controller_mob029	102	102	0	0	0.058	0.806	1.131	1.34	9.8	16.191	25.663	2.145	9.708
CICO_TC_Check-In Controller_mob03	123	123	0	0	0.073	0.737	1.09	1.233	8.859	27.053	27.977	2.241	8.766
CICO_TC_Check-In Controller_mob030	109	109	0	0	0.062	0.771	1.09	1.244	7.297	21.509	28.416	1.94	7.233
CICO_TC_Check-In Controller_mob031	118	118	0	0	0.069	0.755	1.137	1.312	9.416	25.342	27.177	2.245	9.333
CICO_TC_Check-In Controller_mob032	114	114	0	0	0.066	0.795	1.107	1.3	12.635	28.057	28.339	2.619	12.574
CICO_TC_Check-In Controller_mob033	130	130	0	0	0.076	0.777	1.125	1.304	10.567	28.25	33.249	2.364	10.478
CICO_TC_Check-In Controller_mob034	117	117	0	0	0.07	0.802	1.096	1.242	3.703	22.763	28.24	1.961	3.62
CICO_TC_Check-In Controller_mob035	118	118	0	0	0.067	0.678	1.069	1.28	9.53	22.279	23.914	2.013	9.475
CICO_TC_Check-In Controller_mob036	107	107	0	0	0.062	0.749	1.135	1.317	12.184	27.096	28.109	2.519	12.083
CICO_TC_Check-In Controller_mob037	124	124	0	0	0.072	0.687	1.103	1.253	16.472	28.232	32.279	2.657	16.385
CICO_TC_Check-In Controller_mob038	123	123	0	0	0.074	0.696	1.082	1.247	6.904	27.952	28.494	2.039	6.819
CICO_TC_Check-In Controller_mob039	105	105	0	0	0.063	0.799	1.112	1.26	11.695	24.107	27.813	2.358	11.626
CICO_TC_Check-In Controller_mob04	125	125	0	0	0.072	0.757	1.126	1.36	13.955	24.498	29.148	2.501	13.871
CICO_TC_Check-In Controller_mob040	114	114	0	0	0.068	0.798	1.113	1.307	5.28	21.963	26.526	1.953	5.179
CICO_TC_Check-In Controller_mob041	111	111	0	0	0.064	0.813	1.092	1.227	3.14	20.977	26.231	1.717	3.078
CICO_TC_Check-In Controller_mob042	106	106	0	0	0.061	0.759	1.111	1.294	11.209	27.599	28.143	2.343	11.119
CICO_TC_Check-In Controller_mob043	115	115	0	0	0.069	0.808	1.105	1.303	8.776	27.587	27.769	2.572	8.655
CICO_TC_Check-In Controller_mob044	113	113	0	0	0.066	0.761	1.105	1.272	10.124	25.358	27.203	2.458	10.022
CICO_TC_Check-In Controller_mob045	113	113	0	0	0.065	0.779	1.131	1.304	8.867	17.495	24.908	2.212	8.761
CICO_TC_Check-In Controller_mob046	116	116	0	0	0.067	0.812	1.133	1.258	2.163	25.669	27.989	2.063	2.101
CICO_TC_Check-In Controller_mob047	104	104	0	0	0.061	0.741	1.137	1.29	11.298	26.806	28.831	2.324	11.224
CICO_TC_Check-In Controller_mob048	120	120	0	0	0.068	0.762	1.151	1.394	11.062	25.75	31.964	2.597	10.95
CICO_TC_Check-In Controller_mob049	112	112	0	0	0.065	0.736	1.131	1.309	6.775	24.942	29.979	2.302	6.7
CICO_TC_Check-In Controller_mob05	109	109	0	0	0.061	0.787	1.151	1.323	9.085	20.703	24.489	2.184	8.981
CICO_TC_Check-In Controller_mob050	111	110	1	0.901	0.064	0.741	1.134	1.273	4.973	27.635	29.969	2.176	4.89
CICO_TC_Check-In Controller_mob051	107	107	0	0	0.062	0.775	1.095	1.217	10.564	17.139	31.123	2.262	10.463
CICO_TC_Check-In Controller_mob052	115	114	1	0.87	0.066	0.748	1.109	1.277	9.364	25.864	31.724	2.417	9.29
CICO_TC_Check-In Controller_mob053	121	121	0	0	0.07	0.745	1.091	1.287	19.278	29.528	31.431	2.705	19.202
CICO_TC_Check-In Controller_mob054	107	107	0	0	0.062	0.692	1.132	1.326	14.135	25.77	30.53	2.413	14.063
CICO_TC_Check-In Controller_mob055	110	110	0	0	0.063	0.677	1.177	1.318	18.105	26.392	29.35	2.647	18.038
CICO_TC_Check-In Controller_mob056	119	119	0	0	0.07	0.762	1.095	1.262	9.039	22.698	29.083	2.187	8.957
CICO_TC_Check-In Controller_mob057	118	118	0	0	0.067	0.674	1.085	1.238	2.64	14.531	26.124	1.724	2.571
CICO_TC_Check-In Controller_mob058	126	125	1	0.794	0.075	0.721	1.135	1.288	10.979	29.013	29.245	2.319	10.898
CICO_TC_Check-In Controller_mob059	118	118	0	0	0.07	0.78	1.117	1.254	15.707	24.284	28.641	2.499	15.619
CICO_TC_Check-In Controller_mob06	103	103	0	0	0.057	0.826	1.169	1.314	10.143	31.001	32.079	2.616	10.054
CICO_TC_Check-In Controller_mob060	117	117	0	0	0.067	0.716	1.079	1.211	5.197	20.715	25.788	1.903	5.12
CICO_TC_Check-In Controller_mob07	116	116	0	0	0.068	0.839	1.118	1.283	7.446	25.108	27.235	2.084	7.371
CICO_TC_Check-In Controller_mob08	115	0	115	100	0	0.735	1.107	1.266	9.569	21.203	26.718	2.283	9.48
CICO_TC_Check-In Controller_mob09	112	112	0	0	0.062	0.717	1.144	1.344	7.396	22.664	24.86	2.243	7.31
CICO_TC_Check-Out Controller_fs00001137	109	107	2	1.835	0.061	1.864	2.664	3.282	23.102	33.836	37.204	5.161	22.953
CICO_TC_Check-Out Controller_mob01	110	110	0	0	0.062	1.383	2.055	2.382	23.072	32.978	38.543	4.408	22.951
CICO_TC_Check-Out Controller_mob010	112	112	0	0	0.063	1.377	1.987	2.307	17.292	29.007	29.679	4.279	17.164
CICO_TC_Check-Out Controller_mob011	117	117	0	0	0.066	1.429	2.011	2.399	17.778	29.771	31.444	4.431	17.648
CICO_TC_Check-Out Controller_mob012	109	109	0	0	0.061	1.467	2.097	2.55	21.684	26.16	30.535	4.208	21.554
CICO_TC_Check-Out Controller_mob013	125	125	0	0	0.07	1.372	2.071	2.438	21.51	29.463	30.434	4.853	21.358
CICO_TC_Check-Out Controller_mob014	111	111	0	0	0.062	1.503	2.001	2.261	16.692	27.935	34.013	4.132	16.553
CICO_TC_Check-Out Controller_mob015	115	115	0	0	0.065	1.492	2.015	2.272	22.228	30.699	31.282	4.703	22.105
CICO_TC_Check-Out Controller_mob016	118	118	0	0	0.066	1.436	2.026	2.379	17.551	26.255	26.48	4.055	17.455
CICO_TC_Check-Out Controller_mob017	116	116	0	0	0.066	1.481	2.023	2.343	14.597	26.451	31.398	4.029	14.466
CICO_TC_Check-Out Controller_mob018	121	120	1	0.826	0.069	1.37	2.019	2.486	21.359	28.966	35.119	4.843	21.212
CICO_TC_Check-Out Controller_mob019	112	112	0	0	0.066	1.529	1.96	2.197	13.418	29.418	29.732	3.632	13.282
CICO_TC_Check-Out Controller_mob02	115	115	0	0	0.066	1.526	2.012	2.33	19.413	27.135	31.764	4.496	19.309
CICO_TC_Check-Out Controller_mob020	129	129	0	0	0.075	1.306	1.955	2.28	21.893	30.569	31.625	4.183	21.554
CICO_TC_Check-Out Controller_mob021	115	115	0	0	0.066	1.141	2.009	2.292	20.314	25.289	27.984	3.853	20.205
CICO_TC_Check-Out Controller_mob022	114	114	0	0	0.065	1.289	1.97	2.284	15.165	27.107	32.614	3.858	15.011
CICO_TC_Check-Out Controller_mob023	114	114	0	0	0.064	1.518	2.025	2.346	15.301	28.094	29.419	4.289	15.178
CICO_TC_Check-Out Controller_mob024	99	99	0	0	0.057	1.431	2.036	2.564	28.12	32.314	32.325	5.444	27.969
CICO_TC_Check-Out Controller_mob025	112	112	0	0	0.065	1.382	2.015	2.853	24.224	29.174	35.051	5.279	24.11
CICO_TC_Check-Out Controller_mob026	126	126	0	0	0.071	1.472	2.009	2.291	14.977	24.659	29.523	3.612	14.816
CICO_TC_Check-Out Controller_mob027	110	110	0	0	0.066	1.496	2.004	2.367	20.527	29.28	29.332	4.264	20.388
CICO_TC_Check-Out Controller_mob028	103	103	0	0	0.058	1.586	2.025	2.428	17.245	25.314	31.443	4.056	17.147
CICO_TC_Check-Out Controller_mob029	126	126	0	0	0.073	1.416	1.948	2.212	24.008	29.128	29.22	4.112	23.865
CICO_TC_Check-Out Controller_mob03	105	104	1	0.952	0.059	1.491	2.045	2.409	13.14	26.617	27.874	3.576	13.048
CICO_TC_Check-Out Controller_mob030	119	119	0	0	0.072	1.523	2.039	2.47	21.964	28.146	29.13	4.317	21.85
CICO_TC_Check-Out Controller_mob031	111	110	1	0.901	0.063	1.421	1.979	2.471	16.242	27.327	29.335	4.275	16.112
CICO_TC_Check-Out Controller_mob032	113	112	1	0.885	0.064	1.523	2.024	2.401	20.739	29.877	30.021	4.413	20.634
CICO_TC_Check-Out Controller_mob033	98	98	0	0	0.055	1.468	2	2.377	16.965	27.762	29.284	4.083	16.821
CICO_TC_Check-Out Controller_mob034	112	112	0	0	0.063	1.427	2.001	2.448	16.566	25.092	31.43	4.165	16.436
CICO_TC_Check-Out Controller_mob035	111	111	0	0	0.064	1.398	2.02	2.37	19.458	33.012	35.742	4.102	19.343
CICO_TC_Check-Out Controller_mob036	121	121	0	0	0.069	1.488	1.978	2.413	15.64	25.452	28.085	3.667	15.509
CICO_TC_Check-Out Controller_mob037	104	104	0	0	0.059	1.507	2.023	2.35	23.108	30.639	34.904	4.455	23.006
CICO_TC_Check-Out Controller_mob038	104	104	0	0	0.06	1.462	1.982	2.318	20.06	29.907	31.43	4.132	19.926
CICO_TC_Check-Out Controller_mob039	123	123	0	0	0.07	1.496	1.957	2.367	22.917	28.295	29.302	4.163	22.806
CICO_TC_Check-Out Controller_mob04	102	100	2	1.961	0.058	1.464	2.055	2.368	16.717	27.25	29.53	3.946	16.626
CICO_TC_Check-Out Controller_mob040	115	115	0	0	0.065	1.305	1.95	2.311	20.567	32.445	38.41	4.235	20.456
CICO_TC_Check-Out Controller_mob041	118	118	0	0	0.067	1.495	2.034	2.479	18.245	30.274	31.417	4.455	18.151
CICO_TC_Check-Out Controller_mob042	122	122	0	0	0.069	1.415	2.014	2.281	18.411	27.449	29.986	4.093	18.27
CICO_TC_Check-Out Controller_mob043	114	114	0	0	0.065	1.451	2.013	2.338	16.617	28.476	29.386	4.129	16.504
CICO_TC_Check-Out Controller_mob044	116	116	0	0	0.066	1.468	2.061	2.382	18.529	26.052	28.961	4.249	18.421
CICO_TC_Check-Out Controller_mob045	115	115	0	0	0.066	1.446	1.994	2.315	22.951	29.782	32.42	4.52	22.855
CICO_TC_Check-Out Controller_mob046	113	113	0	0	0.064	1.456	2.037	2.508	18.93	28.693	29.696	4.399	18.804
CICO_TC_Check-Out Controller_mob047	123	123	0	0	0.07	1.437	2.02	2.33	19.914	27.447	29.893	4.311	19.799
CICO_TC_Check-Out Controller_mob048	109	109	0	0	0.064	1.438	2.027	2.311	22.571	30.733	34.504	4.056	22.442
CICO_TC_Check-Out Controller_mob049	115	115	0	0	0.066	1.381	1.996	2.252	23.741	30.572	30.658	4.326	23.635
CICO_TC_Check-Out Controller_mob05	121	121	0	0	0.072	1.558	2.082	2.415	21.616	26.947	30.573	4.74	21.484
CICO_TC_Check-Out Controller_mob050	117	117	0	0	0.067	1.466	1.987	2.369	14.65	25.478	27.062	3.863	14.557
CICO_TC_Check-Out Controller_mob051	120	120	0	0	0.069	1.529	1.996	2.233	17.455	31.583	32.02	4.139	17.352
CICO_TC_Check-Out Controller_mob052	112	112	0	0	0.065	1.483	1.998	2.379	12.602	30.95	31.062	3.746	12.511
CICO_TC_Check-Out Controller_mob053	107	107	0	0	0.062	1.4	2.067	2.277	12.298	30.156	31.614	3.666	12.176
CICO_TC_Check-Out Controller_mob054	119	118	1	0.84	0.07	1.611	2.02	2.311	21.779	27.67	30.76	4.232	21.663
CICO_TC_Check-Out Controller_mob055	117	117	0	0	0.068	1.464	1.973	2.283	23.408	30.839	32.237	4.366	23.299
CICO_TC_Check-Out Controller_mob056	108	108	0	0	0.062	1.544	2.051	2.486	25.326	27.483	30.287	4.729	25.225
CICO_TC_Check-Out Controller_mob057	109	108	1	0.917	0.064	1.588	2.056	2.272	23.681	26.301	33.491	4.485	23.565
CICO_TC_Check-Out Controller_mob058	101	101	0	0	0.058	1.519	2.051	2.433	18.213	25.623	26.446	4.123	18.107
CICO_TC_Check-Out Controller_mob059	109	109	0	0	0.062	1.503	2.05	2.331	14.373	24.343	30.694	3.739	14.242
CICO_TC_Check-Out Controller_mob06	126	126	0	0	0.072	1.498	2.014	2.36	17.188	25.397	26.982	3.879	17.07
CICO_TC_Check-Out Controller_mob060	112	112	0	0	0.066	1.432	2.032	2.461	23.767	29.863	32.688	4.764	23.637
CICO_TC_Check-Out Controller_mob07	112	111	1	0.893	0.063	1.576	2.062	2.451	18.459	27.998	28.942	4.585	18.342
CICO_TC_Check-Out Controller_mob08	114	114	0	0	0.064	1.468	2.046	2.544	24.513	31.987	34.21	5.111	24.377
CICO_TC_Check-Out Controller_mob09	117	117	0	0	0.067	1.416	2.052	2.424	18.254	25.795	31.471	4.476	18.122

Full Data Import result table

tenant	file_name	started_date	completed_date	duration	status
fs00001137	10k_bib_Create.mrc	2024-03-15 13:25:02.356+00	2024-03-15 13:33:52.021+00	08:49.7	COMMITTED
mob01	10k_bib_Create.mrc	2024-03-15 13:27:01.324+00	2024-03-15 13:53:56.135+00	26:54.8	COMMITTED
mob02	10k_bib_Create.mrc	2024-03-15 13:29:01.34+00	2024-03-15 14:08:49.275+00	39:47.9	COMMITTED
fs00001137	10k_bib_Create.mrc	2024-03-15 13:30:45.536+00	2024-03-15 14:22:18.418+00	51:32.9	COMMITTED
mob03	10k_bib_Create.mrc	2024-03-15 13:31:01.421+00	2024-03-15 14:23:50.88+00	52:49.5	COMMITTED
mob01	10k_bib_Create.mrc	2024-03-15 13:32:45.004+00	2024-03-15 14:43:51.312+00	11:06.3	COMMITTED
mob04	10k_bib_Create.mrc	2024-03-15 13:33:01.453+00	2024-03-15 14:24:50.14+00	51:48.7	COMMITTED
mob02	10k_bib_Create.mrc	2024-03-15 13:34:44.936+00	2024-03-15 14:54:34.343+00	19:49.4	COMMITTED
mob05	10k_bib_Create.mrc	2024-03-15 13:35:01.502+00	2024-03-15 14:28:41.692+00	53:40.2	COMMITTED
mob03	10k_bib_Create.mrc	2024-03-15 13:36:44.945+00	2024-03-15 15:05:04.392+00	28:19.4	COMMITTED
mob06	10k_bib_Create.mrc	2024-03-15 13:37:01.437+00	2024-03-15 14:32:02.557+00	55:01.1	COMMITTED
mob04	10k_bib_Create.mrc	2024-03-15 13:38:45.107+00	2024-03-15 15:05:46.569+00	27:01.5	COMMITTED
mob07	10k_bib_Create.mrc	2024-03-15 13:39:01.627+00	2024-03-15 14:35:59.833+00	56:58.2	COMMITTED
mob05	10k_bib_Create.mrc	2024-03-15 13:40:45.099+00	2024-03-15 15:08:45.875+00	28:00.8	COMMITTED
mob08	10k_bib_Create.mrc	2024-03-15 13:41:01.656+00	2024-03-15 14:37:00.744+00	55:59.1	COMMITTED
mob06	10k_bib_Create.mrc	2024-03-15 13:42:44.949+00	2024-03-15 15:10:57.728+00	28:12.8	COMMITTED
mob09	10k_bib_Create.mrc	2024-03-15 13:43:01.602+00	2024-03-15 14:38:38.344+00	55:36.7	COMMITTED
mob07	10k_bib_Create.mrc	2024-03-15 13:44:45.706+00	2024-03-15 15:13:27.756+00	28:42.0	COMMITTED
mob010	10k_bib_Create.mrc	2024-03-15 13:45:03.883+00	2024-03-15 14:40:32.307+00	55:28.4	COMMITTED
mob08	10k_bib_Create.mrc	2024-03-15 13:46:45.284+00	2024-03-15 15:13:30.595+00	26:45.3	COMMITTED
mob011	10k_bib_Create.mrc	2024-03-15 13:47:01.461+00	2024-03-15 14:40:43.434+00	53:42.0	COMMITTED
mob09	10k_bib_Create.mrc	2024-03-15 13:48:44.944+00	2024-03-15 15:13:56.003+00	25:11.1	COMMITTED
mob012	10k_bib_Create.mrc	2024-03-15 13:49:01.587+00	2024-03-15 14:42:04.212+00	53:02.6	COMMITTED
mob010	10k_bib_Create.mrc	2024-03-15 13:50:44.918+00	2024-03-15 15:14:04.345+00	23:19.4	COMMITTED
mob013	10k_bib_Create.mrc	2024-03-15 13:51:01.466+00	2024-03-15 14:43:43.98+00	52:42.5	COMMITTED
mob011	10k_bib_Create.mrc	2024-03-15 13:52:44.943+00	2024-03-15 15:14:04.974+00	21:20.0	COMMITTED
mob014	10k_bib_Create.mrc	2024-03-15 13:53:01.49+00	2024-03-15 14:44:37.385+00	51:35.9	COMMITTED
mob012	10k_bib_Create.mrc	2024-03-15 13:54:44.885+00	2024-03-15 15:14:13.252+00	19:28.4	COMMITTED
mob013	10k_bib_Create.mrc	2024-03-15 13:56:45.096+00	2024-03-15 15:14:18.109+00	17:33.0	COMMITTED
mob014	10k_bib_Create.mrc	2024-03-15 13:58:44.974+00	2024-03-15 15:14:16.993+00	15:32.0	COMMITTED

Comparison

The following diagram compares results of Test №3 and Test №3 RERUN (mod-inventory-storage DB_MAXSHAREDPOOLSIZE=2500, mod-circulation-storage DB_MAXSHAREDPOOLSIZE=500 and others modules DB_MAXPOOLSIZE=20, CICO=305 users for 61 tenants) with previous result from this report.

The following table compares results between tests with data import, data import for test №6 and №11 were without errors.

Test #	Test param	CI	CO	DB Connection	DI Duration
4	mod-invetory-storage=2500 mod-circulation-storage=500 DB_MAXPOOLSIZE=20 DI 15	1.27	2.357	3689	0:59:56
5	DB_MAXSHAREDPOOLSIZE=40 15 DI	16.192	18.911	2667	failed
6	DB_MAXSHAREDPOOLSIZE=70 15 DI	7.956	14.255	2100	0:57:59
7	DB_MAXSHAREDPOOLSIZE=140 30 DI	1.866	3.551	2875	1:44:56
9	mod-invetory-storage=210 DB_MAXSHAREDPOOLSIZE=70 30 DI	7.33	14.43	2336	1:46:43
10	mod-invetory-storage=210 DB_MAXSHAREDPOOLSIZE=140 30 DI	1.76	3.06	2974	1:51:41
8	DB_MAXSHAREDPOOLSIZE=210 30 DI	2.568	4.76	3348	2:07:05
11	DB_MAXSHAREDPOOLSIZE=280 30 DI	2.28	4.28	3378	1:49:14

The following diagram compares results of Base Line test, Test №1 and Test №2. Shared pool feature leads to performance degradation.

Resource utilization for Test #1

Resource utilization table

CPU		Memory
mod-inventory-b	84.15	mod-source-record-storage-b	71.4137308
mod-quick-marc-b	80.06	mod-inventory-b	61.6285602
mod-source-record-storage-b	45.01	okapi-b	60.2083333
mod-pubsub-b	35.42	mod-source-record-manager-b	45.1523796
okapi-b	28.25	mod-feesfines-b	31.2176927
mod-source-record-manager-b	26.52	mod-configuration-b	30.7869283
mod-inventory-storage-b	25.85	mod-circulation-b	30.5401742
mod-feesfines-b	5.52	mod-quick-marc-b	28.8143382
mod-configuration-b	4.24	mod-pubsub-b	24.7763039
mod-remote-storage-b	3.78	mod-data-import-b	21.322208
mod-authtoken-b	2.41	mod-authtoken-b	21.2231969
mod-circulation-storage-b	1.84	mod-remote-storage-b	19.8904293
mod-circulation-b	0.71	mod-users-bl-b	19.2934485
mod-users-bl-b	0.61	mod-circulation-storage-b	18.447832
mod-users-b	0.58	mod-inventory-storage-b	15.3019065
mod-patron-blocks-b	0.51	mod-users-b	12.5338753
mod-data-import-b	0.17	mod-patron-blocks-b	10.43

Service CPU Utilization

Here we can see that mod-inventory-b module used 84% CPU and mod-quick-marc-b used 80% CPU

Service Memory Utilization

Here we can see that all modules show a stable trend.

DB CPU Utilization

DB CPU was 81%.

DB Connections

DB connections was 1800.

Resource utilization for Test #2

Resource utilization table

CPU		Memory
mod-inventory-b	83.97	mod-source-record-storage-b	71.40
mod-quick-marc-b	73.22	mod-inventory-b	61.68
mod-source-record-storage-b	54.42	okapi-b	60.09
mod-pubsub-b	35.43	mod-source-record-manager-b	45.19
mod-source-record-manager-b	31.36	mod-feesfines-b	31.25
okapi-b	30.47	mod-configuration-b	30.86
mod-inventory-storage-b	27.04	mod-quick-marc-b	28.68
mod-feesfines-b	4.04	mod-pubsub-b	24.75
mod-configuration-b	3.60	mod-circulation-b	23.42
mod-remote-storage-b	3.45	mod-data-import-b	21.38
mod-authtoken-b	2.48	mod-authtoken-b	21.31
mod-circulation-storage-b	2.04	mod-remote-storage-b	19.90
mod-users-bl-b	0.61	mod-users-bl-b	19.14
mod-circulation-b	0.58	mod-circulation-storage-b	18.43
mod-users-b	0.53	mod-inventory-storage-b	15.48
mod-patron-blocks-b	0.48	mod-users-b	12.48
mod-data-import-b	0.19	mod-patron-blocks-b	10.41

Service CPU Utilization

Here we can see that mod-inventory-b module used 84% CPU and mod-quick-marc-b used 74% CPU

Service Memory Utilization

Here we can see that all modules show a stable trend.

DB CPU Utilization

DB CPU was 80%.

DB Connections

DB connections was 1000.

Resource utilization for Test #3

Resource utilization table

CPU		Memory
mod-feesfines-b	66.73	okapi-b	64.09
okapi-b	59.37	mod-circulation-b	44.07
mod-authtoken-b	58.64	mod-inventory-b	42.33
mod-pubsub-b	38.48	mod-pubsub-b	35.32
mod-configuration-b	34.05	mod-feesfines-b	34.67
mod-circulation-b	24.34	mod-configuration-b	31.42
mod-circulation-storage-b	16.03	mod-quick-marc-b	26.01
mod-inventory-b	12.09	mod-authtoken-b	24.10
mod-inventory-storage-b	11.17	mod-source-record-manager-b	24.04
mod-quick-marc-b	6.49	mod-circulation-storage-b	21.40
mod-users-b	4.77	mod-users-bl-b	19.80
mod-source-record-manager-b	1.91	mod-source-record-storage-b	18.27
mod-patron-blocks-b	1.36	mod-remote-storage-b	17.14
mod-source-record-storage-b	1.26	mod-data-import-b	12.86
mod-remote-storage-b	1.15	mod-inventory-storage-b	12.11
mod-users-bl-b	0.61	mod-users-b	11.82
mod-data-import-b	0.14	mod-patron-blocks-b	10.76

Service CPU Utilization

Here we can see that mod-feesfines-b, okapi-b and mod-authtoken-b modules used 60% CPU

Service Memory Utilization

Here we can see that okapi-b module used 64% memory.

DB CPU Utilization

DB CPU was 40% in spike.

DB Connections

DB connections was 2560.

Resource utilization for Test #3 RERUN

Resource utilization table

CPU		Memory
mod-feesfines-b	56.93	okapi-b	68.05
okapi-b	56.54	mod-inventory-b	54.83
mod-authtoken-b	55.48	mod-circulation-b	38.20
mod-pubsub-b	35.44	mod-pubsub-b	35.15
mod-configuration-b	32.67	mod-feesfines-b	33.04
mod-circulation-b	27.57	mod-configuration-b	32.53
mod-circulation-storage-b	16.37	mod-quick-marc-b	26.15
mod-inventory-b	14.83	mod-source-record-manager-b	25.26
mod-quick-marc-b	14.39	mod-authtoken-b	23.87
mod-inventory-storage-b	12.23	mod-source-record-storage-b	21.52
mod-users-b	5.05	mod-users-bl-b	19.39
mod-source-record-manager-b	2.38	mod-circulation-storage-b	17.63
mod-source-record-storage-b	1.59	mod-remote-storage-b	17.48
mod-remote-storage-b	1.38	mod-inventory-storage-b	14.66
mod-patron-blocks-b	1.28	mod-data-import-b	12.82
mod-users-bl-b	0.67	mod-patron-blocks-b	11.74
mod-data-import-b	0.18	mod-users-b	11.06

Service CPU Utilization

Here we can see that mod-feesfines-b, okapi-b module and mod-authtoken-b used 55-57% CPU.

Service Memory Utilization

Here we can see that mod-source-record-storage module used 99% memory.

DB CPU Utilization

DB CPU was 15% in average.

DB Connections

DB connections was 2864.

DB load

DB for test was db.r6g4xlarge

Top SQL-queries

Resource utilization for Test #4

Resource utilization table

CPU		Memory
nginx-okapi	706.73	mod-source-record-storage-b	91.99
okapi-b	85.00	okapi-b	67.34
mod-quick-marc-b	60.05	mod-search-b	59.65
mod-authtoken-b	58.13	mod-source-record-manager-b	44.72
mod-inventory-storage-b	56.90	mod-pubsub-b	36.46
mod-feesfines-b	54.78	mod-feesfines-b	32.87
mod-source-record-storage-b	43.10	mod-configuration-b	31.33
mod-pubsub-b	37.72	mod-quick-marc-b	30.80
mod-source-record-manager-b	29.36	mod-circulation-b	28.43
pub-okapi	23.17	mod-users-bl-b	24.78
mod-configuration-b	22.23	mod-authtoken-b	23.57
mod-circulation-b	12.29	mod-remote-storage-b	22.81
mod-circulation-storage-b	10.34	mod-data-import-b	18.46
mod-users-b	5.08	mod-circulation-storage-b	16.33
mod-search-b	5.04	mod-inventory-storage-b	14.95
mod-data-import-b	4.29	mod-inventory-update-b	14.79
mod-remote-storage-b	3.78	mod-users-b	10.89
mod-di-converter-storage-b	3.43	mod-di-converter-storage-b	9.23
mod-inventory-update-b	2.32	nginx-okapi	5.08
mod-users-bl-b	0.73	pub-okapi	4.69

Service CPU Utilization

Here we can see that nginx-okapi module used 710% CPU

Service Memory Utilization

Here we can see that mod-source-record-storage module used 91% memory.

DB CPU Utilization

DB CPU was 80% in average.

DB Connections

DB connections was 3670.

Resource utilization for Test #5

Resource utilization table

CPU		Memory
nginx-okapi	545.76	mod-source-record-storage-b	88.39
okapi-b	72.96	okapi-b	63.43
mod-authtoken-b	60.72	mod-search-b	60.60
mod-feesfines-b	55.23	mod-source-record-manager-b	45.74
mod-inventory-storage-b	44.31	mod-feesfines-b	32.70
mod-pubsub-b	39.30	mod-configuration-b	29.80
mod-quick-marc-b	37.50	mod-pubsub-b	27.95
mod-configuration-b	33.26	mod-quick-marc-b	26.38
pub-okapi	24.23	mod-circulation-b	25.60
mod-source-record-storage-b	19.63	mod-data-import-b	23.93
mod-circulation-b	9.43	mod-authtoken-b	22.74
mod-source-record-manager-b	8.84	mod-remote-storage-b	20.63
mod-remote-storage-b	8.02	mod-users-bl-b	19.64
mod-circulation-storage-b	6.16	mod-circulation-storage-b	16.75
mod-users-b	5.39	mod-inventory-storage-b	16.01
mod-search-b	5.10	mod-inventory-update-b	13.10
mod-inventory-update-b	2.39	mod-users-b	9.78
mod-di-converter-storage-b	1.12	mod-di-converter-storage-b	8.61
mod-users-bl-b	0.67	nginx-okapi	5.13
mod-data-import-b	0.58	pub-okapi	4.74

Service CPU Utilization

Here we can see that nginx-okapi module used 542% CPU

Service Memory Utilization

Here we can see that mod-source-record-storage module used 90% memory.

DB CPU Utilization

DB CPU was 90% in average.

DB Connections

DB connections was 2660.

Resource utilization for Test #6

Resource utilization table

CPU		Memory
nginx-okapi	800.67	mod-source-record-storage-b	100.66
okapi-b	82.04	okapi-b	68.87
mod-quick-marc-b	74.11	mod-search-b	63.51
mod-authtoken-b	67.47	mod-source-record-manager-b	52.64
mod-feesfines-b	55.23	mod-feesfines-b	32.87
mod-inventory-storage-b	51.45	mod-configuration-b	30.19
mod-source-record-storage-b	41.97	mod-circulation-b	28.82
mod-pubsub-b	38.52	mod-pubsub-b	27.09
mod-configuration-b	32.33	mod-quick-marc-b	26.70
pub-okapi	27.41	mod-authtoken-b	23.09
mod-source-record-manager-b	23.20	mod-remote-storage-b	21.99
mod-circulation-b	12.11	mod-users-bl-b	20.88
mod-circulation-storage-b	8.15	mod-circulation-storage-b	19.86
mod-users-b	5.73	mod-inventory-storage-b	18.01
mod-di-converter-storage-b	3.12	mod-data-import-b	16.64
mod-inventory-update-b	2.66	mod-inventory-update-b	13.52
mod-search-b	2.43	mod-users-b	10.52
mod-remote-storage-b	1.97	mod-di-converter-storage-b	8.86
mod-users-bl-b	0.71	nginx-okapi	5.25
mod-data-import-b	0.22	pub-okapi	4.85

Service CPU Utilization

Here we can see that nginx-okapi module used 800% CPU

Service Memory Utilization

Here we can see that mod-source-record-storage module used 100% memory.

DB CPU Utilization

DB CPU was 90% in average.

DB Connections

DB connections was 2100.

Resource utilization for Test #7

Resource utilization table

CPU		Memory
nginx-okapi	743.5982	mod-source-record-storage-b	99.05244
okapi-b	78.32452	mod-search-b	78.05208
mod-feesfines-b	58.93508	okapi-b	73.98148
mod-inventory-storage-b	52.86103	mod-source-record-manager-b	67.66418
mod-quick-marc-b	52.38367	mod-pubsub-b	33.90434
mod-source-record-storage-b	47.23491	mod-feesfines-b	33.70536
mod-authtoken-b	46.50385	mod-circulation-b	31.94444
mod-configuration-b	34.16867	mod-configuration-b	30.63616
mod-pubsub-b	33.19999	mod-quick-marc-b	27.25184
mod-source-record-manager-b	30.41597	mod-inventory-storage-b	24.07192
pub-okapi	25.2142	mod-data-import-b	23.55014
mod-circulation-b	9.686785	mod-authtoken-b	23.38035
mod-circulation-storage-b	8.187569	mod-remote-storage-b	22.36304
mod-users-b	4.803039	mod-users-bl-b	21.85395
mod-search-b	4.225501	mod-circulation-storage-b	21.59892
mod-di-converter-storage-b	3.565921	mod-inventory-update-b	15.06696
mod-data-import-b	3.477813	mod-di-converter-storage-b	10.24956
mod-inventory-update-b	2.406785	mod-users-b	10.22916
mod-remote-storage-b	2.043342	nginx-okapi	5.301339
mod-users-bl-b	0.726815	pub-okapi	4.854911

Service CPU Utilization

Here we can see that nginx-okapi module used 750% CPU

Service Memory Utilization

Here we can see that mod-source-record-storage module used 99% memory.

DB CPU Utilization

DB CPU was 95% in average.

DB Connections

DB connections was 2875.

Resource utilization for Test #8

Resource utilization table

CPU		Memory
nginx-okapi	764.0156	mod-source-record-storage-b	97.0883
okapi-b	78.34773	mod-search-b	73.32661
mod-feesfines-b	62.19026	okapi-b	67.15355
mod-source-record-storage-b	55.95898	mod-source-record-manager-b	61.89295
mod-authtoken-b	51.01338	mod-feesfines-b	33.00634
mod-quick-marc-b	48.98675	mod-pubsub-b	32.40759
mod-inventory-storage-b	40.04606	mod-configuration-b	31.41741
mod-pubsub-b	34.82182	mod-quick-marc-b	29.59329
mod-source-record-manager-b	31.3457	mod-circulation-b	26.46058
pub-okapi	27.53193	mod-circulation-storage-b	26.17569
mod-configuration-b	25.44523	mod-authtoken-b	23.52431
mod-circulation-b	12.58609	mod-remote-storage-b	21.19739
mod-circulation-storage-b	5.865943	mod-users-bl-b	20.15625
mod-users-b	5.412809	mod-data-import-b	19.73035
mod-search-b	5.280313	mod-inventory-storage-b	19.23368
mod-di-converter-storage-b	3.394114	mod-inventory-update-b	14.67634
mod-remote-storage-b	2.791721	mod-di-converter-storage-b	10.54878
mod-inventory-update-b	2.723644	mod-users-b	9.769648
mod-users-bl-b	0.754545	nginx-okapi	5.245536
mod-data-import-b	0.189872	pub-okapi	4.799107

Service CPU Utilization

Here we can see that nginx-okapi module used 750% CPU

Service Memory Utilization

Here we can see that mod-source-record-storage module used 96% memory.

DB CPU Utilization

DB CPU was 90% in average.

DB Connections

DB connections was 3348.

DB load

Top SQL-queries

Resource utilization for Test #9

Resource utilization table

CPU		Memory
nginx-okapi	744.73	mod-source-record-storage-b	96.08
okapi-b	79.22	mod-source-record-manager-b	66.85
mod-authtoken-b	75.31	okapi-b	64.54
mod-quick-marc-b	70.95	mod-search-b	59.53
mod-feesfines-b	53.46	mod-feesfines-b	32.34
mod-inventory-storage-b	45.80	mod-configuration-b	31.42
mod-source-record-storage-b	41.77	mod-circulation-b	30.75
mod-pubsub-b	37.73	mod-quick-marc-b	27.02
mod-source-record-manager-b	30.88	mod-remote-storage-b	25.83
mod-configuration-b	28.50	mod-pubsub-b	25.53
pub-okapi	26.59	mod-authtoken-b	22.72
mod-circulation-b	11.38	mod-data-import-b	21.60
mod-circulation-storage-b	7.30	mod-users-bl-b	19.12
mod-users-b	5.63	mod-circulation-storage-b	17.24
mod-remote-storage-b	5.11	mod-inventory-storage-b	16.80
mod-data-import-b	4.20	mod-inventory-update-b	12.09
mod-search-b	4.14	mod-users-b	10.14
mod-di-converter-storage-b	3.49	mod-di-converter-storage-b	9.06
mod-inventory-update-b	1.45	nginx-okapi	5.13
mod-users-bl-b	0.79	pub-okapi	4.80

Service CPU Utilization

Here we can see that nginx-okapi module used 740% CPU

Service Memory Utilization

Here we can see that mod-source-record-storage module used 95% memory.

DB CPU Utilization

DB CPU was 90% in average.

DB Connections

DB connections was 2336.

DB load

Top SQL-queries

Resource utilization for Test #10

Resource utilization table

CPU		Memory
nginx-okapi	710.05	mod-source-record-storage-b	94.67
okapi-b	77.35	mod-search-b	74.13
mod-feesfines-b	66.29	okapi-b	64.00
mod-authtoken-b	54.98	mod-source-record-manager-b	50.57
mod-quick-marc-b	50.21	mod-circulation-b	43.44
mod-source-record-storage-b	50.20	mod-pubsub-b	34.06
mod-pubsub-b	41.74	mod-feesfines-b	32.49
mod-inventory-storage-b	41.17	mod-configuration-b	30.12
mod-configuration-b	30.62	mod-quick-marc-b	28.64
pub-okapi	28.33	mod-authtoken-b	22.87
mod-source-record-manager-b	24.54	mod-remote-storage-b	22.83
mod-circulation-b	11.22	mod-circulation-storage-b	20.81
mod-circulation-storage-b	8.05	mod-users-bl-b	19.05
mod-remote-storage-b	6.17	mod-data-import-b	17.36
mod-users-b	5.43	mod-inventory-storage-b	16.62
mod-di-converter-storage-b	4.18	mod-inventory-update-b	13.12
mod-search-b	2.87	mod-users-b	10.66
mod-inventory-update-b	2.70	mod-di-converter-storage-b	9.41
mod-users-bl-b	0.85	nginx-okapi	5.02
mod-data-import-b	0.21	pub-okapi	4.63

Service CPU Utilization

Here we can see that nginx-okapi module used 700% CPU

Service Memory Utilization

Here we can see that mod-source-record-storage module used 93% memory.

DB CPU Utilization

DB CPU was 90% in average.

DB Connections

DB connections was 2974.

DB load

Top SQL-queries

Resource utilization for Test #11

Resource utilization table

CPU		Memory
nginx-okapi	734.55	mod-source-record-storage-b	99.04
okapi-b	82.42	mod-search-b	72.71
mod-quick-marc-b	80.44	okapi-b	71.69
mod-authtoken-b	67.86	mod-source-record-manager-b	58.73
mod-inventory-storage-b	55.37	mod-circulation-b	45.43
mod-feesfines-b	53.40	mod-feesfines-b	32.59
mod-source-record-storage-b	46.45	mod-configuration-b	30.81
mod-pubsub-b	38.01	mod-pubsub-b	29.67
mod-configuration-b	35.18	mod-quick-marc-b	28.91
mod-source-record-manager-b	31.18	mod-circulation-storage-b	24.21
pub-okapi	27.91	mod-remote-storage-b	23.37
mod-circulation-b	9.91	mod-authtoken-b	23.17
mod-circulation-storage-b	7.97	mod-data-import-b	22.03
mod-users-b	6.81	mod-inventory-storage-b	21.49
mod-di-converter-storage-b	4.02	mod-users-bl-b	20.10
mod-search-b	3.44	mod-inventory-update-b	13.37
mod-data-import-b	3.23	mod-users-b	10.58
mod-inventory-update-b	2.67	mod-patron-blocks-b	8.93
mod-users-bl-b	2.47	mod-di-converter-storage-b	8.84
mod-remote-storage-b	2.42	nginx-okapi	5.17
mod-patron-blocks-b	2.17	pub-okapi	4.80

Service CPU Utilization

Here we can see that nginx-okapi module used 700% CPU.

Service Memory Utilization

Here we can see that mod-source-record-storage module used 99% memory.

DB CPU Utilization

DB CPU was 95% in average.

DB Connections

DB connections was 3378.

DB load

Top SQL-queries

Discussion

Tests involving data import are experiencing errors due to database connection timeouts.

error in UI

error in Logs Insights

Appendix

Infrastructure

PTF - environment pmpt

10 m6g.2xlarge EC2 instances located in US East (N. Virginia)us-east-1
1 database instances, writer
Name Memory GIB vCPUs
db.r6g.4xlarge
128 GiB 16 vCPUs
MSK ptf-mobius-testing2
- 2 m5.2xlarge brokers in 2 zones
- Apache Kafka version 2.8.0
- EBS storage volume per broker 300 GiB
- auto.create.topics.enable=true
- log.retention.minutes=480
- default.replication.factor=2

Modules memory and CPU parameters

Module pmpt-pvt Thu Mar 07 14:07:02 UTC 2024	Task Def. Revision	Module Version	Task Count	Mem Hard Limit	Mem Soft limit	CPU units	Xmx	MetaspaceSize	MaxMetaspaceSize	R/W split enabled
mod-remote-storage	4	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-remote-storage:3.0.1	2	4920	4472	1024	3960	512	512	FALSE
mod-data-import	7	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-data-import:3.0.7-RMB985	1	4096	3690	2048	3076	384	512	FALSE
mod-authtoken	4	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-authtoken:2.14.1	2	1440	1152	512	922	88	128	FALSE
mod-inventory-update	4	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-inventory-update:3.2.1	2	1024	896	128	768	88	128	FALSE
mod-configuration	4	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-configuration:5.9.2	2	1024	896	128	768	88	128	FALSE
mod-users-bl	4	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-users-bl:7.6.0	2	1440	1152	512	922	88	128	FALSE
mod-inventory-storage	23	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-inventory-storage:27.0.4-RMB985	2	4096	3690	2048	3076	384	512	FALSE
mod-circulation-storage	9	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-circulation-storage:17.1.7-RMB985	2	4096	3690	2048	3076	384	512	FALSE
mod-source-record-storage	11	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-source-record-storage:5.7.5-RMB985	2	4096	3690	2048	3076	384	512	FALSE
mod-pubsub	6	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-pubsub:2.11.3-RMB985	2	4096	3690	2048	3076	384	512	FALSE
mod-circulation	7	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-circulation:24.0.11	2	2880	2592	1536	1814	384	512	FALSE
mod-users	5	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-users:19.2.2-RMB985	2	4096	3690	2048	3076	384	512	FALSE
mod-patron-blocks	5	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-patron-blocks:1.9.0-RMB985	2	4096	3690	2048	3076	384	512	FALSE
mod-source-record-manager	10	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-source-record-manager:3.7.7-RMB985	2	4096	3690	2048	3076	384	512	FALSE
mod-quick-marc	4	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-quick-marc:5.0.1	1	2288	2176	128	1664	384	512	FALSE
okapi-b	3	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/okapi:5.1.2	3	1684	1440	1024	922	384	512	FALSE
mod-feesfines	4	579891902283.dkr.ecr.us-east-1.amazonaws.com/folio/mod-feesfines:19.0.0	2	1024	896	128	768	88	128	FALSE

Methodology/Approach

RMB connection caching implementation tests were started by Carrier-IO.

So, perform a baseline test with individual module/tenant connection pool with the default value of DB_MAXPOOLSIZE on ONE tenant . Then, create a new task definition to set the shared pool DB_MAXSHAREDPOOLSIZE to the derived value as explained above and repeat the test on ONE tenant. The baseline test scenario is CICO 8 users with a DI Create MARC BIB records of 25K running in the background.

Run data preparation script before each CI/CO test
Create artefacts and upload to carrier-io: MobiusLike and MobiusLikeOneT
Use Carrier-io to change parameters and run tests
Setup DB_MAXPOOLSIZE=20 parameter for list of modules and executed check-in\check-out test with 8 users for one tenant, plus Data Import Create MARC BIB records of 25K running in the background

Modules	Parameter
mod-inventory-storage	DB_MAXPOOLSIZE=20
mod-source-record-storage	DB_MAXPOOLSIZE=20
mod-source-record-manager	DB_MAXPOOLSIZE=20
mod-di-converter-storage	DB_MAXPOOLSIZE=20
mod-data-import	DB_MAXPOOLSIZE=20
mod-permissions	DB_MAXPOOLSIZE=20
mod-circulation-storage	DB_MAXPOOLSIZE=20
mod-patron-blocks	DB_MAXPOOLSIZE=20
mod-pubsub	DB_MAXPOOLSIZE=20
mod-users	DB_MAXPOOLSIZE=20

Setup DB_MAXSHAREDPOOLSIZE=40 parameter mod-inventory-storage module and executed check-in\check-out test with 8 users for one tenant, plus Data Import Create MARC BIB records of 25K running in the background

Modules	Parameter
mod-inventory-storage	DB_MAXSHAREDPOOLSIZE=40
others	DB_MAXPOOLSIZE=20

Setup DB_MAXSHAREDPOOLSIZE=40 parameter mod-inventory-storage, mod-circulation-storage modules and executed check-in\check-out test with 8 users for one tenant, plus Data Import Create MARC BIB records of 25K running in the background

Modules	Parameter
mod-inventory-storage	DB_MAXSHAREDPOOLSIZE=40
mod-circulation-storage	DB_MAXSHAREDPOOLSIZE=40
others	DB_MAXPOOLSIZE=20

Setup DB_MAXSHAREDPOOLSIZE=2500 parameter for mod-inventory-storage, DB_MAXSHAREDPOOLSIZE=500 for parameter mod-circulation-storage modules and executed check-in\check-out test with 305 users for 61 tenants, plus Data Import Create MARC BIB records of 10K running in the background

Modules	Parameter
mod-inventory-storage	DB_MAXSHAREDPOOLSIZE=2500
mod-circulation-storage	DB_MAXSHAREDPOOLSIZE=500
others	DB_MAXPOOLSIZE=20

Setup DB_MAXSHAREDPOOLSIZE=40 parameter for all 10 modules and executed check-in\check-out test with 305 users for 61 tenants, plus Data Import Create MARC BIB records of 10K running in the background

Modules	Parameter
all list	DB_MAXSHAREDPOOLSIZE=40

Setup DB_MAXSHAREDPOOLSIZE=70 parameter for all 10 modules and executed check-in\check-out test with 305 users for 61 tenants, plus Data Import Create MARC BIB records of 10K running in the background

Modules	Parameter
all list	DB_MAXSHAREDPOOLSIZE=70

Setup DB_MAXSHAREDPOOLSIZE=140 parameter for all 10 modules and executed check-in\check-out test with 305 users for 61 tenants, plus Data Import Create MARC BIB records of 10K running in the background

Modules	Parameter
all list	DB_MAXSHAREDPOOLSIZE=140

Setup DB_MAXSHAREDPOOLSIZE=210 parameter for all 10 modules and executed check-in\check-out test with 305 users for 61 tenants, plus Data Import Create MARC BIB records of 10K running in the background

Modules	Parameter
all list	DB_MAXSHAREDPOOLSIZE=210

Setup DB_MAXSHAREDPOOLSIZE=210 parameter for mod-inventory-storage, DB_MAXSHAREDPOOLSIZE=70 for others modules and executed check-in\check-out test with 305 users for 61 tenants, plus Data Import Create MARC BIB records of 10K running in the background

Modules	Parameter
mod-inventory-storage	DB_MAXSHAREDPOOLSIZE=210
others	DB_MAXSHAREDPOOLSIZE=70

Setup DB_MAXSHAREDPOOLSIZE=210 parameter for mod-inventory-storage, DB_MAXSHAREDPOOLSIZE=140 for others modules and executed check-in\check-out test with 305 users for 61 tenants, plus Data Import Create MARC BIB records of 10K running in the background

Modules	Parameter
mod-inventory-storage	DB_MAXSHAREDPOOLSIZE=210
others	DB_MAXSHAREDPOOLSIZE=140

Setup DB_MAXSHAREDPOOLSIZE=280 parameter for all 10 modules and executed check-in\check-out test with 305 users for 61 tenants, plus Data Import Create MARC BIB records of 10K running in the background

Modules	Parameter
all list	DB_MAXSHAREDPOOLSIZE=280