Ask Giúp mình xử lý lỗi làm blog bị overload

abcde

Senior
Joined
Dec 16, 2011
Messages
542
Reactions
653
MR
0.000
Mình có cái blog chạy nền wordpress khoảng 46k bài, mấy bữa nay kô biết bị gì mà overload miết, Search thử trên google thì vào optimize db nhưng cũng không có tác dụng, vào xem error log thì thấy cái lỗi này

[01-Nov-2013 06:01:08 UTC] WordPress database error MySQL server has gone away for query SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 93135 ORDER BY `meta_count` DESC LIMIT 10; made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/suffusion/search.php'), get_template_part, locate_template, load_template, require('/themes/suffusion/layouts/layout-blog.php'), suffusion_content, do_action('suffusion_content'), call_user_func_array, suffusion_excerpt_or_content, get_template_part, locate_template, load_template, require('/themes/suffusion/post-formats/content.php'), the_content, apply_filters('the_content'), call_user_func_array, pk_stt2_admin_content_filter, stt_terms_list, pk_stt2_db_get_search_terms
[01-Nov-2013 06:01:08 UTC] WordPress database error MySQL server has gone away for query SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 74707 ORDER BY `meta_count` DESC LIMIT 10; made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/suffusion/search.php'), get_template_part, locate_template, load_template, require('/themes/suffusion/layouts/layout-blog.php'), suffusion_content, do_action('suffusion_content'), call_user_func_array, suffusion_excerpt_or_content, get_template_part, locate_template, load_template, require('/themes/suffusion/post-formats/content.php'), the_content, apply_filters('the_content'), call_user_func_array, pk_stt2_admin_content_filter, stt_terms_list, pk_stt2_db_get_search_terms
[01-Nov-2013 06:01:09 UTC] WordPress database error MySQL server has gone away for query SELECT `meta_value`,`meta_count` FROM `wp_stt2_meta` WHERE `post_id` = 62215 ORDER BY `meta_count` DESC LIMIT 10; made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/suffusion/search.php'), get_template_part, locate_template, load_template, require('/themes/suffusion/layouts/layout-blog.php'), suffusion_content, do_action('suffusion_content'), call_user_func_array, suffusion_excerpt_or_content, get_template_part, locate_template, load_template, require('/themes/suffusion/post-formats/content.php'), the_content, apply_filters('the_content'), call_user_func_array, pk_stt2_admin_content_filter, stt_terms_list, pk_stt2_db_get_search_terms
[01-Nov-2013 06:01:09 UTC] WordPress database error MySQL server has gone away for query SELECT MONTH(post_date) AS month, YEAR(post_date) AS year
FROM wp_posts
WHERE post_date < '2013-11-01'
AND post_type = 'post' AND post_status = 'publish'
ORDER BY post_date DESC
LIMIT 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/suffusion/search.php'), get_footer, locate_template, load_template, require_once('/themes/suffusion/footer.php'), suffusion_before_end_container, do_action('suffusion_before_end_container'), call_user_func_array, suffusion_print_right_sidebars, get_sidebar, locate_template, load_template, require_once('/themes/suffusion/sidebar.php'), dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_Calendar->widget, get_calendar
[01-Nov-2013 06:01:09 UTC] WordPress database error MySQL server has gone away for query SELECT MONTH(post_date) AS month, YEAR(post_date) AS year
FROM wp_posts
WHERE post_date > '2013-11-30 23:59:59'
AND post_type = 'post' AND post_status = 'publish'
ORDER BY post_date ASC
LIMIT 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/suffusion/search.php'), get_footer, locate_template, load_template, require_once('/themes/suffusion/footer.php'), suffusion_before_end_container, do_action('suffusion_before_end_container'), call_user_func_array, suffusion_print_right_sidebars, get_sidebar, locate_template, load_template, require_once('/themes/suffusion/sidebar.php'), dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_Calendar->widget, get_calendar
[01-Nov-2013 06:01:09 UTC] WordPress database error MySQL server has gone away for query SELECT DISTINCT DAYOFMONTH(post_date)
FROM wp_posts WHERE post_date >= '2013-11-01 00:00:00'
AND post_type = 'post' AND post_status = 'publish'
AND post_date <= '2013-11-30 23:59:59' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/suffusion/search.php'), get_footer, locate_template, load_template, require_once('/themes/suffusion/footer.php'), suffusion_before_end_container, do_action('suffusion_before_end_container'), call_user_func_array, suffusion_print_right_sidebars, get_sidebar, locate_template, load_template, require_once('/themes/suffusion/sidebar.php'), dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_Calendar->widget, get_calendar
[01-Nov-2013 06:01:09 UTC] WordPress database error MySQL server has gone away for query SELECT ID, post_title, DAYOFMONTH(post_date) as dom FROM wp_posts WHERE post_date >= '2013-11-01 00:00:00' AND post_date <= '2013-11-30 23:59:59' AND post_type = 'post' AND post_status = 'publish' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/suffusion/search.php'), get_footer, locate_template, load_template, require_once('/themes/suffusion/footer.php'), suffusion_before_end_container, do_action('suffusion_before_end_container'), call_user_func_array, suffusion_print_right_sidebars, get_sidebar, locate_template, load_template, require_once('/themes/suffusion/sidebar.php'), dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_Calendar->widget, get_calendar
[01-Nov-2013 06:01:09 UTC] WordPress database error MySQL server has gone away for query 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 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/suffusion/search.php'), get_footer, locate_template, load_template, require_once('/themes/suffusion/footer.php'), suffusion_before_end_container, do_action('suffusion_before_end_container'), call_user_func_array, suffusion_print_right_sidebars, get_sidebar, locate_template, load_template, require_once('/themes/suffusion/sidebar.php'), dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_Categories->widget, wp_list_categories, get_categories, get_terms
[01-Nov-2013 06:01:09 UTC] WordPress database error MySQL server has gone away for query 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 ('link_category') AND t.term_id IN ( 584 ) AND tt.count > 0 ORDER BY t.name ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/suffusion/search.php'), get_footer, locate_template, load_template, require_once('/themes/suffusion/footer.php'), suffusion_before_end_container, do_action('suffusion_before_end_container'), call_user_func_array, suffusion_print_right_sidebars, suffusion_print_sidebar, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_Links->widget, wp_list_bookmarks, get_terms
[01-Nov-2013 06:01:09 UTC] WordPress database error MySQL server has gone away for query SELECT * FROM wp_links INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y' AND ( tt.term_id = 584 ) AND taxonomy = 'link_category' ORDER BY link_name ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/suffusion/search.php'), get_footer, locate_template, load_template, require_once('/themes/suffusion/footer.php'), suffusion_before_end_container, do_action('suffusion_before_end_container'), call_user_func_array, suffusion_print_right_sidebars, suffusion_print_sidebar, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_Links->widget, wp_list_bookmarks, get_bookmarks
[01-Nov-2013 06:01:09 UTC] WordPress database error MySQL server has gone away for query 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 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/suffusion/single.php'), get_footer, locate_template, load_template, require_once('/themes/suffusion/footer.php'), suffusion_before_end_container, do_action('suffusion_before_end_container'), call_user_func_array, suffusion_print_right_sidebars, get_sidebar, locate_template, load_template, require_once('/themes/suffusion/sidebar.php'), dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_Categories->widget, wp_list_categories, get_categories, get_terms
[01-Nov-2013 06:01:09 UTC] WordPress database error MySQL server has gone away for query 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 ('link_category') AND t.term_id IN ( 584 ) AND tt.count > 0 ORDER BY t.name ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/suffusion/single.php'), get_footer, locate_template, load_template, require_once('/themes/suffusion/footer.php'), suffusion_before_end_container, do_action('suffusion_before_end_container'), call_user_func_array, suffusion_print_right_sidebars, suffusion_print_sidebar, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_Links->widget, wp_list_bookmarks, get_terms
[01-Nov-2013 06:01:09 UTC] WordPress database error MySQL server has gone away for query SELECT * FROM wp_links INNER JOIN wp_term_relationships AS tr ON (wp_links.link_id = tr.object_id) INNER JOIN wp_term_taxonomy as tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE 1=1 AND link_visible = 'Y' AND ( tt.term_id = 584 ) AND taxonomy = 'link_category' ORDER BY link_name ASC made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/suffusion/single.php'), get_footer, locate_template, load_template, require_once('/themes/suffusion/footer.php'), suffusion_before_end_container, do_action('suffusion_before_end_container'), call_user_func_array, suffusion_print_right_sidebars, suffusion_print_sidebar, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WP_Widget_Links->widget, wp_list_bookmarks, get_bookmarks

Lúc trước nhờ admin quản lý host coi dùm cũng chưa biết bi5 gì, mình cũng đã tắt 1 số plugin nhưng vẫn còn bị overload, Anh em ai gặp qua lỗi này thì chỉ giúp mình với. Cảm ơn.
 

newbie07

Newbie
Joined
Jul 20, 2011
Messages
274
Reactions
138
MR
0.000
Thử tăng timeout của MySQL, sử dụng cache + chuyển DB Engine sang InnoDB!
Bổ sung: coi log có vẻ như cậu dùng plugin SEO Tagging 2. Cái plugin này sẽ khiến tỉ lệ GHI/XÓA vào database tăng lên đáng kể. Tốt nhất là hãy chuyển những table nào ghi nhiều hơn sang InnoDB. Còn nhưng table nào đọc là phần lớn thì giữ MyISAM. (nói chung là khuyến khích chuyển sang InnoDB). Còn cú pháp + cách thức chuyển thế nào thì Google có sẵn lắm (nên backup cẩn thận trước khi chuyển).
 
Last edited:

TimeZone

Junior
Joined
Nov 1, 2012
Messages
102
Reactions
1,387
MR
0.000
Cái plugin SEO SearchTerms Tagging 2 mà dùng với 46k bài thì nó chiếm chắc cũng phải gần 20MB DB, tốt nhất là ko nên xài plugin nào mà nó ghi vào DB, dùng WP-DBManager vào Drop hết những plugin nào chiếm DB đi cậu. Dọn dẹp chút chắc cũng bớt được vài chục MB DB, site mình vật vã lắm mới có hơn 30MB DB :rolleyes:
 
Last edited:
cs dữ liệu của cậu bây giờ chắc phải lên >1gb nên dùng innodb là chuẩn đới
DB lớn hay nhỏ phụ thuộc vào độ lớn từng bản ghi nữa. Trước mọi người hay để mặc định là MyISAM trong MySQL do khả năng đọc của MySQL nhanh hơn (nếu để ý bạn sẽ thấy WP những phiên bản trước đều để là MyISAM nhưng từ những phiên bản 3.x gần đây thì đã chuyển toàn bộ sang InnoDB). Khuyên các bạn nên dùng InnoDB, tuy tương quan đọc InnoDB hơi "chậm" hơn chút nhưng thực tế cũng không kém cạnh lắm, cộng thêm khả năng bảo toàn cơ sở dữ liệu nên tớ nghĩ sẽ phù hợp hơn. [kích thước database sẽ tăng hơi "khủng" nhưng đừng lo, nó cần thiết phải như vậy].
 
Tắt plugin STT rồi mà vẫn overload liên tục, coi log thì không thấy ghi gì hết trơn, admin thì bận quá kô nhờ check kỹ được, để mua con VPS hay server chạy thử xem sao. Cảm ơn các bạn đã nhiệt tình hỗ trợ.
 

Announcements

Today's birthdays

Forum statistics

Threads
423,920
Messages
7,135,088
Members
176,399
Latest member
girisingo

Most viewed of week

Most discussed of week

Most viewed of week

Most discussed of week

Back
Top Bottom