{"id":1427033,"date":"2018-01-15T15:39:12","date_gmt":"2018-01-15T23:39:12","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/cpu-load-issues-sometimes-bringing-down-the-server\/"},"modified":"2018-01-15T15:39:12","modified_gmt":"2018-01-15T23:39:12","slug":"cpu-load-issues-sometimes-bringing-down-the-server","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/cpu-load-issues-sometimes-bringing-down-the-server\/","title":{"rendered":"CPU load issues sometimes bringing down the server."},"content":{"rendered":"<p>We are running into some CPU load issues that seam to be caused by the events calendar.<\/p>\n<p>We are running New Relic on the server and it seams to be always indicating that the events calendar is causing the load and delays just before the server becomes become unavailable. Please see attached.<\/p>\n<p>~3500 events in the system.<\/p>\n<p>We have tried reducing recurrence creation months but it doesn&#8217;t seam to be solving the issue. We have also tried turning of the lazy cron in favour of running wp-cron with crontab.<\/p>\n<p>On the database end it seams that the slowest repeat queries are also coming from the events calendar. They look like this:<br \/>\nSELECT SQL_CALC_FOUND_ROWS * FROM (SELECT  DISTINCT wp_posts.*, wp_postmeta.meta_value AS EventStartDate, tribe_event_end_date.meta_value AS EventEndDate FROM wp_posts  LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )  LEFT JOIN wp_postmeta AS mt? ON ( wp_posts.ID = mt?.post_id )  LEFT JOIN wp_postmeta AS mt? ON (wp_posts.ID = mt?.post_id AND mt?.meta_key = ? ) LEFT JOIN wp_postmeta AS tribe_event_end_date ON ( wp_posts.ID = tribe_event_end_date.post_id AND tribe &#8230;&#8230;..<\/p>\n<p>Is there currently any know issues with the plugin and CPU load?<br \/>\nIs there any thing else we can change in the settings to prevent this high cpu load issue?<br \/>\nCan we defer the recurrence creation to a set time of day?<\/p>\n","protected":false},"template":"","class_list":["post-1427033","topic","type-topic","status-closed","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>CPU load issues sometimes bringing down the server. -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/cpu-load-issues-sometimes-bringing-down-the-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CPU load issues sometimes bringing down the server. -\" \/>\n<meta property=\"og:description\" content=\"We are running into some CPU load issues that seam to be caused by the events calendar. We are running New Relic on the server and it seams to be always indicating that the events calendar is causing the load and delays just before the server becomes become unavailable. Please see attached. ~3500 events in [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/cpu-load-issues-sometimes-bringing-down-the-server\/\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/cpu-load-issues-sometimes-bringing-down-the-server\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/cpu-load-issues-sometimes-bringing-down-the-server\/\",\"name\":\"CPU load issues sometimes bringing down the server. -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2018-01-15T23:39:12+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/cpu-load-issues-sometimes-bringing-down-the-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/cpu-load-issues-sometimes-bringing-down-the-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/cpu-load-issues-sometimes-bringing-down-the-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/theeventscalendar.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Topics\",\"item\":\"https:\/\/theeventscalendar.com\/support\/topics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Calendar Products\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Events Calendar PRO\",\"item\":\"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/events-calendar-pro\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"CPU load issues sometimes bringing down the server.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\",\"url\":\"https:\/\/theeventscalendar.com\/support\/\",\"name\":\"\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"CPU load issues sometimes bringing down the server. -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/cpu-load-issues-sometimes-bringing-down-the-server\/","og_locale":"en_US","og_type":"article","og_title":"CPU load issues sometimes bringing down the server. -","og_description":"We are running into some CPU load issues that seam to be caused by the events calendar. We are running New Relic on the server and it seams to be always indicating that the events calendar is causing the load and delays just before the server becomes become unavailable. Please see attached. ~3500 events in [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/cpu-load-issues-sometimes-bringing-down-the-server\/","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/cpu-load-issues-sometimes-bringing-down-the-server\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/cpu-load-issues-sometimes-bringing-down-the-server\/","name":"CPU load issues sometimes bringing down the server. -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2018-01-15T23:39:12+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/cpu-load-issues-sometimes-bringing-down-the-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/cpu-load-issues-sometimes-bringing-down-the-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/cpu-load-issues-sometimes-bringing-down-the-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/theeventscalendar.com\/support\/"},{"@type":"ListItem","position":2,"name":"Topics","item":"https:\/\/theeventscalendar.com\/support\/topics\/"},{"@type":"ListItem","position":3,"name":"Calendar Products","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/"},{"@type":"ListItem","position":4,"name":"Events Calendar PRO","item":"https:\/\/theeventscalendar.com\/support\/forums\/forum\/events\/events-calendar-pro\/"},{"@type":"ListItem","position":5,"name":"CPU load issues sometimes bringing down the server."}]},{"@type":"WebSite","@id":"https:\/\/theeventscalendar.com\/support\/#website","url":"https:\/\/theeventscalendar.com\/support\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/theeventscalendar.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1427033","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1427033\/revisions"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1427033"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}