Hallo, Gast! (Registrieren)

Wir wünschen allen Besuchern frohe Ostern!

Letzte Ankündigung: MyBB 1.8.37 veröffentlicht (04.11.23)


Benutzer, die gerade dieses Thema anschauen: 2 Gast/Gäste
Forum ist total laggy...
#1
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 Angel... 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
#2
Mit dieser Beschreibung kann ich nichts anfangen...
[Bild: banner.png]

Bitte die Foren-Regeln beachten und im Profil die verwendete MyBB-Version angeben.
#3
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.
viele Grüße
Jockl
übersetzte und eigene Plugins
#4
(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!?

Confused
#5
Lieber nicht, Jockl ist vor dir dran. Toungue

Poste doch mal bitte die Debug-Statistik unten von der Seite, wenn es langsam bei dir ist. Am besten alle 3 Zeilen davon...
[Bild: banner.png]

Bitte die Foren-Regeln beachten und im Profil die verwendete MyBB-Version angeben.
#6
(20.02.2011, 17:01)StefanT schrieb: Lieber nicht, Jockl ist vor dir dran. Toungue

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 SadSadSad
#7
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.
#8
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
#9
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 Undecided
#10
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