mySql capacity?

Question

I need everyone's help if you could just spare a minute.
1) What's the max capacity of mySql to hold site users? In other words, what's the top number of users that can be registered and stored in database using mySql?

2)how easy is it to migrate from mySql to sql or oracle in the future if my user base expands?

3) any noticeable downside of mySql, for ex: data retrieval speed, or database stability and security?

Thanks so much for your time,

J

Answer 1

Around 4 billion. MySQL is typically meant to scale to 10-100 million rows, beyond that is generally considered a very large database. You'll probably run into file system or operating system constraints before you run into any MySQL limitations. Depends on hosting provider as well...



I wouldn't think the database is a problem if it expands....u just need either more bandwith or memory for your website or both. I have a few MySql databases and besides tweaking in the beginning I love the interface.

Answer 2

(1) The limit is imposed by the maximum size of file that can be created. Unless you are storing vast amounts of data about each user, then you're not going to reach it.



(2) Not difficult, providing that you stick to standard SQL and don't use anything specific to MySQL



(3) Not these days

Answer 3

1) limited by maximum file size, I've seen some mysql table files that are > 4gb in size.

2) export to CVS, build new table, import CVS

3) security is what you make of it...(ie..username access to the master mysql DB that controls access to the dfiferent table and such)..

Answer 4

The capacity is mostly based on disk space: However much disk space your server or host has, is how much SQL can fill up.