Not the answer you need?
Register and ask your own question!

max number of tables in db

DonJulioDonJulio EntrantCurrent User Role Participant
Is there a limit regarding the number of tables within a db for MyIsam and InnoDB?



  • xaprbxaprb Mentor Inactive User Role Leader
    No, it is limited by the operating system. Some filesystems don't deal well with a large number of tables. InnoDB uses a lot of memory if you have tens of thousands of tables. This is fixed in the Percona version of the server.
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.