Today to check the MySQL database when the messages log has a large number of MySQL Kernel:nf_conntrack version 0.5.0 connection information, now the solution is recorded, hoping to help the people who need, note: The operating system is CentOS 6.4, The specific parameters are related to the kernel of the operating system.
Log information:
Oct 22:23:02 mysql kernel:ip_tables: (C) 2000-2006 netfilter Core Team
OCT 22:23:02 mysql kernel:nf_conntrack version 0.5.0 (16384 buckets, 65536 max)
Oct 22:23:03 mysql kernel:ip_tables: (C) 2000-2006 netfilter Core Team
OCT 22:23:03 mysql kernel:nf_conntrack version 0.5.0 (16384 buckets, 65536 max)
OCT 22:25:25 mysql kernel:nf_conntrack version 0.5.0 (16384 buckets, 65536 max)
Oct 22:45:43 mysql kernel:ip_tables: (C) 2000-2006 netfilter Core Team
Oct 22:45:44 mysql kernel:ip_tables: (C) 2000-2006 netfilter Core Team
OCT 22:45:44 mysql kernel:nf_conntrack version 0.5.0 (16384 buckets, 65536 max)
Oct 22:45:45 mysql kernel:ip_tables: (C) 2000-2006 netfilter Core Team
OCT 22:45:45 mysql kernel:nf_conntrack version 0.5.0 (16384 buckets, 65536 max)
Oct 22:49:31 mysql kernel:ip_tables: (C) 2000-2006 netfilter Core Team
OCT 22:49:31 mysql kernel:nf_conntrack version 0.5.0 (16384 buckets, 65536 max)
Oct 22:49:32 mysql kernel:ip_tables: (C) 2000-2006 netfilter Core Team
OCT 22:49:32 mysql kernel:nf_conntrack version 0.5.0 (16384 buckets, 65536 max)
Oct 22:49:33 mysql kernel:ip_tables: (C) 2000-2006 netfilter Core Team
OCT 22:49:33 mysql kernel:nf_conntrack version 0.5.0 (16384 buckets, 65536 max)
Workaround:
1. Loading the module
Modprobe Nf_conntrack_ipv4
2. Modifying kernel parameters
Vim/etc/sysctl.conf--Add the following current
Net.nf_conntrack_max = 655360
net.netfilter.nf_conntrack_tcp_timeout_established = 10800
3. Kernel configuration file takes effect
Sysctl-p
This article is from the "Days Together" blog, please be sure to keep this source http://tongcheng.blog.51cto.com/6214144/1569905
MySQL kernel:nf_conntrack version 0.5.0