I reported this the other day in another active ticket for a different site and wasn’t given any assistance on it so I am now submitting it as it’s own ticket, so this needs high priority response. <\/p>\n
My calendar had under 250 events on it, most of which were 2 weekly reoccurring events (Monday night hangouts and Wednesday Webinars), but after updating the Event Calendar Pro plugin a week ago those 2 reoccurring events started replicating at an alarming rate and grew to over 60,000! This is causing my server resources to spike considerably and is affecting the performance of this site as well as several others I have running on the same VPS. I had GoDaddy\u2019s Fully Managed Server Support Team run a Slow Query Test they ran determined the Event Calendar Pro plugin is 100% the cause of the issues my VPS (see script provided below).<\/p>\n
Trying to be proactive, I just deleted all 60,000+ entries from the WP_Posts and WP_Posts_Meta tables and reinstalled the Event Calendar and Event Calendar Pro plugins and started adding the calendar items back in with one test of the weekly reoccurring event for Monday Hangouts (this time I limited it to end at the end of 2016) and so far it is not replicating. So my questions are:
\n1) why did this happen previously?
\n2) if it does start replicating again, how long would it take for that to happen\/start again
\n3) what do we do if it happens again?<\/p>\n
Here’s the script that was identified as causing the problems previously:<\/p>\n
SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, MIN(wp_postmeta.meta_value) as EventStartDate, MIN(tribe_event_end_date.meta_value) as EventEndDate FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta as tribe_event_end_date ON ( wp_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = \u2018_EventEndDate\u2019 ) WHERE 1=1 AND ( wp_posts.post_parent = 12910 OR wp_posts.ID = 12910 ) AND (
\nwp_postmeta.meta_key = \u2018_EventStartDate\u2019
\n) AND wp_posts.post_type = \u2018tribe_events\u2019 AND ((wp_posts.post_status = \u2018publish\u2019)) AND (wp_postmeta.meta_value >= \u20182016-06-27 14:35:05\u2019 OR (wp_postmeta.meta_value <= \u20182016-06-27 14:35:05\u2019 AND tribe_event_end_date.meta_value >= \u20182016-06-27 14:35:05\u2019 )) GROUP BY wp_posts.ID ORDER BY EventStartDate ASC, wp_posts.post_date ASC LIMIT 27120, 10;<\/p>\n","protected":false},"template":"","class_list":["post-1133459","topic","type-topic","status-closed","hentry"],"yoast_head":"\n