MyBB Community Forums

I'm having site issues. Below are the stats. Obvisoulsy, something is wrong. I'm on a VPS with 304MB. My forum is relatively small. Most members are not currently active. I do have the SpiceFuse Shoutbox and have suspected that is the problem, but I can't confirm that. I'm in talks with one tech from my host and he's not sure what's going on. His last recommendation was to add more memory, but he said it a question-like way. It's not always slow either. It's sort of random.

http://www.ej8squad.com/index.php

"Our members have made a total of 132,272 posts in 8,954 threads.
We currently have 866 members registered."

Generated in 26.3605809 seconds (0.57% PHP / 99.43% MySQL)
SQL Queries: 20 / Global Parsing Time: 22.1832540 / Memory Usage: 7.5 MB
PHP version: 5.2.6 / Server Load: 0 / GZip Compression: Enabled

I've checked the error logs and there are some "Premature end of script headers:" sprinkled in there.

Plugins currently active:

Ads after first post (2.2)
Custom Pages (2.0)
Easy Refer (2.0)
My Awards (1.2)
Online Today (1.0)
Overview (3.1.1)
Private Messages Admin (2.4.1)
Prune Members (2.0)
Side Boxes! (3.0)
SpiceFuse Shoutbox (1.1 Beta 1)
Thread Viewer (1.0)
videolink (0.1)


System Health

Total Database Size 81.85 MB
Attachment Space used 108.8 MB
Total Cache Size 156.45 KB
Estimated Attachment Bandwidth Usage 4.09 GB
Max Upload / POST Size 7M / 8M
Average Attachment Size 149.75 KB

Any help would be appreciated.

Thanks,

Jeremy

Umm. Hmm.

Pretty sure generated in 20 seconds isn't good. I've never seen my forums go above 2 seconds (I have some very inefficient plugins).

What page were you loading when you got those statistics?

It's random. One time it takes 26 seconds and the other 5 seconds.

I was loading the index.

I don't know much about this but the fact the MySQL is at 99.43% doesn't look too good. 20 queries shouldn't take 20+ seconds to load, it looks like MySQL might be a bit limited, might be worth asking your host if they know why MySQL is at 99.43%.

Could be a number of different things. Being on a VPS might have something to do with it even.

Ask your host to investigate and see what you can do from there.

Click advance details at the bottom of the page and post your details here.

(2009-08-05, 01:58 PM)skywalker2208 Wrote: [ -> ]Click advance details at the bottom of the page and post your details here.

Here's my advanced stats. Decipher it please.

Quote:Page Generation Statistics
Page Generation Time: 7.8683040142059 seconds No. DB Queries: 21
PHP Processing Time: 2.1282952 seconds (27.05%) DB Processing Time: 5.7400088 seconds (72.95%)
Extensions Used: mysql, xml Global.php Processing Time: 2.9308600 seconds
PHP Version: 5.2.6 Server Load: 0
GZip Encoding Status: Enabled No. Templates Used: 45 (44 Cached / 7 Manually Loaded)
Memory Usage: 7.5 MB (7864320 bytes) Memory Limit: 90M
Database Connections (1 Total)

Database Queries (21 Total)
#1 - Select Query
SELECT title,cache FROM mybb_datacache
table type possible_keys key key_len ref rows Extra
mybb_datacache ALL 29
Query Time: 0.17540287971497

#2 - Select Query
SELECT * FROM mybb_sessions WHERE sid='7973047e697345eb0301ae54a71ab8aa' AND ip='66.41.53.149' LIMIT 1
table type possible_keys key key_len ref rows Extra
Impossible WHERE noticed after reading const tables
Query Time: 0.81587290763855

#3 - 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.040695905685425

#4 - Write Query
DELETE FROM mybb_sessions WHERE uid='1'
Query Time: 0.019609928131104

#5 - Write Query
REPLACE INTO mybb_sessions SET uid='1',sid='2c73f4ff39db5b64486c3b713f9e08eb',time='1249488218',ip='66.41.53.149',location='/index.php?debug=1',useragent='Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 (.NET CLR 3',location1='0',location2='0',nopermission='0'
Query Time: 0.03886604309082

#6 - 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 2 Using where
Query Time: 0.0376877784729

#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' ,'nav' ,'nav_sep' ,'nav_bit' ,'nav_sep_active' ,'nav_bit_active' ,'footer_languageselect' ,'header_welcomeblock_member_moderator' ,'redirect' ,'error') AND sid IN ('-2','-1','1') ORDER BY sid ASC
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 606 Using where; Using filesort
Query Time: 0.61080408096313

(Plugin Hook: index_start)
#8 - Select Query
SELECT name from mybb_settings WHERE name IN ('overview_do_newestusers','overview_do_topposters','overview_do_newestthreads','overview_do_mostreplies','overview_do_favouritethreads','overview_do_newestposts') ORDER BY value ASC
table type possible_keys key key_len ref rows Extra
mybb_settings ALL 322 Using where; Using filesort
Query Time: 0.012912034988403

(Plugin Hook: index_start)
#9 - Select Query
SELECT username,postnum,uid,usergroup,displaygroup FROM mybb_users ORDER BY postnum DESC LIMIT 0,10
table type possible_keys key key_len ref rows Extra
mybb_users ALL 867 Using filesort
Query Time: 0.73777604103088

(Plugin Hook: index_start)
#10 - Select Query
SELECT template FROM mybb_templates WHERE title='index_overview_column_topposters_row' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 606 Using where; Using filesort
Query Time: 0.029262065887451

(Plugin Hook: index_start)
#11 - Select Query
SELECT template FROM mybb_templates WHERE title='index_overview_column_topposters' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 606 Using where; Using filesort
Query Time: 0.02054500579834

(Plugin Hook: index_start)
#12 - Select Query
SELECT subject,username,uid,tid,replies FROM mybb_threads WHERE visible='1' AND closed NOT LIKE 'moved|%' ORDER BY dateline DESC LIMIT 0,10
table type possible_keys key key_len ref rows Extra
mybb_threads ALL 9035 Using where; Using filesort
Query Time: 0.053020000457764

(Plugin Hook: index_start)
#13 - Select Query
SELECT template FROM mybb_templates WHERE title='index_overview_column_newthreads_row' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 606 Using where; Using filesort
Query Time: 0.040956020355225

(Plugin Hook: index_start)
#14 - Select Query
SELECT template FROM mybb_templates WHERE title='index_overview_column_newthreads' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 606 Using where; Using filesort
Query Time: 0.024018049240112

(Plugin Hook: index_start)
#15 - Select Query
SELECT subject,username,uid,pid,tid FROM mybb_posts WHERE visible='1' ORDER BY dateline DESC LIMIT 0,10
table type possible_keys key key_len ref rows Extra
mybb_posts range visible visible 4 132549 Using where; Using filesort
Query Time: 0.93483901023865

(Plugin Hook: index_start)
#16 - Select Query
SELECT template FROM mybb_templates WHERE title='index_overview_column_newposts_row' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 606 Using where; Using filesort
Query Time: 0.0083940029144287

(Plugin Hook: index_start)
#17 - Select Query
SELECT template FROM mybb_templates WHERE title='index_overview_column_newposts' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 606 Using where; Using filesort
Query Time: 0.3346049785614

(Plugin Hook: index_start)
#18 - Select Query
SELECT template FROM mybb_templates WHERE title='index_overview' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 606 Using where; Using filesort
Query Time: 0.0122230052948

(Plugin Hook: index_start)
#19 - Select Query
SELECT u.* FROM mybb_users u LEFT JOIN mybb_usergroups g ON (g.gid=u.usergroup) WHERE u.lastactive > 1249401818 ORDER BY u.lastactive DESC
table type possible_keys key key_len ref rows Extra
u ALL 867 Using where; Using filesort
g eq_ref PRIMARY PRIMARY 2 ej8forum.u.usergroup 1 Using index
Query Time: 0.7313449382782

#20 - 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>'1249487318' ORDER BY u.username ASC, s.time DESC
table type possible_keys key key_len ref rows Extra
s ALL 817 Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 ej8forum.s.uid 1
Query Time: 0.024034976959229

#21 - 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 52 Using where; Using filesort
fr eq_ref fid fid 8 ej8forum.f.fid,const 1
Query Time: 0.36364507675171

Template Statistics
Templates Used (Loaded for this Page) - 45 Total
global_pm_alert, index, header_welcomeblock_member, forumbit_depth2_forum_lastpost, header_welcomeblock_member_admin, redirect, gobutton, index_boardstats, forumbit_depth2_forum, forumbit_depth3, forumbit_depth3_statusicon, forumbit_subforums, footer, headerinclude, nav_sep, nav_sep_active, header_welcomeblock_guest, header, forumbit_depth1_cat, index_pms, global_unreadreports, 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, header_welcomeblock_member_moderator, footer_languageselect, forumbit_depth1_forum_lastpost, index_overview_column_topposters_row, index_overview_column_topposters, index_overview_column_newthreads_row, index_overview_column_newthreads, index_overview_column_newposts_row, index_overview_column_newposts, index_overview

Templates Requiring Additional Calls (Not Cached at Startup) - 7 Total
index_overview_column_topposters_row, index_overview_column_topposters, index_overview_column_newthreads_row, index_overview_column_newthreads, index_overview_column_newposts_row, index_overview_column_newposts, index_overview

Queries usually take 0.000x seconds, in your database even simple querys take longer than half a second each. That's a bad joke. The database will either be external (i.e. not localhost) and/or simply hopelessly overloaded (and the server load 0 is fake).

Talk to your host about it (unless it's a free host of course). Get better hosting if necessary.

Yeah, I'm in talks with Knownhost right now. Looking to move away from Dreamhost. I did get a response from Dreamhost. I'm sure you all will get a laugh out of it.

Quote:Hi Jeremy,

I'm very sorry that you've been experiencing this poor performance.

We've run into quite a few customers with performance issues using the
MyBB software, and honestly that's probably the source of your issues.

The queries are generally poorly formed and run on the high side.

That being said I did find that the server was running a bit high on
memory usage. I've now patched that up, would you please let me know if
things seem improved?

Thanks!
Brandon

Then why is it nobody else has this problem, I wonder?? The hosts always blame the software...