Maximum number of WordPress per database.

  • Does anyone knows what is the maximum number of WordPress a mysql database can support without slowing down the websites or crashing the database?

    Assuming that each site has about 50 pages (entries/post) and receives about 50 hits per day.

    I have intensions to convert some of my websites into WordPress as now WordPress supports pages.

    Thanks in advance!

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

  • I don’t think there really is a limit, it’s basically just how fast your server can handle it I would think. I’ve read that people start to see slow downs when their database reaches about 10MB in size.

    I recently had 4 wp installs, 2 phpbb and 3 other database programs all in one database and they all worked fine.

    One of the wp installs had over 700 posts and 1o00 comments too.

    Mind you, I felt like a passenger train crossing India….

    HTH ??

    Thread Starter danielck

    (@danielck)

    I see…

    That means, we do not actually need alot of database. Different application can actually share a single database.

    But in what situation do we use a seperate database?

    When your host offers a lot of DBs with your hosting account ??

    Laff..it’s all about economics.

    Ideally each application should have its own database. Then if something becomes corrupt, or breaks, or needs to be backed up, or restored, or moved to another host…etc its easier to deal with.

    But, like you, for my personal stuff I don’t worry about it. If it’s client’s data then you might want to invest in the extra DBs.

    Thread Starter danielck

    (@danielck)

    I see. Thanks for the replies. I will evaluate if I should pay more to increase my hosting plan’s DB or not.

    ??

    Thread Starter danielck

    (@danielck)

    Well, I just got back from work and receive a reply from my web host. Thought of sharing with everyone:


    There is no limit, the performance is not directly affected by the size, it is more likely to be affected by the programming/sql query/number of connection.

    Here is a guideline: Not to have more than 5000 records in a table and more than 1 sql query per every 3 second is safe.

    If you consider running serious web application, you need to host your website on a dedicated server.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Maximum number of WordPress per database.’ is closed to new replies.