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.