Kloxo MR 7 optimization

[R1nk0]

hello friends i have this server specification:
2 x Intel Xeon E5 2620V2 2 x (6 x 2.10 GHz),
128 GB REG ECC RAM MEMORY

 my server output:
A. Kloxo-MR: 7.0.0.b-2015070303
   - Web: hiawatha-9.13.0-f.6.mr.el6.x86_64
   - PHP: php54s-5.4.42-1.ius.el6 (cgi mode)
B. Plateform:
   - OS: CentOS release 6.6 (Final) x86_64
   - Hostname: m2706
C. Services:
   1. MySQL: MariaDB-server-10.0.20-1.el6.x86_64
   2. PHP:
      - Branch: php53u-cli-5.3.29-1.ius.el6.x86_64
      - Used: --Use PHP Branch--
   3. Httpd: httpd-2.2.29-2.mr.el6.x86_64
      - PHP Type: php-fpm_event
   4. Lighttpd: --uninstalled--
   5. Hiawatha: hiawatha-9.13.0-f.6.mr.el6.x86_64
   6. Nginx: nginx-1.9.2-1.el6.ngx.x86_64
   7. Cache: --uninstalled--
   8. Dns: nsd-4.1.3-1.mr.el6.x86_64
   9. Qmail: qmail-toaster-1.03-1.3.55.mr.el6.x86_64
      - with: courier-imap-toaster-4.1.2-1.3.18.mr.el6.x86_64
D. Memory:
                total       used       free     shared    buffers     cached
   Mem:        129013       2136     126877         33         80        416
   -/+ buffers/cache:       1639     127374
   Swap:         4095          0       4095
E. Disk Space:
   Filesystem      Size  Used Avail Use% Mounted on
   /dev/sda2       464G   47G  394G  11% /

what can i do to optimize it to work faster cause i have apps with a lot of users and when i woke up this morning i could not access any of mine admin panels in logs it was showing sql error so what i did searched this forum and i cleared cache with #sh /script/clearcache3 and i restarted everything and it came back to normal. So what can i do to prevent this to happen again since im not using anything to cache on my server and what can i do to optimize php and mysql to allow more calls and faster response.
it have 24 cores and 128gb memory it should be able to handle much more than this.

[MRatWork]

1. Change hostname with FQDN match (like m2706.yourdomain.com instead m2706)
2. Allocate higher 'fastcgi children' from 6 ('unlimited' is equal to '6') to 2-4 times (depend on how much clients and resource plan)
3. Optimize mysql with execute 'mysqltuner' (install with 'yum install mysqltuner' first). From mysqltuner recommended, modified /etc/my.cnf.d/server.cnf (because using mariadb)
4. Using different storage-engine for mysql/mariadb to innodb/aria with execute 'sh /script/mysql-convert --engine=aria'
5. Select 'medium' or 'high' for 'apache optimize' in 'webserver configure'
6. Install mod-pagespeed for apache and opcache and memcached for php
7. Use nginx-proxy/hiawatha proxy instead apache standalone in 'switch program'.

[R1nk0]

2. where do i edit this for cgi


3. Optimize mysql with execute 'mysqltuner' (install with 'yum install mysqltuner' first). From mysqltuner recommended, modified /etc/my.cnf.d/server.cnf (because using mariadb)

3. i cant locate /etc/my.cnf.d/server.cnf

5. Select 'medium' or 'high' for 'apache optimize' in 'webserver configure'
i did this but i dont use apache im using nginx-proxy
6. Install mod-pagespeed for apache and opcache and memcached for php
and for cache i have none there

[MRatWork]

3. Optimize mysql with execute 'mysqltuner' (install with 'yum install mysqltuner' first). From mysqltuner recommended, modified /etc/my.cnf.d/server.cnf (because using mariadb)

3. i cant locate /etc/my.cnf.d/server.cnf

5. Select 'medium' or 'high' for 'apache optimize' in 'webserver configure'
i did this but i dont use apache im using nginx-proxy
6. Install mod-pagespeed for apache and opcache and memcached for php
and for cache i have none there

3. Inform here 'dir -l  /etc/my.cnf.d'
5. Nginx-proxy mean nginx in front and apache in backend
6. Go to /opt/phpXYm/etc/php.d (change XY with 54-56) and copy opcache.nonini to opcache_used.ini and memcached.nonini to memcached_used.ini. Select 'phpXYm' for 'php used' in 'webserver configure'.

For mod-pagespeed, run 'yum install mod-pagespeed-stable --enablerepo=*page* -y' and then restart web with 'sh /script/restart-web -y'.

[R1nk0]

total 16
-rw-r--r-- 1 root root 295 Jun 17 16:54 client.cnf
-rw-r--r-- 1 root root 232 Jun 17 16:54 mysql-clients.cnf
-rw-r--r-- 1 root root 837 Jul  4 14:27 server.cnf
-rw-r--r-- 1 root root 285 Jul  3 18:39 tokudb.cnf

[MRatWork]

1. Modified server.cnf for mysqltuner optimize
2. Sometimes php-fpm not work perfectly, try 'pkill -9 php-fpm; sh /script/restart-web -y'.

[R1nk0]

sorry for dumb question but im noob and i dont know how to edit or access that file.

[MRatWork]

Learn about vi/vim or nano for editing file. Or use edit in filemanager in panel for the same purpose.