[buddypress-trac] [BuddyPress] #4251: Slow queries on Activity Stream during peak times on site.

[buddypress-trac at lists.automattic.com]

#4251: Slow queries on Activity Stream during peak times on site.
---------------------------+-----------------------------
 Reporter:  TheBeardedOne  |      Owner:
     Type:  defect (bug)   |     Status:  new
 Priority:  normal         |  Milestone:  Awaiting Review
Component:  Core           |    Version:  1.5.5
 Severity:  blocker        |   Keywords:
---------------------------+-----------------------------
 We have Buddypress 1.5.5 install on WP 3.3.1 that is going into a tail
 spin during peak times.  The load is all DB related, since we have a
 dedicated web/app server and DB server.  At the time of this report, the
 number of registered users for the site is between 18000-19000 (we've
 acquired these number of users in less than a month of being online).  I'm
 attaching a cleaned (removed identifiable info) mysqld.slow-query-log
 snippet.  The number of MySQL slow queries that will get logged are in the
 thousands, but are basically the same query.  The DB server is running
 Gentoo Linux, with MySQL 5.1.62-r1, and has 32 cores and 64GB of RAM.  Due
 to Buddypress not being compatible with HyperDB, I am unable to mitigate
 this problem by throwing more DB servers at it.

-- 
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/4251>
BuddyPress <http://buddypress.org/>
BuddyPress