-- 查询超过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;