{"action":"closed","issue":{"url":"https://api.github.com/repos/Yoast/wordpress-seo/issues/2047","labels_url":"https://api.github.com/repos/Yoast/wordpress-seo/issues/2047/labels{/name}","comments_url":"https://api.github.com/repos/Yoast/wordpress-seo/issues/2047/comments","events_url":"https://api.github.com/repos/Yoast/wordpress-seo/issues/2047/events","html_url":"https://github.com/Yoast/wordpress-seo/issues/2047","id":59299216,"number":2047,"title":"clear_sitemap_cache gets called when Sitemap Functionality is disabled.","user":{"login":"BuggeringHell","id":2572212,"avatar_url":"https://avatars.githubusercontent.com/u/2572212?v=3","gravatar_id":"","url":"https://api.github.com/users/BuggeringHell","html_url":"https://github.com/BuggeringHell","followers_url":"https://api.github.com/users/BuggeringHell/followers","following_url":"https://api.github.com/users/BuggeringHell/following{/other_user}","gists_url":"https://api.github.com/users/BuggeringHell/gists{/gist_id}","starred_url":"https://api.github.com/users/BuggeringHell/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BuggeringHell/subscriptions","organizations_url":"https://api.github.com/users/BuggeringHell/orgs","repos_url":"https://api.github.com/users/BuggeringHell/repos","events_url":"https://api.github.com/users/BuggeringHell/events{/privacy}","received_events_url":"https://api.github.com/users/BuggeringHell/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/Yoast/wordpress-seo/labels/Has%20patch","name":"Has patch","color":"bfe5bf"}],"state":"closed","locked":false,"assignee":{"login":"Rarst","id":737584,"avatar_url":"https://avatars.githubusercontent.com/u/737584?v=3","gravatar_id":"","url":"https://api.github.com/users/Rarst","html_url":"https://github.com/Rarst","followers_url":"https://api.github.com/users/Rarst/followers","following_url":"https://api.github.com/users/Rarst/following{/other_user}","gists_url":"https://api.github.com/users/Rarst/gists{/gist_id}","starred_url":"https://api.github.com/users/Rarst/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Rarst/subscriptions","organizations_url":"https://api.github.com/users/Rarst/orgs","repos_url":"https://api.github.com/users/Rarst/repos","events_url":"https://api.github.com/users/Rarst/events{/privacy}","received_events_url":"https://api.github.com/users/Rarst/received_events","type":"User","site_admin":false},"milestone":null,"comments":9,"created_at":"2015-02-27T21:48:20Z","updated_at":"2015-03-16T12:49:42Z","closed_at":"2015-03-16T12:49:42Z","body":"Using Woocommerce, I notice a large amount of DELETE queries in my mysql-slow.log i.e...\r\n\r\nDELETE FROM wp_options WHERE option_name LIKE '_transient_timeout_wpseo_sitemap_cache_product_cat_%' \r\n\r\nThis is being called every second with a query time of ~50s. My guess is due to the amount and frequency of these queries, specifically with the LIKE search, it is hampering my MySQL performance.\r\n\r\nI am unsure if this should even be called as I have disabled the sitemap functionality with Wordpress SEO. Could anyone elaborate?"}}