4.9.8 Edit Page Slowed By Core WordPress Query

  • For the past several weeks my website has been slow to load and especially slow to create new posts or edit existing ones. I’m receiving 503 service unavailable errors and “Connection lost. Saving has been disabled until you’re reconnected. We’re backing up this post in your browser, just in case.” I’ve gone through the normal troubleshooting, changing my theme, disabling plugins, etc. and turned on debugging as well as installed Query Monitor. The problem appears to be a query for meta keys in the wp_postmeta table. It’s taking well over 30 seconds to run. The error Query Monitor is showing is:

    SELECT DISTINCT meta_key
    FROM wp_postmeta
    WHERE meta_key NOT BETWEEN ‘_’
    AND ‘_z’
    HAVING meta_key NOT LIKE ‘\\_%’
    ORDER BY meta_key
    LIMIT 30

    1. do_meta_boxes()
    wp-admin/includes/template.php:1073
    2. post_custom_meta_box()
    wp-admin/includes/meta-boxes.php:685
    3. meta_form()
    wp-admin/includes/template.php:630

    I’ve found similar problems on Google in previous versions of WordPress but none of those solutions seemed applicable. I’m really hoping someone here can help me.

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator t-p

    (@t-p)

    – The 503 service unavailable error occurs when your web server is unable to get a proper response from a PHP script. This PHP script could be a WordPress plugin, a theme, or a misbehaving custom code snippet.
    – If the error is caused by heavy usage, a server glitch, server temporarily offline for maintenance, the server too busy or concurrent request limit exceeded, or a DDoS attack, then it could automatically disappear in a few minutes.
    – However, if it is caused by bad code on your website, then it will keep occurring unless you find and disable the code that’s causing it.

    To troubleshoot, try:
    – Deactivate plugins, switch theme, reinstall WP
    – If these methods fail to resolve the error, then try contacting your hosting providert.
    – For more info see https://www.wpbeginner.com/wp-tutorials/how-to-fix-503-service-unavailable-error-in-wordpress/

    Thread Starter michaelcallaway

    (@michaelcallaway)

    I appreciate your response. All of what you mentioned has been done. All of my plugins were disabled and re-enabled one by one, my theme was changed to twenty seventeen, GoDaddy was contacted, etc. Plugins do not appear to be the issue. The errors still occurred with the twenty seventeen theme. The only issue GoDaddy found was intermittent I/O spikes when the intensive query spikes were occurring. I’ve bumped my hosting up several times over the past few years and have enough resources available that I shouldn’t be anywhere near topping off. WordPress has been reinstalled several times. My thought is the query running from WordPress is too broad and not restricted enough.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘4.9.8 Edit Page Slowed By Core WordPress Query’ is closed to new replies.