Maximum number of InnoDB tables in schema

[Martin OShea]

Hello

I have a database schema which is growing by up to 600 tables a day because of work currently being done. Each of these 600 tables is composed of up to 400 columns and each one has a unique column 'signature' of different columns: there is also no referential integrity involved.

Each table has a permanent number of 1400 records at most, and in size is probably no more than a handful of Mbytes.

Is there a limit to the number of tables a schema can have at all?

Apologies for any double posting.

Thanks

Martin O'Shea.



Edited 1 time(s). Last edit at 08/07/2013 02:54AM by Martin OShea.