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

[buddypress-trac at lists.automattic.com]

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