[buddypress-trac] [BuddyPress] #1052: Activity table DB engine

buddypress-trac at lists.automattic.com buddypress-trac at lists.automattic.com
Sun Sep 20 23:25:50 UTC 2009

#1052: Activity table DB engine
Reporter:  petronic  |       Owner:     
    Type:  defect    |      Status:  new
Priority:  minor     |   Milestone:     
Keywords:            |  
 What do you think about changing DB engine of activity table
 (wp_bp_activity_user_activity_cached) from MyISAM to InnoDB?

 I had few cases when I needed to clear data after some activity is deleted
 and found that this is almost impossible to do because activities can be
 deleted by various criteria and we don't always know deleted activities
 IDs. If activity table is InnoDB we could create triggers to clear data
 for us.

 Also, I guess there are more writes then reads from activity tables (maybe
 equal amount), so that can be another plus for InnoDB engine.

Ticket URL: <http://trac.buddypress.org/ticket/1052>
BuddyPress <http://buddypress.org/>

More information about the buddypress-trac mailing list