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

I don't know if you have any knowledge of previous articles like how to optimize the linux kernel in mysql. Today, I'm going to tell you a little bit about it. If you are interested, let's take a look at the body. I'm sure you'll get something after reading the methods of linux kernel optimization in mysql.

Linux kernel optimization, direct modification / etc/sysctl.conf

The execution of sysctl-p will take effect immediately

# maximum length of listener queue per port net.core.somaxconn = 6553mm increase system file descriptor limit fs.file-max = 6553mm when the network acceptance rate is greater than the kernel processing rate Number of packets allowed to be sent to the queue net.core.netdev_max_backlog = 6553packets # maximum number of packets not connected net.ipv4.tcp_max_syn_backlog = 6553packets control tcp link wait time speed up tcp link recycling net.ipv4.tcp_fin_timeout = 10net.ipv4.tcp_tw_reuse = 1net.ipv4.tcp_tw_recycle = determine the size of the tcp accept buffer It is better to set larger net.core.wmem_default = 8388608net.core.wmem_max = 16777216net.core.rmem_default = 8388608net.core.rmem_max = 167772optimization for tcp failed links to occupy system resources Speed up resource recovery efficiency net.ipv4.tcp_keepalive_time = 120 # link validity time net.ipv4.tcp_keepalive_intvl = 30 # tcp did not get the corresponding retransmission interval-net.ipv4.tcp_keepalive_probes = 3 # number of retransmissions-net.ipv4.tcp_timestamps = 0 # optimized tcp three-way handshake syn-acknet.ipv4.tcp_mem = 94500000 915000000 927000000 # tcp memory allocation Can be debugged according to local physical memory unit is Bytenet.ipv4.tcp_max_orphans = 3276800 # largest orphan socket Unit net.ipv4.tcp_sack = unnecessary tcp detection retransmission net.ipv4.ip_local_port_range = 1024 65535 # tcp concurrent connection optimization net.ipv4.tcp_fin_timeout = 6 kernel related parameters # size of innodb buffer pool in shared memory kernel.shmmax = 4294967285 # 4G size is generally physical memory-1bytekernel.hung_task_timeout_secs = 0kernel.core_pattern = / var/log/core.%t # core file save location and file name format

Vm.swappiness = 0 # linux use swap partition unless there is not enough memory

After reading this article on how to optimize the linux kernel in mysql, what do you think? If you want to know more about it, you can continue to follow our industry information section.

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.