Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How many connections (Max.) can be kept in a pool..?

How does connection pooling works? i want to know that if i set max. pool size = 20 so are only 20 users able to connect to the web app. at a same time and make a transaction ? What happens to the large websites like Amazon where thousands of users log in at same time throughout the world i.e what pool size do they keep? i am not getting the core concept. I know that a connection pool keeps open connections and users reuse the open connections but i want my first question to be answered.

like image 473
RachitSharma Avatar asked Aug 19 '13 10:08

RachitSharma


2 Answers

There is no such document where you can find the maximum size of the pool.Default value of max pool size is 100

Check out MSDN

like image 116
Rahul Tripathi Avatar answered Oct 05 '22 23:10

Rahul Tripathi


There can be maximum 32767 connections to the database at a time. That is, at a single point of time only 32767 users can make transactions to database via web app. Not even one more than that. A pool size is not mentioned anywhere only default is there(100). But SQL Server will only accept 32767 connections from user. Proof: Select @@MAX_CONNECTIONS . If misunderstood please correct me.

like image 42
3 revs, 2 users 75% Avatar answered Oct 06 '22 00:10

3 revs, 2 users 75%