(root@localhost) [(none)]> show engine innodb status; ===================================== 2022-08-08 10:06:22 0x7f2790511700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 7 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 7567333 srv_active, 0 srv_shutdown, 235621 srv_idle srv_master_thread log flush and writes: 7802117 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 6026579 OS WAIT ARRAY INFO: signal count 22998987 RW-shared spins 15182979, rounds 31603306, OS waits 40158 RW-excl spins 27509913, rounds 58023583, OS waits 249288 RW-sx spins 18946, rounds 287979, OS waits 5658 Spin rounds per wait: 2.08 RW-shared, 2.11 RW-excl, 15.20 RW-sx ------------------------ LATEST DETECTED DEADLOCK ------------------------ 2022-08-08 09:09:24 0x7f25caf3d700 *** (1) TRANSACTION: TRANSACTION 518600196, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 1 MySQL thread id 8788651, OS thread handle 139800268871424, query id 1778229064 172.3.3.8 app_user Update insert into table_prc (d_id, sid) values (1111111, 2) *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 52 page no 6918 n bits 680 index PRIMARY of table `database`.`table_prc` trx id 518600196 lock_mode X locks gap before rec insert intention waiting Record lock, heap no 61 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 0: len 4; hex 00000000; asc ;; 1: len 6; hex 00000000; asc ;; 2: len 7; hex 00000000; asc ;; 3: len 4; hex 00000000; asc ;; *** (2) TRANSACTION: TRANSACTION 518600195, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 1 MySQL thread id 8788149, OS thread handle 139800295495424, query id 1778229070 172.3.3.8 app_user Update insert into table_prc (d_id, sid) values (14265944, 2) *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 52 page no 6918 n bits 680 index PRIMARY of table `database`.`table_prc` trx id 518600195 lock_mode X locks gap before rec Record lock, heap no 61 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 0: len 4; hex 00000000; asc ;; 1: len 6; hex 00000000; asc ;; 2: len 7; hex 00000000; asc ;; 3: len 4; hex 00000000; asc ;; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 52 page no 6918 n bits 680 index PRIMARY of table `database`.`table_prc` trx id 518600195 lock_mode X locks gap before rec insert intention waiting Record lock, heap no 61 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 0: len 4; hex 00000000; asc ;; 1: len 6; hex 00000000; asc ;; 2: len 7; hex 00000000; asc ;; 3: len 4; hex 00000000; asc ;; *** WE ROLL BACK TRANSACTION (2) ------------ TRANSACTIONS ------------ Trx id counter 518603654 Purge done for trx's n:o < 518597430 undo n:o < 0 state: running History list length 98 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 518603647, ACTIVE 2 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 8798608, OS thread handle 139809064240896, query id 1778323068 172.3.3.8 rd1_user_batch Updating DELETE FROM database.table_urt WHERE pid='rd1' ------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 24 page no 39 n bits 440 index PRIMARY of table `database`.`table_urt` trx id 518603647 lock_mode X waiting Record lock, heap no 123 PHYSICAL RECORD: n_fields 9; compact format; info bits 32 0: len 5; hex 00000000; asc rd1;; 1: len 4; hex 00000000; asc #;; 2: len 4; hex 00000000; asc ;; 3: len 4; hex 00000000; asc ;; 4: len 1; hex 00000000; asc ;; 5: len 6; hex 00000000; asc * ;; 6: len 7; hex 00000000; asc : J ;; 7: len 0; hex ; asc ;; 8: len 4; hex 00000000; asc ;; ------------------ ---TRANSACTION 518603644, ACTIVE 10 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 8798462, OS thread handle 139800110159616, query id 1778322933 172.3.3.8 ru2_user_batch Update INSERT INTO database.table_urt (pid, ...) ------- TRX HAS BEEN WAITING 10 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 24 page no 41 n bits 440 index PRIMARY of table `database`.`table_urt` trx id 518603644 lock_mode X locks gap before rec insert intention waiting Record lock, heap no 219 PHYSICAL RECORD: n_fields 9; compact format; info bits 32 0: len 5; hex 00000000; asc ru1;; 1: len 4; hex 00000000; asc ;; 2: len 4; hex 00000000; asc ;; 3: len 4; hex 00000000; asc ;; 4: len 1; hex 00000000; asc ;; 5: len 6; hex 00000000; asc +w;; 6: len 7; hex 00000000; asc @ o;; 7: len 0; hex ; asc ;; 8: len 4; hex 00000000; asc ;; ------------------ ---TRANSACTION 518603642, ACTIVE 11 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 8798508, OS thread handle 139809075422976, query id 1778322920 172.3.3.8 ra1_user_batch Update INSERT INTO database.table_urt (pid, ...) ------- TRX HAS BEEN WAITING 11 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 24 page no 39 n bits 440 index PRIMARY of table `database`.`table_urt` trx id 518603642 lock_mode X locks gap before rec insert intention waiting Record lock, heap no 123 PHYSICAL RECORD: n_fields 9; compact format; info bits 32 0: len 5; hex 00000000; asc rd1;; 1: len 4; hex 00000000; asc #;; 2: len 4; hex 00000000; asc ;; 3: len 4; hex 00000000; asc ;; 4: len 1; hex 00000000; asc ;; 5: len 6; hex 00000000; asc * ;; 6: len 7; hex 00000000; asc : J ;; 7: len 0; hex ; asc ;; 8: len 4; hex 00000000; asc ;; ------------------ ---TRANSACTION 518603638, ACTIVE 14 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 8798456, OS thread handle 139800982025984, query id 1778322858 172.3.3.8 ru1_user_batch Updating DELETE FROM database.table_urt WHERE pid='ru1' ------- TRX HAS BEEN WAITING 14 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 24 page no 41 n bits 440 index PRIMARY of table `database`.`table_urt` trx id 518603638 lock_mode X waiting Record lock, heap no 219 PHYSICAL RECORD: n_fields 9; compact format; info bits 32 0: len 5; hex 00000000; asc ru1;; 1: len 4; hex 00000000; asc ;; 2: len 4; hex 00000000; asc ;; 3: len 4; hex 00000000; asc ;; 4: len 1; hex 00000000; asc ;; 5: len 6; hex 00000000; asc +w;; 6: len 7; hex 00000000; asc @ o;; 7: len 0; hex ; asc ;; 8: len 4; hex 00000000; asc ;; ------------------ ---TRANSACTION 518603635, ACTIVE 18 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 8797818, OS thread handle 139809529337600, query id 1778322769 172.3.3.8 cu1_user_batch Updating DELETE FROM database.table_urp WHERE pid='cu1' ------- TRX HAS BEEN WAITING 18 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 23 page no 19 n bits 448 index PRIMARY of table `database`.`table_urp` trx id 518603635 lock_mode X waiting Record lock, heap no 183 PHYSICAL RECORD: n_fields 8; compact format; info bits 32 0: len 5; hex 00000000; asc cu1;; 1: len 4; hex 00000000; asc ;; 2: len 3; hex 00000000; asc ss;; 3: len 1; hex 00000000; asc ;; 4: len 4; hex 00000000; asc M;; 5: len 6; hex 00000000; asc +_;; 6: len 7; hex 00000000; asc )F;; 7: len 4; hex 00000000; asc ;; ------------------ ---TRANSACTION 518603632, ACTIVE 22 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 8798480, OS thread handle 139808631904000, query id 1778322691 172.3.3.8 rd1_user_batch Updating DELETE FROM database.table_urm WHERE pid='rd1' ------- TRX HAS BEEN WAITING 22 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 22 page no 3 n bits 168 index PRIMARY of table `database`.`table_urm` trx id 518603632 lock_mode X waiting Record lock, heap no 19 PHYSICAL RECORD: n_fields 5; compact format; info bits 0 0: len 5; hex 00000000; asc rd1;; 1: len 10; hex 00000000; asc rd1ss01;; 2: len 6; hex 00000000; asc +,;; 3: len 7; hex 00000000; asc ~ ;; 4: len 4; hex 00000000; asc ;; ------------------ ---TRANSACTION 518603629, ACTIVE 30 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 8798444, OS thread handle 139808618592000, query id 1778322541 172.3.3.8 ru2_user_batch Updating DELETE FROM database.table_urm WHERE pid='ru2' ------- TRX HAS BEEN WAITING 30 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 22 page no 3 n bits 168 index PRIMARY of table `database`.`table_urm` trx id 518603629 lock_mode X waiting Record lock, heap no 80 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 5; hex 00000000; asc ru2;; 1: len 10; hex 00000000; asc ru2ssp24;; 2: len 6; hex 00000000; asc +^;; 3: len 7; hex 00000000; asc ;; 4: len 4; hex 00000000; asc ;; ------------------ ---TRANSACTION 518603622, ACTIVE 31 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 8798319, OS thread handle 139809045604096, query id 1778322495 172.3.3.8 ra1_user_batch Updating DELETE FROM database.table_urm WHERE pid='ra1' ------- TRX HAS BEEN WAITING 31 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 22 page no 3 n bits 168 index PRIMARY of table `database`.`table_urm` trx id 518603622 lock_mode X waiting Record lock, heap no 89 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 5; hex 00000000; asc ra1;; 1: len 10; hex 00000000; asc ra1ss01;; 2: len 6; hex 00000000; asc +`;; 3: len 7; hex 00000000; asc ;; 4: len 4; hex 00000000; asc 9;; ------------------ ---TRANSACTION 518603621, ACTIVE 31 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 8798436, OS thread handle 139808571303680, query id 1778322494 172.3.3.8 rd1_p_batch Updating DELETE FROM table_sbu WHERE pid ='rd1' ------- TRX HAS BEEN WAITING 31 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 80 page no 67 n bits 456 index PRIMARY of table `database`.`table_sbu` trx id 518603621 lock_mode X waiting Record lock, heap no 2 PHYSICAL RECORD: n_fields 7; compact format; info bits 0 0: len 4; hex 00000000; asc >;; 1: len 5; hex 00000000; asc rb11;; 2: len 6; hex 00000000; asc + ;; 3: len 7; hex 00000000; asc J Y4 ;; 4: len 4; hex 00000000; asc );; 5: len 4; hex 00000000; asc ;; 6: len 3; hex 00000000; asc ;; ------------------ ---TRANSACTION 518603620, ACTIVE 34 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 8798256, OS thread handle 139800966051584, query id 1778322451 172.3.3.8 ru1_user_batch Updating DELETE FROM database.table_urp WHERE pid='ru1' ------- TRX HAS BEEN WAITING 34 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 23 page no 33 n bits 472 index PRIMARY of table `database`.`table_urp` trx id 518603620 lock_mode X waiting Record lock, heap no 299 PHYSICAL RECORD: n_fields 8; compact format; info bits 0 0: len 5; hex 00000000; asc ru1;; 1: len 4; hex 00000000; asc ;; 2: len 3; hex 00000000; asc fd;; 3: len 1; hex 00000000; asc ;; 4: len 4; hex 00000000; asc ;; 5: len 6; hex 00000000; asc +/;; 6: len 7; hex 00000000; asc c ;; 7: len 4; hex 00000000; asc ;; ------------------ ---TRANSACTION 518603617, ACTIVE 38 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 8798375, OS thread handle 139800126134016, query id 1778322370 172.3.3.8 cu1_user_batch Update INSERT INTO database.table_urt (pid,.. ) ------- TRX HAS BEEN WAITING 38 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 24 page no 39 n bits 440 index PRIMARY of table `database`.`table_urt` trx id 518603617 lock_mode X locks gap before rec insert intention waiting Record lock, heap no 123 PHYSICAL RECORD: n_fields 9; compact format; info bits 32 0: len 5; hex 00000000; asc rd1;; 1: len 4; hex 00000000; asc #;; 2: len 4; hex 00000000; asc ;; 3: len 4; hex 00000000; asc ;; 4: len 1; hex 00000000; asc ;; 5: len 6; hex 00000000; asc * ;; 6: len 7; hex 00000000; asc : J ;; 7: len 0; hex ; asc ;; 8: len 4; hex 00000000; asc ;; ------------------ ---TRANSACTION 518603613, ACTIVE 42 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 8798286, OS thread handle 139809519752960, query id 1778322298 172.3.3.8 rd1_user_batch Updating DELETE FROM database.table_urt WHERE pid='rd1' ------- TRX HAS BEEN WAITING 42 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 24 page no 39 n bits 440 index PRIMARY of table `database`.`table_urt` trx id 518603613 lock_mode X waiting Record lock, heap no 123 PHYSICAL RECORD: n_fields 9; compact format; info bits 32 0: len 5; hex 00000000; asc rd1;; 1: len 4; hex 00000000; asc #;; 2: len 4; hex 00000000; asc ;; 3: len 4; hex 00000000; asc ;; 4: len 1; hex 00000000; asc ;; 5: len 6; hex 00000000; asc * ;; 6: len 7; hex 00000000; asc : J ;; 7: len 0; hex ; asc ;; 8: len 4; hex 00000000; asc ;; ------------------ ---TRANSACTION 518603610, ACTIVE 50 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 8798087, OS thread handle 139800970311424, query id 1778322146 172.3.3.8 ru2_user_batch Update INSERT INTO database.table_urt (pid,...) ------- TRX HAS BEEN WAITING 50 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 24 page no 41 n bits 440 index PRIMARY of table `database`.`table_urt` trx id 518603610 lock_mode X locks gap before rec insert intention waiting Record lock, heap no 219 PHYSICAL RECORD: n_fields 9; compact format; info bits 32 0: len 5; hex 00000000; asc ru1;; 1: len 4; hex 00000000; asc ;; 2: len 4; hex 00000000; asc ;; 3: len 4; hex 00000000; asc ;; 4: len 1; hex 00000000; asc ;; 5: len 6; hex 00000000; asc +w;; 6: len 7; hex 00000000; asc @ o;; 7: len 0; hex ; asc ;; 8: len 4; hex 00000000; asc ;; ------------------ ---TRANSACTION 421300813182152, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421300813314336, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421300813322864, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 518603328, ACTIVE 347 sec 6 lock struct(s), heap size 1128, 3 row lock(s), undo log entries 3 MySQL thread id 8796793, OS thread handle 139811332720384, query id 1778316415 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518603329, sees < 518597282 ---TRANSACTION 518603278, ACTIVE 398 sec 6 lock struct(s), heap size 1128, 3 row lock(s), undo log entries 3 MySQL thread id 8796543, OS thread handle 139800411784960, query id 1778315372 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518603279, sees < 518597282 ---TRANSACTION 518603275, ACTIVE 400 sec 6 lock struct(s), heap size 1128, 3 row lock(s), undo log entries 3 MySQL thread id 8796534, OS thread handle 139809571428096, query id 1778315330 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518603277, sees < 518597282 ---TRANSACTION 518603276, ACTIVE 400 sec 6 lock struct(s), heap size 1128, 3 row lock(s), undo log entries 3 MySQL thread id 8796533, OS thread handle 139809084753664, query id 1778315329 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518603277, sees < 518597282 ---TRANSACTION 421300813365504, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421300813246112, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421300813305808, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421300813318600, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 518602331, ACTIVE 1387 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 8792582, OS thread handle 139807951763200, query id 1778296108 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518602332, sees < 518597282 ---TRANSACTION 518602243, ACTIVE 1467 sec 12 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 8792417, OS thread handle 139809063708416, query id 1778293886 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518602244, sees < 518597282 ---TRANSACTION 518602045, ACTIVE 1655 sec 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 8792094, OS thread handle 139807909672704, query id 1778288424 172.3.3.8 app_user starting COMMIT ---TRANSACTION 518602329, ACTIVE 1387 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8792001, OS thread handle 139807950165760, query id 1778296055 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518602330, sees < 518597282 ---TRANSACTION 518601945, ACTIVE 1747 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8791931, OS thread handle 139800975636224, query id 1778285930 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601946, sees < 518597282 ---TRANSACTION 518602327, ACTIVE 1388 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 8791926, OS thread handle 139807949633280, query id 1778295975 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518602328, sees < 518597282 ---TRANSACTION 518601943, ACTIVE 1750 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8791922, OS thread handle 139809085286144, query id 1778285723 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601944, sees < 518597282 ---TRANSACTION 518601991, ACTIVE 1706 sec 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 8791860, OS thread handle 139799884388096, query id 1778286915 172.3.3.8 app_user starting COMMIT ---TRANSACTION 518601899, ACTIVE 1789 sec 14 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 3 MySQL thread id 8791779, OS thread handle 139800974571264, query id 1778284570 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601900, sees < 518597282 ---TRANSACTION 518601858, ACTIVE 1830 sec 12 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 8791673, OS thread handle 139809079150336, query id 1778283413 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601859, sees < 518597282 ---TRANSACTION 518601942, ACTIVE 1751 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8791672, OS thread handle 139809043474176, query id 1778285660 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601943, sees < 518597282 ---TRANSACTION 518602296, ACTIVE 1416 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 8791671, OS thread handle 139808620189440, query id 1778295225 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518602297, sees < 518597282 ---TRANSACTION 518601787, ACTIVE 1892 sec 8 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 3 MySQL thread id 8791666, OS thread handle 139809071163136, query id 1778274657 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601788, sees < 518597282 ---TRANSACTION 518602140, ACTIVE 1569 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8791581, OS thread handle 139799872673536, query id 1778291004 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518602141, sees < 518597282 ---TRANSACTION 518601730, ACTIVE 1948 sec 8 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 3 MySQL thread id 8791495, OS thread handle 139799879063296, query id 1778272918 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601731, sees < 518597282 ---TRANSACTION 518601766, ACTIVE 1916 sec 12 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8791392, OS thread handle 139800928093952, query id 1778273945 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601767, sees < 518597282 ---TRANSACTION 518601878, ACTIVE 1807 sec 11 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 4 MySQL thread id 8791291, OS thread handle 139799890777856, query id 1778284093 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601879, sees < 518597282 ---TRANSACTION 518601580, ACTIVE 2098 sec 19 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 3 MySQL thread id 8791237, OS thread handle 139799898765056, query id 1778269239 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601581, sees < 518597282 ---TRANSACTION 518601680, ACTIVE 1998 sec 19 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 3 MySQL thread id 8791225, OS thread handle 139799911012096, query id 1778271747 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601681, sees < 518597282 ---TRANSACTION 518601509, ACTIVE 2165 sec 12 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 3 MySQL thread id 8791085, OS thread handle 139799913142016, query id 1778267005 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601510, sees < 518597282 ---TRANSACTION 518601585, ACTIVE 2092 sec 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 1 MySQL thread id 8791004, OS thread handle 139799956805376, query id 1778269405 172.3.3.8 app_user starting COMMIT ---TRANSACTION 518601527, ACTIVE 2148 sec 8 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 3 MySQL thread id 8790985, OS thread handle 139799958935296, query id 1778267569 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601528, sees < 518597282 ---TRANSACTION 518601320, ACTIVE 2342 sec 19 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 3 MySQL thread id 8790844, OS thread handle 139799938168576, query id 1778261748 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601321, sees < 518597282 ---TRANSACTION 518601633, ACTIVE 2042 sec 8 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 3 MySQL thread id 8790815, OS thread handle 139800049989376, query id 1778270685 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601634, sees < 518597282 ---TRANSACTION 518601428, ACTIVE 2242 sec 8 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 3 MySQL thread id 8790660, OS thread handle 139799971714816, query id 1778264898 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601429, sees < 518597282 ---TRANSACTION 518601477, ACTIVE 2192 sec 19 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 3 MySQL thread id 8790656, OS thread handle 139799968519936, query id 1778266223 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601478, sees < 518597282 ---TRANSACTION 518601270, ACTIVE 2393 sec 19 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 3 MySQL thread id 8790575, OS thread handle 139799967454976, query id 1778260227 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601271, sees < 518597282 ---TRANSACTION 518601369, ACTIVE 2298 sec 8 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 3 MySQL thread id 8790576, OS thread handle 139799966922496, query id 1778262838 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601370, sees < 518597282 ---TRANSACTION 518601422, ACTIVE 2248 sec 19 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 3 MySQL thread id 8790553, OS thread handle 139799994078976, query id 1778264385 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601423, sees < 518597282 ---TRANSACTION 518601151, ACTIVE 2506 sec 19 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 3 MySQL thread id 8790541, OS thread handle 139799992481536, query id 1778257421 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601152, sees < 518597282 ---TRANSACTION 518601099, ACTIVE 2556 sec 19 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 3 MySQL thread id 8790361, OS thread handle 139800003131136, query id 1778256059 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601100, sees < 518597282 ---TRANSACTION 518601037, ACTIVE 2612 sec 19 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 3 MySQL thread id 8790303, OS thread handle 139800010053376, query id 1778254172 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601038, sees < 518597282 ---TRANSACTION 518601857, ACTIVE 1831 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8790271, OS thread handle 139800002598656, query id 1778283351 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601858, sees < 518597282 ---TRANSACTION 518601138, ACTIVE 2520 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 8790125, OS thread handle 139800027625216, query id 1778257059 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601139, sees < 518597282 ---TRANSACTION 518600986, ACTIVE 2666 sec 19 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 3 MySQL thread id 8790027, OS thread handle 139800053184256, query id 1778252436 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600987, sees < 518597282 ---TRANSACTION 518600921, ACTIVE 2728 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8789928, OS thread handle 139800051054336, query id 1778251031 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600922, sees < 518597282 ---TRANSACTION 518600822, ACTIVE 2823 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8789927, OS thread handle 139800050521856, query id 1778247992 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600823, sees < 518597282 ---TRANSACTION 518600875, ACTIVE 2772 sec 19 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 3 MySQL thread id 8789890, OS thread handle 139800053716736, query id 1778249651 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600876, sees < 518597282 ---TRANSACTION 518600766, ACTIVE 2878 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8789865, OS thread handle 139800045197056, query id 1778246115 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600767, sees < 518597282 ---TRANSACTION 518600823, ACTIVE 2823 sec 19 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 3 MySQL thread id 8789813, OS thread handle 139800078210816, query id 1778248083 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600824, sees < 518597282 ---TRANSACTION 518600714, ACTIVE 2925 sec 19 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 3 MySQL thread id 8789758, OS thread handle 139800055846656, query id 1778244626 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600715, sees < 518597282 ---TRANSACTION 518601210, ACTIVE 2450 sec 19 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 3 MySQL thread id 8789757, OS thread handle 139800056379136, query id 1778258825 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518601211, sees < 518597282 ---TRANSACTION 518600934, ACTIVE 2716 sec 19 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 3 MySQL thread id 8789699, OS thread handle 139800077145856, query id 1778251311 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600935, sees < 518597282 ---TRANSACTION 518600690, ACTIVE 2949 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8789646, OS thread handle 139800069158656, query id 1778244053 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600691, sees < 518597282 ---TRANSACTION 518600769, ACTIVE 2874 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 8789619, OS thread handle 139800073418496, query id 1778246233 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600770, sees < 518597282 ---TRANSACTION 518600770, ACTIVE 2873 sec 19 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 3 MySQL thread id 8789612, OS thread handle 139800117614336, query id 1778246274 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600771, sees < 518597282 ---TRANSACTION 518600582, ACTIVE 3050 sec 14 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 3 MySQL thread id 8789525, OS thread handle 139800082470656, query id 1778240791 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600583, sees < 518597282 ---TRANSACTION 518600607, ACTIVE 3027 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 8789498, OS thread handle 139800124536576, query id 1778241613 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600608, sees < 518597282 ---TRANSACTION 518600606, ACTIVE 3027 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 8789497, OS thread handle 139800086198016, query id 1778241606 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600607, sees < 518597282 ---TRANSACTION 518600541, ACTIVE 3090 sec 19 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 3 MySQL thread id 8789492, OS thread handle 139800115484416, query id 1778239778 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600542, sees < 518597282 ---TRANSACTION 518600529, ACTIVE 3096 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 8789483, OS thread handle 139800103237376, query id 1778239284 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600530, sees < 518597282 ---TRANSACTION 518600520, ACTIVE 3102 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 8789423, OS thread handle 139800095250176, query id 1778239103 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600521, sees < 518597282 ---TRANSACTION 518600592, ACTIVE 3038 sec 19 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 3 MySQL thread id 8789421, OS thread handle 139800096315136, query id 1778241181 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600593, sees < 518597282 ---TRANSACTION 518600552, ACTIVE 3079 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 8789328, OS thread handle 139800116016896, query id 1778240101 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600553, sees < 518597282 ---TRANSACTION 518600480, ACTIVE 3143 sec 19 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 3 MySQL thread id 8789254, OS thread handle 139800125601536, query id 1778237872 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600481, sees < 518597282 ---TRANSACTION 518600490, ACTIVE 3133 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 8789063, OS thread handle 139800133056256, query id 1778238182 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600491, sees < 518597282 ---TRANSACTION 518600237, ACTIVE 3377 sec 13 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 8788878, OS thread handle 139800152758016, query id 1778230685 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600238, sees < 518597282 ---TRANSACTION 518600356, ACTIVE 3263 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 8788813, OS thread handle 139800158615296, query id 1778234182 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600357, sees < 518597282 ---TRANSACTION 518600382, ACTIVE 3241 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 8788651, OS thread handle 139800268871424, query id 1778234902 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600383, sees < 518597282 ---TRANSACTION 518600073, ACTIVE (PREPARED) 3529 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 8788649, OS thread handle 139800176719616, query id 1778225189 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600074, sees < 518597282 ---TRANSACTION 518600301, ACTIVE 3317 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 8788621, OS thread handle 139800256624384, query id 1778232564 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600302, sees < 518597282 ---TRANSACTION 518599972, ACTIVE (PREPARED) 3625 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8788531, OS thread handle 139800256091904, query id 1778218820 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599973, sees < 518597282 ---TRANSACTION 518599951, ACTIVE (PREPARED) 3640 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 8788479, OS thread handle 139800261949184, query id 1778217886 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599952, sees < 518597282 ---TRANSACTION 518600015, ACTIVE (PREPARED) 3579 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8788478, OS thread handle 139800272066304, query id 1778220043 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600016, sees < 518597282 ---TRANSACTION 518600284, ACTIVE 3331 sec 12 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8788407, OS thread handle 139800269936384, query id 1778231780 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600285, sees < 518597282 ---TRANSACTION 518600042, ACTIVE (PREPARED) 3560 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8788350, OS thread handle 139800381433600, query id 1778222532 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600043, sees < 518597282 ---TRANSACTION 518599908, ACTIVE (PREPARED) 3681 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8788198, OS thread handle 139800289638144, query id 1778216662 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599909, sees < 518597282 ---TRANSACTION 518599854, ACTIVE (PREPARED) 3732 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8788197, OS thread handle 139800290170624, query id 1778213477 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599855, sees < 518597282 ---TRANSACTION 518600651, ACTIVE 2981 sec 19 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 3 MySQL thread id 8788149, OS thread handle 139800295495424, query id 1778242811 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600652, sees < 518597282 ---TRANSACTION 518599805, ACTIVE (PREPARED) 3777 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8788036, OS thread handle 139800308807424, query id 1778211186 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599806, sees < 518597282 ---TRANSACTION 518600079, ACTIVE 3523 sec 13 lock struct(s), heap size 1128, 10 row lock(s), undo log entries 2 MySQL thread id 8787974, OS thread handle 139800381966080, query id 1778228901 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600080, sees < 518597282 ---TRANSACTION 518599742, ACTIVE (PREPARED) 3834 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8787972, OS thread handle 139800382498560, query id 1778198536 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599743, sees < 518597282 ---TRANSACTION 518599795, ACTIVE (PREPARED) 3782 sec 11 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 8787951, OS thread handle 139800395278080, query id 1778210645 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599796, sees < 518597282 ---TRANSACTION 518599634, ACTIVE (PREPARED) 3937 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8787825, OS thread handle 139800397408000, query id 1778175239 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599635, sees < 518597282 ---TRANSACTION 518599848, ACTIVE (PREPARED) 3737 sec 13 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 3 MySQL thread id 8787485, OS thread handle 139800433616640, query id 1778212864 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599849, sees < 518597282 ---TRANSACTION 518599639, ACTIVE (PREPARED) 3936 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 8787234, OS thread handle 139800483137280, query id 1778175973 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599640, sees < 518597282 ---TRANSACTION 518599408, ACTIVE (PREPARED) 4157 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 8787173, OS thread handle 139800466097920, query id 1778151929 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599409, sees < 518597282 ---TRANSACTION 518599223, ACTIVE (PREPARED) 4329 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 8787147, OS thread handle 139800481007360, query id 1778147118 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599224, sees < 518597282 ---TRANSACTION 518599141, ACTIVE (PREPARED) 4405 sec 8 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 3 MySQL thread id 8787124, OS thread handle 139800499111680, query id 1778144512 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599142, sees < 518597282 ---TRANSACTION 518599142, ACTIVE (PREPARED) 4403 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8787123, OS thread handle 139800558163712, query id 1778144579 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599143, sees < 518597282 ---TRANSACTION 518599412, ACTIVE (PREPARED) 4152 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 8787080, OS thread handle 139800477280000, query id 1778152105 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599414, sees < 518597282 ---TRANSACTION 518599562, ACTIVE (PREPARED) 4007 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 8787079, OS thread handle 139800477812480, query id 1778156232 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599563, sees < 518597282 ---TRANSACTION 518599201, ACTIVE (PREPARED) 4349 sec 8 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 3 MySQL thread id 8787078, OS thread handle 139800492189440, query id 1778146288 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599202, sees < 518597282 ---TRANSACTION 518599089, ACTIVE (PREPARED) 4446 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 8787026, OS thread handle 139800494319360, query id 1778143007 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599090, sees < 518597282 ---TRANSACTION 518599150, ACTIVE (PREPARED) 4396 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 8786999, OS thread handle 139800487929600, query id 1778144819 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599151, sees < 518597282 ---TRANSACTION 518599369, ACTIVE (PREPARED) 4193 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 8786903, OS thread handle 139800547514112, query id 1778150892 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599370, sees < 518597282 ---TRANSACTION 518599077, ACTIVE (PREPARED) 4456 sec 8 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 3 MySQL thread id 8786723, OS thread handle 139800523552512, query id 1778142692 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599078, sees < 518597282 ---TRANSACTION 518598960, ACTIVE (PREPARED) 4563 sec 8 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 3 MySQL thread id 8786722, OS thread handle 139800524084992, query id 1778132068 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598961, sees < 518597282 ---TRANSACTION 518599021, ACTIVE (PREPARED) 4509 sec 8 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 3 MySQL thread id 8786721, OS thread handle 139800536864512, query id 1778133668 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599022, sees < 518597282 ---TRANSACTION 518599050, ACTIVE (PREPARED) 4480 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 8786678, OS thread handle 139800529409792, query id 1778135015 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599051, sees < 518597282 ---TRANSACTION 518599476, ACTIVE (PREPARED) 4096 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 8786669, OS thread handle 139800531007232, query id 1778153845 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599477, sees < 518597282 ---TRANSACTION 518598794, ACTIVE (PREPARED) 4712 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 8786567, OS thread handle 139800542721792, query id 1778127563 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598795, sees < 518597282 ---TRANSACTION 518598905, ACTIVE (PREPARED) 4615 sec 8 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 3 MySQL thread id 8786563, OS thread handle 139800543254272, query id 1778130466 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598906, sees < 518597282 ---TRANSACTION 518600022, ACTIVE (PREPARED) 3575 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8786562, OS thread handle 139800543786752, query id 1778220278 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518600023, sees < 518597282 ---TRANSACTION 518598793, ACTIVE (PREPARED) 4713 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 8786554, OS thread handle 139800557631232, query id 1778127500 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598794, sees < 518597282 ---TRANSACTION 518598955, ACTIVE (PREPARED) 4568 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 8786418, OS thread handle 139800592242432, query id 1778131832 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598956, sees < 518597282 ---TRANSACTION 518599002, ACTIVE (PREPARED) 4530 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 8786221, OS thread handle 139800605021952, query id 1778133039 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599003, sees < 518597282 ---TRANSACTION 518598676, ACTIVE (PREPARED) 4823 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 8786190, OS thread handle 139800584255232, query id 1778116497 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598677, sees < 518597282 ---TRANSACTION 518598845, ACTIVE (PREPARED) 4667 sec 8 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 3 MySQL thread id 8786121, OS thread handle 139800606086912, query id 1778128863 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598846, sees < 518597282 ---TRANSACTION 518598555, ACTIVE (PREPARED) 4939 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8785959, OS thread handle 139800712333056, query id 1778113167 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598556, sees < 518597282 ---TRANSACTION 518599104, ACTIVE (PREPARED) 4433 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 8785958, OS thread handle 139800608216832, query id 1778143568 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599105, sees < 518597282 ---TRANSACTION 518598781, ACTIVE (PREPARED) 4722 sec 8 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 3 MySQL thread id 8785934, OS thread handle 139800685557504, query id 1778126961 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598782, sees < 518597282 ---TRANSACTION 518599459, ACTIVE (PREPARED) 4107 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 8785933, OS thread handle 139800654522112, query id 1778153495 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518599460, sees < 518597282 ---TRANSACTION 518598479, ACTIVE (PREPARED) 5009 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8785909, OS thread handle 139800644404992, query id 1778103843 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598480, sees < 518597282 ---TRANSACTION 518598397, ACTIVE (PREPARED) 5085 sec 5 lock struct(s), heap size 1128, 3 row lock(s), undo log entries 2 MySQL thread id 8785867, OS thread handle 139800649197312, query id 1778101719 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598398, sees < 518597282 ---TRANSACTION 518598344, ACTIVE (PREPARED) 5138 sec 10 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 2 MySQL thread id 8785776, OS thread handle 139800658781952, query id 1778099780 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598345, sees < 518597282 ---TRANSACTION 518598423, ACTIVE (PREPARED) 5064 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8785753, OS thread handle 139800662509312, query id 1778102299 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598424, sees < 518597282 ---TRANSACTION 518598311, ACTIVE (PREPARED) 5167 sec 13 lock struct(s), heap size 1128, 9 row lock(s), undo log entries 3 MySQL thread id 8785739, OS thread handle 139800682895104, query id 1778092067 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598312, sees < 518597282 ---TRANSACTION 518598743, ACTIVE (PREPARED) 4760 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 8785663, OS thread handle 139800710735616, query id 1778125656 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598744, sees < 518597282 ---TRANSACTION 518598527, ACTIVE (PREPARED) 4962 sec 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 MySQL thread id 8785622, OS thread handle 139800685025024, query id 1778112467 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598528, sees < 518597282 ---TRANSACTION 518598291, ACTIVE (PREPARED) 5189 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 8785618, OS thread handle 139800686089984, query id 1778091440 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598292, sees < 518597282 ---TRANSACTION 518598263, ACTIVE (PREPARED) 5215 sec 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 MySQL thread id 8785617, OS thread handle 139800686622464, query id 1778090497 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598264, sees < 518597282 ---TRANSACTION 518598393, ACTIVE (PREPARED) 5087 sec 9 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 2 MySQL thread id 8785605, OS thread handle 139800711800576, query id 1778101658 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598394, sees < 518597282 ---TRANSACTION 518598240, ACTIVE (PREPARED) 5238 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 8785553, OS thread handle 139800693012224, query id 1778089207 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598241, sees < 518597282 ---TRANSACTION 518598235, ACTIVE (PREPARED) 5240 sec 10 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 2 MySQL thread id 8785531, OS thread handle 139800696207104, query id 1778088432 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598236, sees < 518597282 ---TRANSACTION 518598289, ACTIVE (PREPARED) 5190 sec 10 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 2 MySQL thread id 8785440, OS thread handle 139800737384192, query id 1778091380 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598290, sees < 518597282 ---TRANSACTION 518598198, ACTIVE (PREPARED) 5273 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8785363, OS thread handle 139800723515136, query id 1778081581 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598199, sees < 518597282 ---TRANSACTION 518598180, ACTIVE (PREPARED) 5291 sec 10 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 2 MySQL thread id 8785355, OS thread handle 139800733656832, query id 1778081046 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598181, sees < 518597282 ---TRANSACTION 518598110, ACTIVE (PREPARED) 5360 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 8785301, OS thread handle 139800739514112, query id 1778079285 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598111, sees < 518597282 ---TRANSACTION 518598076, ACTIVE (PREPARED) 5394 sec 10 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 2 MySQL thread id 8785300, OS thread handle 139800740046592, query id 1778078095 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598077, sees < 518597282 ---TRANSACTION 518598124, ACTIVE (PREPARED) 5343 sec 10 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 2 MySQL thread id 8785238, OS thread handle 139800755488512, query id 1778079744 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598125, sees < 518597282 ---TRANSACTION 518598038, ACTIVE (PREPARED) 5427 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 8785237, OS thread handle 139800769230592, query id 1778077279 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598039, sees < 518597282 ---TRANSACTION 518598018, ACTIVE (PREPARED) 5446 sec 10 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 2 MySQL thread id 8785144, OS thread handle 139800756020992, query id 1778076713 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598019, sees < 518597282 ---TRANSACTION 518598049, ACTIVE (PREPARED) 5419 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8785008, OS thread handle 139800791594752, query id 1778077550 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598050, sees < 518597282 ---TRANSACTION 518597866, ACTIVE (PREPARED) 5599 sec 4 lock struct(s), heap size 1128, 3 row lock(s), undo log entries 2 MySQL thread id 8784955, OS thread handle 139800829425408, query id 1778072367 172.3.3.8 ru1_user_batch starting commit ---TRANSACTION 518597868, ACTIVE (PREPARED) 5597 sec 10 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 2 MySQL thread id 8784913, OS thread handle 139800920639232, query id 1778072471 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518597869, sees < 518597282 ---TRANSACTION 518597968, ACTIVE (PREPARED) 5496 sec 10 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 2 MySQL thread id 8784889, OS thread handle 139800791062272, query id 1778075361 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518597969, sees < 518597282 ---TRANSACTION 518598019, ACTIVE (PREPARED) 5444 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 8784785, OS thread handle 139800917976832, query id 1778076800 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518598020, sees < 518597282 ---TRANSACTION 518597818, ACTIVE (PREPARED) 5642 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 8784679, OS thread handle 139800933824256, query id 1778071126 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518597819, sees < 518597282 ---TRANSACTION 518597919, ACTIVE (PREPARED) 5546 sec 10 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 2 MySQL thread id 8784678, OS thread handle 139800934889216, query id 1778073905 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518597920, sees < 518597282 ---TRANSACTION 518597706, ACTIVE (PREPARED) 5756 sec 10 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 2 MySQL thread id 8784660, OS thread handle 139800920106752, query id 1778067368 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518597707, sees < 518597282 ---TRANSACTION 518597810, ACTIVE (PREPARED) 5647 sec 10 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 2 MySQL thread id 8784656, OS thread handle 139800921704192, query id 1778070875 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518597811, sees < 518597282 ---TRANSACTION 518597755, ACTIVE (PREPARED) 5704 sec 10 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 2 MySQL thread id 8784602, OS thread handle 139800952739584, query id 1778069259 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518597756, sees < 518597282 ---TRANSACTION 518597688, ACTIVE (PREPARED) 5769 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 4 MySQL thread id 8784580, OS thread handle 139800930756352, query id 1778066942 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518597689, sees < 518597282 ---TRANSACTION 518597651, ACTIVE (PREPARED) 5808 sec 10 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 2 MySQL thread id 8784565, OS thread handle 139809049863936, query id 1778065651 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518597652, sees < 518597282 ---TRANSACTION 518597630, ACTIVE (PREPARED) 5827 sec 12 lock struct(s), heap size 1128, 16 row lock(s), undo log entries 11 MySQL thread id 8784479, OS thread handle 139800951674624, query id 1778065143 172.3.3.8 rd1_user_batch starting commit ---TRANSACTION 518597640, ACTIVE (PREPARED) 5820 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 8784489, OS thread handle 139800955934464, query id 1778065327 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518597641, sees < 518597282 ---TRANSACTION 518597643, ACTIVE (PREPARED) 5812 sec 10 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 2 MySQL thread id 8784469, OS thread handle 139807926052608, query id 1778065521 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518597644, sees < 518597282 ---TRANSACTION 518597579, ACTIVE (PREPARED) 5867 sec 10 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 2 MySQL thread id 8784428, OS thread handle 139800973506304, query id 1778063898 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518597580, sees < 518597282 ---TRANSACTION 518597495, ACTIVE (PREPARED) 5930 sec mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 469 row lock(s), undo log entries 467 MySQL thread id 8784339, OS thread handle 139809046669056, query id 1778062190 172.3.3.8 ru1_user_batch Commit DELETE FROM database.table_urt WHERE pid='ru1' ---TRANSACTION 518597472, ACTIVE (PREPARED) 5950 sec mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 12 row lock(s), undo log entries 11 MySQL thread id 8784295, OS thread handle 139808626046720, query id 1778061646 172.3.3.8 ra1_user_batch Commit DELETE FROM database.table_urm WHERE pid='ra1' ---TRANSACTION 518597471, ACTIVE (PREPARED) 5950 sec mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 116 row lock(s), undo log entries 115 MySQL thread id 8784299, OS thread handle 139807899555584, query id 1778061644 172.3.3.8 cu1_user_batch Commit DELETE FROM database.table_urp WHERE pid='cu1' ---TRANSACTION 518597470, ACTIVE (PREPARED) 5950 sec mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 37 row lock(s), undo log entries 36 MySQL thread id 8784291, OS thread handle 139807910737664, query id 1778061643 172.3.3.8 ru2_user_batch Commit DELETE FROM database.table_urm WHERE pid='ru2' ---TRANSACTION 518597464, ACTIVE (PREPARED) 5951 sec mysql tables in use 1, locked 1 12 lock struct(s), heap size 1128, 1745 row lock(s), undo log entries 1735 MySQL thread id 8784286, OS thread handle 139809054123776, query id 1778061630 172.3.3.8 rd1_user_batch Commit DELETE FROM database.table_urp WHERE pid='rd1' ---TRANSACTION 518597425, ACTIVE (PREPARED) 5970 sec mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 8 MySQL thread id 8784262, OS thread handle 139809568233216, query id 1778053343 172.3.3.8 cu1_user_batch Commit INSERT INTO database.table_urm (pid, sr, at) VALUES ('cu1', 'cu1ss00', 3),('cu1', 'cu1ss02', 101),('cu1', 'cu1ss03', 119),('cu1', 'cu1ss04', 1),('cu1', 'cu1ss05', 177),('cu1', 'cu1ss06', 199),('cu1', 'cu1ss07', 129),('cu1', 'cu1ss08', 544) ---TRANSACTION 518597423, ACTIVE (PREPARED) 5970 sec mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 938 MySQL thread id 8784255, OS thread handle 139809574090496, query id 1778053256 172.3.3.8 ru1_user_batch Commit INSERT INTO database.table_urp (pid, ...) ---TRANSACTION 518597383, ACTIVE (PREPARED) 5979 sec 71 lock struct(s), heap size 24696, 16546 row lock(s), undo log entries 16150 MySQL thread id 8784273, OS thread handle 139811333785344, query id 1778061243 172.3.3.8 rb11_p_batch starting commit ---TRANSACTION 518597363, ACTIVE (PREPARED) 5996 sec mysql tables in use 1, locked 1 5 lock struct(s), heap size 1128, 791 row lock(s), undo log entries 788 MySQL thread id 8783757, OS thread handle 139809529870080, query id 1778052255 172.3.3.8 rd1_user_batch Commit DELETE FROM database.table_urt WHERE pid='rd1' ---TRANSACTION 518597590, ACTIVE (PREPARED) 5858 sec 7 lock struct(s), heap size 1128, 839 row lock(s), undo log entries 1644 MySQL thread id 8783387, OS thread handle 139807961347840, query id 1778064171 172.3.3.8 ru2_monitor starting commit ---TRANSACTION 518597685, ACTIVE (PREPARED) 5770 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 8782920, OS thread handle 139800953272064, query id 1778066869 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518597686, sees < 518597282 ---TRANSACTION 518597421, ACTIVE (PREPARED) 5971 sec 10 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 2 MySQL thread id 8782815, OS thread handle 139808575563520, query id 1778053184 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518597422, sees < 518597282 ---TRANSACTION 518597456, ACTIVE (PREPARED) 5961 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 8782779, OS thread handle 139808575031040, query id 1778061391 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518597457, sees < 518597282 ---TRANSACTION 518597420, ACTIVE (PREPARED) 5971 sec mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 21 MySQL thread id 8781308, OS thread handle 139808605280000, query id 1778053064 172.3.3.8 rd1_user_batch Commit INSERT INTO database.table_urm (pid,..) 5971 sec 4 lock struct(s), heap size 1128, 834 row lock(s), undo log entries 1638 MySQL thread id 8765183, OS thread handle 139808589408000, query id 1778053959 172.3.3.8 ru1_monitor starting commit ---TRANSACTION 518597514, ACTIVE (PREPARED) 5919 sec 10 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 2 MySQL thread id 8744976, OS thread handle 139809569298176, query id 1778062466 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518597515, sees < 518597282 ---TRANSACTION 518597523, ACTIVE (PREPARED) 5916 sec 7 lock struct(s), heap size 1128, 811 row lock(s), undo log entries 1598 MySQL thread id 8726826, OS thread handle 139807919130368, query id 1778062613 172.3.3.8 ra1_monitor starting commit ---TRANSACTION 421300813335656, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 518597469, ACTIVE (PREPARED) 5950 sec mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 20 row lock(s), undo log entries 19 MySQL thread id 8649903, OS thread handle 139808578758400, query id 1778061642 172.3.3.8 ru1_user_batch Commit DELETE FROM database.table_urm WHERE pid='ru1' ---TRANSACTION 518597282, ACTIVE (PREPARED) 6019 sec 11 lock struct(s), heap size 1128, 2283 row lock(s), undo log entries 758 MySQL thread id 8648186, OS thread handle 139809508419328, query id 1778053027 172.3.3.8 rd1_monitor starting commit ---TRANSACTION 421300814346224, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 518597585, ACTIVE (PREPARED) 5859 sec 5 lock struct(s), heap size 1128, 824 row lock(s), undo log entries 1628 MySQL thread id 8643678, OS thread handle 139807945627392, query id 1778064085 172.3.3.8 rb11_monitor starting commit ---TRANSACTION 518597620, ACTIVE (PREPARED) 5833 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 8642647, OS thread handle 139809050928896, query id 1778064966 172.3.3.8 app_user starting COMMIT Trx read view will not see trx with id >= 518597621, sees < 518597282 ---TRANSACTION 421300813907032, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 518597516, ACTIVE (PREPARED) 5917 sec 7 lock struct(s), heap size 1128, 819 row lock(s), undo log entries 1608 MySQL thread id 8612407, OS thread handle 139809525077760, query id 1778062599 172.3.3.8 cu1_monitor starting commit ---TRANSACTION 518599708, ACTIVE (PREPARED) 3870 sec 4 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 6 MySQL thread id 16, OS thread handle 139811327522560, query id 1778190728 committing ---TRANSACTION 421300813497688, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421300813459312, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421300813484896, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421300813480632, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421300813476368, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421300813472104, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421300813467840, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421300813463576, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421300813450784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421300813446520, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421300813237584, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421300813173624, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421300813169360, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421300813165096, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421300813160832, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421300813156568, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- Pending flushes (fsync) log: 0; buffer pool: 0 316991 OS file reads, 69549360 OS file writes, 63066078 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 1607, seg size 1609, 84 merges merged operations: insert 804, delete mark 4, delete 4 discarded operations: insert 0, delete mark 0, delete 0 0.00 hash searches/s, 6.71 non-hash searches/s --- LOG --- Log sequence number 6328077098796 Log flushed up to 6328077098796 Pages flushed up to 6325818565944 Last checkpoint at 6325818565944 0 pending log flushes, 0 pending chkp writes 62900003 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 13488881664 Dictionary memory allocated 79982352 Buffer pool size 806500 Free buffers 493932 Database pages 312567 Old database pages 115361 Modified db pages 7366 Percent of dirty pages(LRU & free pages): 0.913 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0 Pages made young 3153329, not young 13941146 0.00 youngs/s, 0.00 non-youngs/s Pages read 316590, created 558178, written 6617734 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 312567, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 143 read views open inside InnoDB Process ID=0, Main thread ID=0, state: sleeping Number of rows inserted 5631462602, updated 1503849, deleted 5637515399, read 921379227521 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.14 reads/s Number of system rows inserted 140, updated 0, deleted 138, read 277 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================