mysql 线程id_查找MySQL线程中死锁的ID的方法

mysql> use test; Readingtable informationfor completionof table and column names You can turnoff this featureto get a quicker startupwith -A Database changed mysql>select @@autocommit; +————–+ | @@autocommit | +————–+ |      1 | +————–+ 1 rowin set (0.00 sec) mysql>update t3set birthday='2018-01-03' where id = 19; ERROR 1205 (HY000): Lock wait timeout exceeded; try restartingtransaction mysql>select connection_id(); +—————–+ | connection_id() | +—————–+ |       17 | +—————–+ 1 rowin set (0.00 sec) mysql> show processlist; +—-+——+———–+——+———+——+——-+——————+ | Id |User | Host   | db  | Command |Time | State | Info       | +—-+——+———–+——+———+——+——-+——————+ | 10 | root | localhost |NULL | Sleep  | 1540 |    |NULL       | | 11 | root | localhost |NULL | Sleep  | 722 |    |NULL       | | 16 | root | localhost | test | Sleep  | 424 |    |NULL       | | 17 | root | localhost | test | Query  |  0 | init | show processlist | | 18 | root | localhost |NULL | Sleep  |  5 |    |NULL       | +—-+——+———–+——+———+——+——-+——————+ 5rows in set (0.00 sec) mysql> show engine innodb status\G ———— TRANSACTIONS ———— Trx id counter 189327 Purge donefor trx's n:o < 189323 undo n:o < 0 state: running but idle History list length 343 LIST OF TRANSACTIONS FOR EACH SESSION: —TRANSACTION 0, not started MySQL thread id 11, OS thread handle 0x7f70a0c98700, query id 994 localhost root init show engine innodb status —TRANSACTION 189326, ACTIVE 2 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 376, 1 row lock(s) MySQL thread id 17, OS thread handle 0x7f70a0bd5700, query id 993 localhost root updating update t3 set birthday='2018-01-03' where id = 19 ——- TRX HAS BEEN WAITING 2 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 529 page no 3 n bits 72 index `PRIMARY` of table `test`.`t3` trx id 189326 lock_mode X waiting Record lock, heap no 2 PHYSICAL RECORD: n_fields 9; compact format; info bits 0 0: len 2; hex 3139; asc 19;; 1: len 6; hex 00000002e38c; asc    ;; 2: len 7; hex 7e00000d2827c9; asc ~  (' ;; 3: len 6; hex 6c696c793139;asc lily19;; 4: len 6; hex 6c7563793139;asc lucy19;; 5: len 3; hex 8fcc57;asc  W;; 6: len 4; hex 80000013;asc   ;; 7: len 4; hex 80000000;asc   ;; 8: len 4; hex 80000000;asc   ;; —————— —TRANSACTION 189324, ACTIVE 641 sec 2 lock struct(s), heapsize 376, 3 row lock(s), undo log entries 1 MySQL thread id 16, OS thread handle 0x7f70a0b94700, query id 985 localhost root cleaning up Trxread view willnot see trxwith id >= 189325, sees < 189325