29.超过5秒未提交的用户连接

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_QUERY
FROM INFORMATION_SCHEMA.INNODB_TRX trx
JOIN INFORMATION_SCHEMA.processlist pcl ON trx.trx_mysql_thread_id=pcl.id
WHERE trx_mysql_thread_id != connection_id()
AND TO_SECONDS(now())-TO_SECONDS(trx_started) >= 5 ;