*************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2018-07-15 13:35:13 7f78fb313700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 22 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 2910 srv_active, 0 srv_shutdown, 15 srv_idle srv_master_thread log flush and writes: 2925 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 2418648 OS WAIT ARRAY INFO: signal count 3121091 Mutex spin waits 17157900, rounds 75676080, OS waits 1537266 RW-shared spins 2547543, rounds 36485407, OS waits 662745 RW-excl spins 2906533, rounds 19633615, OS waits 158150 Spin rounds per wait: 4.41 mutex, 14.32 RW-shared, 6.75 RW-excl ------------------------ LATEST DETECTED DEADLOCK ------------------------ 2018-07-15 13:00:30 7f78fe38d700 *** (1) TRANSACTION: TRANSACTION 20204357650, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 127 lock struct(s), heap size 30248, 157 row lock(s), undo log entries 56 MySQL thread id 15489, OS thread handle 0x7f78ff261700, query id 442179907 10.185.50.13 gmrp_app updating /* GscpShipmentResultRcvIntfMapper.updateGscpShipmentResultRcvIntfEnd */ UPDATE XDMD_GSCP_SHIP_PSI_R_R_IF SET process_status = 'S' , error_message = NULL , gmrp_transfer_flag = 'Y' WHERE 1 = 1 AND UNI_SEQ = '325149980' *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 12927 page no 15299227 n bits 88 index "PRIMARY" of table "gmrpp"."xdmd_gscp_ship_psi_r_r_if" trx table locks 2 total table locks 4 trx id 20204357650 lock_mode X locks rec but not gap waiting lock hold time 0 wait time before grant 0 Record lock, heap no 15 PHYSICAL RECORD: n_fields 91; compact format; info bits 0 0: len 8; hex 000000001361651c; asc ae ;; 1: len 6; hex 0004b44607f4; asc F ;; 2: len 7; hex 0700e9801a2da6; asc - ;; 3: len 30; hex 323031383037313430333332353638373738323830303730363133383032; asc 201807140332568778280070613802;; 4: len 4; hex 8000053b; asc ;;; 5: len 4; hex 32303138; asc 2018;; 6: len 4; hex 8000b2d8; asc ;; 7: len 4; hex 8010f0bc; asc ;; 8: len 4; hex 8c5aa10d; asc Z ;; 9: len 3; hex 534541; asc SEA;; 10: len 22; hex 534849504d454e542d3330302d43415252594f564552; asc SHIPMENT-300-CARRYOVER;; 11: len 11; hex 8000000000000000000000; asc ;; 12: len 11; hex 8000000000000000000000; asc ;; 13: len 11; hex 8000000000000000000000; asc ;; 14: len 11; hex 8000000000000000000000; asc ;; 15: len 11; hex 8000000000000000000000; asc ;; 16: len 11; hex 8000000000000000000000; asc ;; 17: len 11; hex 8000000000000000000000; asc ;; 18: len 11; hex 8000000000000000000000; asc ;; 19: len 11; hex 8000000000000000000000; asc ;; 20: len 11; hex 8000000000000000000000; asc ;; 21: len 11; hex 8000000000000000000000; asc ;; 22: len 11; hex 8000000000000000000000; asc ;; 23: len 11; hex 8000000000000000000000; asc ;; 24: len 11; hex 8000000000000000000000; asc ;; 25: len 11; hex 8000000000000000000000; asc ;; 26: len 11; hex 8000000000000000000000; asc ;; 27: len 11; hex 8000000000000000000000; asc ;; 28: len 11; hex 8000000000000000000000; asc ;; 29: len 11; hex 8000000000000000000000; asc ;; 30: len 11; hex 8000000000000000000000; asc ;; 31: len 11; hex 8000000000000000000000; asc ;; 32: len 11; hex 8000000000000000000000; asc ;; 33: len 11; hex 8000000000000000000000; asc ;; 34: len 11; hex 8000000000000000000000; asc ;; 35: len 11; hex 8000000000000000000000; asc ;; 36: len 11; hex 8000000000000000000000; asc ;; 37: len 11; hex 8000000000000000000000; asc ;; 38: len 11; hex 8000000000000000000000; asc ;; 39: len 11; hex 8000000000000000000000; asc ;; 40: len 11; hex 8000000000000000000000; asc ;; 41: len 11; hex 8000000000000000000000; asc ;; 42: len 11; hex 8000000000000000000000; asc ;; 43: len 11; hex 8000000000000000000000; asc ;; 44: len 11; hex 8000000000000000000000; asc ;; 45: len 11; hex 8000000000000000000000; asc ;; 46: len 11; hex 8000000000000000000000; asc ;; 47: len 11; hex 8000000000000000000000; asc ;; 48: len 11; hex 8000000000000000000000; asc ;; 49: len 11; hex 8000000000000000000000; asc ;; 50: len 11; hex 8000000000000000000000; asc ;; 51: len 11; hex 8000000000000000000000; asc ;; 52: len 11; hex 8000000000000000000000; asc ;; 53: len 11; hex 8000000000000000000000; asc ;; 54: len 11; hex 8000000000000000000000; asc ;; 55: len 11; hex 8000000000000000000000; asc ;; 56: len 11; hex 8000000000000000000000; asc ;; 57: len 11; hex 8000000000000000000000; asc ;; 58: len 11; hex 8000000000000000000000; asc ;; 59: len 11; hex 8000000000000000000000; asc ;; 60: len 11; hex 8000000000000000000000; asc ;; 61: len 11; hex 8000000000000000000000; asc ;; 62: len 11; hex 8000000000000000000000; asc ;; 63: len 11; hex 8000000000000000000000; asc ;; 64: len 11; hex 8000000000000000000000; asc ;; 65: len 8; hex 3230313830373039; asc 20180709;; 66: len 3; hex 444d5a; asc DMZ;; 67: len 19; hex 414b2d51333030384330312e41574742554145; asc AK-Q3008C01.AWGBUAE;; 68: len 8; hex 8000125aafff014f; asc Z O;; 69: len 4; hex 7873636d; asc xscm;; 70: len 8; hex 8000125aafff014f; asc Z O;; 71: len 4; hex 7873636d; asc xscm;; 72: len 1; hex 59; asc Y;; 73: len 8; hex 8000125ab04ab18c; asc Z J ;; 74: len 1; hex 53; asc S;; 75: SQL NULL; 76: SQL NULL; 77: SQL NULL; 78: SQL NULL; 79: SQL NULL; 80: SQL NULL; 81: SQL NULL; 82: SQL NULL; 83: SQL NULL; 84: SQL NULL; 85: SQL NULL; 86: SQL NULL; 87: SQL NULL; 88: SQL NULL; 89: SQL NULL; 90: SQL NULL; *** (2) TRANSACTION: TRANSACTION 20204350154, ACTIVE 93 sec fetching rows, thread declared inside InnoDB 1208 mysql tables in use 2, locked 1 42241 lock struct(s), heap size 4535848, 32 row lock(s) MySQL thread id 12415, OS thread handle 0x7f78fe38d700, query id 384830122 10.185.50.16 gmrp_app Sending data /* GscpShipmentResultRcvIntfMapper.updateGscpShipmentResultRcvIntfNoCategory */ UPDATE XDMD_GSCP_SHIP_PSI_R_R_IF A SET A.PROCESS_STATUS = 'W' , A.ERROR_MESSAGE = 'invalid category code' , A.GMRP_TRANSFER_FLAG = 'Y' WHERE 1 = 1 AND (( A.GMRP_TRANSFER_FLAG = 'N' AND A.PROCESS_STATUS = 'N' ) OR ( A.GMRP_TRANSFER_FLAG = 'Y' AND A.PROCESS_STATUS = 'P' )) AND A.INTERFACE_NO = '201807140332568778280070613802' AND NOT EXISTS (SELECT 1 FROM XCOM_PROGRAM_CATEGORY WHERE MENU_CD = 'KIT0200' AND VALID_FLAG = 'Y' AND ATTRIBUTE2 = A.CATEGORY) *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 12927 page no 15299227 n bits 88 index "PRIMARY" of table "gmrpp"."xdmd_gscp_ship_psi_r_r_if" trx table locks 1 total table locks 4 trx id 20204350154 lock_mode X locks rec but not gap lock hold time 0 wait time before grant 0 Record lock, heap no 15 PHYSICAL RECORD: n_fields 91; compact format; info bits 0 0: len 8; hex 000000001361651c; asc ae ;; 1: len 6; hex 0004b44607f4; asc F ;; 2: len 7; hex 0700e9801a2da6; asc - ;; 3: len 30; hex 323031383037313430333332353638373738323830303730363133383032; asc 201807140332568778280070613802;; 4: len 4; hex 8000053b; asc ;;; 5: len 4; hex 32303138; asc 2018;; 6: len 4; hex 8000b2d8; asc ;; 7: len 4; hex 8010f0bc; asc ;; 8: len 4; hex 8c5aa10d; asc Z ;; 9: len 3; hex 534541; asc SEA;; 10: len 22; hex 534849504d454e542d3330302d43415252594f564552; asc SHIPMENT-300-CARRYOVER;; 11: len 11; hex 8000000000000000000000; asc ;; 12: len 11; hex 8000000000000000000000; asc ;; 13: len 11; hex 8000000000000000000000; asc ;; 14: len 11; hex 8000000000000000000000; asc ;; 15: len 11; hex 8000000000000000000000; asc ;; 16: len 11; hex 8000000000000000000000; asc ;; 17: len 11; hex 8000000000000000000000; asc ;; 18: len 11; hex 8000000000000000000000; asc ;; 19: len 11; hex 8000000000000000000000; asc ;; 20: len 11; hex 8000000000000000000000; asc ;; 21: len 11; hex 8000000000000000000000; asc ;; 22: len 11; hex 8000000000000000000000; asc ;; 23: len 11; hex 8000000000000000000000; asc ;; 24: len 11; hex 8000000000000000000000; asc ;; 25: len 11; hex 8000000000000000000000; asc ;; 26: len 11; hex 8000000000000000000000; asc ;; 27: len 11; hex 8000000000000000000000; asc ;; 28: len 11; hex 8000000000000000000000; asc ;; 29: len 11; hex 8000000000000000000000; asc ;; 30: len 11; hex 8000000000000000000000; asc ;; 31: len 11; hex 8000000000000000000000; asc ;; 32: len 11; hex 8000000000000000000000; asc ;; 33: len 11; hex 8000000000000000000000; asc ;; 34: len 11; hex 8000000000000000000000; asc ;; 35: len 11; hex 8000000000000000000000; asc ;; 36: len 11; hex 8000000000000000000000; asc ;; 37: len 11; hex 8000000000000000000000; asc ;; 38: len 11; hex 8000000000000000000000; asc ;; 39: len 11; hex 8000000000000000000000; asc ;; 40: len 11; hex 8000000000000000000000; asc ;; 41: len 11; hex 8000000000000000000000; asc ;; 42: len 11; hex 8000000000000000000000; asc ;; 43: len 11; hex 8000000000000000000000; asc ;; 44: len 11; hex 8000000000000000000000; asc ;; 45: len 11; hex 8000000000000000000000; asc ;; 46: len 11; hex 8000000000000000000000; asc ;; 47: len 11; hex 8000000000000000000000; asc ;; 48: len 11; hex 8000000000000000000000; asc ;; 49: len 11; hex 8000000000000000000000; asc ;; 50: len 11; hex 8000000000000000000000; asc ;; 51: len 11; hex 8000000000000000000000; asc ;; 52: len 11; hex 8000000000000000000000; asc ;; 53: len 11; hex 8000000000000000000000; asc ;; 54: len 11; hex 8000000000000000000000; asc ;; 55: len 11; hex 8000000000000000000000; asc ;; 56: len 11; hex 8000000000000000000000; asc ;; 57: len 11; hex 8000000000000000000000; asc ;; 58: len 11; hex 8000000000000000000000; asc ;; 59: len 11; hex 8000000000000000000000; asc ;; 60: len 11; hex 8000000000000000000000; asc ;; 61: len 11; hex 8000000000000000000000; asc ;; 62: len 11; hex 8000000000000000000000; asc ;; 63: len 11; hex 8000000000000000000000; asc ;; 64: len 11; hex 8000000000000000000000; asc ;; 65: len 8; hex 3230313830373039; asc 20180709;; 66: len 3; hex 444d5a; asc DMZ;; 67: len 19; hex 414b2d51333030384330312e41574742554145; asc AK-Q3008C01.AWGBUAE;; 68: len 8; hex 8000125aafff014f; asc Z O;; 69: len 4; hex 7873636d; asc xscm;; 70: len 8; hex 8000125aafff014f; asc Z O;; 71: len 4; hex 7873636d; asc xscm;; 72: len 1; hex 59; asc Y;; 73: len 8; hex 8000125ab04ab18c; asc Z J ;; 74: len 1; hex 53; asc S;; 75: SQL NULL; 76: SQL NULL; 77: SQL NULL; 78: SQL NULL; 79: SQL NULL; 80: SQL NULL; 81: SQL NULL; 82: SQL NULL; 83: SQL NULL; 84: SQL NULL; 85: SQL NULL; 86: SQL NULL; 87: SQL NULL; 88: SQL NULL; 89: SQL NULL; 90: SQL NULL; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 12927 page no 15302385 n bits 88 index "PRIMARY" of table "gmrpp"."xdmd_gscp_ship_psi_r_r_if" trx table locks 1 total table locks 4 trx id 20204350154 lock_mode X locks rec but not gap waiting lock hold time 0 wait time before grant 0 Record lock, heap no 18 PHYSICAL RECORD: n_fields 91; compact format; info bits 0 0: len 8; hex 0000000013623302; asc b3 ;; 1: len 6; hex 0004b4460812; asc F ;; 2: len 7; hex 1b0053002f052f; asc S / /;; 3: len 30; hex 323031383037313430333332353638373738323830303730363133383032; asc 201807140332568778280070613802;; 4: len 4; hex 8000053b; asc ;;; 5: len 4; hex 32303138; asc 2018;; 6: len 4; hex 8000b2d8; asc ;; 7: len 4; hex 800323a4; asc # ;; 8: len 4; hex 8d0e9663; asc c;; 9: len 3; hex 534541; asc SEA;; 10: len 26; hex 534849504d454e542d3336302d424153455f534849505f524551; asc SHIPMENT-360-BASE_SHIP_REQ;; 11: len 11; hex 8000000000000000000000; asc ;; 12: len 11; hex 8000000000000000000000; asc ;; 13: len 11; hex 8000000000000000000000; asc ;; 14: len 11; hex 8000000000000000000000; asc ;; 15: len 11; hex 8000000000000000000000; asc ;; 16: len 11; hex 8000000000000000000000; asc ;; 17: len 11; hex 8000000000000000000000; asc ;; 18: len 11; hex 8000000000000000000000; asc ;; 19: len 11; hex 8000000000000000000000; asc ;; 20: len 11; hex 8000000000000000000000; asc ;; 21: len 11; hex 8000000000000000000000; asc ;; 22: len 11; hex 8000000000000000000000; asc ;; 23: len 11; hex 8000000000000000000000; asc ;; 24: len 11; hex 8000000000000000000000; asc ;; 25: len 11; hex 8000000000000000000000; asc ;; 26: len 11; hex 8000000000000000000000; asc ;; 27: len 11; hex 8000000000000000000000; asc ;; 28: len 11; hex 8000000000000000000000; asc ;; 29: len 11; hex 8000000000000000000000; asc ;; 30: len 11; hex 8000000000000000000000; asc ;; 31: len 11; hex 8000000000000000000000; asc ;; 32: len 11; hex 8000000000000000000000; asc ;; 33: len 11; hex 8000000000000000000000; asc ;; 34: len 11; hex 8000000000000000000000; asc ;; 35: len 11; hex 8000000000000000000000; asc ;; 36: len 11; hex 8000000000000000000000; asc ;; 37: len 11; hex 8000000000000000000000; asc ;; 38: len 11; hex 8000000000000000000000; asc ;; 39: len 11; hex 8000000000000000000000; asc ;; 40: len 11; hex 8000000000000000000000; asc ;; 41: len 11; hex 8000000000000000000000; asc ;; 42: len 11; hex 8000000000000000000000; asc ;; 43: len 11; hex 8000000000000000000000; asc ;; 44: len 11; hex 8000000000000000000000; asc ;; 45: len 11; hex 8000000000000000000000; asc ;; 46: len 11; hex 8000000000000000000000; asc ;; 47: len 11; hex 8000000000000000000000; asc ;; 48: len 11; hex 8000000000000000000000; asc ;; 49: len 11; hex 8000000000000000000000; asc ;; 50: len 11; hex 8000000000000000000000; asc ;; 51: len 11; hex 8000000000000000000000; asc ;; 52: len 11; hex 8000000000000000000000; asc ;; 53: len 11; hex 8000000000000000000000; asc ;; 54: len 11; hex 8000000000000000000000; asc ;; 55: len 11; hex 8000000000000000000000; asc ;; 56: len 11; hex 8000000000000000000000; asc ;; 57: len 11; hex 8000000000000000000000; asc ;; 58: len 11; hex 8000000000000000000000; asc ;; 59: len 11; hex 8000000000000000000000; asc ;; 60: len 11; hex 8000000000000000000000; asc ;; 61: len 11; hex 8000000000000000000000; asc ;; 62: len 11; hex 8000000000000000000000; asc ;; 63: len 11; hex 8000000000000000000000; asc ;; 64: len 11; hex 8000000000000000000000; asc ;; 65: len 8; hex 3230313830373039; asc 20180709;; 66: len 3; hex 444d5a; asc DMZ;; 67: len 19; hex 414b2d51303930384330312e41574742445842; asc AK-Q0908C01.AWGBDXB;; 68: len 8; hex 8000125aafff014f; asc Z O;; 69: len 4; hex 7873636d; asc xscm;; 70: len 8; hex 8000125aafff014f; asc Z O;; 71: len 4; hex 7873636d; asc xscm;; 72: len 1; hex 59; asc Y;; 73: len 8; hex 8000125ab04ab18c; asc Z J ;; 74: len 1; hex 53; asc S;; 75: SQL NULL; 76: SQL NULL; 77: SQL NULL; 78: SQL NULL; 79: SQL NULL; 80: SQL NULL; 81: SQL NULL; 82: SQL NULL; 83: SQL NULL; 84: SQL NULL; 85: SQL NULL; 86: SQL NULL; 87: SQL NULL; 88: SQL NULL; 89: SQL NULL; 90: SQL NULL; *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 20204782704 Purge done for trx's n:o < 20204782521 undo n:o < 0 state: running but idle History list length 1841 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 75932, OS thread handle 0x7f78fb313700, query id 540060586 localhost root init show engine innodb status ---TRANSACTION 20204782178, not started MySQL thread id 75728, OS thread handle 0x7f78f9490700, query id 540012078 10.185.50.12 gmrp_app cleaning up ---TRANSACTION 20204782173, not started MySQL thread id 75519, OS thread handle 0x7f7903032700, query id 540010405 10.185.50.12 gmrp_app cleaning up ---TRANSACTION 20204782189, not started MySQL thread id 75520, OS thread handle 0x7f78f7a54700, query id 540012203 10.185.50.12 gmrp_app cleaning up ---TRANSACTION 20204781954, not started MySQL thread id 75522, OS thread handle 0x7f78f5865700, query id 539859775 10.185.50.12 gmrp_app cleaning up ---TRANSACTION 20204781956, not started MySQL thread id 75521, OS thread handle 0x7f78fc677700, query id 539859777 10.185.50.12 gmrp_app cleaning up ---TRANSACTION 20204782197, not started MySQL thread id 75523, OS thread handle 0x7f78fdcb5700, query id 540012225 10.185.50.12 gmrp_app cleaning up ---TRANSACTION 0, not started MySQL thread id 75016, OS thread handle 0x7f78f7b78700, query id 539782966 10.64.185.23 gmrp_mgr cleaning up ---TRANSACTION 0, not started MySQL thread id 56322, OS thread handle 0x7f78fc10c700, query id 535530227 165.243.166.57 kic cleaning up ---TRANSACTION 20204750335, not started MySQL thread id 36105, OS thread handle 0x7f78f88df700, query id 538248673 10.185.50.11 gmrp_app cleaning up ---TRANSACTION 20204697558, not started MySQL thread id 13137, OS thread handle 0x7f79d6701700, query id 539834784 10.185.218.144 gmrp_app cleaning up ---TRANSACTION 20204622843, not started MySQL thread id 13138, OS thread handle 0x7f79d6502700, query id 539834790 10.185.218.144 gmrp_app cleaning up ---TRANSACTION 20204697557, not started MySQL thread id 13139, OS thread handle 0x7f79d64b9700, query id 539834787 10.185.218.144 gmrp_app cleaning up ---TRANSACTION 0, not started MySQL thread id 38193, OS thread handle 0x7f78fd502700, query id 516749920 10.64.184.173 gmrp_view cleaning up ---TRANSACTION 20204782695, not started MySQL thread id 29767, OS thread handle 0x7f78f5666700, query id 540060541 10.185.50.12 gmrp_jjobs cleaning up ---TRANSACTION 20204773182, not started MySQL thread id 28700, OS thread handle 0x7f78fc4c1700, query id 539479929 10.185.50.12 gmrp_jjobs cleaning up ---TRANSACTION 20204384882, not started MySQL thread id 27664, OS thread handle 0x7f78fd1df700, query id 507263785 10.185.50.12 gmrp_jjobs cleaning up ---TRANSACTION 20204781221, not started MySQL thread id 27468, OS thread handle 0x7f78f94d9700, query id 539805163 10.185.50.11 gmrp_app cleaning up ---TRANSACTION 20204782164, not started MySQL thread id 22000, OS thread handle 0x7f78fe8f8700, query id 540005941 10.185.50.11 gmrp_jjobs cleaning up ---TRANSACTION 20204713155, not started MySQL thread id 23786, OS thread handle 0x7f7902a35700, query id 536093683 10.185.50.11 gmrp_jjobs cleaning up ---TRANSACTION 20204782698, not started MySQL thread id 22256, OS thread handle 0x7f78f7c53700, query id 540060556 10.185.50.11 gmrp_jjobs cleaning up ---TRANSACTION 20204363165, not started MySQL thread id 20000, OS thread handle 0x7f78fe9d3700, query id 460887595 10.185.50.13 gmrp_jjobs cleaning up ---TRANSACTION 20204782159, not started MySQL thread id 19938, OS thread handle 0x7f78f7855700, query id 540004293 10.185.50.11 gmrp_jjobs cleaning up ---TRANSACTION 20204335179, not started MySQL thread id 13404, OS thread handle 0x7f79029a3700, query id 539732626 10.185.218.189 gmrp_app cleaning up ---TRANSACTION 20204645036, not started MySQL thread id 13140, OS thread handle 0x7f7903b9a700, query id 539834788 10.185.218.144 gmrp_app cleaning up ---TRANSACTION 20204332970, not started MySQL thread id 13225, OS thread handle 0x7f79029ec700, query id 539744847 10.185.218.183 gmrp_app cleaning up ---TRANSACTION 20204336581, not started MySQL thread id 12962, OS thread handle 0x7f7900c54700, query id 539735133 10.185.218.155 gmrp_app cleaning up ---TRANSACTION 20204773150, not started MySQL thread id 12799, OS thread handle 0x7f78fa165700, query id 540060474 10.185.218.27 gmrp_app cleaning up ---TRANSACTION 20204330333, not started MySQL thread id 12766, OS thread handle 0x7f7900a55700, query id 539746041 10.185.218.136 gmrp_app cleaning up ---TRANSACTION 20204782149, not started MySQL thread id 6071, OS thread handle 0x7f79023b6700, query id 539997898 10.185.50.11 gmrp_app cleaning up ---TRANSACTION 0, not started MySQL thread id 4517, OS thread handle 0x7f78f54b0700, query id 9247201 10.64.181.7 root cleaning up ---TRANSACTION 20204384184, not started MySQL thread id 2599, OS thread handle 0x7f79d65dd700, query id 507078372 10.185.50.11 gmrp_app cleaning up ---TRANSACTION 0, not started MySQL thread id 2547, OS thread handle 0x7fa47e56a700, query id 539752554 165.243.166.57 kic cleaning up ---TRANSACTION 20204782702, not started MySQL thread id 1207, OS thread handle 0x7f9f4786e700, query id 540060576 10.185.50.16 gmrp_jjobs cleaning up ---TRANSACTION 20204782688, not started MySQL thread id 43, OS thread handle 0x7fa4ad8cd700, query id 540060503 10.185.50.13 gmrp_jjobs cleaning up ---TRANSACTION 20204782502, ACTIVE 3 sec fetching rows, thread declared inside InnoDB 2542 mysql tables in use 12, locked 0 MySQL thread id 36106, OS thread handle 0x7f78fc155700, query id 540013787 10.185.50.11 gmrp_app Sending data SELECT xmo.inventory_org_id AS organizationId ,tme.master_id AS modelingId ,tme.plan_id AS workYyyymmdd ,tme.out_version_id AS planSeq FROM gmrpe.th_mst_eng_plan_flag tme INNER JOIN gmrpp.xmva_modelings xm ON tme.master_id = xm.modeling_id AND xm.MODELING_TYPE in ('MVA','MVA_MAINSP','MVA_MAXSP') INNER JOIN gmrpp.xmva_modelings_org xmo ON xm.modeling_id = xmo.modeling_id INNER JOIN gmrpp.xmva_inv_organizations xio ON (xio.organization_id = xmo.inventory_org_id) INNER JOIN gmrpp.xmva_simulation_org_option xioo ON ( xioo.organization_ Trx read view will not see trx with id >= 20204782503, sees < 20204330842 Trx #rec lock waits 1 #table lock waits 0 Trx total rec lock wait time 9 SEC Trx total table lock wait time 0 SEC ---TRANSACTION 20204722801, ACTIVE 591 sec MySQL thread id 59934, OS thread handle 0x7f790359d700, query id 539857645 10.64.184.62 gmrp_view cleaning up Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC ---TRANSACTION 20204498314, ACTIVE 1466 sec MySQL thread id 13915, OS thread handle 0x7f7900d2f700, query id 515813795 10.64.184.173 gmrp_view cleaning up Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC ---TRANSACTION 20204330842, ACTIVE 2424 sec MySQL thread id 8737, OS thread handle 0x7f78fd701700, query id 539758473 10.64.185.124 gmrp_view cleaning up Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (read thread) I/O thread 7 state: waiting for completed aio requests (read thread) I/O thread 8 state: waiting for completed aio requests (read thread) I/O thread 9 state: waiting for completed aio requests (read thread) I/O thread 10 state: waiting for completed aio requests (read thread) I/O thread 11 state: waiting for completed aio requests (read thread) I/O thread 12 state: waiting for completed aio requests (read thread) I/O thread 13 state: waiting for completed aio requests (read thread) I/O thread 14 state: waiting for completed aio requests (read thread) I/O thread 15 state: waiting for completed aio requests (read thread) I/O thread 16 state: waiting for completed aio requests (read thread) I/O thread 17 state: waiting for completed aio requests (read thread) I/O thread 18 state: waiting for completed aio requests (write thread) I/O thread 19 state: waiting for completed aio requests (write thread) I/O thread 20 state: waiting for completed aio requests (write thread) I/O thread 21 state: waiting for completed aio requests (write thread) I/O thread 22 state: waiting for completed aio requests (write thread) I/O thread 23 state: waiting for completed aio requests (write thread) I/O thread 24 state: waiting for completed aio requests (write thread) I/O thread 25 state: waiting for completed aio requests (write thread) I/O thread 26 state: waiting for completed aio requests (write thread) I/O thread 27 state: waiting for completed aio requests (write thread) I/O thread 28 state: waiting for completed aio requests (write thread) I/O thread 29 state: waiting for completed aio requests (write thread) I/O thread 30 state: waiting for completed aio requests (write thread) I/O thread 31 state: waiting for completed aio requests (write thread) I/O thread 32 state: waiting for completed aio requests (write thread) I/O thread 33 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2033610 OS file reads, 441212 OS file writes, 17766 OS fsyncs 16.95 reads/s, 16384 avg bytes/read, 47.27 writes/s, 4.36 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 4, free list len 3932178, seg size 3932183, 97917 merges merged operations: insert 131882, delete mark 11893402, delete 675184 discarded operations: insert 0, delete mark 0, delete 0 45571.84 hash searches/s, 3728.33 non-hash searches/s --- LOG --- Log sequence number 291389283864221 Log flushed up to 291389283858693 Pages flushed up to 291374790238503 Last checkpoint at 291374789084865 Max checkpoint age 26083663812 Checkpoint age target 25268549318 Modified age 14493625718 Checkpoint age 14494779356 0 pending log writes, 0 pending chkp writes 158173 log i/o's done, 16.50 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 178845122560; in additional pool allocated 0 Total memory allocated by read views 8224 Internal hash tables (constant factor + variable factor) Adaptive hash index 3544904704 (2720029184 + 824875520) Page hash 21250552 (buffer pool 0 only) Dictionary cache 687835342 (679994096 + 7841246) File system 1463272 (812272 + 651000) Lock system 425010176 (424996136 + 14040) Recovery system 0 (0 + 0) Dictionary memory allocated 7841246 Buffer pool size 10485752 Buffer pool size, bytes 171798560768 Free buffers 7968093 Database pages 2465569 Old database pages 910087 Modified db pages 637572 Percent of dirty pages(LRU & free pages): 6.111 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 816390, not young 89540883 21.59 youngs/s, 125.95 non-youngs/s Pages read 2032876, created 433647, written 274366 16.95 reads/s, 3.77 creates/s, 29.45 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: 2465569, unzip_LRU len: 3518 I/O sum[12792]:cur[48], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 1310719 Buffer pool size, bytes 21474820096 Free buffers 978914 Database pages 325295 Old database pages 120069 Modified db pages 88189 Percent of dirty pages(LRU & free pages): 6.762 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 103281, not young 13648949 2.64 youngs/s, 11.45 non-youngs/s Pages read 259862, created 65526, written 40347 1.91 reads/s, 0.68 creates/s, 3.41 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: 325295, unzip_LRU len: 432 I/O sum[1599]:cur[6], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 1310719 Buffer pool size, bytes 21474820096 Free buffers 997622 Database pages 306601 Old database pages 113169 Modified db pages 78009 Percent of dirty pages(LRU & free pages): 5.981 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 104951, not young 11222552 3.05 youngs/s, 35.36 non-youngs/s Pages read 255160, created 51486, written 33248 2.27 reads/s, 2.55 creates/s, 3.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 1 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 306601, unzip_LRU len: 390 I/O sum[1599]:cur[6], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 1310719 Buffer pool size, bytes 21474820096 Free buffers 998982 Database pages 305253 Old database pages 112677 Modified db pages 78410 Percent of dirty pages(LRU & free pages): 6.012 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 97431, not young 9925257 2.36 youngs/s, 23.68 non-youngs/s Pages read 252635, created 52696, written 33368 2.00 reads/s, 0.36 creates/s, 4.64 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: 305253, unzip_LRU len: 351 I/O sum[1599]:cur[6], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 1310719 Buffer pool size, bytes 21474820096 Free buffers 996575 Database pages 307769 Old database pages 113606 Modified db pages 80085 Percent of dirty pages(LRU & free pages): 6.140 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 102938, not young 11096170 2.36 youngs/s, 12.14 non-youngs/s Pages read 254363, created 53520, written 33921 2.14 reads/s, 0.00 creates/s, 1.77 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: 307769, unzip_LRU len: 284 I/O sum[1599]:cur[6], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 1310719 Buffer pool size, bytes 21474820096 Free buffers 998938 Database pages 305059 Old database pages 112601 Modified db pages 79957 Percent of dirty pages(LRU & free pages): 6.132 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 103367, not young 11119998 3.27 youngs/s, 5.64 non-youngs/s Pages read 252094, created 53109, written 32620 1.82 reads/s, 0.00 creates/s, 5.14 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: 305059, unzip_LRU len: 628 I/O sum[1599]:cur[6], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 1310719 Buffer pool size, bytes 21474820096 Free buffers 999087 Database pages 305147 Old database pages 112635 Modified db pages 76783 Percent of dirty pages(LRU & free pages): 5.887 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 105233, not young 10283847 2.41 youngs/s, 11.36 non-youngs/s Pages read 253002, created 52326, written 33748 1.82 reads/s, 0.14 creates/s, 5.91 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: 305147, unzip_LRU len: 347 I/O sum[1599]:cur[6], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 1310719 Buffer pool size, bytes 21474820096 Free buffers 997851 Database pages 306318 Old database pages 113074 Modified db pages 78753 Percent of dirty pages(LRU & free pages): 6.039 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 100471, not young 11127941 2.59 youngs/s, 11.59 non-youngs/s Pages read 253862, created 52599, written 33157 2.59 reads/s, 0.05 creates/s, 3.64 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: 306318, unzip_LRU len: 610 I/O sum[1599]:cur[6], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 1310719 Buffer pool size, bytes 21474820096 Free buffers 1000124 Database pages 304127 Old database pages 112256 Modified db pages 77386 Percent of dirty pages(LRU & free pages): 5.933 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 98718, not young 11116169 2.91 youngs/s, 14.73 non-youngs/s Pages read 251898, created 52385, written 33957 2.41 reads/s, 0.00 creates/s, 1.95 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: 304127, unzip_LRU len: 476 I/O sum[1599]:cur[6], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB 4 RW transactions active inside InnoDB 0 RO transactions active inside InnoDB 4 out of 1000 descriptors used ---OLDEST VIEW--- Normal read view Read view low limit trx n:o 20204782503 Read view up limit trx id 20204330842 Read view low limit trx id 20204782503 Read view individually stored trx ids: Read view trx id 20204330842 Read view trx id 20204498314 Read view trx id 20204722801 ----------------- Main thread process no. 112247, id 140157806159616, state: sleeping Number of rows inserted 17557085, updated 2928271, deleted 16157936, read 12206650277 70.27 inserts/s, 152.99 updates/s, 0.45 deletes/s, 1185295.67 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================