DigitalOcean Droplet Optimization
Моя версия настроек для виртуального хоста на котором я держу бложик WordPress
SWAP
Сперва делаем свап файл для памяти
sudo fallocate -l 1G /swapfile
sudo chmod 600 /swapfile
sudo mkswap /swapfile
sudo swapon /swapfile
echo ‘/swapfile none swap sw 0 0’ | sudo tee -a /etc/fstab
Вносим изменения в sysctl.conf
sudo nano /etc/sysctl.conf
Добавлям в конце
vm.swappiness=10
vm.vfs_cache_pressure = 50
MYSQL
Настройки для MYSQL, /etc/mysql/my.conf
[mysqld]
default-storage-engine=MyISAM
default-tmp-storage-engine=MyISAM
performance_schema = OFF
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K
innodb = OFF
query_cache_type = 1
query_cache_limit = 256K
query_cache_min_res_unit = 2k
query_cache_size = 64M
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[isamchk]
key_buffer = 8M
sort_buffer_size = 8M
[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M
[mysqlhotcopy]
interactive-timeout
Apache
Настройки Apache
/etc/apache2/apache2.conf
<IfModule mpm_prefork_module>
StartServers 1
MinSpareServers 1
MaxSpareServers 3
MaxClients 10
MaxRequestsPerChild 3000
</IfModule>
<IfModule mpm_worker_module>
StartServers 1
MinSpareThreads 1
MaxSpareThreads 3
ThreadLimit 25
ThreadsPerChild 5
MaxClients 25
MaxRequestsPerChild 200
</IfModule>
StartServers 1
MinSpareServers 1
MaxSpareServers 3
ServerLimit 24
MaxClients 50
MaxRequestsPerChild 3000