*** (2) TRANSACTION:
TRANSACTION 6286508067, ACTIVE 0 sec updating or deleting, thread declared inside InnoDB 4980
mysql tables in use 1, locked 1
12 lock struct(s), heap size 1136, 22 row lock(s), undo log entries 3
MySQL thread id 189619144, OS thread handle 140620050204416, query id 1148803197 10.200.17.37 pt_user updating
UPDATE `user_feed_26` SET `notification` = '1' , `mtime` = '2020-10-03 09:11:11' WHERE `user_id` = '2000000126212250' AND `action` in ( 'deal','price_changed','ting_shou','house_new_picture','house_new_vr','price_changed_rise','on_shelf_again') AND `notification` = '0'
*** (2) HOLDS THE LOCK(S):
RECORD LOCKS space id 2229 page no 263938 n bits 264 index idx_user_id of table `lianjia_user_feed`.`user_feed_26` trx id 6286508067 lock_mode X locks gap before rec
Record lock, heap no 83 PHYSICAL RECORD: n_fields 5; compact format; info bits 0
0: len 8; hex 80071afd5112d89a; asc Q ;;
1: len 4; hex 6465616c; asc deal;;
2: len 1; hex 81; asc ;;
3: len 12; hex 313034313032363731333238; asc 104102671328;;
4: len 4; hex 95e14632; asc F2;;
Record lock, heap no 93 PHYSICAL RECORD: n_fields 5; compact format; info bits 0
0: len 8; hex 80071afd5112d89a; asc Q ;;
1: len 14; hex 6f6e5f7368656c665f616761696e; asc on_shelf_again;;
2: len 1; hex 81; asc ;;
3: len 12; hex 313034313033373433363737; asc 104103743677;;
4: len 4; hex 95f12ab5; asc * ;;
*** 省略……
*** (2) WAITING FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 2229 page no 263938 n bits 264 index idx_user_id of table `lianjia_user_feed`.`user_feed_26` trx id 6286508067 lock_mode X locks gap before rec insert intention waiting
Record lock, heap no 87 PHYSICAL RECORD: n_fields 5; compact format; info bits 32
0: len 8; hex 80071afd5112d89a; asc Q ;;
1: len 15; hex 64697374726963745f7765656b6c79; asc district_weekly;;
2: len 1; hex 80; asc ;;
3: len 8; hex 3233303038373831; asc 23008781;;
4: len 4; hex 95f63035; asc 05;;