Performance Degradation and “mysql server has gone away” after 2.8 upgrade

  • Resolved salmanager

    (@salmanager)


    15 years, 9 months ago

    I recently upgraded from WordPress 2.7.1 to 2.8 thru the core update (as well as manually twice). After upgrade to 2.8 I noticed that it was taking 60s+ sometimes for wordpress to respond or pages to be displayed in my browser. This was happening on the admin pages as well as on the posts on the site. I noticed that once the page loaded after 60s+, then subsequent requests where completed in normal time (under 10s). This lead me to believe that I was seeing DB connection issues.

    I activated the WP Tuner plugin to identify which queries were causing the delays and noticed that init time was the issue and I was getting a lot of “mysql server has gone away” messages.

    It seems that the mysql connection is terminating prematurely in my case. Perhaps the changes made in the wp-db.php are conflicting with a plugin I am using. While I have disabled almost all my plugins, I am still seeing the issue. I will disable them all and see what happens.

    In the meantime, if anyone else is seeing “mysql server has gone away” on their wordpress 2.8 install please discuss here so that we can identify if we have common plugins or the culprit.

    If you are seeing “mysql server has gone away” on a wordpress install PRIOR to 2.8, you may read about a workaround here:

    https://robsnotebook.com/wordpress-mysql-gone-away

Viewing 2 replies - 1 through 2 (of 2 total)

  • If someone has a solution for this problem in 2.8 please share it. The https://robsnotebook.com/wordpress-mysql-gone-away provides only solution until 2.7.1 version. I’m really having problems since I upgrades to 2.8, any help will be great. Thanks.

    Thread Starter salmanager

    (@salmanager)

    Hi there, well the culprit for me was the wp-forecast plugin. In wordpress 2.8 the default transpot method changed from “curl” to “fsockopen” which was causing timeout for my mysql database because of the wp-forecast plugin. It was CURL in 2.7.1

    There are various solutions for this:
    – Do you have the wp-forecast plugin installed? Update the wp-forecast plugin to the latest version 2.4 which adds a menu item to select the transport type.
    – If you don’t want to update the plugin or don’t have it, you can download a patched version of the “http.php” file from the wp-forecast file from here: https://www.tuxlog.de/wordpress/2008/neue-version-von-wp-forecast-v10-beta/ This will need to go in the wp-includes folder. Make sure to save the original. The patched file will change the default transport method back to curl like it was in 2.7.1. See if that works for you.
    – If all else fails, backup your current installation and upgrade to 2.8.1 which takes the default transport BACK to CURL. If that isn’t whats causing your issue maybe there’s a fix in 2.8.1 for your issue. If the upgrade makes things worse, you can roll back.

    Hope that helps.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Performance Degradation and “mysql server has gone away” after 2.8 upgrade’ is closed to new replies.