{"id":29280,"date":"2012-12-11T19:06:53","date_gmt":"2012-12-12T03:06:53","guid":{"rendered":"http:\/\/tri.be\/support\/forums\/topic\/ongoing-mysql-query-causing-extremely-slow-site-urgent-issue\/"},"modified":"2012-12-11T19:06:53","modified_gmt":"2012-12-12T03:06:53","slug":"ongoing-mysql-query-causing-extremely-slow-site-urgent-issue","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/ongoing-mysql-query-causing-extremely-slow-site-urgent-issue\/","title":{"rendered":"Ongoing MYSQL Query causing extremely slow site &#8211; URGENT ISSUE"},"content":{"rendered":"<p>Hi guys, <\/p>\n<p>The event calendar on our site brisbanekids.com.au is causing a huge issue with my site. It&#8217;s overloading the server because it&#8217;s causing a whole lot of  mysql queries that won&#8217;t stop.<\/p>\n<p>We have deactivated the plugin and the site is now running at normal speed, so it is definitely something coming. It is hard for us to deactivate plugins on the site as it&#8217;s such a busy site. But we have tried deactivating a few of them.<\/p>\n<p>This is a website that is currently experiencing traffic of 5,000 a day which will be increasing on Friday as the school holidays starts. We have already had angry advertisers email about the issue, so we really need to fix it ASAP. We&#8217;re happy to give you access to whatever you need to get it sorted.<\/p>\n<p>The below is from SSH   mysql &gt; show processlist; (I have removed a whole lot of the duplicate entries, but these are the unique ones) as you can see they&#8217;re very slow queries<br \/>\n<code>| Id    | User            | Host      | db           | Command        | Time | State                | Info<br \/>\n+-------+-----------------+-----------+--------------+----------------+------+----------------------+------------------------------------------------------------------------------------------------------+<br \/>\n|     5 | eximstats       | localhost | eximstats    | Sleep          |  180 |                      | NULL                                                                                                 |<br \/>\n|  3171 | xxxxxxxx | localhost | xxxxxxxx  | Query          | 7728 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, eventStart.meta_value as EventStartDate, IFNULL(DATE |<br \/>\n|  5232 | xxxxxxxx | localhost | xxxxxxxx  | Query          | 6738 | Sending data         | SELECT SQL_CALC_FOUND_ROWS  wp_posts.*, eventStart.meta_value as EventStartDate, IFNULL(DATE_ADD(CAS |<br \/>\n|  6583 | xxxxxxxx | localhost | xxxxxxxx  | Query          | 5870 | Sending data         | SELECT   wp_posts.*, eventStart.meta_value as EventStartDate, IFNULL(DATE_ADD(CAST(eventStart.meta_v |<br \/>\n|  6925 | xxxxxxxx | localhost | xxxxxxxx  | Query          | 5482 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, eventStart.meta_value as EventStartDate, IFNULL(DATE |                                                                                             |<br \/>\n| 11948 | DELAYED         | localhost | eximstats    | Delayed insert |  180 | Waiting for INSERT   |<br \/>\n| 12318 | leechprotect    | localhost | leechprotect | Sleep          |  546 |                      | NULL<br \/>\n| 12520 | DELAYED         | localhost | eximstats    | Delayed insert |  276 | Waiting for INSERT   |<br \/>\n| 12521 | DELAYED         | localhost | eximstats    | Delayed insert |  276 | Waiting for INSERT   |<br \/>\n| 12792 | root            | localhost | NULL         | Query          |    0 | NULL                 | show processlist<br \/>\n52 rows in set (0.00 sec)<br \/>\n<\/code><\/p>\n<p>Any help in fixing or pointing us in the right direction would be hugely appreciated. We really don&#8217;t want to have to find another calendar solution because this one is perfect for us.<\/p>\n","protected":false},"template":"","class_list":["post-29280","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>Ongoing MYSQL Query causing extremely slow site - URGENT ISSUE -<\/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\/ongoing-mysql-query-causing-extremely-slow-site-urgent-issue\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Ongoing MYSQL Query causing extremely slow site - URGENT ISSUE -\" \/>\n<meta property=\"og:description\" content=\"Hi guys, The event calendar on our site brisbanekids.com.au is causing a huge issue with my site. It&#8217;s overloading the server because it&#8217;s causing a whole lot of mysql queries that won&#8217;t stop. We have deactivated the plugin and the site is now running at normal speed, so it is definitely something coming. It is [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/ongoing-mysql-query-causing-extremely-slow-site-urgent-issue\/\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/ongoing-mysql-query-causing-extremely-slow-site-urgent-issue\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/ongoing-mysql-query-causing-extremely-slow-site-urgent-issue\/\",\"name\":\"Ongoing MYSQL Query causing extremely slow site - URGENT ISSUE -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2012-12-12T03:06:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/ongoing-mysql-query-causing-extremely-slow-site-urgent-issue\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/ongoing-mysql-query-causing-extremely-slow-site-urgent-issue\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/ongoing-mysql-query-causing-extremely-slow-site-urgent-issue\/#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\":\"Ongoing MYSQL Query causing extremely slow site &#8211; URGENT ISSUE\"}]},{\"@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":"Ongoing MYSQL Query causing extremely slow site - URGENT ISSUE -","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\/ongoing-mysql-query-causing-extremely-slow-site-urgent-issue\/","og_locale":"en_US","og_type":"article","og_title":"Ongoing MYSQL Query causing extremely slow site - URGENT ISSUE -","og_description":"Hi guys, The event calendar on our site brisbanekids.com.au is causing a huge issue with my site. It&#8217;s overloading the server because it&#8217;s causing a whole lot of mysql queries that won&#8217;t stop. We have deactivated the plugin and the site is now running at normal speed, so it is definitely something coming. It is [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/ongoing-mysql-query-causing-extremely-slow-site-urgent-issue\/","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/ongoing-mysql-query-causing-extremely-slow-site-urgent-issue\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/ongoing-mysql-query-causing-extremely-slow-site-urgent-issue\/","name":"Ongoing MYSQL Query causing extremely slow site - URGENT ISSUE -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2012-12-12T03:06:53+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/ongoing-mysql-query-causing-extremely-slow-site-urgent-issue\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/ongoing-mysql-query-causing-extremely-slow-site-urgent-issue\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/ongoing-mysql-query-causing-extremely-slow-site-urgent-issue\/#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":"Ongoing MYSQL Query causing extremely slow site &#8211; URGENT ISSUE"}]},{"@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\/29280","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\/29280\/revisions"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=29280"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}