Re: Maximum number of InnoDB tables in schema
In hindsight, perhaps the current architecture of the tables is questionable although it made sense at the time.
Each table stores a series of keywords and frequencies retrieved from RSS feeds, so a given table will have something like the following columns:
id, keyword_x_frequency, keyword_y_frequency, keyword_z_frequency..., keyword_n_frequency, date, rssfeedno
Presently, there are no performance constraints because the tables are largely unused once the frequencies are calculated. However, if reference to a table is needed, the table's name can be retrieved from a master index.
Therefore, archiving large numbers of them is quite possible.
My estimate is that at the end of the cycle, there will be about 12000 tables for each of the two schemas involved.
Edited 1 time(s). Last edit at 08/08/2013 06:11AM by Martin OShea.