My site host provider (site ground) keeps shutting down site because of slow MySQL queries.
\nHere’s part of the message they sent me:<\/p>\n
“With this notification we would like to inform you that our in-house Website Performance Monitoring System (WPMS) has signaled that your account constantly uses a large amount of the server’s CPU resources. These excessive requests consume an abnormally high amount of CPU resources and endanger the overall performance of the shared server.<\/p>\n
Your account consumed more than 55480 CPU seconds for the last 24 hours.<\/p>\n
Violated terms of service:
\nNo more than 40,000 CPU seconds for any given calendar day;”<\/p>\n
Here’s the code they provided that shows the events calendar pro is the cause of this issue.
\nWe cannot afford to have this site down.
\nPLEASE HELP<\/p>\n
=== TOP 2 of 2 (total) Slow Queries for the past 24 hours ==========
\n1. Executed 9h 10m 30s ago for 1.140676 sec on Database –> ioimprov_db
\nDate: 2015-09-10 13:58:56 Query_time: 1.140676 Rows_examined: 71004: Rows_sent 1 Lock_time: 0.000337
\nSELECT SQL_CALC_FOUND_ROWS * FROM ( SELECT DISTINCT wp_4_posts.*, wp_4_postmeta.meta_value as EventStartDate, tribe_event_end_date.meta_value as EventEndDate FROM wp_4_posts LEFT JOIN wp_4_postmeta ON ( wp_4_posts.ID = wp_4_postmeta.post_id ) LEFT JOIN wp_4_postmeta AS mt1 ON ( wp_4_posts.ID = mt1.post_id ) LEFT JOIN wp_4_postmeta AS mt2 ON (wp_4_posts.ID = mt2.post_id AND mt2.meta_key = ‘_EventHideFromUpcoming’ ) LEFT JOIN wp_4_postmeta as tribe_event_end_date ON ( wp_4_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ ) WHERE 1=1 AND wp_4_posts.ID NOT IN (17988) AND ( wp_4_postmeta.meta_key = ‘_EventStartDate’ AND ( mt1.meta_key = ‘_EventStartDate’ AND CAST(mt1.meta_value AS DATETIME) < ‘2015-09-24 18:30:00’ ) AND mt2.post_id IS NULL ) AND wp_4_posts.post_type = ‘tribe_events’ AND (wp_4_posts.post_status = ‘publish’) ORDER BY EventStartDate DESC ) a GROUP BY IF( post_parent = 0, ID, post_parent ) ORDER BY EventStartDate ASC LIMIT 0, 1;
\n—————————————————————————————————-
\n2. Executed 6h 55m 9s ago for 1.076193 sec on Database –> ioimprov_db
\nDate: 2015-09-10 16:14:17 Query_time: 1.076193 Rows_examined: 84285: Rows_sent 1 Lock_time: 0.000397
\nSELECT SQL_CALC_FOUND_ROWS * FROM ( SELECT DISTINCT wp_2_posts.*, wp_2_postmeta.meta_value as EventStartDate, tribe_event_end_date.meta_value as EventEndDate FROM wp_2_posts LEFT JOIN wp_2_postmeta ON ( wp_2_posts.ID = wp_2_postmeta.post_id ) LEFT JOIN wp_2_postmeta AS mt1 ON ( wp_2_posts.ID = mt1.post_id ) LEFT JOIN wp_2_postmeta AS mt2 ON (wp_2_posts.ID = mt2.post_id AND mt2.meta_key = ‘_EventHideFromUpcoming’ ) LEFT JOIN wp_2_postmeta as tribe_event_end_date ON ( wp_2_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ ) WHERE 1=1 AND wp_2_posts.ID NOT IN (18358) AND ( wp_2_postmeta.meta_key = ‘_EventStartDate’ AND ( mt1.meta_key = ‘_EventStartDate’ AND CAST(mt1.meta_value AS DATETIME) > ‘2015-09-11 22:30:00’ ) AND mt2.post_id IS NULL ) AND wp_2_posts.post_type = ‘tribe_events’ AND (wp_2_posts.post_status = ‘publish’) ORDER BY EventStartDate ASC ) a GROUP BY IF( post_parent = 0, ID, post_parent ) ORDER BY EventStartDate ASC LIMIT 0, 1;<\/p>\n","protected":false},"template":"","class_list":["post-1004067","topic","type-topic","status-closed","hentry"],"yoast_head":"\n