2023年4月3日

摘要: SELECT locked_table, locked_index, locked_type, blocking_pid, concat(T2.USER,'@',T2.HOST) AS "blocking(user@ip:port)", blocking_lock_mode, blocking_tr 阅读全文
posted @ 2023-04-03 10:51 zhangdapangzi 阅读(12) 评论(0) 推荐(0) 编辑
 
摘要: SELECT trx_mysql_thread_id AS PROCESSLIST_ID, NOW(), TRX_STARTED, TO_SECONDS(now())-TO_SECONDS(trx_started) AS TRX_LAST_TIME , USER, HOST, DB, TRX_QUE 阅读全文
posted @ 2023-04-03 10:48 zhangdapangzi 阅读(12) 评论(0) 推荐(0) 编辑