锁现场快查
锁现场快查
SELECT ENGINE_TRANSACTION_ID, OBJECT_NAME, INDEX_NAME,
LOCK_TYPE, LOCK_MODE, LOCK_STATUS, LOCK_DATA
FROM performance_schema.data_locks
ORDER BY OBJECT_NAME;
SELECT * FROM performance_schema.data_lock_waits;字段解读
| 字段 | 含义 |
|---|---|
| LOCK_TYPE | TABLE / RECORD |
| LOCK_MODE | X / S / X,REC_NOT_GAP / X,GAP 等 |
| LOCK_DATA | 锁住的记录主键值（RECORD 时） |
| LOCK_STATUS | GRANTED / WAITING |
LOCK_DATA 显示主键值：配合业务查询即可知道「卡在谁的数据上」。