Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
5  
Why 100k tables? Smells like a broken design. –  Mark Storey-Smith Nov 14 '13 at 16:21
4  
The answer is "You're doing it wrong". There is never ever ever going to be an occasion where a single database instance needs to hold 100k+ tables. You need to learn about "separation of concerns" and "single responsibility principle" and "normalization" and the like. This design is absolutely wrong for whatever purpose you think you're trying to accomplish. I don't care how perfect your business plan, or how epic your life saving device or scheme, 100k+ tables in one place is wrong. It's wrong. I know. I don't have to ask. –  jcolebrand Nov 14 '13 at 16:29
    
The answer is no you're not going to have 100k tables. That's one of the worst ideas I've ever heard. Just keeping track of it all would be nealy impossible. You either need to hit the books and learn about database design or hire someone who does know. –  Zane Nov 14 '13 at 16:33
1  
@jcolebrand, I just attended this talk a couple days ago: percona.com/live/london-2013/sessions/… –  Shlomi Noach Nov 14 '13 at 18:27
    
For the record @ShlomiNoach I'm quite certain they're doing it wrong as well. I don't excuse the fact that it works, or negate that experience. I'm just saying, they are doing it wrong. –  jcolebrand Nov 14 '13 at 18:55
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.