# Help with Mysql with 100K+ Table

**URL:** <https://forums.percona.com/t/help-with-mysql-with-100k-table/3086>\
**Category:** Other MySQL® Questions\
**Created:** [November 14, 2013, 4:35am UTC](https://forums.percona.com/t/help-with-mysql-with-100k-table/3086 "2013-11-14T04:35:44Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![infdude666](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/infdude666/32/11425_2.png) [@infdude666](https://forums.percona.com/u/infdude666)\
**Post date:** [November 14, 2013, 4:35am UTC](https://forums.percona.com/t/help-with-mysql-with-100k-table/3086/1 "2013-11-14T04:35:44Z")

</div>

Hi im trying to develop a database design in which its gonna have 100K+ tables residing in it.  
My major concern here is will Mysql be able to hold that much amount of tables with no performance degrade.  
Also mysql has a limit of open\_file\_limit of 64K but i know it can be overcome with ulimit, but again what would be the effect on performance when i have huge open files.  
i dont want to have Error:24 in long run.  
Also whats other parameter should i tune or have to keep in mind.  
Did anyone try to have 100K+ tables in their environment with good performance???  
My Server will be running Percona 5.6.14 x64 on RAID10 with BBU and 30GB RAM.

Regards  
Rohan.