global tables identification (which ones are global?)

Hello,

WPMU newbie here.

After building my WPMU/Buddypress site to 10,000 blogs and 10,000 users on a single database, my Web Host suggested (ahem) that it was time to do something about my Splog and CPU/SQL issues. (they shut down my site).

I’ve just spent 8 hours studying your site and forums, and concluded I need to first install your Multi-db and Anti-splog plugins.

I’ve read (almost) everything on your multi-db plugin, created 256 new databases, and am now editing the multi-db files….

There’s one thing so far I’m not sure about – re: Global tables.

I’ve identified a complete list of unique tables (out of 72,000 total tables), and am now not sure which ones are global tables. Should I just add them all? Your help would be appreciated.

Here is a comple list of my unique tables:

bb_forums

bb_meta

bb_posts

bb_term_relationships

bb_term_taxonomy

bb_terms

bb_topics

blog_versions

blogs

bp__categories

bp__linkmeta

bp__votes

bp__wire

bp_activity

bp_activity_meta

bp_friends

bp_groups

bp_groups_groupmeta

bp_groups_members

bp_groups_wire

bp_invite_anyone

bp_links

bp_messages_messages

bp_messages_notices

bp_messages_recipients

bp_notifications

bp_user_blogs

bp_user_blogs_blogmeta

bp_user_blogs_comments

bp_user_blogs_posts

bp_user_geo

bp_xprofile_data

bp_xprofile_fields

bp_xprofile_groups

bp_xprofile_wire

commentmeta

comments

dpa

dpa_categories

dpa_unlocked

links

options

options

postmeta

postmeta

posts

posts

registration_log

signups

site

sitecategories

sitemeta

term_relationships

term_relationships

term_taxonomy

term_taxonomy

terms

tppo

tppodata

tpposubtabs

tppotoptabs

usermeta

users

Thank you,

Derek

WebVenture.ca