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
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
http://wiki.mysqltuner.com/MySQLTuner
If all else fails, you may just need to feed that lil puppy some more RAM.
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.
Clean up some blogs in the backend.
Consider splitting the database to use more than one.
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.