After reading many of blogs and opinions, I still haven’t found what I am looking for.
This should be the scenario: 1.000.000 Users in an online community. Each user with his own mailbox. Each mailbox can store up to 10.000 of messages.
What to do? One Big Table for all messages or individual tables for each user? Put all tables in one database? MyIsam? Innodb?