Support » Plugin: Media Deduper » Slow query has taken all my sites down

  • Resolved stefhz

    (@stefhz)


    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

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author cornershop

    (@cornershop)

    @stefhz So sorry about this! We’re actively QAing an updated file that we’re aiming to deploy by the end of this week. I’ll post again as soon as it’s in place.

    Plugin Author cornershop

    (@cornershop)

    @stefhz We’ve just deployed version 1.5.2. We expect this will resolve the server load issues, but please let us know how things go for you! Thank you again. – Chelsea

    thx for the update. I did not have a chance to verify the improvement. As you can probably understand, I cannot risk another shutdown like the one I had and therefore have to test the plugin in a different environment first.

    Thx for your work!

    Plugin Author cornershop

    (@cornershop)

    Totally understand! Hopefully your testing went well. If you have any issues, feel free to reach us at support@cshp.co and we’d be happy to help.

    Best,
    Monica

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Slow query has taken all my sites down’ is closed to new replies.