MySql数据库修改表结构或加字段的时候,容易导致表锁死挂起,可以在MySql workbench页面通过下面几条简单的语句: 1.检查被占用的表: show OPEN TABLES where In_use > 0; 2.显示进程: show processlist; 3.杀死挂起的进程即导致表锁死的进程: kill 17909;---17909是进程的id
-- 超过60秒sql SELECT id,`USER`,`host`,DB,command,`time`,state,info FROM information_schema.PROCESSLIST WHERE TIME>=60; 或者 SELECT id,`USER`,`host`,DB,command,`time`,state,info FROM information_schema.P
3月3日下午,系统发生了严重故障,后台程序大量抛出如下异常: DBCP object created 2011-03-03 12:35:19 by the following code was never closed:java.lang.Exception at org.apache.commons.dbcp.AbandonedTrace.setStackTrace(Aban