Lots of DB queries

  • Resolved Christopher Mailänder

    (@ceem123)


    2 years, 8 months ago

    Hi there,

    Hope you are doing fine.

    We are experiencing a lot of DB queries in the morning that our slowing down or crashing our server. At least some of them contain “_wp_old_slug” in them and I just wanted to check, whether this might be related to this plugin and what we eventually could do about it. In addition it seems like something might be scanning all pages for information in the postmeta table. I do not see a scheduled scan in the planned cronjobs though.

    Database is MySQL8
    Products / total pages in our store > 20.000
    PHP 7.4

    Let me know, if you need further information from my side.

    Thank you in advance!

    Best regards,
    Christopher

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Suwash

    (@suascat_wp)

    2 years, 8 months ago

    @ceem123

    We’re sorry you’re having trouble with Database queries slowing down your website. I imagine this can be frustrating for you. We’d like to look a closer look.

    To figure out if it’s due to our Yoast SEO plugin, can you please temporarily deactivate the plugin and check the performance?

    Additionally, install the Query Monitor plugin and monitor if there are any such queries from our plugin registered to cause slow queries.

    Ensure that you’re running the current version v5.8 WordPress, and Yoast SEO v16.8 and that your server meets our plugin requirements.

    Having a little more information about the situation will help us evaluate and get the issue sorted faster.

    Thread Starter Christopher Mailänder

    (@ceem123)

    2 years, 8 months ago

    Hi Suwash,

    Thank you very much for the quick answer.

    The issue only occurs between 6 and 7 am, so I will deactivate it tomorrow morning and have a look.

    PHP version is 7.4
    WordPress: 5.8
    MySQL 8

    As multiple causes come to my mind at the moment, I will deactivate the other ones as well then. Nevertheless, I will keep you posted.

    Plugin Support Suwash

    (@suascat_wp)

    2 years, 8 months ago

    Great, thanks! We look forward to hearing from you.

    Thread Starter Christopher Mailänder

    (@ceem123)

    2 years, 8 months ago

    Hi @suascat_wp

    Thank you for the quick reply and checks. I am not certain yet, which plugin is causing this behaviour, but I am already able to say that it is not Yoast.

    Thanks again!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Lots of DB queries’ is closed to new replies.