Not the answer you need?
Register and ask your own question!

Improve Network Throughtput between server and client.

maydaymayday EntrantCurrent User Role Beginner
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

Comments

  • maydaymayday Entrant Current User Role Beginner
    I was really hopeful someone would have something interesting to share! :)
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.