MyBB.de Forum
Forum ist total laggy... - Druckversion

+- MyBB.de Forum (https://www.mybb.de/forum)
+-- Forum: Archiv (https://www.mybb.de/forum/forum-57.html)
+--- Forum: MyBB 1.6.x (https://www.mybb.de/forum/forum-58.html)
+---- Forum: Allgemeiner Support (https://www.mybb.de/forum/forum-59.html)
+---- Thema: Forum ist total laggy... (/thread-23182.html)

Seiten: Seiten: 1 2


RE: Forum ist total laggy... - frostschutz - 20.02.2011

Es sollte in der Debuginfo nun zusätzliche Zeiten anzeigen...


RE: Forum ist total laggy... - nobodyxxx - 20.02.2011

Hier die neue Debug-Info (bin eben schon wieder kaum drauf gekommen):

Zitat:MyBB Debug Information
Page Generation
Page Generation Statistics
Page Generation Time: 6.7120070457458 seconds No. DB Queries: 58
PHP Processing Time: 4.2940860 seconds (63.98%) DB Processing Time: 2.4179211 seconds (36.02%)
Extensions Used: mysql, xml Global.php Processing Time: 2.699853181839 seconds
PHP Version: 5.2.17 Server Load: 8.3594
GZip Encoding Status: Disabled No. Templates Used: 75 (71 Cached / 10 Manually Loaded)
Memory Usage: 6,5 MB (6815744 bytes) Memory Limit: 104M
Database Connections (1 Total)
[READ] U806924@rdbms.strato.de (Connected in 0s)

Database Queries (58 Total)
0.0139401
#1 - Write Query
SET NAMES 'utf8'
Query Time: 0.00024700164794922

0.0176420
#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.0026531219482422

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

0.1946850
#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.0034420490264893

0.8761551
#5 - Write Query
UPDATE mybb_sessions SET `uid`='1', `time`='1298223736', `location`='/index.php?debug=1', `useragent`='Mozilla/5.0 (Windows; U; Windows NT 6.1; de; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13', `location1`='0', `location2`='0', `nopermission`='0' WHERE sid='b94740dbffe03bbcecfc8978860cc7dd' LIMIT 1
Query Time: 0.2468159198761

1.1093950
#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 7 Using where
Query Time: 0.21832895278931

1.3341341
#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' ,'prostats' ,'prostats_readstate_icon' ,'prostats_newmembers' ,'prostats_newmembers_row' ,'prostats_topposters' ,'prostats_topposters_row' ,'prostats_topreferrers' ,'prostats_topreferrers_row' ,'prostats_mostthanks' ,'prostats_mostthanks_row' ,'prostats_newthreads' ,'prostats_newthreads_row' ,'prostats_newthreads_specialchar' ,'prostats_mostreplies' ,'prostats_mostreplies_row' ,'prostats_mostviews' ,'prostats_mostviews_row' ,'prostats_newposts' ,'prostats_newposts_row' ,'prostats_topdownloads' ,'prostats_topdownloads_row' ,'prostats_message' ,'prostats_onerowextra' ,'prostats_tworowextra' ,'thanks_postbit_count' ,'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','1') ORDER BY sid ASC
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 825 Using where; Using filesort
Query Time: 0.0011360645294189

(Plugin Hook: global_end)
2.6943951
#8 - Select Query
SELECT * FROM mybb_attachments WHERE `thumbnail` != '' ORDER BY aid DESC
table type possible_keys key key_len ref rows Extra
mybb_attachments ALL 303 Using where; Using filesort
Query Time: 0.0019919872283936

(Plugin Hook: global_end)
2.6959531
#9 - Select Query
SELECT * FROM mybb_posts WHERE pid='2835'
table type possible_keys key key_len ref rows Extra
mybb_posts const PRIMARY PRIMARY 4 const 1
Query Time: 0.00060701370239258

(Plugin Hook: global_end)
2.6981442
#10 - Select Query
SELECT template FROM mybb_templates WHERE title='atchgallery' 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 825 Using where; Using filesort
Query Time: 0.0009758472442627

(Plugin Hook: global_end)
2.6998532
#11 - Write Query
REPLACE INTO mybb_datacache SET `title`='atchgallery',`cache`='a:2:{s:7:\"content\";s:1611:\"<!-- start: atchgallery -->\n<br class=\"clear\" />\n<table border=\"0\" cellspacing=\"1\" cellpadding=\"4\" class=\"tborder\">\n <thead>\n <tr>\n <td class=\"thead\" colspan=\"6\">\n \n <div class=\"expcolimage\">\n <img src=\"images/collapse.gif\" id=\"atchgallery_id_img\" class=\"expander\" alt=\"[-]\" />\n </div>\n <div><strong>Die letzen Pic´s auf QFSH</strong></div>\n </td>\n </tr>\n </thead>\n <tbody style=\"\" id=\"atchgallery_id_e\">\n <tr style=\"height: 106px;\">\n <td class=\"trow1\" style=\"text-align: center; width: 16.666666666667%;\">\n <a href=\"showthread.php?tid=358&amp;pid=2835#pid2835\" target=\"_blank\"><img src=\"attachment.php?thumbnail=346\" class=\"attachment\" alt=\"\"></a>\n</td>\n<td class=\"trow1\" style=\"text-align: center; width: 16.666666666667%;\">\n <a href=\"showthread.php?tid=358&amp;pid=2835#pid2835\" target=\"_blank\"><img src=\"attachment.php?thumbnail=345\" class=\"attachment\" alt=\"\"></a>\n</td>\n<td class=\"trow1\" style=\"text-align: center; width: 16.666666666667%;\">\n <a href=\"showthread.php?tid=358&amp;pid=2835#pid2835\" target=\"_blank\"><img src=\"attachment.php?thumbnail=344\" class=\"attachment\" alt=\"\"></a>\n</td>\n<td class=\"trow1\" style=\"text-align: center; width: 16.666666666667%;\">\n <a href=\"showthread.php?tid=358&amp;pid=2835#pid2835\" target=\"_blank\"><img src=\"attachment.php?thumbnail=343\" class=\"attachment\" alt=\"\"></a>\n</td>\n<td class=\"trow1\" style=\"text-align: center; width: 16.666666666667%;\">\n <a href=\"showthread.php?tid=358&amp;pid=2835#pid2835\" target=\"_blank\"><img src=\"attachment.php?thumbnail=342\" class=\"attachment\" alt=\"\"></a>\n</td>\n\n </tr>\n </tbody>\n</table>\n<!-- end: atchgallery -->\";s:12:\"last_updated\";i:1298223738;}'
Query Time: 0.00050687789916992

(Plugin Hook: index_start)
3.0618892
#12 - Select Query
SELECT t.subject,t.username,t.uid,t.tid,t.fid,t.lastpost,t.lastposter,t.lastposteruid,t.replies,tr.uid AS truid,tr.dateline,f.name FROM mybb_threads t LEFT JOIN mybb_threadsread tr ON (tr.tid=t.tid AND tr.uid='1') LEFT JOIN mybb_forums f ON (f.fid = t.fid) WHERE t.visible='1' AND t.closed NOT LIKE 'moved|%' ORDER BY t.lastpost DESC LIMIT 0,11
table type possible_keys key key_len ref rows Extra
t index lastpost 10 309 Using where
tr eq_ref tid tid 8 DB806924.t.tid,const 1
f eq_ref PRIMARY PRIMARY 2 DB806924.t.fid 1
Query Time: 0.34129405021667

(Plugin Hook: index_start)
3.0800772
#13 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '71'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00049304962158203

(Plugin Hook: index_start)
3.0810840
#14 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '71'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00054407119750977

(Plugin Hook: index_start)
3.0825450
#15 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '21'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00041699409484863

(Plugin Hook: index_start)
3.2160220
#16 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '21'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.13298606872559

(Plugin Hook: index_start)
3.2485201
#17 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '71'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00028610229492188

(Plugin Hook: index_start)
4.2012851
#18 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '71'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00087714195251465

(Plugin Hook: index_start)
4.2025962
#19 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '71'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00052595138549805

(Plugin Hook: index_start)
4.2038722
#20 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '1'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00046896934509277

(Plugin Hook: index_start)
4.2059641
#21 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '8'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0010530948638916

(Plugin Hook: index_start)
5.0403750
#22 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '4'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.83309483528137

(Plugin Hook: index_start)
5.0419030
#23 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '70'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00063014030456543

(Plugin Hook: index_start)
5.0428691
#24 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '70'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00049185752868652

(Plugin Hook: index_start)
5.0439911
#25 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '38'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00034785270690918

(Plugin Hook: index_start)
5.0448780
#26 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '24'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00041294097900391

(Plugin Hook: index_start)
5.0459821
#27 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '38'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0003509521484375

(Plugin Hook: index_start)
5.0467410
#28 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '4'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00035500526428223

(Plugin Hook: index_start)
5.0481341
#29 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '2'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00042200088500977

(Plugin Hook: index_start)
5.0488591
#30 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '2'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00024795532226562

(Plugin Hook: index_start)
5.0505002
#31 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '9'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00076913833618164

(Plugin Hook: index_start)
5.0514970
#32 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '24'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00040888786315918

(Plugin Hook: index_start)
5.0527382
#33 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '16'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00034809112548828

(Plugin Hook: index_start)
5.0538921
#34 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '2'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00037813186645508

(Plugin Hook: index_start)
5.0574062
#35 - Write Query
SHOW COLUMNS FROM mybb_users LIKE 'thxcount'
Query Time: 0.002918004989624

(Plugin Hook: index_start)
5.0582561
#36 - Select Query
SELECT uid,username,usergroup,displaygroup,thxcount FROM mybb_users ORDER BY thxcount DESC LIMIT 0,5
table type possible_keys key key_len ref rows Extra
mybb_users ALL 66 Using filesort
Query Time: 0.00078201293945312

(Plugin Hook: index_start)
5.0599022
#37 - Select Query
SELECT uid,regdate,username,usergroup,displaygroup FROM mybb_users ORDER BY uid DESC LIMIT 0,5
table type possible_keys key key_len ref rows Extra
mybb_users index PRIMARY 4 66
Query Time: 0.00051712989807129

(Plugin Hook: index_start)
5.0627091
#38 - Select Query
SELECT t.subject,t.tid,t.replies,t.lastpost,tr.uid AS truid,tr.dateline FROM mybb_threads t LEFT JOIN mybb_threadsread tr ON (tr.tid=t.tid AND tr.uid='1') LEFT JOIN mybb_forums f ON (f.fid = t.fid) WHERE t.visible='1' AND t.closed NOT LIKE 'moved|%' ORDER BY t.replies DESC LIMIT 0,5
table type possible_keys key key_len ref rows Extra
t ALL 309 Using where; Using filesort
tr eq_ref tid tid 8 DB806924.t.tid,const 1
f eq_ref PRIMARY PRIMARY 2 DB806924.t.fid 1 Using index
Query Time: 0.0012049674987793

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

(Plugin Hook: index_start)
5.0672331
#40 - Select Query
SELECT t.subject,t.tid,t.lastpost,t.views,tr.uid AS truid,tr.dateline FROM mybb_threads t LEFT JOIN mybb_threadsread tr ON (tr.tid=t.tid AND tr.uid='1') LEFT JOIN mybb_forums f ON (f.fid = t.fid) WHERE t.visible='1' AND t.closed NOT LIKE 'moved|%' ORDER BY t.views DESC LIMIT 0,5
table type possible_keys key key_len ref rows Extra
t ALL 309 Using where; Using filesort
tr eq_ref tid tid 8 DB806924.t.tid,const 1
f eq_ref PRIMARY PRIMARY 2 DB806924.t.fid 1 Using index
Query Time: 0.0012319087982178

(Plugin Hook: index_start)
5.0697241
#41 - Select Query
SELECT u.uid,u.username,u.usergroup,u.displaygroup,count(*) as refcount FROM mybb_users u LEFT JOIN mybb_users r ON (r.referrer = u.uid) WHERE r.referrer = u.uid GROUP BY r.referrer DESC ORDER BY refcount DESC LIMIT 0 ,5
table type possible_keys key key_len ref rows Extra
r ALL 66 Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 DB806924.r.referrer 1
Query Time: 0.0012187957763672

(Plugin Hook: index_start)
5.0718992
#42 - Select Query
SELECT COUNT(pid) AS newposts FROM mybb_posts WHERE visible=1 AND dateline>'1298203048'
table type possible_keys key key_len ref rows Extra
mybb_posts range visible,dateline dateline 8 71 Using where
Query Time: 0.00021910667419434

(Plugin Hook: index_start)
5.0726950
#43 - Select Query
SELECT COUNT(tid) AS newthreads FROM mybb_threads WHERE visible=1 AND dateline>'1298203048'
table type possible_keys key key_len ref rows Extra
mybb_threads range dateline dateline 8 15 Using where
Query Time: 0.00034117698669434

(Plugin Hook: index_start)
5.0734651
#44 - Select Query
SELECT COUNT(tid) AS newann FROM mybb_threads WHERE visible=1 AND dateline>'1298203048' AND fid IN (2)
table type possible_keys key key_len ref rows Extra
mybb_threads ref fid,dateline fid 6 const,const 1 Using where
Query Time: 0.00041484832763672

(Plugin Hook: index_start)
5.0741541
#45 - Select Query
SELECT template FROM mybb_templates WHERE title='portal_welcome_membertext' 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 825 Using where; Using filesort
Query Time: 0.00025486946105957

(Plugin Hook: index_start)
5.0749140
#46 - Select Query
SELECT template FROM mybb_templates WHERE title='portal_welcome' 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 825 Using where; Using filesort
Query Time: 0.00020790100097656

(Plugin Hook: index_start)
5.0756810
#47 - Select Query
SELECT COUNT(*) AS pms_total, SUM(IF(status='0' AND folder='1','1','0')) AS pms_unread FROM mybb_privatemessages WHERE uid='1'
table type possible_keys key key_len ref rows Extra
mybb_privatemessages ref uid uid 4 const 236
Query Time: 0.00026392936706543

(Plugin Hook: index_start)
5.0763171
#48 - Select Query
SELECT template FROM mybb_templates WHERE title='portal_pms' 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 825 Using where; Using filesort
Query Time: 0.00023913383483887

(Plugin Hook: index_start)
5.0770402
#49 - Select Query
SELECT template FROM mybb_templates WHERE title='portal_stats' 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 825 Using where; Using filesort
Query Time: 0.00029397010803223

(Plugin Hook: index_start)
5.0777640
#50 - Select Query
SELECT template FROM mybb_templates WHERE title='portal_search' 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 825 Using where; Using filesort
Query Time: 0.00028204917907715

(Plugin Hook: index_start)
5.0792341
#51 - Select Query
SELECT s.sid, s.ip, s.uid, s.time, s.location, 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>'1298222836' ORDER BY u.username ASC, s.time DESC
table type possible_keys key key_len ref rows Extra
s range time time 8 18 Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 DB806924.s.uid 1
Query Time: 0.0010478496551514

(Plugin Hook: index_start)
5.2386260
#52 - Select Query
SELECT template FROM mybb_templates WHERE title='portal_whosonline_memberbit' 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 825 Using where; Using filesort
Query Time: 0.010980844497681

(Plugin Hook: index_start)
5.3200872
#53 - Select Query
SELECT template FROM mybb_templates WHERE title='portal_whosonline' 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 825 Using where; Using filesort
Query Time: 0.00028514862060547

(Plugin Hook: index_start)
6.0935121
#54 - Select Query
SELECT t.*, u.username FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid=t.uid) WHERE 1=1 AND t.visible='1' AND t.closed NOT LIKE 'moved|%' ORDER BY t.lastpost DESC LIMIT 0, 10
table type possible_keys key key_len ref rows Extra
t index lastpost 10 309 Using where
u eq_ref PRIMARY PRIMARY 4 DB806924.t.uid 1
Query Time: 0.53643298149109

(Plugin Hook: index_start)
6.1460981
#55 - Select Query
SELECT template FROM mybb_templates WHERE title='portal_latestthreads_thread' 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 825 Using where; Using filesort
Query Time: 0.00030517578125

(Plugin Hook: index_start)
6.1692522
#56 - Select Query
SELECT template FROM mybb_templates WHERE title='portal_latestthreads' 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 825 Using where; Using filesort
Query Time: 0.0011749267578125

6.2459950
#57 - 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>'1298222836' ORDER BY u.username ASC, s.time DESC
table type possible_keys key key_len ref rows Extra
s range time time 8 18 Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 DB806924.s.uid 1
Query Time: 0.022027015686035

6.3793151
#58 - 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 77 Using where; Using filesort
fr eq_ref fid fid 8 DB806924.f.fid,const 1
Query Time: 0.03545618057251

Template Statistics
Templates Used (Loaded for this Page) - 75 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, prostats_newmembers_row, prostats_topposters, prostats_topposters_row, prostats_topreferrers, prostats_topreferrers_row, prostats_mostthanks, prostats_mostthanks_row, prostats_newthreads, prostats_newthreads_row, prostats_newthreads_specialchar, prostats, prostats_readstate_icon, prostats_newmembers, prostats_mostreplies_row, prostats_mostviews, prostats_mostviews_row, prostats_newposts, prostats_mostreplies, prostats_newposts_row, prostats_topdownloads, prostats_topdownloads_row, prostats_message, prostats_onerowextra, prostats_tworowextra, thanks_postbit_count, atchgallery, forumdisplay, portal, portal_welcome_membertext, portal_welcome, portal_pms, portal_stats, portal_search, portal_whosonline_memberbit, portal_whosonline, portal_latestthreads_thread, portal_latestthreads

Templates Requiring Additional Calls (Not Cached at Startup) - 10 Total
atchgallery, portal_welcome_membertext, portal_welcome, portal_pms, portal_stats, portal_search, portal_whosonline_memberbit, portal_whosonline, portal_latestthreads_thread, portal_latestthreads



RE: Forum ist total laggy... - frostschutz - 20.02.2011

Ich würde da auf einen überforderten Host tippen. Es dauert ja schon fast 1 Sekunde bis überhaupt die Session geupdated wird. Durch die Debuginfo ist das natürlich auch nochmal langsamer als normal, aber trotzdem...

Zwischen Query #7 und #8 geht über eine Sekunde Zeit flöten, obwohl diese Queries angeblich jeweils nur 0.00x Sekunden brauchen. Da müsste man nun mal nachvollziehen was dazwischen denn alles gemacht wird, daß da so viel Zeit draufgeht.

Das zu debuggen, artet dann halt in mühevolle Kleinstarbeit aus. Man müsste noch die Hooks mit reinnehmen und unbedingt das Datenbank-Debugging (explain) rauswerfen da das hier nur das Ergebnis verfälscht...


RE: Forum ist total laggy... - nobodyxxx - 20.02.2011

Host ist Strato!

Mist mist mist... Das kann man Zeitweise imho echt keinem zumuten! Wenn das so weiter geht hauen mir die Leute ab... Sad

Irgend Jemand irgend einen Rat parat!?!?

Gruß NX


RE: Forum ist total laggy... - Jockl - 20.02.2011

Ich hatte auch eine Zeit lang das Webhosting-Paket von Strato. Die Shoutbox machte mir da immer ziemliche Schwierigkeiten. Ich würde an Deiner Stelle auf alle Fälle mal das refreshIntervall von derzeit 15 Sekunden deutlich nach oben setzen.

Was sagt denn der Load, wenn Du das Prostats-Plugin deaktivierst?

Allerdings scheint das Forum gerade mal wieder einigermaßen flott zu sein. Zumindest werden die Seiten recht schnell geladen.