Multisite database query

  • Resolved Shailesh

    (@shaileshsavaliya)


    12 years, 8 months ago

    I want that user can create their own blog from my site.
    So i have use wordpress mu, but in wordpress mu when user create site, 9 new tables automatically added to database.
    So if so many user create their own blog than database will so increased.

    So it creates any problem or not????

    If database have so many tables, it creates any load problem or other database crash problem??

    I dont know if table increased than its harmful for sites or not.
    Please give me information for this.
    Your help would be greatly appreciated.

Viewing 6 replies - 1 through 6 (of 6 total)

  • I’m not a professional at this but I believe that WPMU can handle a lot of tables. Some blogs reach a thousand blogs. The database can still handle it. An example is wordpress.com – composed of thousands of blogs.

    But going back to your question – there will come a time when you would have to adjust the hosting to more significant traffic.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    I dont know if table increased than its harmful for sites or not.

    Not. Yes, eventually you’ll need a bigger server, and a better DB, but WordPress.com is running Multisite. It’s okay ??

    (ianjayb, it’s Multisite now, not WPMU ?? )

    Thread Starter Shailesh

    (@shaileshsavaliya)

    ianjayb and Ipstenu

    Thanks you so much for response…

    Thread Starter Shailesh

    (@shaileshsavaliya)

    Not. Yes, eventually you’ll need a bigger server, and a better DB, but WordPress.com is running Multisite. It’s okay ??

    Here, what you mean by better DB. Please help me.

    I am using mysql database..
    Is there any number of tables limit per database?

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Don’t bump, please, even after 2 days.

    There’s a limit on tables per DB, but you have to work hard to get there. But you know, you could look up things like ‘Maximum DB size’ yourself ??

    https://mysqldump.azundris.com/archives/98-How-large-can-a-MySQL-database-become.html

    Thread Starter Shailesh

    (@shaileshsavaliya)

    Sorry for bump…
    Thanks for help Ipstenu…

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Multisite database query’ is closed to new replies.