FUDforum: Bug Reports » slow mysql query

Home » FUDforum Development » Bug Reports » slow mysql query (may not be a bug......)

Show: Today's Messages :: Polls :: Message Navigator

slow mysql query [message #166476]

Mon, 19 December 2011 21:23

andy_scouser
Messages: 76
Registered: June 2003

Karma:

Member

Hi there.

I upgraded the forum today to 3.0.3 and am now experiencing a noticeable slow down when ever a message is selected. My mysql-slow.log is reporting lots of the same errors.

I wonder if you could offer any guidance please?

# Time: 111219 23:17:31
# User@Host: honda[honda] @ localhost []
# Query_time: 14 Lock_time: 0 Rows_sent: 7 Rows_examined: 252391
SELECT
m.*, COALESCE(m.flag_cc, u.flag_cc) AS disp_flag_cc, COALESCE(m.flag_country, u.flag_country) AS disp_flag_country,
t.thread_opt, t.root_msg_id, t.last_post_id, t.forum_id,
f.message_threshold,
u.id AS user_id, u.alias AS login, u.avatar_loc, u.email, u.posted_msg_count, u.join_date, u.location,
u.sig, u.custom_status, u.icq, u.jabber, u.affero, u.aim, u.msnm, u.yahoo, u.google, u.skype, u.twitter, u.users_opt, u.last_
visit AS time_sec,
l.name AS level_name, l.level_opt, l.img AS level_img,
p.max_votes, p.expiry_date, p.creation_date, p.name AS poll_name, p.total_votes,
1 AS cant_vote
FROM forum_msg m
INNER JOIN forum_thread t ON m.thread_id=t.id
INNER JOIN forum_forum f ON t.forum_id=f.id
LEFT JOIN forum_users u ON m.poster_id=u.id
LEFT JOIN forum_level l ON u.level_id=l.id
LEFT JOIN forum_poll p ON m.poll_id=p.id WHERE m.thread_id=16286 AND m.apr=1 ORDER BY m.id ASC LIMIT 20 OFFSET 0;

Report message to a moderator

[Message index]

		slow mysql query By: andy_scouser on Mon, 19 December 2011 21:23
		Re: slow mysql query By: naudefj on Tue, 20 December 2011 02:37
		Re: slow mysql query By: andy_scouser on Wed, 21 December 2011 06:44
		Re: slow mysql query By: andy_scouser on Wed, 21 December 2011 12:27

Previous Topic:	Avatar Approval
Next Topic:	Bug with display of date in Russian

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 04:41:17 GMT 2024

Total time taken to generate the page: 0.05619 seconds