1
My XOOPS site was temporary shut down by the hosting today and I receive a notification saying that my site is causing the server CPU to overload.
It was suspected that the forum was causing the CPU to get overload.
I don't really understand why though. The site receive about 400-500 unique visitors per day. 5-20 post in the forum a day.
Here is the server log sent by the hosting admin.
(i don't if the log will prove anything about the CPU overload)
Quote:
User@Host: catscity_new[catscity_new] @ localhost []
# Query_time: 13 Lock_time: 0 Rows_sent: 2 Rows_examined: 85319
use site_new;
SELECT p.*, t.* FROM xoops_bb_posts AS p LEFT JOIN xoops_bb_posts_text
AS
t ON t.post_id = p.post_id WHERE (p.forum_id IN
(6,36,72,42,39,41,71,70,7,19,33,3,13,55,29,56,1,44,47,48,69,12,8,18)
AND
p.approved = '1') ORDER BY p.post_time DESC LIMIT 28440, 10;
-----------------
SELECT f.forum_id, f.forum_name, f.allow_subject_prefix,
t.topic_id, t.topic_title, t.topic_subject, p.post_id, p.post_time,
p.subject, p.uid, p.poster_name, p.post_karma, p.require_reply,
p.dohtml,
p.dosmiley, p.doxcode, pt.post_text FROM xoops_bb_posts AS p
LEFT JOIN xoops_bb_topics AS t ON t.topic_last_post_id=p.post_id
LEFT JOIN xoops_bb_posts_text AS pt ON pt.post_id=p.post_id LEFT
JOIN
xoops_bb_forums AS f ON f.forum_id=p.forum_id WHERE 1=1 AND t.forum_id
IN
(42,71,7) AND t.approved = 1 AND p.approved = 1 ORDER BY p.post_time
DESC
LIMIT 0, 15;
So anyone know how I can prevent this in future?
Anyone experience the same thing?
Any question I can forward to my hosting for more information regarding this matter?
