{"id":1144544,"date":"2016-07-27T05:40:33","date_gmt":"2016-07-27T12:40:33","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unnecessary-huge-mysql-request-nearly-crashes-server\/"},"modified":"2016-07-27T05:40:33","modified_gmt":"2016-07-27T12:40:33","slug":"unnecessary-huge-mysql-request-nearly-crashes-server","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unnecessary-huge-mysql-request-nearly-crashes-server\/","title":{"rendered":"Unnecessary huge mysql request nearly crashes server"},"content":{"rendered":"<p>Hey there, <\/p>\n<p>there is a (unnecessary) huge mysql request in your Calendar that chrashed our database several times in the past days.<br \/>\nWe run a blog with about 80.000 posts and 50.000 media elements (pictures, etc.). Obviously, your Calendar (the widget maybe?) goes through each and every database entry (posts, pictures, users, tags, &#8230;) and sorts them before showing the top 5 (and deleting everything else afterwards). In our case, this causes the server to download the whole database to hd to perform this task, since the db is way too big to be processed in the memory.  There is a query called <code>databasename_posts.*<\/code> which causes the main problem. <\/p>\n<p>Unfortunately, we are not able to use this plugin anymore, until there is a fix for this issue. <\/p>\n","protected":false},"template":"","class_list":["post-1144544","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>Unnecessary huge mysql request nearly crashes 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\/unnecessary-huge-mysql-request-nearly-crashes-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Unnecessary huge mysql request nearly crashes server -\" \/>\n<meta property=\"og:description\" content=\"Hey there, there is a (unnecessary) huge mysql request in your Calendar that chrashed our database several times in the past days. We run a blog with about 80.000 posts and 50.000 media elements (pictures, etc.). Obviously, your Calendar (the widget maybe?) goes through each and every database entry (posts, pictures, users, tags, &#8230;) and [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unnecessary-huge-mysql-request-nearly-crashes-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\/unnecessary-huge-mysql-request-nearly-crashes-server\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unnecessary-huge-mysql-request-nearly-crashes-server\/\",\"name\":\"Unnecessary huge mysql request nearly crashes server -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2016-07-27T12:40:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unnecessary-huge-mysql-request-nearly-crashes-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unnecessary-huge-mysql-request-nearly-crashes-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unnecessary-huge-mysql-request-nearly-crashes-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\":\"Unnecessary huge mysql request nearly crashes 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":"Unnecessary huge mysql request nearly crashes 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\/unnecessary-huge-mysql-request-nearly-crashes-server\/","og_locale":"en_US","og_type":"article","og_title":"Unnecessary huge mysql request nearly crashes server -","og_description":"Hey there, there is a (unnecessary) huge mysql request in your Calendar that chrashed our database several times in the past days. We run a blog with about 80.000 posts and 50.000 media elements (pictures, etc.). Obviously, your Calendar (the widget maybe?) goes through each and every database entry (posts, pictures, users, tags, &#8230;) and [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unnecessary-huge-mysql-request-nearly-crashes-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\/unnecessary-huge-mysql-request-nearly-crashes-server\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unnecessary-huge-mysql-request-nearly-crashes-server\/","name":"Unnecessary huge mysql request nearly crashes server -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2016-07-27T12:40:33+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unnecessary-huge-mysql-request-nearly-crashes-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/unnecessary-huge-mysql-request-nearly-crashes-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/unnecessary-huge-mysql-request-nearly-crashes-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":"Unnecessary huge mysql request nearly crashes 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\/1144544","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\/1144544\/revisions"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1144544"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}