The MU forums have moved to

Problems with upgrade scripts (7 posts)

  1. Farms2
    Posted 17 years ago #

    I can't tell you the stress and annoyance I've had from trying to upgrade large wpmu sites using the Site-Admin>Upgrade ap.

    The number of times it crashes the site, calls teh database to a creaking halt or just sits there is painful :(

    I've tried no end of configurations - from locking everyone out of the site while upgrading to twaking sql settings but no joy has been had.

    I reckon the the upgrade script is too full-on - it need to have a 'gentle' upgrade option or come with instructions on how you can run it on a site with over 10K blogs without killing everything.

    The same goes for the sk2 upgrade script - it's great but I'm spending the whole day watching for sites falling over.

    Any ideas?

  2. zeug
    Posted 17 years ago #

    Ouch, so if I ever approach 10 000 on a Mu install it's time to split the db? How did you get past this when upgrading Mu, especially the upgrade from wp-inst to rc1 and then 1.0?

  3. quenting
    Posted 17 years ago #

    I'm currently preparing the move to Mu1.1, from a nightly of march 2006 (!) that's been heavily modified. I have 80000 blogs to migrate so I'm a bit tense, to say the least.
    I'm having the DB migration script modified to be run via command line PHP (no way I wait for the migration results looking at a blank IE screen lol). I plan on upgrading users by chunks of a few thousands at a time, I'm verifying in the meantime that both the older and newer versions can run agains the new version of the global tables.
    How long in your experience has the upgrade script been running for, say, 1000 blogs ? The script doesn't seem to be doing that many things, so I'm wondering why it'd take so long ?

  4. Farms2
    Posted 17 years ago #

    Thankfully I upgraded to 1.0 with a larger site when things were still painful (it took a week on with just under 20K blogs) but it managed to happen.

    It's either a version of SQL problem or something in 1.1.1.

    Anything under 5K blogs seems to be OK though.

    My guess is that it's related to the new blog creation problems for larger sites - the more blogs there are the more work / issues there seem to be with the dbase.

    I haven't tried an upgrade with split database yet... but I reckon that you want to start considering that as soon as you get to 5K.

  5. bloggoing
    Posted 17 years ago #

    Farms and quenting,

    Once a solution has been found, would either of you consider consulting (paid of course) with me to upgrade my site? I'm extremely nervous about it and nowhere near as knowledgable when it comes to MU. I've customized the site quite a bit, but most of the changes have been made to the theme only (kiwi).

    The site is and it only has ~5700 users currently. It's running an OLD version from around February 06.

    As you can see, the site loads painfully slow and is pretty much unsuable unless I can upgrade and ensure the DB doesn't get hosed during the process.

    Any help you can provide would be appreciated.

  6. Farms2
    Posted 17 years ago #


    Here's a very easy solution to stop the upgrade script from immediately taking down your server.

    Get it to upgrade blogs one at a time, really slowly :)

    Seriously, in wpmu-upgrade-site.php (using 1.2.1) change line 24 to:

    $blogs = $wpdb->get_results( "SELECT * FROM $wpdb->blogs WHERE site_id = '$wpdb->siteid' AND spam = '0' AND deleted = '0' AND archived = '0' ORDER BY registered DESC LIMIT $n, 1", ARRAY_A );

    line 52 to:

    location.href="wpmu-upgrade-site.php?action=upgrade&n=<?php echo ($n + 1) ?>";

    and line 54 to:

    setTimeout( "nextpage()", 4000 );

    Yeh it'll take a while, but not having your server fall over repeatedly is worth it!

    Unless anyone's got a better idea?

    I'm always open to consulting :O) Although I'll fix you up with a real tech specialist for database splitting / upgrading etc.

    You can reach me at james (at) edublogs /dot/ org

    Cheers, james

  7. quenting
    Posted 17 years ago #

    just some feedback, i started my upgrade from my very modified nightly (03/2006) to a very modified MU1.1 last week end. To do it i have contracted some work to make the upgrade script a separate php script executable on the command line (no way anyone with more than a couple of hundred blogs should upgrade over HTTP). Since I have already my DB and code split into pieces I never had to migrate more than 5000 blogs at once which was convenient. In average, it took about 1 second per blog to migrate them (time to compare tables/alter-create). That should give you an idea of how long your upgrade will take.
    Overall things are going fine, quite a few problems but nothing really major so far.

About this Topic