MyBB Community Forums

For some reason my index page just started to load very slowly. I don't know what it might be, because I haven't done any recent changes.

http://kwikzclan.com/index.php

But the portal is quick like everything else
http://kwikzclan.com/portal.php


Debug Information

Quote:MyBB Debug Information

Page Generation

Page Generation Statistics
Page Generation Time: 0.048558950424194 seconds No. DB Queries: 14
PHP Processing Time: 0.0348241 seconds (71.72%) DB Processing Time: 0.0137348 seconds (28.28%)
Extensions Used: mysqli, xml Global.php Processing Time: 0.0354500 seconds
PHP Version: 5.3.8 Server Load: 0.67
GZip Encoding Status: Disabled No. Templates Used: 38 (46 Cached / 0 Manually Loaded)
Memory Usage: 2.25 MB (2359296 bytes) Memory Limit: 80M
Database Connections (1 Total)

[READ] [email protected] (Connected in 0s)

Database Queries (14 Total)

#1 - Write Query
SET NAMES 'utf8'
Query Time: 0.00022077560424805

#2 - Select Query
SELECT title,cache FROM mybb_datacache
table type possible_keys key key_len ref rows Extra
mybb_datacache ALL 31
Query Time: 0.0028979778289795

#3 - Select Query
SELECT * FROM mybb_sessions WHERE sid='eb2425434d4880fcf6bed05ffc1ac442' AND ip='88.88.56.232' LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_sessions const PRIMARY,ip PRIMARY 98 const 1
Query Time: 0.00036406517028809

#4 - Select Query
SELECT u.*, f.* FROM mybb_users u LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) WHERE u.uid='1' LIMIT 1
table type possible_keys key key_len ref rows Extra
u const PRIMARY PRIMARY 4 const 1
f const PRIMARY PRIMARY 4 const 1
Query Time: 0.00062108039855957

#5 - Write Query
UPDATE mybb_sessions SET uid='1', time='1320079645', location='/index.php?debug=1', useragent='Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_2) AppleWebKit/534.51.22 (KHTML, like Gecko) Version/5.1', location1='0', location2='0', nopermission='0' WHERE sid='eb2425434d4880fcf6bed05ffc1ac442' LIMIT 1
Query Time: 0.00035500526428223

(Plugin Hook: global_start)
#6 - Select Query
SELECT gid FROM mybb_settinggroups WHERE name = 'autosigremovalplugin' LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_settinggroups ALL 32 Using where
Query Time: 0.00029516220092773

(Plugin Hook: global_start)
#7 - Select Query
SELECT name, value FROM mybb_settings WHERE gid = '36'
table type possible_keys key key_len ref rows Extra
mybb_settings ALL 273 Using where
Query Time: 0.0005040168762207

(Plugin Hook: global_start)
#8 - Select Query
SELECT uid, username FROM mybb_users WHERE postnum < 10 AND signature LIKE '%[url%'
table type possible_keys key key_len ref rows Extra
mybb_users ALL 69 Using where
Query Time: 0.0005340576171875

#9 - Select Query
SELECT name, tid, properties, stylesheets FROM mybb_themes WHERE def='1' LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_themes ALL 4 Using where
Query Time: 0.00034689903259277

#10 - Select Query
SELECT title,template FROM mybb_templates WHERE title IN ('' ,'index' ,'index_whosonline' ,'index_welcomemembertext' ,'index_welcomeguest' ,'index_whosonline_memberbit' ,'forumbit_depth1_cat' ,'forumbit_depth1_forum' ,'forumbit_depth2_cat' ,'forumbit_depth2_forum' ,'forumbit_depth1_forum_lastpost' ,'forumbit_depth2_forum_lastpost' ,'index_modcolumn' ,'forumbit_moderators' ,'forumbit_subforums' ,'index_welcomeguesttext' ,'index_birthdays_birthday' ,'index_birthdays' ,'index_pms' ,'index_loginform' ,'index_logoutlink' ,'index_stats' ,'forumbit_depth3' ,'forumbit_depth3_statusicon' ,'index_boardstats' ,'css' ,'headerinclude' ,'header' ,'footer' ,'gobutton' ,'htmldoctype' ,'header_welcomeblock_member' ,'header_welcomeblock_guest' ,'header_welcomeblock_member_admin' ,'global_pm_alert' ,'global_unreadreports' ,'' ,'global_pending_joinrequests' ,'nav' ,'nav_sep' ,'nav_bit' ,'nav_sep_active' ,'nav_bit_active' ,'footer_languageselect' ,'header_welcomeblock_member_moderator' ,'redirect' ,'error') AND sid IN ('-2','-1','8') ORDER BY sid ASC
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 1133 Using where; Using filesort
Query Time: 0.0027270317077637

#11 - Select Query
SELECT COUNT(uid) as total FROM mybb_joinrequests WHERE gid IN (0,4)
table type possible_keys key key_len ref rows Extra
Impossible WHERE noticed after reading const tables
Query Time: 0.00026202201843262

(Plugin Hook: global_end)
#12 - Write Query
SET @@session.wait_timeout = 90
Query Time: 0.0002129077911377

#13 - Select Query
SELECT s.sid, s.ip, s.uid, s.time, s.location, s.location1, u.username, u.invisible, u.usergroup, u.displaygroup FROM mybb_sessions s LEFT JOIN mybb_users u ON (s.uid=u.uid) WHERE s.time>'1320078745' ORDER BY u.username ASC, s.time DESC
table type possible_keys key key_len ref rows Extra
s range time time 8 5 Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 kwikzclan_com.s.uid 1
Query Time: 0.00069499015808105

#14 - Select Query
SELECT f.*, fr.dateline AS lastread FROM mybb_forums f LEFT JOIN mybb_forumsread fr ON (fr.fid=f.fid AND fr.uid='1') WHERE f.active != 0 ORDER BY pid, disporder
table type possible_keys key key_len ref rows Extra
f ALL 28 Using where; Using filesort
fr eq_ref fid fid 8 kwikzclan_com.f.fid,const 1
Query Time: 0.00098180770874023

Template Statistics

Templates Used (Loaded for this Page) - 38 Total
global_pm_alert, index, header_welcomeblock_member, header_welcomeblock_member_moderator, header_welcomeblock_member_admin, redirect, gobutton, forumbit_depth2_forum, forumbit_depth3, forumbit_depth3_statusicon, forumbit_subforums, footer, headerinclude, nav_sep, nav_sep_active, header_welcomeblock_guest, header, forumbit_depth1_cat, global_unreadreports, global_pending_joinrequests, index_loginform, index_whosonline, index_stats, index_birthdays_birthday, forumbit_moderators, index_birthdays, index_logoutlink, error, index_whosonline_memberbit, forumbit_depth2_cat, nav, nav_bit, nav_bit_active, htmldoctype, footer_languageselect, index_boardstats, forumbit_depth2_forum_lastpost, forumbit_depth1_forum_lastpost

Templates Requiring Additional Calls (Not Cached at Startup) - 0 Total

you may have to deactivate (better uninstall) shoutbox AND check ...

(2011-10-31, 05:09 PM)ranjani Wrote: [ -> ]you may have to deactivate (better uninstall) shoutbox AND check ...

I was going to say the same thing!! The shoutbox requires more CPU, more RAM and more SQL queries, disable it (better uninstall it)

Hm, nope, that didn't help.

---

I tried deactivating and uninstalling all plugins, I also removed all pictures and external links on the index page, didn't help.

The page generation is fast enough. Forum URL?

Maybe the debug information now?

He already gave the debug information.

What can be wrong with the URL?
Is it the database that is causing some troubles?

(2011-10-31, 11:10 PM)Paul H. Wrote: [ -> ]The page generation is fast enough. Forum URL?

Hmm?

^ I do not feel your forum is slow ... (without the shoutbox)