Problem Summary
From Redmine:
Root Cause Analysis
โดน Bots/DDoS และ ยังไม่มี WAF
1 Answers
Solution / Workaround
- ติดตั้ง ZRAM
sudo apt install zram-tools
sudo systemctl enable zramswap
sudo systemctl start zramswap
- ทำ Swap File
sudo fallocate -l 4G /swapfile
sudo chmod 600 /swapfile
sudo mkswap /swapfile
sudo swapon /swapfile
- MySQL tunning and Limit
# Limit memory
innodb_buffer_pool_size = 2G
# Limit huge query
max_statement_time = 60
# See also ...
sudo ln -sf /srv/punsarn/site/config-database/punsarn.cnf /etc/mysql/conf.d/
sudo systemctl restart mysql