1. 查询存在的进程:show processlist;
2. 查询是否有锁表:show OPEN TABLES where In_use > 0;
3. 查看被锁住的: SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
4. 等待锁定: SELECT * FROM INFORMATION_SCHEMA.IN NODB_LOCK_WAITS;
5. 显示最大连接数: SHOW status like 'Max_used_connections'; show variables like '%max_connections%';
set global max_connections=500