sandokloud
Active member
Hi I have a problem with the server hosting it seems that the site where I have the script of xenforo forum causes an overload and makes almost inaccessible all sites knocking down the server for minutes, my hosting support asks if you can join support in the ticket to email for the resolution of the problem, alternatively seeing this code can you tell me what can be the solution to the problem? This query examines 1 million rows. thanks in advance.
# Time: 210510 13:03:30
# User@Host: example_example[example_example] @ localhost []
# Thread_id: 324 Schema: example_example QC_hit: No
# Query_time: 8.822642 Lock_time: 0.000053 Rows_sent: 20 Rows_examined: 1029714
# Rows_affected: 0 Bytes_sent: 22425
use example_example;
SET timestamp=1620666210;
SELECT
FROM
LEFT JOIN
LEFT JOIN
WHERE (
ORDER BY
# Time: 210510 13:03:30
# User@Host: example_example[example_example] @ localhost []
# Thread_id: 324 Schema: example_example QC_hit: No
# Query_time: 8.822642 Lock_time: 0.000053 Rows_sent: 20 Rows_examined: 1029714
# Rows_affected: 0 Bytes_sent: 22425
use example_example;
SET timestamp=1620666210;
SELECT
xf_thread., xf_user_User_1., xf_user_LastPoster_2.*FROM
xf_threadLEFT JOIN
xf_user AS xf_user_User_1 ON (xf_user_User_1.user_id = xf_thread.user_id)LEFT JOIN
xf_user AS xf_user_LastPoster_2 ON (xf_user_LastPoster_2.user_id = xf_thread.last_post_user_id)WHERE (
xf_thread.node_id = 52) AND ((xf_thread.discussion_state IN ('visible'))) AND (xf_thread.sticky = 0)ORDER BY
xf_thread.last_post_date DESC