...

Table of Contents
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.

...

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

ProfileMARC File

DI Duration

Quesnelia (hh:mm:ss)

Check In, Check Out Response time (8 users)

Quesnelia

MSK cluster: ptf-mobius-testing2

Check In, Check Out Response time (8 users)

Quesnelia

MSK cluster: PERF-921

MSK cluster: ptf-mobius-testing2

MSK cluster: PERF-921

CI Average secCO Average sec

MSK instance: kafka.m5.2xlarge	File size	DI Duration without CI/CO	DI Duration	CI Average sec	CO Average sec

DI MARC Bib Create (PTF - Create 2)5K.mrc

Create

5k

00:02:31

00:02:54

0.899

25K.mrc

1.409
	25k	00:11:49	00:12:49

DI MARC Bib Update (PTF - Updates Success - 1)5K.mrc

	0.724	1.152
Update	5k	00:03:06	00:03:14

25K.mrc

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

Quesnelia

MSK

cluster: ptf-mobius-testing2

instance: kafka.m5.2xlarge		Response time, sec

Quesnelia

MSK

cluster: PERF-921

instance: kafka.m7g.2xlarge
95 perc	average	95 perc	average
Circulation Check-in/Check-out (without Data import)	8 users	Check-in	0.

863

669

0.

716

570
Check-out	1.

535

152

1

0.

269

960

Comparison

CICO with DI comparison

DI duration results without Check-In and Check-Out for Quesnelia were taken from the report Data Import test report (Quesnelia)[non-ECS].

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

Poppy

		Response time, sec

Quesnelia

		Delta
			MSK instance: kafka.m5.2xlarge		MSK instance: kafka.m7g.2xlarge
			95 perc

average

Average

95 perc

average

Average	Average
Circulation Check-in/Check-out (without Data import)	8 users	Check-in	0.

489

669

0.

4310.6090.521

570
		Check-out

0.9690.828

1.

070

152

0.

803

960

Response time

DI MARC BIB Create + CICO

...

MSK instance: kafka.m5.2xlarge

Image Added

Service CPU Utilization

MSK instance: kafka.m5.2xlarge

Expand

title	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

Image Added

Service Memory Utilization

MSK instance: kafka.m5.2xlarge

Expand

title	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

Image Added

DB CPU Utilization

MSK instance: kafka.m5.2xlarge

Average DB CPU usage during data import is about 90% It decreased 5% from 95% in Poppy.

...

85% during create jobs and 87& during Update jobs. Check-In/Check-Out period without DI - 15%.

Image Added

DB Connections

MSK instance: kafka.m5.2xlarge

Average connection count during data import is about 750 850 connections for create jobs that is 450 connections higher than in Poppy. For update jobs - 730 connections.

DB load

Create jobs

...

and update jobs with CI/CO. And 730 connections for CI/CO without data import

Image Added

Expand

title	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

Image Added

CPU (User) usage by broker

MSK instance: kafka.m5.2xlarge

Image Added

DB load

MSK instance: kafka.m5.2xlarge

Image Added

Top SQL-queries:

Image Added

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 tenant
4 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

Expand

title	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

...

Version	Old Version 1	New Version 2
Changes made by	Leonid Kolesnykov	Leonid Kolesnykov
Saved on	Jun 07, 2024	Jun 07, 2024

Versions Compared

Key

Table of Contents
Overview IN

PROGRESS

Comparison

Response time

DI MARC BIB Create + CICO

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

DB load

Create jobs

DB load

MSK instance: kafka.m5.2xlarge

Appendix

Infrastructure

Methodology/Approach

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

Page Comparison

Versions Compared

Key

<span class="diff-html-changed" data-a11y-before="Start of changed content" data-a11y-after="End of changed content" id="changed-diff-0">[data-colorid=</span>

<span class="diff-html-added" data-a11y-before="Start of added content" data-a11y-after="End of added content" id="added-diff-2">mcvt53aw2j</span><span class="diff-html-changed" data-a11y-before="Start of changed content" data-a11y-after="End of changed content" id="changed-diff-3">]{color:</span>

<span class="diff-html-added" data-a11y-before="Start of added content" data-a11y-after="End of added content" id="added-diff-4">mcvt53aw2j</span><span class="diff-html-changed" data-a11y-before="Start of changed content" data-a11y-after="End of changed content" id="changed-diff-5">]{color:</span>

PROGRESS

Comparison

Response time

DI MARC BIB Create + CICO

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

DB load

Create jobs

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