Forum ist total laggy... - nobodyxxx - 20.02.2011
Moin moin allerseits,
hab da gerade mal so eine mittlere Katastrophe bei mir im Forum! Seit dem ich auf 1.61 upgegradet hab wird mein Forum immer lahmer! Teilweise kommen einige User schon gar nicht mehr auf die Seite.
Hatte letzten alles an Cache erneuert und danach ging es ne Weile, nun wird es wieder schlimmer...
Abgesehen davon kann ich mir die Statistiken nicht mehr anzeigen lassen sowie direkt aus dem Admin CP meine Datenbank Sicherungen herunter laden!?!?
Hab da wohl in meinem jugendlichen Leichtsinn ne Menge verkehrt gemacht ... Und bräucht nun mal dringend Hilfe von Jemanden der wirklich weiss was er da tut (also anders als ich*lach*)....
Mein Forum: klick mich
Der NX sagt THX
RE: Forum ist total laggy... - StefanT - 20.02.2011
Mit dieser Beschreibung kann ich nichts anfangen...
RE: Forum ist total laggy... - Jockl - 20.02.2011
Scheint aber auch schon erledigt zu sein....
Auf der anderen Seite hört man ja auch immer wieder, dass ProStats bzgl. der Auslastung nicht ganz ohne sein soll.
RE: Forum ist total laggy... - nobodyxxx - 20.02.2011
(20.02.2011, 16:33)StefanT schrieb: Mit dieser Beschreibung kann ich nichts anfangen...
Würdst es Dir mal angucken wenn ich Dir die Zugangsdaten gebe!?
RE: Forum ist total laggy... - StefanT - 20.02.2011
Lieber nicht, Jockl ist vor dir dran.
Poste doch mal bitte die Debug-Statistik unten von der Seite, wenn es langsam bei dir ist. Am besten alle 3 Zeilen davon...
RE: Forum ist total laggy... - nobodyxxx - 20.02.2011
(20.02.2011, 17:01)StefanT schrieb: Lieber nicht, Jockl ist vor dir dran.
Poste doch mal bitte die Debug-Statistik unten von der Seite, wenn es langsam bei dir ist. Am besten alle 3 Zeilen davon... Code: MyBB Debug Information
Page Generation
Page Generation Statistics
Page Generation Time: 3.0012259483337 seconds No. DB Queries: 54
PHP Processing Time: 2.8093109 seconds (93.61%) DB Processing Time: 0.1919150 seconds (6.39%)
Extensions Used: mysql, xml Global.php Processing Time: 2.9035509 seconds
PHP Version: 5.2.17 Server Load: 7.918
GZip Encoding Status: Disabled No. Templates Used: 74 (71 Cached / 9 Manually Loaded)
Memory Usage: 6,25 MB (6553600 bytes) Memory Limit: 104M
Database Connections (1 Total)
[READ] U806924@rdbms.strato.de (Connected in 0s)
Database Queries (54 Total)
#1 - Write Query
SET NAMES 'utf8'
Query Time: 0.00034499168395996
#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.0023889541625977
#3 - Select Query
SELECT * FROM mybb_sessions WHERE sid='f52551e0df75ab57420025418cad891c' 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.0003669261932373
#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.16146492958069
#5 - Write Query
UPDATE mybb_sessions SET `uid`='1', `time`='1298217757', `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='f52551e0df75ab57420025418cad891c' LIMIT 1
Query Time: 0.0015220642089844
#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.00039887428283691
#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.00075197219848633
(Plugin Hook: index_start)
#8 - 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 306 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.00034904479980469
(Plugin Hook: index_start)
#9 - 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.00034403800964355
(Plugin Hook: index_start)
#10 - 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.00026702880859375
(Plugin Hook: index_start)
#11 - 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.00027894973754883
(Plugin Hook: index_start)
#12 - 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.00029683113098145
(Plugin Hook: index_start)
#13 - 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.00025701522827148
(Plugin Hook: index_start)
#14 - 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.00024890899658203
(Plugin Hook: index_start)
#15 - 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.00030088424682617
(Plugin Hook: index_start)
#16 - 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.0001680850982666
(Plugin Hook: index_start)
#17 - 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.00030183792114258
(Plugin Hook: index_start)
#18 - 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.00021982192993164
(Plugin Hook: index_start)
#19 - 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.00027799606323242
(Plugin Hook: index_start)
#20 - 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.00020718574523926
(Plugin Hook: index_start)
#21 - 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.00025486946105957
(Plugin Hook: index_start)
#22 - 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.00021600723266602
(Plugin Hook: index_start)
#23 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '57'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0002601146697998
(Plugin Hook: index_start)
#24 - 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.00017690658569336
(Plugin Hook: index_start)
#25 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '51'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00027108192443848
(Plugin Hook: index_start)
#26 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '51'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0005640983581543
(Plugin Hook: index_start)
#27 - 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.00021600723266602
(Plugin Hook: index_start)
#28 - 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.00020885467529297
(Plugin Hook: index_start)
#29 - 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.00022602081298828
(Plugin Hook: index_start)
#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.00019288063049316
(Plugin Hook: index_start)
#31 - Write Query
SHOW COLUMNS FROM mybb_users LIKE 'thxcount'
Query Time: 0.0036921501159668
(Plugin Hook: index_start)
#32 - 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 65 Using filesort
Query Time: 0.00093293190002441
(Plugin Hook: index_start)
#33 - 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 65
Query Time: 0.00044083595275879
(Plugin Hook: index_start)
#34 - 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 306 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.00032997131347656
(Plugin Hook: index_start)
#35 - 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 65 Using filesort
Query Time: 0.00064682960510254
(Plugin Hook: index_start)
#36 - 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 306 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.00027799606323242
(Plugin Hook: index_start)
#37 - 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 65 Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 DB806924.r.referrer 1
Query Time: 0.00098419189453125
(Plugin Hook: index_start)
#38 - 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 70 Using where
Query Time: 0.00018310546875
(Plugin Hook: index_start)
#39 - 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 5 Using where
Query Time: 0.00045394897460938
(Plugin Hook: index_start)
#40 - 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.00018596649169922
(Plugin Hook: index_start)
#41 - 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.00020217895507812
(Plugin Hook: index_start)
#42 - 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.00022697448730469
(Plugin Hook: index_start)
#43 - 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 248
Query Time: 0.0004889965057373
(Plugin Hook: index_start)
#44 - 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.00018811225891113
(Plugin Hook: index_start)
#45 - 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.00036501884460449
(Plugin Hook: index_start)
#46 - 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.00026082992553711
(Plugin Hook: index_start)
#47 - 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>'1298216857' ORDER BY u.username ASC, s.time DESC
table type possible_keys key key_len ref rows Extra
s range time time 8 8 Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 DB806924.s.uid 1
Query Time: 0.00067996978759766
(Plugin Hook: index_start)
#48 - 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.0003960132598877
(Plugin Hook: index_start)
#49 - 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.0002589225769043
(Plugin Hook: index_start)
#50 - 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 306 Using where
u eq_ref PRIMARY PRIMARY 4 DB806924.t.uid 1
Query Time: 0.00091791152954102
(Plugin Hook: index_start)
#51 - 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.0002288818359375
(Plugin Hook: index_start)
#52 - 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.0002129077911377
#53 - 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>'1298216857' ORDER BY u.username ASC, s.time DESC
table type possible_keys key key_len ref rows Extra
s range time time 8 8 Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 DB806924.s.uid 1
Query Time: 0.00063109397888184
#54 - 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.00047397613525391
Template Statistics
Templates Used (Loaded for this Page) - 74 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, 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) - 9 Total
portal_welcome_membertext, portal_welcome, portal_pms, portal_stats, portal_search, portal_whosonline_memberbit, portal_whosonline, portal_latestthreads_thread, portal_latestthreads
Jetzt in diesem Moment braucht das Forum gerade wieder bald ne Minute zum laden
RE: Forum ist total laggy... - frostschutz - 20.02.2011
Die Debugausgabe sagt leider gar nichts genaues dazu aus, wo in PHP die Zeit drauf geht. Kann ja allgemein sein (dann ist die Kiste einfach überlastet), kann aber auch an einer bestimmten Stelle passieren (z.B. ein Plugin das blockiert), und da wärs dann gut die Stelle zu finden.
Bau mal in db_mysqli.php (oder falls du nicht mysqli sondern mysql benutzt, db_mysql.php) ein:
Nach:
PHP-Code: function explain_query($string, $qtime) { global $plugins;
if($plugins->current_hook) { $debug_extra = "<div style=\"float_right\"> (Plugin Hook: {$plugins->current_hook})</div>"; }
Einfügen:
PHP-Code: global $maintimer; $debug_extra .= $maintimer->format($maintimer->stop());
Für eine feinere Auflösung müsste man das auch noch in den Hooks oder in den Dateien selbst machen, aber vielleicht reicht es ja schon mit den Queries.
RE: Forum ist total laggy... - nobodyxxx - 20.02.2011
Ich finde in der DB nur das hier (wo soll ich da den Code genau einfügen!?):
function explain_query($string, $qtime)
{
global $plugins;
if($plugins->current_hook)
{
$debug_extra = "<div style=\"float_right\">(Plugin Hook: {$plugins->current_hook})</div>";
}
if(preg_match("#^\s*select#i", $string))
{
$query = mysql_query("EXPLAIN $string", $this->current_link);
$this->explain .= "<table style=\"background-color: #666;\" width=\"95%\" cellpadding=\"4\" cellspacing=\"1\" align=\"center\">\n".
"<tr>\n".
"<td colspan=\"8\" style=\"background-color: #ccc;\">{$debug_extra}<div><strong>#".$this->query_count." - Select Query</strong></div></td>\n".
"</tr>\n".
"<tr>\n".
"<td colspan=\"8\" style=\"background-color: #fefefe;\"><span style=\"font-family: Courier; font-size: 14px;\">".$string."</span></td>\n".
"</tr>\n".
"<tr style=\"background-color: #efefef;\">\n".
"<td><strong>table</strong></td>\n".
"<td><strong>type</strong></td>\n".
"<td><strong>possible_keys</strong></td>\n".
"<td><strong>key</strong></td>\n".
"<td><strong>key_len</strong></td>\n".
"<td><strong>ref</strong></td>\n".
"<td><strong>rows</strong></td>\n".
"<td><strong>Extra</strong></td>\n".
"</tr>\n";
THX NX
RE: Forum ist total laggy... - frostschutz - 20.02.2011
Da wo ich geschrieben hab ... nach dem oberen Block den unteren einfügen, der obere Block ist ja in dem was du gepostet hast drin
RE: Forum ist total laggy... - nobodyxxx - 20.02.2011
Ok, hab ich gemacht! (Sorry bin halt imho nen bisl vorsichtig beim code einfügen! Hab da wohl schon viel zu viel Mist gebaut)...
Magst mir denn auch gerade mal kurz erklären was das jetzt nun genau bewirken soll!? Möcht ja auch dazu lernen...
Greetz und THX NX
|