Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

Lots of databases on one server

hprashihprashi EntrantCurrent User Role Beginner
I have around 1000 websites to be hosted, All websites are hosted on the same server(LAMP), each website has its own database (DB_1, DB_2,... DB_999,DB_1000)

Each database has around 50 tables, All the websites have less traffic...

1) Does hosting too many databases on the same mysql server slow it down?

2) Which is preferred? hosting 1000 databases with 50 tables each or hosting 1 database with 50,000 tables?


  • sterinsterin Mentor Inactive User Role Contributor
    No, generally a lot of DB does not affect performance.
    The total size of data, queries per second and if you have proper indexes are much more important.

    1000 DB 50 tables each.
    Due to OS and which file system you are using, having a lot of files in one directory is expensive.
    And if you have 50,000 MyISAM tables in one database that will physically mean that you have 150,000 files in one directory.
    If you have change to InnoDB that figure will drop to 50,000 which is still too high.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.