mysql-运维命令

荆茗Scaler

于 2024-08-30 19:11:45 发布

阅读量119

点赞数 3

文章标签： mysql 数据库

本文链接：https://blog.csdn.net/jll126/article/details/133136151

版权

1.锁表快速杀进程

SELECT concat('KILL ',id,';')  FROM information_schema.processlist p INNER JOIN  information_schema.INNODB_TRX x ON p.id=x.trx_mysql_thread_id WHERE db='ctcdm';

2.查看数据库的锁

SELECT * FROM information_schema.INNODB_LOCKS;

3.查询锁的等待情况

SELECT
r.trx_id AS waiting_trx_id,
r.trx_mysql_thread_id AS waiting_thread,
r.trx_query AS waiting_query,
b.trx_id AS blocking_trx_id,
b.trx_mysql_thread_id AS blocking_thread,
b.trx_query AS blocking_query
FROM
information_schema.innodb_lock_waits w
INNER JOIN
information_schema.innodb_trx b ON b.trx_id = w.blocking_trx_id
INNER JOIN
information_schema.innodb_trx r ON r.trx_id = w.requesting_trx_id;