=====================================
2023-05-24 07:25:07 0x7f789806e700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 4 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 0 srv_active, 0 srv_shutdown, 984809 srv_idle
srv_master_thread log flush and writes: 984809
----------
SEMAPHORES
----------
------------------------
LATEST DETECTED DEADLOCK
------------------------
2023-05-23 10:42:51 0x7f47acfcf700
*** (1) TRANSACTION:
TRANSACTION 32461986432, ACTIVE 0 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 5 lock struct(s), heap size 1128, 3 row lock(s), undo log entries 2
MariaDB thread id 32, OS thread handle 139945821665024, query id 976984092
*** WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 24124841 page no 48269 n bits 80 index PRIMARY of table `aDatabase`.`table5` trx id 32461986432 lock_mode X locks rec but not gap waiting
Record lock, heap no 10 PHYSICAL RECORD: n_fields 49; compact format; info bits 0
 0: len 8; hex 800003ed800005d4; asc         ;;
 1: len 6; hex 00078ee29a6b; asc      k;;
 2: len 7; hex 0e000336b503a0; asc    6   ;;
 3: len 22; hex 46492d39323034342d333955435f3331373833393937; asc FI-92044-39UC_31783997;;
 4: len 3; hex 000ccb; asc    ;;
 5: len 1; hex 80; asc  ;;
 6: len 1; hex 80; asc  ;;
 7: len 1; hex 82; asc  ;;
 8: len 1; hex 83; asc  ;;
 9: len 2; hex 8034; asc  4;;
 10: len 1; hex 47; asc G;;
 11: len 16; hex 34383537353434333942444631413945; asc 485754439BDF1A9E;;
 12: len 20; hex 3030303030313831303631393130373235323032; asc 00000181061910725202;;
 13: SQL NULL;
 14: len 2; hex 7fff; asc   ;;
 15: len 8; hex 8000041380005df5; asc       ] ;;
 16: len 8; hex 800004bb00000fd5; asc         ;;
 17: SQL NULL;
 18: len 1; hex 83; asc  ;;
 19: len 1; hex 83; asc  ;;
 20: len 1; hex 80; asc  ;;
 21: len 1; hex 88; asc  ;;
 22: len 1; hex 00; asc  ;;
 23: len 1; hex 01; asc  ;;
 24: len 1; hex 01; asc  ;;
 25: len 1; hex 00; asc  ;;
 26: len 1; hex 00; asc  ;;
 27: len 1; hex 18; asc  ;;
 28: len 4; hex e46c7877; asc  lxw;;
 29: len 4; hex e44f4bca; asc  OK ;;
 30: len 5; hex 99aa3c7299; asc   <r ;;
 31: len 1; hex 80; asc  ;;
 32: len 1; hex 82; asc  ;;
 33: len 8; hex 14556371614d33c0; asc  UcqaM3 ;;
 34: len 8; hex 73b35307457d34c0; asc s S E}4 ;;
 35: len 8; hex 88115febdc74a73f; asc   _  t ?;;
 36: len 8; hex 2ab58bceaeed743f; asc *     t?;;
 37: len 8; hex 8000000000000040; asc        @;;
 38: len 8; hex 8000000000000040; asc        @;;
 39: len 8; hex 03cddb57448ce43f; asc    WD  ?;;
 40: len 8; hex 3abfe8aad572cb3f; asc :    r ?;;
 41: SQL NULL;
 42: SQL NULL;
 43: SQL NULL;
 44: SQL NULL;
 45: SQL NULL;
 46: len 1; hex 80; asc  ;;
 47: len 1; hex 89; asc  ;;
 48: SQL NULL;

*** CONFLICTING WITH:
RECORD LOCKS space id 24124841 page no 48269 n bits 80 index PRIMARY of table `aDatabase`.`table5` trx id 32461986411 lock_mode X locks rec but not gap
Record lock, heap no 10 PHYSICAL RECORD: n_fields 49; compact format; info bits 0
 0: len 8; hex 800003ed800005d4; asc         ;;
 1: len 6; hex 00078ee29a6b; asc      k;;
 2: len 7; hex 0e000336b503a0; asc    6   ;;
 3: len 22; hex 46492d39323034342d333955435f3331373833393937; asc FI-92044-39UC_31783997;;
 4: len 3; hex 000ccb; asc    ;;
 5: len 1; hex 80; asc  ;;
 6: len 1; hex 80; asc  ;;
 7: len 1; hex 82; asc  ;;
 8: len 1; hex 83; asc  ;;
 9: len 2; hex 8034; asc  4;;
 10: len 1; hex 47; asc G;;
 11: len 16; hex 34383537353434333942444631413945; asc 485754439BDF1A9E;;
 12: len 20; hex 3030303030313831303631393130373235323032; asc 00000181061910725202;;
 13: SQL NULL;
 14: len 2; hex 7fff; asc   ;;
 15: len 8; hex 8000041380005df5; asc       ] ;;
 16: len 8; hex 800004bb00000fd5; asc         ;;
 17: SQL NULL;
 18: len 1; hex 83; asc  ;;
 19: len 1; hex 83; asc  ;;
 20: len 1; hex 80; asc  ;;
 21: len 1; hex 88; asc  ;;
 22: len 1; hex 00; asc  ;;
 23: len 1; hex 01; asc  ;;
 24: len 1; hex 01; asc  ;;
 25: len 1; hex 00; asc  ;;
 26: len 1; hex 00; asc  ;;
 27: len 1; hex 18; asc  ;;
 28: len 4; hex e46c7877; asc  lxw;;
 29: len 4; hex e44f4bca; asc  OK ;;
 30: len 5; hex 99aa3c7299; asc   <r ;;
 31: len 1; hex 80; asc  ;;
 32: len 1; hex 82; asc  ;;
 33: len 8; hex 14556371614d33c0; asc  UcqaM3 ;;
 34: len 8; hex 73b35307457d34c0; asc s S E}4 ;;
 35: len 8; hex 88115febdc74a73f; asc   _  t ?;;
 36: len 8; hex 2ab58bceaeed743f; asc *     t?;;
 37: len 8; hex 8000000000000040; asc        @;;
 38: len 8; hex 8000000000000040; asc        @;;
 39: len 8; hex 03cddb57448ce43f; asc    WD  ?;;
 40: len 8; hex 3abfe8aad572cb3f; asc :    r ?;;
 41: SQL NULL;
 42: SQL NULL;
 43: SQL NULL;
 44: SQL NULL;
 45: SQL NULL;
 46: len 1; hex 80; asc  ;;
 47: len 1; hex 89; asc  ;;
 48: SQL NULL;


*** (2) TRANSACTION:
TRANSACTION 32461986411, ACTIVE 0 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 12 lock struct(s), heap size 1128, 11 row lock(s), undo log entries 10
MariaDB thread id 39, OS thread handle 139945819514624, query id 976984093 Update_rows_log_event::find_row(-1) on table `table5`
*** WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 24124841 page no 48269 n bits 80 index PRIMARY of table `aDatabase`.`table5` trx id 32461986411 lock_mode X locks rec but not gap waiting
Record lock, heap no 73 PHYSICAL RECORD: n_fields 49; compact format; info bits 0
 0: len 8; hex 800003ed800005d3; asc         ;;
 1: len 6; hex 00078ee29a80; asc       ;;
 2: len 7; hex 1a0006cc5f21b7; asc     _! ;;
 3: len 22; hex 46492d39323034342d333955435f3330333538353532; asc FI-92044-39UC_30358552;;
 4: len 3; hex 000ccb; asc    ;;
 5: len 1; hex 80; asc  ;;
 6: len 1; hex 80; asc  ;;
 7: len 1; hex 82; asc  ;;
 8: len 1; hex 83; asc  ;;
 9: len 2; hex 8031; asc  1;;
 10: len 1; hex 47; asc G;;
 11: len 16; hex 34383537353434333041383238343942; asc 485754430A82849B;;
 12: len 20; hex 3030303030313831303631373433343334393233; asc 00000181061743434923;;
 13: len 4; hex 30313048; asc 010H;;
 14: len 2; hex 7fff; asc   ;;
 15: len 8; hex 8000041380005df5; asc       ] ;;
 16: len 8; hex 800004bb00000fd5; asc         ;;
 17: SQL NULL;
 18: len 1; hex 83; asc  ;;
 19: len 1; hex 80; asc  ;;
 20: len 1; hex 80; asc  ;;
 21: len 1; hex 87; asc  ;;
 22: len 1; hex 00; asc  ;;
 23: len 1; hex 01; asc  ;;
 24: len 1; hex 01; asc  ;;
 25: len 1; hex 00; asc  ;;
 26: len 1; hex 00; asc  ;;
 27: len 1; hex 18; asc  ;;
 28: len 4; hex e46c7877; asc  lxw;;
 29: len 4; hex e44f4bca; asc  OK ;;
 30: len 5; hex 99aa3c7299; asc   <r ;;
 31: len 1; hex 80; asc  ;;
 32: len 1; hex 82; asc  ;;
 33: len 8; hex adf1c18abe5835c0; asc      X5 ;;
 34: len 8; hex 7b410635413b37c0; asc {A 5A;7 ;;
 35: len 8; hex f2b8a433cfb2903f; asc    3   ?;;
 36: len 8; hex 8c18ed2192e36e3f; asc    !  n?;;
 37: len 8; hex 8000000000000040; asc        @;;
 38: len 8; hex 8000000000000040; asc        @;;
 39: len 8; hex 82418eaeac84d83f; asc  A     ?;;
 40: len 8; hex 017100956594c73f; asc  q  e  ?;;
 41: SQL NULL;
 42: SQL NULL;
 43: len 8; hex ffffffffffffef7f; asc         ;;
 44: SQL NULL;
 45: SQL NULL;
 46: len 1; hex 80; asc  ;;
 47: len 1; hex 89; asc  ;;
 48: SQL NULL;

*** CONFLICTING WITH:
RECORD LOCKS space id 24124841 page no 48269 n bits 80 index PRIMARY of table `aDatabase`.`table5` trx id 32461986432 lock_mode X locks rec but not gap
Record lock, heap no 73 PHYSICAL RECORD: n_fields 49; compact format; info bits 0
 0: len 8; hex 800003ed800005d3; asc         ;;
 1: len 6; hex 00078ee29a80; asc       ;;
 2: len 7; hex 1a0006cc5f21b7; asc     _! ;;
 3: len 22; hex 46492d39323034342d333955435f3330333538353532; asc FI-92044-39UC_30358552;;
 4: len 3; hex 000ccb; asc    ;;
 5: len 1; hex 80; asc  ;;
 6: len 1; hex 80; asc  ;;
 7: len 1; hex 82; asc  ;;
 8: len 1; hex 83; asc  ;;
 9: len 2; hex 8031; asc  1;;
 10: len 1; hex 47; asc G;;
 11: len 16; hex 34383537353434333041383238343942; asc 485754430A82849B;;
 12: len 20; hex 3030303030313831303631373433343334393233; asc 00000181061743434923;;
 13: len 4; hex 30313048; asc 010H;;
 14: len 2; hex 7fff; asc   ;;
 15: len 8; hex 8000041380005df5; asc       ] ;;
 16: len 8; hex 800004bb00000fd5; asc         ;;
 17: SQL NULL;
 18: len 1; hex 83; asc  ;;
 19: len 1; hex 80; asc  ;;
 20: len 1; hex 80; asc  ;;
 21: len 1; hex 87; asc  ;;
 22: len 1; hex 00; asc  ;;
 23: len 1; hex 01; asc  ;;
 24: len 1; hex 01; asc  ;;
 25: len 1; hex 00; asc  ;;
 26: len 1; hex 00; asc  ;;
 27: len 1; hex 18; asc  ;;
 28: len 4; hex e46c7877; asc  lxw;;
 29: len 4; hex e44f4bca; asc  OK ;;
 30: len 5; hex 99aa3c7299; asc   <r ;;
 31: len 1; hex 80; asc  ;;
 32: len 1; hex 82; asc  ;;
 33: len 8; hex adf1c18abe5835c0; asc      X5 ;;
 34: len 8; hex 7b410635413b37c0; asc {A 5A;7 ;;
 35: len 8; hex f2b8a433cfb2903f; asc    3   ?;;
 36: len 8; hex 8c18ed2192e36e3f; asc    !  n?;;
 37: len 8; hex 8000000000000040; asc        @;;
 38: len 8; hex 8000000000000040; asc        @;;
 39: len 8; hex 82418eaeac84d83f; asc  A     ?;;
 40: len 8; hex 017100956594c73f; asc  q  e  ?;;
 41: SQL NULL;
 42: SQL NULL;
 43: len 8; hex ffffffffffffef7f; asc         ;;
 44: SQL NULL;
 45: SQL NULL;
 46: len 1; hex 80; asc  ;;
 47: len 1; hex 89; asc  ;;
 48: SQL NULL;

*** WE ROLL BACK TRANSACTION (1)
------------
TRANSACTIONS
------------
Trx id counter 32465996037
Purge done for trx's n:o < 32465995228 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 32465995244, ACTIVE 57882 sec
9 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 13
MariaDB thread id 15, OS thread handle 139947151865600, query id 1002080583 Waiting for prior transaction to commit
---TRANSACTION 32465995250, ACTIVE 57882 sec
46 lock struct(s), heap size 8312, 42 row lock(s), undo log entries 92
MariaDB thread id 26, OS thread handle 139947148486400, query id 1002080714 Waiting for prior transaction to commit
---TRANSACTION 32465995239, ACTIVE 57882 sec
29 lock struct(s), heap size 3488, 25 row lock(s), undo log entries 53
MariaDB thread id 37, OS thread handle 139945820129024, query id 1002080475 Waiting for prior transaction to commit
---TRANSACTION 32465995267, ACTIVE 57882 sec
11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 16
MariaDB thread id 46, OS thread handle 139945817364224, query id 1002080958 Waiting for prior transaction to commit
---TRANSACTION 32465995240, ACTIVE 57882 sec
65 lock struct(s), heap size 8312, 60 row lock(s), undo log entries 122
MariaDB thread id 57, OS thread handle 139945813985024, query id 1002080545 Waiting for prior transaction to commit
---TRANSACTION 32465995228, ACTIVE 57882 sec
6 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 5
MariaDB thread id 47, OS thread handle 139945817057024, query id 1002080294 Waiting for prior transaction to commit
---TRANSACTION 32465995265, ACTIVE 57882 sec
3 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 2
MariaDB thread id 44, OS thread handle 139945817978624, query id 1002080893 Waiting for prior transaction to commit
---TRANSACTION 32465995255, ACTIVE 57882 sec
3 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 2
MariaDB thread id 59, OS thread handle 139945813370624, query id 1002080785 Waiting for prior transaction to commit
---TRANSACTION 32465995257, ACTIVE 57882 sec
2 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 3
MariaDB thread id 18, OS thread handle 139947150944000, query id 1002080816 Waiting for prior transaction to commit
---TRANSACTION 32465995243, ACTIVE 57882 sec
6 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 5
MariaDB thread id 54, OS thread handle 139945814906624, query id 1002080578 Waiting for prior transaction to commit
---TRANSACTION 32465995232, ACTIVE 57882 sec
18 lock struct(s), heap size 1128, 14 row lock(s), undo log entries 31
MariaDB thread id 13, OS thread handle 139947152480000, query id 1002080330 Waiting for prior transaction to commit
---TRANSACTION 32465995258, ACTIVE 57882 sec
16 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 26
MariaDB thread id 24, OS thread handle 139947149715200, query id 1002080835 Waiting for prior transaction to commit
---TRANSACTION 32465995271, ACTIVE 57882 sec
14 lock struct(s), heap size 1128, 16 row lock(s), undo log entries 37
MariaDB thread id 16, OS thread handle 139947151558400, query id 1002081062 Waiting for prior transaction to commit
---TRANSACTION 32465995251, ACTIVE 57882 sec
6 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 5
MariaDB thread id 20, OS thread handle 139947150329600, query id 1002080725 Waiting for prior transaction to commit
---TRANSACTION 32465995242, ACTIVE 57882 sec
39 lock struct(s), heap size 3488, 35 row lock(s), undo log entries 71
MariaDB thread id 21, OS thread handle 139947150022400, query id 1002080570 Waiting for prior transaction to commit
---TRANSACTION 32465995264, ACTIVE 57882 sec
33 lock struct(s), heap size 3488, 31 row lock(s), undo log entries 62
MariaDB thread id 51, OS thread handle 139945815828224, query id 1002080961 Waiting for prior transaction to commit
---TRANSACTION 32465995231, ACTIVE 57882 sec
6 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 5
MariaDB thread id 36, OS thread handle 139945820436224, query id 1002080315 Waiting for prior transaction to commit
---TRANSACTION 32465995253, ACTIVE 57882 sec
11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 17
MariaDB thread id 49, OS thread handle 139945816442624, query id 1002080737 Waiting for prior transaction to commit
---TRANSACTION 32465995269, ACTIVE 57882 sec
43 lock struct(s), heap size 3488, 40 row lock(s), undo log entries 80
MariaDB thread id 41, OS thread handle 139945818900224, query id 1002081013 Waiting for prior transaction to commit
---TRANSACTION 32465995246, ACTIVE 57882 sec
39 lock struct(s), heap size 3488, 35 row lock(s), undo log entries 74
MariaDB thread id 29, OS thread handle 139945822586624, query id 1002080659 Waiting for prior transaction to commit
---TRANSACTION 32465995233, ACTIVE 57882 sec
6 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 5
MariaDB thread id 23, OS thread handle 139947149100800, query id 1002080335 Waiting for prior transaction to commit
---TRANSACTION 32465995268, ACTIVE 57882 sec
3 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 2
MariaDB thread id 39, OS thread handle 139945819514624, query id 1002080903 Waiting for prior transaction to commit
---TRANSACTION 32465995252, ACTIVE 57882 sec
6 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 5
MariaDB thread id 56, OS thread handle 139945814292224, query id 1002080729 Waiting for prior transaction to commit
---TRANSACTION 32465995229, ACTIVE 57882 sec
3 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 2
MariaDB thread id 48, OS thread handle 139945816749824, query id 1002080291 Waiting for prior transaction to commit
---TRANSACTION 32465995266, ACTIVE 57882 sec
8 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 10
MariaDB thread id 38, OS thread handle 139945819821824, query id 1002080930 Waiting for prior transaction to commit
---TRANSACTION 32465995263, ACTIVE 57882 sec
23 lock struct(s), heap size 3488, 19 row lock(s), undo log entries 40
MariaDB thread id 60, OS thread handle 139945813063424, query id 1002080925 Waiting for prior transaction to commit
---TRANSACTION 32465995237, ACTIVE 57882 sec
45 lock struct(s), heap size 8312, 41 row lock(s), undo log entries 86
MariaDB thread id 14, OS thread handle 139947152172800, query id 1002080435 Waiting for prior transaction to commit
---TRANSACTION 32465995259, ACTIVE 57882 sec
11 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 27
MariaDB thread id 17, OS thread handle 139947151251200, query id 1002080852 Waiting for prior transaction to commit
---TRANSACTION 32465995272, ACTIVE 57882 sec
4 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 2212
MariaDB thread id 19, OS thread handle 139947150636800, query id 1002081117 Waiting for prior transaction to commit
---TRANSACTION 32465995273, ACTIVE 57882 sec
11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 16
MariaDB thread id 22, OS thread handle 139947149408000, query id 1002081082 Waiting for prior transaction to commit
---TRANSACTION 32465995261, ACTIVE 57882 sec
3 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 2
MariaDB thread id 25, OS thread handle 139947148793600, query id 1002080839 Waiting for prior transaction to commit
---TRANSACTION 32465995274, ACTIVE 57882 sec
27 lock struct(s), heap size 3488, 23 row lock(s), undo log entries 48
MariaDB thread id 35, OS thread handle 139945820743424, query id 1002081143 Waiting for prior transaction to commit
---TRANSACTION 32465995245, ACTIVE 57882 sec
13 lock struct(s), heap size 1128, 9 row lock(s), undo log entries 20
MariaDB thread id 27, OS thread handle 139947148179200, query id 1002080598 Waiting for prior transaction to commit
---TRANSACTION 32465995270, ACTIVE 57882 sec
41 lock struct(s), heap size 3488, 37 row lock(s), undo log entries 75
MariaDB thread id 31, OS thread handle 139945821972224, query id 1002081063 Waiting for prior transaction to commit
---TRANSACTION 32465995230, ACTIVE 57882 sec
18 lock struct(s), heap size 1128, 14 row lock(s), undo log entries 28
MariaDB thread id 40, OS thread handle 139945819207424, query id 1002080308 Waiting for prior transaction to commit
---TRANSACTION 32465995260, ACTIVE 57882 sec
18 lock struct(s), heap size 1128, 14 row lock(s), undo log entries 31
MariaDB thread id 28, OS thread handle 139947147872000, query id 1002080872 Waiting for prior transaction to commit
---TRANSACTION (0x7f7898239f80), not started flushing log
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 32465995247, ACTIVE 57882 sec
14 lock struct(s), heap size 1128, 10 row lock(s), undo log entries 24
MariaDB thread id 42, OS thread handle 139945818593024, query id 1002080658 Waiting for prior transaction to commit
---TRANSACTION 32465995238, ACTIVE 57882 sec
6 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 5
MariaDB thread id 53, OS thread handle 139945815213824, query id 1002080427 Waiting for prior transaction to commit
---TRANSACTION 32465995249, ACTIVE 57882 sec
22 lock struct(s), heap size 1128, 18 row lock(s), undo log entries 38
MariaDB thread id 45, OS thread handle 139945817671424, query id 1002080672 Waiting for prior transaction to commit
---TRANSACTION 32465995241, ACTIVE 57882 sec
7 lock struct(s), heap size 1128, 3 row lock(s), undo log entries 9
MariaDB thread id 50, OS thread handle 139945816135424, query id 1002080496 Waiting for prior transaction to commit
---TRANSACTION 32465995254, ACTIVE 57882 sec
50 lock struct(s), heap size 8312, 46 row lock(s), undo log entries 96
MariaDB thread id 32, OS thread handle 139945821665024, query id 1002080784 Waiting for prior transaction to commit
---TRANSACTION 32465995248, ACTIVE 57882 sec
2 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 2
MariaDB thread id 58, OS thread handle 139945813677824, query id 1002080606 Waiting for prior transaction to commit
---TRANSACTION 32465995234, ACTIVE 57882 sec
14 lock struct(s), heap size 1128, 10 row lock(s), undo log entries 24
MariaDB thread id 33, OS thread handle 139945821357824, query id 1002080351 Waiting for prior transaction to commit
---TRANSACTION 32465995256, ACTIVE 57882 sec
27 lock struct(s), heap size 3488, 23 row lock(s), undo log entries 48
MariaDB thread id 55, OS thread handle 139945814599424, query id 1002080811 Waiting for prior transaction to commit
---TRANSACTION 32465995236, ACTIVE 57882 sec
6 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 5
MariaDB thread id 43, OS thread handle 139945818285824, query id 1002080359 Waiting for prior transaction to commit
---TRANSACTION 32465995262, ACTIVE 57882 sec
23 lock struct(s), heap size 3488, 20 row lock(s), undo log entries 42
MariaDB thread id 34, OS thread handle 139945821050624, query id 1002080885 Waiting for prior transaction to commit
---TRANSACTION 32465995235, ACTIVE 57882 sec
34 lock struct(s), heap size 3488, 30 row lock(s), undo log entries 63
MariaDB thread id 52, OS thread handle 139945815521024, query id 1002080393 Waiting for prior transaction to commit
---TRANSACTION (0x7f7898231b80), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION (0x7f78982f1880), not started
0 lock struct(s), heap size 1128, 0 row lock(s)
--------
FILE I/O
--------
Pending flushes (fsync) log: 0; buffer pool: 0
23676277 OS file reads, 250094886 OS file writes, 29922055 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 461, seg size 463, 0 merges
merged operations:
 insert 0, delete mark 0, delete 0
discarded operations:
 insert 0, delete mark 0, delete 0
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 216757235232063
Log flushed up to   216757235232063
Pages flushed up to 216756112274051
Last checkpoint at  216756112274051
0 pending log flushes, 0 pending chkp writes
68295983 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 206175207424
Dictionary memory allocated 1243072920
Buffer pool size   12460032
Free buffers       0
Database pages     12460032
Old database pages 4599484
Modified db pages  150965
Percent of dirty pages(LRU & free pages): 1.212
Max dirty pages percent: 90.000
Pending reads 0
Pending writes: LRU 0, flush list 0
Pages made young 16849982, not young 86718849
0.00 youngs/s, 0.00 non-youngs/s
Pages read 23663259, created 88420874, written 180888908
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
No buffer pool page gets since the last printout
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 12460032, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 read views open inside InnoDB
Process ID=0, Main thread ID=0, state: sleeping
Number of rows inserted 8165581625, updated 634274785, deleted 128864139, read 989687967
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
Number of system rows inserted 71508807, updated 0, deleted 71476799, read 71476799
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s