Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Overview

...

ProfileCSV  FileDE Duration/Status Poppy 2 set DE Duration/Status Quesnelia DE Duration, DELTA Poppy/Quesnelia









ResultStatusResultStatushh:mm:ss
DE MARC Bib (Default instances export job profile)1kDE.csv00:00:08COMPLETED00:00:02COMPLETED00:00:06 - 4 times improvement

100kDE.csv00:15:36COMPLETED00:02:17COMPLETED00:13:19 - 7 times improvement

500kDE.csv00:57:25FAIL00:05:10COMPLETED
DE MARC Bib (srs - holdings and items)1kDE.csv00:00:29COMPLETED00:00:04COMPLETED00:00:25 - 7 times improvement

100kDE.csv00:47:23COMPLETED00:05:13COMPLETED00:42:10 - 9 times improvement

500kDE.csv04:11:09FAIL00:08:58COMPLETED

...


Service CPU Utilization

Expand
titleCPU utilization

Default instances export job profile with 500k file

ModuleCPU
mod-data-export-b434.91
mod-inventory-b10.79
mod-source-record-manager-b1.74
mod-source-record-storage-b1.5
okapi-b0.96
mod-users-bl-b0.63
mod-authtoken-b0.61
mod-inventory-storage-b0.39
nginx-okapi0.24
pub-okapi0.16


srs - holdings and items with 500k file

ModuleCPU
mod-data-export-b296.31
mod-inventory-b12.79
mod-source-record-manager-b1.85
mod-source-record-storage-b1.49
okapi-b1.1
mod-authtoken-b0.95
mod-users-bl-b0.69
mod-inventory-storage-b0.54
nginx-okapi0.32
pub-okapi0.21

TOP 20 modules

ModuleCPU
mod-data-export-b296.31
mod-consortia-b19.03
mod-inventory-b12.79
mod-dcb-b8.17
mod-quick-marc-b7.99
mod-pubsub-b7.05
mod-users-b6.85
mod-audit-b6.18
mod-kb-ebsco-java-b5.78
edge-dematic-b4.5
mod-erm-usage-harvester-b4.49
mod-organizations-storage-b4.04
mod-licenses-b3.51
mod-permissions-b3.06
mod-data-export-spring-b2.78
mod-lists-b2.77
mod-organizations-b2.74
mod-user-import-b2.7
mod-tags-b2.57
mod-sender-b2.5


...

3 files were prepared with query: SELECT id FROM [tenant_id]_mod_inventory_storage.instance where jsonb->>'source'='MARC' LIMIT 1000|100000|500000;

...

Infrastructure

PTF -environment qcp1

  • 10 m6i.2xlarge EC2 instances located in US East (N. Virginia)us-east-1
  • 2 database  instances, writer/reader

    NameMemory GIBvCPUsmax_connections

    db.r6g.xlarge

    32 GiB4 vCPUs2731


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

...