What is the relationship between the database connection pool and the number of concurrent threads on the database server?

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

.
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1bdf640-3146f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1bdf640-3146f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?