[buddypress-trac] [BuddyPress] #4045: Activity Feed queries fail with millions of rows

[buddypress-trac at lists.automattic.com]

#4045: Activity Feed queries fail with millions of rows
-----------------------------------+--------------------
 Reporter:  zacechola              |       Owner:
     Type:  defect (bug)           |      Status:  new
 Priority:  normal                 |   Milestone:  1.6
Component:  Activity               |     Version:  1.5.4
 Severity:  normal                 |  Resolution:
 Keywords:  2nd-opinion has-patch  |
-----------------------------------+--------------------

Comment (by mym6):

 I realized that I've left out our server config information, if its worth
 anything.

 We have a master/slave setup, both with 12 cores with HT, 32GB of ram with
 about 9GB dedicated to the innodb_buffer_pool.  Our activity table has
 actually ben converted to InnoDB though it would be possible to convert it
 back.  We saw this same issue (if not worse due to locking) when using
 MyISAM.

 I've been running the queries I provided for nearly a week and haven't had
 a single issue.

-- 
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/4045#comment:25>
BuddyPress <http://buddypress.org/>
BuddyPress