Australian Joomla! Community

dex wrote: Please use the PM feature at K.org. Let me know how I can contact you (Skype is preferable but telephone is OK, too) by sending me your contact details there.

OK i've been chipping silently away at this. I thought we'd have to upgrade our hosting but the hosting company has suggested (bless 'em) that this is un-necessary.

So the search continues. If anyone actually HAS a needle or can move haystacks, step forward.

Today I have
(a) truncated the forum to only 2012 entries, in case it was all too much to bear
(b) truncated redirects, all 10,239 of them, in case URLS were a burden
(c) turned on a few essentials like firewall, JCE, site map
(d) optimised the DB again
(e) frowned a lot at the big numbers
(f) wondered why despite a recount, the Kunena stats are still the same as before the scythe hit

I will wait 24h for another CPU reading, but BEFORE I did the above, we had numbers like this:

Jun 19 2012:
joomla.org.au 2.35 1.16 0.1
Top Process %CPU 136 [php]
Top Process %CPU 101 /index.php
Top Process %CPU 82.0 /index.php

"D- Could do better"

So time to confer again. Perhaps I should upgrade Kunena to 2? What say you Sozzled? I am getting page loads of .97 tonight

I say we should talk about it. Please give me a means of contact - as I have suggested on several occasions - and I will talk with you.

Why 10k+ redirects???? and how would that occur? Try removing all the redirects and see the load time difference (after clearing all cache and history). May make a difference, as to me that many redirects seems insane - if makes little/no difference then it's not the "main" problem.

Surely most of these could be replaced by a couple of "directory" or "Match" redirects?
At some point in time old links need to be let go - goggle just likes to be informed of it sometimes, if it isn't specified in a 301 redirect.

Max

and can activate the cache across all of joomla, then disable with:
[url=http://]http://extensions.joomla.org/extensions/core-enhancements/performance/cache/17783[/url]
on just the pages not requiring cache (such as the forum).
Instructions sya:Looks like it may help for issues here?? Max

Thanks Max
I turned on as much caching as I could and expires-headers. So perhaps fine-tuning is the way to go.
Am also investigating whether we have enough RAM, as its set to 128Mb - less than recommended.

Ok it wasnt the RAM

Latest ideas:

1. Tune up the DB using ./tuning-primer.sh. Apparently can save 50-70%. Would make sense then that Kunena page load is still slow despite culling. Also if you turn off the 'Thanks' button you can save 2 MySQL queries per thread reply. So in the case of this thread, that's 52 queries.

2. Get Google bot to visit less often (is it set to the standard 0.2 requests per second and 5 seconds between requests in Webmaster tools?)

3. Check out spammers and hackers. Block problem countries. We certainly are getting a lot of hack attempts and there is the reply-to spoof email problem.

Hey Dex,

I'm happy put it on a Nginx. PHP5-FPM, Percona stack and tune it up for you. Would install and use New Relic to identify the source of any inherent issues. Also happy to provide the server (Rackspace Cloud Server) on an ongoing basis as sponsorship in kind if that is of interest.

Cheers
Shayne

Thanks for your work on it Dex.

Did you manage to pinpoint the main culprit?

See www.kunena.org/forum/168-K-17-Support/12...site?start=10#127715

Upgraded Kunena to new 2.0 stable release. Page load times are down significantly -yay! (.18-.5 seconds, instead of .8 to 1.0) On ya, Kunena team. Going to bring back pre-2012 posts shortly.

Sozzled, i resent you my contact details earlier as requested, thanks. However upgrading seems to have fixed the problem

BTW I reloaded all your avatars, but somehow it doesnt know they are there. Not had time to see why yet. I've now enabled Gravatars!

There is a very important patch needed in K 2.0.0 (see details in www.kunena.org/forum/K-2-0-Support/12348...hp-on-line-60#126869) that must be applied to all J! 2.5.x sites that use K 2.0.0.

A proper fix for this problem will be released at K 2.0.1 in a couple of days' time. In the meantime, make the change recommended in the link I have posted here.

Failure to make this change can result in sites using K 2.0.0. on J! 2.5.x going down with HTTP 500 Internal Server Errors (frontend and backend). J! 1.5.x sites are unaffected.

Big improvement in page load times. K 2.0 uses caching and that's probably why K 1.7.2 (plus caching) caused problems in the past.

dex wrote: Although not specifically related to the high CPU usage question, FYI we cannot edit our user profiles because there is a Javascript library conflict here that means the "tabbed" areas on the profiles do not show. At least, I am 99% sure that it's a Javascript library conflict. See msg #1 in www.kunena.org/forum/K-2-0-General-Quest...tion-read-this-first for further information.

Again, if you want, I would be happy to talk this through with you by telephone or Skype if you have the time and if you want to do this.

Thanks Sozzled I've applied the patch, but i'm sick with the flu, going back to bed, the avatars I will sort out later.
cheers
Dex

Hope you are feeling better soon, Dex, and you and I will have that long-overdue (by many months) discussion on Skype, soon.