Performance Optimizations
Checking swap size
Check amount of swap size. To do this run
root# free -m total used free shared buff/cache available Mem: 3950 686 147 75 3116 2921 Swap: 2047 0 2047
To set swap size to the amount of RAM in Cent OS 7.2 and higher run
curl https://keitarotds.com/install.sh -sSL | bash -s -- -t swap -r
Installing Redis
Redis installation manual. After the installation turn it on at the “Performance” page.
Tuning MySQL Configuration
Launch the MySQL load evaluator:
wget https://raw.github.com/major/MySQLTuner-perl/master/mysqltuner.pl perl mysqltuner.pl
Change the /etc/my.cnf file settings according to instructions.
Installing TokuDB to MySQL (MariaDB, Percona)
Plugin TokuDB compatible for MariaDB and Percona Server. Using TokuDB can save server storage and slightly improve speed of building reports.
Instruction for MariaDB https://mariadb.com/kb/en/mariadb/enabling-tokudb
Instruction for Percona Server https://www.percona.com/doc/percona-server/LATEST/index.html#tokudb
To convert tables to TokuDB, open “Maintenance > Status”, Press “Convert to TokuDB”. If you doesn't see that button it means TokuDB is not installed or disabled.
Enable Gzip-compression in Nginx
Locate config file /etc/nginx/nginx.conf
. Find sction http { }
. Add into that section the following:
# Compression gzip on; gzip_comp_level 6; gzip_min_length 4096; gzip_buffers 8 64k; gzip_types text/plain text/css text/javascript text/js text/xml application/json application/javascript application/x-javascript application/xml application/xml+rss gzip_proxied any; gzip_disable "msie"; # cache informations about FDs, frequently accessed files # can boost performance open_file_cache max=10000 inactive=30s; open_file_cache_valid 60s; open_file_cache_min_uses 2; open_file_cache_errors on;
Apache
We recommend replace Apache to NGinx with PHP-FPM if it is possible.