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

User · Answer

I can assure you that raw speed ultimately lies in the non-standard use of Indexes for blazing speed using large tables

User · Answer

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

User · Answer

You might have 10 000 users total  but that s not the same as concurrent users  In this context  concurrent scripts being run   For example  if your visitor visits index php  and it makes a database query to get some user details  that request might live for 250ms  You can limit how long those MySQL connections live even further by opening and closing them only when you are querying  instead of leaving it open for the duration of the script   While it is hard to make any type of formula to predict how many connections would be open at a time  I d venture the following   You probably won t have more than 500 active users at any given time with a user base of 10 000 users  Of those 500 concurrent users  there will probably at most be 10-20 concurrent requests being made at a time   That means  you are really only establishing about 10-20 concurrent requests   As others mentioned  you have nothing to worry about in that department

[mysql] Maximum concurrent connections to MySQL

Examples related to mysql

Examples related to database