Help regarding MYSQL table overload

Could table overload occur?

[Alina]

Hello

I am in the process of designing a private messaging feature for a new client. The client has a dedicated server but just ONE MYSQL table which holds ALL the users emails. The number of users are currently small. But they will be expanding to over 10,000+.

If this were the case, would there be problems with many users read/write accessing just one messaging table concurrently? Wouldn't it be better for me to split this large table into many user mailbox tables that each user is able to access separately?

If so, then how many tables can exist within one MYSQL database?

Any help/advice would be much appreciated.

Alina

[rocknbil]

10K should be fine. I have a customer with three sites, one has 400K emails and the other two 40K and 20K. The 400K one is a little slow when we try to traverse it all but it's still not so slow it's annoying (only in administration, at that.) Not sure on the max. tables in mysql, but there is a max connections in the mysql configuration.