Hello
Could you please send more details about your project here ? do you have a db dump where I can see the existing tables ? Also, if you plan on using all these tables into an app (website or just backend app) maybe it would also be wise to have a look on the code itself, or at least on the queries that are sent to the mysql on this database, to see how they might be optimized ... Do you use MyISAM or InnoDb tables? Do you use foreign keys on your tables ?
Regards,
Dragos