Kunena 6.3.2 released

The Kunena team has announce the arrival of Kunena 6.3.2 [K 6.3.2] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 and issues discovered during the last development stages of K 6.3
Note: Please go to the Kunena Dashboard after an upgrade so that the Kunena database tables are also updated.

Important CPU abuse from Php

More
15 years 1 month ago #1 by irradiate
CPU abuse from Php was created by irradiate
Hi all,

I received an email from my host last night stating that the forum is putting to much pressure on the CPU and will suspended my account until it is fixed.

I only opened the site 12 hours before after transferring everything over from SMF

They have aggreed to let me in, if I keep the whole site offline so I can fix it but I have no idea on what to do?? I have 1600 members and only average about 40 people on at any time.

Any Ideas??

I am running version 1.0.9

when I run debug and access the forum, it says
30 queries logged & 414 legacy queries logged

Not sure if this helps?

Cheers

Please Log in or Create an account to join the conversation.

More
15 years 1 month ago #2 by irradiate
Replied by irradiate on topic Re: CPU abuse from Php
I got confirmation from the host today that it is the forum that is causing the problem :/

I updated to version 1.0.10 hoping that it would fix it but it is the same except for 1 less query

Please Log in or Create an account to join the conversation.

More
15 years 1 month ago #3 by irradiate
Replied by irradiate on topic Re: CPU abuse from Php
Anyone have any idea on what I should do?

Please Log in or Create an account to join the conversation.

More
15 years 1 month ago #4 by johnnydement
Replied by johnnydement on topic Re: CPU abuse from Php
First I think you should ask for real numbers to see this, also give us an URL if still operational.
You're first in having a problem like that, and we have users with big forums (over 400k threads and over 20k users...)
Coulld you share with us what your forum is about and how you use it?

Please Log in or Create an account to join the conversation.

More
15 years 1 month ago #5 by irradiate
Replied by irradiate on topic Re: CPU abuse from Php
I have had to take it offline and redirect all my user back over to my old site for the time being.

It is a fishing forum with 8 categories and 50 topics. It has just over 40000 posts and never has more than 40 people on at any time. I also had the whole forum closed to guests.

How many queries are normal? When I can get back in with my temp address I will copy the whole list. It looked as though there were multiple queries for each topic.

Please Log in or Create an account to join the conversation.

More
15 years 1 month ago - 15 years 1 month ago #6 by irradiate
Replied by irradiate on topic Re: CPU abuse from Php
I just got in and got a copy of the debug



I can also email it if you like or post the whole lot here if need be?

File Attachment:

File Name: queries_logged.zip
File Size:7 KB
Attachments:
Last edit: 15 years 1 month ago by irradiate.

Please Log in or Create an account to join the conversation.

More
15 years 1 month ago #7 by irradiate
Replied by irradiate on topic Re: CPU abuse from Php
Without sounding impatient, Anybody know whats wrong?

Please Log in or Create an account to join the conversation.

More
15 years 1 month ago #8 by Matias
Replied by Matias on topic Re: CPU abuse from Php
Yes, I do know. I have not merged all of my SQL optimizations and some queries are still very slow, especially if your MySQL server is using MyISAM tables (default). Number of queries has nothing to do with the speed -- it's the slow queries reading whole/most of the table that matters.

How large forum do you have?

Please Log in or Create an account to join the conversation.

More
15 years 1 month ago #9 by irradiate
Replied by irradiate on topic Re: CPU abuse from Php
It had 46000 posts, 4500 topics and 1500 members.

Is there anything I can do my end to optimize and speed up the queries or will it be in an updated version?

Please Log in or Create an account to join the conversation.

More
15 years 1 month ago #10 by irradiate
Replied by irradiate on topic Re: CPU abuse from Php
Just thinking, If I upgrade to 1.0.10 is it going to fix it or are there still some slow queries in that build?

Is there anyway I can measure it on my end or do I wait and see if the host comes back and tells me off ;)

Please Log in or Create an account to join the conversation.

Time to create page: 0.542 seconds