Skip to:
Content
Pages
Categories
Search
Top
Bottom

Ever growing database tables – is this normal?

  • Avatar of Thebigk
    thebigk
    Participant

    @thebigk

    Alright, I’m a dumba$$ when it comes to databases. But I observed on my local install of WPMU+BUDDYPRESS (using XAMPP) that every time I see new tables being created under the wordpress database.

    For example, I see following tables being generated every time there is some user activity:

    wp_user_1_activity

    wp_user_1_activity_cached

    .

    .

    .

    and so on.

    Is this normal? My database is supposed to be 9,000 members (to start with) , so will this cause a problem in future?

Viewing 9 replies - 1 through 9 (of 9 total)
  • Avatar of Paul Gibbs
    Paul Gibbs
    Keymaster

    @djpaul

    Yarly.

    Avatar of Ben (oldskoo1)
    oldskoo1
    Participant

    @oldskoo1

    Yep, completely normal and its actually a good way to scale a site.

    You could then install one the few multiple db plugins like hyper DB so you can then buy another server and spread the load. OR you could just run it on the same server if you don\’t have the requirements for more processing power as if you split into chunks using hyperdb it does make it easier to manage.

    Think of it like this, 2 million rows in 1 DB or 200,000 rows spread over 10 db\’s.

    If you\’ve ever tried to manage a DB with 2million rows which is kinda modest in the grand scale, you will need a pretty decent server, but you could run 200k rows on a celeron with 1 gig of ram! :)

    Avatar of Andy Peatling
    Andy Peatling
    Keymaster

    @apeatling

    Actually – this is no longer the case for activity tables, they have been changed to global tables, as it is actually faster for selecting friends activity.

    However, generally for scaling across servers, multiple tables make it far easier.

    Avatar of Thebigk
    thebigk
    Participant

    @thebigk

    Cool :) . I have used vBulletin before. They use some different technique I guess. It runs pretty well too.

    Avatar of Thebigk
    thebigk
    Participant

    @thebigk

    Well, again – if the activity tables aren’t the same anymore (assuming from RC2 onwards) will it cause any problem when I upgrade to RC2 and then to V1?

    Avatar of Andy Peatling
    Andy Peatling
    Keymaster

    @apeatling

    No, there are auto upgrade routines to convert the tables.

    Avatar of m@rk
    m@rk
    Participant

    @mrk-1

    @apeatling So, is an overview of BuddyPress’ current default database tables available somewhere? Can’t find it neither in the codex nor elsewhere?

    About to delete my old wp_user_*_activity tables now, finally. Have other tables become outdated/ obsolete relics since initial BP releases?

    Thx in advance!

    Avatar of @mercime
    @mercime
    Keymaster

    @mercime

    @mrk-1 Current BuddyPress tables with xxx_bp_xxx can be seen at http://codex.buddypress.org/user/setting-up-a-new-installation/installing-group-and-sitewide-forums/#bbpress-forums-tables-in-database
    (xxx_bb_xxx tables are not included, those are for bbPress Group Forums)

    Avatar of m@rk
    m@rk
    Participant

    @mrk-1

    Thx a lot!

Viewing 9 replies - 1 through 9 (of 9 total)

You must be logged in to reply to this topic.