Generated by /opt/oltp-emul/oltp_isql_run_worker.sh, ISQL session No. 1 of total launched 100. 06.10.2022 07:38
Common Performance Final Results
  1. Hardware and OS info
  2. Test configuration
  3. Test Finish details
  4. Test workload details
  5. Indices DDL for heavy-loaded table(s)
  1. Performance, TOTAL score:    as table     as chart
  2. Performance per MINUTE, during test_time phase:    as table     as chart
  3. Performance, DETAILS per units
  4. Memory consumption, metadata cache, attachments activity    as table    as chart
  5. Monitoring data: STATEMENTS activity, as chart
  6. Exceptions during test run
  1. mon$database and 'show version' results
  2. Database statistics was not gathered. Change config parameter 'run_db_statistics' to 1.
  3. Database validation was not performed. Change config parameter 'run_db_validation' to 1.
  4. New in firebird.log while test was run
  5. Final processing of ISQL logs

Hardware and OS info

Command: hostnamectl
Static hostname mscs-test-161.budzdorov.ru
Icon name computer-server
Chassis server
Machine ID aeee285d2cca40bf84c40a748f599e77
Boot ID 2a7b53d1c5ed44b9bb2712fffac5d8c6
Operating System CentOS Linux 7 (Core)
CPE OS Name cpe:/o:centos:centos:7
Kernel Linux 3.10.0-1127.10.1.el7.x86_64
Architecture x86-64
Command: who -b
bootup_info system boot 2021-11-11 18:28
Command: dmidecode -t system|grep -i -e 'manufacturer\|product\|hypervisor'
Manufacturer HP
Product Name ProLiant DL380 Gen9
Command: dmesg | grep DMI
[ 0.000000] DMI HP ProLiant DL380 Gen9/ProLiant DL380 Gen9, BIOS P89 05/21/2018
Command: lscpu | grep -i -v flags
Architecture x86_64
CPU op-mode(s) 32-bit, 64-bit
Byte Order Little Endian
CPU(s) 24
On-line CPU(s) list 0-23
Thread(s) per core 2
Core(s) per socket 6
Socket(s) 2
NUMA node(s) 2
Vendor ID GenuineIntel
CPU family 6
Model 63
Model name Intel(R) Xeon(R) CPU E5-2620 v3 @ 2.40GHz
Stepping 2
CPU MHz 1200.000
CPU max MHz 2400.0000
CPU min MHz 1200.0000
BogoMIPS 4794.33
Virtualization VT-x
L1d cache 32K
L1i cache 32K
L2 cache 256K
L3 cache 15360K
NUMA node0 CPU(s) 0-5,12-17
NUMA node1 CPU(s) 6-11,18-23
Command: cat /proc/meminfo | grep -i -e 'memtotal\|memfree\|memavail\|buffers\|cached\|swapcached'
MemTotal 32643792 kB
MemFree 15254604 kB
MemAvailable 30569156 kB
Buffers 0 kB
Cached 16478896 kB
SwapCached 2048 kB
Command: fdisk -l
WARNING: fdisk GPT support is currently new, and therefore in an experimental phase. Use at your own discretion.
Disk /dev/sda: 599.9 GB, 599932581888 bytes, 1171743324 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk label type: gpt
Disk identifier: 919DACA4-2F35-4CBB-BAA7-2A8CD8F7168C
# Start End Size Type Name
1 2048 411647 200M EFI System EFI System Partition
2 411648 2508799 1G Microsoft basic
3 2508800 1171742719 557.5G Linux LVM
Disk /dev/mapper/centos_mscs--test--161-root: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/mapper/centos_mscs--test--161-swap: 16.8 GB, 16844324864 bytes, 32899072 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes
Disk /dev/sdb: 536 MB, 536870912 bytes, 1048576 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00000046
Device Boot Start End Blocks Id System
/dev/sdb1 63 514079 257008+ c W95 FAT32 (LBA)
Disk /dev/mapper/centos_mscs--test--161-home: 528.1 GB, 528109010944 bytes, 1031462912 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 262144 bytes / 524288 bytes

Server and database settinfs

SERVER_MODE                     SuperServer 4.0.3
DB_NAME                         /home/bases/oltp40-etalone.fdb
FORCED_WRITES                   ON
SWEEP_INT                       0
PAGE_BUFFERS                    1000000
PAGE_SIZE                       8192


Test configuration settings

param=actions_todo_before_reconnect, val=300
param=create_with_compound_columns_order, val=most_selective_first
param=create_with_debug_objects, val=1
param=create_with_fw, val=sync
param=create_with_separate_qdistr_idx, val=0
param=create_with_split_heavy_tabs, val=1
param=create_with_sweep, val=0
param=dbnm, val=/home/bases/oltp40-etalone.fdb
param=detailed_info, val=0
param=etalon_dbnm, val=/home/bases/oltp40-etalone.fd0
param=expected_workers, val=100
param=fbc, val=/opt/fb40/bin
param=file_name_this_host_info, val=bz_cpu24_ram32
param=file_name_with_test_params, val=regular
param=gather_hardware_info, val=1
param=halt_test_on_errors, val=/CK/
param=host, val=localhost
param=init_buff, val=10000
param=init_docs, val=0
param=is_embed, val=0
param=make_html, val=1
param=max_cps, val=25
param=mon_query_interval, val=60
param=mon_query_role, val=tmp$oemul$worker
param=mon_unit_list, val=//
param=mon_unit_perf, val=2
param=mon_usr_prefix, val=tmp$oemul$user_
param=no_auto_undo, val=1
param=port, val=3400
param=pwd, val=masterkey
param=qmism_verify_bitset, val=1
param=recalc_idx_min_interval, val=30
param=remove_isql_logs, val=if_no_severe_errors
param=replace_instance, val=1
param=report_compress_cmd, val=/usr/bin/7za
param=results_storage_fbk, val=/home/bases/oltp40-results-storage.fbk
param=run_db_statistics, val=0
param=run_db_validation, val=0
param=separate_workers, val=1
param=sleep_ddl, val=./oltp_sleepUDF_nix.sql
param=sleep_max, val=0
param=test_intervals, val=60
param=test_time, val=120
param=tmpdir, val=/var/tmp/logs-oltp40
param=unit_selection_method, val=random
param=update_conflict_percent, val=0
param=used_in_replication, val=0
param=use_mtee, val=0
param=usr, val=SYSDBA
param=wait_after_create, val=0
param=wait_for_copy, val=1
param=wait_if_not_exists, val=0
param=warm_time, val=30
param=working_mode, val=small_03
Custom name of interactive SQL utility: parameter: 'clu', value: |isql|

Test finish info

FINISH_STATE                    NORMAL: TEST_TIME EXPIRED AT 2022-10-06 07:37:21
DTS_END                         2022-10-06 07:37:21.0990
FB_GDSCODE                      -1
FB_MNEMONA                      
STACK                           SP_ADD_INVOICE_TO_STOCK(190:30) ==> SP_CUSTOMER_RESERVE(47:5) ==> SP_CHECK_TO_STOP_WORK(32:12) ==> SP_HALT_ON_ERROR(68:17)
IP                              ::1/39658
TRN_ID                          219732
ATT_ID                          609
EXC_UNIT                        2


Test workload details

SETTING_NAME SETTING_VALUE
WORKING_MODE SMALL_03
C_WARES_MAX_ID 400
C_CUSTOMER_DOC_MAX_ROWS 10
C_SUPPLIER_DOC_MAX_ROWS 50
C_CUSTOMER_DOC_MAX_QTY 15
C_SUPPLIER_DOC_MAX_QTY 50
C_NUMBER_OF_AGENTS 50

Indexes for heavy-loaded tables

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_ASC WORKER_ID,DOC_ID
XQD_1000_3300 XQD_1000_3300_WKR_DOC_DEC WORKER_ID,DOC_ID
XQD_1200_2000 XQD_1200_2000_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WA_SO_RO_WKR_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,WORKER_ID,SND_ID

Performance in TOTAL

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE
*** OVERALL *** for 120 minutes: 8913.73 23512 1069648
customer order: creation 171.73 436 20607
customer order: refuse 14.68 358 1761
order to supplier: creation 45.32 1301 5438
order to supplier: removal 3.30 175247 396
invoice (draft): creation 45.17 2837 5420
invoice (draft): removal 48.66 1003 5839
invoice accept: apply 41.62 26583 4994
invoice accept: cancel 43.94 1164 5273
customer reserve: creation 3909.51 253 469141
customer reserve: removal 4302.00 108 516240
realization accept: apply 84.13 254 10096
realization accept: cancel 77.10 169 9252
payment from customer: creation 58.32 162 6998
payment from customer: removal 5.76 112 691
payment to supplier: creation 47.03 182 5643
payment to supplier: removal 3.50 108 420
service: total inventory turnovers 3.99 3784 479
service: total monetary turnovers 7.10 407 852
service: aggregate perf. data 0.87 13863 104
service: refresh index statistics 0.03 241902 4

Performance in TOTAL, chart


Completed "Performance in TOTAL". Done for 00:00:03, from 06-10-2022 07:38:45 to 06-10-2022 07:38:48.

Performance for every MINUTE

TEST_PHASE_NAME MINUTES_PASSED PERF_SCORE
TEST_TIME 1 7990
TEST_TIME 2 6421
TEST_TIME 3 5844
TEST_TIME 4 6143
TEST_TIME 5 5972
TEST_TIME 6 6047
TEST_TIME 7 6193
TEST_TIME 8 6475
TEST_TIME 9 7171
TEST_TIME 10 7278
TEST_TIME 11 7532
TEST_TIME 12 7454
TEST_TIME 13 7623
TEST_TIME 14 7551
TEST_TIME 15 7628
TEST_TIME 16 7689
TEST_TIME 17 7654
TEST_TIME 18 7833
TEST_TIME 19 7675
TEST_TIME 20 7863
TEST_TIME 21 8225
TEST_TIME 22 8279
TEST_TIME 23 8523
TEST_TIME 24 8957
TEST_TIME 25 9073
TEST_TIME 26 9293
TEST_TIME 27 9227
TEST_TIME 28 9412
TEST_TIME 29 9693
TEST_TIME 30 9991
TEST_TIME 31 10137
TEST_TIME 32 10698
TEST_TIME 33 10636
TEST_TIME 34 10681
TEST_TIME 35 10447
TEST_TIME 36 10467
TEST_TIME 37 10398
TEST_TIME 38 10249
TEST_TIME 39 10220
TEST_TIME 40 10110
TEST_TIME 41 10152
TEST_TIME 42 10055
TEST_TIME 43 9898
TEST_TIME 44 9914
TEST_TIME 45 9981
TEST_TIME 46 9877
TEST_TIME 47 10034
TEST_TIME 48 10015
TEST_TIME 49 9913
TEST_TIME 50 9846
TEST_TIME 51 9721
TEST_TIME 52 9567
TEST_TIME 53 9496
TEST_TIME 54 9502
TEST_TIME 55 9464
TEST_TIME 56 9405
TEST_TIME 57 9408
TEST_TIME 58 9367
TEST_TIME 59 9262
TEST_TIME 60 9151
TEST_TIME 61 9057
TEST_TIME 62 9246
TEST_TIME 63 9347
TEST_TIME 64 9369
TEST_TIME 65 9385
TEST_TIME 66 9336
TEST_TIME 67 9413
TEST_TIME 68 9387
TEST_TIME 69 9378
TEST_TIME 70 9404
TEST_TIME 71 9484
TEST_TIME 72 9450
TEST_TIME 73 9443
TEST_TIME 74 9457
TEST_TIME 75 9425
TEST_TIME 76 9368
TEST_TIME 77 9262
TEST_TIME 78 9229
TEST_TIME 79 9170
TEST_TIME 80 9135
TEST_TIME 81 9154
TEST_TIME 82 9098
TEST_TIME 83 9023
TEST_TIME 84 9011
TEST_TIME 85 9043
TEST_TIME 86 9094
TEST_TIME 87 9079
TEST_TIME 88 9058
TEST_TIME 89 9058
TEST_TIME 90 9066
TEST_TIME 91 9061
TEST_TIME 92 9076
TEST_TIME 93 9069
TEST_TIME 94 9062
TEST_TIME 95 9107
TEST_TIME 96 9077
TEST_TIME 97 9053
TEST_TIME 98 8986
TEST_TIME 99 8985
TEST_TIME 100 9003
TEST_TIME 101 8987
TEST_TIME 102 8929
TEST_TIME 103 8882
TEST_TIME 104 8870
TEST_TIME 105 8851
TEST_TIME 106 8863
TEST_TIME 107 8849
TEST_TIME 108 8862
TEST_TIME 109 8831
TEST_TIME 110 8815
TEST_TIME 111 8794
TEST_TIME 112 8834
TEST_TIME 113 8868
TEST_TIME 114 8846
TEST_TIME 115 8922
TEST_TIME 116 9045
TEST_TIME 117 8991
TEST_TIME 118 9038
TEST_TIME 119 9006
TEST_TIME 120 8936

Performance per minute, chart


Completed "Performance for every MINUTE". Done for 00:00:03, from 06-10-2022 07:38:49 to 06-10-2022 07:38:52.

Performance in DETAILS

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL CNT_USER_EXC
doc_list_aiud 1500168 1500168 0 0.00 0 38626 13 0 0
doc_list_biud 1500168 1500168 0 0.00 0 40178 43 0 0
sp_add_invoice_to_stock 5084 4994 90 1.77 47 239647 26583 0 90
sp_cancel_adding_invoice 5273 5273 0 0.00 6 70210 1165 0 0
sp_cancel_client_order 1761 1761 0 0.00 4 14823 359 0 0
sp_cancel_customer_reserve 516240 516240 0 0.00 1 26892 108 0 0
sp_cancel_pay_from_customer 691 691 0 0.00 4 6746 112 0 0
sp_cancel_pay_to_supplier 420 420 0 0.00 4 4381 109 0 0
sp_cancel_supplier_invoice 5847 5839 8 0.13 3 33997 1003 0 8
sp_cancel_supplier_order 396 396 0 0.00 6 1264391 175248 0 0
sp_cancel_write_off 9252 9252 0 0.00 2 40198 169 0 0
sp_client_order 20607 20607 0 0.00 6 36259 436 0 0
sp_customer_reserve 469141 469141 0 0.00 0 114817 253 0 0
sp_fill_shopping_cart 31463 31463 0 0.00 1 12307 77 0 0
sp_fill_shopping_cart_clo_res 469128 469128 0 0.00 0 16619 20 0 0
sp_get_clo_for_invoice 4953 4953 0 0.00 0 18466 300 0 0
sp_kill_cost_storno 15636 15636 0 0.00 0 7415 70 0 0
sp_kill_qstorno_ret_qs2qd 1047967 1047967 0 0.00 0 40173 48 0 0
sp_kill_qty_storno 553810 553810 0 0.00 0 40177 108 0 0
sp_lock_selected_doc 20818 20818 0 0.00 0 10071 6 0 0
sp_make_cost_storno 27690 27690 0 0.00 0 17166 70 0 0
sp_multiply_rows_for_pdistr 27690 27690 0 0.00 0 6489 35 0 0
sp_multiply_rows_for_qdistr 20607 20607 0 0.00 0 19480 177 0 0
sp_pay_from_customer 6998 6998 0 0.00 5 16465 162 0 0
sp_pay_to_supplier 5643 5643 0 0.00 6 16981 182 0 0
sp_payment_common 12641 12641 0 0.00 2 16972 47 0 0
sp_qd_handle_on_cancel_clo 1761 1761 0 0.00 0 8466 284 0 0
sp_qd_handle_on_invoice_upd_sts 10226 10226 0 0.00 0 24063 487 0 0
sp_qd_handle_on_reserve_upd_sts 10096 10096 0 0.00 0 16718 59 0 0
sp_reserve_write_off 10096 10096 0 0.00 8 17620 255 0 0
sp_supplier_invoice 5420 5420 0 0.00 8 70913 2837 0 0
sp_supplier_order 5438 5438 0 0.00 7 67255 1302 0 0
srv_aggregate_perf_data 105 104 1 0.95 2758 170003 13864 0 1
srv_fill_mon_cache_memory 72 72 0 0.00 916 217358 35257 0 0
srv_find_qd_qs_mism 1020119 1020119 0 0.00 0 38624 11 0 0
srv_make_invnt_saldo 479 479 0 0.00 73 93225 3784 0 0
srv_make_money_saldo 852 852 0 0.00 1 19405 407 0 0
srv_recalc_idx_stat 4 4 0 0.00 51111 406216 241902 0 0
t$perf-abend:sp_add_invoice_to_stock 90 90 0 0.00 0 0 0 0 0
t$perf-abend:sp_cancel_supplier_invoice 8 8 0 0.00 0 0 0 0 0
t$perf-abend:srv_aggregate_perf_data 1 1 0 0.00 0 0 0 0 0
t$perf-norm:sp_add_invoice_to_stock 4995 4995 0 0.00 0 12237 754 0 0
t$perf-norm:sp_cancel_adding_invoice 427 427 0 0.00 1 7405 399 0 0
t$perf-norm:sp_cancel_client_order 1761 1761 0 0.00 0 960 25 0 0
t$perf-norm:sp_cancel_customer_reserve 662 662 0 0.00 0 1978 31 0 0
t$perf-norm:sp_cancel_pay_from_customer 691 691 0 0.00 0 280 10 0 0
t$perf-norm:sp_cancel_pay_to_supplier 420 420 0 0.00 0 720 12 0 0
t$perf-norm:sp_cancel_supplier_invoice 405 405 0 0.00 0 1100 34 0 0
t$perf-norm:sp_cancel_supplier_order 396 396 0 0.00 0 69913 5830 0 0
t$perf-norm:sp_cancel_write_off 1007 1007 0 0.00 0 1885 17 0 0
t$perf-norm:sp_client_order 20607 20607 0 0.00 0 12681 32 0 0
t$perf-norm:sp_customer_reserve 989 989 0 0.00 0 1699 15 0 0
t$perf-norm:sp_pay_from_customer 6998 6998 0 0.00 0 8501 18 0 0
t$perf-norm:sp_pay_to_supplier 5643 5643 0 0.00 0 3729 19 0 0
t$perf-norm:sp_reserve_write_off 10096 10096 0 0.00 0 4464 21 0 0
t$perf-norm:sp_supplier_invoice 5420 5420 0 0.00 0 8748 26 0 0
t$perf-norm:sp_supplier_order 5438 5438 0 0.00 0 29689 34 0 0
t$perf-norm:srv_aggregate_perf_data 104 104 0 0.00 0 918 22 0 0
t$perf-norm:srv_fill_mon_cache_memory 72 72 0 0.00 0 259 6 0 0
t$perf-norm:srv_make_invnt_saldo 479 479 0 0.00 0 3874 17 0 0
t$perf-norm:srv_make_money_saldo 852 852 0 0.00 0 680 6 0 0
t$perf-norm:srv_recalc_idx_stat 4 4 0 0.00 4 174 50 0 0
v_add_invoice_to_stock 10086 9906 180 1.78 0 14490 25 0 180
v_all_customers 37540 37540 0 0.00 0 103 3 0 0
v_all_suppliers 29908 29908 0 0.00 0 61 4 0 0
v_all_wares 41214 41214 0 0.00 0 74 3 0 0
v_cancel_adding_invoice 854 854 0 0.00 0 2862 17 0 0
v_cancel_client_order 3522 3522 0 0.00 0 14450 17 0 0
v_cancel_customer_prepayment 1382 1382 0 0.00 0 4794 11 0 0
v_cancel_customer_reserve 1324 1324 0 0.00 0 5158 18 0 0
v_cancel_payment_to_supplier 840 840 0 0.00 0 2306 12 0 0
v_cancel_supplier_invoice 826 810 16 1.93 0 567 21 0 16
v_cancel_supplier_order 792 792 0 0.00 0 1850 10 0 0
v_cancel_write_off 2014 2014 0 0.00 0 5184 32 0 0
v_max_id_clo_ord 5438 5438 0 0.00 0 270 5 0 0
v_max_id_clo_res 989 989 0 0.00 0 1981 15 0 0
v_max_id_ord_sup 5418 5418 0 0.00 0 6595 7 0 0
v_max_non_paid_invoice 1545 1545 0 0.00 0 450 7 0 0
v_max_non_paid_realizn 3706 3706 0 0.00 0 3840 8 0 0
v_min_id_clo_ord 5438 5438 0 0.00 0 7197 12 0 0
v_min_id_clo_res 989 989 0 0.00 0 8041 18 0 0
v_min_id_ord_sup 5418 5418 0 0.00 0 7274 11 0 0
v_min_non_paid_invoice 5643 5643 0 0.00 0 16967 22 0 0
v_min_non_paid_realizn 6998 6998 0 0.00 0 16453 20 0 0
v_our_firm 10258 10258 0 0.00 0 59 4 0 0
v_reserve_write_off 20192 20192 0 0.00 0 14846 11 0 0
x_lock_depdocs_on_canc_invoice 10707 10707 0 0.00 0 18663 127 0 0
x_lock_depdocs_on_canc_sup_ord 396 396 0 0.00 0 23875 424 0 0
x_make_qstorno_1000_1200 5438 5438 0 0.00 3 67236 1147 0 0
x_make_qstorno_1200_2000 5420 5420 0 0.00 4 70814 2619 0 0
x_make_qstorno_2100_3300 469141 469141 0 0.00 0 114782 223 0 0

Completed "Performance in DETAILS". Done for 00:00:04, from 06-10-2022 07:38:54 to 06-10-2022 07:38:58.

Memory consumption, metadata cache, attachments activity

Fields:
  page cache memo used            = page cache total size, bytes:
  memo used, total                = total of mon$memory_usage.mon$memory_used for database level (mon$stat_group = 0);
  memo allocated, total           = the same of mon$memory_usage.mon$memory_allocated;
  metadata cache memo used        = metadata cache, bytes;
  metadata cache percent of total = ratio: metadata cache / (metadata cache + page cache);
  total attachments cnt           = total number of attachments, regardless of state;
  active attachments cnt          = number of attachments with mon$state = 1;
  running statements cnt          = number of statements that are operating with data from page cache (mon$state = 1);
  stalled statements cnt          = number of statements that are waiting for client request for fetching ( mon$state = 2);
  memo used by attachments        = total of mon$memory_usage.mon$memory_used for attachment level (mon$stat_group = 1);
  memo used by transactions       = the same of transaction level (mon$stat_group = 2);
  memo used by statements         = the same of statement level (mon$stat_group = 3);


Page cache type: shared, buffers: 1000000 for all connections, with total size: 8192000000                                                                                                                                                                     

measurement_dts measurement duration ms page cache memo used memo used, total memo allocated, total metadata cache metadata cache percent of total total attachments cnt active attachments cnt running statements cnt stalled statements cnt memo used by attachments memo used by transactions memo used by statements
05:07:24 1 8192000000 8796669344 8807108608 3189136 0.038 1 1 2 0 3286752 61840 35776
05:08:26 20964 8192000000 9721908064 10019532800 797864608 8.875 100 90 180 0 827787824 7866672 22056544
05:09:51 26844 8192000000 9777017680 10084794368 848112864 9.381 100 89 178 0 880545360 11405840 21026656
05:11:25 13380 8192000000 9800910272 10119688192 873246064 9.632 100 84 168 0 912184688 19894576 19044048
05:12:40 10599 8192000000 9858760720 10190835712 920174064 10.098 100 87 173 0 973280128 33881568 19224496
05:13:55 4090 8192000000 9907923936 10250686464 960008560 10.489 100 91 178 0 1029702256 50840960 18852736
05:15:02 1269 8192000000 9969989536 10320412672 992629728 10.807 100 93 178 1 1089091568 78546816 17915024
05:16:06 1565 8192000000 10000860672 10359779328 1014818128 11.022 100 96 191 2 1117792960 83073152 19901680
05:17:09 805 8192000000 10011918000 10378575872 1036245280 11.229 100 98 193 2 1129872400 75081504 18545616
05:18:10 1644 8192000000 10015636368 10390294528 1049858016 11.359 100 90 178 1 1137439568 69478080 18103472
05:19:13 1143 8192000000 10023629152 10397077504 1063666256 11.492 100 96 187 1 1145001728 62117120 19218352
05:20:16 944 8192000000 10026696688 10408288256 1072064816 11.572 100 86 167 1 1151435360 62661216 16709328
05:21:17 852 8192000000 10043489696 10423390208 1077058064 11.619 100 94 185 1 1167834528 70982912 19793552
05:22:19 954 8192000000 10020675936 10405289984 1082744800 11.674 100 92 171 2 1147977056 46424272 18807984
05:23:20 4965 8192000000 10036611024 10427084800 1084294720 11.688 100 66 118 2 1163220240 66355616 12569904
05:24:26 6108 8192000000 10050491936 10436378624 1086745152 11.712 100 80 153 2 1173889776 71725696 15418928
05:25:33 1113 8192000000 10048081568 10444189696 1091474416 11.757 100 70 131 2 1171390848 65625168 14291264
05:26:36 1154 8192000000 10069895808 10458198016 1093290944 11.774 100 95 176 0 1190592016 79354304 17946768
05:27:38 1179 8192000000 10052895008 10440724480 1090601696 11.748 100 95 185 0 1170984272 61094480 19288096
05:28:41 1904 8192000000 10038353072 10423226368 1081244704 11.659 100 86 166 3 1159957024 62859552 15852768
05:29:44 945 8192000000 10048815040 10432983040 1083896608 11.685 100 90 173 3 1168692352 67150336 17645408
05:30:47 917 8192000000 10028364864 10409451520 1073889712 11.589 100 96 186 0 1149822224 56622640 19309872
05:31:48 1174 8192000000 10029713056 10408284160 1062212640 11.478 99 91 168 8 1152334736 73192752 16929344
05:32:50 1807 8192000000 9950504160 10319949824 1011846704 10.993 99 71 133 1 1073811600 47431712 14533184
05:33:53 2590 8192000000 9973430672 10346434560 1026450000 11.134 99 77 141 6 1097292896 55691328 15151568
05:34:58 2821 8192000000 9981657840 10363203584 1028889120 11.158 100 57 112 0 1094067472 53900432 11277920
05:36:02 3043 8192000000 9998135488 10375991296 1032681136 11.194 100 66 129 0 1121347056 75336128 13329792
05:37:06 2242 8192000000 9991465184 10366365696 1040186304 11.266 100 82 161 0 1113525664 56639696 16699664
05:38:11 8996 8192000000 9996004688 10385235968 1067311936 11.526 100 66 124 1 1122509328 41560032 13637360
05:39:39 6485 8192000000 10047703056 10428878848 1083404272 11.680 100 76 146 0 1164930512 67605952 13920288
05:40:55 1543 8192000000 10086349760 10471895040 1100427936 11.842 100 84 161 1 1212062320 94481984 17152400
05:41:59 6641 8192000000 10076224768 10468438016 1093974528 11.780 99 70 127 2 1195976128 88557712 13443888
05:43:09 7167 8192000000 10140624576 10536681472 1110588320 11.938 100 74 143 2 1256223360 129456224 16178816
05:44:23 2694 8192000000 10146431808 10540150784 1122296064 12.049 100 83 149 2 1257569024 118783952 16489008
05:45:28 6747 8192000000 10189631632 10580021248 1131377360 12.134 100 92 169 1 1297808400 149139280 17291760
05:46:37 1122 8192000000 10189733488 10605027328 1151358928 12.322 100 96 176 3 1306268656 134330752 20578976
05:47:41 1454 8192000000 10226214768 10626203648 1157071200 12.376 100 94 180 0 1336515008 160167584 19276224
05:48:45 2709 8192000000 10226843840 10628968448 1164245184 12.443 100 79 156 0 1337697328 155695936 17756208
05:49:51 2294 8192000000 10266417856 10680815616 1171349760 12.509 100 82 159 1 1380202352 190918480 17934112
05:50:57 3783 8192000000 10295402768 10709475328 1186089536 12.647 100 82 162 0 1411338880 205633696 19615648
05:52:05 1666 8192000000 10354218640 10775957504 1198669104 12.764 100 90 172 2 1462908880 243219216 21020560
05:53:09 904 8192000000 10398817568 10801479680 1192444896 12.706 100 94 183 0 1506805552 293097568 21263088
05:54:15 3205 8192000000 10386292880 10808688640 1193308576 12.714 100 77 149 0 1497743216 285570144 18864496
05:55:21 2107 8192000000 10462947264 10877415424 1203758816 12.811 100 87 167 0 1571495232 346709616 21026800
05:56:26 10038 8192000000 10476476224 10896986112 1183679344 12.624 99 64 125 1 1569170048 369394688 16096016
05:57:40 1963 8192000000 10463523808 10887557120 1175445904 12.548 99 72 139 0 1567370400 374993040 16931456
05:58:45 3464 8192000000 10459658528 10905767936 1166766896 12.467 99 61 120 1 1556965888 374919872 15279120
05:59:51 2836 8192000000 10428461968 10888667136 1175523920 12.548 100 74 144 1 1549363520 356553584 17286016
06:01:00 2029 8192000000 10412810688 10846277632 1156815712 12.373 100 81 160 1 1519648432 343775744 19056976
06:02:04 8835 8192000000 10372298384 10809630720 1123452912 12.060 98 54 105 1 1454830512 319278320 12099280
06:03:20 17097 8192000000 10387209888 10874003456 1157065024 12.376 100 36 72 0 1497303664 329884112 10354528
06:04:42 35269 8192000000 10393047248 10843738112 1151780512 12.326 100 30 60 0 1518296320 358598624 7917184
06:06:18 12931 8192000000 10332595616 10786504704 1136925024 12.187 100 29 54 0 1437695648 294164560 6606064
06:07:42 42321 8192000000 10283396160 10765815808 1121242352 12.039 99 23 46 0 1408409552 281445408 5721792
06:09:25 48342 8192000000 10127744448 10586636288 1109615568 11.929 98 40 74 1 1267715408 149143968 8955872
06:11:18 9934 8192000000 10129009936 10559299584 1118314432 12.011 99 65 113 0 1230856240 100429392 12112416
06:12:30 57112 8192000000 10094015888 10561794048 1121668144 12.043 99 24 48 0 1190799984 64024896 5106944
06:14:27 67460 8192000000 10084334608 10528010240 1131587184 12.136 100 31 59 0 1172830416 35561856 5681376
06:16:36 65981 8192000000 10091083888 10526597120 1125744704 12.081 99 35 65 0 1174921904 42588224 6588976
06:18:42 96127 8192000000 10109001360 10564063232 1111036608 11.942 98 22 44 0 1226827808 110853488 4937712
06:21:22 56655 8192000000 10120152608 10560950272 1088136704 11.725 97 17 34 0 1188146048 96320288 3689056
06:23:38 100114 8192000000 10101159904 10526539776 1114929888 11.979 99 14 28 1 1181576224 63808480 2837856
06:26:19 30152 8192000000 10116524400 10535047168 1143555424 12.249 100 65 120 1 1202344320 46576464 12212432
06:27:53 217357 8192000000 10081970992 10556006400 1106969504 11.904 97 31 61 0 1165674240 53169824 5534912
06:32:33 51670 8192000000 10098432912 10574356480 1137885680 12.196 100 19 38 0 1203469232 61230144 4353408
06:34:25 37684 8192000000 10095798496 10575687680 1139366608 12.210 100 11 22 0 1194050512 52480128 2203776
06:36:05 144952 8192000000 10212651904 10666676224 1154783904 12.354 99 18 36 0 1259493216 100297008 4412304
06:39:52 71924 8192000000 10102192080 10582499328 1143530560 12.249 99 15 30 0 1250077664 103358208 3188896
06:42:05 71995 8192000000 10101741584 10546192384 1122462368 12.050 97 23 45 0 1171052240 43795376 4794496
06:44:19 3729 8192000000 10133500560 10559135744 1134847808 12.167 99 67 121 3 1225554528 77906256 12800464
06:45:25 36221 8192000000 10131256896 10577956864 1106673584 11.901 96 48 94 1 1178088608 61388192 10026832
06:47:02 49771 8192000000 10122722048 10561757184 1099298688 11.831 96 32 62 0 1186088736 80418928 6371120
06:49:30 23173 8192000000 10106478880 10547712000 1136555424 12.183 100 40 76 0 1195062032 50874064 7632544
06:51:10 60055 8192000000 10100952128 10549022720 1118365568 12.012 98 32 63 1 1186763632 62105472 6292592
06:53:15 10475 8192000000 10090587904 10522124288 1125967328 12.083 99 47 93 0 1181768512 46819680 8981504
06:54:27 45882 8192000000 10108800592 10546622464 1129856128 12.120 99 39 76 0 1211865136 74739952 7269056
06:56:23 57852 8192000000 10070597728 10536931328 1103787952 11.874 98 18 35 0 1176239488 68720096 3731440
06:58:22 82525 8192000000 10082783136 10542510080 1113008080 11.961 99 17 34 0 1158494560 42056880 3429600
07:00:45 49554 8192000000 10088988960 10569977856 1116341536 11.992 99 17 34 0 1216376160 96345824 3688800
07:02:35 50130 8192000000 10051810240 10533064704 1068718608 11.540 96 21 42 0 1142461216 69042064 4700544
07:04:30 38474 8192000000 10060257648 10507722752 1091624928 11.758 98 31 61 0 1144095184 45897696 6572560
07:06:17 6261 8192000000 10091446768 10520453120 1118042368 12.008 100 54 106 2 1181652816 52831856 10778592
07:07:24 37116 8192000000 10094494432 10545373184 1093926784 11.780 98 45 88 1 1182753376 79841952 8984640
07:09:01 22070 8192000000 10077831712 10527592448 1122835968 12.054 100 40 78 0 1186740448 55237632 8666848
07:10:31 28152 8192000000 10102030720 10533588992 1104598608 11.881 98 54 108 0 1189522592 74161856 10762128
07:12:03 24852 8192000000 10102124784 10571218944 1100745776 11.845 98 42 84 0 1194559296 85358928 8454592
07:13:41 15198 8192000000 10123774640 10554957824 1126656496 12.090 100 50 100 0 1198021328 61429680 9935152
07:15:00 103436 8192000000 10086702240 10547740672 1117937840 12.008 99 46 91 0 1213754112 87495168 8321104
07:17:44 43782 8192000000 10045878720 10498478080 1103762976 11.873 98 10 18 2 1145525392 39422864 2339552
07:19:40 49282 8192000000 10064427344 10533093376 1123389328 12.059 100 7 14 0 1175195872 50271312 1535232
07:21:34 32743 8192000000 10106513296 10557939712 1138623088 12.203 100 19 38 0 1198360400 55693072 4044240
07:23:07 43354 8192000000 10139796800 10613919744 1152118592 12.329 100 29 58 1 1241203584 82046064 7038928
07:25:00 29246 8192000000 10153105728 10598760448 1145006400 12.263 99 31 62 0 1251512416 99367312 7138704
07:26:30 16280 8192000000 10191371264 10630250496 1152811904 12.336 99 39 78 1 1277513104 115712272 8988928
07:27:51 23316 8192000000 10248338448 10691170304 1159329312 12.397 99 43 86 0 1340894624 171168224 10397088
07:29:15 27707 8192000000 10275904704 10735042560 1153209408 12.340 99 37 74 0 1367592784 205028432 9354944
07:30:51 36734 8192000000 10247586752 10687918080 1155885200 12.365 99 41 82 0 1329838736 164877968 9075568
07:32:31 52824 8192000000 10199643760 10728103936 1157468032 12.380 100 20 40 0 1341962432 179545744 4948656
07:34:25 103781 8192000000 10085140304 10611838976 1098232816 11.821 96 25 47 0 1173185904 70184688 4768400
07:37:10 10403 8192000000 10086652480 10513633280 1135630464 12.174 100 54 100 0 1179824736 32948624 11245648

Memory consumption, total, chart

Metadata cache size, chart

Statements activity, chart


Completed "Memory consumption, metadata cache, attachments activity". Done for 00:00:16, from 06-10-2022 07:39:00 to 06-10-2022 07:39:16.

Exceptions occured during test was in run

FB_MNEMONA CNT UNIT FB_GDSCODE
except 1 srv_aggregate_perf_data 335544517
except 90 v_add_invoice_to_stock 335544517
except 8 v_cancel_supplier_invoice 335544517

Completed "Exceptions occured during test was in run". Done for 00:00:02, from 06-10-2022 07:39:17 to 06-10-2022 07:39:19.

Content of mon$database and FB version

MON$DATABASE_NAME               /home/bases/oltp40-etalone.fdb
MON$PAGE_SIZE                   8192
MON$ODS_MAJOR                   13
MON$ODS_MINOR                   0
MON$OLDEST_TRANSACTION          220642
MON$OLDEST_ACTIVE               220643
MON$OLDEST_SNAPSHOT             220643
MON$NEXT_TRANSACTION            220643
MON$PAGE_BUFFERS                1000000
MON$SQL_DIALECT                 3
MON$SHUTDOWN_MODE               0
MON$SWEEP_INTERVAL              0
MON$READ_ONLY                   0
MON$FORCED_WRITES               1
MON$RESERVE_SPACE               1
MON$CREATION_DATE               2020-04-30 07:30:08.6030 GMT
MON$PAGES                       2070880
MON$STAT_ID                     1
MON$BACKUP_STATE                0
MON$CRYPT_PAGE                  0
MON$OWNER                       SYSDBA                                                                                                                                                                                                                                                      
MON$SEC_DATABASE                Default
MON$CRYPT_STATE                 0
MON$GUID                        {58978C10-B735-40F5-8B7D-F7A1956E782B}
MON$FILE_ID                     02fd0000000000002e02000000000000
MON$NEXT_ATTACHMENT             771
MON$NEXT_STATEMENT              53
MON$REPLICA_MODE                0


ISQL Version: LI-V4.0.3.2855 Firebird 4.0
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version "LI-V4.0.3.2855 Firebird 4.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version "LI-V4.0.3.2855 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version "LI-V4.0.3.2855 Firebird 4.0/tcp (mscs-test-161.budzdorov.ru)/P17:C"
on disk structure version 13.0

Database statistics

Database statistics was not gathered, see config parameter 'run_db_statistics'.
===============================================================================

Database validation

Database validation was not performed, see config parameter 'run_db_validation'
===============================================================================

Comparison of old and new firebird.log: get messages that appeared during test

--- start of diff output ---
--- end of diff output ---

Final processing ISQL logs in /var/tmp/logs-oltp40 according to config parameter 'remove_isql_logs'

06.10.22 07:39:20. There are 3 logs in /var/tmp/logs-oltp40 that can be removed if no severe errors occured, see config setting 'remove_isql_logs' Following values of gdscode are considered as SEVERE: 0 Unidentified error in PSQL code: gdscode=0 within WHEN block when exception raised. 335544321 'string truncation'. Attempt to assign too long text into string variable. 335544347 'not_valid'. Validation error for column. 335544349 'no_dup'. Attempt to store duplicate value visible to active transactions. 335544558 'check_constraint'. Operation violates CHECK constraint on view or table. 335544665 'unique_key_violation'. Violation of PRIMARY or UNIQUE KEY constraint. 335544838 'foreign_key_target_doesnt_exist'. Foreign key reference target does not exist. 335544839 'foreign_key_references_present'. Foreign key references are present for the record.
FINISHED_AT ERRORS_RESULT
2022-10-06 07:39:23 No severe PSQL-related problems occured
06.10.22 07:39:24. End of report.