Important Huge cpu usage on server (happened after upgrade to K1.6.0)

Hi,
I upgraded my joomla template to JA Social and then upgrade my kunena to K1.6.0 and now my site is running very very slow and i called the hosting company and they said it is because the httpd is using huge amount of the cpu.

I dont know how to fix this, I am on a VPS with 832mb ram hosted in Australia.

any ideas?

Database collation check: The collation of your table fields are correct

Legacy mode: Disabled | Joomla! SEF: Enabled | Joomla! SEF rewrite: Enabled | FTP layer: Enabled |

This message contains confidential information

htaccess: Exists | PHP environment: Max execution time: 9900 seconds | Max execution memory: 1024M | Max file upload: 1024M

Kunena version detailled: Installed version: 1.6.0 | Build: 3620 | Version name: Spika | Kunena detailled configuration:

Warning: Spoiler!

[th]Kunena config settings:[/th]

board_title	Forum
board_offline	0
board_ofset	0
offline_message	<h2>The Forum is currently offline for important maintenance and upgrades. We aim to be back online in 30 mins</h2>
enablerss	1
enablepdf	1
threads_per_page	20
messages_per_page	20
messages_per_page_search	30
showhistory	1
historylimit	15
shownew	1
jmambot	1
disemoticons	0
template	bfo
showannouncement	1
avataroncat	1
catimagepath	category_images/
showchildcaticon	1
annmodid	62
rtewidth	700
rteheight	450
enableforumjump	1
reportmsg	1
username	1
askemail	0
showemail	0
showuserstats	1
showkarma	0
useredit	1
useredittime	5259487
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	0
allowfavorites	1
maxsubject	50
maxsig	300
regonly	1
changename	0
pubwrite	0
floodprotection	0
mailmod	0
mailadmin	0
captcha	1
mailfull	0
allowavatar	1
allowavatarupload	0
allowavatargallery	1
imageprocessor	gd2
avatarquality	65
avatarsize	500
allowimageupload	0
allowimageregupload	1
imageheight	1000
imagewidth	1500
imagesize	500
allowfileupload	0
allowfileregupload	1
filetypes	zip,txt,doc,gz,tgz,pdf
filesize	500
showranking	1
rankimages	1
avatar_src
fb_profile
pm_component
userlist_rows	50
userlist_online	1
userlist_avatar	1
userlist_name	0
userlist_username	1
userlist_posts	1
userlist_karma	0
userlist_email	0
userlist_usertype	1
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory	0
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	1
popusercount	30
showpopsubjectstats	1
popsubjectcount	30
usernamechange	0
rules_infb	1
rules_cid	69
rules_link
help_infb	0
help_cid	1
help_link
showspoilertag	1
showvideotag	1
showebaytag	1
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	1
ebaylanguagecode	en-us
fbsessiontimeout	1800
highlightcode	0
rss_type	topic
rss_timelimit	month
rss_limit	100
rss_included_categories
rss_excluded_categories
rss_specification	rss2.0
rss_allow_html	1
rss_author_format	name
rss_author_in_title	1
rss_word_count	0
rss_old_titles	1
rss_cache	900
fbdefaultpage	categories
default_sort	asc
alphauserpointsnumchars	0
sef	1
sefcats	0
sefutf8	0
showimgforguest	1
showfileforguest	1
pollnboptions	5
pollallowvoteone	1
pollenabled	1
poppollscount	5
showpoppollstats	1
polltimebtvotes	00:15:00
pollnbvotesbyuser	100
pollresultsuserslist	1
maxpersotext	50
ordering_system	mesid
post_dateformat	ago
post_dateformat_hover	datetime
hide_ip	0
js_actstr_integration	0
imagetypes	jpg,jpeg,gif,png
checkmimetypes	1
imagemimetypes	image/jpeg,image/jpg,image/gif,image/png
imagequality	50
thumbheight	32
thumbwidth	32
hideuserprofileinfo	put_empty
integration_access	auto
integration_login	jomsocial
integration_avatar	jomsocial
integration_profile	jomsocial
integration_private	jomsocial
integration_activity	jomsocial
boxghostmessage	0
userdeletetmessage	0
latestcategory_in	1
topicicons	1
onlineusers	1
debug	0
catsautosubscribed	0
showbannedreason	0
version_check	1
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	1
bbcode_img_secure	text
listcat_show_moderators	0

Third-party components: AlphaUserPoints: Disabled or not installed | CommunityBuilder: Disabled or not installed | Jomsocial: Installed (Version : 1.8. | UddeIm: Disabled or not installed

Plugins: System - Mootools12: Disabled | System - Mootools Upgrade: Enabled | JFirePHP: Disabled or not installed | Kunena Discuss: Enabled (Version : 1.6.0-RC2) | Kunena Search: Disabled or not installed | My Kunena Forum Menu: Disabled or not installed

Modules: Kunena Latest: Enabled (Version : 1.6.0-RC2) | Kunena Stats: Enabled (Version : 1.6.0-RC2) | Kunena Login: Enabled (Version : 1.6.0-RC2)

Can you turn on Joomla debug mode and look at the query and memory consumptions of various pages? FYI if you set the Joomla debug plugin to access level 'Special' only admins will see its output.

We just ran into and issue with jomSocial and custom menus that cause a lot of extra queries to get generated by JS.

If its not that I would check all your plugins you are running.

We continue to do load testing with all our releases and 1.6.0 stable is at the very minimum as fast or faster than the prior RCs and up to 10x faster than 1.5.x

Profile Information
Application afterLoad: 0.000 seconds, 0.14 MB
Application afterInitialise: 0.042 seconds, 1.19 MB
Application afterRoute: 0.061 seconds, 1.92 MB
Application afterDispatch: 1.322 seconds, 7.25 MB
Application afterRender: 2.880 seconds, 8.24 MB
Memory Usage
8702512
121 queries logged


how does this compare with others? is this terrible?

Do you have JomSocial installed? It has a bug where you get huge amount of SQL queries when there are no JomSocial entries in the menu.

Yes I have Jomsocial 1.8.8 installed. How do i fix this bug and see if this is the problem? cheers

Can you copy and paste the queries into the thread (into a code section). Need to see them.

On most systems you should see 30-40 queries with 1/2 of them coming from Kunena. If you have more, it means something is doing extra queries. Could be JS but it could also be a plugin or module.