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 -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:


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

Instruction for Percona Server

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;


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