mysql> SELECT cc.* FROM t_channel_chatbot cc LEFT JOIN t_channel c ON cc.manage_id = c.id WHERE acct_id = '1' AND channel_name = '北京电信' FOR UPDATE;
---TRANSACTION 2564179, ACTIVE 9 sec 8 LOCK struct(s), heap SIZE 1136, 10 ROW LOCK(s) MySQL thread id 451036, OS thread handle 140481624741632, query id 9707877 10.10.133.115 root starting SHOW engine innodb STATUS TABLE LOCK TABLE `lock_test`.`t_channel` trx id 2564179 LOCK mode IX RECORD LOCKS SPACE id 7958 page no 5 n bits 80 INDEX idx_name OF TABLE `lock_test`.`t_channel` trx id 2564179 lock_mode X Record LOCK, heap no 7 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 12; hex e58c97e4baace794b5e4bfa1; ASC ;; 1: len 4; hex 80000008; ASC ;; RECORD LOCKS SPACE id 7958 page no 3 n bits 80 INDEX PRIMARY OF TABLE `lock_test`.`t_channel` trx id 2564179 lock_mode X locks rec but NOT gap Record LOCK, heap no 9 PHYSICAL RECORD: n_fields 10; compact format; info bits 0 0: len 4; hex 80000008; ASC ;; 1: len 6; hex 0000002496f0; ASC $ ;; 2: len 7; hex a300000419016b; ASC k;; 3: len 12; hex 6368696e6174656c65636f6d; ASC chinatelecom;; 4: len 12; hex e58c97e4baace794b5e4bfa1; ASC ;; 5: len 4; hex 80000000; ASC ;; 6: len 4; hex 80000000; ASC ;; 7: len 5; hex 99a934e86b; ASC 4 k;; 8: len 5; hex 99a934e86d; ASC 4 m;; 9: SQL NULL; TABLE LOCK TABLE `lock_test`.`t_channel_chatbot` trx id 2564179 LOCK mode IX RECORD LOCKS SPACE id 7970 page no 4 n bits 152 INDEX idx_chatbot OF TABLE `lock_test`.`t_channel_chatbot` trx id 2564179 lock_mode X Record LOCK, heap no 38 PHYSICAL RECORD: n_fields 3; compact format; info bits 0 0: len 8; hex 8000000000000008; ASC ;; 1: len 15; hex 313235323030343031313131303237; ASC 125200401111027;; 2: len 8; hex 8000000000000008; ASC ;; Record LOCK, heap no 83 PHYSICAL RECORD: n_fields 3; compact format; info bits 0 0: len 8; hex 8000000000000008; ASC ;; 1: len 30; hex 336432613336333966303964343436353936346337616164333437653131; ASC 3d2a3639f09d4465964c7aad347e11; (total 32 bytes); 2: len 8; hex 800000000000000b; ASC ;; Record LOCK, heap no 84 PHYSICAL RECORD: n_fields 3; compact format; info bits 0 0: len 8; hex 8000000000000008; ASC ;; 1: len 16; hex 31323532303034303131313131383134; ASC 1252004011111814;; 2: len 8; hex 8000000000000005; ASC ;; RECORD LOCKS SPACE id 7970 page no 3 n bits 168 INDEX PRIMARY OF TABLE `lock_test`.`t_channel_chatbot` trx id 2564179 lock_mode X locks rec but NOT gap Record LOCK, heap no 93 PHYSICAL RECORD: n_fields 14; compact format; info bits 0 0: len 8; hex 8000000000000005; ASC ;; 1: len 6; hex 000000271d9d; ASC ' ;; 2: len 7; hex 23000004311fce; asc # 1 ;; 3: len 8; hex 8000000000000008; asc ;; 4: len 1; hex 31; asc 1;; 5: len 16; hex 31323532303034303131313131383134; asc 1252004011111814;; 6: len 30; hex e4b8ade59bbde993b6e8a18ce6a087e58786e68ea5e58fa32d6874747020; asc -http ; (total 36 bytes); 7: len 4; hex 48545450; asc HTTP;; 8: len 7; hex 74656c65636f6d; asc telecom;; 9: len 4; hex 80000009; asc ;; 10: len 4; hex 80000000; asc ;; 11: len 5; hex 99a8acfc36; asc 6;; 12: len 5; hex 99acb30a90; asc ;; 13: len 1; hex 80; asc ;; Record lock, heap no 94 PHYSICAL RECORD: n_fields 14; compact format; info bits 0 0: len 8; hex 8000000000000008; asc ;; 1: len 6; hex 000000271da3; asc ' ;; 2: len 7; hex 260000040d2ce4; ASC & , ;; 3: len 8; hex 8000000000000008; ASC ;; 4: len 1; hex 32; ASC 2;; 5: len 15; hex 313235323030343031313131303237; ASC 125200401111027;; 6: len 30; hex e5b7a5e993b6e7919ee4bfa1e6a087e58786e68ea5e58fa32d6874747020; ASC -http ; (total 36 bytes); 7: len 4; hex 48545450; ASC HTTP;; 8: len 7; hex 74656c65636f6d; ASC telecom;; 9: len 4; hex 80000009; ASC ;; 10: len 4; hex 80000001; ASC ;; 11: len 5; hex 99a8acfc35; ASC 5;; 12: len 5; hex 99acb30a9c; ASC ;; 13: len 1; hex 80; ASC ;; Record LOCK, heap no 95 PHYSICAL RECORD: n_fields 14; compact format; info bits 0 0: len 8; hex 800000000000000b; ASC ;; 1: len 6; hex 000000271d98; ASC ' ;; 2: len 7; hex 0000000f3c2e68; asc <.h;; 3: len 8; hex 8000000000000008; asc ;; 4: len 1; hex 33; asc 3;; 5: len 30; hex 336432613336333966303964343436353936346337616164333437653131; asc 3d2a3639f09d4465964c7aad347e11; (total 32 bytes); 6: len 30; hex e68b9be59586e993b6e8a18ce6a087e58786e68ea5e58fa32d6874747020; asc -http ; (total 36 bytes); 7: len 4; hex 48545450; asc HTTP;; 8: len 7; hex 74656c65636f6d; asc telecom;; 9: len 4; hex 80000009; asc ;; 10: len 4; hex 80000000; asc ;; 11: len 5; hex 99a830bed5; asc 0 ;; 12: len 5; hex 99acb30a6d; asc m;; 13: len 1; hex 80; asc ;; RECORD LOCKS space id 7970 page no 4 n bits 152 index idx_chatbot of table `lock_test`.`t_channel_chatbot` trx id 2564179 lock_mode X locks gap before rec Record lock, heap no 51 PHYSICAL RECORD: n_fields 3; compact format; info bits 0 0: len 8; hex 8000000000000009; asc ;; 1: len 15; hex 313235323030343031313131303330; asc 125200401111030;; 2: len 8; hex 800000000000000e; asc ;; RECORD LOCKS space id 7958 page no 5 n bits 80 index idx_name of table `lock_test`.`t_channel` trx id 2564179 lock_mode X locks gap before rec Record lock, heap no 8 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 12; hex e59b9be5b79de88194e9809a; asc ;; 1: len 4; hex 80000003; asc ;;