(root@localhost) [(none)]> SHOW ENGINE INNODB STATUS\G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2022-02-18 19:39:37 0x7.0b9c6d700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 2 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 21584296 srv_active, 0 srv_shutdown, 980408 srv_idle srv_master_thread log flush and writes: 22561553 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 18116165 OS WAIT ARRAY INFO: signal count 5.09781 RW-shared spins 44627975, rounds 88551732, OS waits 105648 RW-excl spins 58769205, rounds 126605383, OS waits 820100 RW-sx spins 111719, rounds 1670570, OS waits 37509 Spin rounds per wait: 1.98 RW-shared, 2.15 RW-excl, 14.95 RW-sx ------------------------ LATEST DETECTED DEADLOCK ------------------------ 2022-02-16 14:13:15 0x7f34d0f23700 *** (1) TRANSACTION: TRANSACTION 316347401, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 5 lock struct(s), heap size 1128, 3 row lock(s) MySQL thread id 25075968, OS thread handle 139861194389248, query id 4961074622 192.168.0.51 www2 Update insert into ...... *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 51 page no 35001 n bits 160 index PRIMARY of table `database`.`makss` trx id 316347401 lock_mode X locks gap before rec insert intention waiting Record lock, heap no 9 PHYSICAL RECORD: n_fields 40; compact format; info bits 0 0: len 12; hex 0x00000000 ; asc XXXXXXXXXXX; 1: len 6; hex 0x00000000 ; asc XXXXXXXXXXX; 2: len 7; hex 0x00000000 ; asc XXXXXXXXXXX; 3: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 4: len 3; hex 0x00000000 ; asc XXXXXXXXXXX; 5: len 7; hex 0x00000000 ; asc XXXXXXXXXXX; 6: len 30; hex 0x00000000 ; asc XXXXXXXXXXX; 7: SQL NULL; 8: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 9: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 10: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 11: SQL NULL; 12: SQL NULL; 13: len 2; hex 0x00000000 ; asc XXXXXXXXXXX; 14: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 15: len 0; hex 0x00000000 ; asc XXXXXXXXXXX; 16: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 17: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 18: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 19: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 20: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 21: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 22: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 23: len 9; hex 0x00000000 ; asc XXXXXXXXXXX; 24: SQL NULL; 25: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 26: SQL NULL; 27: SQL NULL; 28: SQL NULL; 29: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 30: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 31: SQL NULL; 32: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 33: SQL NULL; 34: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 35: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 36: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 37: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 38: SQL NULL; 39: SQL NULL; *** (2) TRANSACTION: TRANSACTION 316347402, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1128, 3 row lock(s) MySQL thread id 25098107, OS thread handle 139864820561664, query id 4961074623 192.168.0.51 www2 Update insert into makss .. *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 51 page no 35001 n bits 160 index PRIMARY of table `database`.`makss` trx id 316347402 lock_mode X locks gap before rec Record lock, heap no 9 PHYSICAL RECORD: n_fields 40; compact format; info bits 0 0: len 12; hex 0x00000000 ; asc XXXXXXXXXXX; 1: len 6; hex 0x00000000 ; asc XXXXXXXXXXX; 2: len 7; hex 0x00000000 ; asc XXXXXXXXXXX; 3: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 4: len 3; hex 0x00000000 ; asc XXXXXXXXXXX; 5: len 7; hex 0x00000000 ; asc XXXXXXXXXXX; 6: len 30; hex 0x00000000 ; asc XXXXXXXXXXX; 7: SQL NULL; 8: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 9: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 10: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 11: SQL NULL; 12: SQL NULL; 13: len 2; hex 0x00000000 ; asc XXXXXXXXXXX; 14: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 15: len 0; hex 0x00000000 ; asc XXXXXXXXXXX; 16: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 17: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 18: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 19: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 20: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 21: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 22: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 23: len 9; hex 0x00000000 ; asc XXXXXXXXXXX; 24: SQL NULL; 25: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 26: SQL NULL; 27: SQL NULL; 28: SQL NULL; 29: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 30: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 31: SQL NULL; 32: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 33: SQL NULL; 34: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 35: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 36: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 37: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 38: SQL NULL; 39: SQL NULL; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 51 page no 35001 n bits 160 index PRIMARY of table `database`.`makss` trx id 316347402 lock_mode X locks gap before rec insert intention waiting Record lock, heap no 9 PHYSICAL RECORD: n_fields 40; compact format; info bits 0 0: len 12; hex 0x00000000 ; asc XXXXXXXXXXX; 1: len 6; hex 0x00000000 ; asc XXXXXXXXXXX; 2: len 7; hex 0x00000000 ; asc XXXXXXXXXXX; 3: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 4: len 3; hex 0x00000000 ; asc XXXXXXXXXXX; 5: len 7; hex 0x00000000 ; asc XXXXXXXXXXX; 6: len 30; hex 0x00000000 ; asc XXXXXXXXXXX; 7: SQL NULL; 8: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 9: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 10: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 11: SQL NULL; 12: SQL NULL; 13: len 2; hex 0x00000000 ; asc XXXXXXXXXXX; 14: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 15: len 0; hex 0x00000000 ; asc XXXXXXXXXXX; 16: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 17: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 18: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 19: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 20: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 21: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 22: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 23: len 9; hex 0x00000000 ; asc XXXXXXXXXXX; 24: SQL NULL; 25: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 26: SQL NULL; 27: SQL NULL; 28: SQL NULL; 29: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 30: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 31: SQL NULL; 32: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 33: SQL NULL; 34: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 35: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 36: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 37: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 38: SQL NULL; 39: SQL NULL; *** WE ROLL BACK TRANSACTION (2) ------------ TRANSACTIONS ------------ Trx id counter 319257742 Purge done for trx's n:o < 319253216 n:o < 0 state: running History list length 172 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421353839919576, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353839855136, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 319257739, ACTIVE 6 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 25371614, OS thread handle 139859597215488, query id 5009031950 192.168.0.51 c_ur_cron Updating DELETE FROM database.c_re_tr WHERE p_id='c' ------- TRX HAS BEEN WAITING 6 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 24 page no 19 n bits 432 index PRIMARY of table `database`.`c_re_tr` trx id 319257739 lock_mode X waiting Record lock, heap no 2 PHYSICAL RECORD: n_fields 9; compact format; info bits 0 0: len 5; hex 0x00000000 ; asc XXXXXXXXXXX; 1: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 2: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 3: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 4: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 5: len 6; hex 0x00000000 ; asc XXXXXXXXXXX; 6: len 7; hex 0x00000000 ; asc XXXXXXXXXXX; 7: len 0; hex 0x00000000 ; asc XXXXXXXXXXX; 8: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; ------------------ ---TRANSACTION 319257738, ACTIVE 8 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 25371628, OS thread handle 139859585349376, query id 5009031907 192.168.0.51 l_ur_cron Updating DELETE FROM s_bu_us WHERE p_id ='d' ------- TRX HAS BEEN WAITING 8 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 80 page no 4 n bits 464 index PRIMARY of table `database`.`s_bu_us` trx id 319257738 lock_mode X waiting Record lock, heap no 2 PHYSICAL RECORD: n_fields 7; compact format; info bits 0 0: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 1: len 5; hex 0x00000000 ; asc XXXXXXXXXXX; 2: len 6; hex 0x00000000 ; asc XXXXXXXXXXX; 3: len 7; hex 0x00000000 ; asc XXXXXXXXXXX; 4: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 5: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 6: len 3; hex 0x00000000 ; asc XXXXXXXXXXX; ------------------ ---TRANSACTION 319257737, ACTIVE 9 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 25371592, OS thread handle 139859575764736, query id 5009031891 192.168.0.51 l_ur_cron Updating DELETE FROM database.c_us_re_pr WHERE p_id='d' ------- TRX HAS BEEN WAITING 9 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 23 page no 113 n bits 352 index PRIMARY of table `database`.`c_us_re_pr` trx id 319257737 lock_mode X waiting Record lock, heap no 41 PHYSICAL RECORD: n_fields 8; compact format; info bits 32 0: len 5; hex 0x00000000 ; asc XXXXXXXXXXX; 1: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 2: len 3; hex 0x00000000 ; asc XXXXXXXXXXX; 3: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 4: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 5: len 6; hex 0x00000000 ; asc XXXXXXXXXXX; 6: len 7; hex 0x00000000 ; asc XXXXXXXXXXX; 7: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; ------------------ ---TRANSACTION 319257736, ACTIVE 10 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 25371595, OS thread handle 139860687869696, query id 5009031861 192.168.0.51 g_ur_cron Updating DELETE FROM database.c_re_tr WHERE p_id='b' ------- TRX HAS BEEN WAITING 10 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 24 page no 16 n bits 448 index PRIMARY of table `database`.`c_re_tr` trx id 319257736 lock_mode X waiting Record lock, heap no 262 PHYSICAL RECORD: n_fields 9; compact format; info bits 32 0: len 5; hex 0x00000000 ; asc XXXXXXXXXXX; 1: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 2: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 3: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 4: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 5: len 6; hex 0x00000000 ; asc XXXXXXXXXXX; 6: len 7; hex 0x00000000 ; asc XXXXXXXXXXX; 7: len 0; hex 0x00000000 ; asc XXXXXXXXXXX; 8: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; ------------------ ---TRANSACTION 319257735, ACTIVE 13 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 25371601, OS thread handle 139859584284416, query id 5009031822 192.168.0.51 u_ur_cron Updating DELETE FROM database.c_us_re_ma WHERE p_id='ul' ------- TRX HAS BEEN WAITING 13 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 22 page no 3 n bits 200 index PRIMARY of table `database`.`c_us_re_ma` trx id 319257735 lock_mode X waiting Record lock, heap no 58 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 5; hex 0x00000000 ; asc XXXXXXXXXXX; 1: len 10; hex 0x00000000 ; asc XXXXXXXXXXX; 2: len 6; hex 0x00000000 ; asc XXXXXXXXXXX; 3: len 7; hex 0x00000000 ; asc XXXXXXXXXXX; 4: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; ------------------ ---TRANSACTION 319257.0, ACTIVE 17 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 25364512, OS thread handle 139861187999488, query id 5009031717 192.168.0.51 a_ur_cron Updating DELETE FROM database.c_us_re_pr WHERE p_id='a' ------- TRX HAS BEEN WAITING 17 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 23 page no 106 n bits 472 index PRIMARY of table `database`.`c_us_re_pr` trx id 319257.0 lock_mode X waiting Record lock, heap no 285 PHYSICAL RECORD: n_fields 8; compact format; info bits 32 0: len 5; hex 0x00000000 ; asc XXXXXXXXXXX; 1: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 2: len 3; hex 0x00000000 ; asc XXXXXXXXXXX; 3: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 4: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 5: len 6; hex 0x00000000 ; asc XXXXXXXXXXX; 6: len 7; hex 0x00000000 ; asc XXXXXXXXXXX; 7: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; ------------------ ---TRANSACTION 319257731, 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 25371050, OS thread handle 139859602007808, query id 5009031668 192.168.0.51 e1_ur_cron Updating DELETE FROM database.c_us_re_ma WHERE p_id='un' ------- TRX HAS BEEN WAITING 18 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 22 page no 3 n bits 200 index PRIMARY of table `database`.`c_us_re_ma` trx id 319257731 lock_mode X waiting Record lock, heap no 131 PHYSICAL RECORD: n_fields 5; compact format; info bits 32 0: len 5; hex 0x00000000 ; asc XXXXXXXXXXX; 1: len 10; hex 0x00000000 ; asc XXXXXXXXXXX; 2: len 6; hex 0x00000000 ; asc XXXXXXXXXXX; 3: len 7; hex 0x00000000 ; asc XXXXXXXXXXX; 4: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; ------------------ ---TRANSACTION 319257712, ACTIVE (PREPARED) 52 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 4 MySQL thread id 25371543, OS thread handle 139859583219456, query id 5009031084 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257713, sees < 319252968 ---TRANSACTION 319257724, ACTIVE 32 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 25371.0, OS thread handle 139859599877888, query id 5009031427 192.168.0.51 www2 Statistics select maksentity0_.makss_id as makss_id1_48_,... ------- TRX HAS BEEN WAITING 32 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 51 page no 116797 n bits 168 index PRIMARY of table `database`.`makss` trx id 319257724 lock_mode X locks rec but not gap waiting Record lock, heap no 51 PHYSICAL RECORD: n_fields 40; compact format; info bits 0 0: len 12; hex 0x00000000 ; asc XXXXXXXXXXX; 1: len 6; hex 0x00000000 ; asc XXXXXXXXXXX; 2: len 7; hex 0x00000000 ; asc XXXXXXXXXXX; 3: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 4: len 3; hex 0x00000000 ; asc XXXXXXXXXXX; 5: len 12; hex 0x00000000 ; asc XXXXXXXXXXX; 6: len 30; hex 0x00000000 ; asc XXXXXXXXXXX; 7: SQL NULL; 8: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 9: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 10: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 11: SQL NULL; 12: SQL NULL; 13: len 2; hex 0x00000000 ; asc XXXXXXXXXXX; 14: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 15: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 16: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 17: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 18: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 19: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 20: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 21: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 22: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 23: len 9; hex 0x00000000 ; asc XXXXXXXXXXX; 24: SQL NULL; 25: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 26: SQL NULL; 27: SQL NULL; 28: SQL NULL; 29: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 30: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 31: SQL NULL; 32: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 33: SQL NULL; 34: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 35: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 36: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 37: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 38: SQL NULL; 39: SQL NULL; ------------------ ---TRANSACTION 319257720, ACTIVE 38 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 25371478, OS thread handle 139860162459392, query id 5009031312 192.168.0.51 www2 Statistics select maksentity0_.makss_id as makss_id1_48_, ..... ------- TRX HAS BEEN WAITING 38 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 51 page no 4177 n bits 184 index PRIMARY of table `database`.`makss` trx id 319257720 lock_mode X locks rec but not gap waiting Record lock, heap no 116 PHYSICAL RECORD: n_fields 40; compact format; info bits 0 0: len 12; hex 0x00000000 ; asc XXXXXXXXXXX; 1: len 6; hex 0x00000000 ; asc XXXXXXXXXXX; 2: len 7; hex 0x00000000 ; asc XXXXXXXXXXX; 3: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 4: len 3; hex 0x00000000 ; asc XXXXXXXXXXX; 5: len 16; hex 0x00000000 ; asc XXXXXXXXXXX; 6: len 30; hex 0x00000000 ; asc XXXXXXXXXXX; 7: SQL NULL; 8: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 9: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 10: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 11: SQL NULL; 12: SQL NULL; 13: len 2; hex 0x00000000 ; asc XXXXXXXXXXX; 14: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 15: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 16: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 17: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 18: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 19: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 20: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 21: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 22: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 23: len 9; hex 0x00000000 ; asc XXXXXXXXXXX; 24: SQL NULL; 25: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 26: SQL NULL; 27: SQL NULL; 28: SQL NULL; 29: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 30: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 31: SQL NULL; 32: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 33: SQL NULL; 34: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 35: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 36: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 37: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 38: SQL NULL; 39: SQL NULL; ------------------ ---TRANSACTION 319257687, ACTIVE (PREPARED) 98 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25371443, OS thread handle 139860158732032, query id 5009030138 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257688, sees < 319252968 ---TRANSACTION 319257741, ACTIVE 2 sec inserting mysql tables in use 1, locked 1 LOCK WAIT 5 lock struct(s), heap size 1128, 3 row lock(s) MySQL thread id 25371424, OS thread handle 139859592955648, query id 5009032073 192.168.0.51 www2 Update insert into makss .... Trx read view will not see trx with id >= 319257742, sees < 319252968 ------- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 51 page no 60842 n bits 168 index PRIMARY of table `database`.`makss` trx id 319257741 lock_mode X locks gap before rec insert intention waiting Record lock, heap no 26 PHYSICAL RECORD: n_fields 40; compact format; info bits 0 0: len 13; hex 0x00000000 ; asc XXXXXXXXXXX; 1: len 6; hex 0x00000000 ; asc XXXXXXXXXXX; 2: len 7; hex 0x00000000 ; asc XXXXXXXXXXX; 3: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 4: len 3; hex 0x00000000 ; asc XXXXXXXXXXX; 5: len 6; hex 0x00000000 ; asc XXXXXXXXXXX; 6: len 30; hex 0x00000000 ; asc XXXXXXXXXXX; 7: len 30; hex 0x00000000 ; asc XXXXXXXXXXX; 8: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 9: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 10: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 11: SQL NULL; 12: SQL NULL; 13: len 2; hex 0x00000000 ; asc XXXXXXXXXXX; 14: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 15: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 16: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 17: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 18: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 19: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 20: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 21: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 22: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 23: len 9; hex 0x00000000 ; asc XXXXXXXXXXX; 24: SQL NULL; 25: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 26: SQL NULL; 27: SQL NULL; 28: SQL NULL; 29: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 30: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 31: SQL NULL; 32: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 33: SQL NULL; 34: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 35: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 36: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 37: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 38: SQL NULL; 39: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; ------------------ ---TRANSACTION 319257730, ACTIVE 20 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 25371315, OS thread handle 139859461932800, query id 5009031650 192.168.0.51 www2 Statistics select maksentity0_.makss_id .... ------- TRX HAS BEEN WAITING 20 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 51 page no 75435 n bits 160 index PRIMARY of table `database`.`makss` trx id 319257730 lock_mode X locks rec but not gap waiting Record lock, heap no 70 PHYSICAL RECORD: n_fields 40; compact format; info bits 0 0: len 13; hex 0x00000000 ; asc XXXXXXXXXXX; 1: len 6; hex 0x00000000 ; asc XXXXXXXXXXX; 2: len 7; hex 0x00000000 ; asc XXXXXXXXXXX; 3: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 4: len 3; hex 0x00000000 ; asc XXXXXXXXXXX; 5: len 12; hex 0x00000000 ; asc XXXXXXXXXXX; 6: len 30; hex 0x00000000 ; asc XXXXXXXXXXX; 7: SQL NULL; 8: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 9: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 10: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 11: SQL NULL; 12: SQL NULL; 13: len 2; hex 0x00000000 ; asc XXXXXXXXXXX; 14: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 15: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 16: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 17: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 18: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 19: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 20: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 21: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 22: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 23: len 9; hex 0x00000000 ; asc XXXXXXXXXXX; 24: SQL NULL; 25: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 26: SQL NULL; 27: SQL NULL; 28: SQL NULL; 29: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 30: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 31: SQL NULL; 32: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 33: SQL NULL; 34: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 35: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 36: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 37: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 38: SQL NULL; 39: SQL NULL; ------------------ ---TRANSACTION 421353837960600, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 319257676, ACTIVE (PREPARED) 119 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 4 MySQL thread id 25371303, OS thread handle 139859597747968, query id 5009029783 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257677, sees < 319252968 ---TRANSACTION 319257732, ACTIVE (PREPARED) 18 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25371254, OS thread handle 139859616536320, query id 5009031703 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257.0, sees < 319252968 ---TRANSACTION 421353839837952, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 319257734, ACTIVE (PREPARED) 14 sec 8 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 3 MySQL thread id 25371129, OS thread handle 139859589228288, query id 5009031804 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257735, sees < 319252968 ---TRANSACTION 319257621, ACTIVE (PREPARED) 221 sec 9 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 3 MySQL thread id 25371124, OS thread handle 139861226870528, query id 5009027745 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257622, sees < 319252968 ---TRANSACTION 319257623, ACTIVE (PREPARED) 220 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25371113, OS thread handle 139859585881856, query id 5009027779 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257624, sees < 319252968 ---TRANSACTION 319257597, ACTIVE (PREPARED) 272 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 4 MySQL thread id 25371025, OS thread handle 139859590825728, query id 5009026807 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257598, sees < 319252968 ---TRANSACTION 319257563, ACTIVE (PREPARED).01 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25370945, OS thread handle 139859623458560, query id 5009025545 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257564, sees < 319252968 ---TRANSACTION 319257571, ACTIVE (PREPARED) 322 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25370911, OS thread handle 139859594020608, query id 5009025758 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257572, sees < 319252968 ---TRANSACTION 319257638, ACTIVE (PREPARED) 188 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 25370886, OS thread handle 139859600410368, query id 500902.03 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257639, sees < 319252968 ---TRANSACTION 319257647, ACTIVE (PREPARED) 170 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 4 MySQL thread id 25370851, OS thread handle 139860121687808, query id 5009028796 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257648, sees < 319252968 ---TRANSACTION 319257613, ACTIVE (PREPARED) 235 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25370841, OS thread handle 139859618.0760, query id 5009027486 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257614, sees < 319252968 ---TRANSACTION 319257512, ACTIVE (PREPARED) 425 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25370557, OS thread handle 139859605735168, query id 5009023661 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257513, sees < 319252968 ---TRANSACTION 319257471, ACTIVE (PREPARED) 496 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25370509, OS thread handle 139860147930880, query id 5009022242 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257472, sees < 319252968 ---TRANSACTION 319257483, ACTIVE (PREPARED) 476 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25370489, OS thread handle 139859607865088, query id 5009022699 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257484, sees < 319252968 ---TRANSACTION 319257562, ACTIVE (PREPARED).02 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25370482, OS thread handle 1398596287.060, query id 5009025502 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257563, sees < 319252968 ---TRANSACTION 319257615, ACTIVE (PREPARED) 232 sec 8 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 3 MySQL thread id 25370457, OS thread handle 139863920023296, query id 5009027542 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257616, sees < 319252968 ---TRANSACTION 319257558, ACTIVE (PREPARED).05 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 4 MySQL thread id 25370420, OS thread handle 139864542156544, query id 5009025417 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257559, sees < 319252968 ---TRANSACTION 319257537, ACTIVE (PREPARED) 382 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25370414, OS thread handle 139859602540288, query id 5009024510 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257538, sees < 319252968 ---TRANSACTION 319257509, ACTIVE (PREPARED) 428 sec 14 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 3 MySQL thread id 25370284, OS thread handle 139859609614080, query id 5009023544 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257510, sees < 319252968 ---TRANSACTION 319257378, ACTIVE (PREPARED) 676 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 25370276, OS thread handle 139861198116608, query id 5009018888 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257379, sees < 319252968 ---TRANSACTION 319257375, ACTIVE (PREPARED) 681 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25370245, OS thread handle 139859611744000, query id 5009018785 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257376, sees < 319252968 ---TRANSACTION 319257506, ACTIVE (PREPARED) 432 sec 6 lock struct(s), heap size 1128, 3 row lock(s), undo log entries 3 MySQL thread id 25370199, OS thread handle 139859606267648, query id 5009023469 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257507, sees < 319252968 ---TRANSACTION 319257323, ACTIVE (PREPARED) 773 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25370197, OS thread handle 13985960.02608, query id 5009016898 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257324, sees < 319252968 ---TRANSACTION 319257383, ACTIVE (PREPARED) 663 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25370193, OS thread handle 13986069.00304, query id 5009019184 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257384, sees < 319252968 ---TRANSACTION 319257364, ACTIVE (PREPARED) 700 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 25370175, OS thread handle 139859617601280, query id 5009018436 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257365, sees < 319252968 ---TRANSACTION 319257477, ACTIVE (PREPARED) 485 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25370151, OS thread handle 139859631445760, query id 5009022467 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257478, sees < 319252968 ---TRANSACTION 319257287, ACTIVE (PREPARED) 849 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25370022, OS thread handle 139859626653440, query id 5009015322 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257288, sees < 319252968 ---TRANSACTION 319257346, ACTIVE (PREPARED) 732 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 25370020, OS thread handle 139859634640640, query id 5009017767 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257347, sees < 319252968 ---TRANSACTION 319257308, ACTIVE (PREPARED) 802 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25370011, OS thread handle 139859619731200, query id 5009016310 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257309, sees < 319252968 ---TRANSACTION 319257245, ACTIVE (PREPARED) .0 sec 10 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 4 MySQL thread id 25369897, OS thread handle 139859610679040, query id 5009013730 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257246, sees < 319252968 ---TRANSACTION 319257204, ACTIVE (PREPARED) 1016 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25369745, OS thread handle 139860109973248, query id 5009012222 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257205, sees < 319252968 ---TRANSACTION 319257293, ACTIVE (PREPARED) 836 sec 9 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 3 MySQL thread id 25369738, OS thread handle 139860115298048, query id 5009015627 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257294, sees < 319252968 ---TRANSACTION 319257294, ACTIVE (PREPARED) 832 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 4 MySQL thread id 25369732, OS thread handle 139859625588480, query id 5009015759 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257295, sees < 319252968 ---TRANSACTION 319257226, ACTIVE (PREPARED) 972 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25369716, OS thread handle 139860128888576, query id 5009013011 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257227, sees < 319252968 ---TRANSACTION 319257341, ACTIVE (PREPARED) 742 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25369648, OS thread handle 139859622926080, query id 5009017531 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257342, sees < 319252968 ---TRANSACTION 319257280, ACTIVE (PREPARED) 868 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25369.0, OS thread handle 139859624523520, query id 5009014954 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257281, sees < 319252968 ---TRANSACTION 319257171, ACTIVE (PREPARED) 1073 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25369632, OS thread handle 139859623991040, query id 5009011057 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257172, sees < 319252968 ---TRANSACTION 319257193, ACTIVE (PREPARED) 1.0 sec 8 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 4 MySQL thread id 25369573, OS thread handle 139859629848320, query id 5009011816 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257194, sees < 319252968 ---TRANSACTION 319257181, ACTIVE (PREPARED) 1056 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 25369551, OS thread handle 13986013527.06, query id 5009011404 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257182, sees < 319252968 ---TRANSACTION 319257144, ACTIVE (PREPARED) 1125 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25369490, OS thread handle 139860139538176, query id 5009010022 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257145, sees < 319252968 ---TRANSACTION 319257170, ACTIVE (PREPARED) 1073 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25369485, OS thread handle 139859636770560, query id 5009011034 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257171, sees < 319252968 ---TRANSACTION 319257129, ACTIVE (PREPARED) 1156 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25369469, OS thread handle 139860108908288, query id 5009009377 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257130, sees < 319252968 ---TRANSACTION 319257125, ACTIVE (PREPARED) 1170 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25369440, OS thread handle 139859635705600, query id 5009009092 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257126, sees < 319252968 ---TRANSACTION 319257112, ACTIVE (PREPARED) 1195 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25369406, OS thread handle 139863886071552, query id 5009008629 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257113, sees < 319252968 ---TRANSACTION 319257164, ACTIVE (PREPARED) 1086 sec 7 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 4 MySQL thread id 25369217, OS thread handle 139860145268480, query id 5009010742 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257165, sees < 319252968 ---TRANSACTION 319257088, ACTIVE (PREPARED) 1243 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25369089, OS thread handle 139860109440768, query id 5009007702 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257089, sees < 319252968 ---TRANSACTION 319257090, ACTIVE (PREPARED) 1239 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25369067, OS thread handle 1398601078.028, query id 5009007783 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257091, sees < 319252968 ---TRANSACTION 319257299, ACTIVE (PREPARED) 826 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25369020, OS thread handle 139860132083456, query id 5009015893 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257300, sees < 319252968 ---TRANSACTION 319257009, ACTIVE (PREPARED) 1402 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25369004, OS thread handle 139860108375808, query id 5009004695 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257010, sees < 319252968 ---TRANSACTION 319257140, ACTIVE (PREPARED) 1.0 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25368991, OS thread handle 139860129953536, query id 5009009853 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257141, sees < 319252968 ---TRANSACTION 319256998, ACTIVE (PREPARED) 1425 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25368925, OS thread handle 139860115830528, query id 5009004208 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256999, sees < 319252968 ---TRANSACTION 319257169, ACTIVE (PREPARED) 1074 sec 8 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 3 MySQL thread id 25368923, OS thread handle 139860141008640, query id 5009010999 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257170, sees < 319252968 ---TRANSACTION 319256979, ACTIVE (PREPARED) 1463 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25368883, OS thread handle 139860111570688, query id 5009003432 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256980, sees < 319252968 ---TRANSACTION 319256973, ACTIVE (PREPARED) 1473 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25368882, OS thread handle 139860112103168, query id 5009003247 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256974, sees < 319252968 ---TRANSACTION 319256992, ACTIVE (PREPARED) 1432 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25368863, OS thread handle 139860119557888, query id 5009004049 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256993, sees < 319252968 ---TRANSACTION 319256994, ACTIVE (PREPARED) 1431 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25368792, OS thread handle 139863887668992, query id 5009004087 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256995, sees < 319252968 ---TRANSACTION 319256948, ACTIVE (PREPARED) 1523 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25368764, OS thread handle 139860114.0088, query id 5009002306 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256949, sees < 319252968 ---TRANSACTION 319257001, ACTIVE (PREPARED) 1416 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 25368700, OS thread handle 139860137940736, query id 5009004436 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257002, sees < 319252968 ---TRANSACTION 319256924, ACTIVE (PREPARED) 1569 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25368698, OS thread handle 139860120622848, query id 5009001391 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256925, sees < 319252968 ---TRANSACTION 319257044, ACTIVE (PREPARED) 1328 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25368635, OS thread handle 139860117427968, query id 5009006056 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319257045, sees < 319252968 ---TRANSACTION 319256899, ACTIVE (PREPARED) 1621 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25368606, OS thread handle 139860169914112, query id 5009000463 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256900, sees < 319252968 ---TRANSACTION 319256896, ACTIVE (PREPARED) 1623 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 25368600, OS thread handle 139860121155328, query id 5009000403 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256897, sees < 319252968 ---TRANSACTION 319256920, ACTIVE (PREPARED) 1573 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25368540, OS thread handle 139860119025408, query id 5009001301 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256921, sees < 319252968 ---TRANSACTION 319256939, ACTIVE (PREPARED) 1538 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25368450, OS thread handle 139860122220288, query id 5009002016 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256940, sees < 319252968 ---TRANSACTION 319256990, ACTIVE (PREPARED) 1435 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25368411, OS thread handle 139860125693696, query id 5009003996 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256991, sees < 319252968 ---TRANSACTION 319256846, ACTIVE (PREPARED) 1728 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25368389, OS thread handle 139860124096256, query id 500899.06 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256847, sees < 319252968 ---TRANSACTION 319256840, ACTIVE (PREPARED) 1735 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25368387, OS thread handle 139860127823616, query id 5008998176 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256841, sees < 319252968 ---TRANSACTION 319256827, ACTIVE (PREPARED) 1770 sec 12 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 25368321, OS thread handle 139860128356096, query id 5008997495 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256828, sees < 319252968 ---TRANSACTION 319256895, ACTIVE (PREPARED) 1624 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25368314, OS thread handle 139860126758656, query id 5009000290 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256896, sees < 319252968 ---TRANSACTION 319256868, ACTIVE (PREPARED) 1675 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25368305, OS thread handle 139860680947456, query id 5008999350 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256869, sees < 319252968 ---TRANSACTION 319256812, ACTIVE (PREPARED) 1795 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25368276, OS thread handle 139860129421056, query id 5008996980 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256813, sees < 319252968 ---TRANSACTION 319256821, ACTIVE (PREPARED).511 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25368074, OS thread handle 139860165121792, query id 5008997235 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256822, sees < 319252968 ---TRANSACTION 319256801, ACTIVE (PREPARED) 1818 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25367998, OS thread handle 139860.0148416, query id 5008996488 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256802, sees < 319252968 ---TRANSACTION 319256788, ACTIVE (PREPARED) 1838 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25367981, OS thread handle 139860142073600, query id 5008996107 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256789, sees < 319252968 ---TRANSACTION 319256805, ACTIVE (PREPARED) 1809 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25367972, OS thread handle 139860131550976, query id 5008996658 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256806, sees < 319252968 ---TRANSACTION 319256778, ACTIVE (PREPARED) 1855 sec 11 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 25367929, OS thread handle 139860136343296, query id 5008995812 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256779, sees < 319252968 ---TRANSACTION 319256839, ACTIVE (PREPARED) 1745 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25367862, OS thread handle 139860160861952, query id 5008997986 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256840, sees < 319252968 ---TRANSACTION 319256722, ACTIVE (PREPARED) 1961 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25367786, OS thread handle 1398601484.060, query id 5008993763 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256723, sees < 319252968 ---TRANSACTION 319256763, ACTIVE (PREPARED) 1893 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25367781, OS thread handle 139879400310528, query id 5008995099 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256764, sees < 319252968 ---TRANSACTION 319256688, ACTIVE (PREPARED) 2017 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25367713, OS thread handle 139860135810816, query id 5008992614 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256689, sees < 319252968 ---TRANSACTION 319256845, ACTIVE (PREPARED) 1728 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25367707, OS thread handle 139878502344448, query id 5008998309 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256846, sees < 319252968 ---TRANSACTION 319256701, ACTIVE (PREPARED) 2000 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25367695, OS thread handle 139860144203520, query id 5008992979 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256702, sees < 319252968 ---TRANSACTION 319256732, ACTIVE (PREPARED) 1949 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25367691, OS thread handle 139863899916032, query id 5008994018 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256.0, sees < 319252968 ---TRANSACTION 319256695, ACTIVE (PREPARED) 2011 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25367676, OS thread handle 139860693194496, query id 5008992765 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256696, sees < 319252968 ---TRANSACTION 319256675, ACTIVE (PREPARED) 2050 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25367638, OS thread handle 139860137408256, query id 5008991521 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256676, sees < 319252968 ---TRANSACTION 319256619, ACTIVE (PREPARED) 2149 sec 12 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 4 MySQL thread id 25367610, OS thread handle 139861193856768, query id 5008987653 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256620, sees < 319252968 ---TRANSACTION 319256745, ACTIVE (PREPARED) 1924 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25367600, OS thread handle 139860142606080, query id 5008994534 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256746, sees < 319252968 ---TRANSACTION 319256638, ACTIVE (PREPARED) 2111 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25367544, OS thread handle 139860166186752, query id 5008989609 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256639, sees < 319252968 ---TRANSACTION 319256626, ACTIVE (PREPARED) 2135 sec 14 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 3 MySQL thread id 25367520, OS thread handle 139860122752768, query id 5008988353 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256627, sees < 319252968 ---TRANSACTION 319256648, ACTIVE (PREPARED) 2103 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25367516, OS thread handle 139860161394432, query id 5008990160 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256649, sees < 319252968 ---TRANSACTION 319256589, ACTIVE (PREPARED) 2206 sec 3 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 1 MySQL thread id 25367483, OS thread handle 139864542689024, query id 5008984891 192.168.0.51 c_ur_cron starting commit ---TRANSACTION 319256591, ACTIVE (PREPARED) 2203 sec 7 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 4 MySQL thread id 25367500, OS thread handle 139860145800960, query id 5008985030 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256592, sees < 319252968 ---TRANSACTION 319256578, ACTIVE (PREPARED) 2215 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 25367444, OS thread handle 139860161926912, query id 500898.04 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256579, sees < 319252968 ---TRANSACTION 319256586, ACTIVE (PREPARED) 2208 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25367373, OS thread handle 139860654450432, query id 5008984727 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256587, sees < 319252968 ---TRANSACTION 319256566, ACTIVE (PREPARED) 2248 sec 3 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 1 MySQL thread id 25367328, OS thread handle 139860165654272, query id 5008982612 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256567, sees < 319252968 ---TRANSACTION 319257714, ACTIVE 50 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 25367297, OS thread handle 139860148995840, query id 5009031127 192.168.0.51 a_mon_user Updating DELETE FROM database.c_status WHERE monitorel_from ='....... ------- TRX HAS BEEN WAITING 50 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 34 page no 6 n bits 408 index PRIMARY of table `database`.`c_status` trx id 319257714 lock_mode X waiting Record lock, heap no.06 PHYSICAL RECORD: n_fields 9; compact format; info bits 0 0: len 5; hex 0x00000000 ; asc XXXXXXXXXXX; 1: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 2: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; 3: len 3; hex 0x00000000 ; asc XXXXXXXXXXX; 4: len 6; hex 0x00000000 ; asc XXXXXXXXXXX; 5: len 7; hex 0x00000000 ; asc XXXXXXXXXXX; 6: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 7: len 1; hex 0x00000000 ; asc XXXXXXXXXXX; 8: len 4; hex 0x00000000 ; asc XXXXXXXXXXX; ------------------ ---TRANSACTION 319256569, ACTIVE (PREPARED) 2237 sec 12 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 25367294, OS thread handle 139860159796992, query id 5008983194 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256570, sees < 319252968 ---TRANSACTION 319256555, ACTIVE (PREPARED) 2262 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25367250, OS thread handle 139860159264512, query id 5008981946 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256556, sees < 319252968 ---TRANSACTION 319256612, ACTIVE (PREPARED) 2155 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25367206, OS thread handle 139860160329472, query id 5008987306 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256613, sees < 319252968 ---TRANSACTION 319256614, ACTIVE (PREPARED) 2153 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25367199, OS thread handle 139860164589312, query id 5008987401 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256615, sees < 319252968 ---TRANSACTION 319256502, ACTIVE (PREPARED) 2369 sec 12 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25367197, OS thread handle 139860677879552, query id 5008977805 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256503, sees < 319252968 ---TRANSACTION 319256646, ACTIVE (PREPARED) 2104 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25367186, OS thread handle 139860655515392, query id 5008990085 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256647, sees < 319252968 ---TRANSACTION 319256455, ACTIVE (PREPARED) 2455 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366835, OS thread handle 139860174173952, query id 5008976218 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256456, sees < 319252968 ---TRANSACTION 319256423, ACTIVE (PREPARED) 2519 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366776, OS thread handle 139860658177792, query id 5008975021 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256424, sees < 319252968 ---TRANSACTION 319256537, ACTIVE (PREPARED) 2300 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366746, OS thread handle 139860167784192, query id 5008980027 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256538, sees < 319252968 ---TRANSACTION 319256525, ACTIVE (PREPARED) 2317 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366701, OS thread handle 139860163524352, query id 5008979168 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256526, sees < 319252968 ---TRANSACTION 319256482, ACTIVE (PREPARED) 2405 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366631, OS thread handle 139861231408896, query id 5008977166 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256483, sees < 319252968 ---TRANSACTION 319256508, ACTIVE (PREPARED) 2354 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366568, OS thread handle 139860706252544, query id 5008978096 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256509, sees < 319252968 ---TRANSACTION 319256324, ACTIVE (PREPARED) 2710 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366566, OS thread handle 139861200779008, query id 5008971353 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256325, sees < 319252968 ---TRANSACTION 319256515, ACTIVE (PREPARED) .05 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366552, OS thread handle 139860707317504, query id 5008978506 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256516, sees < 319252968 ---TRANSACTION 319256412, ACTIVE (PREPARED) 2543 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366479, OS thread handle 139860167251712, query id 5008974563 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256413, sees < 319252968 ---TRANSACTION 319256295, ACTIVE (PREPARED) 2758 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366475, OS thread handle 139860668294912, query id 5008970393 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256296, sees < 319252968 ---TRANSACTION 319256358, ACTIVE (PREPARED) 2644 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366470, OS thread handle 139860659775232, query id 5008972670 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256359, sees < 319252968 ---TRANSACTION 319256322, ACTIVE (PREPARED) 2713 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366458, OS thread handle 139860168316672, query id 5008971256 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256323, sees < 319252968 ---TRANSACTION 319256263, ACTIVE (PREPARED) 2816 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366368, OS thread handle 139860168849152, query id 5008969244 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256264, sees < 319252968 ---TRANSACTION 319256350, ACTIVE (PREPARED) 2657 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366366, OS thread handle 139860172044032, query id 5008972361 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256351, sees < 319252968 ---TRANSACTION 319256260, ACTIVE (PREPARED) 2822 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366358, OS thread handle 139864671790848, query id 5008969111 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256261, sees < 319252968 ---TRANSACTION 319256288, ACTIVE (PREPARED) 2768 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 2536.05, OS thread handle 139860659242752, query id 5008970087 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256289, sees < 319252968 ---TRANSACTION 319256435, ACTIVE (PREPARED) 2497 sec 7 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 4 MySQL thread id 25366307, OS thread handle 139860667229952, query id 5008975422 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256436, sees < 319252968 ---TRANSACTION 319256236, ACTIVE (PREPARED) 2865 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366273, OS thread handle 139860653917952, query id 5008968215 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256237, sees < 319252968 ---TRANSACTION 319256294, ACTIVE (PREPARED) 2759 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366271, OS thread handle 139860670957312, query id 5008970343 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256295, sees < 319252968 ---TRANSACTION 319256265, ACTIVE (PREPARED) 2815 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366258, OS thread handle 139859578427136, query id 5008969293 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256266, sees < 319252968 ---TRANSACTION 319256226, ACTIVE (PREPARED) 2879 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 25366183, OS thread handle 139860665632512, query id 5008967920 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256227, sees < 319252968 ---TRANSACTION 319256209, ACTIVE (PREPARED) 2915 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366175, OS thread handle 139860657112832, query id 5008967199 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256210, sees < 319252968 ---TRANSACTION 31925.02, ACTIVE (PREPARED) 2694 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366173, OS thread handle 139860696135424, query id 5008971695 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 31925.03, sees < 319252968 ---TRANSACTION 319256203, ACTIVE (PREPARED) 2928 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 25366138, OS thread handle 139860696667904, query id 5008966956 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256204, sees < 319252968 ---TRANSACTION 319256195, ACTIVE (PREPARED) 2946 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366085, OS thread handle 139860662437632, query id 5008966551 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256196, sees < 319252968 ---TRANSACTION 319256177, ACTIVE (PREPARED) 2978 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366059, OS thread handle 139860694005504, query id 5008965868 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 31925.51, sees < 319252968 ---TRANSACTION 319256176, ACTIVE (PREPARED) 2982 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366039, OS thread handle 139860666164992, query id 5008965794 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256177, sees < 319252968 ---TRANSACTION 319256168, ACTIVE (PREPARED) 2996 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366026, OS thread handle 139860700395264, query id 5008965486 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256169, sees < 319252968 ---TRANSACTION 319256225, ACTIVE (PREPARED) 2879 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25366022, OS thread handle 139860662970112, query id 5008967896 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256226, sees < 319252968 ---TRANSACTION 319256248, ACTIVE (PREPARED) 2845 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25365986, OS thread handle 139860675749632, query id 5008968603 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256249, sees < 319252968 ---TRANSACTION 319256250, ACTIVE (PREPARED) 2843 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25365987, OS thread handle 139860672554752, query id 5008968665 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256251, sees < 319252968 ---TRANSACTION 319256797, ACTIVE (PREPARED) 1827 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25365960, OS thread handle 139860698797824, query id 500899.05 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256798, sees < 319252968 ---TRANSACTION 319256140, ACTIVE (PREPARED) 3046 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25365931, OS thread handle 139860674684672, query id 5008964441 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256141, sees < 319252968 ---TRANSACTION 319256172, ACTIVE (PREPARED) 2991 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25365910, OS thread handle 139860671489792, query id 5008965610 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256173, sees < 319252968 ---TRANSACTION 319256115, ACTIVE (PREPARED) 3098 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25365832, OS thread handle 139864820029184, query id 5008963475 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256116, sees < 319252968 ---TRANSACTION 319256143, ACTIVE (PREPARED) 3041 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25365737, OS thread handle 139860686804736, query id 5008964535 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256144, sees < 319252968 ---TRANSACTION 319256186, ACTIVE (PREPARED) 2963 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25365736, OS thread handle 139860697200384, query id 5008966218 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256187, sees < 319252968 ---TRANSACTION 319256088, ACTIVE (PREPARED) 3149 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25365734, OS thread handle 139859482978048, query id 5008962409 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256089, sees < 319252968 ---TRANSACTION 319256113, ACTIVE (PREPARED) 3099 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 25365724, OS thread handle 139878502876928, query id 5008963414 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256114, sees < 319252968 ---TRANSACTION 319256150, ACTIVE (PREPARED) 3029 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25365697, OS thread handle 139861217285888, query id 5008964754 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256151, sees < 319252968 ---TRANSACTION 319256078, ACTIVE (PREPARED) 3166 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25365693, OS thread handle 139860694537984, query id 5008962111 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256079, sees < 319252968 ---TRANSACTION 319256105, ACTIVE (PREPARED) 3116 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25365689, OS thread handle 139858827204352, query id 5008963103 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256106, sees < 319252968 ---TRANSACTION 319256069, ACTIVE (PREPARED) .51 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25365639, OS thread handle 139863874889472, query id 5008961778 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256070, sees < 319252968 ---TRANSACTION 319256059, ACTIVE (PREPARED) 3198 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25365637, OS thread handle 139861202908928, query id 5008961343 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256060, sees < 319252968 ---TRANSACTION 319256112, ACTIVE (PREPARED) 3105 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25365638, OS thread handle 139860709447424, query id 50089.011 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256113, sees < 319252968 ---TRANSACTION 319256132, ACTIVE (PREPARED) 3065 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25365636, OS thread handle 139860692129536, query id 5008964020 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256.0, sees < 319252968 ---TRANSACTION 319256090, ACTIVE (PREPARED) 3148 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 25365400, OS thread handle 139860684674816, query id 5008962485 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256091, sees < 319252968 ---TRANSACTION 319256010, ACTIVE (PREPARED) 3298 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25364939, OS thread handle 139864541091584, query id 5008959401 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256011, sees < 319252968 ---TRANSACTION 319256008, ACTIVE (PREPARED) 3298 sec 11 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 3 MySQL thread id 25364936, OS thread handle 139879400843008, query id 5008959417 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256009, sees < 319252968 ---TRANSACTION 319256007, ACTIVE (PREPARED) 3298 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25364938, OS thread handle 139860703590144, query id 5008959412 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256008, sees < 319252968 ---TRANSACTION 319256006, ACTIVE (PREPARED) 3298 sec 11 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 25364937, OS thread handle 139861218350848, query id 5008959411 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256007, sees < 319252968 ---TRANSACTION 319256018, ACTIVE (PREPARED) 3283 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25365409, OS thread handle 139860678412032, query id 5008959682 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256019, sees < 319252968 ---TRANSACTION 319256031, ACTIVE (PREPARED) 3251 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25365408, OS thread handle 139860685739776, query id 5008960226 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256032, sees < 319252968 ---TRANSACTION 319256036, ACTIVE (PREPARED) 3248 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25365401, OS thread handle 139860682012416, query id 5008960359 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256037, sees < 319252968 ---TRANSACTION 319256032, ACTIVE (PREPARED) 3249 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25365402, OS thread handle 139860690532096, query id 5008960273 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256.0, sees < 319252968 ---TRANSACTION 319256066, ACTIVE (PREPARED) 3185 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25365405, OS thread handle 139860676282112, query id 5008961639 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256067, sees < 319252968 ---TRANSACTION 319256101, ACTIVE (PREPARED) 3128 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25365404, OS thread handle 139860677347072, query id 5008962842 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256102, sees < 319252968 ---TRANSACTION 319256035, ACTIVE (PREPARED) 3248 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25365406, OS thread handle 139859454478080, query id 5008960360 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256036, sees < 319252968 ---TRANSACTION 319256053, ACTIVE (PREPARED) 3213 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25365403, OS thread handle 139860697732864, query id 5008961019 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256054, sees < 319252968 ---TRANSACTION 319256038, ACTIVE (PREPARED) 3248 sec 11 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 25365407, OS thread handle 13986068414.06, query id 5008960384 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256039, sees < 319252968 ---TRANSACTION 319255518, ACTIVE (PREPARED) 4548 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25363013, OS thread handle 139861192791808, query id 5008937997 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255519, sees < 319252968 ---TRANSACTION 319255507, ACTIVE (PREPARED) 4574 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 25362889, OS thread handle 139860703057664, query id 5008937454 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255508, sees < 319252968 ---TRANSACTION 319255762, ACTIVE (PREPARED) 3941 sec 12 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 25362882, OS thread handle 139860701992704, query id 5008948280 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255763, sees < 319252968 ---TRANSACTION 319255517, ACTIVE (PREPARED) 4549 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25362767, OS thread handle 139861201843968, query id 5008937959 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255518, sees < 319252968 ---TRANSACTION 319255493, ACTIVE (PREPARED) 4602 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25362765, OS thread handle 139861186934528, query id 5008936963 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255494, sees < 319252968 ---TRANSACTION 319255544, ACTIVE (PREPARED) 4494 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25362707, OS thread handle 139860708382464, query id 5008938992 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255545, sees < 319252968 ---TRANSACTION 319255453, ACTIVE (PREPARED) 4685 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25362595, OS thread handle 13986122.08048, query id 5008935451 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255454, sees < 319252968 ---TRANSACTION 319255398, ACTIVE (PREPARED) 4805 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25362582, OS thread handle 139861232473856, query id 5008.0210 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255399, sees < 319252968 ---TRANSACTION 319255568, ACTIVE (PREPARED) 4.0 sec 3 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 1 MySQL thread id 25362554, OS thread handle 139863865837312, query id 5008940011 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255569, sees < 319252968 ---TRANSACTION 319255389, ACTIVE (PREPARED) 4823 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25362539, OS thread handle 139861188531968, query id 5008932790 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255390, sees < 319252968 ---TRANSACTION 319255371, ACTIVE (PREPARED) 4855 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25362493, OS thread handle 139861182674688, query id 5008932220 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255372, sees < 319252968 ---TRANSACTION 319255367, ACTIVE (PREPARED) 4860 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25362478, OS thread handle 139861243123456, query id 5008932097 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255368, sees < 319252968 ---TRANSACTION 319255397, ACTIVE (PREPARED) 4807 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25362451, OS thread handle 139864557217536, query id 5008.0107 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255398, sees < 319252968 ---TRANSACTION 319255425, ACTIVE (PREPARED) 4740 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25362415, OS thread handle 139861222610688, query id 5008934398 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255426, sees < 319252968 ---TRANSACTION 319255469, ACTIVE (PREPARED) 4654 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25362403, OS thread handle 139859491497728, query id 5008936025 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255470, sees < 319252968 ---TRANSACTION 319255306, ACTIVE (PREPARED) 4989 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25362207, OS thread handle 139861190661888, query id 5008929693 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255307, sees < 319252968 ---TRANSACTION 319255347, ACTIVE (PREPARED) 4902 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25362195, OS thread handle 139861191726848, query id 5008931276 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255348, sees < 319252968 ---TRANSACTION 31925.00, ACTIVE (PREPARED) 4939 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25362173, OS thread handle 139861207701248, query id 5008930590 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 31925.01, sees < 319252968 ---TRANSACTION 319255286, ACTIVE (PREPARED) 5.0 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25362160, OS thread handle 139861231941376, query id 5008928883 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255287, sees < 319252968 ---TRANSACTION 319255281, ACTIVE (PREPARED) 5039 sec 7 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 3 MySQL thread id 25362145, OS thread handle 139863873824512, query id 5008928749 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255282, sees < 319252968 ---TRANSACTION 319255268, ACTIVE (PREPARED) 5065 sec 12 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 25362081, OS thread handle 139861219415808, query id 5008928249 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255269, sees < 319252968 ---TRANSACTION 319255247, ACTIVE (PREPARED) 5106 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25362020, OS thread handle 139861215155968, query id 5008927444 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255248, sees < 319252968 ---TRANSACTION 319255362, ACTIVE (PREPARED) 4873 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 25362019, OS thread handle 139861204506368, query id 5008931806 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255363, sees < 319252968 ---TRANSACTION 319255356, ACTIVE (PREPARED) 4889 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25361975, OS thread handle 139861198649088, query id 5008931526 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255357, sees < 319252968 ---TRANSACTION 319255234, ACTIVE (PREPARED) 5132 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25361966, OS thread handle 139861201311488, query id 5008926947 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255235, sees < 319252968 ---TRANSACTION 319255228, ACTIVE (PREPARED) 5140 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25361953, OS thread handle 1398612188.028, query id 5008926782 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255229, sees < 319252968 ---TRANSACTION 319255227, ACTIVE (PREPARED) 5140 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25361952, OS thread handle 139861205571328, query id 5008926761 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255228, sees < 319252968 ---TRANSACTION 319255280, ACTIVE (PREPARED) 5040 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25361945, OS thread handle 139858807097088, query id 5008928725 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255281, sees < 319252968 ---TRANSACTION 319255257, ACTIVE (PREPARED) 5090 sec 6 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 3 MySQL thread id 25361908, OS thread handle 139861211428608, query id 5008927797 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255258, sees < 319252968 ---TRANSACTION 319255203, ACTIVE (PREPARED) 5190 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25361863, OS thread handle 139863905240832, query id 5008925811 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255204, sees < 319252968 ---TRANSACTION 319255202, ACTIVE (PREPARED) 5190 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25361860, OS thread handle 139861207168768, query id 5008925776 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255203, sees < 319252968 ---TRANSACTION 319255201, ACTIVE (PREPARED) 5191 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25361858, OS thread handle 139861208.0728, query id 5008925741 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255202, sees < 319252968 ---TRANSACTION 319255256, ACTIVE (PREPARED) 5090 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25361850, OS thread handle 139861209831168, query id 5008927781 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255257, sees < 319252968 ---TRANSACTION 319255192, ACTIVE (PREPARED) 5205 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25361827, OS thread handle 13985936.05104, query id 5008925468 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255193, sees < 319252968 ---TRANSACTION 319255291, ACTIVE (PREPARED) 5020 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25361816, OS thread handle 139861213026048, query id 5008929099 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255292, sees < 319252968 ---TRANSACTION 319255174, ACTIVE (PREPARED) 5240 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25361762, OS thread handle 139861216220928, query id 5008924737 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255175, sees < 319252968 ---TRANSACTION 319255173, ACTIVE (PREPARED) 5240 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25361718, OS thread handle 139861216753408, query id 5008924708 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255174, sees < 319252968 ---TRANSACTION 319255189, ACTIVE (PREPARED) 5207 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25361711, OS thread handle 139863871694592, query id 5008925400 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255190, sees < 319252968 ---TRANSACTION 319255146, ACTIVE (PREPARED) 5287 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25361670, OS thread handle 139861.5118368, query id 5008923756 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255147, sees < 319252968 ---TRANSACTION 319255144, ACTIVE (PREPARED) 5290 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25361667, OS thread handle 139861246850816, query id 5008923684 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255145, sees < 319252968 ---TRANSACTION 319255212, ACTIVE (PREPARED) 5165 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25361641, OS thread handle 139861235136256, query id 5008926260 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255213, sees < 319252968 ---TRANSACTION 319255168, ACTIVE (PREPARED) 5246 sec 12 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 25361637, OS thread handle 139861221013248, query id 5008924608 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255169, sees < 319252968 ---TRANSACTION 319255197, ACTIVE (PREPARED) 5196 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25361632, OS thread handle 139861223675648, query id 5008925638 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255198, sees < 319252968 ---TRANSACTION 319255.0, ACTIVE (PREPARED) 5307 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25361621, OS thread handle 139863866902272, query id 50089.019 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255134, sees < 319252968 ---TRANSACTION 319255162, ACTIVE (PREPARED) 5257 sec 12 lock struct(s), heap size 1128, 9 row lock(s), undo log entries 2 MySQL thread id 25361620, OS thread handle 139861237266176, query id 5008924362 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255163, sees < 319252968 ---TRANSACTION 319255185, ACTIVE (PREPARED) 5218 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25361577, OS thread handle 139861.000.06, query id 5008925189 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255186, sees < 319252968 ---TRANSACTION 319255118, ACTIVE (PREPARED) 5341 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25361571, OS thread handle 139861241526016, query id 5008922729 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255119, sees < 319252968 ---TRANSACTION 319255110, ACTIVE (PREPARED) 5355 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25361514, OS thread handle 139861228467968, query id 5008922401 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255111, sees < 319252968 ---TRANSACTION 319255103, ACTIVE (PREPARED) 5373 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25361495, OS thread handle 139861244720896, query id 5008922053 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255104, sees < 319252968 ---TRANSACTION 319255094, ACTIVE (PREPARED) 5391 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25361473, OS thread handle 139858809759488, query id 5008921728 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255095, sees < 319252968 ---TRANSACTION 319255143, ACTIVE (PREPARED) 5291 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25361462, OS thread handle 139863866369792, query id 5008923659 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255144, sees < 319252968 ---TRANSACTION 319255431, ACTIVE (PREPARED) 4735 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25361438, OS thread handle 139863930672896, query id 5008934536 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255432, sees < 319252968 ---TRANSACTION 319255079, ACTIVE (PREPARED) 5419 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25361417, OS thread handle 139861234603776, query id 5008921123 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255080, sees < 319252968 ---TRANSACTION 319255077, ACTIVE (PREPARED) 5423 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25361390, OS thread handle 139861237798656, query id 5008921034 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255078, sees < 319252968 ---TRANSACTION 319255066, ACTIVE (PREPARED) 5441 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25361372, OS thread handle 13985932.04144, query id 5008920680 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255067, sees < 319252968 ---TRANSACTION 319255117, ACTIVE (PREPARED) 5341 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25361364, OS thread handle 13986123.01136, query id 5008922706 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255118, sees < 319252968 ---TRANSACTION 319255060, ACTIVE (PREPARED) 5446 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25361360, OS thread handle 139863918425856, query id 5008920552 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255061, sees < 319252968 ---TRANSACTION 319255057, ACTIVE (PREPARED) 5449 sec 11 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 25361348, OS thread handle 139859319879424, query id 5008920472 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255058, sees < 319252968 ---TRANSACTION 319255056, ACTIVE (PREPARED) 5455 sec 12 lock struct(s), heap size 1128, 9 row lock(s), undo log entries 2 MySQL thread id 25361275, OS thread handle 139861238863616, query id 5008920359 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255057, sees < 319252968 ---TRANSACTION 319255041, ACTIVE (PREPARED) 5491 sec 8 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 3 MySQL thread id 25361274, OS thread handle 139861239396096, query id 5008919499 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255042, sees < 319252968 ---TRANSACTION 319255040, ACTIVE (PREPARED) 5491 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25361272, OS thread handle 139861240461056, query id 5008919478 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255041, sees < 319252968 ---TRANSACTION 319255039, ACTIVE (PREPARED) 5492 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 4 MySQL thread id 25361271, OS thread handle 139861240993536, query id 5008919426 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255040, sees < 319252968 ---TRANSACTION 319255067, ACTIVE (PREPARED) 5441 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25361266, OS thread handle 139861244188416, query id 5008920697 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255068, sees < 319252968 ---TRANSACTION 319255035, ACTIVE (PREPARED) 5497 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25361260, OS thread handle 139861247915776, query id 5008919197 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255036, sees < 319252968 ---TRANSACTION 319255093, ACTIVE (PREPARED) 5391 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25361242, OS thread handle 139863869564672, query id 5008921713 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255094, sees < 319252968 ---TRANSACTION 319255029, ACTIVE (PREPARED) 5506 sec 11 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 25361166, OS thread handle 139863885006592, query id 5008918728 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255030, sees < 319252968 ---TRANSACTION 319255012, ACTIVE (PREPARED) 5541 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25361162, OS thread handle 139863868499712, query id 5008917086 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255013, sees < 319252968 ---TRANSACTION 319255031, ACTIVE (PREPARED) 5503 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25361116, OS thread handle 139863881279232, query id 5008918879 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255032, sees < 319252968 ---TRANSACTION 319255024, ACTIVE (PREPARED) 5517 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25361085, OS thread handle 139863909500672, query id 5008918142 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255025, sees < 319252968 ---TRANSACTION 319255048, ACTIVE (PREPARED) 5473 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25361060, OS thread handle 139863892461312, query id 5008919993 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255049, sees < 319252968 ---TRANSACTION 319254983, ACTIVE (PREPARED) 5592 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25361037, OS thread handle 139863871162112, query id 5008914768 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254984, sees < 319252968 ---TRANSACTION 319254978, ACTIVE (PREPARED) 5604 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25360996, OS thread handle 139863892993792, query id 5008914195 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254979, sees < 319252968 ---TRANSACTION 319255025, ACTIVE (PREPARED) 5510 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25360966, OS thread handle 139864562009856, query id 5008918450 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255026, sees < 319252968 ---TRANSACTION 319254960, ACTIVE (PREPARED) 5642 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360922, OS thread handle 139863917360896, query id 5008912508 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254961, sees < 319252968 ---TRANSACTION 319254984, ACTIVE (PREPARED) 5592 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360841, OS thread handle 139859444209408, query id 5008914790 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254985, sees < 319252968 ---TRANSACTION 319254964, ACTIVE (PREPARED) 5630 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25360840, OS thread handle 139859583751936, query id 5008913144 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254965, sees < 319252968 ---TRANSACTION 319254940, ACTIVE (PREPARED) 5685 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25360824, OS thread handle 139863894058752, query id 5008910952 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254941, sees < 319252968 ---TRANSACTION 319255011, ACTIVE (PREPARED) 5541 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360753, OS thread handle 139863888201472, query id 5008917063 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255012, sees < 319252968 ---TRANSACTION 319254935, ACTIVE (PREPARED) 5692 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360739, OS thread handle 139863879681792, query id 5008910724 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254936, sees < 319252968 ---TRANSACTION 319255007, ACTIVE (PREPARED) 5547 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25360725, OS thread handle 139863885539072, query id 5008916849 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319255008, sees < 319252968 ---TRANSACTION 319254908, ACTIVE (PREPARED) 5742 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360722, OS thread handle 139863882876672, query id 5008908893 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254909, sees < 319252968 ---TRANSACTION 319254906, ACTIVE (PREPARED) 5743 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360670, OS thread handle 139864540026624, query id 5008908829 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254907, sees < 319252968 ---TRANSACTION 319254925, ACTIVE (PREPARED) 5709 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25360669, OS thread handle 139863886604032, query id 5008910091 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254926, sees < 319252968 ---TRANSACTION 319254959, ACTIVE (PREPARED) 5642 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360632, OS thread handle 139859630913280, query id 5008912493 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254960, sees < 319252968 ---TRANSACTION 319254885, ACTIVE (PREPARED) 5792 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360630, OS thread handle 139863883409152, query id 5008907221 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254886, sees < 319252968 ---TRANSACTION 319254884, ACTIVE (PREPARED) 5792 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360628, OS thread handle 139863884474112, query id 5008907207 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254885, sees < 319252968 ---TRANSACTION 319254934, ACTIVE (PREPARED) 5692 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360551, OS thread handle 139863887136512, query id 5008910704 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254935, sees < 319252968 ---TRANSACTION 319254907, ACTIVE (PREPARED) 5742 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360544, OS thread handle 139860711044864, query id 5008908869 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254908, sees < 319252968 ---TRANSACTION 319254865, ACTIVE (PREPARED) 5836 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25360532, OS thread handle 139864822691584, query id 5008905681 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254866, sees < 319252968 ---TRANSACTION 319254864, ACTIVE (PREPARED) 5839 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25360520, OS thread handle 139859626120960, query id 5008905525 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254865, sees < 319252968 ---TRANSACTION 319254860, ACTIVE (PREPARED) 5843 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360323, OS thread handle 1398793.088288, query id 5008905369 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254861, sees < 319252968 ---TRANSACTION 319254857, ACTIVE (PREPARED) 5844 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360404, OS thread handle 139863891928832, query id 5008905288 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254858, sees < 319252968 ---TRANSACTION 319254859, ACTIVE (PREPARED) 5843 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360341, OS thread handle 139863908968192, query id 5008905349 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254860, sees < 319252968 ---TRANSACTION 319254856, ACTIVE (PREPARED) 5849 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 25360397, OS thread handle 139863893526272, query id 5008905073 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254857, sees < 319252968 ---TRANSACTION 319254835, ACTIVE (PREPARED) 5882 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360396, OS thread handle 139863913228032, query id 5008903977 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254838, sees < 319252968 ---TRANSACTION 319254838, ACTIVE (PREPARED) 5882 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25360363, OS thread handle 139863907903232, query id 5008903983 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254839, sees < 319252968 ---TRANSACTION 319254909, ACTIVE (PREPARED) 5741 sec 8 lock struct(s), heap size 1128, 5 row lock(s), undo log entries 4 MySQL thread id 25360353, OS thread handle 139860704655104, query id 5008908946 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254910, sees < 319252968 ---TRANSACTION 319254852, ACTIVE (PREPARED) 5851 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360398, OS thread handle 139860140070656, query id 5008904964 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254853, sees < 319252968 ---TRANSACTION 319254837, ACTIVE (PREPARED) 5882 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360412, OS thread handle 139863889266432, query id 5008903973 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254838, sees < 319252968 ---TRANSACTION 319254836, ACTIVE (PREPARED) 5882 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360411, OS thread handle 139864576792320, query id 5008903972 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254838, sees < 319252968 ---TRANSACTION 319254820, ACTIVE (PREPARED) 5923 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360296, OS thread handle 139863908435712, query id 5008902749 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254822, sees < 319252968 ---TRANSACTION 319254819, ACTIVE (PREPARED) 5923 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360295, OS thread handle 139859582686976, query id 5008902743 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254820, sees < 319252968 ---TRANSACTION 319254821, ACTIVE (PREPARED) 5923 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360292, OS thread handle 139863896188672, query id 5008902748 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254822, sees < 319252968 ---TRANSACTION 319254818, ACTIVE (PREPARED) 5923 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360291, OS thread handle 139863902045952, query id 5008902744 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254820, sees < 319252968 ---TRANSACTION 421353837870384, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837758688, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 319256009, ACTIVE (PREPARED) 3298 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25360294, OS thread handle 139863895123712, query id 5008959409 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256010, sees < 319252968 ---TRANSACTION 421353837655584, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 319256011, ACTIVE (PREPARED) 3298 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25360251, OS thread handle 139864539494144, query id 5008959418 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319256012, sees < 319252968 ---TRANSACTION 319254806, ACTIVE (PREPARED) 5956 sec 14 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 3 MySQL thread id 25360242, OS thread handle 139878498084608, query id 5008901863 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254807, sees < 319252968 ---TRANSACTION 319254802, ACTIVE (PREPARED) 5961 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360240, OS thread handle 139860.0680896, query id 5008901747 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254803, sees < 319252968 ---TRANSACTION 319254800, ACTIVE (PREPARED) 5961 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360237, OS thread handle 139859612808960, query id 5008901711 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254801, sees < 319252968 ---TRANSACTION 319254799, ACTIVE (PREPARED) 5961 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360235, OS thread handle 139864545097472, query id 5008901681 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254800, sees < 319252968 ---TRANSACTION 319254798, ACTIVE (PREPARED) 5962 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25360234, OS thread handle 139864825353984, query id 5008901657 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319254799, sees < 319252968 ---TRANSACTION 421353837522408, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837509520, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 319253809, ACTIVE (PREPARED) 8618 sec 12 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25355137, OS thread handle 139863927478016, query id 5008856997 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253810, sees < 319252968 ---TRANSACTION 319253828, ACTIVE (PREPARED) 8574 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25355134, OS thread handle 139863925348096, query id 5008857778 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253829, sees < 319252968 ---TRANSACTION 319253869, ACTIVE (PREPARED) 8474 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25355068, OS thread handle 139864555620096, query id 5008859500 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253870, sees < 319252968 ---TRANSACTION 319253785, ACTIVE (PREPARED) 8664 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25355048, OS thread handle 139864681248512, query id 5008856056 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253786, sees < 319252968 ---TRANSACTION 319253799, ACTIVE (PREPARED) 8628 sec 14 lock struct(s), heap size 1128, 9 row lock(s), undo log entries 2 MySQL thread id 25355020, OS thread handle 139858815616768, query id 5008856739 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253800, sees < 319252968 ---TRANSACTION 319253818, ACTIVE (PREPARED) 8599 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25354987, OS thread handle 139864563074816, query id 5008857310 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253819, sees < 319252968 ---TRANSACTION 319253800, ACTIVE (PREPARED) 8628 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25354979, OS thread handle 139863923218176, query id 5008856764 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253801, sees < 319252968 ---TRANSACTION 319253808, ACTIVE (PREPARED) 8621 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25354926, OS thread handle 139864573597440, query id 5008856938 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253809, sees < 319252968 ---TRANSACTION 319253781, ACTIVE (PREPARED) 8674 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 25354897, OS thread handle 139864546694912, query id 5008855870 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253782, sees < 319252968 ---TRANSACTION 319253792, ACTIVE (PREPARED) 8647 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25354889, OS thread handle 139864683910912, query id 5008856373 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253793, sees < 319252968 ---TRANSACTION 421353838794024, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 319253756, ACTIVE (PREPARED) 8714 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25354863, OS thread handle 139854124259072, query id 5008854998 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253757, sees < 319252968 ---TRANSACTION 319253771, ACTIVE (PREPARED) 8691 sec 15 lock struct(s), heap size 1128, 9 row lock(s), undo log entries 4 MySQL thread id 25354862, OS thread handle 139864682313472, query id 5008855542 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253772, sees < 319252968 ---TRANSACTION 319253712, ACTIVE (PREPARED) 8792 sec 15 lock struct(s), heap size 1128, 9 row lock(s), undo log entries 4 MySQL thread id 25354813, OS thread handle 139864541624064, query id 5008853432 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253713, sees < 319252968 ---TRANSACTION 319253722, ACTIVE (PREPARED) 8767 sec 7 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 4 MySQL thread id 25354807, OS thread handle 139864812168960, query id 5008853878 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253723, sees < 319252968 ---TRANSACTION 319253770, ACTIVE (PREPARED) 8693 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25354800, OS thread handle 139864812701440, query id 5008855489 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253771, sees < 319252968 ---TRANSACTION 319253767, ACTIVE (PREPARED) 8697 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25354782, OS thread handle 139864559879936, query id 5008855393 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253768, sees < 319252968 ---TRANSACTION 319253698, ACTIVE (PREPARED) 8815 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25354735, OS thread handle 139864572000000, query id 5008852951 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253699, sees < 319252968 ---TRANSACTION 319253682, ACTIVE (PREPARED) 8845 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25354707, OS thread handle 139864545629952, query id 5008852307 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253683, sees < 319252968 ---TRANSACTION 319253677, ACTIVE (PREPARED) 8848 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25354701, OS thread handle 139864553490176, query id 5008852199 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253678, sees < 319252968 ---TRANSACTION 319253708, ACTIVE (PREPARED) 8798 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25354690, OS thread handle 139864549889792, query id 5008853268 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253709, sees < 319252968 ---TRANSACTION 319253734, ACTIVE (PREPARED) 8747 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25354676, OS thread handle 139859438352128, query id 5008854345 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253735, sees < 319252968 ---TRANSACTION 319253669, ACTIVE (PREPARED) 8865 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25354660, OS thread handle 139864556152576, query id 5008851823 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253670, sees < 319252968 ---TRANSACTION 421353838746768, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 319253727, ACTIVE (PREPARED) 8765 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25354607, OS thread handle 139861224740608, query id 5008854005 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253728, sees < 319252968 ---TRANSACTION 319253714, ACTIVE (PREPARED) 8789 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25354605, OS thread handle 139858811889408, query id 5008853486 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253715, sees < 319252968 ---TRANSACTION 319253879, ACTIVE (PREPARED) 8450 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25354603, OS thread handle 139864564139776, query id 5008859976 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253880, sees < 319252968 ---TRANSACTION 319253648, ACTIVE (PREPARED) 8898 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25354596, OS thread handle 139864558814976, query id 5008851053 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253649, sees < 319252968 ---TRANSACTION 319253741, ACTIVE (PREPARED) 8741 sec 15 lock struct(s), heap size 1128, 9 row lock(s), undo log entries 4 MySQL thread id 25354584, OS thread handle 139864677521152, query id 5008854496 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253742, sees < 319252968 ---TRANSACTION 319253644, ACTIVE (PREPARED) 8905 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25354569, OS thread handle 139864560412416, query id 5008850913 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253645, sees < 319252968 ---TRANSACTION 319253639, ACTIVE (PREPARED) 8913 sec 11 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 3 MySQL thread id 25354562, OS thread handle 139859363010304, query id 5008850716 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253640, sees < 319252968 ---TRANSACTION 319253662, ACTIVE (PREPARED) 8873 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 25354534, OS thread handle 139864570402560, query id 5008851646 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253663, sees < 319252968 ---TRANSACTION 319253627, ACTIVE (PREPARED) 8935 sec 11 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 25354520, OS thread handle 139864566802176, query id 5008850271 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253628, sees < 319252968 ---TRANSACTION 319253689, ACTIVE (PREPARED) 8831 sec 10 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 2 MySQL thread id 25354511, OS thread handle 139878501811968, query id 5008852589 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253690, sees < 319252968 ---TRANSACTION 319253658, ACTIVE (PREPARED) 8882 sec 10 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 2 MySQL thread id 25354494, OS thread handle 139864814831360, query id 5008851461 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253659, sees < 319252968 ---TRANSACTION 319253660, ACTIVE (PREPARED) 8878 sec 3 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 1 MySQL thread id 25354492, OS thread handle 139864813.0920, query id 5008851.0 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253661, sees < 319252968 ---TRANSACTION 319253616, ACTIVE (PREPARED) 8948 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25354480, OS thread handle 139864824821504, query id 5008849880 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253617, sees < 319252968 ---TRANSACTION 319253615, ACTIVE (PREPARED) 8949 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25354471, OS thread handle 13986389.01392, query id 5008849847 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253616, sees < 319252968 ---TRANSACTION 319253614, ACTIVE (PREPARED) 8955 sec 10 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 2 MySQL thread id 25354454, OS thread handle 139864813766400, query id 5008849736 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253615, sees < 319252968 ---TRANSACTION 319253610, ACTIVE (PREPARED) 8965 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25354426, OS thread handle 139864815363840, query id 5008849457 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253611, sees < 319252968 ---TRANSACTION 319253604, ACTIVE (PREPARED) 8977 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25354389, OS thread handle 1398646.078432, query id 5008849184 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253605, sees < 319252968 ---TRANSACTION 319253594, ACTIVE (PREPARED) 8995 sec 11 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 25354384, OS thread handle 139864679118592, query id 5008848766 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253595, sees < 319252968 ---TRANSACTION 319253593, ACTIVE (PREPARED) 8998 sec 13 lock struct(s), heap size 1128, 9 row lock(s), undo log entries 2 MySQL thread id 25354380, OS thread handle 139860660840192, query id 5008848668 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253594, sees < 319252968 ---TRANSACTION 421353838682328, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 319253592, ACTIVE (PREPARED) 8998 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25354343, OS thread handle 139860661372672, query id 5008848614 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253593, sees < 319252968 ---TRANSACTION 319253583, ACTIVE (PREPARED) 9014 sec 12 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 3 MySQL thread id 25354341, OS thread handle 139878497019648, query id 5008848062 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253584, sees < 319252968 ---TRANSACTION 319253582, ACTIVE (PREPARED) 9016 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25354282, OS thread handle 139864819496704, query id 5008847985 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253583, sees < 319252968 ---TRANSACTION 319253628, ACTIVE (PREPARED) 8932 sec 10 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 2 MySQL thread id 25354272, OS thread handle 139879396583168, query id 5008850318 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253629, sees < 319252968 ---TRANSACTION 319253561, ACTIVE (PREPARED) 9052 sec 11 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 25354264, OS thread handle 139859322541824, query id 5008846531 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253562, sees < 319252968 ---TRANSACTION 319253560, ACTIVE (PREPARED) 9054 sec 12 lock struct(s), heap size 1128, 9 row lock(s), undo log entries 2 MySQL thread id 25354263, OS thread handle 139859443676928, query id 5008846452 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253561, sees < 319252968 ---TRANSACTION 319253559, ACTIVE (PREPARED) 9054 sec 11 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 25354193, OS thread handle 139864814298880, query id 5008846424 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253560, sees < 319252968 ---TRANSACTION 319253637, ACTIVE (PREPARED) 8915 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25354169, OS thread handle 139864543221504, query id 5008850667 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253638, sees < 319252968 ---TRANSACTION 319253532, ACTIVE (PREPARED) 9111 sec 11 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 25354156, OS thread handle 139864815896320, query id 5008844298 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253.0, sees < 319252968 ---TRANSACTION 319253562, ACTIVE (PREPARED) 9048 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 25354150, OS thread handle 139864817493760, query id 5008846662 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253563, sees < 319252968 ---TRANSACTION 319253530, ACTIVE (PREPARED) 9115 sec 11 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 25354148, OS thread handle 139864818964224, query id 5008844108 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253531, sees < 319252968 ---TRANSACTION 421353838622184, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 319253554, ACTIVE (PREPARED) 9066 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25354088, OS thread handle 139859329996544, query id 5008845917 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253555, sees < 319252968 ---TRANSACTION 319253543, ACTIVE (PREPARED) 9087 sec 14 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 3 MySQL thread id 25354083, OS thread handle 139861214091008, query id 5008845125 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253544, sees < 319252968 ---TRANSACTION 319253556, ACTIVE (PREPARED) 9064 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25354066, OS thread handle 139864823224064, query id 5008846058 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253557, sees < 319252968 ---TRANSACTION 319253611, ACTIVE (PREPARED) 8964 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25354059, OS thread handle 139859480848128, query id 5008849516 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253612, sees < 319252968 ---TRANSACTION 319253508, ACTIVE (PREPARED) 9151 sec 12 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 3 MySQL thread id 25354038, OS thread handle 139859306923776, query id 5008842761 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253509, sees < 319252968 ---TRANSACTION 319253531, ACTIVE (PREPARED) 9114 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25354020, OS thread handle 139864823756544, query id 5008844168 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253532, sees < 319252968 ---TRANSACTION 319253494, ACTIVE (PREPARED) 9175 sec 11 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 25354018, OS thread handle 139864824289024, query id 5008841817 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253495, sees < 319252968 ---TRANSACTION 319253492, ACTIVE (PREPARED) .51 sec 12 lock struct(s), heap size 1128, 9 row lock(s), undo log entries 2 MySQL thread id 25354010, OS thread handle 139864575727360, query id 5008841644 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253493, sees < 319252968 ---TRANSACTION 319253493, ACTIVE (PREPARED) 9176 sec 11 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 25353995, OS thread handle 139879397648128, query id 5008841.0 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253494, sees < 319252968 ---TRANSACTION 319253523, ACTIVE (PREPARED) 9126 sec 12 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 3 MySQL thread id 25353945, OS thread handle 139864826951424, query id 5008843663 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253524, sees < 319252968 ---TRANSACTION 319253529, ACTIVE (PREPARED) 9116 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25353938, OS thread handle 139864825886464, query id 5008844056 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253530, sees < 319252968 ---TRANSACTION 319253475, ACTIVE (PREPARED) 9215 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25353934, OS thread handle 139864828016384, query id 5008840142 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253476, sees < 319252968 ---TRANSACTION 319253503, ACTIVE (PREPARED) 9164 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25353.0, OS thread handle 139878496487168, query id 5008842288 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253504, sees < 319252968 ---TRANSACTION 319253472, ACTIVE (PREPARED) 9216 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25353925, OS thread handle 139860124628736, query id 5008840.0 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253473, sees < 319252968 ---TRANSACTION 319253471, ACTIVE (PREPARED) 9219 sec 11 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 25353921, OS thread handle 139860670424832, query id 5008839885 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253472, sees < 319252968 ---TRANSACTION 319253470, ACTIVE (PREPARED) 9222 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25353915, OS thread handle 139859629315840, query id 5008839763 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253471, sees < 319252968 ---TRANSACTION 319253468, ACTIVE (PREPARED) 9224 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 25353891, OS thread handle 139878503409408, query id 5008839683 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253469, sees < 319252968 ---TRANSACTION 319253460, ACTIVE (PREPARED) 9235 sec 12 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 3 MySQL thread id 25353883, OS thread handle 139858822539008, query id 5008839263 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253461, sees < 319252968 ---TRANSACTION 319253459, ACTIVE (PREPARED) 9239 sec 12 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 3 MySQL thread id 25353827, OS thread handle 139854115206912, query id 5008839077 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253460, sees < 319252968 ---TRANSACTION 319253449, ACTIVE (PREPARED) 9265 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25353821, OS thread handle 139858820409088, query id 5008838187 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253450, sees < 319252968 ---TRANSACTION 319253446, ACTIVE (PREPARED) 9266 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25353809, OS thread handle 139861183207168, query id 5008838105 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253447, sees < 319252968 ---TRANSACTION 319253442, ACTIVE (PREPARED) 9272 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25353808, OS thread handle 13985.05321344, query id 5008837916 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253443, sees < 319252968 ---TRANSACTION 319253499, ACTIVE (PREPARED) 9166 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25353731, OS thread handle 139863903110912, query id 5008842191 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253500, sees < 319252968 ---TRANSACTION 319253421, ACTIVE (PREPARED) 9314 sec 11 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 25353723, OS thread handle 139860130486016, query id 5008836547 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253422, sees < 319252968 ---TRANSACTION 319253483, ACTIVE (PREPARED) 9188 sec 5 lock struct(s), heap size 1128, 3 row lock(s), undo log entries 2 MySQL thread id 25353722, OS thread handle 139859.0575680, query id 5008841152 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253484, sees < 319252968 ---TRANSACTION 319253420, ACTIVE (PREPARED) 9315 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25353719, OS thread handle 139859477374720, query id 5008836496 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253421, sees < 319252968 ---TRANSACTION 319253418, ACTIVE (PREPARED) 9322 sec 11 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 25353694, OS thread handle 139864821094144, query id 5008836251 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253419, sees < 319252968 ---TRANSACTION 319253419, ACTIVE (PREPARED) 9317 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25353682, OS thread handle 139864822159104, query id 5008836424 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253420, sees < 319252968 ---TRANSACTION 319253409, ACTIVE (PREPARED) .04 sec 12 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 3 MySQL thread id 25353678, OS thread handle 139864561477376, query id 5008835864 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253410, sees < 319252968 ---TRANSACTION 319253441, ACTIVE (PREPARED) 9273 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 25353635, OS thread handle 139863931737856, query id 5008837870 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253442, sees < 319252968 ---TRANSACTION 3192.096, ACTIVE (PREPARED) 9361 sec 11 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 25353622, OS thread handle 139863914292992, query id 5008835107 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 3192.097, sees < 319252968 ---TRANSACTION 3192.095, ACTIVE (PREPARED) 9365 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25353609, OS thread handle 139861234071296, query id 5008834944 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 3192.096, sees < 319252968 ---TRANSACTION 3192.090, ACTIVE (PREPARED) 9367 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25353587, OS thread handle 139859320411904, query id 5008834817 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 3192.091, sees < 319252968 ---TRANSACTION 3192.086, ACTIVE (PREPARED) 9379 sec 14 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 3 MySQL thread id 25353541, OS thread handle 139859618666240, query id 5008834488 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 3192.087, sees < 319252968 ---TRANSACTION 3192.069, ACTIVE (PREPARED) 9415 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25353520, OS thread handle 139859497760512, query id 5008.0373 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 3192.070, sees < 319252968 ---TRANSACTION 3192.077, ACTIVE (PREPARED) 9405 sec 11 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 25353516, OS thread handle 139860669892352, query id 5008.0740 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 3192.078, sees < 319252968 ---TRANSACTION 3192.068, ACTIVE (PREPARED) 9417 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25353481, OS thread handle 139859325736704, query id 5008.0300 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 3192.069, sees < 319252968 ---TRANSACTION 3192.060, ACTIVE (PREPARED) 9.0 sec 11 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 25353450, OS thread handle 139879397115648, query id 5008832704 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 3192.061, sees < 319252968 ---TRANSACTION 3192.041, ACTIVE (PREPARED) 9471 sec 11 lock struct(s), heap size 1128, 10 row lock(s), undo log entries 15 MySQL thread id 253.091, OS thread handle 139863897786112, query id 5008831458 192.168.0.51 u_ur_cron starting commit ---TRANSACTION 319253431, ACTIVE (PREPARED) 9293 sec 16 lock struct(s), heap size 1128, 10 row lock(s), undo log entries 4 MySQL thread id 253.059, OS thread handle 139859587630848, query id 5008837212 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253432, sees < 319252968 ---TRANSACTION 3192.052, ACTIVE (PREPARED) 9450 sec 11 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 253.024, OS thread handle 139859442611968, query id 5008832022 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 3192.053, sees < 319252968 ---TRANSACTION 319253406, ACTIVE (PREPARED) .08 sec 11 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 2 MySQL thread id 253.011, OS thread handle 139863920555776, query id 5008835716 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253407, sees < 319252968 ---TRANSACTION 319253285, ACTIVE (PREPARED) 9567 sec mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 30 row lock(s), undo log entries 29 MySQL thread id 25353196, OS thread handle 139863879149312, query id 5008828714 192.168.0.51 g_ur_cron Commit DELETE FROM database.c_us_re_ma WHERE p_id='b' ---TRANSACTION 319253284, ACTIVE (PREPARED) 9568 sec mysql tables in use 1, locked 1 4 lock struct(s), heap size 1128, 42 row lock(s), undo log entries 40 MySQL thread id 25353193, OS thread handle 13986456.04656, query id 5008828681 192.168.0.51 c_ur_cron Commit DELETE FROM database.c_us_re_pr WHERE p_id='c' ---TRANSACTION 319253282, ACTIVE (PREPARED) 9570 sec mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 11 row lock(s), undo log entries 10 MySQL thread id 25353203, OS thread handle 139861200246528, query id 5008828664 192.168.0.51 a_ur_cron Commit DELETE FROM database.c_us_re_ma WHERE p_id='a' ---TRANSACTION 319253277, ACTIVE (PREPARED) 9571 sec mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 231 row lock(s), undo log entries 230 MySQL thread id 25353200, OS thread handle 139861183739648, query id 5008828.0 192.168.0.51 u_ur_cron Commit DELETE FROM database.c_us_re_pr WHERE p_id='ul' ---TRANSACTION 319253268, ACTIVE (PREPARED) 9587 sec mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 25 row lock(s), undo log entries 24 MySQL thread id 25353176, OS thread handle 139864549357312, query id 5008828344 192.168.0.51 l_ur_cron Commit DELETE FROM database.c_us_re_ma WHERE p_id='d' ---TRANSACTION 319253261, ACTIVE (PREPARED) 9589 sec mysql tables in use 1, locked 1 2 lock struct(s), heap size 1128, 27 row lock(s), undo log entries 26 MySQL thread id 25353148, OS thread handle 139860656580352, query id 5008828294 192.168.0.51 e1_ur_cron Commit DELETE FROM database.c_us_re_ma WHERE p_id='un' ---TRANSACTION 319253247, ACTIVE (PREPARED) 9607 sec mysql tables in use 1, locked 1 5 lock struct(s), heap size 1128, 962 row lock(s), undo log entries 959 MySQL thread id 25353117, OS thread handle 139859481913088, query id 5008827900 192.168.0.51 g_ur_cron Commit DELETE FROM database.c_us_re_pr WHERE p_id='b' ---TRANSACTION 319253246, ACTIVE (PREPARED) 9609 sec mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 6 MySQL thread id 25353115, OS thread handle 139863929075456, query id 5008827861 192.168.0.51 c_ur_cron Commit DELETE FROM database.c_us_re_ma WHERE p_id='c' ---TRANSACTION 319253245, ACTIVE (PREPARED) 9610 sec mysql tables in use 1, locked 1 5 lock struct(s), heap size 1128, 446 row lock(s), undo log entries 442 MySQL thread id 25353131, OS thread handle 139860680414976, query id 5008827853 192.168.0.51 e1_ur_cron Commit DELETE FROM database.c_us_re_pr WHERE p_id='un' ---TRANSACTION 319253239, ACTIVE (PREPARED) 9611 sec mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 38 row lock(s), undo log entries 37 MySQL thread id 25353122, OS thread handle 139860700927744, query id 5008827822 192.168.0.51 u_ur_cron Commit DELETE FROM database.c_us_re_ma WHERE p_id='ul' ---TRANSACTION 319253238, ACTIVE (PREPARED) 9624 sec 18 lock struct(s), heap size 3488, 22 row lock(s), undo log entries 36 MySQL thread id 25353112, OS thread handle 139860706785024, query id 5008826839 192.168.0.51 e1_ur_cron starting commit ---TRANSACTION 319253221, ACTIVE (PREPARED) 9627 sec mysql tables in use 1, locked 1 5 lock struct(s), heap size 1128, 525 row lock(s), undo log entries 522 MySQL thread id 25353066, OS thread handle 139861223143168, query id 5008826251 192.168.0.51 l_ur_cron Commit DELETE FROM database.c_us_re_pr WHERE p_id='d' ---TRANSACTION 319253214, ACTIVE (PREPARED) 9631 sec mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 15 row lock(s), undo log entries 13 MySQL thread id 25353072, OS thread handle 139861219948288, query id 5008825591 192.168.0.51 a_ur_cron Commit DELETE FROM database.c_re_tr WHERE p_id='a' ---TRANSACTION 3192.013, ACTIVE (PREPARED) 9530 sec 6 lock struct(s), heap size 1128, 780 row lock(s), undo log entries 1538 MySQL thread id 25353099, OS thread handle 139859598280448, query id 5008829593 192.168.0.51 a_mon_user starting commit ---TRANSACTION 3192.010, ACTIVE (PREPARED) 9532 sec 6 lock struct(s), heap size 1128, 808 row lock(s), undo log entries 1584 MySQL thread id 25353096, OS thread handle 139860695070464, query id 5008829505 192.168.0.51 al_usrmntn starting commit ---TRANSACTION 3192.009, ACTIVE (PREPARED) 9.0 sec 5 lock struct(s), heap size 1128, 805 row lock(s), undo log entries 1578 MySQL thread id 25353095, OS thread handle 139861208766208, query id 5008829500 192.168.0.51 e1_usrmntn starting commit ---TRANSACTION 3192.004, ACTIVE (PREPARED) 9534 sec 6 lock struct(s), heap size 1128, 794 row lock(s), undo log entries 1566 MySQL thread id 25353093, OS thread handle 139860171511552, query id 5008829461 192.168.0.51 g_usrmntn starting commit ---TRANSACTION 319253200, ACTIVE (PREPARED) 9636 sec 13 lock struct(s), heap size 1128, 2735 row lock(s), undo log entries 908 MySQL thread id 25353092, OS thread handle 139859340113664, query id 5008824803 192.168.0.51 l_usrmntn starting commit ---TRANSACTION 319253171, ACTIVE (PREPARED) 9645 sec 141 lock struct(s), heap size 24696, 294 row lock(s), undo log entries 310 MySQL thread id 25353079, OS thread handle 139859480315648, query id 50088.053 192.168.0.51 g_ur_cron starting commit ---TRANSACTION 3192.012, ACTIVE (PREPARED) 9530 sec 6 lock struct(s), heap size 1128, 788 row lock(s), undo log entries 1548 MySQL thread id 25353020, OS thread handle 139859620263680, query id 5008829587 192.168.0.51 c_usrmntn starting commit ---TRANSACTION 319253168, ACTIVE (PREPARED) 9647 sec mysql tables in use 1, locked 1 6 lock struct(s), heap size 1128, 515 row lock(s), undo log entries 507 MySQL thread id 25352766, OS thread handle 139861186402048, query id 5008822784 192.168.0.51 g_ur_cron Commit DELETE FROM database.c_re_tr WHERE p_id='b' ---TRANSACTION 319253169, ACTIVE (PREPARED) 9647 sec mysql tables in use 1, locked 1 5 lock struct(s), heap size 1128, 283 row lock(s), undo log entries 271 MySQL thread id 25352311, OS thread handle 139864821626624, query id 5008822811 192.168.0.51 l_ur_cron Commit DELETE FROM database.c_re_tr WHERE p_id='d' ---TRANSACTION 421353837415008, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 319253167, ACTIVE (PREPARED) 9650 sec mysql tables in use 1, locked 1 5 lock struct(s), heap size 1128, 244 row lock(s), undo log entries 238 MySQL thread id 25350466, OS thread handle 139859631978240, query id 5008822449 192.168.0.51 e1_ur_cron Commit DELETE FROM database.c_re_tr WHERE p_id='un' ---TRANSACTION 421353837548184, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 319253244, ACTIVE (PREPARED) 9611 sec mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 24 row lock(s), undo log entries 23 MySQL thread id 25349969, OS thread handle 139859452196608, query id 5008827826 192.168.0.51 a_ur_cron Commit DELETE FROM database.c_us_re_pr WHERE p_id='a' ---TRANSACTION 421353837565368, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837457968, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 3192.059, ACTIVE (PREPARED) 9443 sec 93 lock struct(s), heap size 24696,.51 row lock(s), undo log entries 198 MySQL thread id 25348328, OS thread handle 139858826671872, query id 5008832405 192.168.0.51 l_ur_cron starting commit ---TRANSACTION 319253219, ACTIVE (PREPARED) 9629 sec mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 29 row lock(s), undo log entries 29 MySQL thread id 25348013, OS thread handle 139878499682048, query id 5008825848 192.168.0.51 c_ur_cron Commit INSERT INTO database.c_re_tr ..... ---TRANSACTION 319253213, ACTIVE (PREPARED) 9631 sec mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 146 row lock(s), undo log entries 139 MySQL thread id 25347584, OS thread handle 139859619198720, query id 5008825563 192.168.0.51 u_ur_cron Commit DELETE FROM database.c_re_tr WHERE p_id='ul' ---TRANSACTION 421353837586848, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837341976, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838055112, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837741504, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838347240, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838042224, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838141032, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837552480, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838381608, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 319253270, ACTIVE (PREPARED) 9585 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 25340752, OS thread handle 139864565737216, query id 5008828384 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253271, sees < 319252968 ---TRANSACTION 3192.003, ACTIVE (PREPARED) 9536 sec 12 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 3 MySQL thread id 25340748, OS thread handle 139863888.0952, query id 5008829408 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 3192.004, sees < 319252968 ---TRANSACTION 319253249, ACTIVE (PREPARED) 9605 sec 12 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 3 MySQL thread id 25340747, OS thread handle 139863931205376, query id 5008828011 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253250, sees < 319252968 ---TRANSACTION 421353838269912, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838192584, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838149624, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838050816, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838102368, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837939120, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837831720, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837904752, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837539592, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837827424, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837384936, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837638400, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837629808, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 42135383.03384, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837737208, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837681360, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838020744, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837496632, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838046520, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837646992, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837848904, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838317168, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837750096, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838450344, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 42135383.07680, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838312872, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837836016, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837956304, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837406416, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838222656, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837694248, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837698544, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837573960, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837329088, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837290424, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838063704, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837445080, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837372048, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837535296, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837518112, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837745800, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838037928, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 3192.025, ACTIVE (PREPARED) 9516 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25312447, OS thread handle 139864568399616, query id 5008829931 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 3192.026, sees < 319252968 ---TRANSACTION 421353838128144, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837204504, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838166808, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837505224, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838.0632, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838059408, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837483744, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837982080, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838025040, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 4213538379.044, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837887568, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838153920, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837668472, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837475152, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837810240, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838385904, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837397824, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838373016, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837479448, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837969192, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838145328, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837711432, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837921936, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837208800, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838364424, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837762984, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837930528, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838162512, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837531000, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837625512, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837359160, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837281832, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838068000, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837926232, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837801648, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837608328, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837896160, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837634104, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837844608, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837788760, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837780168, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837964896, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838171104, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837556776, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838106664, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838257024, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837599736, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838158216, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837797352, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837728616, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837689952, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837784464, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837840312, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837449376, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838235544, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838390200, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838226952, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837595440, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838093776, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837543888, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838282800, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838072296, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837367752, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837934824, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837376344, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837702840, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837947712, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837389232, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837526704, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837767280, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837943416, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838085184, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837299016, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837857496, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837500928, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837393528, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837677064, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837316200, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837793056, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838407384, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838188288, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838428864, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837878976, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838287096, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837724320, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837775872, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838415976, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838076592, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837994968, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837732912, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838132440, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837324792, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838175400, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838291392, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837402120, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838321464, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 319253206, ACTIVE (PREPARED) 9636 sec 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 25134902, OS thread handle 139859595085568, query id 5008824846 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253207, sees < 319252968 ---TRANSACTION 421353838003560, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837823128, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838446048, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837604032, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838398792, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837591144, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838424568, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837685656, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837419304, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837973488, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 3192.048, ACTIVE (PREPARED) 9466 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25098107, OS thread handle 139864820561664, query id 5008831627 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 3192.049, sees < 319252968 ---TRANSACTION 421353837771576, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838355832, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837999264, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837853200, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837990672, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837311904, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837952008, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 319253295, ACTIVE (PREPARED) 9557 sec 6 lock struct(s), heap size 1128, 4 row lock(s), undo log entries 3 MySQL thread id 25075968, OS thread handle 139861194389248, query id 5008828891 192.168.0.51 www2 starting commit Trx read view will not see trx with id >= 319253296, sees < 319252968 ---TRANSACTION 421353837294720, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837277536, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837861792, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837320496, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837672768, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838231248, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837818832, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838209768, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837651288, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837977784, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838110960, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837346272, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837986376, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 42135383802.06, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838360128, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838342944, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838183992, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838205472, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837720024, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837891864, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837380640, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837664176, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353838420272, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 319252968, ACTIVE (PREPARED) 9668 sec 56 lock struct(s), heap size 8312, 13156 row lock(s), undo log entries 13414 MySQL thread id 17664357, OS thread handle 139859342776064, query id 5008827713 192.168.0.51 l_ur_cron starting commit ---TRANSACTION 421353837264648, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837260352, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837256056, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837251760, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837247464, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837243168, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837238872, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837234576, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837230280, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837225984, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837221688, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837217392, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837213096, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837195912, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837200208, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837191616, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 421353837187320, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: (null) ((null)) I/O thread 1 state: (null) ((null)) I/O thread 2 state: (null) ((null)) I/O thread 3 state: (null) ((null)) I/O thread 4 state: (null) ((null)) I/O thread 5 state: (null) ((null)) I/O thread 6 state: (null) ((null)) I/O thread 7 state: (null) ((null)) I/O thread 8 state: (null) ((null)) I/O thread 9 state: (null) ((null)) I/O thread 10 state: (null) ((null)) I/O thread 11 state: (null) ((null)) I/O thread 12 state: (null) ((null)) I/O thread 13 state: (null) ((null)) I/O thread 14 state: (null) ((null)) I/O thread 15 state: (null) ((null)) I/O thread 16 state: (null) ((null)) I/O thread 17 state: (null) ((null)) I/O thread 18 state: (null) ((null)) I/O thread 19 state: (null) ((null)) I/O thread 20 state: (null) ((null)) I/O thread 21 state: (null) ((null)) I/O thread 22 state: (null) ((null)) I/O thread 23 state: (null) ((null)) I/O thread 24 state: (null) ((null)) I/O thread 25 state: (null) ((null)) I/O thread 26 state: (null) ((null)) I/O thread 27 state: (null) ((null)) I/O thread 28 state: (null) ((null)) I/O thread 29 state: (null) ((null)) Pending normal aio reads: Pending flushes (fsync) log: 0; buffer pool: 0 453 OS file reads, 204165523 OS file writes, 180469218 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 0, seg size 2, 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, 13.49 non-hash searches/s --- LOG --- Log sequence number 3864001508268 Log flushed up to 3864001508268 Pages flushed up to 3863990177088 Last checkpoint at 3863990177088 0 pending log flushes, 0 pending chkp writes 179446072 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 13488881664 Dictionary memory allocated 79975080 Buffer pool size 806500 Free buffers 319108 Database pages 487390 Old database pages 179895 Modified db pages 2631 Percent of dirty pages(LRU & free pages): 0.326 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0 Pages made young 7477036, not young 2 0.00 youngs/s, 0.00 non-youngs/s Pages read 440, created 2864603, written 24573577 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: 487390, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 374 read views open inside InnoDB Process ID=0, Main thread ID=0, state: sleeping Number of rows inserted 16369167201, updated 5578256, deleted 1.0522.05, read 68869621.01 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 4.50 reads/s Number of system rows inserted 42, updated 0, deleted 42, read 89 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================