twollert
Active member
I switched from vBulletin 4.0.4 to XenForo 1.1.0 a week ago. Since the changeover I have some issues with the server latency and load average (see attachments). Sometimes it takes really long until a clicked page comes up and I also had some double postings from members because of that.
My provider told me that the reason are some slow querys (which are locking the tables):
Is there a way to fix that?
My provider told me that the reason are some slow querys (which are locking the tables):
Code:
2011-12-10 09:41:44 | dbXXXXXXXX[dbXXXXXXXX] @ local3 [127.0.0.3] |
00:00:13 | SELECT thread.*
,
user.*, IF(user.username IS
NULL, thread.username, user.username) AS username,
node.title AS node_title,
forum.*,
permission.cache_value AS
node_permission_cache
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id =
thread.user_id)
INNER JOIN xf_node AS node ON
(node.node_id =
thread.node_id)
INNER JOIN xf_forum AS forum ON
(forum.node_id =
thread.node_id)
LEFT JOIN xf_permission_cache_content AS
permission
ON
(permission.permission_combination_id = 1
AND
permission.content_type = 'node'
AND
permission.content_id = thread.node_id)
WHERE (forum.find_new = 1)
ORDER BY thread.last_post_date DESC
LIMIT 120
Is there a way to fix that?