Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $ egrep -B4 '38.19|80.65|26.13|18.36|18.18' mysqld-slow-queries.log
- SET timestamp=1411407705;
- 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;
- # Time: 140922 10:42:11
- # User@Host: root[root] @ localhost [127.0.0.1]
- # Query_time: 80.655094 Lock_time: 0.000059 Rows_sent: 511 Rows_examined: 511
- --
- SET timestamp=1411407530;
- SELECT /*!40001 SQL_NO_CACHE */ * FROM `eps_prop_rates`;
- # Time: 140922 10:39:47
- # User@Host: root[root] @ localhost [127.0.0.1]
- # Query_time: 38.197007 Lock_time: 0.000045 Rows_sent: 13002 Rows_examined: 13002
- --
- SET timestamp=1411407903;
- SET SESSION character_set_results = 'binary';
- # Time: 140922 10:45:04
- # User@Host: coeus[coeus] @ localhost [127.0.0.1]
- # Query_time: 26.133218 Lock_time: 23.516140 Rows_sent: 0 Rows_examined: 2
- --
- SET timestamp=1411407844;
- SET autocommit=1;
- # Time: 140922 10:44:05
- # User@Host: root[root] @ localhost [127.0.0.1]
- # Query_time: 18.369883 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
- --
- SET timestamp=1411407874;
- SET SQL_SELECT_LIMIT=5;
- # Time: 140922 10:44:39
- # User@Host: root[root] @ localhost [127.0.0.1]
- # Query_time: 18.187640 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement