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