Mysql Innodb死锁解决

• 场景：在操作数据库的过程中，由于一些原因，如：事务未正常提交/回滚等造成数据库死锁，导致其他需要事务的操作出现锁等待超时的错误，Lock wait timeout exceeded; try restarting transaction。

• 查询数据库死锁的线程id：

  SELECT * FROM information_schema.INNODB_TRX\G

• 查询结果如下：

  mysql> SELECT * FROM information_schema.INNODB_TRX\G
  
  ************************** 1. row **************************
  
  trx_id: 189324
  
  trx_state: RUNNING
  
  trx_started: 2017-02-17 10:00:00
  
  trx_requested_lock_id: NULL
  
  trx_wait_started: NULL
  
  trx_weight: 3
  
  trx_mysql_thread_id: 5
  
  trx_query: NULL
  
  trx_operation_state: NULL
  
  trx_tables_in_use: 0
  
  trx_tables_locked: 0
  
  trx_lock_structs: 2
  
  trx_lock_memory_bytes: 376
  
  trx_rows_locked: 3
  
  trx_rows_modified: 1
  
  trx_concurrency_tickets: 0
  
  trx_isolation_level: REPEATABLE READ
  
  trx_unique_checks: 1
  
  trx_foreign_key_checks: 1
  
  trx_last_foreign_key_error: NULL
  
  trx_adaptive_hash_latched: 0
  
  trx_adaptive_hash_timeout: 10000
  
  trx_is_read_only: 0
  
  trx_autocommit_non_locking: 0
  
  1 row in set (0.01 sec)

• 杀掉死锁线程：

  kill 5;