innodb_buffer_pool_size = 2048M
innodb_buffer_pool_instances = 32
innodb_log_file_size = 64M
innodb_log_buffer_size = 16M
innodb_fast_shutdown = 0
innodb_flush_log_at_trx_commit = 1
sync_binlog = 1
innodb_lock_wait_timeout = 50
innodb_max_dirty_pages_pct = 90
innodb_max_dirty_pages_pct_lwm = 10
innodb_read_io_threads = 4
innodb_write_io_threads = 4
innodb_thread_concurrency = 2
innodb_io_capacity = 2000
innodb_io_capacity_max = 4000

Необходимо сделать глобальную настройку:

set global sql_mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

net.core.wmem_max=12582912
net.core.rmem_max=12582912
net.ipv4.tcp_rmem= 10240 87380 12582912
net.ipv4.tcp_wmem= 10240 87380 12582912
net.ipv4.tcp_timestamps = 1
net.ipv4.tcp_sack = 1
net.ipv4.tcp_no_metrics_save = 1
net.ipv4.tcp_window_scaling = 0
net.core.netdev_max_backlog = 5000
vm.swappiness=10
vm.dirty_writeback_centisecs = 600

ethtool -K eth0 tso off gso off gro off

Решаем проблему "ping: socket: Operation not permitted":

Для команды ping нужен доступ к сырым сокетам, для чего устанавливаем соответствующую возможность на файл /usr/bin/ping

test@user:~
$ sudo chmod -s $(which ping)

test@user:~
$ ls -al $(which ping)
-rwxr-xr-x 1 root root 69368 мар 17 02:29 /usr/bin/ping

test@user:~
$ sudo getcap $(which ping)

test@user:~
$ sudo setcap cap_net_raw+ep $(which ping)

test@user:~
$ ping 8.8.8.8
PING 8.8.8.8 (8.8.8.8) 56(84) bytes of data.
64 bytes from 8.8.8.8: icmp_seq=1 ttl=106 time=5.4 ms
64 bytes from 8.8.8.8: icmp_seq=2 ttl=106 time=5.4 ms
64 bytes from 8.8.8.8: icmp_seq=3 ttl=106 time=5.4 ms
64 bytes from 8.8.8.8: icmp_seq=4 ttl=106 time=5.4 ms