Login

nobodyxxx · Beiträge: 122 Themen: 14 Registriert seit: 20.11.2010

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

StefanT · 20.02.2011, 16:33

Mit dieser Beschreibung kann ich nichts anfangen...

Jockl · 20.02.2011, 16:43

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.

nobodyxxx · 20.02.2011, 16:55

(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

StefanT · 20.02.2011, 17:01

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

nobodyxxx · Beiträge: 122 Themen: 14 Registriert seit: 20.11.2010

(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 Sad

frostschutz · Beiträge: 2.318 Themen: 13 Registriert seit: 09.11.2008

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.

nobodyxxx · 20.02.2011, 17:53

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

frostschutz · 20.02.2011, 18:00

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

nobodyxxx · 20.02.2011, 18:17

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

Login
Benutzername:
Passwort:	Passwort vergessen?
	Merken