MyBB Community Forums

Full Version: server load
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
I dont know much about these things. I just post to give an idea to the Thread starter so that he can decide on others review.

I too feel same that 1.6 have some perfomance problem comparison to 1.4 but there is no way to go back otherwise i prefer to stay with 1.4 till some good thing comes out. I have purchased vBulletin but at the end i decided to stay with myBB i dont know but i feel i am addicted of myBB Smile
If I knew this would be such a performance hit I would have stayed with 1.4x. The few extra features weren't worth it. I like 1.6x well enough but c'mon...double the queries? WTF
Thank you all for your answers.

I deactivated the Google SEO plugins and the difference is: [attachment=21229]

And the query list:
#1 - Write Query
SET NAMES 'utf8'
Query Time: 0.000102996826172

#2 - 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.00217509269714

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

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

#5 - Write Query
UPDATE mybb_sessions SET uid='1', time='1294614611', location='/index.php?debug=1', useragent='Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13 ( .NET CL', location1='0', location2='0', nopermission='0' WHERE sid='58232c1123ac9376ab01822b2237baa6' LIMIT 1
Query Time: 0.000198125839233

(Plugin Hook: global_start)
#6 - Select Query
SELECT * FROM mybb_board_messages WHERE enabled='1'
table type possible_keys key key_len ref rows Extra
mybb_board_messages system 1
Query Time: 8.70227813721E-5

#7 - 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 3 Using where
Query Time: 6.69956207275E-5

#8 - 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','12') ORDER BY sid ASC
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 731 Using where; Using filesort
Query Time: 0.00014591217041

(Plugin Hook: index_start)
#9 - Select Query
SELECT DISTINCT s.uid, s.ip, s.sid, s.time, s.location, u.username, s.nopermission, u.invisible, u.usergroup, u.displaygroup FROM mybb_sessions s LEFT JOIN mybb_users u ON (s.uid=u.uid) WHERE s.time > 1294528211 ORDER BY s.time DESC
table type possible_keys key key_len ref rows Extra
s ALL time 228 Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 studen_forum.s.uid 1
Query Time: 0.00239491462708

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

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

#12 - 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>'1294613711' ORDER BY u.username ASC, s.time DESC
table type possible_keys key key_len ref rows Extra
s range time time 8 41 Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 studen_forum.s.uid 1
Query Time: 0.000380992889404

#13 - 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 582 Using where; Using filesort
fr eq_ref fid fid 8 studen_forum.f.fid,const 1
Query Time: 0.00128102302551

Template Statistics
Templates Used (Loaded for this Page) - 40 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, online24_index, usergroup_legend

Templates Requiring Additional Calls (Not Cached at Startup) - 2 Total
online24_index, usergroup_legend




@Labrocca

iShare (1.1.0)
This plugin adds a box to the thread page with buttons to share/bookmark the thread. The buttons can be easily managed in the admin control panel.
Created by frinklabs
With this plugin you can share forum discussons to facebook,twitter,digg etc.
(2011-01-09, 08:19 PM)labrocca Wrote: [ -> ]If I knew this would be such a performance hit I would have stayed with 1.4x. The few extra features weren't worth it. I like 1.6x well enough but c'mon...double the queries? WTF

i think i got my solution , i am going to convert my board to SMF and then come back to 1.4 Stable that will save me or i have to buy 8 Core Dedicated this time Big Grin as holidays are going on and all want entertainment videos Toungue
Google SEO ain't your problem.

You've given us the index page export but you said the issue was when you're in forums. Can you do the same outputs for us for forumdisplay and showthread?
Could be bots indexing your forums too. Try banning some of them in AdminCP or directly through .htaccess

http://www.web-actually.fr/actualites-et...r-htaccess
Quote:1.6 is better than 1.4 in perfomance+core features in my opinion

Performance is measurable...it's not an opinion.
Forumdisplay with google seo active/deactivated:

[attachment=21248]
[attachment=21245]

Showthread with google seo active/deactivated:

[attachment=21247]
[attachment=21246]
I solved the problem by reducing the number of forums and subforums. So, the memory usage was reduced to half and everything seems to be better now.
Pages: 1 2