INVESTIGATED THE SERVER OUTAGE | REASON FOR OUTAGE TEMPLATE


I have investigated the server outages and I found out the following information:

  1. The websites kidsbaron.com and trendbaron.com has a lot of Heartbeat executions. You can reduce the execution…
  2. Both websites have almost 100 slow queries. The top 10 slow queries for the last 24 שעות:
    Code

חלק עליון 3 of 97 (total) Slow Queries for the past 24 שעות

1.Executed 20h 52m 14s ago for 76.575306 sec on Database --> Unknown (NOT FOUND / DELETED)  Date: 2017-09-13 09:36:50 Query_time: 76.575306 Rows_examined: 2196592: Rows_sent 100 Lock_time: 0.000322  # Schema: trendbar_kidsbar Last_errno: 0 Killed: 0 SELECT SQL_CALC_FOUND_ROWS cfcel_posts.ID FROM cfcel_posts LEFT JOIN cfcel_postmeta ON (cfcel_posts.ID = cfcel_postmeta.post_id AND cfcel_postmeta.meta_key = 'show_order_option' ) LEFT JOIN cfcel_postmeta AS mt1 ON ( cfcel_posts.ID = mt1.post_id ) WHERE 1=1 AND ( cfcel_postmeta.post_id IS NULL OR ( mt1.meta_key = 'show_order_option' AND mt1.meta_value = '1' ) ) AND cfcel_posts.post_type = 'shop_order' AND ((cfcel_posts.post_status = 'wc-processing' OR cfcel_posts.post_status = 'wc-completed')) GROUP BY cfcel_posts.ID ORDER BY RAND() LIMIT 0, 100;    ---------------------------------------------------------------------------------------------------------  2. Executed 20h 52m 14s ago for 76.08039 sec on Database --> Unknown (NOT FOUND / DELETED)  Date: 2017-09-13 09:36:50 Query_time: 76.080390 Rows_examined: 2196592: Rows_sent 100 Lock_time: 0.000545  # Schema: trendbar_kidsbar Last_errno: 0 Killed: 0 SELECT SQL_CALC_FOUND_ROWS cfcel_posts.ID FROM cfcel_posts LEFT JOIN cfcel_postmeta ON (cfcel_posts.ID = cfcel_postmeta.post_id AND cfcel_postmeta.meta_key = 'show_order_option' ) LEFT JOIN cfcel_postmeta AS mt1 ON ( cfcel_posts.ID = mt1.post_id ) WHERE 1=1 AND ( cfcel_postmeta.post_id IS NULL OR ( mt1.meta_key = 'show_order_option' AND mt1.meta_value = '1' ) ) AND cfcel_posts.post_type = 'shop_order' AND ((cfcel_posts.post_status = 'wc-processing' OR cfcel_posts.post_status = 'wc-completed')) GROUP BY cfcel_posts.ID ORDER BY RAND() LIMIT 0, 100;  ---------------------------------------------------------------------------------------------------------  3. Executed 20h 52m 17s ago for 74.756889 sec on Database --> Unknown (NOT FOUND / DELETED)  Date: 2017-09-13 09:36:47 Query_time: 74.756889 Rows_examined: 2196592: Rows_sent 100 Lock_time: 0.000240  # Schema: trendbar_kidsbar Last_errno: 0 Killed: 0 SELECT SQL_CALC_FOUND_ROWS cfcel_posts.ID FROM cfcel_posts LEFT JOIN cfcel_postmeta ON (cfcel_posts.ID = cfcel_postmeta.post_id AND cfcel_postmeta.meta_key = 'show_order_option' ) LEFT JOIN cfcel_postmeta AS mt1 ON ( cfcel_posts.ID = mt1.post_id ) WHERE 1=1 AND ( cfcel_postmeta.post_id IS NULL OR ( mt1.meta_key = 'show_order_option' AND mt1.meta_value = '1' ) ) AND cfcel_posts.post_type = 'shop_order' AND ((cfcel_posts.post_status = 'wc-processing' OR cfcel_posts.post_status = 'wc-completed')) GROUP BY cfcel_posts.ID ORDER BY RAND() LIMIT 0, 100;    ---------------------------------------------------------------------------------------------------------    

There can be many reasons for slow database queries, but the following 3 are the most common ones:

  1. Large database
  2. Not well-written scripts
  3. A large number of internal links that query the database directly.

What we can advise you is to try to reduce your database in size and optimize it. You can reduce it be deleting some old records/articles from your website and truncate log related tables. For the optimization

מקווה שאתה אוהב את המאמר הזה, אם עשית לוודא שאתה נותן זה אגודל למעלה תגובה טובה למטה.

השאר תגובה

כתובת האימייל שלך לא תפורסם. שדות חובה מסומנים *

CommentLuv התג