Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.