Hallo, habe ein Problem. Wollte eine Homepage auf einen vServer hochladen. Die Datenbanken sind schon etwas größer. Die gzip-Export Datei ist ca. 10MB groß.
Die Seite braucht für den Seitenaufbau extrem lange. Die CPU ist dabei laut Parallels Business Automation über 100% ausgelastet. Der Server hat 2,7GHz.
Ist der Profi hier:
Auch die Datenbanken dauern extrem lang zum laden. Komplett die selbe Datenbank und der selbe Space laufen aber auf einen anderen Server flüssig, mit ca. der selben(schwächeren) Hardware.
Am Server wurde rein GAR NICHTS noch geändert, da ich die Performance des Blogs testen wollte. Also nur die Domain via Confixx Angelegt und Dateien und Datenbank übertragen
Kann mir jemand helfen?
Hier noch die generierten SQL-Befehle, von Wordpress:
Die Seite braucht für den Seitenaufbau extrem lange. Die CPU ist dabei laut Parallels Business Automation über 100% ausgelastet. Der Server hat 2,7GHz.
Ist der Profi hier:
Auch die Datenbanken dauern extrem lang zum laden. Komplett die selbe Datenbank und der selbe Space laufen aber auf einen anderen Server flüssig, mit ca. der selben(schwächeren) Hardware.
Am Server wurde rein GAR NICHTS noch geändert, da ich die Performance des Blogs testen wollte. Also nur die Domain via Confixx Angelegt und Dateien und Datenbank übertragen
Kann mir jemand helfen?
Hier noch die generierten SQL-Befehle, von Wordpress:
Code:
<!--
20 queries. 8.040 seconds.
array(20) {
[0]=>
array(3) {
[0]=>
string(71) "SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'"
[1]=>
float(0.338349819183)
[2]=>
string(88) "require, require_once, require_once, require_once, is_blog_installed, wp_load_alloptions"
}
[1]=>
array(3) {
[0]=>
string(49) "SELECT * FROM wp_users WHERE user_login = 'admin'"
[1]=>
float(0.0504579544067)
[2]=>
string(160) "require, require_once, require_once, require_once, WP->init, wp_get_current_user, get_currentuserinfo, wp_validate_auth_cookie, get_userdatabylogin, get_user_by"
}
[2]=>
array(3) {
[0]=>
string(62) "SELECT meta_key, meta_value FROM wp_usermeta WHERE user_id = 1"
[1]=>
float(0.0133190155029)
[2]=>
string(172) "require, require_once, require_once, require_once, WP->init, wp_get_current_user, get_currentuserinfo, wp_validate_auth_cookie, get_userdatabylogin, get_user_by, _fill_user"
}
[3]=>
array(3) {
[0]=>
string(257) " SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_posts.post_date)='2010' AND MONTH(wp_posts.post_date)='1' AND wp_posts.post_name = 'neuer-status-und-neuer-name-fur-ibluetooth-2-0' AND wp_posts.post_type = 'post' ORDER BY wp_posts.post_date DESC "
[1]=>
float(0.0154850482941)
[2]=>
string(76) "require, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts"
}
[4]=>
array(3) {
[0]=>
string(286) "SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (5219) ORDER BY t.name ASC"
[1]=>
float(0.026654958725)
[2]=>
string(143) "require, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, update_post_caches, update_object_term_cache, wp_get_object_terms"
}
[5]=>
array(3) {
[0]=>
string(77) "SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (5219)"
[1]=>
float(0.0151710510254)
[2]=>
string(138) "require, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, update_post_caches, update_postmeta_cache, update_meta_cache"
}
[6]=>
array(3) {
[0]=>
string(173) " SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.ID ASC LIMIT 0, 1"
[1]=>
float(0.166357040405)
[2]=>
string(247) "require, require_once, include, get_header, locate_template, load_template, require_once, wp_head, do_action, call_user_func_array, start_post_rel_link, get_boundary_post_rel_link, get_boundary_post, get_posts, WP_Query->query, WP_Query->get_posts"
}
[7]=>
array(3) {
[0]=>
string(19) "SELECT FOUND_ROWS()"
[1]=>
float(0.163440942764)
[2]=>
string(247) "require, require_once, include, get_header, locate_template, load_template, require_once, wp_head, do_action, call_user_func_array, start_post_rel_link, get_boundary_post_rel_link, get_boundary_post, get_posts, WP_Query->query, WP_Query->get_posts"
}
[8]=>
array(3) {
[0]=>
string(283) "SELECT t.*, tt.*, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (3) ORDER BY t.name ASC"
[1]=>
float(0.125754117966)
[2]=>
string(314) "require, require_once, include, get_header, locate_template, load_template, require_once, wp_head, do_action, call_user_func_array, start_post_rel_link, get_boundary_post_rel_link, get_boundary_post, get_posts, WP_Query->query, WP_Query->get_posts, update_post_caches, update_object_term_cache, wp_get_object_terms"
}
[9]=>
array(3) {
[0]=>
string(74) "SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (3)"
[1]=>
float(0.084892988205)
[2]=>
string(309) "require, require_once, include, get_header, locate_template, load_template, require_once, wp_head, do_action, call_user_func_array, start_post_rel_link, get_boundary_post_rel_link, get_boundary_post, get_posts, WP_Query->query, WP_Query->get_posts, update_post_caches, update_postmeta_cache, update_meta_cache"
}
[10]=>
array(3) {
[0]=>
string(162) "SELECT p.* FROM wp_posts AS p WHERE p.post_date < '2010-01-09 12:03:50' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date DESC LIMIT 1"
[1]=>
float(0.0221221446991)
[2]=>
string(202) "require, require_once, include, get_header, locate_template, load_template, require_once, wp_head, do_action, call_user_func_array, adjacent_posts_rel_link, get_adjacent_post_rel_link, get_adjacent_post"
}
[11]=>
array(3) {
[0]=>
string(161) "SELECT p.* FROM wp_posts AS p WHERE p.post_date > '2010-01-09 12:03:50' AND p.post_type = 'post' AND p.post_status = 'publish' ORDER BY p.post_date ASC LIMIT 1"
[1]=>
float(0.0552749633789)
[2]=>
string(202) "require, require_once, include, get_header, locate_template, load_template, require_once, wp_head, do_action, call_user_func_array, adjacent_posts_rel_link, get_adjacent_post_rel_link, get_adjacent_post"
}
[12]=>
array(3) {
[0]=>
string(106) "SELECT * FROM wp_posts WHERE (post_type = 'page' AND post_status = 'publish') ORDER BY menu_order ASC"
[1]=>
float(0.045166015625)
[2]=>
string(114) "require, require_once, include, get_header, locate_template, load_template, require_once, wp_list_pages, get_pages"
}
[13]=>
array(3) {
[0]=>
string(44) "SELECT * FROM wp_users WHERE ID = 15 LIMIT 1"
[1]=>
float(0.0632801055908)
[2]=>
string(90) "require, require_once, include, the_post, WP_Query->the_post, setup_postdata, get_userdata"
}
[14]=>
array(3) {
[0]=>
string(63) "SELECT meta_key, meta_value FROM wp_usermeta WHERE user_id = 15"
[1]=>
float(0.00949382781982)
[2]=>
string(102) "require, require_once, include, the_post, WP_Query->the_post, setup_postdata, get_userdata, _fill_user"
}
[15]=>
array(3) {
[0]=>
string(157) "SELECT * FROM wp_comments WHERE comment_post_ID = 5219 AND (comment_approved = '1' OR ( user_id = 1 AND comment_approved = '0' ) ) ORDER BY comment_date_gmt"
[1]=>
float(0.0790917873383)
[2]=>
string(49) "require, require_once, include, comments_template"
}
[16]=>
array(3) {
[0]=>
string(193) "SELECT wp_comments.* FROM wp_comments JOIN wp_posts ON wp_posts.ID = wp_comments.comment_post_ID WHERE comment_approved = '1' AND post_status = 'publish' ORDER BY comment_date_gmt DESC LIMIT 15"
[1]=>
float(0.043851852417)
[2]=>
string(192) "require, require_once, include, get_sidebar, locate_template, load_template, require_once, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_Recent_Comments->widget"
}
[17]=>
array(3) {
[0]=>
string(151) "SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') ORDER BY t.name ASC "
[1]=>
float(0.0447587966919)
[2]=>
string(136) "require, require_once, include, get_sidebar, locate_template, load_template, require_once, wp_list_categories, get_categories, get_terms"
}
[18]=>
array(3) {
[0]=>
string(86) "SELECT * FROM wp_links WHERE 1=1 AND link_visible = 'Y' ORDER BY link_name ASC"
[1]=>
float(0.0254728794098)
[2]=>
string(122) "require, require_once, include, get_footer, locate_template, load_template, require_once, wp_list_bookmarks, get_bookmarks"
}
[19]=>
array(3) {
[0]=>
string(226) "SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC LIMIT 12"
[1]=>
float(0.0424180030823)
[2]=>
string(105) "require, require_once, include, get_footer, locate_template, load_template, require_once, wp_get_archives"
}
}
--!>