Versions Compared

Version Old Version 8 New Version 9
Changes made by

Stanislav Nehrii

Stanislav Nehrii

Saved on

Key

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

Table of Contents
outlinetrue

...

  • Сomparative Baseline Check-In\Check-Out results without Data Import between Poppy and Quesnelia.

CICO, Median time without
DI
(Poppy)

CICO, 95% time without
DI
(Poppy)		CICO, Median time without
DI
(Quesnelia)		CICO, 95% time without
DI
(Quesnelia)		CICO, Avg time without
DI
(Quesnelia)
Check-In516 ms567 ms503 ms
-2.5%

593 ms
+4.5%

511 ms

Check-Out910 ms2094 ms 836 ms
-8%		1117 ms
-46%		876 ms


...

  • Сomparative Data Import and Check-In\Check-Out results between Poppy and Quesnelia.

# of records 
(Poppy)

DI Duration with CICO
(Poppy)

CI time Avg
(Poppy)

CI time 95th pct
(Poppy)

CO time Avg
(Poppy)

CO time 95th pct
(Poppy)

# of records
(Quesnelia)

DI Duration with CICO
(Quesnelia)

CI time Avg
(Quesnelia)		CI time 95th pct
(Quesnelia)		CO time Avg
(Quesnelia)		CO time 95th pct
(Quesnelia)
1,00035 sec0.5250.5761.0781.3261,000

20 sec
-42.8%

0.560
+6%		0.754
+30%		1.164
+8%		1.313
-1%
5,0001 min 41 sec0.5130.6120.91.0195,0001 min 19 sec
-21.7%		0.701
+36%		1.171
+91%		1.141
+26%		1.790
+75%
10,0003 min 4 sec0.5810.6851.0161.32110,0002 min 35 sec
-15.7%		0.723
+24%		1.024
+49%		1.179
+16%		1.494
+13%
22,7786 min 32 sec0.5981.5421.2441.72925,0006 min 26 sec
-1.5%		0.722
+20%		1.024
-33%		1.180
-5%		1.494
-13%
50,00013 min 48 sec0.6711.9531.512.0950,000

12 min 16 sec
-11%

0.777
+15%		1.045
-46%

1.265

1.265
-16%

1.550
-25%

Resource utilization for Test #1

...

titleResource utilization table

-16%

1.550
-25%



Resource utilization for Test #1 and Test #2

Expand
titleResource utilization table


CPURAM
mod-data-export-b452%mod-data-export-b75%
mod-inventory-b13%mod-source-record-manager-b53%
mod-source-record-storage-b2.40%mod-inventory-b48%
mod-source-record-manager-b1.80%okapi-b32%
okapi-b1.10%mod-source-record-storage-b30%
mod-authtoken-b0.90%mod-authtoken-b20%
mod-users-bl-b0.50%mod-users-bl-b19%
nginx-okapi0.40%mod-inventory-storage-b16%
mod-inventory-storage-b0.40%nginx-okapi5%


Service CPU Utilization

Here we can see that mod-inventorydata-b module export used 50% CPU and mod-source-record-storage-b 46% CPU 452% CPU in spike.

Service Memory Utilization

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

Image Added

DB CPU Utilization

DB CPU in the average spike was 90%32%.

Image Added

DB Connections

DB connections was 11511470.

Image Added

DB load

                                                                                                                     

...

#TOP 5 SQL statements
1
INSERT INTO fs09000000_mod_source_record_manager.events_processed (handler_id, event_id) VALUES ($1, $2)
2
INSERT INTO fs09000000_mod_source_record_manager.journal_records (id, job_execution_id, source_id, source_record_order, entity_type, entity_id, entity_hrid, action_type, action_status, error, action_date, title, instance_id, holdings_id, order_id, permanent_location_id, tenant_id) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17)
3
insert into "marc_records_lb" ("id", "content") values (cast($1 as uuid), cast($2 as jsonb)) on conflict ("id") do update set "content" = cast($3 as jsonb)
4
WITH input_rows(record_id, authority_id) AS (
   VALUES ($1::uuid,$2::uuid)
)
, ins AS (
   INSERT INTO fs09000000_mod_inventory.records_authorities(record_id, authority_id)
   SELECT * FROM input_rows
   ON CONFLICT (record_id) DO UPDATE SET record_id=EXCLUDED.record_id
   RETURNING record_id::uuid, authority_id::uuid
   )
SELECT record_id, authority_id
FROM   ins
UNION  ALL
SELECT c.record_id, c.authority_id 
FROM   input_rows
JOIN   fs09000000_mod_inventory.records_authorities c USING (record_id);
5
UPDATE fs09000000_mod_source_record_manager.job_execution_progress SET succeeded_records_count = succeeded_records_count + $2, error_records_count = error_records_count + $3 WHERE job_execution_id = $1 Returning *


Resource utilization for Test

#2

#3 and Test #4

Expand
titleResource utilization table



...