MySQL Forums
Forum List  »  InnoDB

Help with Mysql with 100K+ Table
Posted by: Rohan D
Date: November 14, 2013 04:34AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Help with Mysql with 100K+ Table
1278
November 14, 2013 04:34AM
856
November 15, 2013 05:09PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.