Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We are planning migrate most of our authentication system from within our application to mysql. How many no. of user can mysql handle? I am talking about a couple of thousands at the moment and perhaps a lot more in the future. Am highly apprehensive about doing this, but couldn't find anything more than, if it isn't said , it is unlimited type of answers.

I am worried about the number of users mysql can manage.

I know about the max_connections variable and memory limit, which is a key factor for that.

share|improve this question
Please clarify if you need information about how many user connections a mySQL server may handle, or if there is a maximum number of users which mysql can manage? – pacey Jan 31 '11 at 14:51
@pacey: it is the max number of users mysql can manage. i am guessing, but is it really the same problem as managing max records in a table?? – Software Mechanic Feb 2 '11 at 4:33
up vote 1 down vote accepted

On a powerful server, you can expect performance about 10000 tps to read and 6000 tps to write(DB about 20Gb with 50 million rows). Also you can use memcached to cache and read-only replica and sharding.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.