Skip to:
Content
Pages
Categories
Search
Top
Bottom

Update with a lot of members, sql crash

  • Avatar of Tom_
    Tom_
    Participant

    @tom_

    I’am trying to upgrade my buddypress install from RC1to the 1.0.

    In dev, with a few test members and some test blogs, everything is running.

    In production, we have 2000 members..and same number of blogs.

    >it makes sql crash (on a very powerfull server)

    logs shows a lot of queries like SHOW TABLES LIKE “wp_user_xx_activity”

    Is it from the upgrade script ?

    I don’t know how to make it lighter / is it possible to desactivate the include call of component ‘activity’ in bp-loader.php ?

    Isn’t it dangerous if database schema change ?

    In general, where are localized bp versions upgrades fonctions ?

    thanks.

Viewing 1 replies (of 1 total)
  • It’s not inherently dangerous that the database schema’s changed, no. BP used to have lots of tables like user_xx_activity, now they are combined into one (to give an example). Probably because you have >2k members, that’s why it’s taken so long to run.

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.