We have so many error happen on website (WordPress and Woocommerce) error log and it will show the following error message
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'), include('/themes/themename/template/template-name.php'), WC_Abstract_Order->update_status, wp_update_post, 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
But I don't know why it is happening. I create this template for special operation, and in that template I didn't use
_transient_wpseo_sitemap_cache_shop_order_% is made by yoast plugin , but I already do not follow instruction for that page
Could any one tell what is the reason for this ?
Also when I install Delete Expired Transients plugin it will show very large number of Expired transients, could any one tell what happen if I delete this expired transient?
Why transient come in my newly created page and template ,even i didn't use
get_header(), get_footer() ?
How to disable this future in selected pages ?