Page 1 of 1
Max number of databases or tables in MySQL
Posted: Fri Apr 22, 2005 2:11 am
by Calimero
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 !
Posted: Fri Apr 22, 2005 8:17 pm
by Chris Corbyn
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

Re: Max number of databases or tables in MySQL
Posted: Fri Apr 22, 2005 8:54 pm
by Roja
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.
The answer to both is the same: It depends on what you mean by performance, and what hardware you throw at it.
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 ?!?!?
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.
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
Posted: Sat Apr 23, 2005 12:29 pm
by magicrobotmonkey
my company probably has about a half-mil end users all on one mysql db (although we are throwing the load balancing switch this weekend to get a two boxes online)