2011-05-21, 03:59 PM
Hi all i am having a problem with my forum and ca'nt seem to find out what is causing it .
I am running MyBB 1.6.3.
Plugins installed "None"
Host 000Webhost (Free)
Here is the problem i am having .When i click on my url, http://canadianwildfeeds.prairiewind.hostei.com/ I get this message through out the day , "The maximum server load limit has been reached. Please check back later once the server is less busy". Its a MyBB board Message , but does,nt show forums just that message . Or Sometime i just get this message " The server is too busy at the moment. Please reload this page few seconds later which is a message in my browser blank white page with message .
My forum is'nt overly busy as i may have maybe 20 visiters and maybe 2 registered users at most at one time. Tried optimizing database from users ACP and also checked Tables for errors in mybb and PHP Admin. Nothing seems to be working . I contacted host support and this is what they tell me this :
Hello,
If the server is busy (for example we setup a lot of new accounts at the same time), you may see this message briefly while server load returns to normal levels:
The server is too busy at the moment. Please reload this page few seconds later.
This message can be noticed on peak times only, and only for active servers (active servers are the servers where we add tons of new accounts every day). This message will permanently disappear as soon we will switch new account setups to another server (usually in few days).
I never ran into this problem before , its not only just during peak times but perty much all the time .
Here is my Debug Imformation:
MyBB Debug Information
Page Generation
Page Generation Statistics
Page Generation Time: 1.22097086906 seconds No. DB Queries: 10
PHP Processing Time: 0.6907895 seconds (56.58%) DB Processing Time: 0.5301814 seconds (43.42%)
Extensions Used: mysqli, xml Global.php Processing Time: 1.2017889 seconds
PHP Version: 5.2.13 Server Load: 29.86
GZip Encoding Status: Disabled No. Templates Used: 38 (46 Cached / 0 Manually Loaded)
Memory Usage: 3.25 MB (3407872 bytes) Memory Limit: 64M
Database Connections (1 Total)
[READ] [email protected] (Connected in 0s)
Database Queries (10 Total)
#1 - Write Query
SET NAMES 'utf8'
Query Time: 0.0014271736145
#2 - Select Query
SELECT title,cache FROM mybb_datacache
table type possible_keys key key_len ref rows Extra
mybb_datacache ALL 27
Query Time: 0.0125160217285
#3 - Select Query
SELECT * FROM mybb_sessions WHERE sid='c27c47abc0cd6f198504658190f12c3b' AND ip='74.214.150.176' LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_sessions const PRIMARY,ip PRIMARY 98 const 1
Query Time: 0.351912975311
#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.028666973114
#5 - Write Query
UPDATE mybb_sessions SET
Query Time: 0.000903129577637
#6 - Select Query
SELECT name, tid, properties, stylesheets FROM mybb_themes WHERE tid='5' LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_themes const PRIMARY PRIMARY 2 const 1
Query Time: 0.0066511631012
#7 - 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','3') ORDER BY sid ASC
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 640 Using where; Using filesort
Query Time: 0.110988140106
#8 - Select Query
SELECT tid, subject, lastposter, lastposteruid FROM mybb_threads ORDER BY lastpost DESC LIMIT 0, 10
table type possible_keys key key_len ref rows Extra
mybb_threads index lastpost 10 1241
Query Time: 0.01327085495
#9 - 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>'1305992475' ORDER BY u.username ASC, s.time DESC
table type possible_keys key key_len ref rows Extra
s range time time 8 7 Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 a8036588_mybb.s.uid 1
Query Time: 0.00088095664978
#10 - 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 26 Using where; Using filesort
fr eq_ref fid fid 8 a8036588_mybb.f.fid,const 1
Query Time: 0.00117802619934
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
Sorry for such a large post , but any help would be greatly appreciated. Thanks in advance.
Lubrack
I am running MyBB 1.6.3.
Plugins installed "None"
Host 000Webhost (Free)
Here is the problem i am having .When i click on my url, http://canadianwildfeeds.prairiewind.hostei.com/ I get this message through out the day , "The maximum server load limit has been reached. Please check back later once the server is less busy". Its a MyBB board Message , but does,nt show forums just that message . Or Sometime i just get this message " The server is too busy at the moment. Please reload this page few seconds later which is a message in my browser blank white page with message .
My forum is'nt overly busy as i may have maybe 20 visiters and maybe 2 registered users at most at one time. Tried optimizing database from users ACP and also checked Tables for errors in mybb and PHP Admin. Nothing seems to be working . I contacted host support and this is what they tell me this :
Hello,
If the server is busy (for example we setup a lot of new accounts at the same time), you may see this message briefly while server load returns to normal levels:
The server is too busy at the moment. Please reload this page few seconds later.
This message can be noticed on peak times only, and only for active servers (active servers are the servers where we add tons of new accounts every day). This message will permanently disappear as soon we will switch new account setups to another server (usually in few days).
I never ran into this problem before , its not only just during peak times but perty much all the time .
Here is my Debug Imformation:
MyBB Debug Information
Page Generation
Page Generation Statistics
Page Generation Time: 1.22097086906 seconds No. DB Queries: 10
PHP Processing Time: 0.6907895 seconds (56.58%) DB Processing Time: 0.5301814 seconds (43.42%)
Extensions Used: mysqli, xml Global.php Processing Time: 1.2017889 seconds
PHP Version: 5.2.13 Server Load: 29.86
GZip Encoding Status: Disabled No. Templates Used: 38 (46 Cached / 0 Manually Loaded)
Memory Usage: 3.25 MB (3407872 bytes) Memory Limit: 64M
Database Connections (1 Total)
[READ] [email protected] (Connected in 0s)
Database Queries (10 Total)
#1 - Write Query
SET NAMES 'utf8'
Query Time: 0.0014271736145
#2 - Select Query
SELECT title,cache FROM mybb_datacache
table type possible_keys key key_len ref rows Extra
mybb_datacache ALL 27
Query Time: 0.0125160217285
#3 - Select Query
SELECT * FROM mybb_sessions WHERE sid='c27c47abc0cd6f198504658190f12c3b' AND ip='74.214.150.176' LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_sessions const PRIMARY,ip PRIMARY 98 const 1
Query Time: 0.351912975311
#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.028666973114
#5 - Write Query
UPDATE mybb_sessions SET
uid
='1', time
='1305993375', location
='/index.php?debug=1', useragent
='Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/534.24 (KHTML, like Gecko) Chrome/11.0.696.68 Safari', location1
='0', location2
='0', nopermission
='0' WHERE sid='c27c47abc0cd6f198504658190f12c3b' LIMIT 1Query Time: 0.000903129577637
#6 - Select Query
SELECT name, tid, properties, stylesheets FROM mybb_themes WHERE tid='5' LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_themes const PRIMARY PRIMARY 2 const 1
Query Time: 0.0066511631012
#7 - 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','3') ORDER BY sid ASC
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 640 Using where; Using filesort
Query Time: 0.110988140106
#8 - Select Query
SELECT tid, subject, lastposter, lastposteruid FROM mybb_threads ORDER BY lastpost DESC LIMIT 0, 10
table type possible_keys key key_len ref rows Extra
mybb_threads index lastpost 10 1241
Query Time: 0.01327085495
#9 - 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>'1305992475' ORDER BY u.username ASC, s.time DESC
table type possible_keys key key_len ref rows Extra
s range time time 8 7 Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 a8036588_mybb.s.uid 1
Query Time: 0.00088095664978
#10 - 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 26 Using where; Using filesort
fr eq_ref fid fid 8 a8036588_mybb.f.fid,const 1
Query Time: 0.00117802619934
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
Sorry for such a large post , but any help would be greatly appreciated. Thanks in advance.
Lubrack