database - Maximum concurrent connections to MySQL

Question

I want to set up a MySQL database for a social networking website for my college.

My app can have at most 10,000 users. What is the maximum number of concurrent MySQL connections possible?

Answer 1

As per the MySQL docs: http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_max_user_connections

 maximum range: 4,294,967,295  (e.g. 2**32 - 1)

You'd probably run out of memory, file handles, and network sockets, on your server long before you got anywhere close to that limit.