Question Kunena Performance FAQ

I have 220 000 messages, 20 000 threads and 3300 registered + 4000-6000 anonymous users visiting my board every day.

FireBoard 1.0.5RC2 crashed my server in 5 minutes when I migrated into it. It just couldn't handle 200 concurrent users. After optimizing my MySQL and Apache servers the load was 100-200% and the site was really slow.

Kunena 1.0.8 is faster, but it slows down for large forums. There are still too many unoptimized queries, which take over 1 sec if you have, say, 200 000 messages. The problem of the current queries is that they get exponentially slower as the board grows larger.

I have optimized version in my own site, which drops my MySQL CPU usage for 50-99% most of the time. Average CPU usage is usually in the range of 1-6% (compared to 100-200%) with some short spikes of 25-50%, which haven't been optimized. The queries have been optimized so that they wont slow down much when number of messages and threads grow.

I can say that your VPS is barely enough for my site. My traffic is about 50GB a month, so you need to upgrade your VPS soon.

I hope that this helps.

peetree21 it was a advice and joke

we can support which other
i mean lat them in peace do that they have do CODE

fxstein Matias and other plz dont look forum but make kunena stable
we can support which other

Matias wrote:

Kunena 1.0.8 is faster, but it slows down for large forums. There are still too many unoptimized queries, which take over 1 sec if you have, say, 200 000 messages. The problem of the current queries is that they get exponentially slower as the board grows larger.

I have optimized version in my own site, which drops my MySQL CPU usage for 50-99% most of the time. Average CPU usage is usually in the range of 1-6% (compared to 100-200%) with some short spikes of 25-50%, which haven't been optimized. The queries have been optimized so that they wont slow down much when number of messages and threads grow.

I can say that your VPS is barely enough for my site. My traffic is about 50GB a month, so you need to upgrade your VPS soon.

thanks matias, the more information the better as i try and understand it all. yes my VPS did go over the 50GB bandwidth recently and so had to go up to 70GB limit. Is this bandwidth related to the forum at all (apart from images etc)?

Will the optimising you have done be included into the 1.1 build of Kunena do you think? And just to confirm, you are saying that your site has now got 6% cpu usage instead of 100% cpu usage? (with 200 users online at same time).

Forum eats a lot of bandwidth, because of it's dynamic. Usually every page load takes at least 15k, so for 1000 users going through on average 20 threads (and back to latestx) every day eats 20G of bandwidth in every month. And that is only for the html..

My optimizations will go to SVN as soon as 1.0.8 is out. No, I'm not saying that. It's only counting MySQL CPU usage. Apache processes will be as slow as before (taking about 10-20% of CPU each). But it does mean that you can have 100-200 users online (with 30 min session timeout) and your site is still be fast. This is true if your VPS has enough memory and CPU time to support all those users AND if you have optimized your server.

Hello! Thanks for all beauty work!

I've found something new about performance. What do you think about this comparison?

blogomunity.com/joomla-blog/62-benchmark...nena-vs-phpbb-3.html

That new kunena 1.1 will be more faster? Mean have less query to database?

as fxstein explained in some other thread, query count is not the most efficient way to benchmark performance

That said, is evident kunena is still far from the big ones, phpbb, ipb, vbulletin, but that is the biggest aim for 1.1, improve performance radically(this has been already tested in some dev sites)