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 hours:
    Code

TOP 3 of 97 (total) Slow Queries for the past 24 hours

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

Hope you like this article, if you did make sure you give it a thumbs up and a good comment down below.

Leave a Reply

Your email address will not be published. Required fields are marked *

CommentLuv badge