# max number of tables in db

**URL:** <https://forums.percona.com/t/max-number-of-tables-in-db/1046>\
**Category:** Other MySQL® Questions\
**Created:** [December 28, 2008, 5:03am UTC](https://forums.percona.com/t/max-number-of-tables-in-db/1046 "2008-12-28T05:03:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![DonJulio](https://avatars.discourse-cdn.com/v4/letter/d/d26b3c/32.png) [@DonJulio](https://forums.percona.com/u/DonJulio)\
**Post date:** [December 28, 2008, 5:03am UTC](https://forums.percona.com/t/max-number-of-tables-in-db/1046/1 "2008-12-28T05:03:00Z")

</div>

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

Best,  
DonJulio

---

<div class="post-metadata">

**Author:** ![xaprb](https://avatars.discourse-cdn.com/v4/letter/x/49beb7/32.png) [@xaprb](https://forums.percona.com/u/xaprb)\
**Post date:** [December 25, 2009, 10:23am UTC](https://forums.percona.com/t/max-number-of-tables-in-db/1046/2 "2009-12-25T10:23:42Z")

</div>

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.