Slow query caused by too many TIME_WAIT in mysql-mysql tutorial

If your mysql has a large number of TIME_WAIT instances, the cause of this problem is generally that your program optimization is not in place or a large number of queries are unreasonable. we only need to simply deal with the problem.

If your mysql has a large number of TIME_WAIT instances, the cause of this problem is generally that your program optimization is not in place or a large number of queries are unreasonable. we only need to simply deal with the problem.

The optimization method is as follows:

The code is as follows:
Vim/etc/sysctl. conf

Add the following content:

The code is as follows:
Net. ipv4.tcp _ syncookies = 1 Net. ipv4.tcp _ tw_reuse = 1 Net. ipv4.tcp _ tw_recycle = 1 Net. ipv4.tcp _ fin_timeout = 30

Solved