Can someone suggest me an idea on this?

I am using Wordpress MU. And as per my requirement every user who register on main site will have a sub-site for them. And it is working correctly.

I noticed that whenever a new site is created it is creating few tables in the database as like wp_2_post, wp_2_postmeta and so on. Whenever a new site is created, it is creating about 9 new tables in my database.

If i have 1000 users in my site, then will it create about 9000 new tables in my database?

I will be having lot more users with my site.

So, can someone tell me is this right? Can i have this much of tables in my database? Or can i do anything else to avoid this? Is there any other way to avoid this.?

1 Answer 1


Yes, this is the correct behavior, and no, there is nothing you can do about it in a multi-site setup. But that's usually not a problem; disk space is cheap.

Maybe you could run a workaround with a single-site installation and rewrite rules to map subdomains to URLs like /author/post-name/. But that sounds like a collsion magnet; so I wouldn't recommend it.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.