Slow query has taken all my sites down
-
Hi – I had a large number of duplicate images that I was hoping to clean up with Media Deduper, but the result was that my hosting company locked down all my sites of my entire account because of high server load caused by slow queries.
This is what they gave me and what I found in my logs:
WordPress database error Query execution was interrupted for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id ) INNER JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id ) INNER JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id ) WHERE 1=1 AND (
wp_postmeta.meta_key = ‘mdd_hash’
OR
mt1.meta_key = ‘mdd_size’
OR
mt2.meta_key = ‘_mdd_referenced_by’
OR
mt3.meta_key = ‘_mdd_referenced_by_count’
OR
mt4.meta_key = ‘_mdd_references’
) AND wp_posts.post_type IN (‘post’, ‘page’, ‘attachment’, ‘product’) AND ((wp_posts.post_status <> ‘trash’ AND wp_posts.post_status <> ‘auto-draft’)) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 20 made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, media_deduper_init, Media_Deduper->__construct, MDD_Compat_Manager->__construct, MDD_Compat_Manager->check_index_version, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
————————This only showed up when I activated this plugin. I’m not a MySQL expert. If I am wrong in my conclusion, please let me know.
Thx
- The topic ‘Slow query has taken all my sites down’ is closed to new replies.