The MU forums have moved to WordPress.org

Database has 36,000 tables! crashing mysql HELP (5 posts)

  1. scottdonald
    Member
    Posted 14 years ago #

    hi, my WPMU database has 36,000 tables! when i go to view the database in phpmyadmin it crashes the database server. any help appreciated thanks
    Scott

  2. delayedinsanity
    Member
    Posted 14 years ago #

    http://wiki.mysqltuner.com/MySQLTuner

    If all else fails, you may just need to feed that lil puppy some more RAM.

  3. kgraeme
    Member
    Posted 14 years ago #

    Each blog on WPMU creates 8 tables. Some plugins can add additional tables.

    How many users do you have? Do you limit/control/purge blog registrations? 36000 tables is roughly 4,500 blogs, not counting any tables created by plugins.

  4. andrea_r
    Moderator
    Posted 14 years ago #

    Clean up some blogs in the backend.
    Consider splitting the database to use more than one.

  5. scottdonald
    Member
    Posted 14 years ago #

    hi thanks all for your help, the site has been offline a lot because of crashes. I'll try these suggestions to get it going. I currently have over 1000 users some with multiple blogs. I am running budypress which has probably added a lot of extra tables.

About this Topic

  • Started 14 years ago by scottdonald
  • Latest reply from scottdonald