Guest User

Untitled

a guest
Oct 18th, 2018
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. SELECT
  2. EVENT_ID,
  3. TRUNCATE(TIMER_WAIT / 1000000000000, 6) AS Duration,
  4. SQL_TEXT
  5. FROM performance_schema.events_statements_history_long
  6. WHERE SQL_TEXT LIKE '%UNIQUE_THING%';
  7.  
  8. SELECT
  9. sum(TRUNCATE(TIMER_WAIT / 1000000000000, 6)) AS total
  10. FROM performance_schema.events_stages_history_long
  11. WHERE NESTING_EVENT_ID = 13348585;
  12.  
  13. SELECT sum(TRUNCATE(TIMER_WAIT / 1000000000000, 6)) AS total
  14. FROM performance_schema.events_waits_history_long
  15. WHERE NESTING_EVENT_ID = 13348585;
Add Comment
Please, Sign In to add comment