I have a single table that stores the file information for all the users. Over a period of time, I see huge traffic of users on the website, and concerned about the size of the single table that would store all the file information. A user can have unlimited number of files, and thus eventually, the tabel would grow very huge and effect the performance.
I considered a manual partitioning. Users with ids from 1 to 50 will be allocated one table for file information. The other set of users from 51 to 100 will be allocated the other table for file information with same structure.
I am at a stage when the whole application is ready and any change would lead major impact on all the modules. And hence, do not want to follow this approach.
I have the server with the following configuration: “MYSQL Master - 2 x QUAD Core XEON E5410 - 300GB SAS - 2GB RAM”
Can somebody please guide me as to how I can start taking measures at this stage itself, so that we are prepared for the huge number of users well before?