Public Pastes
SHARE
TWEET

Untitled

a guest Oct 11th, 2011 47 Never
  1. Reading mysql slow query log from /var/log/mysql/mysql-slow.log
  2. Count: 10  Time=23.45s (234s)  Lock=1.99s (19s)  Rows=505.2 (5052), rick[rick]@[192.168.180.68]
  3.   SELECT author_id, topic_id FROM posts WHERE  queued=N  AND author_id=N AND topic_id IN(N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N)
  4.  
  5. Count: 2  Time=17.16s (34s)  Lock=0.00s (0s)  Rows=11.0 (22), rick[rick]@[192.168.180.68]
  6.   SELECT p.pid as id, p.post_date, p.topic_id,t.title, t.posts, t.views FROM posts p  LEFT JOIN topics t ON ( t.tid=p.topic_id )   WHERE t.forum_id IN (N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N) AND t.tid=N AND  p.queued=N  AND  t.approved=N  AND MATCH( p.post ) AGAINST( 'S' IN BOOLEAN MODE ) AND t.state != 'S' ORDER BY post_date desc LIMIT N,N
  7.  
  8. Count: 24  Time=15.95s (382s)  Lock=0.00s (0s)  Rows=653.5 (15683), rick[rick]@[192.168.180.68]
  9.   SELECT author_id, topic_id FROM posts WHERE  queued=N  AND author_id=N AND post_date > N AND topic_id IN(N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N)
  10.  
  11. Count: 1  Time=14.63s (14s)  Lock=0.00s (0s)  Rows=588.0 (588), rick[rick]@[192.168.180.68]
  12.   SELECT author_id, topic_id FROM posts WHERE  queued=N  AND author_id=N AND topic_id IN(N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N)
  13.  
  14. Count: 1  Time=12.45s (12s)  Lock=0.00s (0s)  Rows=1.0 (1), rick[rick]@[192.168.180.68]
  15.   SELECT count(*) as cnt FROM attachments a  LEFT JOIN posts p ON ( p.pid=a.attach_rel_id )   WHERE a.attach_rel_module='S' AND p.topic_id=N
  16.  
RAW Paste Data
Top