Skip to:
Content
Pages
Categories
Search
Top
Bottom

buddypress site is down or overloaded

  • Avatar of kriskl
    kriskl
    Participant

    @kriskl

    hello.

    we receiving a little bit more traffic this week and the site is either very slow (overloaded/ or goes down)

    we run buddypress 1.5 on the site  with w3 total cache

    the server admin restarts mysql / server to get it back to normal..

    However this query  is called often and take 8-10 secs to process (and server admin suggested it is the culprit)

    SELECT COUNT(DISTINCT u.ID) FROM wp_users u LEFT JOIN wp_usermeta um ON um.user_id = u.ID LEFT JOIN

    is there anyway to fix it? at least temporarily?

     

    thanks

    kris

Viewing 2 replies - 1 through 2 (of 2 total)
  • Avatar of Paul Gibbs
    Paul Gibbs
    Keymaster

    @djpaul

    This is an area we’ve drastically improved in the upcoming BuddyPress 1.7. I’m not sure there’s any easy solutions for now; figuring out if you can add indexes to more columns might help, but the real badness is in the structure of the SQL itself, and that’s what we’ve improved.

    Avatar of kriskl
    kriskl
    Participant

    @kriskl

    Thank you Paul for quick reply

    will keep my fingers crossed that BP 1.7 will be released soon

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

You must be logged in to reply to this topic.