[ungelöst] Seite lädt sich tot....
Eingetragen von ahoek (570)am 17.11.2010 - 17:14 Uhr in
Hallo,
ich hoffe Ihr könnt mir bei einem Problem helfen.
Ich hatte auf:
www.chess-gran-canaria.com (Link entferne ich nachher wieder)
ein Facebook-Plugin eingebaut.
Ungefähr zur selben Zeit, begannen die Probleme mit den Ladezeiten.
Also habe ich das Plugin wieder entfernt.
Jetzt läuft die Seite manchmal, wie es soll und manchmal geht garnichts. Da wartet man minutenlang auf den Seitenaufbau.
Merkwürdig ist, dass alles Andere auf dem Server gut läuft, bis auf 2 D5-Installationen, die dann auch mit aussteigen.
Kann es sein, das irgendwo Fragmente von dem Plugin in der Seite herumschwirren, die den Load verhindern, da zuerst versucht wird, Facebook zu konnektieren?
Ich hatte so was mal mit einem Javascript.
Trotzdem ich alles entfernt hatte, blieb irgendwo was hängen und ich konnte keine neuen Scripte installieren. Bzw. die liefen dann nicht.
Nach einem Wechsel des Themes war alles wieder gut.
Kann vielleicht jemand von Euch mal nachsehen wo es hängen könnte?
- Anmelden oder Registrieren um Kommentare zu schreiben
Den Cache schon geleert?
am 18.11.2010 - 08:13 Uhr
Den Cache schon geleert?
Hatte ich bestimmt gemacht.
am 18.11.2010 - 10:20 Uhr
Hatte ich bestimmt gemacht. Weiß ich aber nicht mehr genau.
Ich habe es auf jeden Fall gerade nochmal wiederholt.
Das Problem ist, das genau in dieser Zeit auf dem Server zu viele offene Verbindungen sind. Leider kann ich mit dem, was mir der Serverstatus anzeigt nur begrenzt was anfangen.
Kann jemand von Euch was damit anfangen?
Ich würde dann mal einen Link schicken.
Ich denke das die Probleme daher rühren, da vorher alles lief und auf einen Schlag drei Seiten Probleme machen....
Am besten testest Du einfach
am 18.11.2010 - 10:25 Uhr
Am besten testest Du einfach was lange dauert.
Auf der Nutzerseite: Per firebug (Netzwerk tab) oder den chrom developer tools (recources tab)
Auf der Serverseite: Per devel modul http://www.drupalcenter.de/handbuch/4690 http://www.drupalcenter.de/handbuch/25685
Dann siehst Du genau was gemacht wird und wie lange es dauert. Dann kannst das Problem isolieren.
Grundsätzlich sind die 773 kb zu viel für die Startseite.
Frage: Wenn das laden lange dauert, läd dann die Seite scheinbar komplett nur der Browser zeigt weitere Ladeaktivität oder ist der Seitenaufbau selbst langsam?
Zu was genau sind zu viele
am 18.11.2010 - 10:28 Uhr
Zu was genau sind zu viele Verbindungen? mysql, apache?
Administrierst Du den Server selbst?
Ich prüfe das gleich
am 18.11.2010 - 10:28 Uhr
Ich prüfe das gleich mal.....
Frage: Wenn das laden lange dauert, läd dann die Seite scheinbar komplett nur der Browser zeigt weitere Ladeaktivität oder ist der Seitenaufbau selbst langsam?
Der Seitenaufbau selbst ist langsam (teilweise 5 Minuten) und dann ohne erkennbaren Grund, rennt die Seite wieder wie sie soll.
Zitat: Zu was genau sind zu
am 18.11.2010 - 10:37 Uhr
Zu was genau sind zu viele Verbindungen? mysql, apache?
Administrierst Du den Server selbst?
Auf dem Apache sind manchmal viele Verbindungen offen (w =sending Reply) und der CPU-Load geht teilweise auf 450%
Ich habe einen Managed-Server, kann aber vieles selber machen.
Was ich nicht kann, machen die Jungs dort in der Regel sofort. Da reicht ein Anruf.
Merkwürdig ist, dass andere Seiten super laufen. Die liegen sogar teilweise im gleichen Kunden-Account.
Nur bei drei Seiten treten diese ewig unbeantworteten Requests auf.
Sogar bei einer Seite, die ich per Chmod auf 000 gesetzt habe.....
ahoek schrieb Ich prüfe das
am 18.11.2010 - 10:53 Uhr
Ich prüfe das gleich mal.....
Der Seitenaufbau selbst ist langsam (teilweise 5 Minuten) und dann ohne erkennbaren Grund, rennt die Seite wieder wie sie soll.
d.h. white screen bis zum laden der html Seite?
Wenn es das ist dürfte Dir devel gut weiter helfen da du dann siehst ob Anfragen an die db oder an php lange dauern und welche der Anfrage lange dauert.
Zitat: d.h. white screen bis
am 18.11.2010 - 12:06 Uhr
d.h. white screen bis zum laden der html Seite?
Ja, und dann wieder als wenn nichts gewesen wäre.
Ich bau das Modul gleich mal ein.
Das Theme war der
am 18.11.2010 - 13:30 Uhr
Das Theme war der Verursacher!
Das ist eine Eigenheit des Zeropoint-Themes. Man löscht eingebaute externe Scripte (Bei mir einmal ein Javascript und jetzt das facebook-Plugin via iframe) und im Theme bleibt irgendwas zurück.
Nach einem Neuaufbau des Themes schnurrt die Seite und der Server wieder wie mein alter Kater.
Falls einer der Entwickler Interesse hat, könnte ich das Theme mit Fehler zur Verfügung stellen.
Das war es doch nicht....
am 18.11.2010 - 13:36 Uhr
Das war es doch nicht....
Hast Du denn jetzt mal Devel
am 18.11.2010 - 13:42 Uhr
Hast Du denn jetzt mal Devel laufen lassen und geschaut welche Funktion wie lange braucht?
Auf was steht Deine php max_execution_time? (Wenn Du sagst die Seite braucht 5 Minuten zum laden)
Das Hauptproblem war ein
am 18.11.2010 - 15:52 Uhr
Das Hauptproblem war ein veraltetes Modul in einer D5 Installation auf dem Server.
Wie das nun genau zusammenhängt, das ausgerechnet die beiden Seiten ausfallen....Kein Ahnung
Das Ding spinnt noch
am 18.11.2010 - 17:25 Uhr
Das Ding spinnt noch immer....
Hier was Devel nach einem langen Load ausgespuckt hat:
Executed 151 queries in 34.05 milliseconds. Queries taking longer than 5 ms and queries executed more than once, are highlighted. Page execution time was 500953.78 ms.ms
#
where
query
1.15
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'schema'
0.96
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'locale:de'
0.88
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'admin' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.6
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'theme_registry:zeropoint'
0.58
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:navigation:tree-data:a3d7c91bd5fb8f62948f23863d49e97d'
0.54
1
variable_set
UPDATE variable SET value = 's:4:\"HTTP\";' WHERE name = 'weather_fetch'
0.53
1
statistics_exit
INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values('', 'node', 'http://www.chess-gran-canaria.com/', '83.35.140.103', 1, '7fe9478ea660b4b7e886203efce01bfd', 500949, 1290097039)
0.52
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'modules/service_links/images/twitter.png' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.51
1
menu_tree_check_access
SELECT n.nid FROM node n WHERE (n.language ='de' OR n.language ='' OR n.language IS NULL) AND ( n.status = 1 AND n.nid IN (2, 3, 4, 12, 60, 153, 154, 155))
0.47
1
_weather_get_configs_in_use
SELECT * FROM weather_config WHERE uid=-1 ORDER BY weight ASC, real_name ASC
0.44
1
cache_clear_all
DELETE FROM cache WHERE cid = 'variables'
0.44
1
sess_write
UPDATE sessions SET uid = 1, cache = 0, hostname = '83.35.140.103', session = 'language|s:2:\"de\";', timestamp = 1290097039 WHERE sid = '7fe9478ea660b4b7e886203efce01bfd'
0.39
1
weather_store_metar
DELETE FROM weather WHERE icao='GCLP'
0.35
1
weather_store_metar
INSERT INTO weather (icao, next_update_on, metar_raw) VALUES ('GCLP', 1290099720, 'GCLP 181600Z 04012KT 9999 FEW025 23/17 Q1016 NOSIG')
0.32
1
module_list
SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC
0.31
1
fckeditor_profile_load
SELECT * FROM fckeditor_settings
0.3
1
user_load
SELECT * FROM users u WHERE uid = 1
0.29
1
sess_write
UPDATE users SET access = 1290097039 WHERE uid = 1
0.29
1
locale
SELECT s.lid, t.translation, s.version FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'de' WHERE s.source = 'Remove the ability for the user to drag the map. If dragging is disabled, keyboard shortcuts are implicitly disabled.' AND s.textgroup = 'default'
0.28
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'newsletter/subscriptions' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.28
1
user_roles
SELECT * FROM role ORDER BY name
0.27
1
simplenews_user_is_subscribed
SELECT COUNT(*) FROM simplenews_subscriptions s INNER JOIN simplenews_snid_tid t ON s.snid = t.snid WHERE s.mail = 'info@chess-gran-canaria.com' AND t.tid = 1
0.27
1
weather_get_latitude_longitude
SELECT latitude, longitude FROM weather_icao WHERE icao='GCLP'
0.27
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'faq' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.26
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'misc/powered-blue-80x15.png' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.26
1
locale
SELECT s.lid, t.translation, s.version FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'de' WHERE s.source = 'Create a new form or questionnaire accessible to users. Submission results and statistics are recorded and accessible to privileged users.' AND s.textgroup = 'default'
0.26
1
language_list
SELECT * FROM languages ORDER BY weight ASC, name ASC
0.25
1
locale
SELECT s.lid, t.translation, s.version FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'de' WHERE s.source = 'Enabling this will work around some issues that can occur when maps appear inside collapsible fieldsets.' AND s.textgroup = 'default'
0.25
1
menu_get_item
SELECT * FROM menu_router WHERE path IN ('node') ORDER BY fit DESC LIMIT 0, 1
0.25
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '3:f3ca9be9e90336bdbfab0ea925f1bb73'
0.25
1
uc_store_default_country
SELECT COUNT(*) FROM uc_countries WHERE country_id = 724 AND version > 0
0.25
1
node_load
SELECT n.nid, n.type, n.language, n.uid, n.status, n.created, n.changed, n.comment, n.promote, n.moderate, n.sticky, n.tnid, n.translate, r.vid, r.uid AS revision_uid, r.title, r.body, r.teaser, r.log, r.timestamp AS revision_timestamp, r.format, u.name, u.picture, u.data FROM node n INNER JOIN users u ON u.uid = n.uid INNER JOIN node_revisions r ON r.vid = n.vid WHERE n.nid = 1
0.24
1
_i18nblocks_list
SELECT * FROM i18n_blocks WHERE language = ''
0.24
1
locale
SELECT s.lid, t.translation, s.version FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'de' WHERE s.source = 'Disable dynamically resizing images while waiting for tiles to load when zooming.' AND s.textgroup = 'default'
0.24
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'admin/settings/actions' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.24
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'node/2' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.24
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'contact' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.23
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'modules/service_links/images/facebook.png' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.23
1
locale
SELECT s.lid, t.translation, s.version FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'de' WHERE s.source = 'Used for advanced javascript work, this will enable the <em>mouseovermarker</em>, <em>mouseoutmarker</em>, and <em>dblclickmarker</em> events.' AND s.textgroup = 'default'
0.23
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'user' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.23
1
taxonomy_get_term
SELECT * FROM term_data WHERE tid = 1
0.23
1
i18nmenu_get_router
SELECT title FROM menu_router WHERE path = 'image'
0.22
1
drupal_get_filename
SELECT filename FROM system WHERE name = 'zeropoint' AND type = 'theme'
0.22
1
fckeditor_profile_load
SELECT name, rid FROM fckeditor_role
0.22
1
locale
SELECT s.lid, t.translation, s.version FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'de' WHERE s.source = 'Load the marker loader system even if no markers to load are detected. Useful if you are injecting markers from somewhere else.' AND s.textgroup = 'default'
0.22
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'node/11' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.22
1
_i18nblocks_list
SELECT * FROM i18n_blocks WHERE language = 'de'
0.22
1
menu_local_tasks
SELECT * FROM menu_router WHERE tab_root = 'node' ORDER BY weight, title
0.21
1
block_block
SELECT body, format FROM boxes WHERE bid = 2
0.21
1
drupal_lookup_path
SELECT COUNT(pid) FROM url_alias
0.21
1
i18nmenu_get_router
SELECT title FROM menu_router WHERE path = 'node/%'
0.21
1
taxonomy_get_tree
SELECT t.tid, t.*, parent FROM term_data t INNER JOIN term_hierarchy h ON t.tid = h.tid WHERE (t.language ='de' OR t.language ='' OR t.language IS NULL) AND ( t.vid = 2 )ORDER BY weight, name
0.21
1
uc_address_format
SELECT * FROM uc_zones WHERE zone_id = 825
0.21
1
i18nmenu_get_router
SELECT title FROM menu_router WHERE path = ''
0.2
1
locale
SELECT s.lid, t.translation, s.version FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'de' WHERE s.source = 'Triggers are system events, such as when new content is added or when a user logs in. Trigger module combines these triggers with actions (functional tasks), such as unpublishing content or e-mailing an administrator. The <a href=\"@url\">Actions settings page</a> contains a list of existing actions and provides the ability to create and configure additional actions.' AND s.textgroup = 'default'
0.2
0
locale
SELECT s.lid, t.translation, s.version FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'de' WHERE s.source = ' Queries taking longer than @threshold ms and queries executed more than once, are <span class=\"marker\">highlighted</span>.' AND s.textgroup = 'default'
0.2
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '2:888f2170517da42dfbb90ef34a601f3d'
0.2
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:primary-links:page-cid:node:1'
0.2
1
locale
SELECT s.lid, t.translation, s.version FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'de' WHERE s.source = 'Used for advanced javascript work, this will enable the <em>clickshape</em> event.' AND s.textgroup = 'default'
0.19
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:secondary-links:page-cid:node:1'
0.19
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:primary-links:tree-data:bfbd30e6b1a111d354b02e8719a4b2b3'
0.19
1
i18nmenu_get_router
SELECT title FROM menu_router WHERE path = 'admin'
0.19
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'forum' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.19
1
i18nmenu_get_router
SELECT title FROM menu_router WHERE path = 'logout'
0.19
1
comment_nodeapi
SELECT last_comment_timestamp, last_comment_name, comment_count FROM node_comment_statistics WHERE nid = 1
0.19
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:secondary-links:tree-data:5d6d3aaaaef5fba302ce62698fa37bbe'
0.19
1
i18nmenu_get_router
SELECT title FROM menu_router WHERE path = 'profile'
0.19
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'taxonomy/term/1' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.19
1
nodewords_load_tags
SELECT * FROM nodewords WHERE type = 3 AND id = 0
0.19
1
i18nmenu_get_router
SELECT title FROM menu_router WHERE path = 'tracker'
0.19
1
user_load
SELECT r.rid, r.name FROM role r INNER JOIN users_roles ur ON ur.rid = r.rid WHERE ur.uid = 1
0.19
1
list_themes
SELECT * FROM system WHERE type = 'theme'
0.19
1
locale
SELECT s.lid, t.translation, s.version FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'de' WHERE s.source = 'An image (with thumbnail). This is ideal for publishing photographs or screenshots.' AND s.textgroup = 'default'
0.19
1
i18nmenu_get_router
SELECT title FROM menu_router WHERE path = 'map/macro'
0.18
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'taxonomy/term/1/0/feed' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.18
1
block_block
SELECT body, format FROM boxes WHERE bid = 5
0.18
1
simplenews_recent_newsletters
SELECT n.nid, n.title, sn.s_status, n.created FROM node n INNER JOIN term_node t ON n.vid = t.vid INNER JOIN simplenews_newsletters sn ON n.nid = sn.nid WHERE (n.language ='de' OR n.language ='' OR n.language IS NULL) AND ( (t.tid = 1 AND n.status = 1) )ORDER BY n.created DESC LIMIT 0, 5
0.18
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'node/60' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.18
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'node/12' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.18
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'node/154' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.18
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'image' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.18
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'node/4' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.18
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'node/3' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.18
1
profile_load_profile
SELECT f.name, f.type, v.value FROM profile_fields f INNER JOIN profile_values v ON f.fid = v.fid WHERE uid = 1
0.18
1
_node_types_build
SELECT nt.type, nt.* FROM node_type nt ORDER BY nt.type ASC
0.18
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'service_links_get_links'
0.18
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'user/1' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.18
1
block_list
SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta LEFT JOIN i18n_blocks i18n ON (b.module = i18n.module AND b.delta = i18n.delta) WHERE (i18n.language ='de' OR i18n.language ='' OR i18n.language IS NULL) AND ( b.theme = 'zeropoint' AND b.status = 1 AND (r.rid IN (2) OR r.rid IS NULL) )ORDER BY b.region, b.weight, b.module
0.18
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'node/155' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.18
1
nodewords_load_tags
SELECT * FROM nodewords WHERE type = 1 AND id = 0
0.18
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'node/153' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.18
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'node/add' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.18
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'map/macro' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.17
1
module_list
SELECT name, filename, throttle FROM system WHERE type = 'module' AND status = 1 AND bootstrap = 1 ORDER BY weight ASC, filename ASC
0.17
1
weather_get_metar
SELECT * FROM weather WHERE icao='GCLP'
0.17
1
locale
SELECT s.lid, t.translation, s.version FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'de' WHERE s.source = 'A <em>blog entry</em> is a single post to an online journal, or <em>blog</em>.' AND s.textgroup = 'default'
0.17
1
drupal_get_filename
SELECT filename FROM system WHERE name = 'user' AND type = 'module'
0.17
1
pager_query
SELECT n.nid, n.sticky, n.created FROM node n WHERE (n.language ='de' OR n.language ='' OR n.language IS NULL) AND ( n.promote = 1 AND n.status = 1 )ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 1
0.17
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'modules/service_links/images/misterwong.png' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.17
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'logout' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.17
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'modules/service_links/images/google.png' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.17
1
nodewords_load_tags
SELECT * FROM nodewords WHERE type = 8 AND id = 1
0.16
1
locale
SELECT s.lid, t.translation, s.version FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'de' WHERE s.source = 'This node represents two or more products that have been listed together. This presents a logical and convenient grouping of items to the customer.' AND s.textgroup = 'default'
0.16
1
locale
SELECT s.lid, t.translation, s.version FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'de' WHERE s.source = 'This node displays the representation of a product for sale on the website. It includes all the unique information that can be attributed to a specific model number.' AND s.textgroup = 'default'
0.16
1
_weather_get_config
SELECT * FROM weather_config WHERE uid=-1 AND cid=1
0.16
1
upload_load
SELECT * FROM files f INNER JOIN upload r ON f.fid = r.fid WHERE r.vid = 1 ORDER BY r.weight, f.fid
0.16
1
uc_address_format
SELECT * FROM uc_countries WHERE country_id = 724
0.16
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:navigation:page-cid:node:1'
0.16
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'variables:de'
0.16
1
menu_tree_check_access
SELECT n.nid FROM node n WHERE (n.language ='de' OR n.language ='' OR n.language IS NULL) AND ( n.status = 1 AND n.nid IN (11))
0.16
1
locale
SELECT s.lid, t.translation, s.version FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'de' WHERE s.source = 'A <em>poll</em> is a question with a set of possible responses. A <em>poll</em>, once created, automatically provides a simple running count of the number of votes received for each response.' AND s.textgroup = 'default'
0.16
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'misc/feed.png' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.16
1
node_access_view_all_nodes
SELECT COUNT(*) FROM node_access WHERE nid = 0 AND ((gid = 0 AND realm = 'all')) AND grant_view >= 1
0.16
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'node/1' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.15
1
locale
SELECT s.lid, t.translation, s.version FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t.language = 'de' WHERE s.source = 'A <em>forum topic</em> is the initial post to a new discussion thread within a forum.' AND s.textgroup = 'default'
0.15
1
page_title_load_title
SELECT page_title FROM page_title WHERE type = "node" AND id = 1
0.15
1
i18nmenu_get_router
SELECT title FROM menu_router WHERE path = 'filter/tips'
0.15
1
taxonomy_node_get_terms
SELECT t.* FROM term_node r INNER JOIN term_data t ON r.tid = t.tid INNER JOIN vocabulary v ON t.vid = v.vid WHERE r.vid = 1 ORDER BY v.weight, t.weight, t.name
0.15
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '3:0549cd10475a3a5e0f70f4ff93bf68af'
0.15
1
statistics_get
SELECT totalcount, daycount, timestamp FROM node_counter WHERE nid = 1
0.15
1
i18nmenu_get_router
SELECT title FROM menu_router WHERE path = 'search'
0.15
1
i18nmenu_get_router
SELECT title FROM menu_router WHERE path = 'catalog'
0.15
1
taxonomy_vocabulary_load
SELECT v.*, n.type FROM vocabulary v LEFT JOIN vocabulary_node_types n ON v.vid = n.vid WHERE v.vid = 1
0.15
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'node' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.15
1
i18nmenu_get_router
SELECT title FROM menu_router WHERE path = 'invite'
0.15
1
i18nmenu_get_router
SELECT title FROM menu_router WHERE path = 'poll'
0.15
1
i18nmenu_get_router
SELECT title FROM menu_router WHERE path = 'user/%'
0.14
1
i18nmenu_get_router
SELECT title FROM menu_router WHERE path = 'forum'
0.14
1
i18nmenu_get_router
SELECT title FROM menu_router WHERE path = 'contact'
0.14
1
i18nmenu_get_router
SELECT title FROM menu_router WHERE path = 'faq'
0.14
1
block_block
SELECT body, format FROM boxes WHERE bid = 4
0.14
1
filter_list_format
SELECT * FROM filters WHERE format = 3 ORDER BY weight, module, delta
0.14
1
_trigger_get_hook_aids
SELECT aa.aid, a.type FROM trigger_assignments aa LEFT JOIN actions a ON aa.aid = a.aid WHERE aa.hook = 'nodeapi' AND aa.op = 'view' ORDER BY weight
0.14
1
drupal_lookup_path
SELECT dst FROM url_alias WHERE src = 'rss.xml' AND language IN('de', '') ORDER BY language DESC, pid DESC
0.14
1
filter_format_allowcache
SELECT cache FROM filter_formats WHERE format = 3
0.14
1
nodewords_load_tags
SELECT * FROM nodewords WHERE type = 5 AND id = 1
0.14
1
pager_query
SELECT COUNT(*) FROM node n WHERE (n.language ='de' OR n.language ='' OR n.language IS NULL) AND ( n.promote = 1 AND n.status = 1 )
0.14
1
uc_product_node_info
SELECT pcid, name, description FROM uc_product_classes
0.14
1
system_region_list
SELECT info FROM system WHERE type = 'theme' AND name = 'zeropoint'
0.14
1
block_block
SELECT body, format FROM boxes WHERE bid = 8
0.14
1
i18nmenu_get_router
SELECT title FROM menu_router WHERE path = 'blog'
0.14
1
i18nmenu_get_router
SELECT title FROM menu_router WHERE path = 'weather'
0.14
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '2:8fae0d26d5073f10b5d4f1f87e0c3191'
0.14
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '2:4ecb78049d3f7f0e0253afdd54a15b9f'
0.14
1
cache_get
SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '2:c0f9bea7f90f1e25f2692b882f3a67e1'
0.14
1
filter_list_format
SELECT * FROM filters WHERE format = 2 ORDER BY weight, module, delta
0.14
1
i18nmenu_get_router
SELECT title FROM menu_router WHERE path = 'node/add'
0.13
1
sess_count
SELECT COUNT(sid) AS count FROM sessions WHERE timestamp >= 1290053338 AND uid = 0
0.13
1
filter_format_allowcache
SELECT cache FROM filter_formats WHERE format = 2
0.13
1
user_block
SELECT DISTINCT u.uid, u.name, s.timestamp FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.timestamp >= 1290053338 AND s.uid > 0 ORDER BY s.timestamp DESC
0.13
1
block_block
SELECT body, format FROM boxes WHERE bid = 7
0.12
1
drupal_lookup_path
SELECT src FROM url_alias WHERE dst = 'node' AND language IN('de', '') ORDER BY language DESC, pid DESC
Memory usage:
Memory used at: devel_init()=2.56 MB, devel_shutdown()=22.3 MB.
Das ist natürlich etwas
am 18.11.2010 - 19:28 Uhr
Das ist natürlich etwas schwer so zu lesen. ;)
Was am Anfang steht ist aber schon mal recht aussagekräftig:
Executed 151 queries in 34.05 milliseconds. Queries taking longer than 5 ms and queries executed more than once, are highlighted. Page execution time was 500953.78 ms.
Also 0,034 Sekunden für die DB Abfragen, 500 Sekunden für den Rest. Es ist schon überraschend, dass PHP nicht vorher abbricht (siehe letzte Frage). Jedenfalls liegt es nicht an der DB sondern eher am Apache. Ich würde jetzt schnell einen dump erstellen und schauen ob das Problem auch lokal auftritt und dann da ggf. weiter debuggen.
Ich glaube auch, das es der
am 19.11.2010 - 16:55 Uhr
Ich glaube auch, das es der Apache ist.
Auch wenn die Jungs mir dort immer wieder glaubhaft versichern, das es nicht so ist.
Im Serverstatus kann ich sehen, das Prozesse gestartet werden, wie sie beim Aufruf einer Webseite üblich sind.
Dieser Prozess wird nicht beendet, obwohl der Server nach 45 Sek einen 500er sendet. Manchmal bleibt dieser Prozess noch mehrere Minuten auf sending reply.
Erst wenn dieser Prozess beendet ist, kann man die Seite wieder erreichen.
Merkwürdig ist, dass es zwischendurch ein paar Stunden gut laufen kann.
Wichtig wäre vielleicht noch, das auf dem Server Updates eingespielt wurden und fcgi eingerichtet wurde und das Problem mehrere Webseiten betrifft.
Eine davon ist überhaupt nicht mehr aufrufbar.
Was kann das sein?
Wie gesagt, ich würde jetzt
am 19.11.2010 - 17:19 Uhr
Wie gesagt, ich würde jetzt die Seite auf einem Vergleichssystem testen um einen Fehler bei der Seite auszuschließen.
Wenn es wirklich am Apache hängt muss ich mich mit der Hilfe allerdings verabschieden, da kenne ich mich nur rudimentär aus. Den Bereich überlasse ich den Admins ;)
Du hast nicht zufällig eine
am 19.11.2010 - 17:34 Uhr
Du hast nicht zufällig eine Ecke auf Deinem Server, wo man das mal machen könnte?
Einen Server schon aber
am 19.11.2010 - 18:21 Uhr
Einen Server schon aber aktuell keine Zeit um mich darum zu kümmern. Sorry.
Schnapp Dir doch schnell XAMPP o.ä. http://www.apachefriends.org/de/xampp.html