摘要:
##查看被锁的表show OPEN TABLES where In_use > 0 ##查看被锁的表的进程; show processlist; ##杀死进程 杀死进程(就是[show processlist;]命令的id列) kill 12641; select * from sys.innodb 阅读全文
摘要:
查死锁 select CONVERT(VARCHAR(100), request_session_id) spid ,OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_ 阅读全文