Max number of databases or tables in MySQL

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
Calimero
Forum Contributor
Posts: 310
Joined: Thu Jan 22, 2004 6:54 pm
Location: Milky Way

Max number of databases or tables in MySQL

Post 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 !
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post 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 ;-)
Roja
Tutorials Group
Posts: 2692
Joined: Sun Jan 04, 2004 10:30 pm

Re: Max number of databases or tables in MySQL

Post 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
magicrobotmonkey
Forum Regular
Posts: 888
Joined: Sun Mar 21, 2004 1:09 pm
Location: Cambridge, MA

Post 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)
Post Reply