Tag: User IKE variables mil decides style queue res star
The following parameters are referred to other people's blogs, where the original address will be pasted.
Https://www.cnblogs.com/mydriverc/p/8296814.html
1,Back_log
Meaning explained:
If the number of MySQL connections exceeds max_connections , the new request is placed in a stack waiting for a connection to be released.
The length of the stack is determined by the value of the back_log . If the stack fills up, the new request will not be accepted and the client will get an error:
Unauthenticated user|xxx.xxx.xxx.xxx| null| Connect| null|login| Null
(1) View the current value of this parameter: (default = 50)
' Back_log ';
(2) Modify the value of this parameter: (must restart in effect)
[Mysqld]
Back_log = 500
(3) Restart effective
/etc/init.d/mysqld restart
Note :
The value of the Back_log cannot exceed the TCP/IP listener Queue size of the Linux system, and if exceeded, the set back_log is not valid.
To view the TCP/IP listener Queue size for the current system:
Cat/proc/sys/net/ipv4/tcp_max_syn_backlog
To modify the TCP/IP listener Queue size for the system:
Cat/etc/sysctl.conf
Net.ipv4.tcp_max_syn_backlog = 2048
MySQL parameter explanation