Hi All,
I would like to know how many DB(MYSQL) connections can made at a single time? I'm creating a website, which has to handle 10,000 + user at a single time.
can anyone help me?
Thanks
When developing a web site, you should not reserve one connection per user.
Such an application typically has a pool of connections available. The application shortly picks one of the connections in the pool to perform short database interactions, and returns it to the pool.
It depends a lot on what you mean by 10000 users. Registered users? Logged in users? Users making simultaneous requests?
Here is one possible way to calculate the required connection pool size: If you assume that each user will spend 5 minutes thinking before entering a request, and each request takes 1 second to process, then you have about 33 simultaneous users (5 min == 300 seconds, so if you had only 300 users you would have 1 request at a time; 10000 / 300 ~= 33). If only 1/2 of the requests require a database connection, then a pool of 16 connections should be sufficient.
On another topic, I recall reading somewhere that MySQL can handle around 500 connections. That depends on the amount of memory and processor speed (you won't get that on a netbook!). Given the above calculations, you could handle 100s of thousands of users.
On more thought - Java EE application servers have built-in database connection pools. Read the docs for your app server to see how to go about configuring such a pool.
0
I'm creating a website, which has to handle 10,000 + user at a single time.
