Performance Optimizations

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

Redis installation manual. After the installation turn it on at the “Performance” page.

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.

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.

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;

We recommend replace Apache to NGinx with PHP-FPM if it is possible.