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

buddypress-trac at lists.automattic.com buddypress-trac at lists.automattic.com
Thu Mar 22 19:25:55 UTC 2012

#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

 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

 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/>

More information about the buddypress-trac mailing list