Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2024-07-15, 22:06:59

Author Topic: Kloxo MR 7 optimization  (Read 4781 times)

0 Members and 1 Guest are viewing this topic.

Offline R1nk0

  • Junior Member
  • *
  • Posts: 15
  • Karma: +0/-0
    • View Profile
Kloxo MR 7 optimization
« on: 2015-07-04, 14:51:06 »
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.

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Kloxo MR 7 optimization
« Reply #1 on: 2015-07-04, 15:00:10 »
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'.
« Last Edit: 2015-07-04, 15:03:36 by MRatWork »
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline R1nk0

  • Junior Member
  • *
  • Posts: 15
  • Karma: +0/-0
    • View Profile
Re: Kloxo MR 7 optimization
« Reply #2 on: 2015-07-04, 15:26:55 »
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
« Last Edit: 2015-07-04, 15:39:00 by R1nk0 »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Kloxo MR 7 optimization
« Reply #3 on: 2015-07-04, 15:39:22 »
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'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline R1nk0

  • Junior Member
  • *
  • Posts: 15
  • Karma: +0/-0
    • View Profile
Re: Kloxo MR 7 optimization
« Reply #4 on: 2015-07-04, 16:00:46 »
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


« Last Edit: 2015-07-04, 16:25:10 by R1nk0 »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Kloxo MR 7 optimization
« Reply #5 on: 2015-07-04, 16:24:35 »
1. Modified server.cnf for mysqltuner optimize
2. Sometimes php-fpm not work perfectly, try 'pkill -9 php-fpm; sh /script/restart-web -y'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline R1nk0

  • Junior Member
  • *
  • Posts: 15
  • Karma: +0/-0
    • View Profile
Re: Kloxo MR 7 optimization
« Reply #6 on: 2015-07-04, 17:04:56 »
sorry for dumb question but im noob and i dont know how to edit or access that file.

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Kloxo MR 7 optimization
« Reply #7 on: 2015-07-04, 17:07:48 »
Learn about vi/vim or nano for editing file. Or use edit in filemanager in panel for the same purpose.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

 


MRatWork Affiliates:    BIGRAF(R) Inc.    House of LMAR    EFARgrafix

Page created in 0.026 seconds with 22 queries.

web stats analysis