Announcement

Announcement Module
Collapse
No announcement yet.

max number of tables in db

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • max number of tables in db

    Is there a limit regarding the number of tables within a db for MyIsam and InnoDB?

    Best,
    DonJulio

  • #2
    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.

    Comment

    Working...
    X