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的进程