Advertisement
Guest User

Untitled

a guest
Sep 22nd, 2014
201
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.36 KB | None | 0 0
  1. $ egrep -B4 '38.19|80.65|26.13|18.36|18.18' mysqld-slow-queries.log
  2.  
  3.  
  4. SET timestamp=1411407705;
  5. SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME, PRIORITY FROM KC_QRTZ_TRIGGERS WHERE TRIGGER_STATE = 'WAITING' AND NEXT_FIRE_TIME < 1411407730348 AND (NEXT_FIRE_TIME >= 1411407640425) ORDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC;
  6. # Time: 140922 10:42:11
  7. # User@Host: root[root] @ localhost [127.0.0.1]
  8. # Query_time: 80.655094 Lock_time: 0.000059 Rows_sent: 511 Rows_examined: 511
  9.  
  10. --
  11.  
  12. SET timestamp=1411407530;
  13. SELECT /*!40001 SQL_NO_CACHE */ * FROM `eps_prop_rates`;
  14. # Time: 140922 10:39:47
  15. # User@Host: root[root] @ localhost [127.0.0.1]
  16. # Query_time: 38.197007 Lock_time: 0.000045 Rows_sent: 13002 Rows_examined: 13002
  17.  
  18. --
  19.  
  20. SET timestamp=1411407903;
  21. SET SESSION character_set_results = 'binary';
  22. # Time: 140922 10:45:04
  23. # User@Host: coeus[coeus] @ localhost [127.0.0.1]
  24. # Query_time: 26.133218 Lock_time: 23.516140 Rows_sent: 0 Rows_examined: 2
  25.  
  26. --
  27.  
  28. SET timestamp=1411407844;
  29. SET autocommit=1;
  30. # Time: 140922 10:44:05
  31. # User@Host: root[root] @ localhost [127.0.0.1]
  32. # Query_time: 18.369883 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
  33. --
  34.  
  35. SET timestamp=1411407874;
  36. SET SQL_SELECT_LIMIT=5;
  37. # Time: 140922 10:44:39
  38. # User@Host: root[root] @ localhost [127.0.0.1]
  39. # Query_time: 18.187640 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement