mySQL Size Limitations and Performance

does anyone have any first-hand experience?

[mike73]

Does anyone know how large a mySQL database can be before you get bad performace? Can you have as many tables as you want? How many rows can a table have?

I have a DB that creates a new table for each user, and each user adds a new row of data to his table every day. Some users have been with me for years. So I'm wondering, will there ever be a point when I have too many tables, or the tables are so big that performace suffers. Should I be making serperate DBs for each year? Or is mySQL just totally bad ass and I don't have to worry about it?

[mack]

I have managed a Mysql DB in excess of 50 gig with no real drop off in peformance.

Mack.

[mike73]

That's very reassuring.

Thanks! :)