Question Kunena 1.5.9 performance

WOW!! Gratz mate! Long time since I've seen steady loads on 40!! :woohoo:

Anyway ...
You seem to know your way with the systems.

Do you use any memcache?
Do you use any kinds of query optimizer? (i have seen one for joomla itself, that replaces the database layer, caching the results)
Do you use caching?

Are your tools capable of detecting optimisation in the database itself (missing indexes, etc)?

The queries IS bad, but they will always be bad for complex forums.
That said, it is true that 1.6 will perform better that 1.5.x. But that is still sometime in the future.

Yes Kunena 1.5.9 is definitely killing server. I had received following notice from my host provider:

Hi,

Your site is suspended for using high CPU / MySQL resources. We are monitoring the server and can activate once it is normal.

You will need to move this site to a VPS or dedicated server as we cannot allow one site to use so much resource that it causes issues for other websites on a shared server.

I have been using all CSS cache to reduce server load, but despite this Kunena is utilizing lot of CPU.

Just wanted to tell developer that how badly I am waiting for the K 1.6. Thank you.

Thank you. The development team is only too well aware of how much users are waiting for K 1.6's public debut.

sunnyjey,

Caching css and javascript doesnt offload the CPU usage.

Database queries, page rendering and file io does.

You might be able to sort this out on K1.5 too, but it requires some insight and testing.

Have you tried any of the suggestions from my post?
Which versions of php, mysql, joomla, kunena, etc (EVERYTHING) are you using?

Hello,

Yes, I'm using memcached as cache handler.
Will implement the query cache component of joomlaperformance.com this coming week.
Caching is ON.

Thanks.

LittleJohn wrote:

WOW!! Gratz mate! Long time since I've seen steady loads on 40!! :woohoo:

Anyway ...
You seem to know your way with the systems.

Do you use any memcache?
Do you use any kinds of query optimizer? (i have seen one for joomla itself, that replaces the database layer, caching the results)
Do you use caching?

Are your tools capable of detecting optimisation in the database itself (missing indexes, etc)?

The queries IS bad, but they will always be bad for complex forums.
That said, it is true that 1.6 will perform better that 1.5.x. But that is still sometime in the future.

Hi,

Sorry for my late reply, have been busy working on K1.6

Can you provide some more details on your setup and website? How much traffic are you running?

We are running Kunena 1.5.9 for two significant sites (kunena.com and starvmax.com) on the same single server and we are getting load numbers of 0.2 - 0.5 on a similar system like yours.

If I run a load test like: ab -n 1024 -c 32 www.kunena.com/forum locally from our server, I get about 35 requests per second and the load goes up to about 30 after 5+ min of back to back repeat runs. That is with Joomla caching disabled - so every request builds the full kunena.com Index (Categories) page - the most expensive page in Kunena 1.5.9.

That is the equivalent of about 2.5M page views per day or about 77M per month. That is definitely a big site and about as much as you can get a single server to scale with Kunena 1.5.x.

Kunena 1.6 makes significant improvements with 1/10th of the queries and newly optimized queries. Since SQL is only part of the performance, that should translate to 2-3x faster page creation times. e.g. our current Index page takes about 350ms on Kunena 1.5.x and can be tuned as fast as 140ms on Kunena 1.6

With your configuration you are either running more then 50M page views on a single server like yours, or there is something else that needs to be looked at.

fxstein