Question Kunena Latest 2.0.1 performance

Hi, I just upgraded my joomla + kunena installs yesterday, and ever since, my site, but especially the forum has been extremly slow. Slow as in 4-7 seconds loading time for a really small forum. Traffic is so low, that i can usually count the loggin in users on one hand

The server runs locally, so 1gbit link, albeit in a VM being allocated plenty of ram and 2 CPU's.

Firstly I noticed, disabeling kunena_latest brought the speed back up in joomla itself, so I quickly noticed it was kunena causing the slowdowns.

Further analysing the server and running mysqld with the --slow-queries-log option, I noticed whenever a query from the forum was executed, mysql was using up 100% CPU time. I then went to run 'SHOW FULL PROCESSLIST' to see what was running that was being so slow. Obviously quite a few queries get run, but a few that I tried yielded the following results:

SELECT b.rules
FROM j17_assets AS a
LEFT JOIN j17_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
WHERE (a.name = 'com_kunena' OR a.parent_id=0)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
957 rows in set (1.79 sec)

as a matter of fact, the only query I could intersept was this one. Which isn't too supprising, as all these relativily small queries should be by within miliseconds. If this query alone takes almost 2 seconds, and it could for whatever reason be run twice, we're talking about an almost 4 second delay just for quering the database.

Something is going horribly wrong here, especially with kunena_latest even causing the slowdown, which should be quite fast.

Any obvious things I overlooked?

Joomla! version: 2.5.6 Platform: Apache/2.2.15 (Unix) mod_ssl/2.2.15 OpenSSL/1.0.0e (site.tldk) PHP version: 5.3.8 | safe_mode: Off | register_globals: Off | mbstring: Enabled | GD: 2.0 | MySQL version: 5.1.53 | Base URL: site.tld/joomla/

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

Legacy mode: Disabled | Joomla! SEF: Disabled | Joomla! SEF rewrite: Disabled | FTP layer: Disabled |
htaccess: Missing | PHP environment: Max execution time: 320 seconds | Max execution memory: 128M | Max file upload: 16M

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path
50	143	mainmenu	option=com_kunena	143
61	Forum	kunenamenu	view=home&defaultmenu=62	forum
62	Index	kunenamenu	view=category&layout=list&catid=0	forum/index
63	Recent Topics	kunenamenu	view=topics&layout=default&mode=replies	forum/recent
64	New Topic	kunenamenu	view=topic&layout=create	forum/newtopic
65	No Replies	kunenamenu	view=topics&layout=default&mode=noreplies	forum/noreplies
66	My Topics	kunenamenu	view=topics&layout=user&mode=default	forum/mylatest
67	Profile	kunenamenu	view=user	forum/profile
68	Rules	kunenamenu	view=misc	forum/rules
69	Help	kunenamenu	view=misc	forum/help
70	Search	kunenamenu	view=search	forum/search

Joomla default template details : mistsofpandaria | author: Andy Taylor | version: 1.0 | creationdate: 2012-07-30

Kunena default template details : Blue Eagle 2.0 | author: Kunena Team | version: 2.0.1 | creationdate: 2012-07-07

Kunena version detailed: Kunena 2.0.1 | 2012-07-07 [ Balozi ]
| Kunena detailed configuration:

Warning: Spoiler!

Kunena config settings:
board_offline	0
enablerss	0
threads_per_page	20
messages_per_page	6
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
disemoticons	0
template	blue_eagle
showannouncement	1
avataroncat	0
catimagepath	category_images/
showchildcaticon	1
rtewidth	450
rteheight	300
enableforumjump	1
reportmsg	1
username	1
askemail	0
showemail	0
showuserstats	1
showkarma	0
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	0
allowfavorites	1
maxsubject	50
maxsig	300
regonly	0
changename	0
pubwrite	0
floodprotection	10
mailmod	0
mailadmin	0
captcha	1
mailfull	0
allowavatarupload	1
allowavatargallery	0
avatarquality	65
avatarsize	2048
imageheight	800
imagewidth	800
imagesize	150
filetypes	zip,txt,doc,gz,tgz,png,gif,jpg
filesize	3000000
showranking	1
rankimages	1
userlist_rows	30
userlist_online	1
userlist_avatar	0
userlist_name	0
userlist_posts	1
userlist_karma	1
userlist_email	0
userlist_usertype	0
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	0
latestcategory	0
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	0
popusercount	5
showpopsubjectstats	0
popsubjectcount	5
usernamechange	0
showspoilertag	1
showvideotag	1
showebaytag	0
trimlongurls	0
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	0
ebaylanguagecode	en-us
sessiontimeout	1800
highlightcode	0
rss_type	topic
rss_timelimit	week
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	0
rss_cache	60
defaultpage	categories
default_sort	asc
sef	1
sefutf8	1
showimgforguest	1
showfileforguest	1
pollnboptions	4
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	1
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
boxghostmessage	0
userdeletetmessage	0
latestcategory_in	1
topicicons	1
debug	0
catsautosubscribed	0
showbannedreason	1
version_check	0
showthankyou	0
showpopthankyoustats	0
popthankscount	5
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	0
lightbox	1
show_list_time	720
show_session_type	0
show_session_starttime	0
userlist_allowed	1
userlist_count_users	1
enable_threaded_layouts	0
category_subscriptions	post
topic_subscriptions	every
pubprofile	1
thankyou_max	10
email_recipient_count	0
email_recipient_privacy	bcc
captcha_post_limit	0
keywords	0
userkeywords	0
image_upload	registered
file_upload	registered
topic_layout	flat
time_to_create_page	1
show_imgfiles_manage_profile	1
hold_newusers_posts	0
hold_guest_posts	0
attachment_limit	8
pickup_category	0
article_display	intro
send_emails	1
fallback_english	1
cache	1
cache_time	60
enablepdf	0
jmambot	0
annmodid	62
userlist_username	1
rules_infb	0
help_infb	0
onlineusers	1

| Kunena integration settings:

Warning: Spoiler!

Kunena - AlphaUserPoints Disabled
Kunena - Community Builder Disabled
Kunena - Gravatar Disabled
Kunena - JomSocial Disabled
Kunena - Joomla Enabled: access=1 login=1
Kunena - Kunena Disabled
Kunena - UddeIM Disabled

| Joomla! detailed language files installed:

Warning: Spoiler!

Joomla! languages installed:
en-GB	English (United Kingdom)

Third-party components: UddeIM 2.6

Third-party SEF components: None

Plugins: None

Modules: Kunena Latest 2.0.1

G'day, oliver, and welcome to Kunena.

I suggest you read two articles that may help:

(1) Improving Kunena performance ; and

(2) What information should I include when I ask for help (including how to post my configuration report)? . When people edit their configuration report BBcode (as you have made one or two changes) this taints all the evidence. If you want further help in this area then please do not tamper with the BBcode produced by the configuration report writer. Thank you.

It may also assist us to learn what settings you are using with Kunena Latest.

The only 'tampering' that happend was with removing the 'confident' tags as it was no longer confident with my personal details removed. My personal details are of nobodies business here marked 'confident' or not. So other then my site/e-mail address being removed, it is exactly the same. I suppose me not trusting my confident data to this site is the same as you not trusting me in having changed actual data But if it dramatically changes the outcome of the support, I can of course change my personal data in the site, and regenerate the data.

This hasn't much to do with 'pure performance tuning' with a loaded site with many users etc.

Ever since the upgrade, this one specific query that I posted above, takes about 2 seconds to complete, which is just WAY way to long. This is with only 1 user logged onto the site.

I know technically, that is a mysql issue, but since it's a kunena query, I'm hoping for support here.

Things that I'm looking for, are replies like 'this query indeed should only take 0.02 seconds. It should contain far more/less records/match your post count roughly.

At this point it looks purly like mysql is having some sort of trouble with the query, but don't quite understand yet why.

kunena_latest uses a max post count of 1 to show and just some bare basics, poster name, post date. But it is disabled now to limit the slowness purely to the forum only. With kunena_latest on the front page, the frontpage becomes equally slow.

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

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

This message contains confidential information

htaccess: Missing | PHP environment: Max execution time: 320 seconds | Max execution memory: 128M | Max file upload: 16M

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path
50	143	mainmenu	option=com_kunena	143
61	Forum	kunenamenu	view=home&defaultmenu=62	forum
62	Index	kunenamenu	view=category&layout=list&catid=0	forum/index
63	Recent Topics	kunenamenu	view=topics&layout=default&mode=replies	forum/recent
64	New Topic	kunenamenu	view=topic&layout=create	forum/newtopic
65	No Replies	kunenamenu	view=topics&layout=default&mode=noreplies	forum/noreplies
66	My Topics	kunenamenu	view=topics&layout=user&mode=default	forum/mylatest
67	Profile	kunenamenu	view=user	forum/profile
68	Rules	kunenamenu	view=misc	forum/rules
69	Help	kunenamenu	view=misc	forum/help
70	Search	kunenamenu	view=search	forum/search

Joomla default template details : mistsofpandaria | author: Andy Taylor | version: 1.0 | creationdate: 2012-07-30

Kunena default template details : Blue Eagle 2.0 | author: Kunena Team | version: 2.0.1 | creationdate: 2012-07-07

Kunena version detailed: Kunena 2.0.1 | 2012-07-07 [ Balozi ]
| Kunena detailed configuration:

Warning: Spoiler!

Kunena config settings:
board_offline	0
enablerss	0
threads_per_page	20
messages_per_page	6
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
disemoticons	0
template	blue_eagle
showannouncement	1
avataroncat	0
catimagepath	category_images/
showchildcaticon	1
rtewidth	450
rteheight	300
enableforumjump	1
reportmsg	1
username	1
askemail	0
showemail	0
showuserstats	1
showkarma	0
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	0
allowfavorites	1
maxsubject	50
maxsig	300
regonly	0
changename	0
pubwrite	0
floodprotection	10
mailmod	0
mailadmin	0
captcha	1
mailfull	0
allowavatarupload	1
allowavatargallery	0
avatarquality	65
avatarsize	2048
imageheight	800
imagewidth	800
imagesize	150
filetypes	zip,txt,doc,gz,tgz,png,gif,jpg
filesize	3000000
showranking	1
rankimages	1
userlist_rows	30
userlist_online	1
userlist_avatar	0
userlist_name	0
userlist_posts	1
userlist_karma	1
userlist_email	0
userlist_usertype	0
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	0
latestcategory	0
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	0
popusercount	5
showpopsubjectstats	0
popsubjectcount	5
usernamechange	0
showspoilertag	1
showvideotag	1
showebaytag	0
trimlongurls	0
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	0
ebaylanguagecode	en-us
sessiontimeout	1800
highlightcode	0
rss_type	topic
rss_timelimit	week
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	0
rss_cache	60
defaultpage	categories
default_sort	asc
sef	1
sefutf8	1
showimgforguest	1
showfileforguest	1
pollnboptions	4
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	1
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
boxghostmessage	0
userdeletetmessage	0
latestcategory_in	1
topicicons	1
debug	0
catsautosubscribed	0
showbannedreason	1
version_check	0
showthankyou	0
showpopthankyoustats	0
popthankscount	5
mod_see_deleted	0
bbcode_img_secure	text
listcat_show_moderators	0
lightbox	1
show_list_time	720
show_session_type	0
show_session_starttime	0
userlist_allowed	1
userlist_count_users	1
enable_threaded_layouts	0
category_subscriptions	post
topic_subscriptions	every
pubprofile	1
thankyou_max	10
email_recipient_count	0
email_recipient_privacy	bcc
captcha_post_limit	0
keywords	0
userkeywords	0
image_upload	registered
file_upload	registered
topic_layout	flat
time_to_create_page	1
show_imgfiles_manage_profile	1
hold_newusers_posts	0
hold_guest_posts	0
attachment_limit	8
pickup_category	0
article_display	intro
send_emails	1
fallback_english	1
cache	1
cache_time	60
enablepdf	0
jmambot	0
annmodid	62
userlist_username	1
rules_infb	0
help_infb	0
onlineusers	1

| Kunena integration settings:

Warning: Spoiler!

Kunena - AlphaUserPoints Disabled
Kunena - Community Builder Disabled
Kunena - Gravatar Disabled
Kunena - JomSocial Disabled
Kunena - Joomla Enabled: access=1 login=1
Kunena - Kunena Disabled
Kunena - UddeIM Disabled

| Joomla! detailed language files installed:

Warning: Spoiler!

Joomla! languages installed:
en-GB	English (United Kingdom)

Third-party components: UddeIM 2.6

Third-party SEF components: None

Plugins: None

Modules: Kunena Latest 2.0.1

I can see why it might take a long time to process things at your website. Please try to use a standard Kunena menu (watch the video in The Kunena Menu to find out how it's done). Because you do not want us to look at your actual website, there is nothing else we can to do help you.

oliver wrote:

My personal details are of nobodies business here

We respect that and we will not ask you for any more information that might otherwise help us to help you.

Thank you for posting your question on the forum; we cannot help you but we wish you every success solving the problem.

The only other thought that I can offer at this time is to read When all else fails, try this