Look up one of the meanings of linux tcp kernel parameter kernel parameter tcp_max_syn_backlog
Preface
In order to run mysql database stably and efficiently, it is necessary to optimize the performance of the database from many levels, and the effect will be obvious. One of the important links involves the optimization of the operating system.
This article only talks about linux operating system, because linux is the most important platform for running mysql, which is the most representative. Other operating systems can refer to this idea.
Operating system optimization is very complex, involving different dimensions. For example, there is a kernel parameter ipv4.tcp_max_syn_backlog at the network tcp level. If the mysql has a large number of concurrent threads, you may want to optimize this parameter.
Contact information
Catalogue
Query tcp-related kernel parameters
Get the meaning of kernel parameter tcp_max_syn_backlog
Summary
Training courseware
Query tcp related kernel parameters [root@three57 ~] # sysctl-a | grep ipv4 | grep-I-- color tcpnet.ipv4.tcp_timestamps = 1net.ipv4.tcp_window_scaling = 1net.ipv4.tcp_sack = 1net.ipv4.tcp_retrans_collapse = 1net.ipv4.tcp_syn_retries = 5net.ipv4.tcp_synack_retries = 5net.ipv4.tcp_max_orphans = 131072net.ipv4.tcp_max_tw_buckets = 131072 slightly net.ipv4.tcp_max_ssthresh = 0net.ipv4.tcp _ thin_linear_timeouts = 0net.ipv4.tcp_thin_dupack = 0net.ipv4.tcp_min_tso_segs = 2 get the meaning of kernel parameter tcp_max_syn_backlog
1. Open the official manual of linux kernel
Https://www.kernel.org/doc/man-pages/
2, click 7.overviews.convertionss and conventions,and miscellaneous
3, click tcp
4. Check the kernel parameter tcp_max_syn_backlog
Summary
Training courseware
(for a fee of 20 yuan, the training courseware has been shared to Baidu Cloud disk for students to obtain.)
