{"id":1199092,"date":"2016-11-29T08:26:42","date_gmt":"2016-11-29T16:26:42","guid":{"rendered":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/large-number-of-transients-in-wp_options-table\/"},"modified":"2016-12-08T12:10:06","modified_gmt":"2016-12-08T20:10:06","slug":"large-number-of-transients-in-wp_options-table","status":"closed","type":"topic","link":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/large-number-of-transients-in-wp_options-table\/","title":{"rendered":"Large number of Transients in wp_options table"},"content":{"rendered":"<p>Hello,<\/p>\n<p>Since launching the our site it has (along with other sites in our WP multinetwork) have been gradually seeing a decrease in performance. On Thursday Nov 24th we deleted about 143,513 rows of transient entries bringing the wp_options table from 8Gb to 200mb.<\/p>\n<p>Over the weekend 2,800 have been created. It seems like these transients do not have an expiration date assigned to them and are being generated from the plugin. We continue to monitor the growth but it is like trying to bail water out of a sinking ship.<\/p>\n<p>Any help on the matter would be greatly appreciated.<\/p>\n<p>Thanks<\/p>\n","protected":false},"template":"","class_list":["post-1199092","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>Large number of Transients in wp_options table -<\/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\/large-number-of-transients-in-wp_options-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Large number of Transients in wp_options table -\" \/>\n<meta property=\"og:description\" content=\"Hello, Since launching the our site it has (along with other sites in our WP multinetwork) have been gradually seeing a decrease in performance. On Thursday Nov 24th we deleted about 143,513 rows of transient entries bringing the wp_options table from 8Gb to 200mb. Over the weekend 2,800 have been created. It seems like these [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/large-number-of-transients-in-wp_options-table\/\" \/>\n<meta property=\"article:modified_time\" content=\"2016-12-08T20:10:06+00:00\" \/>\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\/large-number-of-transients-in-wp_options-table\/\",\"url\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/large-number-of-transients-in-wp_options-table\/\",\"name\":\"Large number of Transients in wp_options table -\",\"isPartOf\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/#website\"},\"datePublished\":\"2016-11-29T16:26:42+00:00\",\"dateModified\":\"2016-12-08T20:10:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/large-number-of-transients-in-wp_options-table\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/large-number-of-transients-in-wp_options-table\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/theeventscalendar.com\/support\/forums\/topic\/large-number-of-transients-in-wp_options-table\/#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\":\"Large number of Transients in wp_options table\"}]},{\"@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":"Large number of Transients in wp_options table -","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\/large-number-of-transients-in-wp_options-table\/","og_locale":"en_US","og_type":"article","og_title":"Large number of Transients in wp_options table -","og_description":"Hello, Since launching the our site it has (along with other sites in our WP multinetwork) have been gradually seeing a decrease in performance. On Thursday Nov 24th we deleted about 143,513 rows of transient entries bringing the wp_options table from 8Gb to 200mb. Over the weekend 2,800 have been created. It seems like these [&hellip;]","og_url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/large-number-of-transients-in-wp_options-table\/","article_modified_time":"2016-12-08T20:10:06+00:00","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\/large-number-of-transients-in-wp_options-table\/","url":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/large-number-of-transients-in-wp_options-table\/","name":"Large number of Transients in wp_options table -","isPartOf":{"@id":"https:\/\/theeventscalendar.com\/support\/#website"},"datePublished":"2016-11-29T16:26:42+00:00","dateModified":"2016-12-08T20:10:06+00:00","breadcrumb":{"@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/large-number-of-transients-in-wp_options-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/theeventscalendar.com\/support\/forums\/topic\/large-number-of-transients-in-wp_options-table\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/theeventscalendar.com\/support\/forums\/topic\/large-number-of-transients-in-wp_options-table\/#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":"Large number of Transients in wp_options table"}]},{"@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\/1199092","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":1,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1199092\/revisions"}],"predecessor-version":[{"id":1203397,"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/topic\/1199092\/revisions\/1203397"}],"wp:attachment":[{"href":"https:\/\/theeventscalendar.com\/support\/wp-json\/wp\/v2\/media?parent=1199092"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}