请问tidb如何查锁、解锁？
感觉和mysql不太一样。
需要的就是这个语句 
SELECT
START_TIME,USER,DB,STATE,SESSION_ID,
SUBSTRING_INDEX(CURRENT_SQL_DIGEST_TEXT,' ',3) AS 'table_operator'
FROM information_schema.CLUSTER_TIDB_TRX
WHERE CURRENT_SQL_DIGEST_TEXT IS NOT NULL
AND STATE='LockWaiting'
ORDER BY DB,CURRENT_SQL_DIGEST_TEXT,START_TIME
1 个赞