https://blog.csdn.net/w059805.
it is said in this article that the size of the database connection pool on the client side of
has been reduced from 2048 to 96. The number of concurrent threads on MySQL server has been maintained at 9600
what I wonder is, why can the number of concurrent threads on the server be so high?
if one thread is connected at a time, the maximum number of threads is 2048
in actual business, the statistical value is the number of requests processed by the server per second, that is, tps
people's customary concurrency is the number of requests sent at the same time.
for example, how many people click to place an order for a product at the same time, this number is concurrency.
and how many order requests the server can handle per second is tps
, so I think his 9600 is actually tps,. Client connection pool 2048,
the maximum concurrency given to the server is 2048, unless multiple clients access
at the same time, but the real concurrency for the server is to execute at the same time, and how many cores cpu can handle at most
, so this concept only has different understandings for different objects, and there is no need to tangle