[MySQL] Mysql事物锁等待超时Lock wait timeout exceeded;的解决

• 问题场景
  
• 原因分析
  
• 解决方案
  
• 参考信息
  

org.springframework.dao.CannotAcquireLockException: 
### Error updating database.  Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
### The error may involve com.*.dao.mapper.PhoneFlowMapper.updateByPrimaryKeySelective-Inline
### The error occurred while setting parameters
### SQL:-----后面为SQL语句及堆栈信息--------

select * from information_schema.innodb_trx

innodb_lock_wait_timeout=500

InnoDB automatically detects transaction deadlocks and rolls back a transaction or transactions to break the deadlock. InnoDB tries to pick small transactions to roll back, where the size of a transaction is determined by the number of rows inserted, updated, or deleted.