MySQL Database Size?

Linc

Your hosts must have the strictest storage limits in the industry.

Gillingham

Regardless of storage limits, having 1.7G out of 2G in my database storing activities, of which 90%+ will never be looked at is fairly absurd so cutting down on the size makes sense just to speed up all the activity queries outside of the activity pages I disabled.

Anonymoose

There are other solutions out there, like federated web setups that integrate with Facebook and any number of other social networks, that show the limits of such an approach: as you begin to follow and integrate activities on various networks, the amount of database churning begins to slow your site to a crawl until you get more resources.

Todd

We've done a bit more on activities to make them a bit more manageable:

1. Activities are only inserted if a user has a notification preference set up to receive them.
2. Most activities representing only an email notification get deleted when the email has been sent.

Since activities only get added when a user wants to be notified of them you should be abe to turn those activities off by setting the notification preferences to FALSE in your config. Take the following preferences from config-defaults.php.

$Configuration['Preferences']['Email']['ConversationMessage']   = '1';
$Configuration['Preferences']['Email']['BookmarkComment']       = '1';
$Configuration['Preferences']['Email']['WallComment']           = '0';
$Configuration['Preferences']['Email']['ActivityComment']       = '0';
$Configuration['Preferences']['Email']['DiscussionComment']     = '0';
$Configuration['Preferences']['Popup']['ConversationMessage']   = '1';
$Configuration['Preferences']['Popup']['BookmarkComment']       = '1';
$Configuration['Preferences']['Popup']['WallComment']           = '1';
$Configuration['Preferences']['Popup']['ActivityComment']       = '1';
$Configuration['Preferences']['Popup']['DiscussionComment']     = '1';
$Configuration['Preferences']['Email']['Mention']               = '0';
$Configuration['Preferences']['Popup']['Mention']               = '1'; 

A '0' means that the preference is off by default, but if you copy the preference into your config.php and instead make it FALSE then the preference is off for everyone. Maybe someone can give this a try on a 2.0.18 installation and report back?