Shulou(Shulou.com)06/01 Report--

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.)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.