[nobodyxxx]

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

[StefanT]

Mit dieser Beschreibung kann ich nichts anfangen...

[Jockl]

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]

Mit dieser Beschreibung kann ich nichts anfangen...

Würdst es Dir mal angucken wenn ich Dir die Zugangsdaten gebe!?

[StefanT]

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

[nobodyxxx]

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] [email protected] (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

[frostschutz]

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]

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]

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

[nobodyxxx]

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