WordPress.org

Ready to get started?Download WordPress

Forums

Maximum number of WordPress per database. (8 posts)

  1. danielck
    Member
    Posted 9 years ago #

    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!

  2. lawtai
    Member
    Posted 9 years ago #

    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.

  3. shadow
    Member
    Posted 9 years ago #

    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 :)

  4. danielck
    Member
    Posted 9 years ago #

    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?

  5. moshu
    Member
    Posted 9 years ago #

    When your host offers a lot of DBs with your hosting account :)

  6. Heatsink
    Member
    Posted 9 years ago #

    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.

  7. danielck
    Member
    Posted 9 years ago #

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

    :)

  8. danielck
    Member
    Posted 9 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.