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