- Posts: 37
- Thank you received: 0
Kunena 7.0.5 & Kunena 6.4.11 – Security Updates Released
The Kunena team has announce the arrival of Kunena 7.0.5 [K 7.0.5] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0.
The Kunena team is also pleased to announce the eleventh version of Kunena 6.4, a native Joomla extension for Joomla! 5.0, 5.1, 5.2, 5.3, 5.4 and 6.0.
Idea Kunena getting Slowwww! Ddos attack or normal behaviour?
14 years 5 months ago #113028
by stromboli
Hi,
I'm running Kunena 1.7.1 with Joomla and Jomsocial (latest versions)
at certain times I got 100% of MYSQL usage that renders the server unusable.
I don't know what causes this problem but I see:
It's like a lot of queries are started but they NEVER STOP running.
I see in my query logs lots of:
262805 tresjolie localhost tresjolieorg Query 00:42:30 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, (a.time > 1323281759) AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
262838 tresjolie localhost tresjolieorg Query 00:42:21 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, 0 AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
262853 tresjolie localhost tresjolieorg Query 00:42:15 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, 0 AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
262868 tresjolie localhost tresjolieorg Query 00:42:11 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, (a.time > 1323303988) AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
262915 tresjolie localhost tresjolieorg Query 00:41:56 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, 0 AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
262920 tresjolie localhost tresjolieorg Query 00:41:56 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, 0 AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
262945 tresjolie localhost tresjolieorg Query 00:41:48 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, 0 AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
262993 tresjolie localhost tresjolieorg Query 00:41:30 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, (a.time > 1323307386 AND a.thread NOT IN (0,109805)) AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
263016 tresjolie localhost tresjolieorg Query 00:41:27 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, (a.time > 1323343355) AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
263049 tresjolie localhost tresjolieorg Query 00:41:15 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, 0 AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
263060 tresjolie localhost tresjolieorg Query 00:41:10 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, (a.time > 1306543152) AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
263088 tresjolie localhost tresjolieorg Query 00:41:03 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, (a.time > 1323303988) AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
263130 tresjolie localhost tresjolieorg Query 00:40:48 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, 0 AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
263163 tresjolie localhost tresjolieorg Query 00:40:37 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, (a.time > 1322078296) AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
263178 tresjolie localhost tresjolieorg Query 00:40:31 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, (a.time > 1323234389) AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
263196 tresjolie localhost tresjolieorg Query 00:40:24 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, 0 AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
263252 tresjolie localhost tresjolieorg Query 00:40:06 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, (a.time > 1322078296) AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
263302 tresjolie localhost tresjolieorg Query 00:39:50 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, (a.time > 1323343355) AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
I'm running Kunena 1.7.1 with Joomla and Jomsocial (latest versions)
at certain times I got 100% of MYSQL usage that renders the server unusable.
I don't know what causes this problem but I see:
It's like a lot of queries are started but they NEVER STOP running.
I see in my query logs lots of:
262805 tresjolie localhost tresjolieorg Query 00:42:30 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, (a.time > 1323281759) AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
262838 tresjolie localhost tresjolieorg Query 00:42:21 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, 0 AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
262853 tresjolie localhost tresjolieorg Query 00:42:15 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, 0 AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
262868 tresjolie localhost tresjolieorg Query 00:42:11 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, (a.time > 1323303988) AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
262915 tresjolie localhost tresjolieorg Query 00:41:56 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, 0 AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
262920 tresjolie localhost tresjolieorg Query 00:41:56 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, 0 AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
262945 tresjolie localhost tresjolieorg Query 00:41:48 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, 0 AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
262993 tresjolie localhost tresjolieorg Query 00:41:30 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, (a.time > 1323307386 AND a.thread NOT IN (0,109805)) AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
263016 tresjolie localhost tresjolieorg Query 00:41:27 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, (a.time > 1323343355) AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
263049 tresjolie localhost tresjolieorg Query 00:41:15 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, 0 AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
263060 tresjolie localhost tresjolieorg Query 00:41:10 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, (a.time > 1306543152) AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
263088 tresjolie localhost tresjolieorg Query 00:41:03 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, (a.time > 1323303988) AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
263130 tresjolie localhost tresjolieorg Query 00:40:48 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, 0 AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
263163 tresjolie localhost tresjolieorg Query 00:40:37 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, (a.time > 1322078296) AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
263178 tresjolie localhost tresjolieorg Query 00:40:31 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, (a.time > 1323234389) AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
263196 tresjolie localhost tresjolieorg Query 00:40:24 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, 0 AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
263252 tresjolie localhost tresjolieorg Query 00:40:06 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, (a.time > 1322078296) AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
263302 tresjolie localhost tresjolieorg Query 00:39:50 SELECT a.id, a.name, a.userid, a.subject, a.catid, a.time AS posttime, c.name AS catname, (a.time > 1323343355) AS unread FROM j17_kunena_categories AS c, j17_kunena_messages AS a LEFT JOIN j17_kunena_messages AS b ON a.thread = b.thread AND a.time < b.time WHERE b.id IS NULL AND a.catid = c.id AND a.moved = 0 AND c.pub_access <= 0 ORDER BY a.time DESC LIMIT 7
Please Log in or Create an account to join the conversation.
14 years 5 months ago #113030
by sozzled
Blue Eagle vs. Crypsis reference guide
Read my blog and
Replied by sozzled on topic Re: Kunena getting Slowwww! Ddos attack or normal behaviour?
To help us better understand the possible causes of your apparent slowdown, would you be able to post your configuration report. Thanks.
Blue Eagle vs. Crypsis reference guide
Read my blog and
Please Log in or Create an account to join the conversation.
14 years 5 months ago #113183
by Matias
Replied by Matias on topic Re: Kunena getting Slowwww! Ddos attack or normal behaviour?
Looks like your server runs out of CPU time, which causes these peaks in the load. It's just like water pipes/sewers: as long as the load is under 90%, everything runs smoothly. But when the water pipes saturate, you will see 30cm of water in the roads just after few minutes.
Same happens in the computer: if CPU can handle the load, everything works smoothly. But if resources run out, you get 30-180 second page loads within just a few minutes.
Kunena 2.0 has many optimizations that will push this saturation limit up by factor of 3-6. There are some means to work around this: best way is to find out how to optimize your apache and mysql settings.
Same happens in the computer: if CPU can handle the load, everything works smoothly. But if resources run out, you get 30-180 second page loads within just a few minutes.
Kunena 2.0 has many optimizations that will push this saturation limit up by factor of 3-6. There are some means to work around this: best way is to find out how to optimize your apache and mysql settings.
Please Log in or Create an account to join the conversation.
Time to create page: 0.305 seconds