Overview IN PROGRESS

This document contains the results of testing workflows Check-in/Check-out and Data Import for MARC Bibliographic records in the Quesnelia release with a new MSK instance type. The main idea is to see how the m7g series affects FOLIO performance. Compared results for main workflows with different instance types: kafka.m5.2xlarge against kafka.m7g.2xlarge.

Ticket: PERF-921 - Getting issue details... STATUS

Summary

Comparing kafka.m5.2xlarge against kafka.m7g.2xlarge instance type
- Check-in / Check-out perform better in ........
- DI durations ..........
Resource utilization
- Average CPU utilization did not exceed -----
- Memory .......
- Average DB CPU usage
- Average connection count

Test Runs

Test #	MSK instance type	Scenario	Load level
1	kafka.m5.2xlarge	CICO + DI MARC Bib Create	8 users + 5K, 25K sequentially
2		DI MARC Bib Create	5K, 25K sequentially
3		CICO + DI MARC Bib Update	8 users + 5K, 25K sequentially
4		DI MARC Bib Update	5K, 25K sequentially
5	kafka.m7g.2xlarge	CICO + DI MARC Bib Create	8 users + 5K, 25K sequentially
6		DI MARC Bib Create	5K, 25K sequentially
7		CICO + DI MARC Bib Update	8 users + 5K, 25K sequentially
8		DI MARC Bib Update	5K, 25K sequentially

Test Results

This table shows results of Check-In/Check-out and Data Import create and update jobs.

The only difference between tests is MSK cluster instance type. Cluster ptf-mobius-testing2 has kafka.m5.2xlarge and cluster PERF-921 has kafka.m7g.2xlarge

MSK instance: kafka.m5.2xlarge	File size	DI Duration without CI/CO	DI Duration	CI Average sec	CO Average sec
Create	5k	00:02:31	00:02:54	0.899	1.409
	25k	00:11:49	00:12:49	0.724	1.152
Update	5k	00:03:06	00:03:14	0.807	1.257
	25k	00:15:00	00:15:30	0.784	1.275
MSK instance: kafka.m7g.2xlarge
Create	5k
	25k
Update	5k
	25k

Check-in/Check-out without DI

Scenario	Load level	Request	Response time, sec MSK instance: kafka.m5.2xlarge		Response time, sec MSK instance: kafka.m7g.2xlarge
Scenario	Load level	Request	95 perc	average	95 perc	average
Circulation Check-in/Check-out (without Data import)	8 users	Check-in	0.669	0.570
Circulation Check-in/Check-out (without Data import)	8 users	Check-out	1.152	0.960

Comparison

The following table compares test results of two MSK clusters.

This table show comparison results of CICO without Data Import in two MSK clusters

Scenario	Load level	Request	Response time, sec		Response time, sec		Delta
			MSK instance: kafka.m5.2xlarge		MSK instance: kafka.m7g.2xlarge
			95 perc	Average	95 perc	Average	Average
Circulation Check-in/Check-out (without Data import)	8 users	Check-in	0.669	0.570
		Check-out	1.152	0.960

Response time

MSK instance: kafka.m5.2xlarge

Service CPU Utilization

MSK instance: kafka.m5.2xlarge

CPU utilization MSK instance: kafka.m5.2xlarge

Module	CPU (CICO + 25k Create)	CPU (CICO + 25k Update)
mod-inventory-b	110.54	145.5
mod-quick-marc-b	90.64	102.38
mod-di-converter-storage-b	78.09	121.08
nginx-okapi	64.1	98.19
okapi-b	39.14	58.73
mod-source-record-storage-b	28.06	44.84
mod-users-b	23.41	20.28
mod-inventory-storage-b	20.17	24.74
mod-source-record-manager-b	18.9	19.54
mod-feesfines-b	17.74	8.11
mod-configuration-b	14.55	10.3
mod-dcb-b	12.3	11.91
mod-authtoken-b	7.67	11.87
mod-search-b	7.32	6
mod-pubsub-b	6.35	6.8
mod-entities-links-b	3.58	2.26
pub-okapi	3.42	3.4
mod-patron-b	2.84	2.77
mod-circulation-storage-b	2.83	2.91
mod-data-import-b	2.04	1.65
mod-circulation-b	1.92	1.6
edge-patron-b	1.15	1.16
mod-patron-blocks-b	0.99	0.81
mod-users-bl-b	0.85	2.51
pub-edge	0.07	0.07

DI MARC BIB Create and Update + CICO

Service Memory Utilization

MSK instance: kafka.m5.2xlarge

Memory consumption

Module	Memory
mod-dcb-b	68.81
mod-inventory-b	68.23
mod-users-b	50.17
mod-di-converter-storage-b	48.62
mod-feesfines-b	45.56
mod-inventory-storage-b	45.32
mod-source-record-storage-b	44.27
okapi-b	41.85
mod-data-import-b	41.42
mod-patron-blocks-b	41.04
mod-search-b	40.55
mod-users-bl-b	39.82
mod-configuration-b	38.78
mod-source-record-manager-b	38.45
mod-pubsub-b	36.86
mod-quick-marc-b	31.25
mod-patron-b	31.19
mod-entities-links-b	27.12
mod-authtoken-b	26.17
mod-circulation-b	24.17
edge-patron-b	22.77
mod-circulation-storage-b	20.02
nginx-okapi	4.69
pub-okapi	4.52
pub-edge	4.46

DB CPU Utilization

MSK instance: kafka.m5.2xlarge

Average DB CPU usage during data import is 85% during create jobs and 87& during Update jobs. Check-In/Check-Out period without DI - 15%.

DB Connections

MSK instance: kafka.m5.2xlarge

Average connection count during data import is about 850 connections for create and update jobs with CI/CO. And 730 connections for CI/CO without data import

MSK resources table

MSK instance: kafka.m5.2xlarge
Disk usage	Idle state
	1	0.2095713
	2	0.2086522
	Under load
	1	4.6120204
	2	4.611104
CPU usage	Idle state
	1	0.93541725
	2	0.78333345
	Under load
CICO	1	13.7625025
	2	11.9479163
CICO+DI	1	38.0916663
	2	33.8229113

Disk usage by broker

MSK instance: kafka.m5.2xlarge

CPU (User) usage by broker

MSK instance: kafka.m5.2xlarge

DB load

MSK instance: kafka.m5.2xlarge

Top SQL-queries:

AppendixInfrastructure

PTF -environment qcp1

10 m6i.2xlarge EC2 instances located in US East (N. Virginia)us-east-1
1 database instance, writer
Name Memory GIB vCPUs max_connections
db.r6g.xlarge
32 GiB 4 vCPUs 2731
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=3

Task count for modules mod-agreements, mod-serials-management, mod-graphql set to 0 during tests.

Modules

All qcp1 modules

Module	Task Def. Revision	Module Version	Task Count	Mem Hard Limit	Mem Soft limit	CPU units	Xmx	MetaspaceSize	MaxMetaspaceSize
qcp1-pvt
Tue Jun 04 07:31:53 UTC 2024
mod-remote-storage	4	mod-remote-storage:3.2.0	2	4920	4472	1024	3960	512	512
mod-ncip	4	mod-ncip:1.14.4	2	1024	896	128	768	88	128
mod-finance-storage	4	mod-finance-storage:8.6.0	2	1024	896	1024	700	88	128
mod-agreements	4	mod-agreements:7.0.0	2	1592	1488	128	0	0	0
mod-ebsconet	4	mod-ebsconet:2.2.0	2	1248	1024	128	700	128	256
mod-organizations	4	mod-organizations:1.9.0	2	1024	896	128	700	88	128
mod-consortia	2	mod-consortia:1.1.0	2	3072	2048	128	2048	512	1024
edge-sip2	2	edge-sip2:3.2.0-SNAPSHOT.209	2	1024	896	128	768	88	128
mod-serials-management	4	mod-serials-management:1.0.0	2	2480	2312	128	1792	384	512
mod-settings	4	mod-settings:1.0.3	2	1024	896	200	768	88	128
mod-data-import	7	mod-data-import:3.1.0	1	2048	1844	256	1292	384	512
edge-dematic	4	edge-dematic:2.2.0	1	1024	896	128	768	88	128
mod-search	4	mod-search:3.2.0	2	2592	2480	2048	1440	512	1024
mod-inn-reach	2	mod-inn-reach:3.2.0-SNAPSHOT.86	2	3600	3240	1024	2880	512	1024
mod-tags	4	mod-tags:2.2.0	2	1024	896	128	768	88	128
edge-courses	4	edge-courses:1.4.0	2	1024	896	128	768	88	128
mod-authtoken	5	mod-authtoken:2.15.1	2	1440	1152	512	922	88	128
mod-inventory-update	4	mod-inventory-update:3.3.0	2	1024	896	128	768	88	128
mod-notify	4	mod-notify:3.2.0	2	1024	896	128	768	88	128
mod-configuration	4	mod-configuration:5.10.0	2	1024	896	128	768	88	128
mod-orders-storage	4	mod-orders-storage:13.7.0	2	1024	896	512	700	88	128
edge-caiasoft	4	edge-caiasoft:2.2.0	2	1024	896	128	768	88	128
mod-login-saml	4	mod-login-saml:2.8.0	2	1024	896	128	768	88	128
mod-erm-usage-harvester	4	mod-erm-usage-harvester:4.5.0	2	1024	896	128	768	88	128
mod-licenses	4	mod-licenses:6.0.0	2	2480	2312	128	1792	384	512
mod-gobi	4	mod-gobi:2.8.0	2	1024	896	128	700	88	128
mod-password-validator	4	mod-password-validator:3.2.0	2	1440	1298	128	768	384	512
mod-bulk-operations	4	mod-bulk-operations:2.0.0	2	3072	2600	1024	1536	384	512
mod-fqm-manager	4	mod-fqm-manager:2.0.1	2	3000	2600	128	2048	384	512
edge-dcb	4	edge-dcb:1.1.0	2	1024	896	128	768	88	128
mod-graphql	5	mod-graphql:1.12.1	2	1024	896	128	768	88	128
mod-finance	4	mod-finance:4.9.0	2	1024	896	128	700	88	128
mod-erm-usage	4	mod-erm-usage:4.7.0	2	1024	896	128	768	88	128
mod-batch-print	5	mod-batch-print:1.1.0	2	1024	896	128	768	88	128
mod-copycat	4	mod-copycat:1.6.0	2	1024	512	128	768	88	128
mod-lists	4	mod-lists:2.0.0	2	3000	2600	128	2048	384	512
mod-entities-links	5	mod-entities-links:3.0.0	2	2592	2480	400	1440	0	1024
mod-permissions	8	mod-permissions:6.5.0	2	1684	1544	512	1024	384	512
pub-edge	3	pub-edge:2023.06.14	2	1024	896	128	768	0	0
mod-orders	4	mod-orders:12.8.0	2	2048	1440	1024	1024	384	512
edge-patron	4	edge-patron:5.1.0	2	1024	896	256	768	88	128
edge-ncip	4	edge-ncip:1.9.2	2	1024	896	128	768	88	128
edge-inn-reach	2	edge-inn-reach:3.1.1-SNAPSHOT.45	2	1024	896	128	768	88	128
mod-users-bl	4	mod-users-bl:7.7.0	2	1440	1152	512	922	88	128
mod-oa	2	mod-oa:2.1.0-SNAPSHOT.62	2	1024	896	128	768	88	128
mod-inventory-storage	4	mod-inventory-storage:27.1.0	2	4096	3690	2048	3076	384	512
mod-invoice	5	mod-invoice:5.8.0	2	1440	1152	512	922	88	128
mod-user-import	4	mod-user-import:3.8.0	2	1024	896	128	768	88	128
mod-sender	5	mod-sender:1.12.0	2	1024	896	128	768	88	128
edge-oai-pmh	4	edge-oai-pmh:2.9.0	2	1512	1360	1024	1440	384	512
mod-data-export-worker	4	mod-data-export-worker:3.2.1	2	3072	2048	1024	2048	384	512
mod-rtac	4	mod-rtac:3.6.0	2	1024	896	128	768	88	128
mod-circulation-storage	4	mod-circulation-storage:17.2.0	2	2880	2592	1536	1814	384	512
mod-calendar	4	mod-calendar:3.1.0	2	1024	896	128	768	88	128
mod-source-record-storage	4	mod-source-record-storage:5.8.0	2	5600	5000	2048	3500	384	512
mod-event-config	4	mod-event-config:2.7.0	2	1024	896	128	768	88	128
mod-courses	4	mod-courses:1.4.10	2	1024	896	128	768	88	128
mod-circulation-item	4	mod-circulation-item:1.0.0	2	1024	896	128	0	0	0
mod-inventory	4	mod-inventory:20.2.0	2	2880	2592	1024	1814	384	512
mod-email	4	mod-email:1.17.0	2	1024	896	128	768	88	128
mod-pubsub	4	mod-pubsub:2.13.0	2	1536	1440	1024	922	384	512
mod-circulation	4	mod-circulation:24.2.0	2	2880	2592	1536	1814	384	512
mod-di-converter-storage	4	mod-di-converter-storage:2.2.0	2	1024	896	128	768	88	128
edge-rtac	4	edge-rtac:2.7.1	2	1024	896	128	768	88	128
edge-orders	4	edge-orders:3.0.0	2	1024	896	128	768	88	128
mod-users	5	mod-users:19.3.1	2	1024	896	128	768	88	128
mod-template-engine	4	mod-template-engine:1.20.0	2	1024	896	128	768	88	128
mod-patron-blocks	4	mod-patron-blocks:1.10.0	2	1024	896	1024	768	88	128
mod-audit	4	mod-audit:2.9.0	2	1024	896	128	768	88	128
edge-fqm	4	edge-fqm:2.0.0	2	1024	896	128	768	88	128
mod-source-record-manager	5	mod-source-record-manager:3.9.0-SNAPSHOT.330	2	5600	5000	2048	3500	384	512
nginx-edge	3	nginx-edge:2023.06.14	2	1024	896	128	0	0	0
mod-quick-marc	4	mod-quick-marc:5.1.0	1	2288	2176	128	1664	384	512
nginx-okapi	3	nginx-okapi:2023.06.14	2	1024	896	128	0	0	0
okapi-b	4	okapi:5.3.0	3	1684	1440	1024	922	384	512
mod-feesfines	4	mod-feesfines:19.1.0	2	1024	896	128	768	88	128
mod-invoice-storage	4	mod-invoice-storage:5.8.0	2	1872	1536	1024	1024	384	512
mod-dcb	5	mod-dcb:1.1.0	2	1024	896	128	768	88	128
mod-service-interaction	4	mod-service-interaction:4.0.1	2	2048	1844	256	1290	384	512
mod-data-export	13	mod-data-export:5.0.4	1	2048	`1844`	2048	0	0	0
mod-patron	4	mod-patron:6.1.0	2	1024	896	128	768	88	128
mod-oai-pmh	4	mod-oai-pmh:3.13.0	2	4096	3690	2048	3076	384	512
edge-connexion	4	edge-connexion:1.2.0	2	1024	896	128	768	88	128
mod-kb-ebsco-java	4	mod-kb-ebsco-java:4.0.0	2	1024	896	128	768	88	128
mod-notes	4	mod-notes:5.2.0	2	1024	896	128	952	384	512
mod-data-export-spring	4	mod-data-export-spring:3.2.0	1	2048	1844	256	1536	384	512
mod-organizations-storage	4	mod-organizations-storage:4.7.0	2	1024	896	128	700	88	128
mod-login	4	mod-login:7.11.0	2	1440	1298	1024	768	384	512
pub-okapi	3	pub-okapi:2023.06.14	2	1024	896	128	768	0	0
mod-eusage-reports	4	mod-eusage-reports:2.1.1	2	1024	896	128	768	88	128

Methodology/Approach

To run CI/CO - carrier-io artefact was used

DI tests were started from UI

Name	Memory GIB	vCPUs	max_connections
db.r6g.xlarge	32 GiB	4 vCPUs	2731

Data Import with Check-ins Check-outs (Quesnelia)[non-ECS] MSK instance type comparison

[data-colorid=dhef8j9zvo]{color:#ec7211} html[data-color-mode=dark] [data-colorid=dhef8j9zvo]{color:#ee7413}[data-colorid=g292my1u4m]{color:#16191f} html[data-color-mode=dark] [data-colorid=g292my1u4m]{color:#e0e3e9} Overview IN PROGRESS

Summary

Test Runs

Test Results

Comparison

Response time

Service CPU Utilization

MSK instance: kafka.m5.2xlarge

DI MARC BIB Create and Update + CICO

Service Memory Utilization

MSK instance: kafka.m5.2xlarge

DB CPU Utilization

MSK instance: kafka.m5.2xlarge

DB Connections

MSK instance: kafka.m5.2xlarge

Disk usage by broker

MSK instance: kafka.m5.2xlarge

CPU (User) usage by broker

MSK instance: kafka.m5.2xlarge

DB load

MSK instance: kafka.m5.2xlarge

Appendix

Infrastructure

Methodology/Approach

Overview IN PROGRESS