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

  • Barry

    The ones the multi-db plugin treats as global are (cut and pasted from the multi-db plugin at the top of db.php):

    $global_tables = array (
    $table_prefix . 'blogs',
    $table_prefix . 'blog_versions',
    $table_prefix . 'registration_log',
    $table_prefix . 'signups',
    $table_prefix . 'site',
    $table_prefix . 'sitecategories',
    $table_prefix . 'sitemeta',
    $table_prefix . 'usermeta',
    $table_prefix . 'users',
    $table_prefix . 'bp_activity_sitewide',
    $table_prefix . 'bp_activity_user_activity',
    $table_prefix . 'bp_activity_user_activity_cached',
    $table_prefix . 'bp_friends',
    $table_prefix . 'bp_groups',
    $table_prefix . 'bp_groups_groupmeta',
    $table_prefix . 'bp_groups_members',
    $table_prefix . 'bp_groups_wire',
    $table_prefix . 'bp_messages_messages',
    $table_prefix . 'bp_messages_notices',
    $table_prefix . 'bp_messages_notices',
    $table_prefix . 'bp_messages_recipients',
    $table_prefix . 'bp_messages_threads',
    $table_prefix . 'bp_messages_threads',
    $table_prefix . 'bp_notifications',
    $table_prefix . 'bp_user_blogs',
    $table_prefix . 'bp_user_blogs_blogmeta',
    $table_prefix . 'bp_user_blogs_comments',
    $table_prefix . 'bp_user_blogs_posts',
    $table_prefix . 'bp_xprofile_data',
    $table_prefix . 'bp_xprofile_fields',
    $table_prefix . 'bp_xprofile_groups',
    $table_prefix . 'bp_xprofile_wire',
    $table_prefix . 'bp_activity',
    $table_prefix . 'bp_activity_meta'
    );

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.