atzqtzq的博客

//1.查询表锁，发现无锁定的表show OPEN TABLES where In_use > 0;//2.但执行拿锁的sql时，却提示超时select *From test where id=231 for update;//3.直接查询正在执行的事务SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;//发现有一个，kill线程kill 141148...

1.sqlserver2.mysql