{"action":"created","issue":{"url":"https://api.github.com/repos/Yoast/wordpress-seo/issues/4016","repository_url":"https://api.github.com/repos/Yoast/wordpress-seo","labels_url":"https://api.github.com/repos/Yoast/wordpress-seo/issues/4016/labels{/name}","comments_url":"https://api.github.com/repos/Yoast/wordpress-seo/issues/4016/comments","events_url":"https://api.github.com/repos/Yoast/wordpress-seo/issues/4016/events","html_url":"https://github.com/Yoast/wordpress-seo/issues/4016","id":136534477,"number":4016,"title":"Slow SQL QUERY Bug.","user":{"login":"Kocarik","id":15687687,"avatar_url":"https://avatars.githubusercontent.com/u/15687687?v=3","gravatar_id":"","url":"https://api.github.com/users/Kocarik","html_url":"https://github.com/Kocarik","followers_url":"https://api.github.com/users/Kocarik/followers","following_url":"https://api.github.com/users/Kocarik/following{/other_user}","gists_url":"https://api.github.com/users/Kocarik/gists{/gist_id}","starred_url":"https://api.github.com/users/Kocarik/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Kocarik/subscriptions","organizations_url":"https://api.github.com/users/Kocarik/orgs","repos_url":"https://api.github.com/users/Kocarik/repos","events_url":"https://api.github.com/users/Kocarik/events{/privacy}","received_events_url":"https://api.github.com/users/Kocarik/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/Yoast/wordpress-seo/labels/xml%20sitemap","name":"xml sitemap","color":"006b75"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2016-02-25T22:42:56Z","updated_at":"2016-04-12T08:06:49Z","closed_at":null,"body":"Hallo,\r\n\r\nI have instal woocommerce + yoast seo , and my MySQL Databaze report Slow Query please fix, her is report from log:\r\n\r\n```\r\n# Query_time: 4.848047 Lock_time: 0.000028 Rows_sent: 0 Rows_examined: 574724\r\nuse hmlm95nx;\r\nSET timestamp=1454396620;\r\nDELETE FROM wp_options WHERE option_name LIKE '_transient_wpseo_sitemap_cache_shop_order_%' OR option_name LIKE '_transient_timeout_wpseo_sitemap_cache_shop_order_%';\r\n# Time: 160202 8:03:46\r\n```\r\nhttps://wordpress.org/plugins/wordpress-seo/\r\n\r\ntom\r\nMember\r\nPosted 15 hours ago #\r\n\r\ni face the same issue. Please see this .\r\n\r\n(1)WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_options WHERE option_name LIKE '_transient_wpseo_sitemap_cache_shop_order_%' OR option_name LIKE '_transient_timeout_wpseo_sitemap_cache_shop_order_%' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, WC_AJAX::do_wc_ajax, do_action('wc_ajax_checkout'), call_user_func_array, WC_AJAX::checkout, WC_Checkout->process_checkout, WC_Checkout->create_order, wc_create_order, wp_insert_post, clean_post_cache, clean_object_term_cache, do_action('clean_object_term_cache'), call_user_func_array, wpseo_invalidate_sitemap_cache_terms, wpseo_invalidate_sitemap_cache, WPSEO_Utils::clear_sitemap_cache\r\n\r\n(2)WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_options WHERE option_name LIKE '_transient_wpseo_sitemap_cache_shop_order_%' OR option_name LIKE '_transient_timeout_wpseo_sitemap_cache_shop_order_%' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), call_user_func_array, WC_AJAX::do_wc_ajax, do_action('wc_ajax_checkout'), call_user_func_array, WC_AJAX::checkout, WC_Checkout->process_checkout, WC_Gateway_COD->process_payment, WC_Abstract_Order->update_status, WC_Abstract_Order->add_order_note, wp_insert_comment, wp_update_comment_count, wp_update_comment_count_now, clean_post_cache, clean_object_term_cache, do_action('clean_object_term_cache'), call_user_func_array, wpseo_invalidate_sitemap_cache_terms, wpseo_invalidate_sitemap_cache, WPSEO_Utils::clear_sitemap_cache"},"comment":{"url":"https://api.github.com/repos/Yoast/wordpress-seo/issues/comments/208771085","html_url":"https://github.com/Yoast/wordpress-seo/issues/4016#issuecomment-208771085","issue_url":"https://api.github.com/repos/Yoast/wordpress-seo/issues/4016","id":208771085,"user":{"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},"created_at":"2016-04-12T08:06:49Z","updated_at":"2016-04-12T08:06:49Z","body":"Some probably relevant metrics that would be helpful to hear on this:\r\n\r\n - how many rows do you have in options table?\r\n - how many sitemaps do you have generated in index?"}}