Solved Query mysql from kunena make cpu high

Hi,

UPDATE u3gbc_kunena_users AS u
LEFT JOIN (
SELECT userid, MAX(expiration) AS banned FROM u3

Please view and recommend me how to optimize it

Kunena: 4.0.6
Kunena user total: 321848

Thankyou so much,

could you add the kunena report

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

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

This message contains confidential information

htaccess: Missing | PHP environment: Max execution time: 600 seconds | Max execution memory: 128M | Max file upload: 8M

Kunena menu details:

Warning: Spoiler!

ID	Name	Menutype	Link	Path	In trash
1439	Community Forum - Disable	mainmenu	view=home&defaultmenu=1763	support/community-forum-disable	No
1763	Forum	kunenamenu	view=home&defaultmenu=1764	forum	No
1764	Home	kunenamenu	view=category&layout=list&catid=0	forum/home	No
1765	Recent Topics	kunenamenu	view=topics&mode=replies	forum/recent	No
1766	New Topic	kunenamenu	view=topic&layout=create	forum/newtopic	No
1767	No Replies	kunenamenu	view=topics&mode=noreplies	forum/noreplies	No
1768	My Topics	kunenamenu	view=topics&layout=user&mode=default	forum/mylatest	No
1769	Profile	kunenamenu	view=user	forum/profile	No
1770	Help	kunenamenu	view=misc	forum/help	No
1771	Search	kunenamenu	view=search	forum/search	No
3206	Late Response	kunenamenu	view=domainsearch	forum/late-response	No
3207	Responsed	kunenamenu	view=domainsupportersearch	forum/responsed	No

Joomla default template details : domain_db | author: domain.com | version: 1.0.0 | creationdate: Unknown

Kunena default template details : domain Mainsite Forum | author: domain Team | version: 1.0.0 | creationdate: 16/10/2013

Kunena version detailed: Kunena 4.0.6 | 2015-09-28 [ Pielungo ]
| Kunena detailed configuration:

Warning: Spoiler!

Kunena config settings:
board_offline	0
enablerss	1
threads_per_page	20
messages_per_page	6
messages_per_page_search	15
showhistory	1
historylimit	6
shownew	1
disemoticons	0
template	domain_mainsite
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	1
useredit	1
useredittime	0
useredittimegrace	600
editmarkup	1
allowsubscriptions	1
subscriptionschecked	1
allowfavorites	1
maxsubject	50
maxsig	1300
regonly	0
pubwrite	0
floodprotection	60
mailmod	0
mailadmin	-1
captcha	1
mailfull	1
allowavatarupload	1
allowavatargallery	1
avatarquality	65
avatarsize	1024
imageheight	800
imagewidth	800
imagesize	4096
filetypes	txt,rtf,pdf,zip,tar.gz,tgz,tar.bz2
filesize	8192
showranking	1
rankimages	1
userlist_rows	30
userlist_online	1
userlist_avatar	1
userlist_posts	1
userlist_karma	1
userlist_email	0
userlist_joindate	1
userlist_lastvisitdate	1
userlist_userhits	1
latestcategory
showstats	1
showwhoisonline	1
showgenstats	1
showpopuserstats	1
popusercount	5
showpopsubjectstats	1
popsubjectcount	5
showspoilertag	1
showvideotag	1
showebaytag	1
trimlongurls	1
trimlongurlsfront	40
trimlongurlsback	20
autoembedyoutube	1
autoembedebay	1
ebaylanguagecode	en-us
sessiontimeout	900
highlightcode	1
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
defaultpage	recent
default_sort	asc
sef	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	150
thumbwidth	150
hideuserprofileinfo	put_empty
boxghostmessage	0
userdeletetmessage	0
latestcategory_in	1
topicicons	1
debug	0
catsautosubscribed	0
showbannedreason	1
showthankyou	1
showpopthankyoustats	1
popthankscount	5
mod_see_deleted	1
bbcode_img_secure	text
listcat_show_moderators	1
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	0
thankyou_max	10
email_recipient_count	0
email_recipient_privacy	bcc
captcha_post_limit	3
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	120
iptracking	1
rss_feedburner_url
autolink	1
access_component	1
statslink_allowed	1
superadmin_userlist	0
legacy_urls	1
attachment_protection	0
categoryicons	1
avatarresizemethod	1
avatarcrop	0
user_report	1
searchtime	365
teaser	0
ebay_language	0
twitter_consumer_key
twitter_consumer_secret
allow_change_subject	1
max_links	6
userlist_name	1
usernamechange	0
version_check	1
enablepdf	1
jmambot	0
annmodid	62
changename	0
userlist_username	1
userlist_usertype	0
rules_infb	1
help_infb	1
sefutf8	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 Enabled: avatar=1 profile=1
Kunena - UddeIM Enabled: private=1

| Joomla! detailed language files installed:

Warning: Spoiler!

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

Third-party components: UddeIM 3.5

Third-party SEF components: sh404sef 4.6.0.2718

Plugins: Search - Kunena Search 3.1.1

Modules: Kunena Stats 3.1.1

Hi,

I found that the time to "Sending data" of query is very long,

Recommend me how to fix it,

Thanks,

mhh should be ok, do you have extra plugins installed, try to disable them, and enable it, until the cpu is high again.