innodb_lock_monitor解決mysql死鎖
開發說，mysql出現Translating SQLException with SQL state '41000', error code '1205', message [Lock wait timeout exceeded; try restarting transaction];
通過innodb_lock_monitor看到有如下語句一直在執行，同時有lock。
insert into xxxx( ...) select .... from xxxx 關聯很多表很多複雜聚合，
處理：
修改一下插入邏輯，先把記錄查詢出來，然後在分步提交insert
結果，問題解決了，但是還是有疑問，得繼續研究。
Translating SQLException with SQL state '41000', error code '1205', message [Lock wait timeout exceeded; try restarting transaction];
Trx read view will not see trx with id >= 0 5185563, sees < 0 5185563
TABLE LOCK table `xxxx`.`xxxx` trx id 0 5185562 lock mode IX
RECORD LOCKS space id 0 page no 480 n bits 1368 index `idx_xxxxxx_ID` of table `xxxx`.`xxxx` trx id 0 5185562 lock_mode X
Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0
0: len 8; hex 73757072656d756d; asc supremum;;
Record lock, heap no 317 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 3; hex 808cca; asc ;; 1: len 3; hex 85334e; asc 3N;;
0: len 3; hex 808cca; asc ;; 1: len 3; hex 85334e; asc 3N;;
0: len 3; hex 808ccd; asc ;; 1: len 3; hex 871dea; asc ;;
Record lock, heap no 1287 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 3; hex 808cce; asc ;; 1: len 3; hex 871deb; asc ;;
0: len 3; hex 808cce; asc ;; 1: len 3; hex 871deb; asc ;;
Record lock, heap no 1288 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 3; hex 808ccb; asc ;; 1: len 3; hex 878666; asc f;;
0: len 3; hex 808ccb; asc ;; 1: len 3; hex 878666; asc f;;
Record lock, heap no 1289 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 3; hex 808cce; asc ;; 1: len 3; hex 8ac665; asc e;;
0: len 3; hex 808cce; asc ;; 1: len 3; hex 8ac665; asc e;;
Record lock, heap no 1300 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 3; hex 808cca; asc ;; 1: len 3; hex 87351a; asc 5 ;;
0: len 3; hex 808cca; asc ;; 1: len 3; hex 87351a; asc 5 ;;
Record lock, heap no 1301 PHYSICAL RECORD: n_fields 2; compact format; info bits 0
0: len 3; hex 808ccb; asc ;; 1: len 3; hex 87351b; asc 5 ;;
0: len 3; hex 808ccb; asc ;; 1: len 3; hex 87351b; asc 5 ;;
RECORD LOCKS space id 0 page no 1573 n bits 184 index `PRIMARY` of table `xxxx`.`zszzz` trx id 0 5185562 lock_mode X locks rec but not gap
Record lock, heap no 2 PHYSICAL RECORD: n_fields 31; compact format; info bits 0
0: len 3; hex 853349; asc 3I;; 1: len 6; hex 00000005c3d7; asc ;; 2: len 7; hex 80000005b03830; asc 80;; 3: len 3; hex 808ccb; asc ;; 4: len 3; hex 800001; asc ;; 5: len 3; hex 800001; asc ;; 6: SQL NULL; 7: len 6; hex e9a9ace58faf; asc ;; 8: len 3; hex 302e30; asc 0.0;; 9: len 3; hex 302e30; asc 0.0;; 10: len 3; hex 332e32; asc 3.2;; 11: len 1; hex 33; asc 3;; 12: len 4; hex 80000000; asc ;; 13: len 4; hex 80000000; asc ;; 14: len 4; hex 8000000c; asc ;; 15: len 4; hex 302e3030; asc 0.00;; 16: len 3; hex 302e30; asc 0.0;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; 21: len 4; hex 302e3030; asc 0.00;; 22: len 4; hex 332e3030; asc 3.00;; 23: len 5; hex 302e303025; asc 0.00%;; 24: len 4; hex 80000000; asc ;; 25: len 4; hex 80000000; asc ;; 26: len 4; hex 80000000; asc ;; 27: len 4; hex 80000000; asc ;; 28: len 3; hex 302e30; asc 0.0;; 29: len 8; hex 8000124a40837176; asc J@ qv;; 30: len 8; hex 8000124a40900e24; asc J@ $;;
Record lock, heap no 2 PHYSICAL RECORD: n_fields 31; compact format; info bits 0
0: len 3; hex 853349; asc 3I;; 1: len 6; hex 00000005c3d7; asc ;; 2: len 7; hex 80000005b03830; asc 80;; 3: len 3; hex 808ccb; asc ;; 4: len 3; hex 800001; asc ;; 5: len 3; hex 800001; asc ;; 6: SQL NULL; 7: len 6; hex e9a9ace58faf; asc ;; 8: len 3; hex 302e30; asc 0.0;; 9: len 3; hex 302e30; asc 0.0;; 10: len 3; hex 332e32; asc 3.2;; 11: len 1; hex 33; asc 3;; 12: len 4; hex 80000000; asc ;; 13: len 4; hex 80000000; asc ;; 14: len 4; hex 8000000c; asc ;; 15: len 4; hex 302e3030; asc 0.00;; 16: len 3; hex 302e30; asc 0.0;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; 21: len 4; hex 302e3030; asc 0.00;; 22: len 4; hex 332e3030; asc 3.00;; 23: len 5; hex 302e303025; asc 0.00%;; 24: len 4; hex 80000000; asc ;; 25: len 4; hex 80000000; asc ;; 26: len 4; hex 80000000; asc ;; 27: len 4; hex 80000000; asc ;; 28: len 3; hex 302e30; asc 0.0;; 29: len 8; hex 8000124a40837176; asc J@ qv;; 30: len 8; hex 8000124a40900e24; asc J@ $;;
Record lock, heap no 3 PHYSICAL RECORD: n_fields 31; compact format; info bits 0
0: len 3; hex 85334a; asc 3J;; 1: len 6; hex 00000005c3d7; asc ;; 2: len 7; hex 80000005b0383c; asc 8
0: len 3; hex 85334a; asc 3J;; 1: len 6; hex 00000005c3d7; asc ;; 2: len 7; hex 80000005b0383c; asc 8
Record lock, heap no 4 PHYSICAL RECORD: n_fields 31; compact format; info bits 0
0: len 3; hex 85334b; asc 3K;; 1: len 6; hex 00000005c3d7; asc ;; 2: len 7; hex 80000005b03848; asc 8H;; 3: len 3; hex 808d39; asc 9;; 4: len 3; hex 800001; asc ;; 5: len 3; hex 800001; asc ;; 6: SQL NULL; 7: len 6; hex e79c9fe5bda9; asc ;; 8: len 3; hex 302e30; asc 0.0;; 9: len 3; hex 302e30; asc 0.0;; 10: len 3; hex 302e30; asc 0.0;; 11: len 1; hex 36; asc 6;; 12: len 4; hex 80000000; asc ;; 13: len 4; hex 80000000; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 4; hex 302e3030; asc 0.00;; 16: len 3; hex 302e30; asc 0.0;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; 21: len 4; hex 302e3030; asc 0.00;; 22: len 4; hex 302e3630; asc 0.60;; 23: len 5; hex 302e303025; asc 0.00%;; 24: len 4; hex 80000000; asc ;; 25: len 4; hex 80000000; asc ;; 26: len 4; hex 80000000; asc ;; 27: len 4; hex 80000000; asc ;; 28: len 3; hex 302e30; asc 0.0;; 29: len 8; hex 8000124a40837176; asc J@ qv;; 30: len 8; hex 8000124a40900e24; asc J@ $;;
0: len 3; hex 85334b; asc 3K;; 1: len 6; hex 00000005c3d7; asc ;; 2: len 7; hex 80000005b03848; asc 8H;; 3: len 3; hex 808d39; asc 9;; 4: len 3; hex 800001; asc ;; 5: len 3; hex 800001; asc ;; 6: SQL NULL; 7: len 6; hex e79c9fe5bda9; asc ;; 8: len 3; hex 302e30; asc 0.0;; 9: len 3; hex 302e30; asc 0.0;; 10: len 3; hex 302e30; asc 0.0;; 11: len 1; hex 36; asc 6;; 12: len 4; hex 80000000; asc ;; 13: len 4; hex 80000000; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 4; hex 302e3030; asc 0.00;; 16: len 3; hex 302e30; asc 0.0;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; 21: len 4; hex 302e3030; asc 0.00;; 22: len 4; hex 302e3630; asc 0.60;; 23: len 5; hex 302e303025; asc 0.00%;; 24: len 4; hex 80000000; asc ;; 25: len 4; hex 80000000; asc ;; 26: len 4; hex 80000000; asc ;; 27: len 4; hex 80000000; asc ;; 28: len 3; hex 302e30; asc 0.0;; 29: len 8; hex 8000124a40837176; asc J@ qv;; 30: len 8; hex 8000124a40900e24; asc J@ $;;
Record lock, heap no 5 PHYSICAL RECORD: n_fields 31; compact format; info bits 0
0: len 3; hex 85334c; asc 3L;; 1: len 6; hex 00000005c3d7; asc ;; 2: len 7; hex 80000005b03854; asc 8T;; 3: len 3; hex 808d33; asc 3;; 4: len 3; hex 800001; asc ;; 5: len 3; hex 800001; asc ;; 6: SQL NULL; 7: len 6; hex e993b6e8a385; asc ;; 8: len 3; hex 302e30; asc 0.0;; 9: len 3; hex 302e30; asc 0.0;; 10: len 3; hex 302e30; asc 0.0;; 11: len 1; hex 37; asc 7;; 12: len 4; hex 80000000; asc ;; 13: len 4; hex 80000000; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 4; hex 302e3030; asc 0.00;; 16: len 3; hex 302e30; asc 0.0;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; 21: len 4; hex 302e3030; asc 0.00;; 22: len 4; hex 302e3235; asc 0.25;; 23: len 5; hex 302e303025; asc 0.00%;; 24: len 4; hex 80000000; asc ;; 25: len 4; hex 80000000; asc ;; 26: len 4; hex 80000000; asc ;; 27: len 4; hex 80000000; asc ;; 28: len 3; hex 302e30; asc 0.0;; 29: len 8; hex 8000124a40837176; asc J@ qv;; 30: len 8; hex 8000124a40900e24; asc J@ $;;
0: len 3; hex 85334c; asc 3L;; 1: len 6; hex 00000005c3d7; asc ;; 2: len 7; hex 80000005b03854; asc 8T;; 3: len 3; hex 808d33; asc 3;; 4: len 3; hex 800001; asc ;; 5: len 3; hex 800001; asc ;; 6: SQL NULL; 7: len 6; hex e993b6e8a385; asc ;; 8: len 3; hex 302e30; asc 0.0;; 9: len 3; hex 302e30; asc 0.0;; 10: len 3; hex 302e30; asc 0.0;; 11: len 1; hex 37; asc 7;; 12: len 4; hex 80000000; asc ;; 13: len 4; hex 80000000; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 4; hex 302e3030; asc 0.00;; 16: len 3; hex 302e30; asc 0.0;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; 21: len 4; hex 302e3030; asc 0.00;; 22: len 4; hex 302e3235; asc 0.25;; 23: len 5; hex 302e303025; asc 0.00%;; 24: len 4; hex 80000000; asc ;; 25: len 4; hex 80000000; asc ;; 26: len 4; hex 80000000; asc ;; 27: len 4; hex 80000000; asc ;; 28: len 3; hex 302e30; asc 0.0;; 29: len 8; hex 8000124a40837176; asc J@ qv;; 30: len 8; hex 8000124a40900e24; asc J@ $;;
Record lock, heap no 12 PHYSICAL RECORD: n_fields 31; compact format; info bits 0
0: len 3; hex 853353; asc 3S;; 1: len 6; hex 00000005c3d7; asc ;; 2: len 7; hex 80000005b038a8; asc 8 ;; 3: len 3; hex 808d55; asc U;; 4: len 3; hex 800001; asc ;; 5: len 3; hex 800001; asc ;; 6: SQL NULL; 7: len 9; hex e699aee4b990e5a3ab; asc ;; 8: len 3; hex 302e30; asc 0.0;; 9: len 3; hex 302e30; asc 0.0;; 10: len 3; hex 312e30; asc 1.0;; 11: len 1; hex 37; asc 7;; 12: len 4; hex 80000000; asc ;; 13: len 4; hex 80000000; asc ;; 14: len 4; hex 80000001; asc ;; 15: len 4; hex 302e3030; asc 0.00;; 16: len 3; hex 302e30; asc 0.0;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; 21: len 4; hex 302e3030; asc 0.00;; 22: len 4; hex 302e3135; asc 0.15;; 23: len 5; hex 302e303025; asc 0.00%;; 24: len 4; hex 80000000; asc ;; 25: len 4; hex 80000000; asc ;; 26: len 4; hex 80000000; asc ;; 27: len 4; hex 80000000; asc ;; 28: len 3; hex 302e30; asc 0.0;; 29: len 8; hex 8000124a40837176; asc J@ qv;; 30: len 8; hex 8000124a40900e24; asc J@ $;;
0: len 3; hex 853353; asc 3S;; 1: len 6; hex 00000005c3d7; asc ;; 2: len 7; hex 80000005b038a8; asc 8 ;; 3: len 3; hex 808d55; asc U;; 4: len 3; hex 800001; asc ;; 5: len 3; hex 800001; asc ;; 6: SQL NULL; 7: len 9; hex e699aee4b990e5a3ab; asc ;; 8: len 3; hex 302e30; asc 0.0;; 9: len 3; hex 302e30; asc 0.0;; 10: len 3; hex 312e30; asc 1.0;; 11: len 1; hex 37; asc 7;; 12: len 4; hex 80000000; asc ;; 13: len 4; hex 80000000; asc ;; 14: len 4; hex 80000001; asc ;; 15: len 4; hex 302e3030; asc 0.00;; 16: len 3; hex 302e30; asc 0.0;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; 21: len 4; hex 302e3030; asc 0.00;; 22: len 4; hex 302e3135; asc 0.15;; 23: len 5; hex 302e303025; asc 0.00%;; 24: len 4; hex 80000000; asc ;; 25: len 4; hex 80000000; asc ;; 26: len 4; hex 80000000; asc ;; 27: len 4; hex 80000000; asc ;; 28: len 3; hex 302e30; asc 0.0;; 29: len 8; hex 8000124a40837176; asc J@ qv;; 30: len 8; hex 8000124a40900e24; asc J@ $;;
Record lock, heap no 13 PHYSICAL RECORD: n_fields 31; compact format; info bits 0
0: len 3; hex 853354; asc 3T;; 1: len 6; hex 00000005c3d7; asc ;; 2: len 7; hex 80000005b038b4; asc 8 ;; 3: len 3; hex 808d4f; asc O;; 4: len 3; hex 800001; asc ;; 5: len 3; hex 800001; asc ;; 6: SQL NULL; 7: len 6; hex e69687e4bbaa; asc ;; 8: len 3; hex 302e30; asc 0.0;; 9: len 3; hex 302e30; asc 0.0;; 10: len 3; hex 302e30; asc 0.0;; 11: len 1; hex 37; asc 7;; 12: len 4; hex 80000000; asc ;; 13: len 4; hex 80000000; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 4; hex 302e3030; asc 0.00;; 16: len 3; hex 302e30; asc 0.0;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; 21: len 4; hex 302e3030; asc 0.00;; 22: len 4; hex 302e3135; asc 0.15;; 23: len 5; hex 302e303025; asc 0.00%;; 24: len 4; hex 80000000; asc ;; 25: len 4; hex 80000000; asc ;; 26: len 4; hex 80000000; asc ;; 27: len 4; hex 80000000; asc ;; 28: len 3; hex 302e30; asc 0.0;; 29: len 8; hex 8000124a40837176; asc J@ qv;; 30: len 8; hex 8000124a40900e24; asc J@ $;;
0: len 3; hex 853354; asc 3T;; 1: len 6; hex 00000005c3d7; asc ;; 2: len 7; hex 80000005b038b4; asc 8 ;; 3: len 3; hex 808d4f; asc O;; 4: len 3; hex 800001; asc ;; 5: len 3; hex 800001; asc ;; 6: SQL NULL; 7: len 6; hex e69687e4bbaa; asc ;; 8: len 3; hex 302e30; asc 0.0;; 9: len 3; hex 302e30; asc 0.0;; 10: len 3; hex 302e30; asc 0.0;; 11: len 1; hex 37; asc 7;; 12: len 4; hex 80000000; asc ;; 13: len 4; hex 80000000; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 4; hex 302e3030; asc 0.00;; 16: len 3; hex 302e30; asc 0.0;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; 21: len 4; hex 302e3030; asc 0.00;; 22: len 4; hex 302e3135; asc 0.15;; 23: len 5; hex 302e303025; asc 0.00%;; 24: len 4; hex 80000000; asc ;; 25: len 4; hex 80000000; asc ;; 26: len 4; hex 80000000; asc ;; 27: len 4; hex 80000000; asc ;; 28: len 3; hex 302e30; asc 0.0;; 29: len 8; hex 8000124a40837176; asc J@ qv;; 30: len 8; hex 8000124a40900e24; asc J@ $;;
Record lock, heap no 14 PHYSICAL RECORD: n_fields 31; compact format; info bits 0
0: len 3; hex 853355; asc 3U;; 1: len 6; hex 00000005c3d7; asc ;; 2: len 7; hex 80000005b038c0; asc 8 ;; 3: len 3; hex 808d3a; asc :;; 4: len 3; hex 800001; asc ;; 5: len 3; hex 800001; asc ;; 6: SQL NULL; 7: len 6; hex e6b0b8e58f91; asc ;; 8: len 3; hex 302e30; asc 0.0;; 9: len 3; hex 302e30; asc 0.0;; 10: len 3; hex 322e30; asc 2.0;; 11: len 1; hex 37; asc 7;; 12: len 4; hex 80000000; asc ;; 13: len 4; hex 80000000; asc ;; 14: len 4; hex 80000001; asc ;; 15: len 4; hex 302e3030; asc 0.00;; 16: len 3; hex 302e30; asc 0.0;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; 21: len 4; hex 302e3030; asc 0.00;; 22: len 4; hex 302e3135; asc 0.15;; 23: len 5; hex 302e303025; asc 0.00%;; 24: len 4; hex 80000000; asc ;; 25: len 4; hex 80000000; asc ;; 26: len 4; hex 80000000; asc ;; 27: len 4; hex 80000000; asc ;; 28: len 3; hex 302e30; asc 0.0;; 29: len 8; hex 8000124a40837176; asc J@ qv;; 30: len 8; hex 8000124a40900e24; asc J@ $;;
0: len 3; hex 853355; asc 3U;; 1: len 6; hex 00000005c3d7; asc ;; 2: len 7; hex 80000005b038c0; asc 8 ;; 3: len 3; hex 808d3a; asc :;; 4: len 3; hex 800001; asc ;; 5: len 3; hex 800001; asc ;; 6: SQL NULL; 7: len 6; hex e6b0b8e58f91; asc ;; 8: len 3; hex 302e30; asc 0.0;; 9: len 3; hex 302e30; asc 0.0;; 10: len 3; hex 322e30; asc 2.0;; 11: len 1; hex 37; asc 7;; 12: len 4; hex 80000000; asc ;; 13: len 4; hex 80000000; asc ;; 14: len 4; hex 80000001; asc ;; 15: len 4; hex 302e3030; asc 0.00;; 16: len 3; hex 302e30; asc 0.0;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; 21: len 4; hex 302e3030; asc 0.00;; 22: len 4; hex 302e3135; asc 0.15;; 23: len 5; hex 302e303025; asc 0.00%;; 24: len 4; hex 80000000; asc ;; 25: len 4; hex 80000000; asc ;; 26: len 4; hex 80000000; asc ;; 27: len 4; hex 80000000; asc ;; 28: len 3; hex 302e30; asc 0.0;; 29: len 8; hex 8000124a40837176; asc J@ qv;; 30: len 8; hex 8000124a40900e24; asc J@ $;;
Record lock, heap no 15 PHYSICAL RECORD: n_fields 31; compact format; info bits 0
0: len 3; hex 853356; asc 3V;; 1: len 6; hex 00000005c3d7; asc ;; 2: len 7; hex 80000005b038cc; asc 8 ;; 3: len 3; hex 808d62; asc b;; 4: len 3; hex 800001; asc ;; 5: len 3; hex 800001; asc ;; 6: SQL NULL; 7: len 9; hex e58fafe5be97e4bc98; asc ;; 8: len 3; hex 302e30; asc 0.0;; 9: len 3; hex 302e30; asc 0.0;; 10: len 3; hex 302e30; asc 0.0;; 11: len 1; hex 37; asc 7;; 12: len 4; hex 80000000; asc ;; 13: len 4; hex 80000000; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 4; hex 302e3030; asc 0.00;; 16: len 3; hex 302e30; asc 0.0;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; 21: len 4; hex 302e3030; asc 0.00;; 22: len 4; hex 302e3135; asc 0.15;; 23: len 5; hex 302e303025; asc 0.00%;; 24: len 4; hex 80000000; asc ;; 25: len 4; hex 80000000; asc ;; 26: len 4; hex 80000000; asc ;; 27: len 4; hex 80000000; asc ;; 28: len 3; hex 302e30; asc 0.0;; 29: len 8; hex 8000124a40837176; asc J@ qv;; 30: len 8; hex 8000124a40900e24; asc J@ $;;
0: len 3; hex 853356; asc 3V;; 1: len 6; hex 00000005c3d7; asc ;; 2: len 7; hex 80000005b038cc; asc 8 ;; 3: len 3; hex 808d62; asc b;; 4: len 3; hex 800001; asc ;; 5: len 3; hex 800001; asc ;; 6: SQL NULL; 7: len 9; hex e58fafe5be97e4bc98; asc ;; 8: len 3; hex 302e30; asc 0.0;; 9: len 3; hex 302e30; asc 0.0;; 10: len 3; hex 302e30; asc 0.0;; 11: len 1; hex 37; asc 7;; 12: len 4; hex 80000000; asc ;; 13: len 4; hex 80000000; asc ;; 14: len 4; hex 80000000; asc ;; 15: len 4; hex 302e3030; asc 0.00;; 16: len 3; hex 302e30; asc 0.0;; 17: SQL NULL; 18: SQL NULL; 19: SQL NULL; 20: SQL NULL; 21: len 4; hex 302e3030; asc 0.00;; 22: len 4; hex 302e3135; asc 0.15;; 23: len 5; hex 302e303025; asc 0.00%;; 24: len 4; hex 80000000; asc ;; 25: len 4; hex 80000000; asc ;; 26: len 4; hex 80000000; asc ;; 27: len 4; hex 80000000; asc ;; 28: len 3; hex 302e30; asc 0.0;; 29: len 8; hex 8000124a40837176; asc J@ qv;; 30: len 8; hex 8000124a40900e24; asc J@ $;;
開啟：
mysql> use marketing
Database changed
mysql>
mysql> create table innodb_lock_monitor(x int) engine=innodb;
Query OK, 0 rows affected (0.08 sec)
mysql> exit
Bye
關閉：
mysql> use marketing
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> drop table innodb_lock_monitor;
Query OK, 0 rows affected (0.02 sec)
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/758322/viewspace-692630/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- MySQL解決死鎖MySql
- MySQL 死鎖解決MySql
- 面試：什麼是死鎖，如何避免或解決死鎖；MySQL中的死鎖現象，MySQL死鎖如何解決面試MySql
- MySQL死鎖分析與解決之路MySql
- mysql慢查詢，死鎖解決方案MySql
- Mysql使用kill命令解決死鎖問題MySql
- 手把手教你分析解決MySQL死鎖問題MySql
- MySQL 死鎖和鎖等待MySql
- MySQL死鎖問題MySql
- 什麼是死鎖？如何解決死鎖？
- 解決Oracle死鎖問題步驟Oracle
- MySQL死鎖系列-線上死鎖問題排查思路MySql
- Mysql 兩階段鎖和死鎖MySql
- mysql行鎖和死鎖檢測MySql
- MySQL併發時經典常見的死鎖原因及解決方法MySql
- mysql死鎖最佳化MySql
- Mysql如何處理死鎖MySql
- MySQL列印死鎖日誌MySql
- MySQL：死鎖一例MySql
- MySQL 死鎖問題分析MySql
- MySQL：MTS和mysqldump死鎖MySql
- 【MySQL】死鎖案例之六MySql
- 【MySQL】死鎖案例之七MySql
- 【MySQL】死鎖案例之八MySql
- MySQL：一個死鎖分析 (未分析出來的死鎖)MySql
- MySQL鎖等待與死鎖問題分析MySql
- 例項詳解 Java 死鎖與破解死鎖Java
- MySQL insert on duplicate key update 死鎖MySql
- 故障分析 | MySQL死鎖案例分析MySql
- MySQL:Innodb 一個死鎖案例MySql
- MySQL批量更新死鎖案例分析MySql
- MySQL死鎖案例一（回滾導致死鎖）MySql
- MySQL死鎖案例二（自增列導致死鎖）MySql
- 常見的死鎖情況及解決方法
- 剖析6個MySQL死鎖案例的原因以及死鎖預防策略MySql
- SQL SERVER死鎖查詢，死鎖分析，解鎖，查詢佔用SQLServer
- MySQL強人“鎖”難《死磕MySQL系列 三》MySql
- MySQL死鎖系列-常見加鎖場景分析MySql
- MySQL的index merge(索引合併）導致資料庫死鎖分析與解決方案MySqlIndex索引資料庫