暹罗猫的鱼

MySQL8.0.26配置文件my.ini详解。

#查询是否锁表show OPEN TABLES where In_use > 0;#查询进程show processlist#查询到相对应的进程===然后 kill id补充：#查看正在锁的事务SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS; #查看等待锁的事务SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;...