New to the community? Start here

Dynamic of growing blog

Hi,

in our company are the blogs mushrooming up, we have already 66 blog (whitin 7 months). Some of them were alraedy deleted or deactivated, but most of them are still active.

Each blog has 26 own tables (wp_<blogid>_ …:wink:, in total 26 * 66 = 1716 tables. To our first anniversary we will have nearly 3000 tables.

Question: was WPMU designed for such dynamic:

a) creating 2 blogs in the week

b) deactivating / deleting 2-3 blogs in a months ?

Is there an useful limit for blog count ?

Thanks in advance,

Michel

Tue, 16 Feb 2010 14:35:28
  • drmike
    • DEV MAN’s Mascot

    Depends on your OS as well. Please remember that most if not all OS’es have an upper limit of how many files can be in a single directory. And then many hosting platforms (like CPanel) reduce that limit even more.

    For every one of those database tables, three files are created within the MySQL directory.

  • Aaron
    • Ex Staff

    Not sure what your question is. WPMU is currently running in installs with up to 10.2 million blogs.

    Of course when you move into bigger installs you have to do some major server tweaking for things to run smoothly as with any other large website. Examples are DB server clusters, webserver clusters/load balancing, CDN or file servers/proxys, nginx, multiple datacenters for failover, etc.

    You can get amazingly far though with a single server running nginx, a php opcode cache like APC or xcache, and a caching plugin like WP Super Cache.