3 ms·
> In short, what happens is that if you create a large number of tables, like 10000, the mysql daemon will crash at restart. Feels like this would be unlikely
by dave4420 2y ago
> In short, what happens is that if you create a large number of tables, like 10000, the mysql daemon will crash at restart.
Feels like this would be unlikely to get triggered in practice. What am I missing?
- christophilus 2y agoWhat I’ve read is that some multi-tenant apps run into this. I’m not sure if it’s 10k per database, or per server. The multi-tenant comments make it sound like a per server issue. I’ve worked on apps that create a database per tenant. (I’d advise against this, but it did have its advantages.) I could see 10k tables happening pretty easily in that kind of architecture.