sysctl -P 报"unknown key"错误解决办法和 mysql的配置也需要优化

 

 (2016-08-19 15:27:55)

转载▼

分类： 服务器性能

 

[root@oracle11gr2 Packages]# sysctl -p

net.ipv4.ip_forward = 0

net.ipv4.conf.default.rp_filter = 1

net.ipv4.conf.default.accept_source_route = 0

kernel.sysrq = 0

kernel.core_uses_pid = 1

net.ipv4.tcp_syncookies = 1

error: "net.bridge.bridge-nf-call-ip6tables" is an unknown key

error: "net.bridge.bridge-nf-call-iptables" is an unknown key

error: "net.bridge.bridge-nf-call-arptables" is an unknown key

kernel.msgmnb = 65536

kernel.msgmax = 65536

kernel.shmmax = 2576980377

kernel.shmall = 2097152

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

fs.file-max = 6815744

fs.aio-max-nr = 1048576

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 4194304

net.core.rmem_max = 4194304

net.core.wmem_default = 1048576

net.core.wmem_max = 1048576

解决办法：

注：此错误可以忽视，也可以使用下面命令解决。

[root@oracle11gr2 ]# modprobe bridge

[root@oracle11gr2 ]# lsmod |grep bridge

bridge                 48077  0

stp                     2067  1 bridge

llc                     5352  2 bridge,stp

[root@oracle11gr2 Packages]# sysctl -p

net.ipv4.ip_forward = 0

net.ipv4.conf.default.rp_filter = 1

net.ipv4.conf.default.accept_source_route = 0

kernel.sysrq = 0

kernel.core_uses_pid = 1

net.ipv4.tcp_syncookies = 1

net.bridge.bridge-nf-call-ip6tables = 0

net.bridge.bridge-nf-call-iptables = 0

net.bridge.bridge-nf-call-arptables = 0

kernel.msgmnb = 65536

kernel.msgmax = 65536

kernel.shmmax = 2576980377

kernel.shmall = 2097152

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

fs.file-max = 6815744

fs.aio-max-nr = 1048576

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 4194304

net.core.rmem_max = 4194304

net.core.wmem_default = 1048576

net.core.wmem_max = 1048576

 

==============================

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 65000

vm.hugetlb_shm_group = 501

net.ipv4.tcp_fin_timeout = 30

net.ipv4.tcp_tw_reuse = 1

net.ipv4.tcp_tw_recycle = 1

 

今天上班发现公司的一台云服务器突然连接数非常大，一查nginx的上限都到达了，全是time_wait，一查询发现均是因为timeout超时时间默认太长引起，导致这个就需要优化网络这块；

 

说的优化，除了代码以外mysql的配置也需要优化：

lower_case_table_names=1

max_allowed_packet = 32M  

back_log=500

wait_timeout = 1800

max_connections= 1000

max_connect_errors = 3000  

max_user_connections = 400

thread_concurrency=16 

key_buffer_size=1024M

innodb_buffer_pool_size=1024M

innodb_additional_mem_pool_size = 16M

innodb_log_buffer_size=16M

innodb_log_file_size = 128M

query_cache_size = 64M

read_buffer_size=4M

sort_buffer_size = 4M

read_rnd_buffer_size = 8M

tmp_table_size = 16M

thread_cache_size  = 64

 

#table_cache = 614