Skip to:

Update with a lot of members, sql crash

  • 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 ?


Viewing 1 replies (of 1 total)

  • Paul Wong-Gibbs


    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)
  • The topic ‘Update with a lot of members, sql crash’ is closed to new replies.
Skip to toolbar