Page 1 of 1

Boardschnelligkeit

Posted: 26. May 2010 20:25
by 3nV|Tr0
Deine Portal Version: 1.0.5
Typ Deines phpBB Forums: Standard phpBB3
MODs installiert: Ja
Dein Wissensstand: Grundwissen
Link zu Deinem Forum: http://www.quaden.info

PHP Version: Weiss ich nich so genau, näheres im Posting
MySQL Version: Weiss ich nich so genau, näheres im Posting

Was hast Du gemacht, bevor das Problem aufgetreten ist?
nix

Was hast Du bereits versucht um das Problem zu lösen?
unnötige ordner / dateien gelöscht

Fehlerbeschreibung und Nachricht
Tach,
Seit geraumer zeit habe ich festgestellt das das board etwas "lahm" ist. Ich weiss nicht ob das am Portal liegt oder generell am server.
Wenn ich auf dem FTP unterwegs bin habe ich keinerlei beeinträchtigungen.

Es kommt realtiv häufig momentan vor das folgende Meldung sichtbar ist:

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, service@webmailer.de and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.


Bezüglich der Error log: Im webinterface von Strato sind keinerlei einträge in der Error Log vorhanden.

Ebenso habe ich eine andere Meldung welche meistens dann kommt wenn ich im ACP etwas umstellen will. Leider habe ich grade nicht die Meldung zur hand .. Kann nur ungefähr sagen das was mit capacity Problems dabei steht und irgendwas mit maintance oder so ...

Ich habe leider absolut keine ahnung was genau das problem ist ...

Es sind 5 Mods installiert.

Portalmod 1.0.5
Geomap
User Reminder
PHPBB Statiscis
Mod Version Check

Beim update von 3.0.5 auf 3.0.6 gab es jedoch schon probleme. Das ganze scheint aber ein hosterproblem zu sein da es nen timeout gibt .. Durch googlen habe ich dies sagen wir mal, mehr oder weniger raus gefunden. Ebenso ein paar wege wie man das umgehen könnte .. Schlussendlich bleibt mir nur ein lokales "update"

Ich weiss nicht ob dies damit zusammenhängen könnte weil:
3.0.5 auf 3.0.7-pl1 habe ich gemacht jedoch ohne die konvertierung der 200 dateien.

Ist es ein Datenbank problem oder eher ein Hosterproblem ? Liegt es am Portalmod oder generell an dem Forum selbst ?

greetz, envi

Re: Boardschnelligkeit

Posted: 26. May 2010 21:31
by Marc
Stelle mal Debug und Debug_Extra in der config.php an. Danach öffne z.B. das Portal und klicke im am unteren Rand des Forums auf Explain. Von der Seite bräuchte ich dann einen Screenshot oder Ähnliches.

Re: Boardschnelligkeit

Posted: 26. May 2010 22:39
by 3nV|Tr0
Hier it is:

Code: Select all

[phpBB Debug] PHP Notice: in file /portal/block/user_menu.php  on line 94: Undefined index: SEARCH_UNREAD
[phpBB Debug] PHP Notice: in file /portal/block/mini_cal.php on line 95: Undefined index: VIEW_PREVIOUS_MONTH
[phpBB Debug] PHP Notice: in file /portal/block/mini_cal.php on line 96: Undefined index: VIEW_NEXT_MONTH
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3853: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3247)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3855: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3247)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3856: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3247)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3857: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3247)
Return to previous page
SQL Report

Page generated in 1.7905 seconds with 49 queries + 5 queries returning data from cache

Time spent on mysqli queries: 0.05348s | Time spent on PHP: 1.73705s


Query #1
SELECT config_name, config_value FROM phpbb_config WHERE is_dynamic = 1
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_config	ref	is_dynamic	is_dynamic	1	const	21	 

Before: 0.35737s | After: 0.35833s | Elapsed: 0.00096s


Query #2
SELECT config_name, config_value FROM phpbb_portal_config
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_portal_config	ALL	 	 	 	 	97	 

Before: 0.47152s | After: 0.47253s | Elapsed: 0.00101s


Query #3
SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = '2d1fbfbe7628afc6b7c3816d5cddde8a' AND u.user_id = s.session_user_id
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	s	const	PRIMARY,session_user_id	PRIMARY	96	const	1	 
1	SIMPLE	u	const	PRIMARY	PRIMARY	3	const	1	 

Before: 0.48289s | After: 0.48473s | Elapsed: 0.00184s


Query #4
UPDATE phpbb_sessions SET session_time = 1274906340, session_page = 'portal.php?&explain=1', session_forum_id = 0 WHERE session_id = '2d1fbfbe7628afc6b7c3816d5cddde8a'
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_sessions	const	PRIMARY	PRIMARY	96	const	1	 

Affected rows: 1 | Before: 0.50148s | After: 0.50239s | Elapsed: 0.00091s


Query #5
UPDATE phpbb_users SET user_online_time = 590336 WHERE user_id = 2
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_users	const	PRIMARY	PRIMARY	3	const	1	 

Affected rows: 1 | Before: 0.50465s | After: 0.50545s | Elapsed: 0.00080s


Query results obtained from the cache
SELECT s.style_id, t.template_storedb, t.template_path, t.template_id, t.bbcode_bitfield, t.template_inherits_id, t.template_inherit_path, c.theme_path, c.theme_name, c.theme_storedb, c.theme_id, i.imageset_path, i.imageset_id, i.imageset_name FROM phpbb_styles s, phpbb_styles_template t, phpbb_styles_theme c, phpbb_styles_imageset i WHERE s.style_id = 23 AND t.template_id = s.template_id AND c.theme_id = s.theme_id AND i.imageset_id = s.imageset_id

Before: 0.55709s | After: 0.56193s | Elapsed [cache]: 0.00483s | Elapsed [db]: 0.00088s


Query results obtained from the cache
SELECT * FROM phpbb_styles_imageset_data WHERE imageset_id = 18 AND image_filename <> '' AND image_lang IN ('de', '')

Before: 0.57645s | After: 0.58673s | Elapsed [cache]: 0.01028s | Elapsed [db]: 0.00369s


Query #8
SELECT forum_id FROM phpbb_forums WHERE forum_id NOT IN (0, 21, 22, 23, 24, 25, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 62, 63, 64, 65, 66, 67, 68)
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_forums	index	PRIMARY	PRIMARY	3	 	41	Using where; Using index

Before: 0.60394s | After: 0.60476s | Elapsed: 0.00082s


Query #9
SELECT forum_id FROM phpbb_forums WHERE forum_type = 1 LIMIT 1
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_forums	ALL	 	 	 	 	41	Using where

Before: 0.61004s | After: 0.61092s | Elapsed: 0.00087s


Query #10
SELECT topic_title, forum_id, topic_id FROM phpbb_topics t WHERE topic_status <> 2 AND topic_approved = 1 AND (topic_type = 2 OR topic_type = 3) AND topic_moved_id = 0 ORDER BY topic_time DESC LIMIT 10
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	ref	topic_approved	topic_approved	1	const	117	Using where; Using filesort

Before: 0.61360s | After: 0.61457s | Elapsed: 0.00097s


Query #11
SELECT topic_title, forum_id, topic_id FROM phpbb_topics t WHERE topic_approved = 1 AND topic_replies >=25 AND topic_moved_id = 0 ORDER BY topic_time DESC LIMIT 10
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	ref	topic_approved	topic_approved	1	const	117	Using where; Using filesort

Before: 0.62323s | After: 0.62386s | Elapsed: 0.00063s


Query #12
SELECT topic_title, forum_id, topic_id FROM phpbb_topics t WHERE topic_status <> 2 AND topic_approved = 1 AND topic_type = 0 AND topic_moved_id = 0 ORDER BY topic_time DESC LIMIT 10
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	ref	topic_approved	topic_approved	1	const	117	Using where; Using filesort

Before: 0.62651s | After: 0.62733s | Elapsed: 0.00082s


Query #13
SELECT t.poll_title, t.poll_start, t.topic_id, t.topic_first_post_id, t.forum_id, t.poll_length, t.poll_vote_change, t.poll_max_options, t.topic_status, f.forum_status, p.bbcode_bitfield, p.bbcode_uid FROM phpbb_topics t, phpbb_posts p, phpbb_forums f WHERE t.forum_id = f.forum_id AND t.topic_approved = 1 AND t.poll_start > 0 AND t.forum_id IN (21, 22, 23, 24, 25, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 62, 63, 64, 65, 66, 67, 68) AND t.topic_moved_id = 0 AND p.post_id = t.topic_first_post_id AND (t.poll_start + t.poll_length > 1274906340 OR t.poll_length = 0) ORDER BY t.poll_start DESC LIMIT 3
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	ref	forum_id,forum_id_type,topic_approved,forum_appr_last,fid_time_moved	topic_approved	1	const	117	Using where; Using filesort
1	SIMPLE	f	eq_ref	PRIMARY	PRIMARY	3	DB556056.t.forum_id	1	 
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	3	DB556056.t.topic_first_post_id	1	 

Before: 0.66106s | After: 0.66499s | Elapsed: 0.00393s


Query #14
UPDATE phpbb_config SET config_value = '5f10690b12083f264c4fd49de496f81b' WHERE config_name = 'rand_seed'
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_config	const	PRIMARY	PRIMARY	767	const	1	 

Affected rows: 1 | Before: 0.67206s | After: 0.67281s | Elapsed: 0.00075s


Query #15
UPDATE phpbb_config SET config_value = '1274906340' WHERE config_name = 'rand_seed_last_update'
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_config	const	PRIMARY	PRIMARY	767	const	1	 

Affected rows: 1 | Before: 0.67489s | After: 0.67572s | Elapsed: 0.00082s


Query #16
SELECT * FROM phpbb_bbcodes
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_bbcodes	ALL	 	 	 	 	2	 

Before: 0.67852s | After: 0.67932s | Elapsed: 0.00080s


Query results obtained from the cache
SELECT * FROM phpbb_smilies ORDER BY LENGTH(code) DESC

Before: 0.70929s | After: 0.71553s | Elapsed [cache]: 0.00624s | Elapsed [db]: 0.00241s


Query results obtained from the cache
SELECT * FROM phpbb_bbcodes WHERE bbcode_id = 13

Before: 1.19448s | After: 1.20283s | Elapsed [cache]: 0.00835s | Elapsed [db]: 0.00099s


Query #19
SELECT t.forum_id, t.topic_id, t.topic_last_post_id, t.topic_last_post_time, t.topic_time, t.topic_title, t.topic_attachment, t.topic_views, t.poll_title, t.topic_replies, t.topic_replies_real, t.topic_poster, t.topic_type, t.topic_status, t.topic_last_poster_name, t.topic_last_poster_id, t.topic_last_poster_colour, t.icon_id, u.username, u.user_id, u.user_type, u.user_colour, p.post_id, p.poster_id, p.post_time, p.post_text, p.post_attachment, p.post_username, p.enable_smilies, p.enable_bbcode, p.enable_magic_url, p.bbcode_bitfield, p.bbcode_uid, f.forum_name, f.enable_icons, tp.topic_posted FROM (phpbb_topics t) LEFT JOIN phpbb_users u ON (t.topic_poster = u.user_id) LEFT JOIN phpbb_forums f ON (t.forum_id=f.forum_id) LEFT JOIN phpbb_posts p ON (t.topic_first_post_id = p.post_id) LEFT JOIN phpbb_topics_posted tp ON (tp.topic_id = t.topic_id AND tp.user_id = 2) WHERE (t.topic_type <> 2) AND (t.topic_type <> 3) AND t.topic_status <> 2 AND t.topic_approved = 1 AND t.topic_moved_id = 0 AND (t.forum_id = 27 OR t.forum_id = 28 OR t.forum_id = 29 OR t.forum_id = 30 OR t.forum_id = 31 OR t.forum_id = 32 OR t.forum_id = 33 OR t.forum_id = 34 OR t.forum_id = 35 OR t.forum_id = 36 OR t.forum_id = 37 OR t.forum_id = 38 OR t.forum_id = 50 OR t.forum_id = 51 OR t.forum_id = 52 OR t.forum_id = 53 OR t.forum_id = 54 OR t.forum_id = 55) ORDER BY t.topic_last_post_time DESC LIMIT 5
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	ref	forum_id,forum_id_type,topic_approved,forum_appr_last,fid_time_moved	topic_approved	1	const	117	Using where; Using filesort
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	3	DB556056.t.topic_poster	1	 
1	SIMPLE	f	eq_ref	PRIMARY	PRIMARY	3	DB556056.t.forum_id	1	 
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	3	DB556056.t.topic_first_post_id	1	 
1	SIMPLE	tp	eq_ref	PRIMARY	PRIMARY	6	const,DB556056.t.topic_id	1	 

Before: 1.23902s | After: 1.24410s | Elapsed: 0.00508s


Query #20
SELECT * FROM phpbb_attachments WHERE post_msg_id = 2131 AND in_message = 0 ORDER BY filetime DESC
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	 	 	 	 	 	 	 	Impossible WHERE noticed after reading const tables

Before: 1.24739s | After: 1.24815s | Elapsed: 0.00076s


Query #21
SELECT * FROM phpbb_attachments WHERE post_msg_id = 2099 AND in_message = 0 ORDER BY filetime DESC
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	 	 	 	 	 	 	 	Impossible WHERE noticed after reading const tables

Before: 1.25237s | After: 1.25317s | Elapsed: 0.00079s


Query #22
SELECT * FROM phpbb_attachments WHERE post_msg_id = 2102 AND in_message = 0 ORDER BY filetime DESC
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	 	 	 	 	 	 	 	Impossible WHERE noticed after reading const tables

Before: 1.27219s | After: 1.27300s | Elapsed: 0.00080s


Query #23
SELECT * FROM phpbb_attachments WHERE post_msg_id = 2118 AND in_message = 0 ORDER BY filetime DESC
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	 	 	 	 	 	 	 	Impossible WHERE noticed after reading const tables

Before: 1.28181s | After: 1.28279s | Elapsed: 0.00098s


Query #24
SELECT * FROM phpbb_attachments WHERE post_msg_id = 2103 AND in_message = 0 ORDER BY filetime DESC
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	 	 	 	 	 	 	 	Impossible WHERE noticed after reading const tables

Before: 1.29690s | After: 1.29797s | Elapsed: 0.00107s


Query #25
SELECT topic_id, mark_time FROM phpbb_topics_track WHERE user_id = 2 AND topic_id = '503'
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	 	 	 	 	 	 	 	Impossible WHERE noticed after reading const tables

Before: 1.30903s | After: 1.30977s | Elapsed: 0.00074s


Query #26
SELECT forum_id, mark_time FROM phpbb_forums_track WHERE user_id = 2 AND forum_id = 31
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_forums_track	const	PRIMARY	PRIMARY	6	const,const	1	 

Before: 1.31212s | After: 1.31418s | Elapsed: 0.00206s


Query #27
SELECT topic_id, mark_time FROM phpbb_topics_track WHERE user_id = 2 AND topic_id = '498'
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	 	 	 	 	 	 	 	Impossible WHERE noticed after reading const tables

Before: 1.32433s | After: 1.32528s | Elapsed: 0.00096s


Query #28
SELECT forum_id, mark_time FROM phpbb_forums_track WHERE user_id = 2 AND forum_id = 33
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_forums_track	const	PRIMARY	PRIMARY	6	const,const	1	 

Before: 1.32877s | After: 1.32990s | Elapsed: 0.00114s


Query #29
SELECT topic_id, mark_time FROM phpbb_topics_track WHERE user_id = 2 AND topic_id = '500'
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	 	 	 	 	 	 	 	Impossible WHERE noticed after reading const tables

Before: 1.34051s | After: 1.34111s | Elapsed: 0.00060s


Query #30
SELECT forum_id, mark_time FROM phpbb_forums_track WHERE user_id = 2 AND forum_id = 33
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_forums_track	const	PRIMARY	PRIMARY	6	const,const	1	 

Before: 1.34281s | After: 1.34350s | Elapsed: 0.00068s


Query #31
SELECT topic_id, mark_time FROM phpbb_topics_track WHERE user_id = 2 AND topic_id = '502'
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	 	 	 	 	 	 	 	Impossible WHERE noticed after reading const tables

Before: 1.35252s | After: 1.35343s | Elapsed: 0.00091s


Query #32
SELECT forum_id, mark_time FROM phpbb_forums_track WHERE user_id = 2 AND forum_id = 33
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_forums_track	const	PRIMARY	PRIMARY	6	const,const	1	 

Before: 1.35504s | After: 1.35573s | Elapsed: 0.00069s


Query #33
SELECT topic_id, mark_time FROM phpbb_topics_track WHERE user_id = 2 AND topic_id = '501'
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	 	 	 	 	 	 	 	Impossible WHERE noticed after reading const tables

Before: 1.36435s | After: 1.36502s | Elapsed: 0.00067s


Query #34
SELECT forum_id, mark_time FROM phpbb_forums_track WHERE user_id = 2 AND forum_id = 33
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_forums_track	const	PRIMARY	PRIMARY	6	const,const	1	 

Before: 1.36665s | After: 1.36728s | Elapsed: 0.00063s


Query #35
SELECT group_id, group_name, group_colour, group_type FROM phpbb_groups WHERE group_legend = 1 ORDER BY group_name ASC
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_groups	ref	group_legend_name	group_legend_name	1	const	2	Using where

Before: 1.38609s | After: 1.38697s | Elapsed: 0.00088s


Query #36
SELECT u.user_id, u.username, u.user_colour, u.user_birthday FROM phpbb_users u LEFT JOIN phpbb_banlist b ON (u.user_id = b.ban_userid) WHERE (b.ban_id IS NULL OR b.ban_exclude = 1) AND (u.user_birthday LIKE '26- 5-%' OR u.user_birthday LIKE ' 2- 6-%' OR u.user_birthday LIKE ' 1- 6-%' OR u.user_birthday LIKE '31- 5-%' OR u.user_birthday LIKE '30- 5-%' OR u.user_birthday LIKE '29- 5-%' OR u.user_birthday LIKE '28- 5-%' OR u.user_birthday LIKE '27- 5-%') AND u.user_type IN (0, 3) ORDER BY SUBSTRING(u.user_birthday FROM 4 FOR 2) ASC, SUBSTRING(u.user_birthday FROM 1 FOR 2) ASC, u.username_clean ASC
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	u	range	user_birthday,user_type	user_birthday	32	 	8	Using where; Using filesort
1	SIMPLE	b	ref	ban_user	ban_user	3	DB556056.u.user_id	1	Using where

Before: 1.41562s | After: 1.41691s | Elapsed: 0.00129s


Query #37
SELECT user_id, username, user_posts, user_colour FROM phpbb_users WHERE user_type <> 2 AND user_posts <> 0 ORDER BY user_posts DESC LIMIT 8
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_users	range	user_type	user_type	1	 	33	Using where; Using filesort

Before: 1.42540s | After: 1.42694s | Elapsed: 0.00153s


Query #38
SELECT user_id, username, user_regdate, user_colour FROM phpbb_users WHERE user_type <> 2 AND user_inactive_time = 0 ORDER BY user_regdate DESC LIMIT 8
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_users	range	user_type	user_type	1	 	33	Using where; Using filesort

Before: 1.44461s | After: 1.44625s | Elapsed: 0.00163s


Query #39
SELECT style_id, style_name FROM phpbb_styles WHERE style_active = 1 ORDER BY LOWER(style_name) ASC
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_styles	ALL	 	 	 	 	6	Using where; Using filesort

Before: 1.46690s | After: 1.46773s | Elapsed: 0.00083s


Query #40
SELECT style_id, style_name FROM phpbb_styles WHERE style_active = 1 ORDER BY style_name
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_styles	ALL	 	 	 	 	6	Using where; Using filesort

Before: 1.47048s | After: 1.47120s | Elapsed: 0.00072s


Query #41
SELECT COUNT(distinct t.topic_id) as total FROM phpbb_topics t WHERE t.topic_last_post_time > 1274893343 AND t.topic_moved_id = 0
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	range	last_post_time	last_post_time	4	 	8	Using where

Before: 1.48812s | After: 1.48890s | Elapsed: 0.00079s


Query #42
SELECT user_posts FROM phpbb_users WHERE user_id = 2
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_users	const	PRIMARY	PRIMARY	3	const	1	 

Before: 1.49113s | After: 1.49205s | Elapsed: 0.00092s


Query #43
SELECT COUNT(distinct t.topic_id) AS announcement_total FROM phpbb_topics t, phpbb_posts p WHERE t.topic_type = 2 AND p.post_id = t.topic_first_post_id
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	ALL	 	 	 	 	118	Using where
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	3	DB556056.t.topic_first_post_id	1	Using index

Before: 1.51680s | After: 1.51751s | Elapsed: 0.00071s


Query #44
SELECT COUNT(distinct t.topic_id) AS sticky_total FROM phpbb_topics t, phpbb_posts p WHERE t.topic_type = 1 AND p.post_id = t.topic_first_post_id
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	ALL	 	 	 	 	118	Using where
1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	3	DB556056.t.topic_first_post_id	1	Using index

Before: 1.52008s | After: 1.52135s | Elapsed: 0.00126s


Query #45
SELECT COUNT(attach_id) AS attachments_total FROM phpbb_attachments
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	 	 	 	 	 	 	 	Select tables optimized away

Before: 1.52356s | After: 1.52437s | Elapsed: 0.00080s


Query #46
SELECT group_id, group_name, group_colour, group_type FROM phpbb_groups WHERE group_legend = 1 ORDER BY group_name ASC
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_groups	ref	group_legend_name	group_legend_name	1	const	2	Using where

Before: 1.58460s | After: 1.58542s | Elapsed: 0.00082s


Query #47
SELECT u.user_id, u.username, u.user_colour, u.group_id FROM phpbb_users AS u WHERE u.group_id IN ('4', '10') ORDER BY u.username ASC
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	u	ALL	 	 	 	 	82	Using where; Using filesort

Before: 1.58824s | After: 1.58940s | Elapsed: 0.00116s


Query #48
SELECT DISTINCT u.user_id, u.username, u.username_clean, u.user_colour, u.user_allow_viewonline, MAX(s.session_time) as online_time, MIN(s.session_viewonline) AS viewonline FROM (phpbb_users u, phpbb_zebra z) LEFT JOIN phpbb_sessions s ON (s.session_user_id = z.zebra_id) WHERE z.user_id = 2 AND z.friend = 1 AND u.user_id = z.zebra_id GROUP BY z.zebra_id, u.user_id, u.username, u.username_clean, u.user_allow_viewonline, u.user_colour ORDER BY u.username_clean ASC LIMIT 8
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	 	 	 	 	 	 	 	Impossible WHERE noticed after reading const tables

Before: 1.59685s | After: 1.59778s | Elapsed: 0.00093s


Query #49
SELECT COUNT(DISTINCT s.session_ip) as num_guests FROM phpbb_sessions s WHERE s.session_user_id = 1 AND s.session_time >= 1274906040
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	s	ref	session_time,session_user_id	session_user_id	3	const	6	Using where

Before: 1.60788s | After: 1.60899s | Elapsed: 0.00112s


Query #50
SELECT s.session_user_id, s.session_ip, s.session_viewonline FROM phpbb_sessions s WHERE s.session_time >= 1274906040 AND s.session_user_id <> 1
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	s	range	session_time,session_user_id	session_time	4	 	5	Using where

Before: 1.61102s | After: 1.61180s | Elapsed: 0.00078s


Query #51
SELECT username, username_clean, user_id, user_type, user_allow_viewonline, user_colour FROM phpbb_users WHERE user_id IN (2, 55) ORDER BY username_clean ASC
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_users	range	PRIMARY	PRIMARY	3	 	2	Using where; Using filesort

Before: 1.61438s | After: 1.61544s | Elapsed: 0.00106s


Query #52
SELECT * FROM phpbb_portal_config LIMIT 1
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_portal_config	ALL	 	 	 	 	97	 

Before: 1.69975s | After: 1.70052s | Elapsed: 0.00077s


Query #53
SELECT config_name, config_value FROM phpbb_portal_config
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_portal_config	ALL	 	 	 	 	97	 

Before: 1.70252s | After: 1.70350s | Elapsed: 0.00097s


Query results obtained from the cache
SELECT forum_id, forum_name, parent_id, forum_type, left_id, right_id FROM phpbb_forums ORDER BY left_id ASC

Before: 1.74689s | After: 1.75423s | Elapsed [cache]: 0.00734s | Elapsed [db]: 0.00212s


Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
Solltest du daraus nich schlau werden und doch nen screenshot wünschen. Bescheid sagen :)

Tante €dit: beim screenshot würdest du jedoch nur die ersten 5 zeilens ehen. alle anderen sachen sind NICHT sichtbar auf dem screenshot!

Re: Boardschnelligkeit

Posted: 27. May 2010 10:22
by Marc
Naja, also der Screenshot würde schon einmal ausreichen. Der Grund für die Fehler sind wohl die alten Dateien, also die nicht konvertierten Dateien. Da fehlen dir ein paar Einträge in den Sprachdateien.

Re: Boardschnelligkeit

Posted: 27. May 2010 10:43
by 3nV|Tr0
Im screenshot würdest du wie gesagt nur:
[phpBB Debug] PHP Notice: in file /portal/block/user_menu.php on line 94: Undefined index: SEARCH_UNREAD
[phpBB Debug] PHP Notice: in file /portal/block/mini_cal.php on line 95: Undefined index: VIEW_PREVIOUS_MONTH
[phpBB Debug] PHP Notice: in file /portal/block/mini_cal.php on line 96: Undefined index: VIEW_NEXT_MONTH
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3853: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3247)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3855: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3247)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3856: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3247)
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 3857: Cannot modify header information - headers already sent by (output started at /includes/functions.php:3247)
Return to previous page
SQL Report
sehen.

Ich mach ihn dir gerne und lad ihn dir hoch. Das kann ich aber erst in 30 minuten oder so machen wenn ich zu hause bin :)

Re: Boardschnelligkeit

Posted: 27. May 2010 11:47
by 3nV|Tr0
Sie haben post :D

Re: Boardschnelligkeit

Posted: 27. May 2010 15:16
by Marc
Die beiden Fehler kannst du beseitigen, indem du die neuesten Sprachdateien von Board3 Portal nutzt.

Code: Select all

[phpBB Debug] PHP Notice: in file /portal/block/mini_cal.php on line 95: Undefined index: VIEW_PREVIOUS_MONTH
[phpBB Debug] PHP Notice: in file /portal/block/mini_cal.php on line 96: Undefined index: VIEW_NEXT_MONTH
Den Fehler wirst du nur los wenn du die Dateien deines phpBB3's aktulisierst:

Code: Select all

[phpBB Debug] PHP Notice: in file /portal/block/user_menu.php on line 94: Undefined index: SEARCH_UNREAD
Danach kann man dann auch erst sehen, was denn jetzt die große Ladezeit verursacht.

Re: Boardschnelligkeit

Posted: 27. May 2010 21:21
by 3nV|Tr0
Hier hab ich übrigens die 2te Fehlermeldung welche bei Postings, aenderungen im ACP etc auftritt:
Service Temporarily Unavailable

The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.

Re: Boardschnelligkeit

Posted: 28. May 2010 00:13
by Marc
Also wenn es wirklich bei allem Auftritt, dann würde ich dir doch mal empfehlen deinen Hoster zu kontaktieren. Mir kommt es eher so vor als ob du viele Webseiten auf einem Server des Hosters laufen oder eine andere Seite ein sehr resourcenintensives Skript laufen hat.