Welcome 微信登录

首页 / 数据库 / MySQL / mysql kernel: nf_conntrack version 0.5.0

今天要检查mysql数据库时messages日志中有大量mysql kernel: nf_conntrack version 0.5.0连接信息,现在将解决方法记录下来,希望能帮助需要的人,注:操作系统是CentOS 6.4,具体参数和操作系统的内核有关.日志信息:Oct 30 22:23:02 mysql kernel: ip_tables: (C) 2000-2006 Netfilter Core Team
Oct 30 22:23:02 mysql kernel: nf_conntrack version 0.5.0 (16384 buckets, 65536 max)
Oct 30 22:23:03 mysql kernel: ip_tables: (C) 2000-2006 Netfilter Core Team
Oct 30 22:23:03 mysql kernel: nf_conntrack version 0.5.0 (16384 buckets, 65536 max)
Oct 30 22:25:25 mysql kernel: nf_conntrack version 0.5.0 (16384 buckets, 65536 max)
Oct 30 22:45:43 mysql kernel: ip_tables: (C) 2000-2006 Netfilter Core Team
Oct 30 22:45:44 mysql kernel: ip_tables: (C) 2000-2006 Netfilter Core Team
Oct 30 22:45:44 mysql kernel: nf_conntrack version 0.5.0 (16384 buckets, 65536 max)
Oct 30 22:45:45 mysql kernel: ip_tables: (C) 2000-2006 Netfilter Core Team
Oct 30 22:45:45 mysql kernel: nf_conntrack version 0.5.0 (16384 buckets, 65536 max)
Oct 30 22:49:31 mysql kernel: ip_tables: (C) 2000-2006 Netfilter Core Team
Oct 30 22:49:31 mysql kernel: nf_conntrack version 0.5.0 (16384 buckets, 65536 max)
Oct 30 22:49:32 mysql kernel: ip_tables: (C) 2000-2006 Netfilter Core Team
Oct 30 22:49:32 mysql kernel: nf_conntrack version 0.5.0 (16384 buckets, 65536 max)
Oct 30 22:49:33 mysql kernel: ip_tables: (C) 2000-2006 Netfilter Core Team
Oct 30 22:49:33 mysql kernel: nf_conntrack version 0.5.0 (16384 buckets, 65536 max)解决方法:1.加载模块modprobe nf_conntrack_ipv42.修改内核参数vim /etc/sysctl.conf        --添加以下现行net.nf_conntrack_max = 655360net.netfilter.nf_conntrack_tcp_timeout_established = 108003.内核配置文件生效sysctl -p--------------------------------------分割线 --------------------------------------Ubuntu 14.04下安装MySQL http://www.linuxidc.com/Linux/2014-05/102366.htm《MySQL权威指南(原书第2版)》清晰中文扫描版 PDF http://www.linuxidc.com/Linux/2014-03/98821.htmUbuntu 14.04 LTS 安装 LNMP NginxPHP5 (PHP-FPM)MySQL http://www.linuxidc.com/Linux/2014-05/102351.htmUbuntu 14.04下搭建MySQL主从服务器 http://www.linuxidc.com/Linux/2014-05/101599.htmUbuntu 12.04 LTS 构建高可用分布式 MySQL 集群 http://www.linuxidc.com/Linux/2013-11/93019.htmUbuntu 12.04下源代码安装MySQL5.6以及Python-MySQLdb http://www.linuxidc.com/Linux/2013-08/89270.htmMySQL-5.5.38通用二进制安装 http://www.linuxidc.com/Linux/2014-07/104509.htm--------------------------------------分割线 --------------------------------------本文永久更新链接地址