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

 

posted @ 2022-02-15 16:56  屠魔的少年  阅读(6)  评论(0)    收藏  举报