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.

  • 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?? – Nandhini Anand Jeyahar Feb 2 '11 at 4:33

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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