I'm running MySQL (5.0 but I don't think it matters for anything after 4.1) and I've seen advice about using the
innodb_file_per_table configuration option for InnoDB tables. This is usually done so you can better control how much disk space is used by InnoDB tables since that space isn't ever recovered even if that table is later dropped.
But every time I see that piece of advice is says to use it if you don't have a lot of tables (here's an example). So my question is, how many tables is too many?
I have an application that is running for lots of different clients (about 50, but likely to grow closer to 100) and each database has 135 tables in it. Is 13,500 tables too many?