Hi, just a short one:
1) How many Databases can MySQL hold - without loosing the performance,
and/or
2) how many tables can one DB hold, again without loosing the performance.
3) I intend to build large scale site, >10,000 users with high personalisation and customisation to each one - so lots of data about each member there will be. I intended to use one-user set-of-tables or one DB per user - is this wise ?!?!?
Thanks ahead !
Max number of databases or tables in MySQL
Moderator: General Moderators
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
If you design your database carefully 10000 users *shouldnt* be a big deal for MySQL.
Also, I would not have a separate database for each user.... that sounds incredibly unmanageable... you just need to spend plenty of time working out the perfect entity relationships and making sure the database meets at the very least 3NF...
Short answer... 10000 users... go for it
Also, I would not have a separate database for each user.... that sounds incredibly unmanageable... you just need to spend plenty of time working out the perfect entity relationships and making sure the database meets at the very least 3NF...
Short answer... 10000 users... go for it
Re: Max number of databases or tables in MySQL
The answer to both is the same: It depends on what you mean by performance, and what hardware you throw at it.Calimero wrote:Hi, just a short one:
1) How many Databases can MySQL hold - without loosing the performance,
and/or
2) how many tables can one DB hold, again without loosing the performance.
Slashdot ( http://www.slashdot.org ), runs on mysql and has *far* more users than that. Of course, they also have several extremely well run machines running each of the http and db systems. They also don't run other services, have a huge bandwidth allotment, and more.Calimero wrote: 3) I intend to build large scale site, >10,000 users with high personalisation and customisation to each one - so lots of data about each member there will be. I intended to use one-user set-of-tables or one DB per user - is this wise ?!?!?
Point is, mysql can scale just fine, it just depends on how much you want to do, how much performance you want, and what hardware you will throw at it.
If you want to know more, I highly suggest "High performance mysql". Its written by Jeremy Zawodny, who know works for Yahoo, and still blogs about mysql every so often.
http://www.amazon.com/exec/obidos/tg/de ... 6?v=glance
-
magicrobotmonkey
- Forum Regular
- Posts: 888
- Joined: Sun Mar 21, 2004 1:09 pm
- Location: Cambridge, MA