Multisite Creating Too Many Database Tables

  • pschlenker

    (@pschlenker)


    11 years ago

    I am working for a client who is using WordPress Multisite. As you know, each time a site is created in Multisite, WordPress creates several tables in the database for the site. With the number of sites that have been created thus far, my client’s database now has over 5700 tables. The database has gotten so large that it is about to violate the terms of service set forth by my client’s web hosting company. The database has become so large that it can no longer be backed up.

    Has anyone else run into this problem using WordPress Multisite? Do you know of any way to resolve this issue? Any assistance you might provide would be greatly appreciated.

Viewing 4 replies - 1 through 4 (of 4 total)
  • jkhongusc

    (@jkhongusc)

    https://www.ads-software.com/extend/plugins/shardb/

    https://www.ads-software.com/extend/plugins/hyperdb/

    Havent run into the issue yet, but keeping my eye on the database. Those two plugins above will allow you to split WP table onto multiple databases.

    I am not sure what is “large” in terms of databases. We have about 2400 tables and almost 3GB of data. Still “small” but getting to the point that I am considering our future options.

    Thread Starter pschlenker

    (@pschlenker)

    Thanks for the information, jkhongusc. I was in the middle of researching HyperDB and SharDB when I received your response. Great minds must think alike. ??

    I’ll look into HyperDB and SharDB as a possible solution to our problem. I will need to find out if our shared hosting provider will allow us to shard our database, and if there are any costs associated with database sharding. I wouldn’t be surprised if there is. ??

    I’d be interested to hear from anyone who has experience using HyperDB or SharDB. Thanks in advance.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    3G is large.

    You may also want to look into changing some of the defaults in WP, like only saving 5 or 10 revisions, instead of all, and doing a force purge on the DB for all revisions, plus spam comments. Some users are bad at remembering to do the spam thing.

    Every new site creation will create a number of tables in the database.

    From the number 5700 it sounds as if you have almost 600 sites, is this correct?

    If so, this is normal. If not, you may have a plugin installed which is adding extra tables to each install (if you have them set as Must Use for example).

    The only real solution here is a new hosting provider that allows 1000s of data tables ??

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Multisite Creating Too Many Database Tables’ is closed to new replies.