MySQL storage engine belongs to or supports MVCC, supports concurrency and I/O multiplexing. It is thought that the client communicates with the mysql client in the form of a TCP connection. Under normal circumstances, the client will use the already established connection and will not create a new connection every time SQL is executed (from the perspective of resources and efficiency). If the instantaneous traffic is large, the client should create multiple connections to implement asynchronous non-blocking processing in this form. Each TCP connection will have a disconnect waiting time. If it has not been used by this time, it will be destroyed. , show full processlist actually sees these connections. These are the functions of the client mysql plug-in connection pool.
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
MySQL storage engine belongs to or supports MVCC, supports concurrency and I/O multiplexing. It is thought that the client communicates with the mysql client in the form of a TCP connection. Under normal circumstances, the client will use the already established connection and will not create a new connection every time SQL is executed (from the perspective of resources and efficiency). If the instantaneous traffic is large, the client should create multiple connections to implement asynchronous non-blocking processing in this form. Each TCP connection will have a disconnect waiting time. If it has not been used by this time, it will be destroyed. , show full processlist actually sees these connections. These are the functions of the client mysql plug-in connection pool.