# 通过连接线程ID找SQL线程语句
select * from performance_schema.threads
where
PROCESSLIST_COMMAND != 'Sleep'
and PROCESSLIST_DB = 'test_zhcxkj_center_mercado'
and PROCESSLIST_STATE like '%lock%'
数据库查找死锁的sql
最新推荐文章于 2024-11-08 18:30:00 发布
# 通过连接线程ID找SQL线程语句
select * from performance_schema.threads
where
PROCESSLIST_COMMAND != 'Sleep'
and PROCESSLIST_DB = 'test_zhcxkj_center_mercado'
and PROCESSLIST_STATE like '%lock%'
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
344
