Slow query problem

  • k0c1

    (@k0c1)


    8 years, 2 months ago

    Hallo,

    I have instal woocommerce + yoast seo , and my MySQL Databaze report Slow Query please fix, her is report from log:

    # Query_time: 4.848047 Lock_time: 0.000028 Rows_sent: 0 Rows_examined: 574724
    use hmlm95nx;
    SET timestamp=1454396620;
    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_%’;
    # Time: 160202 8:03:46

    https://wordpress.org/plugins/wordpress-seo/

Viewing 5 replies - 1 through 5 (of 5 total)
  • webaware

    (@webaware)

    8 years, 2 months ago

    FYI wp-seo: the underscore character is a one-character wildcard in SQL. You need to escape that sucker if you want to utilise an index on wp_options, otherwise you get a full table scan and can run into exactly this problem.

    LIKE '\_transient\_wpseo\_sitemap\_cache\_shop\_order\_%'

    etc.

    cheers,
    Ross

    tom

    (@klickchoice)

    8 years, 2 months ago

    so where i need to change this ? .Could you please advice ?. Need to write a new function or change the code in plugin ?

    Really thank you for your support 🙂

    webaware

    (@webaware)

    8 years, 2 months ago

    G’day tom,

    That’s something the Yoast SEO crew need to address in their code.

    cheers,
    Ross

    /cc @tacoverdo

    Plugin Support Taco Verdonschot

    (@tacoverdo)

    8 years, 2 months ago

    Please feel free to write a full bug report on GitHub.

    The better you’re able to describe the issue and all your findings, the bigger chances are that our development team is able to solve this.

    Thanks for your help!

    ronmisely

    (@ronmisely)

    8 years, 1 month ago

    But could you please check the given error , and the possibility or reason for this error ?

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Slow query problem’ is closed to new replies.

Tags