Tweet
Had none of these before upgrade any ideas?
A bunch of slow queries since upgrading to 3.8.4 p1:
A bunch of slow queries since upgrading to 3.8.4 p1:
# Time: 091017 23:52:40
# Query_time: 16 Lock_time: 0 Rows_sent: 5 Rows_examined: 10
SELECT thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, thread.lastpostid, pollid, thread.forumid, thread.open, sticky
, post.pagetext AS preview, thread.attach
FROM thread as thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
WHERE open != 10
AND thread.visible = 1 AND thread.lastpost > 1255762342
AND thread.forumid NOT IN(263,116,115,21,54,175,57,31,15,29,220,159)
ORDER BY lastpost DESC
LIMIT 5;
# Query_time: 9 Lock_time: 0 Rows_sent: 4 Rows_examined: 8
SELECT post.postid
FROM post AS post
WHERE post.threadid = 1738
AND post.visible = 1
ORDER BY post.dateline
LIMIT 0, 15;
# Query_time: 15 Lock_time: 0 Rows_sent: 8 Rows_examined: 16
SELECT post.postid
FROM post AS post
WHERE post.threadid = 87647
AND post.visible = 1
ORDER BY post.dateline
LIMIT 0, 15;
# Query_time: 9 Lock_time: 0 Rows_sent: 9 Rows_examined: 18
SELECT post.postid
FROM post AS post
WHERE post.threadid = 109982
AND post.visible = 1
ORDER BY post.dateline
LIMIT 0, 15;
# Query_time: 7 Lock_time: 0 Rows_sent: 10 Rows_examined: 109
SELECT thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, thread.lastpostid, pollid, thread.forumid, thread.open, sticky
, post.pagetext AS preview, thread.attach
FROM thread as thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
WHERE open != 10
AND thread.visible = 1 AND thread.lastpost > 1255762342
AND thread.forumid NOT IN(263,116,115,21,54,175,57,31,15,29,220,159)
ORDER BY views DESC
LIMIT 10;
# Query_time: 3 Lock_time: 0 Rows_sent: 14 Rows_examined: 28
SELECT post.postid
FROM post AS post
WHERE post.threadid = 108687
AND post.visible = 1
ORDER BY post.dateline
LIMIT 0, 15;
# Query_time: 20 Lock_time: 0 Rows_sent: 15 Rows_examined: 33
SELECT post.postid
FROM post AS post
WHERE post.threadid = 112295
AND post.visible = 1
ORDER BY post.dateline
LIMIT 0, 15;
# Query_time: 7 Lock_time: 0 Rows_sent: 10 Rows_examined: 109
SELECT thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, thread.lastpostid, pollid, thread.forumid, thread.open, sticky
, post.pagetext AS preview, thread.attach
FROM thread as thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
WHERE open != 10
AND thread.visible = 1 AND thread.lastpost > 1255762348
AND thread.forumid NOT IN(263,116,115,21,54,175,57,31,15,29,220,159)
ORDER BY views DESC
LIMIT 10;
# Query_time: 12 Lock_time: 0 Rows_sent: 3 Rows_examined: 36
SELECT post.postid
FROM post AS post
WHERE post.threadid = 61728
AND post.visible = 1
ORDER BY post.dateline
LIMIT 15, 15;
# Query_time: 9 Lock_time: 0 Rows_sent: 15 Rows_examined: 33
SELECT post.postid
FROM post AS post
WHERE post.threadid = 5717
AND post.visible = 1
ORDER BY post.dateline
LIMIT 0, 15;
# Query_time: 12 Lock_time: 0 Rows_sent: 15 Rows_examined: 31
SELECT post.postid
FROM post AS post
WHERE post.threadid = 77404
AND post.visible = 1
ORDER BY post.dateline
LIMIT 0, 15;
# Time: 091017 23:53:29
# Query_time: 9 Lock_time: 0 Rows_sent: 15 Rows_examined: 1179
SELECT post.postid
FROM post AS post
WHERE post.threadid = 47663
AND post.visible = 1
ORDER BY post.dateline
LIMIT 15, 15;
# Time: 091017 23:53:53
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 32
SELECT post.postid
FROM post AS post
WHERE post.threadid = 103815
AND post.visible = 1
ORDER BY post.dateline
LIMIT 15, 15;
# Time: 091017 23:53:56
# Query_time: 3 Lock_time: 0 Rows_sent: 7 Rows_examined: 14
SELECT post.postid
FROM post AS post
WHERE post.threadid = 104182
AND post.visible = 1
ORDER BY post.dateline
LIMIT 0, 15;
# Time: 091017 23:53:59
# Query_time: 4 Lock_time: 0 Rows_sent: 2 Rows_examined: 4
SELECT post.postid
FROM post AS post
WHERE post.threadid = 55063
AND post.visible = 1
ORDER BY post.dateline
LIMIT 0, 15;
# Query_time: 16 Lock_time: 0 Rows_sent: 5 Rows_examined: 10
SELECT thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, thread.lastpostid, pollid, thread.forumid, thread.open, sticky
, post.pagetext AS preview, thread.attach
FROM thread as thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
WHERE open != 10
AND thread.visible = 1 AND thread.lastpost > 1255762342
AND thread.forumid NOT IN(263,116,115,21,54,175,57,31,15,29,220,159)
ORDER BY lastpost DESC
LIMIT 5;
# Query_time: 9 Lock_time: 0 Rows_sent: 4 Rows_examined: 8
SELECT post.postid
FROM post AS post
WHERE post.threadid = 1738
AND post.visible = 1
ORDER BY post.dateline
LIMIT 0, 15;
# Query_time: 15 Lock_time: 0 Rows_sent: 8 Rows_examined: 16
SELECT post.postid
FROM post AS post
WHERE post.threadid = 87647
AND post.visible = 1
ORDER BY post.dateline
LIMIT 0, 15;
# Query_time: 9 Lock_time: 0 Rows_sent: 9 Rows_examined: 18
SELECT post.postid
FROM post AS post
WHERE post.threadid = 109982
AND post.visible = 1
ORDER BY post.dateline
LIMIT 0, 15;
# Query_time: 7 Lock_time: 0 Rows_sent: 10 Rows_examined: 109
SELECT thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, thread.lastpostid, pollid, thread.forumid, thread.open, sticky
, post.pagetext AS preview, thread.attach
FROM thread as thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
WHERE open != 10
AND thread.visible = 1 AND thread.lastpost > 1255762342
AND thread.forumid NOT IN(263,116,115,21,54,175,57,31,15,29,220,159)
ORDER BY views DESC
LIMIT 10;
# Query_time: 3 Lock_time: 0 Rows_sent: 14 Rows_examined: 28
SELECT post.postid
FROM post AS post
WHERE post.threadid = 108687
AND post.visible = 1
ORDER BY post.dateline
LIMIT 0, 15;
# Query_time: 20 Lock_time: 0 Rows_sent: 15 Rows_examined: 33
SELECT post.postid
FROM post AS post
WHERE post.threadid = 112295
AND post.visible = 1
ORDER BY post.dateline
LIMIT 0, 15;
# Query_time: 7 Lock_time: 0 Rows_sent: 10 Rows_examined: 109
SELECT thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, thread.lastpostid, pollid, thread.forumid, thread.open, sticky
, post.pagetext AS preview, thread.attach
FROM thread as thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
WHERE open != 10
AND thread.visible = 1 AND thread.lastpost > 1255762348
AND thread.forumid NOT IN(263,116,115,21,54,175,57,31,15,29,220,159)
ORDER BY views DESC
LIMIT 10;
# Query_time: 12 Lock_time: 0 Rows_sent: 3 Rows_examined: 36
SELECT post.postid
FROM post AS post
WHERE post.threadid = 61728
AND post.visible = 1
ORDER BY post.dateline
LIMIT 15, 15;
# Query_time: 9 Lock_time: 0 Rows_sent: 15 Rows_examined: 33
SELECT post.postid
FROM post AS post
WHERE post.threadid = 5717
AND post.visible = 1
ORDER BY post.dateline
LIMIT 0, 15;
# Query_time: 12 Lock_time: 0 Rows_sent: 15 Rows_examined: 31
SELECT post.postid
FROM post AS post
WHERE post.threadid = 77404
AND post.visible = 1
ORDER BY post.dateline
LIMIT 0, 15;
# Time: 091017 23:53:29
# Query_time: 9 Lock_time: 0 Rows_sent: 15 Rows_examined: 1179
SELECT post.postid
FROM post AS post
WHERE post.threadid = 47663
AND post.visible = 1
ORDER BY post.dateline
LIMIT 15, 15;
# Time: 091017 23:53:53
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 32
SELECT post.postid
FROM post AS post
WHERE post.threadid = 103815
AND post.visible = 1
ORDER BY post.dateline
LIMIT 15, 15;
# Time: 091017 23:53:56
# Query_time: 3 Lock_time: 0 Rows_sent: 7 Rows_examined: 14
SELECT post.postid
FROM post AS post
WHERE post.threadid = 104182
AND post.visible = 1
ORDER BY post.dateline
LIMIT 0, 15;
# Time: 091017 23:53:59
# Query_time: 4 Lock_time: 0 Rows_sent: 2 Rows_examined: 4
SELECT post.postid
FROM post AS post
WHERE post.threadid = 55063
AND post.visible = 1
ORDER BY post.dateline
LIMIT 0, 15;
Comment