MyBB Community Forums

Not sure if this is important but I just got a server load of 5.05 on a board running 1.4.9.
This is a test board.
NO Plugins activated but there are quite a few themes in there.
I'm getting similar stats still on the code from the 1.4.10 board I posted earlier.

ralgith fixed the side box plugin for that and that solved the original issue.

Any ideas?

MyBB Debug Information
Page Generation
Page Generation Statistics 
Page Generation Time: 0.077397108078003 seconds No. DB Queries: 18 
PHP Processing Time: 0.0492959 seconds (63.69%) DB Processing Time: 0.0281012 seconds (36.31%) 
Extensions Used: mysql, xml Global.php Processing Time: 0.0459061 seconds 
PHP Version: 5.2.3 Server Load: 3.83 
GZip Encoding Status: Enabled No. Templates Used: 72 (78 Cached / 0 Manually Loaded) 
Memory Usage: 3 MB (3145728 bytes) Memory Limit: 24M 

Database Connections (1 Total) 
xxxxxxx


Database Queries (18 Total) 
#1 - Write Query 
SET NAMES 'utf8' 
Query Time: 0.00048708915710449 

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

#3 - Select Query 
SELECT * FROM mybb_sessions WHERE sid='298a80c8cba153e9ef78e12a12c931fc' AND ip='74.105.29.98' LIMIT 1 
table type possible_keys key key_len ref rows Extra 
mybb_sessions const PRIMARY PRIMARY 98 const 1  
Query Time: 0.00061392784118652 

#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.00136399269104 

#5 - Write Query 
UPDATE mybb_sessions SET `uid`='1', `time`='1261082272', `location`='/mybb4test/forumdisplay.php?fid=4&debug=1', `useragent`='Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; SU 3.24; .NET CLR 1.1.4322; .NET CLR 2.0.50727; M', `location1`='4', `location2`='0', `nopermission`='0' WHERE sid='298a80c8cba153e9ef78e12a12c931fc' LIMIT 1  
Query Time: 0.00085115432739258 

#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     29 Using where 
Query Time: 0.00056099891662598 

#7 - Select Query 
SELECT title,template FROM mybb_templates WHERE title IN ('' ,'forumdisplay' ,'forumdisplay_thread' ,'breadcrumb_bit' ,'forumbit_depth1_cat' ,'forumbit_depth1_forum' ,'forumbit_depth2_cat' ,'forumbit_depth2_forum' ,'forumdisplay_subforums' ,'forumdisplay_threadlist' ,'forumdisplay_moderatedby_moderator' ,'forumdisplay_moderatedby' ,'forumdisplay_newthread' ,'forumdisplay_searchforum' ,'forumdisplay_orderarrow' ,'forumdisplay_thread_rating' ,'forumdisplay_announcement' ,'forumdisplay_threadlist_rating' ,'forumdisplay_threadlist_sortrating' ,'forumdisplay_subforums_modcolumn' ,'forumbit_moderators' ,'forumbit_subforums' ,'forumbit_depth2_forum_lastpost' ,'forumbit_depth1_forum_lastpost' ,'forumdisplay_thread_multipage_page' ,'forumdisplay_thread_multipage' ,'forumdisplay_thread_multipage_more' ,'multipage_prevpage' ,'multipage_nextpage' ,'multipage_page_current' ,'multipage_page' ,'multipage_start' ,'multipage_end' ,'multipage' ,'forumjump_advanced' ,'forumjump_special' ,'forumjump_bit' ,'forumdisplay_usersbrowsing_guests' ,'forumdisplay_usersbrowsing_user' ,'forumdisplay_usersbrowsing' ,'forumdisplay_inlinemoderation' ,'forumdisplay_thread_modbit' ,'forumdisplay_inlinemoderation_col' ,'forumdisplay_announcements_announcement' ,'forumdisplay_announcements' ,'forumdisplay_threads_sep' ,'forumbit_depth3_statusicon' ,'forumbit_depth3' ,'forumdisplay_sticky_sep' ,'forumdisplay_thread_attachment_count' ,'forumdisplay_threadlist_inlineedit_js' ,'forumdisplay_rssdiscovery' ,'forumdisplay_announcement_rating' ,'forumdisplay_announcements_announcement_modbit' ,'forumdisplay_rules_link' ,'forumdisplay_thread_gotounread' ,'forumdisplay_nothreads' ,'forumdisplay_inlinemoderation_custom_tool' ,'forumdisplay_inlinemoderation_custom' ,'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','64') ORDER BY sid ASC 
table type possible_keys key key_len ref rows Extra 
mybb_templates ALL     1691 Using where; Using filesort 
Query Time: 0.0041689872741699 

#8 - 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     10 Using where; Using filesort 
fr eq_ref fid fid 8 afishca_mybb14x.f.fid,const 1  
Query Time: 0.0013439655303955 

#9 - Select Query 
SELECT s.ip, s.uid, u.username, s.time, u.invisible, u.usergroup, u.usergroup, u.displaygroup FROM mybb_sessions s LEFT JOIN mybb_users u ON (s.uid=u.uid) WHERE s.time > '1261081372' AND location1='4' AND nopermission != 1 ORDER BY u.username ASC, s.time DESC  
table type possible_keys key key_len ref rows Extra 
s ref location1,time location1 4 const 2 Using where; Using temporary; Using filesort 
u eq_ref PRIMARY PRIMARY 4 afishca_mybb14x.s.uid 1  
Query Time: 0.00083708763122559 

#10 - Select Query 
SELECT threads, unapprovedthreads FROM mybb_forums WHERE fid = '4' LIMIT 1 
table type possible_keys key key_len ref rows Extra 
mybb_forums const PRIMARY PRIMARY 2 const 1  
Query Time: 0.00032997131347656 

#11 - Select Query 
SELECT a.*, u.username FROM mybb_announcements a LEFT JOIN mybb_users u ON (u.uid=a.uid) WHERE a.startdate<='1261082272' AND (a.enddate>='1261082272' OR a.enddate='0') AND ((fid='3' OR fid='4') OR fid='-1') ORDER BY a.startdate DESC LIMIT 0, 6  
table type possible_keys key key_len ref rows Extra 
       Impossible WHERE noticed after reading const tables 
Query Time: 0.00082707405090332 

#12 - Select Query 
SELECT t.*, (t.totalratings/t.numratings) AS averagerating, r.uid AS rated, t.username AS threadusername, u.username FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid = t.uid) LEFT JOIN mybb_threadratings r ON(r.tid=t.tid AND r.uid='1') WHERE t.fid='4' AND (t.visible='1' OR t.visible='0') ORDER BY t.sticky DESC, t.lastpost desc LIMIT 0, 20  
table type possible_keys key key_len ref rows Extra 
t ref fid fid 2 const 2 Using where; Using filesort 
u eq_ref PRIMARY PRIMARY 4 afishca_mybb14x.t.uid 1  
r ref tid tid 8 afishca_mybb14x.t.tid,const 1 Using index 
Query Time: 0.0011961460113525 

#13 - Select Query 
SELECT tid,uid FROM mybb_posts WHERE uid='1' AND tid IN (15,3,11,13,10) 
table type possible_keys key key_len ref rows Extra 
mybb_posts range tid,uid tid 8  27 Using where; Using index 
Query Time: 0.00031685829162598 

#14 - Select Query 
SELECT * FROM mybb_threadsread WHERE uid='1' AND tid IN (15,3,11,13,10) 
table type possible_keys key key_len ref rows Extra 
mybb_threadsread ALL tid    3 Using where 
Query Time: 0.00046610832214355 

#15 - Select Query 
SELECT dateline FROM mybb_forumsread WHERE fid='4' AND uid='1' 
table type possible_keys key key_len ref rows Extra 
mybb_forumsread const fid fid 8 const,const 1  
Query Time: 0.0004279613494873 

#16 - Select Query 
SELECT tid, name FROM mybb_modtools WHERE (CONCAT(',',forums,',') LIKE '%,4,%' OR CONCAT(',',forums,',') LIKE '%,-1,%' OR forums='') AND type = 't' 
table type possible_keys key key_len ref rows Extra 
       Impossible WHERE noticed after reading const tables 
Query Time: 0.00054001808166504 

#17 - Select Query 
SELECT COUNT(t.tid) AS unread_count FROM mybb_threads t LEFT JOIN mybb_threadsread tr ON (tr.tid=t.tid AND tr.uid='1') LEFT JOIN mybb_forumsread fr ON (fr.fid=t.fid AND fr.uid='1') WHERE t.visible=1 AND t.closed NOT LIKE 'moved|%' AND t.fid IN (4) AND t.lastpost > IFNULL(tr.dateline,1260477472) AND t.lastpost > IFNULL(fr.dateline,1260477472) AND t.lastpost>1260477472  
table type possible_keys key key_len ref rows Extra 
t ref fid,lastpost fid 6 const,const 5 Using where 
tr eq_ref tid tid 8 afishca_mybb14x.t.tid,const 1 Using where 
fr const fid fid 8 const,const 1 Using where 
Query Time: 0.0007178783416748 

#18 - Select Query 
SELECT fid FROM mybb_forumsubscriptions WHERE fid='4' AND uid='1' LIMIT 1 
table type possible_keys key key_len ref rows Extra 
       Impossible WHERE noticed after reading const tables 
Query Time: 0.00035691261291504 


Template Statistics
Templates Used (Loaded for this Page) - 72 Total 
forumdisplay_threadlist, forumdisplay_threadlist_sortrating, global_pm_alert, header_welcomeblock_member, header_welcomeblock_member_moderator, forumjump_advanced, forumdisplay_searchforum, header_welcomeblock_member_admin, forumdisplay_newthread, forumdisplay_inlinemoderation_custom, forumdisplay_inlinemoderation_custom_tool, forumdisplay_inlinemoderation, redirect, gobutton, forumdisplay_thread_rating, forumdisplay_announcement_rating, forumbit_depth2_forum, forumbit_depth3, forumbit_depth3_statusicon, forumbit_subforums, footer, forumdisplay_rules_link, forumdisplay, headerinclude, nav_sep, nav_sep_active, header_welcomeblock_guest, header, forumbit_depth1_cat, forumdisplay_thread_modbit, forumdisplay_thread_gotounread, forumdisplay_announcements_announcement, forumdisplay_announcements, forumdisplay_sticky_sep, forumdisplay_threads_sep, global_unreadreports, multipage, multipage_end, multipage_nextpage, multipage_page, multipage_page_current, multipage_prevpage, multipage_start, forumdisplay_subforums, forumdisplay_threadlist_rating, forumdisplay_thread, forumdisplay_orderarrow, forumdisplay_nothreads, forumbit_moderators, forumdisplay_thread_multipage, forumdisplay_thread_multipage_page, forumdisplay_thread_multipage_more, forumdisplay_usersbrowsing_user, forumdisplay_usersbrowsing, forumdisplay_inlinemoderation_col, forumjump_bit, forumjump_special, error, forumdisplay_moderatedby_moderator, forumdisplay_moderatedby, forumbit_depth2_cat, nav, nav_bit, nav_bit_active, htmldoctype, forumdisplay_threadlist_inlineedit_js, forumdisplay_thread_attachment_count, forumdisplay_rssdiscovery, footer_languageselect, forumdisplay_announcements_announcement_modbit, forumbit_depth2_forum_lastpost, forumbit_depth1_forum_lastpost 

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

Nothing out of the ordinary, Goggalor - there must be other software causing the additional load on the server.

Yeah, all four of the times there are 0.0x seconds, that's very good. If the server is under strain with those generation times, it sounds like it's on their end... MyBB is outputting stuff very quickly.

You know I was thinking the same thing that it has to be on the server end. It makes no sense that the pages load in split seconds but the server load fluctuates to such extremes.

Do you guys have any idea what could be on their end to do this so I can suggest it to them? They're very good about suggestions and trying to narrow problems down.

Could it be too many people hosted on the same server?

I've no clue but for some reason they tracked the first one to my one site and it listed the three others as you saw in the first post. Weird.

(2009-12-17, 03:51 PM)ralgith Wrote: [ -> ]Ok, but those are the STOCK portal templates. So they SHOULD BE cached, yes?

They are cached. However, the whole point of the cache is that you load all of the templates you need at once. If the plugin author doesn't use this functionality (i.e. if they call them individually) then they ruin the point of the cache and in the end cause lots of extra problems like this.

Ryan

(2009-12-17, 10:56 PM)Ryan Gordon Wrote: [ -> ]

(2009-12-17, 03:51 PM)ralgith Wrote: [ -> ]Ok, but those are the STOCK portal templates. So they SHOULD BE cached, yes?

They are cached. However, the whole point of the cache is that you load all of the templates you need at once. If the plugin author doesn't use this functionality (i.e. if they call them individually) then they ruin the point of the cache and in the end cause lots of extra problems like this.

Ryan

And this information is not in the wiki, and apparently not many plugin authors know about it. Labrocca's plugins don't cache anything either. Someone really should add this to the plugin authoring wiki. Your comment however isn't helpful at all, especially in light of the fact that there isn't any documentation on it. Not to mention that thanks to Tomm we already figured it out. I don't know why you're so negative towards myself and Goggalor, but it is somewhat irritating. Just like your comment on bug #594 that it doesn't seem like an issue. So what? It IS a bug, whether serious or not. And quite frankly your negativity is disgusting. I'm trying to be a contributing member of this community who helps to improve the software AND his own understanding of it.

I sometimes cache templates but that's normally in files that are in root and not too often just in straight plugins.

The MySideBoxes should be caching them so I am going to release an update today with a fix for this. Go check it in a few minutes.

Quote:Someone really should add this to the plugin authoring wiki.

The documentation for plugin authoring is really minimal and expects that you already understand php coding and how mybb works. It's never helped me. There should be a guide imho for basic standards fof MyBB plugin authoring for things like security, admin hooking, and template caching. Just more explanations I guess.

Either way I'll fix any plugin you think is giving you cache problems but realistically those few template calls on first page shouldn't be killing a server.

Just your sidebox plugin. It does the same as mine did. Loads all those portal templates without caching. Though I agree that none of this has made sense from the very beginning. And that I still have plenty to learn about MyBB's internal functions. Oh well. At least I learned something new today.

Quote:Just your sidebox plugin. It does the same as mine did. Loads all those portal templates without caching.

I don't understand what you mean. I just fixed my plugin which it appears you're using...and updated it for caching of those templates. I use caching normally but My Side Boxes is an old plugin.

EDIT: Apologies as I see you're probably not using my plugin. I was mentioned so that's why I assumed that's what it was.

An example though of one of my plugins using cache: http://www.skincitydesigns.com/bb/refer.php

So I do use it and I am aware of it.

Sorry, just none of the one's Goggalor is using (and she does have your side box plugin on some sites) seem to be using the cache was why I said that.