My host is complaining again about the high amount of resources used by this plugin.<\/p>\n
They think that the following query is responsible for high SQL usage.<\/p>\n
===============================================================================================================================================
\nSELECT DISTINCT wp_pfh3w2370f_posts.*, wp_pfh3w2370f_postmeta.meta_value as EventStartDate, tribe_event_end_date.meta_value as EventEndDate FROM wp_pfh3w2370f_posts LEFT JOIN wp_pfh3w2370f_term_relationships ON (wp_pfh3w2370f_posts.ID = wp_pfh3w2370f_term_relationships.object_id) INNER JOIN wp_pfh3w2370f_postmeta ON ( wp_pfh3w2370f_posts.ID = wp_pfh3w2370f_postmeta.post_id ) INNER JOIN wp_pfh3w2370f_postmeta AS mt1 ON ( wp_pfh3w2370f_posts.ID = mt1.post_id ) LEFT JOIN wp_pfh3w2370f_postmeta as tribe_event_end_date ON ( wp_pfh3w2370f_posts.ID = tribe_event_end_date.post_id AND tribe_event_end_date.meta_key = ‘_EventEndDate’ ) WHERE 1=1 AND wp_pfh3w2370f_posts.ID NOT IN (53076) AND (
\n wp_pfh3w2370f_term_relationships.term_taxonomy_id IN (163,66)
\n) AND (
\n wp_pfh3w2370f_postmeta.meta_key = ‘_EventStartDate’
\n AND
\n (
\n mt1.meta_key = ‘_EventStartDate’
\n )
\n) AND wp_pfh3w2370f_posts.post_type = ‘tribe_events’ AND (wp_pfh3w2370f_posts.post_status = ‘publish’ OR wp_pfh3w2370f_posts.post_status = ‘acf-disabled’ OR wp_pfh3w2370f_posts.post_status = ‘tribe-ea-success’ OR wp_pfh3w2370f_posts.post_status = ‘tribe-ea-failed’ OR wp_pfh3w2370f_posts.post_status = ‘tribe-ea-schedule’ OR wp_pfh3w2370f_posts.post_status = ‘tribe-ea-pending’ OR wp_pfh3w2370f_posts.post_status = ‘tribe-ea-draft’) AND (wp_pfh3w2370f_postmeta.meta_value >= ‘2018-09-25 06:53:00’ OR (wp_pfh3w2370f_postmeta.meta_value <= ‘2018-09-25 06:53:00’ AND tribe_event_end_date.meta_value >= ‘2018-09-25 06:53:00’ )) ORDER BY EventStartDate ASC, wp_pfh3w2370f_postmeta.meta_value ASC
\n ) a
\n GROUP BY IF( post_parent = 0, ID, post_parent )
\n ORDER BY EventStartDate ASC
\n===============================================================================================================================================<\/p>\n
High SQL usage is consistent. Here is a graph showing MySQL usage over the past week: http:\/\/take.ms\/uOjEa.<\/p>\n
They think that the plugin is starting some automatic job and it is doing it for couple of hours then everything reverts to normal. During periods of high SQL usage, the website slows down and sometimes resource limits are hit, resulting in time out errors.<\/p>\n","protected":false},"template":"","class_list":["post-1630642","topic","type-topic","status-closed","hentry"],"yoast_head":"\n