Hi Guys,
I have always wandered what you are using to optimize the throughtput between a Dedicated Webserver and a Dedicated Database server.
network layout: CrossOver Nic>NIC 1GBPS low latency obviously.
Sysctl tunning identical on both systems
fs.file-max = 383999
net.core.rmem_max=8388608
net.core.wmem_max=8388608
net.core.rmem_default=65536
net.core.wmem_default=65536
net.ipv4.tcp_rmem=8192 873800 8388608
net.ipv4.tcp_wmem=4096 655360 8388608
net.ipv4.tcp_mem=8388608 8388608 8388608
net.ipv4.tcp_max_tw_buckets=6000000
net.ipv4.tcp_max_syn_backlog=65536
net.ipv4.tcp_max_orphans=262144
net.core.somaxconn = 16384
net.core.netdev_max_backlog = 16384
net.ipv4.tcp_synack_retries = 2
net.ipv4.tcp_syn_retries = 2
net.ipv4.tcp_fin_timeout = 7
net.ipv4.tcp_slow_start_after_idle = 0
net.ipv4.ip_local_port_range = 1024 65000
net.ipv4.tcp_window_scaling = 1
net.ipv4.tcp_congestion_control = cubic
net.ipv4.tcp_tw_recycle=1
vm.min_free_kbytes=262144
Server 1 Ded MySQl 24 Cores 24GB ram SSD raid 10 ~518 TPS percona 5.5. 1.9 2.1 latency
Server 2 Ded WebServer 16 cores 24GB ram SSD Drive
Performance over the network is ~ 250 tps.
I lose about 50% tps going over the network. Latency wise it’s between 4.9-6ms
I was curious what i can do exactly to squeze more performance our of the networking connection.
I know upgrading to 5.6 will boost my performance but i’m limited right now to just 5.5
Bogdan
