查询超过InnoDB cluster中设置事物大小的那些失败的事物
-- 查询超过InnoDB cluster中设置事物大小的那些失败的事物 select t.THREAD_ID, p.PROCESSLIST_ID, p.PROCESSLIST_USER USER, p.PROCESSLIST_HOST HOST, p.PROCESSLIST_DB DB, t.STATE, s.EVENT_NAME, s.SQL_TEXT, s.TIMER_WAIT, s.ROWS_SENT, s.ROWS_EXAMINED, sys.format_time(s.timer_wait) SQL_DURATION from performance_schema.events_transactions_history t inner join performance_schema.events_statements_history s inner join performance_schema.threads p where t.thread_id = s.thread_id and t.thread_id = p.thread_id and t.event_id = s.NESTING_EVENT_ID and t.state = 'ROLLED BACK' order by s.event_id;