MYSQL数据库锁常用sql(解决锁表,锁库)
— 查询数据库锁
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
— 查看等待锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
— 执行中的 解决sql锁表
SELECT * from information_schema.INNODB_TRX
kill trx_mysql_thread_id
MYSQL数据库锁常用sql(解决锁表,锁库)
— 查询数据库锁
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCKS;
— 查看等待锁的事务
SELECT * FROM INFORMATION_SCHEMA.INNODB_LOCK_WAITS;
— 执行中的 解决sql锁表
SELECT * from information_schema.INNODB_TRX
kill trx_mysql_thread_id