msyql 锁等待 解决方案

1.JAVA代码

<span style="font-size:18px;">@Transactional(propagation=Propagation.SUPPORTS)public void batchUpdate(String tablename, final String[] val, final String[] obj, final List<Map> list) {StringBuffer sql = new StringBuffer("UPDATE " + tablename + " SET ");for(String value : val){sql.append(value + " = ?, ");}</span>

2.MYSQL设置

 2.1 /etc/my.cnf

set global innodb_lock_wait_timeout = 50;

都是先用 show PROCESSLIST然后kill sleep的进程